Solved

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

Correct Answer:

verifed

Verified

Unlock this answer now
Get Access to more Verified Answers free of charge

Related Questions

Q3: Explain the different Lookup functions in Excel.

Q4: Use the data given below to

Q5: To use the VLOOKUPlookup_value, table_array, col_index_num), the

Q6: ANDcondition 1, condition 2…) is a logical

Q7: In a database file, which is organized

Q9: In a MATCH function, if match_type =

Q10: is a logical function that returns one

Q11: Use the data given below to

Q12: In a MATCH function, the default value

Q13: Use the data given below to