Stages
Just playMission 1/6
Fold forty sales at once
- Forty canteen sales sit on one tab.
- Total one stall with a formula, then let a pivot table fold every stall.
Do thisMission 2/6
Group the rows by stall
Do thisMission 3/6
Count the sales instead
Do thisMission 4/6
The size of a typical sale
Do thisMission 5/6
Fold the same log by item
Do thisMission 6/6
A fixed sale reaches the fold
★★★
Run cleared.
🚀 Push it
- 🟢Fold the log by date and say what each line tells you.
- 🟡Switch one fold to count, then say which question it answers now.
- 🔴Explain why a pivot never misses a stall nobody knew about.
🌐 Make it for real
Open a blank spreadsheet in Google Sheets and build the sample log with its pivot, folded by item.
Twist: fold it by stall as well, and say which stall takes the most money.
🧑🏫 Teacher Guideclick to open
⏱ 63014
✅ Watch for
- Totals worked out with formulas and typed into a table
- Counting sales when the question asks how much money
- Rows grouped by food when the question asks by stall