Stages
Just playMission 1/6
Give a range a word
- Forty canteen sales sit on one tab.
- Give the Total column a name, then add it up by that name.
Do thisMission 2/6
Name the totals column
Do thisMission 3/6
Name the how-many column
Do thisMission 4/6
Ask the name how many
Do thisMission 5/6
Reach the last row
Do thisMission 6/6
Name what, not where
★★★
Run cleared.
🚀 Push it
- 🟢Give the price column a word and take its mean.
- 🟡Point one summary line at a name that covers week one only, and say what breaks.
- 🔴Explain why a name that says where goes stale when the log grows.
🌐 Make it for real
Open a blank spreadsheet in Google Sheets and build the sample summary, with both ranges named.
Twist: add three more sales and check whether your names still cover them.
🧑🏫 Teacher Guideclick to open
⏱ 53015
✅ Watch for
- A name that stops a few rows short of the last sale
- Formulas still spelling out addresses after the name exists
- A name laid on the price column instead of quantities