Heje
Authored by Rose Maharjan
Information Technology (IT)
University
Used 1+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
20 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which of the following functions will return the total of a range of numbers?
COUNT
ADD
TOTAL
SUM
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What will =AVERAGE(2,4,6,8) return?
4
6
5
10
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
The formula =MAX(A1:A5) returns:
The smallest value in A1 to A5
The average
The highest value
Count of values
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What does =COUNT(A1:A10) count?
Non empty cell
All cell
Only text
Numeric value
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
COUNTA(A1:A5) counts:
Only number
Only formula
All non empty cells
Only errors
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What will =MEDIAN(7, 3, 9) return?
3
9
7
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which function will count blank cells in a range?
COUNT
COUNTBLANK
ISBLANK
COUNTA
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?
