Asked by Leticia Miranda on May 25, 2024

verifed

Verified

The _____ function returns the value from a range of data at the intersection of a specified row and column.

A) INDEX
B) MATCH
C) LOOKUP
D) ARRAY

INDEX Function

A function in spreadsheet software like Excel that returns the value of an element in a table or array, selected by the row and column number indexes.

  • Employ Excel formulas and functions for data manipulation and retrieval.
verifed

Verified Answer

SN
Shina NguyenMay 31, 2024
Final Answer :
A
Explanation :
The INDEX function is specifically designed to return the value from a range of data at a specified row and column intersection. MATCH is used to find the position of a specified value within a range and LOOKUP is used to search for a value within a range and return a corresponding value from another column. ARRAY is not a specific function, but can refer to an array formula or an array of values in Excel.