What type of match would the following function return when the lookup array is sorted in descending order? =MATCH(A3,B7:B53,-1)
A) The match would be the greatest value in the list that is less than or equal to the value of A3.
B) The match would be an exact match to A3.
C) The match would be A3-1.
D) The match would be the smallest value in the list without going over the value of A3.
Correct Answer:
Verified
Q7: Why would you nest MATCH in an
Q8: IF you use the function, =MATCH(66, A1:A4,0),
Q9: If 9/3/2021 is the contents of B3,
Q10: If you need to find out how
Q11: Which function returns a value at the
Q13: Which function returns the relative position of
Q14: When formated as a date, the results
Q15: If you need to find the day
Q16: What best describes a criteria range?
A)The table
Q17: Which is not an argument in an
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents