Quiz 5 - Excel
Authored by Nixon López
Computers
11th Grade
Used 4+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
10 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What function in Excel totals all of the cells in a range?
AVERAGE
AutoSum
COUNT
MAX
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which function should be used to determine the mean value of a range of cells?
MIN
AVERAGE
COUNT
MAX
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which function should be used to calculate the number of nonblank cells in a worksheet?
SUM
COUNTA
MIN
MAX
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the default selection for AutoSum in Excel?
By default, AutoSum totals all entries above the cell in which the formula is located, even if the cells contain a mix of numeric and nonnumeric content.
By default, AutoSum calculates the total from the adjacent cell through the first nonnumeric cell.
AutoSum does not have a default selection.
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which category of functions do the COUNT and MIN functions belong to?
Text
Statistical
Financial
Logical
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
The AVERAGE function calculates the average score of a group of students. (True/False)
True
False
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
The COUNT function returns the total number of cells in the selected range that contain both text and numbers. (True/False)
True
False
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?
