Given that the table/worksheet is not given, here is how to use a slicer to filter the data on a worksheet to depict only rows where the category value required exists:
- Click Design; then
- Click Tools; then
- Click Insert Slicer; next
- Select Category checkbox
- Click multiselect; then
- Select everything EXCEPT Coffee/Meals.
<h3>What is a filter on excel?</h3>
You may use the FILTER function to filter a set of data depending on the criteria you provide.
Filters and filter view aid in the analysis of data in a spreadsheet. Filters may be used to: Display a specified filter when someone opens your spreadsheet. After employing a filter, sort your data.
As the name implies, data filtering can assist you in removing unnecessary data. For example, if you want to find the total number of records in a dataset that contains two different types of fields, such as integers and strings, you can use data filtering to remove all records that contain either type of field.
Learn more about slicer:
brainly.com/question/19717692
#SPJ1
