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.