Exam 19: Using Powerful Excel Functions

When you use the VLOOKUP function, you will need to enter information into the ____ dialog box.

As you are typing a range name into a formula, ____.

The VLOOKUP function finds data when it is displayed horizontally in the lookup table.

Excel does not accept spaces in named ranges.

The Lookup & Reference button is found on the ____ tab.

To use the HLOOKUP function, you will need to enter information into the ____________________ dialog box.

Figure EX 13-1 In Figure EX 13-1 above, item 1 points to the ____.

Named ranges are helpful if you need to use a range in several functions.

You will use the ____ function to see how many cells do not contain data.

Table_array is the range of cells for a lookup table.

The ____________________ lets you control the calculation that the Subtotal function performs.

To find the total number of cells that have numeric data, you use the ____________________ function.

You can count cells that have text with the COUNT function.

The ____ function locates data when it is displayed vertically in the lookup table.

You can use the ____ function to get the total amount for data in a range of cells.

The Subtotal function is ____.

The ____ function can count cells if they contain text or a combination of text and numbers.

Use the ____ function when the data in the lookup table is listed horizontally in rows.

The VLOOKUP function is found on the ____________________ list.

Explain why you might need to use the Subtotal function, instead of the COUNT function, when dealing with filtered data.