In Microsoft Excel, what is the “INDEX” function used for?
- it is used to sort the data in an ascending order
- it is used to sort the data in a descending order
- it is used to return a value or the reference to a value from within a table or range
- it is used to auto sum the values in a given range
| Answers Explanation & Hints:
The Microsoft Excel INDEX function is a built-in function that is categorized as a Lookup/Reference tool. It is used to return a value or the reference to a value from within a table or range. |