Year 6 Introduction to Spreadsheets

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?

• 1. =B3xC3

• 1. =B3*C3

• 1. =C3*D3

• 1. =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?

Answer explanation

Learners should be able to justify their reasoning for choosing a graph to present this data. Learners may use similar words to: picture, compare the two, clearly, ease of use.

I chose a graph because I wanted the head teacher to see really clearly the differences between when the doors were open and when they were closed at playtime. Showing a picture of the data makes it easier to explain what we found than a table of numbers.