In a MATCH Function, If the Match_type = 0, Then

question 8

Multiple Choice

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