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)
- 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)
I Can Statement
- calculate numbers using a spreadsheet
STEPS for Using a Formula to Add a Column
Using the directions above, 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.
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: Put your mouse in one of the Totaled cells and view the formulas in the fx space directly above the sheet and take a screenshot of that.
Step 5 - Save your screen shot with one of the formulas showing
Step 6 - Google Sheets: Return to normal View. Excel needs no change.
Step 7 - Check with your teacher to see how they want you to submit or share this document.
- Tutorials for Creating Simple Formulas for Google Spreadsheets
- Tutorials for Creating Complex Formulas for Google Spreadsheets
- Formulas and Functions Help From Google
- Tutorials for Creating Simple Formulas for Microsoft Excel
- Tutorials for Creating Complex Formulas for Microsoft Excel
Check off this Quest on the 21t4s roadmap
Websites and Applications
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