Exam 5: Retrieving Data for Computation, Analysis, and Reference

The MATCH function is designed to return the relative position (such as 1, 2, or 3) of an item in a list. _________________________

When you use the HLOOKUP function, you specify the row_index_num. _________________________

In a VLOOKUP function, the argument ____ refers to the type of lookup you want to perform-TRUE or FALSE.

In the formula =IF(ISBLANK(A9)," ",VLOOKUP(A9,Products,2,FALSE)), if cell A9 is blank, Excel displays ____.

With the INDEX function, if you are using a noncontiguous range, you must enclose the entire reference in ____.

The V in VLOOKUP stands for velocity. _________________________

You can use VLOOKUP and HLOOKUP to retrieve data stored in lookup tables on ____.

The IS function where the value refers to a reference is ____________________.

When you write a VLOOKUP formula, you indicate the value you want to look up in a table.

In an INDEX function, the argument ____ refers to the part of a nonadjacent range referenced in the first argument.