Q5 Case Cracking Formulas: Introduction

Detective Calculations

When you walk into class, you immediately notice something strange: a new clue glowing on the projector and another written right across a basketball you’re allowed to pick up and read. 

As Data Detectives, you know this clue is pointing you toward the next step in solving the mystery of the missing collectibles. In this Quest, you will learn how to use formulas, functions, and tools like Autosum to uncover patterns and hidden information in your data. Every correct calculation gets you closer to cracking the case.

learning objectives

I can:

• Write basic formulas to add, subtract, multiply, and divide numbers in a spreadsheet.
• Use simple functions like SUM, AVERAGE, MIN, and MAX to calculate data.
• Select the correct cells to include in a formula or function.
• Check and fix errors in my formulas.