- Practice
- About 12 min
- 5 practice questions
Cells, rows, columns and ranges
Read cell addresses and ranges correctly and count cells in a range, a favourite exam calculation.
If something looks wrong, please tell us.
A spreadsheet is a grid used to store, calculate and analyse data. Before any formula, you must read the grid correctly. Questions on addresses and ranges are quick marks.
The grid
- Columns run vertically and are named A, B, C and so on.
- Rows run horizontally and are numbered 1, 2, 3 and so on.
- A cell is where a row and a column meet. Its address is the column letter followed by the row number, such as C5.
- A range is a block of cells written with a colon, such as B2:D6.
- A worksheet is one sheet; a workbook is a file holding one or more worksheets.
Counting cells in a range
Number of columns = last column - first column + 1. Number of rows = last row - first row + 1. Cells in the range = columns x rows.
Worked examples
Example 1. How many cells are in B2:D6? Columns B to D are 3 (B, C, D). Rows 2 to 6 are 5. Cells = 3 x 5 = 15.
Example 2. How many cells are in A1:A10? One column and 10 rows, so 1 x 10 = 10 cells.
Cell address = column letter + row number. Cells in a range = columns x rows.
Key takeaways: column letter then row number, and cells in a range = columns x rows.
Check your understanding
-
1. What is the address of the cell where column F meets row 11?
- 11F
- K6
- 6K
- F11
Show answer
Answer: D. A cell address is the column letter followed by the row number: F11.
-
2. How many cells are in the range B4:F9?
- 30
- 20
- 24
- 36
Show answer
Answer: A. Columns B to F are 5 (B, C, D, E, F) and rows 4 to 9 are 9 - 4 + 1 = 6, so 5 x 6 = 30 cells.
-
3. How many cells are in the range A5:A20?
- 16
- 15
- 20
- 25
Show answer
Answer: A. One column and rows 5 to 20: 20 - 5 + 1 = 16 cells. Forgetting the +1 gives the trap answer 15.
-
4. In a spreadsheet, columns are named by
- Numbers
- Letters
- Colours
- Sheet names
Show answer
Answer: B. Columns are named A, B, C and so on; rows are numbered 1, 2, 3.
-
5. Which statement is correct?
- A workbook can hold several worksheets
- A worksheet can hold several workbooks
- A range is always a single cell
- A cell address is the row number followed by the column letter
Show answer
Answer: A. A workbook is the file and holds one or more worksheets. A range is a block of cells, and an address is column letter then row number.
Sign in to keep track of the lessons you finish.