Y6 - Data - Introduction to Spreadsheets
Authored by Toby Henniker
others
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
12 questions
Show all answers
1.
OPEN ENDED QUESTION
30 sec • Ungraded
Name
Evaluate responses using AI:
OFF
2.
MULTIPLE SELECT QUESTION
30 sec • 1 pt
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
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
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
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
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
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
4. Using the same spreadsheet, which formula is the correct formula to calculate the subtotal for bananas?
=B3xC3
=B3*C3
=C3*D3
=C3xD3
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
5. What does this operator mean in a spreadsheet / ?
Divide
Multiply
Add
Subtract
7.
MULTIPLE SELECT QUESTION
30 sec • 1 pt
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
Access all questions and much more by creating a free account
Create resources
Host any resource
Get auto-graded reports
Continue with Google
Continue with Email
Continue with Microsoft
or continue with
%20(1).png)
Apple
Others
By signing up, you agree to our Terms of Service & Privacy Policy
Already have an account?
