WorksheetsY6 - Data - Introduction to Spreadsheets Assessment NCCE
Total questions: 11
Worksheet time: 33mins
1. Which of these statements are true about spreadsheets? (Tick ALL that apply)
When using formulas with cell references; if I change one cell, it could change another cell automatically
Calculations can be used on any data type in a spreadsheet. For example 7*hello.
Data can be calculated (+, -, * & /) using different operations within the spreadsheet.
Spreadsheets can produce charts line bar charts and line graphs based on the data.
3. Using the spreadsheet, which of the following is the correct cell reference for the subtotal of grapefruit (how much the grapefruit costs)?
6. Which of these would make suitable column headings in a spreadsheet for a local supermarket? (Tick ALL that apply)
The total of A1 and A4 only
11. Explain why you think this would be the best way to share with your headteacher.
