What is the purpose of the Row_num argument in the following INDEX function? =INDEX(A2:B5,MATCH(MAX(B2:B5),B2:B5,0),1)
A. To return the highest value in the range B2:B5
B. To return the position of the highest value in the range B2:B5
C. To return the column to the left of the highest values in the range B2:B5
D. To return the row of the highest value in the range B2:B5
Answer: B
You might also like to view...
Which type of website would StumbleUpon be classified as?
a. Crowdfunding site b. Live bookmarking site c. Metasearch site d. Social bookmarking site
When a query is saved, the records reside in the related table; only the ________ of the query is saved
Fill in the blank(s) with correct word
Right-clicking opens a shortcut menu
Indicate whether the statement is true or false
Write a program that plays the game of “guess the number” as follows: Your program chooses the number to be guessed by selecting an integer at random in the range 1 to 1000. The program then displays the following:
I have a number between 1 and 1000. Can you guess my number? Please type your first guess. The player then types a first guess. The program responds with one of the following: 1. Excellent! You guessed the number! Would you like to play again (y or n)? 2. Too low. Try again. 3. Too high. Try again. If the player’s guess is incorrect, your program should loop until the player finally gets the number right. Your program should keep telling the player Too high or Too low to help the player “zero in” on the correct answer.