Which is the Array argument in =INDEX(A2:B5,MATCH(MAX(B2:B5),B2:B5,0),1)?

A. MAX(B2:B5)
B. MATCH(MAX(B2:B5),B2:B5,0)
C. 1
D. A2:B5

Answer: D

Computer Science & Information Technology

You might also like to view...

You can reopen the Excel worksheet and edit the chart's data by clicking the ____ button (CHART TOOLS DESIGN tab | Data group).

A. Open Worksheet B. Open Chart C. Edit Data D. Edit Worksheet

View
Computer Science & Information Technology

Cite some examples of integrity constraints that you think can apply to the database shown in Figure 1.2.

What will be an ideal response?

View
Computer Science & Information Technology

The STP root switch is the switch with the lowest numeric value for the ________

A) Cost B) Primary ID C) Router ID D) Bridge ID

View
Computer Science & Information Technology

The location of an open file in relation to other folders in a website is called the ____.

A. index B. path C. title D. place

View
Computer Science & Information Technology