Font size
WorksheetsSpreadsheet Assessment KS3 End of Unit
Total questions: 23
Worksheet time: 42mins
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
Draw pictures
Store numeric data
Draw charts and graphs
Present information
Make calculations
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) )
Label the different parts of this spreadsheet.
Active Cell
Menu
Font
Column
Row
How many rows are shown on this spreadsheet?
(a)
How many columns are shown on this spreadsheet?
(a)
What is the cell reference of the active cell?
(a)
Check the cell references which have a label
A4
B4
C5
E5
Which column letter contains the individual cost of ingredients?
A
B
C
D
Which row number contains the spell name?
4
3
1
2
5
Which cell reference contains the title ‘ingredients’ ?
A4
B4
C5
E5
Which cell reference contains the quantity of Moth’s spots needed?
A4
B4
C7
E5
Give a cell reference which contains a value
E4
B7
A4
E5
C5
Give a cell reference which contains a formula
E4
B7
A4
E5
C5
Write the formula used to work out the total cost of caterpillar hair required
(a)
The individual cost of Bat Wings has gone up from £0.20 to £0.25.
Which cell will change as a result of this price increase?
(a)
What symbol do you use to start a formula in excel?
(a)
The COUNTIF() function counts the number of cells that meet a set (a)
A spreadsheet is a (a) which makes it easy for you to work with numbers. It consists of a page of (b) and rows arranged into a (c) .
You can identify every single cell on a spreadsheet by its unique cell (d) , made up of the (e) number and column letter, for example, A6, E14, and N45.
Numbers, text or (a) can be entered into each cell. Formulas allow you to perform (b) on the numbers in your spreadsheet.
You can add, subtract, multiply and (c) numbers by using formulas.
Using formulas is a very good idea because it means that once your spreadsheet is set up, any changes you make to one area are automatically (d) throughout the (e) .
