GoSkills
Back to lesson
Question
1
of
3
1. Assume we have the following values 10, 20, 30 ,40 in the range A1:A4. What will the following function return? =VLOOKUP(15,A1:A4,1,TRUE)
#N/A
10
20
Don’t know
2. Assume we have the following values 10, 30, 20 ,40 in the range A1:A4. What will the following function return? =VLOOKUP(25,A1:A4,1,TRUE)
30
10
20
Don’t know
3. Assume we have the following values 10, 40, 20 ,30 in the range A1:A4. What will the following function return? =VLOOKUP(42,A1:A4,1,TRUE)
30
40
10
Don’t know
Quiz progress
Previous
question
Next
question
Submit
answers
Back to the top
© 2017 GoSkills Ltd.
Skills for career advancement