Excel Cell Ranges & References

What is the cell reference for the colour black?

• 3C

• C3

• B3

• 3B

What is the cell reference for the colour yellow?

• B6

• C1

• 6B

• 1C

What is the cell range for the colour green?

• A10

• A10 to D10

• 10A : D10

• A10 : D10

What is the cell range for the colour red?

• A1 to A2

• A1 : B1

• A1 : B2

• B2 : A1

What is the cell range for the colour purple?

• A1 : D4

• A1 : A4

• A1 to A4

• A1 to D4

What is the cell range for the colour blue?

• B6

• B8 to B6

• B6 : B8

• B8

What is the cell range for the colour grey?

• D11

• D11 : A11

• 11D to 11A

• A11 : D11

D7 is the cell reference for the colour orange.

• True

• False

This picture shows...

• Row C

• Column C

This picture shows...

• Row 6

• Column 6