Stages
Just playMission 1/6
Two tests in one formula
- Every sale on the log names a stall and an item.
- Ask for one stall and one item in a single formula.
Do thisMission 2/6
Two tests, one count
Do thisMission 3/6
Only those rows, added up
Do thisMission 4/6
The mean of what is left
Do thisMission 5/6
Each test, its own column
Do thisMission 6/6
One week, the same rows
★★★
Run cleared.
🚀 Push it
- 🟢Add a line for South tea money the same way.
- 🟡Point one line at week three instead, and say what had to change.
- 🔴Explain why a block of rows only means one week when the log is sorted.
🌐 Make it for real
Open a blank spreadsheet in Google Sheets and build the sample workbook, each question in one formula.
Twist: point one more line at week three, and say which way the number moved.
🧑🏫 Teacher Guideclick to open
⏱ 53213
✅ Watch for
- Two one-test counts added together with a plus
- A second test aimed at the stall column again
- Week ranges that start on different rows