Question 1

MATCHING
Identify the letter of the choice that best matches the definition of the word or phrase.
-Allows you to specify your own text when an error is encountered

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 2

Headings at the top of each column should be included as part of the lookup_range in the VLOOKUP formula.

Accepted Answer

A) True 
 B)False

Question 3

If a product or company has more than three or four pricing structures, a relational database, such as Microsoft ____________________, might be a better choice than using a spreadsheet program.

Accepted Answer

The answer of If a product or company has more...

Question 4

The INDEX function argument ____________________ refers to the number of the row in the range referenced in the first argument.

Accepted Answer

The answer of The INDEX function argument ____________________ refers to...

Question 5

A function named IFWRONG can be used in combination with the VLOOKUP function to simplify error checking. _________________________

Accepted Answer

A) True 
 B)False

Question 6

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 7

In a VLOOKUP function, the argument ____ refers to the number of the column containing the data you want to retrieve.

Accepted Answer

A)  lookup_value 
B)  table_array 
C)  col_index_num 
D)  range_lookup

Question 8

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

Accepted Answer

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

Question 9

When using the CHOOSE function, if the index_num argument is 2, the function returns ____.

Accepted Answer

A)  the first value from the list 
B)  the second value from the list 
C)  an error message 
D)  the first value that equals "2"

Question 10

With a ____ type of VLOOKUP, the function returns the greatest value that does not exceed the lookup value.

Accepted Answer

A)  FALSE 
B)  TRUE 
C)  complex 
D)  simple

Question 11

Unlike VLOOKUP, the RLOOKUP function looks up the greatest value that does not exceed a specified value anywhere in a table or range.

Accepted Answer

A) True 
 B)False

Question 12

With a ____ type of VLOOKUP, the function would look only for the exact match.

Accepted Answer

A)  FALSE 
B)  TRUE 
C)  complex 
D)  simple

Question 13

The H in HLOOKUP stands for ____.

Accepted Answer

A)  help 
B)  horizontal 
C)  historic 
D)  hit

Question 14

Excel provides nine functions, called the OF functions, that test a value or cell reference, and then return a TRUE or FALSE value depending on the results. _________________________

Accepted Answer

A) True 
 B)False

Question 15

The LOOKUP function has the ____ lookup type.

Accepted Answer

A)  TRUE 
B)  FALSE 
C)  either a or b 
D)  neither a nor b

Question 16

The INDEX function allows you to specify a list of nonadjacent ranges as the reference argument, and then specify which of these ranges to use in the ____ argument.

Accepted Answer

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

Question 17

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

Accepted Answer

The answer of The IS function where the value refers...

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

LOOKUP has both a TRUE and a FALSE lookup type.

Accepted Answer

A) True 
 B)False

Question 20

Write the correct syntax for the VLOOKUP function. Give a brief explanation of each of the four arguments that are included in VLOOKUP.

Accepted Answer

The answer of Write the correct syntax for the VLOOKUP...

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

MATCHING Identify the letter of the choice that best matches the definition of the word or phrase. -Allows you to specify your own text when an error is encountered

Headings at the top of each column should be included as part of the lookup_range in the VLOOKUP formula.

If a product or company has more than three or four pricing structures, a relational database, such as Microsoft ____________________, might be a better choice than using a spreadsheet program.

The INDEX function argument ____________________ refers to the number of the row in the range referenced in the first argument.

A function named IFWRONG can be used in combination with the VLOOKUP function to simplify error checking. _________________________

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.

In a VLOOKUP function, the argument ____ refers to the number of the column containing the data you want to retrieve.

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

When using the CHOOSE function, if the index_num argument is 2, the function returns ____.

With a ____ type of VLOOKUP, the function returns the greatest value that does not exceed the lookup value.

Unlike VLOOKUP, the RLOOKUP function looks up the greatest value that does not exceed a specified value anywhere in a table or range.

With a ____ type of VLOOKUP, the function would look only for the exact match.

The H in HLOOKUP stands for ____.

Excel provides nine functions, called the OF functions, that test a value or cell reference, and then return a TRUE or FALSE value depending on the results. _________________________

The LOOKUP function has the ____ lookup type.

The INDEX function allows you to specify a list of nonadjacent ranges as the reference argument, and then specify which of these ranges to use in the ____ argument.

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.

LOOKUP has both a TRUE and a FALSE lookup type.

Write the correct syntax for the VLOOKUP function. Give a brief explanation of each of the four arguments that are included in VLOOKUP.