
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 Classlink

Continue with Clever
or continue with

Microsoft
%20(1).png)
Apple
Others
Already have an account?
Similar Resources on Wayground
20 questions
Yr 11 ICT quiz 1 Networks & Security
Quiz
•
10th - 11th Grade
20 questions
Word 2016 - Lessons 1 & 2
Quiz
•
9th - 12th Grade
20 questions
MS Excel Grade 6
Quiz
•
6th - 10th Grade
21 questions
Y9 Creative iMedia RO81 Quiz Part 1
Quiz
•
9th Grade
20 questions
Semester 1 - Microsoft Word
Quiz
•
9th - 12th Grade
20 questions
Microsoft Excel
Quiz
•
KG - Professional Dev...
20 questions
CSS 10 - QUIZ
Quiz
•
10th Grade
20 questions
Fungsi IF, AND dan OR
Quiz
•
10th - 12th Grade
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