Question 1

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

Accepted Answer

A)  an error symbol 
B)  the LOOKUP wizard 
C)  the number 0 
D)  the number 100

Question 2

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

Accepted Answer

A) vertical lookup table 
B) horizontal lookup table 
C) LOOKUP function 
D) INDEX function 
E) MATCH function
F)CHOOSE function
G)IFERROR

Question 3

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

Accepted Answer

A)  the same worksheet 
B)  other worksheets 
C)  either a or b 
D)  neither a nor b

Question 4

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.

Accepted Answer

A)  first 
B)  second 
C)  third 
D)  fourth

Question 5

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.

Accepted Answer

A)  POSITION 
B)  LOOKUP 
C)  LINK 
D)  LIST

Question 6

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.

Accepted Answer

The answer of Use ____________________ when the first column of...

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

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

Accepted Answer

A)  asterisk (*) 
B)  question mark (?) 
C)  exclamation point (!) 
D)  dollar sign ($)

Question 9

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

Accepted Answer

A)  one 
B)  two 
C)  three 
D)  four or more

Question 10

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

Accepted Answer

The answer of The final argument of the VLOOKUP function...

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