Cell references like A1
Name:
Date:
Class:
A
Quick Questions
Shade in the A or B circle for each question.
1. Which cell reference names the cell in column B, row 3?
2. Which one is a correct cell reference?
3. Cell C5 is in which column?
4. Cell D2 is in which row?
5. You click a cell and the Name Box shows B4. What does this tell you?
B
Match the Pairs
Draw a line connecting each item on the left to its match on the right.
| Left column | Right column | |
|---|---|---|
| 1B3 | AThe row number is written before the column letter. It should be B3, with the letter first. | |
| 2A1:A5 | BThe cell in column B, row 3 | |
| 3The cell reference for the cell where column C meets row 7 | CName box: D4 | |
| 4The active cell is the selected cell, and its reference shows in the name box | DA range uses a colon, not a hyphen. It should be A1:A5. | |
| 53B | EC7 | |
| 6A1-A5 | FA range of cells from A1 down to A5 in column A |
C
Definitions
B3
D
Fill in the Blanks
Complete each line of code by filling in the missing parts.
1.
Column C, row 4 is cell __
2.
Cell B3 is in column B and row _
3.
Cells A1 to A5 are written A1_A5
4.
Active cell: B3, column letter: _
5.
Range A1:A5 starts at A1 and ends at __
E
Spot the Error
Shade in the letter of the line that contains an error.
Question 1
A
Column letters: A, B, C
B
Row numbers: A, B, C
C
Cell reference: B3
Question 2
A
Click column D, row 5
B
That cell is now active
C
The Name Box shows its address
D
Active cell reference: 5D
Question 3
A
Cell C4 is in column 4
B
Cell C4 is in row 4
C
Its reference is C4
Question 4
A
Range A1:A5 names a group
B
It starts at cell A1
C
It ends at cell B5
D
It has 5 cells in column A
Question 5
A
A1 holds 4
B
A2 holds 6
C
In B1 type =A+A2
D
B1 shows 10
Answer Key
Cell references like A1
Section A: Quick Questions
Q1
B — B3
Q2
A — A1
Q3
A — Column C
Q4
A — Row 2
Q5
B — B4 is the active cell
Section B: Match the Pairs
Q1
B3 → The cell in column B, row 3
Q2
A1:A5 → A range of cells from A1 down to A5 in column A
Q3
The cell reference for the cell where column C meets row 7 → C7
Q4
The active cell is the selected cell, and its reference shows in the name box → Name box: D4
Q5
3B → The row number is written before the column letter. It should be B3, with the letter first.
Q6
A1-A5 → A range uses a colon, not a hyphen. It should be A1:A5.
Section C: Definitions
Q1
B3 — A cell reference. It names one spreadsheet cell by its column letter (B) then its row number (3). A range like A1:A5 names a group of cells.Section D: Fill in the Blanks
Q1
Column C, row 4 is cell C4Q2
Cell B3 is in column B and row 3Q3
Cells A1 to A5 are written A1:A5Q4
Active cell: B3, column letter: BQ5
Range A1:A5 starts at A1 and ends at A5Section E: Spot the Error
Q1
B — Rows are labelled with numbers (1, 2, 3), not letters. Letters label the columns. The line should be: Row numbers: 1, 2, 3.
Q2
D — A cell reference gives the column letter first, then the row number. It should be D5, not 5D.
Q3
A — Columns are named with letters. The C in C4 is the column, and 4 is the row. The line should say column C.
Q4
C — The range A1:A5 ends at cell A5, which is in column A. B5 is in a different column, so it is not the end of this range.
Q5
C — A cell reference needs a column letter and a row number. A on its own is not a cell. It should be =A1+A2.