extracts an entry from a given row and column of a rectangular array of cells. The syntax of the INDEX function is =INDEX(array, r, c.). Then the INDEX function returns the entry in row r and column c of the given array.

🎲 Try a Random Question  |  Total Questions in Quiz: 113  |  🧠 Study this quiz with Flashcards
This question is part of a full practice quiz:
Harvard Spreadsheet Modeling — practice the complete quiz, review flashcards, or try a random question.


1. extracts an entry from a given row and column of a rectangular array of cells. The syntax of the INDEX function is =INDEX(array, r, c.). Then the INDEX function returns the entry in row r and column c of the given array.