1. 1

    Suppose you’ve added a field containing numbers into the values area of a PivotTable, but the display is not to your liking. Which is the best method to update the number format in the PivotTable?

  2. 2

    By default, Excel automatically adjusts column widths on a PivotTable to fit the data. (This is to avoid seeing ### symbols when a number is too large to be displayed in the cell.) If you don’t want this to happen, how do you turn it off?

  3. 3

    By default, Excel adds subtotals to PivotTables when value fields are added. How do you make subtotals appear at the bottom of the applicable groups?