Cells, rows, columns and ranges
Every cell in a spreadsheet has a name, such as B3. Learn how cells and ranges are named in Excel and Google Sheets.
In this room: 2 tasks, 8 questions
- Finding a cell4 questions
- Naming a range4 questions
A spreadsheet is a grid of boxes, and each box is a cell. Columns have letters across the top, and rows have numbers down the side.
A cell is named by its column letter, then its row number. B3 is the cell in column B, on row 3.
| A | B | C | |
|---|---|---|---|
| 1 | Item | Boxes | Price |
| 2 | Copier paper | 12 | 4.50 |
| 3 | Envelopes | 8 | 3.20 |
| 4 | Ring binders | 5 | 2.75 |
| 5 | Marker pens | 20 | 1.10 |
Answer the questions below
3 more questions follow in this task.
A range is a block of cells that sit together. It is written as its first cell, a colon, then its last cell.
- B2:B5
- part of a column: B2, B3, B4 and B5
- A3:C3
- part of a row: A3, B3 and C3
- A2:C5
- a block: every cell from A2 across and down to C5
| A | B | C | |
|---|---|---|---|
| 1 | Item | Boxes | Price |
| 2 | Copier paper | 12 | 4.50 |
| 3 | Envelopes | 8 | 3.20 |
| 4 | Ring binders | 5 | 2.75 |
| 5 | Marker pens | 20 | 1.10 |
Answer the questions below
3 more questions follow in this task.