Quiz

  1. 1
    Intermediate

    Assume that you’ve added a field containing numbers into the values area of a PivotTable, and the display is not to your liking. What is the best way to update the number format on the PivotTable?

  2. 2
    Intermediate

    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.) If you don’t want this to happen, how do you turn it off?

  3. 3
    Intermediate

    By default, Excel adds subtotals to PivotTables when value fields are added. To show subtotals at the bottom of the applicable groups, what actions need to be taken?