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
Advanced
Assume that you have a small table set up as follows: A1 = A, A2 = B, B1 = C, C1 = D. What will the following formula return? =INDEX(A1:B2,2,1)
D
C
B
Don’t know
2
Advanced
Assume that A1:A4 contains the following values: Fred, Joe, Mary, John. What will the following formula return? =MATCH(“joe”,A1:A4,FALSE)
#N/A
2
Joe
Don’t know
3
Advanced
Assume that A1:D1 contains the following values: Fred, Joe, Mary, John. What will the following formula return? =HLOOKUP(“joe”,A1:D1,1,FALSE)
Joe
#N/A
2
Don’t know
Back to the top
© 2024 GoSkills Ltd.
Skills for career advancement