Spreadsheet Functions

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")