Q3 Party Planner: Formula
You have now created and formatted your basic spreadsheet. One of the really useful functions of a spreadsheet is its ability to do calculations. It can do much more than a calculator can do if you know how to create a formula. All formulas start with an equal sign. Let's calculate how many people will be coming to your party!
(Link to PDF Directions)
I Can Statement
- calculate numbers using a spreadsheet
- Sum: The sum is the function of adding numbers in a spreadsheet. (=sum)
- Count: The count is the function of totaling the number of cells in a selected range that contain a specific type of data. (=count)
- Max: Max is the function of finding the largest or maximum number in a given list of values. (=max)
- Min: Min is the function of finding the smallest or minimum number in a given list of values. (=min)
- Average: Average is the function of finding the average value, or arithmetic mean, of values in a selected range of cells. (=average)
Play the Vocabulary Game below to practice the Key Vocabulary.
You can change the Quiz mode to Match, Test, Learn, Flash Cards, Spell using the selection list at the bottom right of the activity that says "Choose a Study Mode".
STEPS for Using a Formula to Add a Column
Using the directions, complete the following:
Step 1 - Create an addition formula to add up the total invitees start with the = symbol, followed by SUM and an open parens (then drag down across the cells and a closed parens ) and hit enter. Your formula should look like =SUM(B3:B7) where the : indicates including all the cells between B3 and B7.
Step 2 - Create an addition formula to find total attending in the next column in a similar way. Note: after you enter the formula, click on Return or Enter, and the total will appear instead of the formula.
Step 3 - Make sure that your formulas work.
Step 4 - Google Sheets: Select the View menu and Show formulas. Then take a screenshot.
Microsoft Excel: Select the Formulas Menu and select Show Formulas.
Step 5 - Save your screenshot with one of the formulas showing.
Step 6 - Return to normal View to hide the formulas
Step 7 - Check with your teacher to see how they want you to submit or share this document.
- Creating Complex Formulas Google Sheets
- Creating Simple Formulas Google Sheets
- Google Sheets Tutorials from GCF LearnFree
Check off this Quest on the 21t4s roadmap
Competencies & Standards
MITECS Michigan Integrated Technology Competencies for Students, and
3. Knowledge Constructor
c. Curate information from digital resources using a variety of tools and methods to create collections of artifacts that demonstrate meaningful connections or conclusions
6. Creative Communicator
c. Communicate complex ideas clearly and effectively by creating or using a variety of digital objects such as visualizations, models or simulations