Y6 - Data & Information - Intro to Spreadsheets

Q1. Which of these statements are true about spreadsheets? (Tick 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

Q2. The picture is an example section of a spreadsheet. How much does one kiwi cost?

• £3

• £9.50

• £0.80

• £2.40

Q3. Using the picture, which of the following is the correct cell reference for the subtotal of grapefruit?

• D5

• A5

• £1.00

• D1

Q4. Using the picture, which formula is the correct formula to calculate the subtotal for bananas?

• =B3xC3

• =B3*C3

• =C3*D3

• =C3xD3

Q5. What does this operator mean in a spreadsheet  /  ?

• Divide

• Multiply

• Add

• Subtract

Q6.  Which of these would make suitable column headings in a spreadsheet for a local supermarket? (Tick all that apply)

• Cost

• £4.62

• Apples

• Item

Q7.  Which number format has been applied to this piece of data? 

12:05:00

• Date

• Italics

• Duration

• Currency

Q8.  What does this SUM function calculate?

 

=SUM(A1:A4)

• The total cost of items

• The total of A1, A2, A3, and A4

• 1. The total of A1 and A4

• A data heading

Q9.  The subtotal column in the spreadsheet picture has been calculated using a formula. Which cell could be changed to alter the value shown in D2?

• 1. A2

• B2

• £8.00

• D1

Q10. 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?

• 1. Spreadsheet table

• 1. Graph