Why would you nest MATCH in an INDEX function?

A) To find the highest or lowest value in an array
B) To use the value returned in the Match function as a lookup in the index function
C) To handle multiple outcomes
D) To use the position returned in the Match function as an argument in the index function


D

Computer Science & Information Technology

You might also like to view...

To freeze a row, select the cell below the row(s) you want to freeze, click the ____________________ button in the Window group and then click Freeze Top Row.

Fill in the blank(s) with the appropriate word(s).

Computer Science & Information Technology

The appointment being entered in the accompanying figure will be saved automatically when the user presses the ____ key.

A. TAB B. CTRL C. HOME D. ENTER

Computer Science & Information Technology

Answer the following statements true (T) or false (F)

1. Polymorphism is used extensively in commercial programming. 2. A method in a subclass can invoke a method in its base class. 3. A single method can return values that are of different data types. 4. A single method invocation may contain constants or variables, but not both. 5. No objects can be created of a base class that is an abstract class.

Computer Science & Information Technology

A mixture of programming language and human language is known as:

(a) Algorithms (b) Recipes (c) Directions (d) Pseudocode

Computer Science & Information Technology