MOAC Excel 2016 Lesson 05
Authored by Kim Conant
Computers
8th - 12th Grade
Used 283+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
14 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which function calculates the TOTAL (adds all the cells in the range together)?
SUM
AVERAGE
MAX
MIN
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which function calculates the MEAN of a range of cells (adds all the cells together and then divides by the number of cells)?
MIN
AVERAGE
COUNT
MAX
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
You want to calculate the number of nonblank cells in your worksheet. Which function should be used?
SUM
COUNTA
MIN
MAX
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which function returns the highest value in a range?
SUM
AVERAGE
MAX
MIN
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which function returns the lowest value in a range?
SUM
AVERAGE
MAX
MIN
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which function would you use instead of this formula: =B1+B2+B3+B4+B5+B6+B7?
=SUM(B1:B7)
=COUNT(B1:B7)
=AVERAGE(B1:B7)
=MAX(B1:B7)
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which function would you use instead of this formula: =(B1+B2+B3+B4)/4?
=SUM(B1:B4)/4
=COUNT(B1:B4)/4
=AVERAGE(B1:B4)/4
=MAX(B1:B4)/4
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
Already have an account?
