What is the purpose of the INDEX function in Excel? The INDEX function returns a value or a reference to a value from a table or range. The INDEX ...

What is the purpose of the INDEX function in Excel?

The INDEX function returns a value or a reference to a value from a table or range.
The INDEX function returns a reference to a cell or range of cells that is a specified number of rows and columns from a cell or range of cells.
The INDEX function is used to organize employee data in a spreadsheet.
a) Only I is correct.
b) Only II is correct.
c) Only III is correct.
d) I and II are correct.
e) I and III are correct.