Toggle navigation
GoSkills
Courses
Courses
Train your organization
Supercharge your organization with expert-led business and productivity courses.
Learn more
Learn on your own
Earn certifications for the most in-demand skills with unlimited access to all GoSkills courses.
Learn more
Explore our courses
Browse our award-winning library of 110+ business and productivity courses delivered in bite-sized lessons.
Explore courses
LMS
Course builder
Resources
Pricing
Organization pricing
Individual pricing
Pricing
Search
Sign up
Log in
Log in
Signup
Quiz
1
Intermediate
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 #N/A if not.
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 the price for the closest product if the exact product number can't be found.
Don’t know
2
Intermediate
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 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 #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
Intermediate
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 #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)
The product number for the product in column A (or the closest product if the exact product number can't be found)
Don’t know
Back to the top
© 2024 GoSkills Ltd.
Skills for career advancement