🎯 The Goal
I can use the SUM, AVERAGE, MAX, and MIN functions to analyze large groups of data quickly.
📖 The Walkthrough: The Spreadsheet Shortcuts
Imagine you have a list of 1,000 students. You wouldn’t want to type =A1+A2+A3... 1,000 times! Instead, we use Functions.
Every function has a name and a range (the start and end cells).
| Function | What it does… | Example |
| SUM | Adds everything together. | =SUM(B2:B10) |
| AVERAGE | Finds the “middle” or mean value. | =AVERAGE(B2:B10) |
| MAX | Finds the highest number in the list. | =MAX(B2:B10) |
| MIN | Finds the lowest number in the list. | =MIN(B2:B10) |
📥 The Starter File
Download the “House Points Leaderboard” below. It contains a list of students and the points they have earned for their houses this term.
✅ The Checklist: Your Task
Scroll to the bottom of the data table and find the Summary Box. Use your new skills to fill it in:
- Total Points: Use
=SUM(B2:B50)to find out how many points were earned in total. - Average Score: Use
=AVERAGE(B2:B50)to see the typical score per student. - Top Performer: Use
=MAX(B2:B50)to find the highest score achieved. - Lowest Score: Use
=MIN(B2:B50)to find the lowest score.
🏆 Level Up! (Extension)
- Specific House Totals: Can you use a SUM function to add up only the students in “Gryffindor”? (Hint: You will need to select a specific range of cells that aren’t all together).
- The “Count” Secret: Try using
=COUNT(B2:B50). What does the answer tell you about your data?
📤 Test Your Knowledge
Once you have completed the tasks click the button below to take the quiz for this skill.Remember to select Skill 4 in the first question !
🏁 Navigation
| ⇠ Previous: Skill 3 | Next Lesson: Skill 5 Creating Charts & Graphs ➔ |