Discover answers to your questions with Westonci.ca, the leading Q&A platform that connects you with knowledgeable experts. Connect with a community of experts ready to help you find accurate solutions to your questions quickly and efficiently. Discover in-depth answers to your questions from a wide network of professionals on our user-friendly Q&A platform.

The function ________ returns a value or reference of the cell at the intersection of a particular row and column in a given range. A) VLOOKUP(lookup_value, table_array, col_index_num) B) MATCH(lookup_value, lookup_array, match_type) C) HLOOKUP(lookup_value, table_array, row_index_num) D) INDEX(array, row_num, col_num)

Sagot :

Answer:

The function ___ INDEX_____ returns a value or reference of the cell at the intersection of a particular row and column in a given range

Explanation:

In Excel, The function INDEX returns a value or reference of the cell at the intersection of a particular row and column in a given range.

What is the importance of INDEX?

It should be noted that the INDEX function is important as it's categorized under Excel lookup functions.

The function INDEX returns a value or reference of the cell at the intersection of a particular row and column in a given range.

Learn more About Excel on:

https://brainly.com/question/25863198