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

• Store numeric data

• Write a letter

• Draw charts and graphs

• Write reports

• Make calculations

• Draw pictures

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

Font

Active Cell

Column

Menu

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?