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

• Make calculations

• Draw charts and graphs

• Store numeric data

• Present information

• Draw pictures

• Write reports

• Write a letter

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

Row

Menu

Active Cell

Font

Column

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?