1. 1

    When you drag a row field on to a PivotTable, it will sort in what order by default?

  2. 2

    You have two major product groups on your PivotTable: Food and Alcohol. Unhappy with Food showing up at the bottom, you manually drag it to the top of the PivotTable so it shows as below. Now the accountant adds a new major product group called “Sundries” to the source data. What will happen when you update the PivotTable?

  3. 3

    Assuming you have the PivotTable shown below. You right click cell B2 and choose to Sort by Z-A (Descending). What would happen?