Have an account?
Skip to Content
Build your own quiz
Suggestions for you
8 questions
Show Answers
See Preview
- 1. Multiple Choice
All functions and formulas begin with which symbol?
#
/
:
=
- 2. Multiple Choice
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.
- 3. Multiple Choice
What 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
- 4. Multiple Choice
What is the result of
=C4 + C5
32
12
17
15
- 5. Multiple Choice
Which function is correct for adding up a selection of numbers?
sum(A1+A10)
=sum(A1+A10)
sum(A1:A10)
=sum(A1:A10)
- 6. Multiple Choice
What two operations does the AVERAGE function perform?
Addition and Multiplication
Multiplication and Division
Addition and Subtraction
Addition and Division
- 7. Multiple Choice
What function should be entered to calculate the total budget?
=AVERAGE(B3:B6)
=SUM(B3:B6)
=SUM(B3-B6)
=TOTAL(B3:B6)
- 8. Multiple Choice
Which function would display "Yes" if D13 is greater than 0?
=IF(D13>0, "Yes", "No")
=IF(D13<0, "Yes", "No")
=IF(D13>0: "Yes", "No")
=IF(D13<0: "Yes", "No")
- Answer choicesTagsAnswer choicesTags