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

• Draw pictures

• Store numeric data

• Make calculations

• Write a letter

• Draw charts and graphs

• Write reports

• Present information

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

Active Cell

Row

Column

Menu

Font

1. How many rows are shown on this spreadsheet?   

(a)  

1. How many columns are shown on this spreadsheet?   

(a)  

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

(a)