You Have Been Using a Variety of Nested IF Functions

question 84

Multiple Choice

You have been using a variety of nested IF functions to calculate costs in your spreadsheet when a colleague stops by and comments on what you have been working on, suggesting that there is an easier approach to use.
-If you omit the range_lookup value from a LOOKUP function,which of the following is true?

• A)The function returns the #NAME? error value.
• B)Your function can only search the first column of the lookup table.
• C)It is considered an approximate match.
• D)It is considered an exact match.

---

Definitions:

Former CEO

An individual who previously held the chief executive officer position in a company, responsible for strategic decision-making and overall management.

Lump-sum Merit Pay

A one-time payment awarded to an employee for exceptional performance, rather than an ongoing salary increase.

Base Pay

The initial rate of compensation an employee receives, excluding any additional benefits, bonuses, or overtime.

Annual Merit Raise

An increase in salary given yearly based on an employee's performance evaluation.