Question 1

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 2

The ____________________ function returns the relative position of an item in a list, and can be used instead of LOOKUP, VLOOKUP, or HLOOKUP when you need the position of an item in a range instead of the item itself.

Accepted Answer

The answer of The ____________________ function returns the relative position...

Question 3

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, also known as a VLOOKUP table, organizes data in columns to be searched by the VLOOKUP function in Excel.

Question 4

With ____________________, you can specify your own text (or even a blank cell) when an error is encountered rather than the standard Excel message.

Accepted Answer

The answer of With ____________________, you can specify your own...

Question 5

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...

Question 6

You could write a formula using the ____________________ function to check whether cell A5 contains text.

Accepted Answer

The answer of You could write a formula using the...

Question 7

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 8

When using the MATCH function, the lookup_array must be enclosed in ____________________ if the values are not contiguous.

Accepted Answer

The answer of When using the MATCH function, the lookup_array...

Question 9

If you use an INDEX formula that refers to ranges on separate worksheets, Excel displays the ____________________ error.

Accepted Answer

The answer of If you use an INDEX formula that...

Question 10

The ISBLANK function checks whether a specified value refers to an empty cell. The syntax of this function is as follows: =ISBLANK(____________________).

Accepted Answer

The answer of The ISBLANK function checks whether a specified...

Question 11

The function =____________________(index_num,value1,value2,…) can return up to 254 values.

Accepted Answer

The answer of The function =____________________(index_num,value1,value2,…) can return up to...

Question 12

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

Accepted Answer

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

Question 13

MATCHING
Identify the letter of the choice that best matches the definition of the word or phrase.
-Looks up the greatest value that does not exceed a specified value anywhere in a table or range

Accepted Answer

The LOOKUP function is used to find the closest match to a given value in a set of data. It looks up the greatest value that does not exceed a specified value anywhere in a table or range.

Answer: D
 The INDEX function is used to return a value or reference of the cell at the intersection of a specified row and column in a table or range.

Both functions can be used for looking up values in a table or range, but LOOKUP function returns the closest match while INDEX function returns the value at a specific position.

Question 14

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

Accepted Answer

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

Question 15

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

The IFERROR function allows you to specify your own text to be displayed when an error is encountered in a formula.

Question 16

MATCHING
Identify the letter of the choice that best matches the definition of the word or phrase.
-Can return a value or a range for up to 254 different values

Accepted Answer

The CHOOSE function can return a value or a range for up to 254 different values based on an index number.

Question 17

MATCHING
Identify the letter of the choice that best matches the definition of the word or phrase.
-Allows you to retrieve data from multidimensional tables

Accepted Answer

The INDEX function allows you to retrieve data from multidimensional tables by specifying the row and column numbers of the cell you want to return.

Question 18

You can use the ____________________ function to test a cell reference. If the cell is blank, or empty, the function returns the value TRUE.

Accepted Answer

The answer of You can use the ____________________ function to...

Question 19

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

Accepted Answer

The answer of The LOOKUP function uses only a TRUE...

Question 20

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...

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