Chapter 5 Quiz

Ranges can be named in Excel to make it easier to reference the worksheet when using formulas or functions. A. TRUE B. FALSE

A. TRUE

The ISBLANK function returns a value of TRUE or FALSE. A. TRUE B. FALSE

A. TRUE

The lookup_value argument in a VLOOKUP or HLOOKUP function is often a number, text, a logical value, or a cell reference...but the lookup_value argument can also be a formula. A. TRUE B. FALSE

A. TRUE

To specify an "Exact Match" vlookup, enter the word False into the range_lookup argument of the vlookup function. A. TRUE B. FALSE

A. TRUE

In order to correctly use an "exact match" VLOOKUP function, the values in the first column of the lookup table must be sorted in ascending order. A. TRUE B. FALSE

B. FALSE

The ISERR function refers to any error value (#N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL!). A. TRUE B. FALSE

B. FALSE

The ISERROR function refers to any error value except #N/A. A. TRUE B. FALSE

B. FALSE

The range_lookup argument of the VLOOKUP and HLOOKUP functions is the range of values to be looked up in order to determine the function's result. A. TRUE B. FALSE

B. FALSE

Values in a "closest match" vlookup table must be sorted in descending order so that the VLOOKUP function can make accurate comparisons. A. TRUE B. FALSE

B. FALSE

When using VLOOKUP or HLOOKUP to look up a number that can fall within a range of values, you should be using an "Exact Match" lookup. A. TRUE B. FALSE

B. FALSE

You can only use the VLOOKUP and the HLOOKUP formulas to retrieve data stored in lookup tables on the same worksheet. A. TRUE B. FALSE

B. FALSE

The function =HLOOKUP(F12,$A$3:$D$10,3,TRUE) retrieves the value from the third column of the lookup table. A. TRUE B. FALSE

B. FALSE The function =HLOOKUP(F12,$A$3:$D$10,3,TRUE) retrieves the value from the third ROW of the lookup table.

When entered in a worksheet named Forecast, the formula =Costs!B5*C5 multiples the value in cell B5 of the "Costs" worksheet by the value in cell C5 of the "Costs" worksheet. A. TRUE B. FALSE

B. FALSE When entered in a worksheet named Forecast, the formula =Costs!B5*C5 multiples the value in cell B5 of the "Costs" worksheet by the value in cell C5 of the "Forecast" worksheet.

A LOOKUP function is used to retrieve a value from _____. A. a row B. a column or row C. None of the answers listed. D. a column E. an index

B. a column or row

For the VLOOKUP function, the _____ is the data to be looked up. A. range_lookup B. lookup_value C. table_array D. None of the answers listed. E. col_index_num

B. lookup_value

The _____ argument of the VLOOKUP function is the type of lookup...the value should be either TRUE or FALSE. A. lookup_type B. range_lookup C. None of the answers listed. D. col_index_num E. lookup_value

B. range_lookup

A data list that categorizes values for retrieval is a(n) _____ table. A. None of the answers listed. B. data C. lookup D. index E. category

C. lookup

Use _____ to check whether a specified reference or formula returns an empty cell. A. None of the answers listed. B. ISNONTEXT C. ISNA D. ISBLANK E. ISEMPTY

D. ISBLANK

The "V" in VLOOKUP stands for _____. A. None of the answers listed. B. Virtual C. Visual D. Vertical E. Vector

D. Vertical

The VLOOKUP function "looks up" a value and evaluates (compares) it against values in a lookup_table (the "key data") in order to return a matching "answer." When constructing a table_array to be used as lookup reference table, the "key data" should be placed in the _____. A. heading B. None of the answers listed. C. rightmost column D. leftmost column E. column specified by the col_index_num

D. leftmost column The VLOOKUP function "looks up" a value and evaluates (compares) it against the values (key data) in the leftmost column of a table_array. The VLOOKUP function returns a matching answer from the table_array by pulling it from the column specified by the col_index_num.

Use the _____ function to retrieve a value from a table based on the row and column numbers specified. A. None of the answers listed. B. VLOOKUP C. LOOKUP D. HLOOKUP E. INDEX

E. INDEX The INDEX function returns the value of an element in a table or an array selected by the row and column number indexes. (The LOOKUP function returns a value either from a one-row or one-column range.)

The number of the column containing the data you want to retrieve for the VLOOKUP function is the _____. A. range_lookup B. lookup_value C. None of the answers listed. D. row_index_value E. col_index_num

E. col_index_num

When using a VLOOKUP function, the first column of the lookup table that contains the data you are comparing to your "lookup_value" is/are called the _____. A. source values B. target values C. None of the answers listed. D. range_lookup E. key data

E. key data

The function =HLOOKUP(F16,Discounts,2,TRUE) retrieves the value in _____. A. row 16 of the worksheet B. column F of the worksheet C. None of the answers listed. D. column 2 of the table array E. row 2 of the table_array

E. row 2 of the table_array