In a MATCH function, if the match_type = 0, then ________.
A. the function finds the largest value that is less than or equal to lookup_value
B. the function finds the smallest value that is greater than or equal to lookup_value
C. MATCH finds the first value that is exactly equal to lookup_value
D. the values in the lookup_array must be in a particular order
Answer:C
In a MATCH function, if the match_type = 0, then ________.
A. the function finds the largest value that is less than or equal to lookup_value B. the function finds the smallest value that is greater than or equal to lookup_value C. MATCH finds the first value that is exactly equal to lookup_value D. the values in the lookup_array must be in a particular order