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 smallest value in the list without going over the value of A3.
B) The match would be the greatest value in the list that is less than or equal to the value of A3.
C) The match would be an exact match to A3.
D) The match would be A3-1.

A

Computer Science & Information Technology

You might also like to view...

Variables should be declared as fields only if ________.

a. they are local variables b. they are used only within a method c. they are required for use in more than one method or their values must be saved between calls to the class’s methods d. they are arguments

Computer Science & Information Technology

Modify your solution to Exercise 20.8 to determine when the game is over, then prompt the user to determine if they would like to play again. If so, scramble the numbers.

What will be an ideal response?

Computer Science & Information Technology