Spreadsheet test 1
Authored by Mister Wall
Computers
9th - 10th Grade
Used 4+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
25 questions
Show all answers
1.
MULTIPLE SELECT QUESTION
45 sec • 1 pt
Which arithmetic operation would you use to work out the total KM for this D of E Hike?
MINUS -
PLUS +
DIVIDE /
MULTIPLY *
=SUM( )
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which arithmetic operation would you use to work out the discount with a Morrison's more card?
PLUS +
MINUS -
MULTIPLY *
DIVIDE /
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which arithmetic operation would you use to work out the total cost for all of the quantities of all Apples?
DIVIDE /
ADD +
MINUS -
MULTIPLY *
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What formular would we use to work out all the totals?
=MAX
=AVERAGE
=COUNT
=SUM
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What formular would we use to work out the number of pupils that are in this class?
=SUM
=AVERAGE
=COUNT
=MAX
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What formular would we use to work out the numbers of students doing Football, Basketball and Tennis?
=COUNT()
=SUM()
=MAX()
=COUNTIF()
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What should the numbers in green be formatted too?
Percentage
Decimal
Currency
Date
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?
