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:

Projected Job Market

An estimation or forecast of the future demand and availability of jobs within a certain sector or economy.

Internal Factor

refers to elements within an organization or individual that can influence decisions, behaviors, and outcomes, such as values, resources, and goals.

Appropriate Job

An employment position that is well-suited to an individual's skills, interests, and qualifications.

Prospecting Cover Letter

A type of cover letter sent to inquire about potential job opportunities or to introduce oneself to a potential employer, even when no job has been advertised.