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 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 https://brainly.com/question/18305399
