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

You use VLOOKUP when ____ of the lookup table contains the data you are looking up.

Internal values are those pieces of data that you know, such as customer names, quantities, or product descriptions. _________________________

In a LOOKUP function, the argument ____ refers to the data you want to look up.

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

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 Lookup function argument called lookup_vector is the location of the data you want to look up. _________________________

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.

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

When creating a range for use with a type FALSE VLOOKUP table, make sure to sort the values in the first column of table_array in ____ order.

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

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

The syntax of the CHOOSE function is as follows: =CHOOSE(index_num,value1,value2,…). _________________________

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

In a(n) two-dimensional table, Excel can search a row or column to find key data, and then use that data to locate the correct value. _________________________

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

Case 5-2 Mark is in charge of determining the unit pricing for each order for robot toys. Please refer to the chart above as you answer the questions below. -In the formula Mark is discussing with his co-worker, =VLOOKUP(Z10,H$1:I10,1,FALSE), the lookup_value is ____.

In a VLOOKUP function, the argument ____ refers to the data you want to look up.

The syntax of the VLOOKUP function is as follows: =VLOOKUP(lookup_value,table_array,col_index_num,____).

In an INDEX function, the argument ____ refers to the column in the range referenced in the first argument.

In a LOOKUP function, the argument ____ refers to the location of the data you want to look up.