
Mastering Spreadsheets Quiz
Quiz
•
Computers
•
7th Grade
•
Practice Problem
•
Hard
Samar Chauhan
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 purpose of the SUM function in a spreadsheet?
To divide a series of numbers
To multiply a series of numbers
To add up a series of numbers
To subtract a series of numbers
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which formula can be used to find the average value of the numbers in cells A1 through A10?
=AVERAGE(A1:A10)
=SUM(A1:A10)/10
Both A and B
=AVG(A1:A10)
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What does the cell address A1 indicate?
Column A and Row 1
Column 1 and Row A
The first cell in Column A
Both A and C
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
How do you insert a pie chart in a spreadsheet?
Select the data and press the pie chart button
Write a formula to generate a pie chart
Copy and paste from another document
Use the SUM function
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What function would you use to find the maximum value in a range of cells from B1 to B10?
=MAX(B1:B10)
=HIGHEST(B1:B10)
=LARGEST(B1:B10)
=TOP(B1:B10)
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
To find the minimum value in the cells C1 through C10, which function is correct?
=SMALLEST(C1:C10)
=MIN(C1:C10)
=LOWEST(C1:C10)
=BOTTOM(C1:C10)
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the result of the formula =AVERAGE(2, 4, 6, 8)?
4
5
6
20
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
15 questions
Pretest Aplikasi Pengolah Angka
Quiz
•
10th Grade
15 questions
Coding Quiz
Quiz
•
6th - 10th Grade
15 questions
Virtual Private Server
Quiz
•
12th Grade
17 questions
Mobile app development principles
Quiz
•
10th Grade
15 questions
Robotics Prelim
Quiz
•
University
20 questions
Digital and Analog transmission
Quiz
•
University
17 questions
Security and Ethics
Quiz
•
9th - 12th Grade
15 questions
GIS Unit III
Quiz
•
University
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
54 questions
Analyzing Line Graphs & Tables
Quiz
•
4th 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
