Solved

Match Each Term with Its Correct Description

Question 79

Matching

Match each term with its correct description.

Premises:
Conditions entered on different lines in an advanced filter
Conditions entered on the same line in an advanced filter
To display only the records that meet the criteria you specify
Wildcard to specify a series of characters
Place a copy of a filtered table in a range that you specify in the Advanced Filter dialog box
Wildcard to specify a single character
Used in an advanced filter to specify conditions for the filter
Responses:
extract
And
*
Criteria range
(?)
Or
AutoFilter

Correct Answer:

Conditions entered on different lines in an advanced filter
Conditions entered on the same line in an advanced filter
To display only the records that meet the criteria you specify
Wildcard to specify a series of characters
Place a copy of a filtered table in a range that you specify in the Advanced Filter dialog box
Wildcard to specify a single character
Used in an advanced filter to specify conditions for the filter
Related Questions