Stages
Just playMission 1/6
Reach into another tab
- Forty canteen sales sit on one tab, and nothing reads them yet.
- Name the tab, add a second one, and pull a sale across.
Do thisMission 2/6
Fetch the grand total across
Do thisMission 3/6
One stall, gathered across tabs
Do thisMission 4/6
Anchor the ranges, fill down
Do thisMission 5/6
Every total follows the log
Do thisMission 6/6
Both ranges read the log
★★★
Run cleared.
🚀 Push it
- 🟢Add a row that gathers the Tea sales from the log.
- 🟡Change one price on the log and watch which totals move, and which stay still.
- 🔴Say why a copied number and a reference stop agreeing.
🌐 Make it for real
Open a blank spreadsheet in Google Sheets and build the sample workbook, every total read across tabs.
Twist: change one price on the log tab and watch the summary move by itself.
🧑🏫 Teacher Guideclick to open
⏱ 62618
✅ Watch for
- Totals worked out and typed onto the summary
- A range with no tab name, reading the summary itself
- Ranges left unanchored, so filled rows slide down the log