What Is the Purpose of the Row_num Argument in the Following

question 30

Multiple Choice

What is the purpose of the Row_num argument in the following INDEX function?
=INDEX(A2:B5,MATCH(MAX(B2:B5) ,B2:B5,0) ,1)

• A)To return the highest value in the range B2:B5
• B)To return the position of the highest value in the range B2:B5
• C)To return the column to the left of the highest values in the range B2:B5
• D)To return the row of the highest value in the range B2:B5

---

Definitions:

Abstract Reasoning

The process of thinking about ideas and concepts that are not physically present, involving the ability to analyze and manipulate mental constructs.

Nervous System

The network of nerve cells and fibers that transmits nerve impulses between parts of the body, overseeing both voluntary actions and involuntary processes.

Sensory Stimulation

Exposure to stimuli that affects one of the five senses, used to enhance learning, healing, and general well-being.

Sensory Changes

Alterations in how one perceives sensory stimuli, often due to aging or neurological conditions, affecting sight, hearing, taste, touch, and smell.