Quiz

  1. 1
    Intermediate

    You’ve added a new filter to filter your Sales Category on your PivotTable. When you go to use it, you notice that you can only filter by a single category, but you’d like to select Bottled Beer, Canned Beer and Draft Beer. How can you fix this?

  2. 2
    Intermediate

    Assume you had a PivotTable filtered as shown below, and you wanted to select only the Canned Beer category. What would be the most efficient method to do so?

  3. 3
    Intermediate

    What steps would you need to take to set up your filters to appear as shown below, providing you’d added them to your report filters area in the following order: Category, Class, Week, POSChitHour and POSChitMinute?