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
Beginner
In the example, what formula might be in cell C9?
=IF(C$8<$C$4,$C$5,LOOKUP(C$8,$C$4:$H$5))
=IF(C$8<$C$4,$C$5,LOOKUP(C$8,$C$5:$H$5,$C$4:$H$4))
=LOOKUP(C$8,$C$4:$H$4,$C$5:$H$5)
Don’t know
2
Beginner
If lookup data is in ascending, rather than strict ascending, order (e.g. 1, 2, 3, 3, 3, 4, 5), how does the LOOKUP function behave when searching for one of the duplicate values?
LOOKUP references the first occurrence of the value
LOOKUP returns #N/A
LOOKUP references the last occurrence of the value
Don’t know
3
Beginner
In modeling, which of the following three functions is recommended for looking up data?
LOOKUP
VLOOKUP
HLOOKUP
Don’t know
Back to the top
© 2024 GoSkills Ltd.
Skills for career advancement