IDNLearn.com is your go-to platform for finding reliable answers quickly. Our platform provides accurate, detailed responses to help you navigate any topic with ease.

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