Back to lesson
1. A contiguous collection of cells with more than one row and more than one column is known as what?
2. Using the range illustrated, what would the formula =INDEX(B4:G9,2,3) return?
3. The syntax for INDEX is =INDEX(Array, Row_Number, [Column_Number]). If you wanted to return the third cell in the row vector A1:A5, which of the following three formulae is all that is necessary?
Back to the top
© 2017 GoSkills Ltd.
Skills for career advancement