Excel Functions

Front

What is the purpose of the MIN function?

Back

Find the lowest number in a range of cells

Front

All functions and formulas begin with which symbol?

Back

=

Front

Which are the three essential elements to enter a function?

Back

Equal sign, function name, and cell reference.

Front

Which function will produce results that indicate whether a student has passed or failed a course by entering the text "Pass" or "Fail"?

Back

If

Front

What is the result of =C4 + C5?

Back

12

Front

Which function is correct for adding up a selection of numbers? Options: sum(A1+A10), =sum(A1+A10), sum(A1:A10), =sum(A1:A10)

Back

sum(A1:A10)

Front

What function should be entered to calculate the total budget? Options: =AVERAGE(B3:B6), =SUM(B3:B6), =SUM(B3-B6), =TOTAL(B3:B6)

Back

=SUM(B3:B6)

Front

Which function would display "Yes" if D13 is greater than 0? Options: =IF(D13>0, "Yes", "No"), =IF(D13<0, "Yes", "No"), =IF(D13>0: "Yes", "No"), =IF(D13<0: "Yes", "No")

Back

=IF(D13>0, "Yes", "No")

Front

What is the purpose of the MAX function?

Back

Find the highest number in the range of cells.

Front

Is the following a valid function?

=SUM(12+56)

Back

No