• Foundation
  • About 12 min
  • 5 practice questions

Workbooks, worksheets, rows, columns and cells

Name the parts of a spreadsheet and read a cell address like C5 or a range like B2:B6.

If something looks wrong, please tell us.

A spreadsheet is the tool behind every budget, mark list and account book. Before you calculate anything, you must be able to find your way around the grid.

The grid

A spreadsheet is application software that arranges data in a grid of rows and columns and can calculate with it. Examples are Excel, Calc and Google Sheets. A file is a workbook; each page inside it is a worksheet (sheet).

  • Columns run top to bottom and are named by letters: A, B, C...
  • Rows run left to right and are named by numbers: 1, 2, 3...
  • A cell is where a row and column meet; its address is the column letter then row number, such as C5.
  • A range is a group of cells, written with a colon, such as B2:B6.
  • The active cell is the one currently selected; the formula bar shows its contents.

Kinds of data in a cell

Data types
TypeExampleNote
Text (label)RohitLeft-aligned by default
Number (value)250Right-aligned by default
Date04-10-2026Stored as a number internally
Formula=B2+B3Always starts with =

Worked examples

Example 1. What is the address of the cell in the 4th column and 7th row? The 4th column is D, so the address is D7.

Example 2. How many cells are in the range B2:B6? Rows 2, 3, 4, 5 and 6 make 5 cells.

Example 3. How many cells are in the range A1:C4? 3 columns x 4 rows = 12 cells.

Cell address = column letter + row number. A range uses a colon: B2:B6.

— Remember

Key takeaways

  • Workbook contains worksheets; sheets contain a grid of cells.
  • Columns are letters; rows are numbers.
  • A formula starts with =.

Check your understanding

  1. 1. What is the address of the cell in the 3rd column and the 8th row?

    1. 8C
    2. C8
    3. H3
    4. 3H
    Show answer

    Answer: B. The 3rd column is C and the address is written column letter first, then row number: C8. H3 would be the 8th column and 3rd row.

  2. 2. How many cells are in the range A2:D5?

    1. 16
    2. 9
    3. 20
    4. 12
    Show answer

    Answer: A. Columns A to D are 4 and rows 2 to 5 are 4, so 4 x 4 = 16 cells.

  3. 3. A spreadsheet file that contains one or more worksheets is called a

    1. Workbook
    2. Folder
    3. Slide
    4. Document
    Show answer

    Answer: A. The file is a workbook; each page inside it is a worksheet.

  4. 4. You type the number 250 into an empty cell. By default it is

    1. Left-aligned
    2. Centred
    3. Changed into text
    4. Right-aligned
    Show answer

    Answer: D. Numbers (values) are right-aligned by default; text labels are left-aligned.

  5. 5. What does the formula bar show?

    1. The names of all saved workbooks
    2. The width of every column
    3. The title of each chart
    4. The contents of the active cell
    Show answer

    Answer: D. The formula bar shows what is in the currently selected (active) cell, including a formula if it holds one.

Sign in to keep track of the lessons you finish.

Next lesson → Formulas and operators

Privacy · Terms · Refunds · Delivery