The correct answer is: C. Find and select the value on which you want to base the filter and select tools>filter by selection from the menu.
To filter by selection, follow these steps:
- In the table, find the value that you want to use to filter the data.
- Select the value.
- On the Data tab, in the Sort & Filter group, click Filter.
- In the Filter by Selection list, click the value that you want to filter the data by.
The following are the other options and their explanations:
A. Right click the field value and select filter by selection from the shortcut menu. This option is incorrect because you need to select the value first before you can right-click it.
B. Find and double click the value on which you want to base the filter. This option is incorrect because you need to select the value first before you can double-click it.
D. None. This option is incorrect because it is not a valid way to filter by selection.