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.

Explanation:

Step1: Select data range

Select the range of cells that contains the data (likely including columns for Date, Category, Cost, e.g., A1:C[last row with data]).

Step2: Access filter tool

Go to the "Data" tab in Excel (or corresponding data manipulation section in other spreadsheet software) and click on the "Filter" button. This will add filter arrows to the header of each column.

Step3: Set Category filter

Click on the filter arrow in the "Category" column header. In the filter menu, uncheck all categories except "Meals" and then click "OK".

Step4: Set Cost filter

Click on the filter arrow in the "Cost" column header. Choose the "Number Filters" (or similar option for numerical filtering) and then select "Greater Than". In the dialog box, enter 20 as the value and click "OK".

Step5: Verify filtered data

The spreadsheet will now display only the rows where the Category is "Meals" and the Cost is greater than 20. Check the cells A1:C2 (or the relevant range) to ensure the criteria range is set up correctly and the filtered data matches the requirements.

Answer:

To filter the data:

1. Select the data range (e.g., A1:C[last data row]).
2. Apply filter (via "Data" tab → "Filter").
3. Filter "Category" to "Meals".
4. Filter "Cost" to "Greater Than 20".
5. Verify the filtered rows (only Meals with Cost >20 are shown).

(The final filtered data will display rows meeting both criteria; specific rows depend on the full dataset, but the process follows these steps.)