Question

When you use Advanced Filter/Sort to filter records using complex criteria, create the filter and then click the ____ button on the HOME tab to view the results.FilterSelectionAdvancedToggle Filter

Answer 1

Answer:

The correct answer to the following question will be "Toggle Filter".

Explanation:

• You could use the property Filter to get a filter and then add it later. Filters are stored along with the items they are produced in. When the object is opened they are automatically loaded but are not automatically applied.
• The Toggle Filter button shows the status of the property Filter and FilterOn. The button stays inactivated until a filter is applied. This button will appear pressed in when an active filter is currently being added.

Therefore, the "Toggle Filter" is the right answer.