Spreadsheet Assessment KS3 End of Unit

Look at the screenshot of a financial model of a zoo and answer the questions below.

How much does it cost to feed the lions? 

• £200.00

• £1010.00

• £25.00

• £240.00

Look at the screenshot of a financial model of a zoo and answer the questions below.

How much is allowed to be spent in total each week?

• £200.00

• £1010.00

• £25.00

• £1000.00

Look at the screenshot of a financial model of a zoo and answer the questions below.

How much is spent in total this week?

• £200.00

• £1010.00

• £25.00

• £1000.00

Look at the screenshot of a financial model of a zoo and answer the questions below.

Is the zoo overspending or underspending?

• Overspending by £10

• Underspending by £10

            Are spreadsheets always the best tools?

Look at the options below and organise into True and False

Groups:

(a) True

,

(b) False

• Present information

• Write a letter

• Make calculations

• Draw pictures

• Write reports

• Store numeric data

• Draw charts and graphs

A ​ (a)   is a ready made formula that uses ​ (b)   (words) whilst a ​ (c)   is a calculation that uses symbols (​ (d)   )

• formula
• operators
• function
• statements
• spreadsheet
• maximum
• minimum

Label the different parts of this spreadsheet.

b

c

d

e

a

Font

Menu

Row

Column

Active Cell

1. How many rows are shown on this spreadsheet?   

1. How many columns are shown on this spreadsheet?   

1. What is the cell reference of the active cell?