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.

The data to be filtered can be done in an excel sheet and the method to filter data is explained as follows,

First we will select the cells that we need to filter, so in this case we will select the cells where data is put, All three columns will be selected A:C.

Then Click on Filter on Data Ribbon.

In the cost column select Number filter then select greater than, and then write the number 20 in order to get data which is greater than 20.

Learn more at link

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.

the answer is account d

it's obviously d. it could be c though.