- 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
| Type | Example | Note |
|---|---|---|
| Text (label) | Rohit | Left-aligned by default |
| Number (value) | 250 | Right-aligned by default |
| Date | 04-10-2026 | Stored as a number internally |
| Formula | =B2+B3 | Always 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.
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. What is the address of the cell in the 3rd column and the 8th row?
- 8C
- C8
- H3
- 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. How many cells are in the range A2:D5?
- 16
- 9
- 20
- 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. A spreadsheet file that contains one or more worksheets is called a
- Workbook
- Folder
- Slide
- Document
Show answer
Answer: A. The file is a workbook; each page inside it is a worksheet.
-
4. You type the number 250 into an empty cell. By default it is
- Left-aligned
- Centred
- Changed into text
- Right-aligned
Show answer
Answer: D. Numbers (values) are right-aligned by default; text labels are left-aligned.
-
5. What does the formula bar show?
- The names of all saved workbooks
- The width of every column
- The title of each chart
- 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.