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
Which of the following formulae would give the first month the Balance Sheet does not balance?
=MATCH(F4:Q4,INDEX(1,F13:Q13,0))
=INDEX(F4:Q4,MATCH(1,F13:Q13,-1))
=INDEX(F4:Q4,MATCH(1,F13:Q13,0))
Don’t know
2
Beginner
Which of the following statements is true?
INDEX, MATCH can be used to search arrays where the value sought is to the right or below the lookup value column or row
The INDEX and MATCH functions are often used together to perform lookups
It is often advantageous to use this combination in conjunction with the LOOKUP family of functions
Don’t know
3
Beginner
Which formula calculates the oranges sold in Winter?
=INDEX(C5:E8,MATCH(B8,B5:B8),MATCH(D4,C4:E4))
=INDEX(C5:E8,MATCH(B8,B5:B8,0),MATCH(D4,C4:E4,0))
=INDEX(C5:E8,MATCH(D4,C4:E4,0),MATCH(B8,B5:B8,0))
Don’t know
Back to the top
© 2024 GoSkills Ltd.
Skills for career advancement