GoSkills
Back to lesson
Question
1
of
3
1. Assume you have a table in cells A2:B20, which contains product numbers in column A and product prices in column B. What should you expect to be returned by the following formula? =VLOOKUP(A25,A2:B20,2,FALSE)
The product # for the product in column A (or #N/A if the exact product number cannot be found)
The price for the product found in column A (or the closest product if the exact product number cannot be found)
The price for the product found in column A (or #N/A if the exact product number cannot be found)
Don’t know
2. Assume you have a table in cells A2:B20, which contains product numbers in column A and product prices in column B. What should you expect to be returned by the following formula? =VLOOKUP(A25,A2:B20,1,FALSE)
The price for the product found in column A (or #N/A if the exact product number cannot be found)
The product # for the product in column A (or #N/A if the exact product number cannot be found)
The price for the product found in column A (or the closest product if the exact product number cannot be found)
Don’t know
3. Assume you have a table in cells A2:B20, which contains sorted product numbers in column A and product prices in column B. What should you expect to be returned by the following formula? =VLOOKUP(A25,A2:B20,2)
The price for the product found in column A (or the closest product if the exact product number cannot be found)
The price for the product found in column A (or #N/A if the exact product number cannot be found)
The product # for the product in column A (or the closest product if the exact product number cannot be found)
Don’t know
Quiz progress
Previous
question
Next
question
Submit
answers
Back to the top
© 2017 GoSkills Ltd.
Skills for career advancement