Use a slicer to filter the data in this table to show only rows where the Category value is Coffee or Meals.
Question
Use a slicer to filter the data in this table to show only rows where the Category value is Coffee or Meals.
Solution
-
First, select any cell within the table you want to filter.
-
Go to the "Insert" tab on the Ribbon, then click on "Slicer" in the Filters group.
-
In the "Insert Slicers" dialog box, check the box for "Category" and then click "OK".
-
A slicer will appear on your worksheet. It will list all the unique values in the Category column of your table.
-
In the slicer, click on "Coffee". Hold down the Ctrl key and click on "Meals". This will select both values.
-
The table will now only display rows where the Category is either "Coffee" or "Meals".
Remember, you can clear the slicer at any time by clicking on the icon in the top right corner of the slicer. This will show all data in the table again.
Similar Questions
By default, PivotTables display __________ data for each category. However, you may want to set a filter to exclude particular categories or values.Group of answer choicesAverage value ofMaximum value ofAggregated Minimum value of data
Pivot tables must have a row and column but don't have to have a filter category True False
Fill in the gaps in the HTML below to create the Table of data shown below._____________________________________________ <html lang="eng"><head> <title>Table </head><body> <table> <caption>Drink Preference by Age</caption> <tr><th>Preference</th> <td> </td> <td>25-29</td> <td>30-39</td> <td>40-49</td> <td>50-54</td> </tr> <tr><td>Cocao-Cola</td> <td>65</td> <td>41</td><td>55</td> <td>28</td> <td>46</td> </tr> <tr><td>Diet Coke</td> <td>2</td> <td>10</td> <td>13</td> <td>15</td> <td>8</td> </tr> <tr><td>Coke Zero</td> <td>9</td> <td>23</td> <td>19</td> <td>22</td> <td>28</td> </table> </html>
Which of the following is not applicable for a slicer?Group of answer choicesSlicer is used to filter data when a pivot table is based on multiple tablesSlicer provides a visual representation for easier manipulationOnly ONE slicer can be created for a pivot tableWe can define how many columns can be displayed in the slicer window PreviousNext
What is an Excel feature that displays only the data in column (s) according to specified criteria?Group of answer choicesFormulaPivotFilteringSorting
Upgrade your grade with Knowee
Get personalized homework help. Review tough concepts in more detail, or go deeper into your topic by exploring other relevant questions.