Filling a cell with colour by hand

Name:

Date:

Class:

Quick Questions

Shade in the A or B circle for each question.

1. Which tool changes the background colour of a spreadsheet cell?

A Fill colour

B Font size

2. Before you fill a cell with colour, what must you do first?

A Type a formula in it

B Select the cell

3. How can you colour a whole block of cells at the same time?

A Drag over the block to select it, then pick a colour

B Click one cell and the whole block fills by itself

4. You click cell B2 and choose red from the fill colour tool. What changes?

A Only cell B2 gets a red background

B The whole column turns red

5. You fill a cell with yellow by mistake. How do you remove the colour?

A Choose white text

B Choose No fill

Match the Pairs

Draw a line connecting each item on the left to its match on the right.

Left column		Right column
1Fill colour		AA tool that changes the background colour of the selected cell or cells
2No fill		BA1:C3
3Select a block of cells by dragging from the first cell to the last cell		CB2
4Click one cell to select it before choosing a fill colour		DPicking a colour will not remove it. You need to choose No fill to take the colour away.
5Click B2, then choose Fill colour to colour the whole block A1:C3		EAn option that removes the background colour from the selected cells
6To remove the colour from A1, pick the same fill colour again		FOnly one cell was selected. The fill colours just B2. To colour the whole block, drag from A1 to C3 first.

Definitions

fill colour

Fill in the Blanks

Complete each line of code by filling in the missing parts.

select("B2") __________("Yellow")

select("A1_C3") fillColour("Pink")

______("D4") fillColour("Red")

select("B2:B6") fillColour("_______")

select("A1:__") # drag down 3 cells fillColour("Blue")

Spot the Error

Shade in the letter of the line that contains an error.

Question 1

A Goal: colour cell B2 red

B Click cell B2 to select it

C Choose Text colour, then red

Question 2

A Click the column letter C

B Open the Fill colour palette

C Pick green from the palette

Question 3

A Click cell A1

B Drag across to cell C3

C Choose No fill to add blue

Question 4

A Select the coloured cell D5

B Open the Fill colour palette

C Pick red to remove the colour

Question 5

A Click cell A1

B Hold the mouse button down

C Drag down to cell A5

D Click cell F9 to finish

E Pick pink from Fill colour

Answer Key

Filling a cell with colour by hand

Section A: Quick Questions

A — Fill colour

B — Select the cell

A — Drag over the block to select it, then pick a colour

A — Only cell B2 gets a red background

B — Choose No fill

Section B: Match the Pairs

Fill colour → A tool that changes the background colour of the selected cell or cells

No fill → An option that removes the background colour from the selected cells

Select a block of cells by dragging from the first cell to the last cell → A1:C3

Click one cell to select it before choosing a fill colour → B2

Click B2, then choose Fill colour to colour the whole block A1:C3 → Only one cell was selected. The fill colours just B2. To colour the whole block, drag from A1 to C3 first.

To remove the colour from A1, pick the same fill colour again → Picking a colour will not remove it. You need to choose No fill to take the colour away.

Section C: Definitions

fill colour — A spreadsheet tool that changes the background colour of the selected cell or cells. Click one cell or drag over a block, then pick a colour. Choose No fill to remove the colour.

Section D: Fill in the Blanks

select("B2")
fillColour("Yellow")

select("A1:C3")
fillColour("Pink")

select("D4")
fillColour("Red")

select("B2:B6")
fillColour("No fill")

select("A1:A3")  # drag down 3 cells
fillColour("Blue")

Section E: Spot the Error

C — Text colour changes the colour of the letters or numbers. To change the background of the cell, choose Fill colour, then red.

A — Clicking a column letter selects the whole column, not one cell. To colour just C4, click cell C4 itself.

C — No fill removes colour, so it cannot add blue. Choose Fill colour, then blue, to colour the selected block.

C — Picking a colour adds a new fill, it does not remove one. To remove the colour, choose No fill.

D — Clicking another cell replaces the selection, so only F9 would be selected. Release the mouse button to keep the block A1 to A5 selected.