Productivity Suite

Q3 Party Planner: Formula

13. Dig the Data

 

Introduction

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 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)

Vocabulary Matching Quiz!


I Can Statement

  • calculate numbers using a spreadsheet

Using a Formula to Add a Column

Using the directions above, complete the following:

Step 1 - Create an addition formula to find total invitees
Step 2 - Create an addition formula to find total attending
Step 3 - Make sure that your formulas work
Step 4 - View the formulas
Step 5 - Screen shot your work with formulas showing
Step 6 - Return to normal View
Step 7 - Check with your teacher to see how they want you to submit or share this document.

Note: after you enter the formula, click on Return or Enter, and the total will appear instead of the formula.

Q3Sum formula

 


Additional Resources:

Google Spreadsheets

Microsoft Excel


  Check off this Quest on the 21t4s roadmap  

  Ready for Quest 4 Charts