GoSkills
Back to lesson
Question
1
of
3
1. Assume that you have a small table set up as follows: A1 = A, A2 = B, B1 = C, C1 = D. What will the following formula return? =INDEX(A1:B2,2,1)
B
D
C
Don’t know
2. Assume that A1:A4 contains the following values: Fred, Joe, Mary, John. What will the following formula return? =MATCH(“joe”,A1:A4,FALSE)
Joe
2
#N/A
Don’t know
3. Assume that A1:D1 contains the following values: Fred, Joe, Mary, John. What will the following formula return? =HLOOKUP(“joe”,A1:D1,1,FALSE)
Joe
#N/A
2
Don’t know
Quiz progress
Previous
question
Next
question
Submit
answers
Back to the top
© 2017 GoSkills Ltd.
Skills for career advancement