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

Question

Quizplus · Accepted Answer

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.

The _____ Function Returns the Value from a Range of Data