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
Correct Answer:

Verified
Correct Answer:
Verified
Q24: In a MATCH function, if match_type =
Q25: Use the data given below to
Q26: The Excel function of is used to
Q27: To find the number of orders with
Q28: Using a $ sign before a column
Q30: Which of the following functions is a
Q31: Which of the following is a difference
Q32: Give the logical function for the following:
Q33: is a logical function that returns one
Q34: The reflects the opportunity costs of spending