The Magic of Formulas
A spreadsheet looks like a boring grid. Its secret power: change one number and everything updates itself.
A spreadsheet looks like a boring grid. Its secret power: change one number and everything updates itself.
A spreadsheet is a grid. Columns get letters (A, B, C) and rows get numbers (1, 2, 3). Where a column and row cross is a cell, and its address is just the two put together. Click any cell to hear its name.
Addresses are what make formulas possible. Instead of saying "the number three cells up," you just say A1. Every formula is built from these little coordinates.
Type a formula into a cell, starting with =, and it shows the answer instead of the text. Here A3 holds =A1+A2. Change the two numbers and watch A3 work it out for you, instantly.
| A1 | |
| A2 | |
| A3 | 8 |
You never press an equals button or recalculate by hand. The moment an input changes, the formula reruns. A spreadsheet is really a page full of tiny always-on calculators.
This is the superpower. Formulas can use other formulas, so one change ripples through the whole sheet. Plan a pizza party below. Change the number of friends and watch the slices, pizzas, and total cost all recalculate at once.
This is why spreadsheets run the world. Scientists, shopkeepers, and NASA all ask "what if?" by changing one cell and letting thousands of formulas answer at once.
Adding cells one by one is slow. Functions do it in a word. =SUM(A1:A5) adds a whole column; =AVERAGE(A1:A5) finds the mean. Edit these test scores and watch the total and average keep up.
| SUM | 0 | =SUM(A1:A5) |
| AVG | 0 | =AVERAGE(A1:A5) |
Modern spreadsheets have over 400 built-in functions, for money, dates, text, even random numbers. The first spreadsheet, VisiCalc in 1979, was so useful people bought whole computers just to run it.
You learned the secret every spreadsheet hides: cells point at other cells, so one change ripples through everything automatically. That single idea runs budgets, science labs, and businesses all over the world. Now go build one.
Columns are letters, rows are numbers. The cell where column B meets row 2 is called B2. Addresses let formulas point at cells.
Type =A1+A2 and the cell shows the answer, not the text. It is a tiny instruction the spreadsheet runs for you.
Because formulas point at cells, editing one number makes every formula that depends on it recalculate instantly. That is the what-if superpower.
Instead of =A1+A2+A3+A4, write =SUM(A1:A4). Functions like SUM and AVERAGE crunch whole ranges in one word.
Put your new knowledge into practice!