Have an account?
Skip to Content
Build your own quiz
Suggestions for you
10 questions
Show Answers
See Preview
- 1. Multiple Choice
What is the purpose of the MIN function
Add the numerical values in a range of cells
Find the lowest number in a range of cells
Find the highest number in the range of cells
Finds the average from a range of cells
- 2. Multiple Choice
What is the purpose of the COUNT function?
Adds the values of a range of cells
Counts how many cells in a range contain anything
Counts how many cells in a range contain numbers
Counts how many cells have been selected
- 3. Multiple Choice
What is the purpose of the COUNTA function?
Adds the values of a range of cells
Counts how many cells in a range contain anything
Counts how many cells in a range contain numbers
Counts how many cells have been selected
- 4. Multiple Choice
What is the purpose of the MAX function
Add the numerical values in a range of cells
Find the lowest number in a range of cells
Find the highest number in the range of cells
Finds the average from a range of cells
- 5. Multiple Choice
Is the below a function or formula?
=SUM(A1:A5)
Function
Formula
- 6. Multiple Choice
Is the below a function or formula?
=(A1+A5)-(A5*A7)
Function
Formula
- 7. Multiple Choice
Is the following a valid function?
=SUM(12+56)
Yes
No
- 8. Multiple Choice
Is the following function valid?
=counta(A1:A6)
Yes
No
- 9. Multiple Choice
All functions and formulas begin with which symbol?
#
/
:
=
- 10. Multiple Choice
Which formula would be used to calculate average?
=MAX(B5:B10)
=SUM(B5:B10)
=AVERAGE(B5:B10)
=SUM(B5*B10)
- Answer choicesTagsAnswer choicesTags