Question

the feature that allows you to specify the criteria for filtering the data in the worksheet ​

Answer 1

Explanation:

In the Sort & Filter group of the Data ribbon, there is an Advanced icon, which evokes the Advanced Filter dialog box. This dialog box allows you to set a particular criteria, copy results to another location (other location must be in the same sheet), and capture unique values.

Answer 2

In the Sort & Filter group of the Data ribbon, there is an Advanced icon, which evokes the Advanced Filter dialog box. This dialog box allows you to set a particular criteria, copy results to another location (other location must be in the same sheet), and capture unique values.