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:

Bateman's Principle

A concept in sexual selection that suggests males have greater variance in reproductive success than females due to their investment in mating.

Reproductive Variance

Reproductive variance refers to the variation in reproductive success among individuals within a population.

Eyespots

Markings found on the bodies of some animals, resembling eyes, thought to deter predators or attract mates.

Marion Petrie

A researcher known for her work on sexual selection, particularly regarding the role of peacock tail feathers in attracting mates.