Year 6 Introduction to Spreadsheets
Authored by S Greenfield
Computers
6th Grade
Used 6+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
10 questions
Show all answers
1.
MULTIPLE SELECT QUESTION
5 mins • 1 pt
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
2.
MULTIPLE CHOICE QUESTION
5 mins • 1 pt
Below is an example section of a spreadsheet. How much does one kiwi cost?
£3
£9.50
£0.80
£2.40
3.
MULTIPLE CHOICE QUESTION
5 mins • 1 pt
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
4.
MULTIPLE CHOICE QUESTION
5 mins • 1 pt
Using the same spreadsheet section as in question 2, which formula is the correct formula to calculate the subtotal for bananas?
=B3xC3
=B3*C3
=C3*D3
=C3xD3
5.
MULTIPLE CHOICE QUESTION
5 mins • 1 pt
What does the following operator mean in a spreadsheet?
/
Divide
Multiply
Add
Subtract
6.
MULTIPLE SELECT QUESTION
5 mins • 1 pt
Which of these would make suitable column headings in a spreadsheet for a local supermarket? (Select all that apply)
Cost
£4.62
Apples
Item
7.
MULTIPLE CHOICE QUESTION
5 mins • 1 pt
Which number format has been applied to this piece of data?
12:05:00
Date
Italics
Duration
Currency
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?
