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.
Answer: D
Computer Science & Information Technology
You might also like to view...
The ________ finds records in one table that do not have related records in another table
A) crosstab query B) Find Unmatched Query Wizard C) append query D) Find Duplicates Query Wizard
Computer Science & Information Technology
This vector function returns true if the vector has no elements.
a. has_no_elements b. null_size c. empty d. is_empty
Computer Science & Information Technology