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
Microsoft documents that the syntax for MATCH is =MATCH(Lookup_Value, Lookup_Array, [Match_Type]). What is wrong with this syntax as it is stated?
The syntax implies that Match_Type is optional. It must be specified.
Lookup_Array must be a vector not an array (i.e. the range must consist of either one row or one column)
The default value for Match_Type is 1, not 0. However, modellers typically require this value to be zero.
Don’t know
2
Beginner
The default setting of Match_Type in the MATCH function is 1. What does this mean?
The function will search for an approximate match (i.e. the smallest value greater than or equal to the value sought), provided the list is in strict descending alphanumerical order.
The function will search for the first exact match regardless of how the list is populated.
The function will search for an approximate match (i.e. the largest value less than or equal to the value sought), provided the list is in strict ascending alphanumerical order.
Don’t know
3
Beginner
In this example, the formula in cell F7 is =MATCH(F6,B6:B16). What value will the output take?
6
#N/A
5
Don’t know
Back to the top
© 2024 GoSkills Ltd.
Skills for career advancement