Quiz

  1. 1
    Beginner

    In the data set below, the PivotTable is showing the Class (Alcohol) and the Categories (Bottled Beer, Canned Beer, etc…) on rows. What steps did the author take in order to group the data this way?

  2. 2
    Beginner

    Assume you have a data source that has a single column full of dates, as shown below. You’d like to use this column but display your PivotTable with Months on rows and Years on columns. Since you have over 500,000 rows of data in the table, you’d like to keep your file working as quickly as possible, so you…

  3. 3
    Beginner

    How do you completely remove a grouping level that you’ve set up?