GMetrix Exam GMetrix Excel: Formulas and Functions 3

Question 1

What does the IFERROR function do?

Accepted Answer

Returns a custom value when a formula produces an error

Answer

IFERROR evaluates a formula and returns a specified value instead of an error message if the formula produces an error.

Question 2

Which formula calculates the average of cells B1:B10 only where A1:A10 equals "Sales"?

Accepted Answer

=AVERAGEIF(A1:A10,"Sales",B1:B10)

Answer

AVERAGEIF calculates the average of a range based on a single condition in another range.

Question 3

What is the keyboard shortcut to enter an array formula in Excel?

Accepted Answer

Ctrl+Shift+Enter

Answer

Ctrl+Shift+Enter enters an array formula and wraps it in curly braces {}.

Question 4

Which function returns the largest value in a set of values?

Accepted Answer

MAX

Answer

MAX returns the maximum (largest) numeric value from a range or list of values.

Question 5

What does =TEXT(1234.5, "$#,##0.00") return?

Accepted Answer

$1,234.50

Answer

The TEXT function formats a number as text using the specified format code, adding a dollar sign and comma separator.

GMetrix Exam Practice Test