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:

Learning And Performance

The acquisition of knowledge or skills and the application thereof in specific situations.

Classical Conditioning

The acquisition of knowledge through the connection between a stimulus in the environment and one that naturally exists.

Phobias

Extreme or irrational fears of specific objects, situations, or activities, leading to significant distress and avoidance behavior.

Operant Conditioning

A teaching mechanism in which the intensity of an action is altered through positive reinforcement or disciplinary actions.