What is a spreadsheet, actually?

Open Excel or Google Sheets. You'll see a wall of empty boxes and probably feel nothing.

Here's the thing to hold on to: it's squared paper that can do arithmetic. That's it. Everything else is a feature built on that one idea.

The parts of the grid

• Cell — one box. The basic unit.
• Column — a vertical strip, labelled with letters: A, B, C…
• Row — a horizontal strip, labelled with numbers: 1, 2, 3…
• Cell reference — the cell's address: column letter then row number. B4 is column B, row 4.

Three things a cell can hold

Only three. This matters more than it sounds.

1. 1A number — 4500
2. 2Text — Rahul (also called a label)
3. 3A formula — =B2*C2 (always starts with =)

Your first sheet

Type this in exactly. Really do it — reading about spreadsheets doesn't work.

Now click cell D1 and type Total. Click D2 and type:

=B2*C2

Press Enter. You get 180.

You just wrote a formula. That * is the multiply sign — computers use * because × is too easily confused with the letter x.

The magic handle

Now the moment that makes people fall in love with spreadsheets.

Click D2 again. See the tiny square at the bottom-right corner of the cell border? That's the fill handle. Drag it down to D4.

Excel doesn't copy =B2*C2 literally. It's smart enough to write =B3*C3 and =B4*C4. It understood you meant "this row's price times this row's quantity".

That single behaviour is why a person with a spreadsheet can do in ten seconds what would take an hour with a calculator. Ten rows or ten thousand — same drag.

The four maths symbols

One habit to start today

Never type a number inside a formula if that number lives in a cell.

Bad: =180*0.18 Good: =D2*E1 (where E1 holds the tax rate)

Why? Because when the tax rate changes — and it will — you change one cell instead of hunting through 400 formulas. This one habit is the difference between a spreadsheet people trust and one they quietly rebuild.