GoSkills
Back to lesson
Question
1
of
3
1. Suppose cells A2:B20 contain a table with product numbers in column A and product prices in column B. What does the formula =VLOOKUP(A25,A2:B20,2,FALSE) return?
The price for the product in column A if the exact product number corresponding to A25 can be found, or the price for the closest product if the exact product number can't be found.
The number for the product in column A if the exact product number corresponding to A25 can be found, or #N/A if not.
The price for the product in column A if the exact product number corresponding to A25 can be found, or #N/A if not.
Don’t know
2. Suppose cells A2:B20 contain a table with product numbers in column A and product prices in column B. What does the formula =VLOOKUP(A25,A2:B20,1,FALSE) return?
The price for the product found in column A (or #N/A if the exact product number can't be found).
The number for the product in column A (or #N/A if the exact product number can't be found).
The price for the product found in column A (or the closest product if the exact product number can't be found).
Don’t know
3. Suppose cells A2:B20 contain a table with sorted product numbers in column A and product prices in column B. What does the formula =VLOOKUP(A25,A2:B20,2) return?
The price for the product found in column A (or the closest product if the exact product number can't be found).
The product number for the product in column A (or the closest product if the exact product number can't be found).
The price for the product found in column A (or #N/A if the exact product number can't be found).
Don’t know
Quiz progress
Previous
question
Next
question
Submit
answers
Back to the top
© 2017 GoSkills Ltd.
Skills for career advancement