The ____ option buttons in the Custom AutoFilter dialog box are used if you want to display rows and columns that meet two conditions for the field.
A)And and Not
B)If and Then
C)And and Or
D)If and While

Question

Quizplus · Accepted Answer

The "And" and "Or" option buttons in the Custom AutoFilter dialog box are used if you want to display rows and columns that meet one or more conditions for the field. The "And" and "Or" buttons are used to create compound criteria by combining two or more criteria together. Specifically, the "And" button is used to display rows that meet two or more criteria for the same field, while the "Or" button is used to display rows that meet one or more criteria for the same field. The other options listed do not accurately describe the functionality of the Custom AutoFilter dialog box.

The ____ Option Buttons in the Custom AutoFilter Dialog Box