Productivity Suite

Q3 Party Planner: Formula

13. Dig the Data



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! 
PDF Document (Link to PDF Directions)

Key Vocabulary:

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)

Vocabulary Matching Quiz!

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.

Q3Sum 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.

Additional Resources:

Google Spreadsheets

Microsoft Excel

  Check off this Quest on the 21t4s Roadmap  

  Ready for Quest 4 Charts