Question 1

Match between columns
                        Premises: The value that Excel will look for in the first column of the lookup table.
A requirement that needs to be met.
The range of cells for the lookup table.
A number that represents a calculation in the Subtotal function.
The range of data you create in either a vertical or horizontal format, which Excel will use to match against the criteria.

Accepted Answer

The Answer of Table_array and lookup table and function number is...

Question 2

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

Accepted Answer

The answer of Explain why you might need to use...

Question 3

The VLOOKUP function is found on the ____________________ list.

Accepted Answer

The answer of The VLOOKUP function is found on the...

Question 4

The SUMIF function is another form of the ____________________ function.

Accepted Answer

The answer of The SUMIF function is another form of...

Question 5

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

Accepted Answer

The answer of To use the HLOOKUP function, you will...

Question 6

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

Accepted Answer

The answer of The ____________________ lets you control the calculation...

Quiz 19: Using Powerful Excel Functions

Identify the letter of the choice that best matches the phrase or definition.

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

The VLOOKUP function is found on the ____________________ list.

The SUMIF function is another form of the ____________________ function.

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

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