Real World Maths Busters
The Maths Behind Everyday Life
The story, the formula and a worked example — see exactly where this maths shows up in the world around you.
Technology 3 min read
Spreadsheets Are Just Grids of Equations
Every cell can reference any other — creating a web of live calculations.
A spreadsheet is a grid where each cell can contain a formula that references other cells. Change one input and every dependent value recalculates instantly.
Dependency Chains
If A1=10, B1=A1×2 (=20), and C1=A1+B1 (=30), changing A1 to 15 updates B1 to 30 and C1 to 45. The spreadsheet traces the dependency graph automatically.
Sales tax calculation chain
- 1
A1 = Price
100
- 2
B1 = Tax rate
0.08
- 3
C1 = A1 × B1
- 4
D1 = A1 + C1
Answer
Change A1 to 200 and D1 instantly becomes 216
The takeaway
Spreadsheets are live equation webs — change one cell and the whole sheet responds.