• 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.

— Rule to remember

Key takeaways: column letter then row number, and cells in a range = columns x rows.

Check your understanding

  1. 1. What is the address of the cell where column F meets row 11?

    1. 11F
    2. K6
    3. 6K
    4. F11
    Show answer

    Answer: D. A cell address is the column letter followed by the row number: F11.

  2. 2. How many cells are in the range B4:F9?

    1. 30
    2. 20
    3. 24
    4. 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. 3. How many cells are in the range A5:A20?

    1. 16
    2. 15
    3. 20
    4. 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. 4. In a spreadsheet, columns are named by

    1. Numbers
    2. Letters
    3. Colours
    4. Sheet names
    Show answer

    Answer: B. Columns are named A, B, C and so on; rows are numbered 1, 2, 3.

  5. 5. Which statement is correct?

    1. A workbook can hold several worksheets
    2. A worksheet can hold several workbooks
    3. A range is always a single cell
    4. 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.

Next lesson → Formulas and basic functions

Privacy · Terms · Refunds · Delivery