Font size
WorksheetsYear 6 Introduction to Spreadsheets
Total questions: 10
Worksheet time: 50mins
Which of these statements are true about spreadsheets? (Select all that apply)
When using formulas with cell references, changing one cell can change another
Calculations can be used on any data type in a spreadsheet
Data can be calculated using different operations within the spreadsheet
Charts can be produced using the data held in spreadsheets
Below is an example section of a spreadsheet. How much does one kiwi cost?
£3
£9.50
£0.80
£2.40
Using the same spreadsheet section as in question 2, which of the following is the correct cell reference for the subtotal of grapefruit?
D5
A5
£1.00
D1
Using the same spreadsheet section as in question 2, which formula is the correct formula to calculate the subtotal for bananas?
=B3xC3
=B3*C3
=C3*D3
=C3xD3
What does the following operator mean in a spreadsheet?
/
Divide
Multiply
Add
Subtract
Which of these would make suitable column headings in a spreadsheet for a local supermarket? (Select all that apply)
Cost
£4.62
Apples
Item
Which number format has been applied to this piece of data?
12:05:00
Date
Italics
Duration
Currency
What does this SUM function calculate?
=SUM(A1:A4)
The total cost of items
The total of A1, A2, A3 and A4
The total of A1 and A4
A data heading
The subtotal column in the spreadsheet section below has been calculated using a formula. Which cell could be changed to alter the value shown in D2?
A2
B2
£8.00
D1
Some children want to show the head teacher how much cheaper the school heating bill is if the doors are left closed at playtime. Should they show their data in a spreadsheet table or a graph?
