Excel Functions Quiz

What is the purpose of the SUM function in Excel?

• To find the total of a range of cells

• To find the average of a range of cells

• To find the maximum number in a range

• To count the number of cells

What is the correct syntax for the AVERAGE function?

• =average(range)

• =mean(range/list of cells)

• =avg(range/list of cells)

• =average(range/list of cells)

Which function would you use to find the maximum number in a range?

• =max(range/list of cells)

• =average(range/list of cells)

• =count(range/list of cells)

• =min(range/list of cells)

What does the COUNT function do?

• Counts cells that meet a criteria

• Counts non-empty cells

• Counts only cells with numbers

• Counts all cells in a range

What is the syntax for the IF function?

• =IF(test, true, false)

• =IF(logical_test, result_if_true, result_if_false)

• =IF(condition, value_if_true, value_if_false)

• =IF(condition, true_value, false_value)

Which function creates a valid date from year, month, and day?

• =valid_date(year, month, day)

• =datetime(year, month, day)

• =date(year, month, day)

• =create_date(year, month, day)

What is the purpose of the COUNTIF function?

• To count all cells in a range

• To count non-empty cells

• To count the maximum value in a range

• To count cells that meet a specific condition

What does the VLOOKUP function do?

• Looks for a value in a column and returns a value from the same row

• Looks for a value in a row and returns a value from the same column

• Counts the number of cells in a range

• Finds the minimum value in a range

What is the correct syntax for the PMT function?

• PMT(rate, nper, pv)

• PMT(rate, nper, pv, fv, type)

• PMT(interest_rate, number_of_payments, present_value)

• PMT(rate, total_payments, principal)

Which function would you use to find the minimum number in a range?

• =sum(range/list of cells)

• =max(range/list of cells)

• =min(range/list of cells)

• =average(range/list of cells)