Activity 2 - Pixel Art: Flag 1

Download as docx, pdf, or txt
Download as docx, pdf, or txt
You are on page 1of 3

Year 7 – Spreadsheets Learner activity sheet

Lesson 1 – Getting to know a spreadsheet

Activity 2 – Pixel art


In this activity, you will draw some flags by colouring in cells in a spreadsheet. Can you
guess which country each flag belongs to?

★ Top tip: If you make a mistake, you can use the Undo command to undo the last
thing you did.

Flag 1
Apply a black fill colour to the following cells:
● A1:F5

Step-by-step guide
Prefer to do it step by step? Here are the cells you need to colour:

A1:A5 B1:B5 C1:C5 D1:D5 E1:E5 F1:F5

Hint: A1:A5 means cells 1 to 5 in column A

Apply a red fill colour to the following cells:


● A6:F10

Step-by-step guide
Here are the cells you need to colour:

A6:A10 B6:B10 C6:C10 D6:D10 E6:E10 F6:F10

Page 1 Last updated: 08-06-21


Year 7 – Spreadsheets Learner activity sheet
Lesson 1 – Getting to know a spreadsheet

Apply a yellow fill colour to the following cells:


● A11:F15

Step-by-step guide
Here are the cells you need to colour:

A11:A15 B11:B15 C11:C15 D11:D15 E11:E15 F11:F15

Flag 2
Apply a blue fill colour to the following cells:
● A21:B35

Step-by-step guide
Prefer to do it step by step? Here are the cells you need to colour:

A21:A35 B21:B35

Hint: A1:A5 means cells 1 to 5 in column A

Leave the following cells white:


● C21:D35

Apply a red fill colour to the following cells:


● E21:F35

Finally, make the flag stand out by putting a border around it.
● Select all of the cells A21:F35 and apply a border around the outside only.
● Can you work out how to change the thickness of the border?

Page 2 Last updated: 08-06-21


Year 7 – Spreadsheets Learner activity sheet
Lesson 1 – Getting to know a spreadsheet

Flag 3
Apply a blue fill colour to the following cells:
● A41:B46
● A50:B55
● D41:F46
● D50:F55

Apply a yellow fill colour to the following cells:


● C41:C55
● A47:F49

Resources are updated regularly — the latest version is available at: ncce.io/tcc.

This resource is licensed under the Open Government Licence, version 3. For more information on this
licence, see ncce.io/ogl.

Page 3 Last updated: 08-06-21

You might also like