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

• Store numeric data

• Write reports

• Present information

• Make calculations

• Draw charts and graphs

• Draw pictures

• 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

Column

Menu

Row

Active Cell

Font

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?