GoSkills
Back to lesson
Question
1
of
3
1. Suppose there is a small table with these values for the cells: A1 = A, A2 = B, B1 = C, C1 = D. What does the formula =INDEX(A1:B2,2,1) return?
D
C
B
Don’t know
2. Suppose cells A1:A4 contain these values: Fred, Joe, Mary, John. What does the formula =MATCH(“joe”,A1:A4,FALSE) return?
2
Joe
#N/A
Don’t know
3. Suppose cells A1:D1 contain these values: Fred, Joe, Mary, John. What does the formula =HLOOKUP(“joe”,A1:D1,1,FALSE) return?
#N/A
Joe
2
Don’t know
Quiz progress
Previous
question
Next
question
Submit
answers
Back to the top
© 2018 GoSkills Ltd.
Skills for career advancement