Excel Functions
Authored by O Hawkridge
Computers
10th Grade
Used 13+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
16 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
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 QUESTION
30 sec • 1 pt
All functions and formulas begin with which symbol?
#
/
:
=
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which are the three essential elements to enter a function?
Equal sign, function name, and cell reference.
Equal sign, cell reference, and formula.
Function name, data, and cell reference.
Function name and cell reference.
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which function will produce results that indicate whether a student has passed or failed a course by entering the text "Pass" or "Fail"?
Count
Count A
If
Sum
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the result of =C4 + C5
32
12
17
15
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which function is correct for adding up a selection of numbers?
sum(A1+A10)
=sum(A1+A10)
sum(A1:A10)
=sum(A1:A10)
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What function should be entered to calculate the total budget?
=AVERAGE(B3:B6)
=SUM(B3:B6)
=SUM(B3-B6)
=TOTAL(B3:B6)
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?
