Cells, rows and columns
Step 1 of 6
A spreadsheet is a grid of cells. Columns are named with letters and rows with numbers, so every cell has an address: its column letter, then its row number.
The shaded cell is B3: column B, row 3.
Click Continue when you're ready.
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Month | Sales | ||||
| 2 | January | 120 | ||||
| 3 | February | 95 | ||||
| 4 | March | 140 | ||||
| 5 | ||||||
| 6 | ||||||
| 7 | ||||||
| 8 |
Need help?
Why this works
Every cell has an address made of its column letter and row number, like B3. Formulas use these addresses to point at data, so reading them quickly is the first skill to learn.
Common mistake: Reading the address the wrong way round. It's always the column letter first, then the row number, so B3 not 3B.
The answer
- D1
Total
It's the column letter followed by the row number. B3 is the cell in column B, row 3.
- Jump to the last filled cell in a columnCtrl+Down
- Go to cell A1Ctrl+Home
- Confirm and move downEnter
- Confirm and move rightTab
+5 points