GoSkills
Back to lesson
Question
1
of
3
1. A contiguous collection of cells with more than one row and more than one column is known as what?
An array
A cell
A vector
Don’t know
2. Using the range illustrated, what would the formula =INDEX(B4:G9,2,3) return?
10
9
14
Don’t know
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?
=INDEX(A1:A5,,3)
=INDEX(A1:A5,1,3)
=INDEX(A1:A5,3)
Don’t know
Quiz progress
Previous
question
Next
question
Submit
answers
Back to the top
© 2017 GoSkills Ltd.
Skills for career advancement