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 function of adding numbers in a spreadsheet (=sum)
Count: the function of totaling the number of cells in a selected range that contain a specific type of data (=count)
Max: the function of finding the largest or maximum number in a given list of values (=max)
Min: the function of finding the smallest or minimum number in a given list of values (=min)
Average: the function of finding the average value, or arithmetic mean, of values in a selected range of cells (=average)
Using a Formula to Add a Column
1. Put an addition formula in the B column below the last number of invitees. In our example that is cell B8. We will be using a formula to add all of the numbers from cell B3 to B7, or the total number of people we invited.
The formula should look like one of these:
=B3+B4+B5+B6+B7 or = SUM(B3:B7)
Notice B3 is the cell for the first number of invited guests, and B7 is the last cell with a number of invited guests. So we want to add all the numbers in the cells starting with B3 down to B7 (B3:B7.
After you enter the formula, click on Return or Enter, and the total will appear instead of the formula.
2. Put an addition formula in Column C below the last number of people attending. The process is the same as above. You may also experiment with using the FUNCTIONS button on the toolbar.
3. When you click off of the formula it should automatically add the numbers.
4. To view the formulas again go to VIEW in the menu and select ALL FORMULAS. This shows you all of the formulas on the sheet.
5. Take a screen shot of your spreadsheet with ALL FORMULAS showing. Ask your teacher if they want you to share it with them.
6. To hide all of the formulas, go back to VIEW in the menu and select ALL FORMULAS and it will again show numbers in the columns.
- Tutorials for Creating Simple Formulas for Google Spreadsheets
- Tutorials for Creating Complex Formulas for Google Spreadsheets
- Spreadsheet Help From Google
- Formula Help From Google
- Using Google Spreadsheets from About.com
- Using Formulas from About.com (Hint: Review all 6 steps)
- Tutorials for Creating Simple Formulas for Microsoft Excel
- Tutorials for Creating Complex Formulas for Microsoft Excel
Check off this Quest on the 21t4s roadmap
ISTE and Common Core Standards
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