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

If the lookup_value is less than the smallest value in the lookup_vector, LOOKUP displays ____.

MATCHING Identify the letter of the choice that best matches the definition of the word or phrase. -A lookup table in which the data to be searched is organized in columns

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

You can use the INDEX function to look up data stored in a single row, such as B3:E3, or a single column, such as B3:B7. In this case, you enter the range as the ____ argument.

As with the VLOOKUP and HLOOKUP functions with the TRUE lookup type, the ____ function looks for a value that matches the criterion by comparing values based on their position in the lookup table.

Use ____________________ when the first column of the lookup table contains the key data, and the information you want to retrieve is in one of the columns to the right of the key data column.

The rules for an HLOOKUP function with a TRUE lookup type test the values down the first column.

If you use a match_type of 0 (exact match), you can use the ____ to match any sequence of characters.

A VLOOKUP table can have ____ key value(s) in each cell of its first column.

The final argument of the VLOOKUP function is the ____________________ type, which can be TRUE or FALSE.