NEW
Font size
WorksheetsSpreadsheet Functions
Total questions: 8
Worksheet time: 4mins
All functions and formulas begin with which symbol?
#
/
:
=
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.
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
What is the result of
=C4 + C5
32
12
17
15
Which function is correct for adding up a selection of numbers?
sum(A1+A10)
=sum(A1+A10)
sum(A1:A10)
=sum(A1:A10)
What two operations does the AVERAGE function perform?
Addition and Multiplication
Multiplication and Division
Addition and Subtraction
Addition and Division
What function should be entered to calculate the total budget?
=AVERAGE(B3:B6)
=SUM(B3:B6)
=SUM(B3-B6)
=TOTAL(B3:B6)
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")
