Ask Question
5 May, 03:05

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.

+4
Answers (1)
  1. 5 May, 03:31
    0
    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.
Know the Answer?
Not Sure About the Answer?
Find an answer to your 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 ...” in 📗 Business if the answers seem to be not correct or there’s no answer. Try a smart search to find answers to similar questions.
Search for Other Answers