Question 1

You can only use a LOOKUP function when you want to retrieve a value that is stored ____ a key data row in a horizontal lookup table.

Accepted Answer

A)  above 
B)  below 
C)  either a or b 
D)  neither a nor b

Question 2

If the values you want to look up are in column B and the values you want to retrieve are in column A, you can use the ____ function.

Accepted Answer

A)  VLOOKUP 
B)  LOOKUP 
C)  either a or b 
D)  neither a nor b

Question 3

In an INDEX function, the argument ____ refers to the number of the row in the range referenced in the first argument.

Accepted Answer

A)  reference 
B)  row_num 
C)  column_num 
D)  area_num

Question 4

You cannot use VLOOKUP, HLOOKUP, or LOOKUP functions with a two-dimensional table.

Accepted Answer

A) True 
 B)False

Question 5

A ____ at the beginning of the formula indicates that Excel should display the results as a negative value.

Accepted Answer

A)  negative sign 
B)  double negative sign 
C)  (0) 
D)  none of the above

Question 6

The ISBLANK function checks whether a specified value refers to an empty cell. The syntax of this function is ____.

Accepted Answer

A)  =ISBLANK(value) 
B)  =ISBLANK(value,reference) 
C)  =ISBLANK(reference) 
D)  =ISBLANK(reference,value)

Question 7

The syntax of the INDEX function is as follows: INDEX(value,row_num,column_num,area_num). _________________________

Accepted Answer

A) True 
 B)False

Question 8

With the INDEX function, you can use a column_num of ____________________ to retrieve all the values in a specified row.

Accepted Answer

The answer of With the INDEX function, you can use...

Question 9

The table_array argument must contain ____ cell references so that the row values will not change when the formula is copied down the column.

Accepted Answer

A)  absolute 
B)  relative 
C)  simple 
D)  complex

Question 10

The INDEX function allows you to retrieve data from ____________________ tables.

Accepted Answer

The answer of The INDEX function allows you to retrieve...

Question 11

Case 5-1
  
Violet is learning how to use the MATCH function and is testing several different formulas. The chart above shows orders for small robot toys from five different customers. The amount "0" in column A is for a customer who changed his mind. Please answer the questions below using the data in the figure above.
-Violet is not sure if the Sales department is filling in the word "return" in uppercase or lowercase letters. What is the correct way to write "return" in a MATCH formula?

Accepted Answer

A)  return 
B)  RETURN 
C)  Return 
D)  It doesn't matter; the MATCH formula does not distinguish between upper- and lowercase letters.

Question 12

In the VLOOKUP function, if a type ____________________ is specified, an exact or approximate match is returned.

Accepted Answer

The answer of In the VLOOKUP function, if a type...

Question 13

The syntax of the HLOOKUP function is as follows: HLOOKUP(lookup_value,table_array,row_index_num,range_lookup).

Accepted Answer

A) True 
 B)False

Question 14

LOOKUP has both a TRUE and a FALSE lookup type.

Accepted Answer

A) True 
 B)False

Question 15

The LOOKUP function uses a ____ lookup type, so the column or row containing the lookup values must be in ascending order.

Accepted Answer

A)  TRUE 
B)  FALSE 
C)  both a and b 
D)  neither a nor b

Question 16

You can use a VLOOKUP formula and an HLOOKUP formula to retrieve data stored in lookup tables on the same worksheet.

Accepted Answer

A) True 
 B)False

Question 17

VLOOKUP searches for a matching value in the leftmost column of the table, and then retrieves the value ____.

Accepted Answer

A)  in the same row but in another column that you specify 
B)  in the same column but in another row that you specify 
C)  anywhere in the table 
D)  in the same row, in the very next column

Question 18

A data list that categorizes values you want to retrieve is called a ____ table.

Accepted Answer

A)  lookup 
B)  list 
C)  query 
D)  help

Question 19

One effective way to verify accuracy in a worksheet is to create an order with ____ set(s) of entries, and then systematically vary each entry to test each formula and cell that contains a value.

Accepted Answer

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

Question 20

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 ($)

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

You can only use a LOOKUP function when you want to retrieve a value that is stored ____ a key data row in a horizontal lookup table.

If the values you want to look up are in column B and the values you want to retrieve are in column A, you can use the ____ function.

In an INDEX function, the argument ____ refers to the number of the row in the range referenced in the first argument.

You cannot use VLOOKUP, HLOOKUP, or LOOKUP functions with a two-dimensional table.

A ____ at the beginning of the formula indicates that Excel should display the results as a negative value.

The ISBLANK function checks whether a specified value refers to an empty cell. The syntax of this function is ____.

The syntax of the INDEX function is as follows: INDEX(value,row_num,column_num,area_num). _________________________

With the INDEX function, you can use a column_num of ____________________ to retrieve all the values in a specified row.

The table_array argument must contain ____ cell references so that the row values will not change when the formula is copied down the column.

The INDEX function allows you to retrieve data from ____________________ tables.

In the VLOOKUP function, if a type ____________________ is specified, an exact or approximate match is returned.

The syntax of the HLOOKUP function is as follows: HLOOKUP(lookup_value,table_array,row_index_num,range_lookup).

LOOKUP has both a TRUE and a FALSE lookup type.

The LOOKUP function uses a ____ lookup type, so the column or row containing the lookup values must be in ascending order.

You can use a VLOOKUP formula and an HLOOKUP formula to retrieve data stored in lookup tables on the same worksheet.

VLOOKUP searches for a matching value in the leftmost column of the table, and then retrieves the value ____.

A data list that categorizes values you want to retrieve is called a ____ table.

One effective way to verify accuracy in a worksheet is to create an order with ____ set(s) of entries, and then systematically vary each entry to test each formula and cell that contains a value.

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