Quiz

  1. 1
    Intermediate

    How would you filter the PivotTable shown below to display only the Draft Beer category?

  2. 2
    Intermediate

    How would you filter the PivotTable shown below to display only the values for Week 5?

  3. 3
    Intermediate

    How would you filter the PivotTable shown below to display only the rows where the total of sales by category is greater than $1,000? (i.e. we want to keep Draft Beer, Wine and the Grand Total row only)