Question

Filter the data in place so that only rows where the category value is meals and the cost value is greater than 20 are shown. the criteria range has been set up for you in cells a1:c2.

Answer 1

Explanation:

To find :

Filter the data in order such that only rows where the sum of the type is food and the sum of the amount is greater than 20 are displayed. The selection of requirements has been set for you in cells a1:c2.

Now,

You clicked the Advanced button on the Data Ribbon Tab in the Sort & Filter Ribbon Section.

You tapped on cell A1.

You pressed the OK button in the Advanced Filter window.