Introduction to spreadsheets
Quiz
•
Computers
•
5th Grade
•
Practice Problem
•
Hard
Mrs O'Connor
Used 20+ times
FREE Resource
Enhance your content in a minute
9 questions
Show all answers
1.
MULTIPLE SELECT QUESTION
45 sec • 1 pt
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.
MULTIPLE CHOICE QUESTION
30 sec • 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
30 sec • 1 pt
Which of the following is the correct cell reference for the subtotal of grapefruit?
D5
A5
£1.00
D1
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which formula is the correct formula to calculate the subtotal for bananas?
=B3xC3
=B3*C3
=C3*D3
=C3xD3
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What does this operator mean in a spreadsheet / ?
Divide
Multiply
Add
Subtract
6.
MULTIPLE SELECT QUESTION
45 sec • 1 pt
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.
MULTIPLE CHOICE QUESTION
30 sec • 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 Classlink

Continue with Clever
or continue with

Microsoft
%20(1).png)
Apple
Others
Already have an account?
Similar Resources on Wayground
10 questions
Microsoft Windows
Quiz
•
4th Grade - University
10 questions
CLASS 5 COMPUTER ACTIVITY - 1
Quiz
•
5th Grade
11 questions
Youtube
Quiz
•
4th Grade - University
10 questions
ICT Yr 5 - Programming in LOGO (Part 1)
Quiz
•
5th Grade
12 questions
Microsoft Office Word
Quiz
•
4th Grade - University
12 questions
Keyword searches and reliable sources
Quiz
•
2nd - 5th Grade
10 questions
Operating System
Quiz
•
5th - 9th Grade
13 questions
Pet simulator x Test
Quiz
•
1st Grade - Professio...
Popular Resources on Wayground
15 questions
Fractions on a Number Line
Quiz
•
3rd Grade
20 questions
Equivalent Fractions
Quiz
•
3rd Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
22 questions
fractions
Quiz
•
3rd Grade
20 questions
Main Idea and Details
Quiz
•
5th Grade
20 questions
Context Clues
Quiz
•
6th Grade
15 questions
Equivalent Fractions
Quiz
•
4th Grade
20 questions
Figurative Language Review
Quiz
•
6th Grade
