GoSkills
Back to lesson
Question
1
of
3
1. Suppose cells A1:A4 contain these values: 10, 20, 30, 40. What does the formula =VLOOKUP(15,A1:A4,1,TRUE) return?
20
#N/A
10
Don’t know
2. Suppose cells A1:A4 contain these values: 10, 30, 20, 40. What does the formula =VLOOKUP(25,A1:A4,1,TRUE) return?
30
20
10
Don’t know
3. Suppose cells A1:A4 contain these values: 10, 40, 20, 30. What does the formula =VLOOKUP(42,A1:A4,1,TRUE) return?
40
30
10
Don’t know
Quiz progress
Previous
question
Next
question
Submit
answers
Back to the top
© 2017 GoSkills Ltd.
Skills for career advancement