Question 1

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 2

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 3

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

Accepted Answer

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

Question 4

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 5

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
A)vertical lookup table
B)horizontal lookup table
C)LOOKUP function
D)INDEX function
E)MATCH function
F)CHOOSE function
G)IFERROR

Accepted Answer

The LOOKUP function is specifically designed to look up and return the value in a table or range that matches the lookup value provided. It searches for the greatest value that does not exceed the specified value, which is known as the approximate match mode.

Question 6

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 7

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
A)vertical lookup table
B)horizontal lookup table
C)LOOKUP function
D)INDEX function
E)MATCH function
F)CHOOSE function
G)IFERROR

Accepted Answer

A vertical lookup table is organized in columns where the data is searched.

Question 8

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 9

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 10

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

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
A)vertical lookup table
B)horizontal lookup table
C)LOOKUP function
D)INDEX function
E)MATCH function
F)CHOOSE function
G)IFERROR

Accepted Answer

The answer of MATCHING
Identify the letter of the choice that...

Question 13

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 14

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 15

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 16

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 17

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
A)vertical lookup table
B)horizontal lookup table
C)LOOKUP function
D)INDEX function
E)MATCH function
F)CHOOSE function
G)IFERROR

Accepted Answer

The answer of MATCHING
Identify the letter of the choice that...

Question 18

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 19

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
A)vertical lookup table
B)horizontal lookup table
C)LOOKUP function
D)INDEX function
E)MATCH function
F)CHOOSE function
G)IFERROR

Accepted Answer

The IFERROR function allows you to specify your own text when an error is encountered. It is used to handle errors that occur in Excel formulas by returning a predefined value or message when an error is detected.

Question 20

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

Accepted Answer

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

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