Which Excel Function Checks for Errors and Displays a Message

question 69

Multiple Choice

Which Excel function checks for errors and displays a message you specify if there is an error in a formula.

• A) ERROR
• B) #ERROR
• C) IFERROR
• D) #IFERROR

---

Definitions:

Constants

Fixed values that do not change within the context of a mathematical equation, experiment, or model, serving as a reference point for comparisons and calculations.

Indifference Curve

A graph representing combinations of goods between which a consumer is indifferent, showing their preferences.

Absolute Values

A mathematical operation that determines the magnitude of a number without regard to its sign, represented as the distance from zero on the number line.

Favorite Bundle

A term in economics, particularly in consumer theory, referring to the combination of goods and services that maximizes a consumer's utility or satisfaction given their budget constraints.