Quiz

  1. 1
    Intermediate

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

  2. 2
    Intermediate

    By default, Excel automatically adjusts column widths on a Pivot Table 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
    Intermediate

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