Excel Functions

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

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.

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

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

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.

Is the following a valid function?

=SUM(12+56)

• Yes

• No