Asked by Leticia Miranda on May 25, 2024
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.
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.
Learning Objectives
- Employ Excel formulas and functions for data manipulation and retrieval.
Related questions
An Excel Table Contains Columns Named Salary and Commission ...
Ned Has a Table with an Expenses Column Listing Monthly ...
You Can Click the Logical Button (FORMULAS Tab | Function ...
Assigns a Value to a Cell Based on a Logical ...
Clicking the Create Function Box Opens the Function Arguments Dialog ...