
Mastering Spreadsheet Essentials
Quiz
•
Information Technology (IT)
•
9th Grade
•
Practice Problem
•
Easy
S Uwadiae
Used 1+ times
FREE Resource
Enhance your content in a minute
20 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the formula to add the values in cells A1 and A2?
`=A1+A2`
`=SUM(A1:A2)`
`=ADD(A1,A2)`
`=A1-A2`
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which of the following is a basic formula to subtract the value in cell B2 from B1?
`=B1+B2`
`=B1-B2`
`=SUBTRACT(B1,B2)`
`=B2-B1`
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
How do you multiply the values in cells C1 and C2?
`=C1*C2`
`=MULTIPLY(C1,C2)`
`=C1+C2`
`=C1/C2`
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the formula to divide the value in cell D1 by D2?
`=D1*D2`
`=D1-D2`
`=D1/D2`
`=DIVIDE(D1,D2)`
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which function would you use to find the average of cells E1 to E5?
`=SUM(E1:E5)`
`=AVERAGE(E1:E5)`
`=MEAN(E1:E5)`
`=MEDIAN(E1:E5)`
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
How can you format a cell to display numbers as currency?
Change the font
Use the currency format option
Use the percentage format option
Use the text format option
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which of the following is a function to find the maximum value in a range of cells?
`=MIN()`
`=MAX()`
`=LARGEST()`
`=HIGHEST()`
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
Lower Elementary Quiz: Introduction to Computers
Quiz
•
2nd Grade - University
15 questions
ICS: Unit 3 Review
Quiz
•
9th Grade
15 questions
Lesson 2: IT Systems In Organisations
Quiz
•
9th - 12th Grade
15 questions
Intro to Word Processing
Quiz
•
9th Grade - University
15 questions
AI in Agriculture Quiz
Quiz
•
9th Grade - University
15 questions
Python Battle Royale: Who Will Survive in the End?❤️🤔
Quiz
•
9th - 12th Grade
15 questions
Lesson 1: Shared Data
Quiz
•
9th - 12th Grade
15 questions
Content Distribution Questions
Quiz
•
9th Grade
Popular Resources on Wayground
5 questions
This is not a...winter edition (Drawing game)
Quiz
•
1st - 5th Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
10 questions
Identify Iconic Christmas Movie Scenes
Interactive video
•
6th - 10th Grade
20 questions
Christmas Trivia
Quiz
•
6th - 8th Grade
18 questions
Kids Christmas Trivia
Quiz
•
KG - 5th Grade
11 questions
How well do you know your Christmas Characters?
Lesson
•
3rd Grade
14 questions
Christmas Trivia
Quiz
•
5th Grade
20 questions
How the Grinch Stole Christmas
Quiz
•
5th Grade
Discover more resources for Information Technology (IT)
10 questions
Identify Iconic Christmas Movie Scenes
Interactive video
•
6th - 10th Grade
10 questions
Understanding Meiosis
Interactive video
•
6th - 10th Grade
26 questions
Christmas Movie Trivia
Lesson
•
8th Grade - Professio...
15 questions
Christmas Song Emoji Pictionary
Quiz
•
7th - 12th Grade
20 questions
Christmas Movies
Quiz
•
1st - 12th Grade
10 questions
Exploring Christmas Traditions Through Cartoons
Interactive video
•
6th - 10th Grade
20 questions
Christmas Movie Trivia
Quiz
•
9th - 12th Grade
20 questions
Name That Tune Christmas Edition
Quiz
•
6th - 9th Grade
