Why Would You Nest MATCH in an INDEX Function

question 17

Multiple Choice

Why would you nest MATCH in an INDEX function?

• A)To handle multiple outcomes
• B)To find the highest or lowest value in an array
• C)To use the position returned in the Match function as an argument in the index function
• D)To use the value returned in the Match function as a lookup in the index function

---

Definitions:

Consumer Goods

Products and commodities bought and used by individuals and households for personal consumption.

Capital Goods

Long-lasting goods that are used in the production of other goods and services but are not themselves part of the end product.

Opportunity Cost

The cost of forgoing the next best alternative when making a decision, representing the benefits one misses out on when choosing one option over another.

Socialistic Economies

Economic systems where the production and distribution of goods and services are controlled by the state, aiming for equal wealth distribution and reduction of economic inequalities.