Y6 - Data - Introduction to Spreadsheets

Name

1. 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

2. Here is an example section of a spreadsheet. How much does 1 Kiwi cost?

• A: £3
• B: £9.50
• C: £0.80
• D: £2.40

3. Using the spreadsheet in the previous question, which of the following is the correct cell reference for the subtotal of grapefruit?

• D5
• A5
• £1.00
• D1

4. Using the same spreadsheet, which formula is the correct formula to calculate the subtotal for bananas?

• =B3xC3
• =B3*C3
• =C3*D3
• =C3xD3

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

• Divide
• Multiply
• Add
• Subtract

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

• Cost
• £4.62
• Apples
• Item

7. Which number format has been applied to this piece of data? 12:05:00

• Date
• Italics
• Duration
• Currency

8. 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

9. The Subtotal column in the spreadsheet section below has been calculated using a formula. Which cell could be changed to change the value shown in D2?

• A2
• B2
• £8.00
• D1