WorksheetsExcel Cell Ranges & References
Total questions: 10
Worksheet time: 5mins
Name
Class
Date
1.
What is the cell reference for the colour black?
a)
3C
b)
C3
c)
B3
d)
3B
2.
What is the cell reference for the colour yellow?
a)
B6
b)
C1
c)
6B
d)
1C
3.
What is the cell range for the colour green?
a)
A10
b)
A10 to D10
c)
10A : D10
d)
A10 : D10
4.
What is the cell range for the colour red?
a)
A1 to A2
b)
A1 : B1
c)
A1 : B2
d)
B2 : A1
5.
What is the cell range for the colour purple?
a)
A1 : D4
b)
A1 : A4
c)
A1 to A4
d)
A1 to D4
6.
What is the cell range for the colour blue?
a)
B6
b)
B8 to B6
c)
B6 : B8
d)
B8
7.
What is the cell range for the colour grey?
a)
D11
b)
D11 : A11
c)
11D to 11A
d)
A11 : D11
8.
D7 is the cell reference for the colour orange.
a)
True
b)
False
9.
This picture shows...
a)
Row C
b)
Column C
10.
This picture shows...
a)
Row 6
b)
Column 6
100 %
