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

Competencies & Standards

MITECS   Michigan Integrated Technology Competencies for Students, and

ISTE Standards for Students

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