Quiz

  1. 1
    Intermediate

    If we created a new PivotTable and formatted it as follows, but never changed any of the default settings, what would you expect to happen if you updated this PivotTable? (Assume that we are simply performing a refresh, and that no additional data has been added to our data source.)

  2. 2
    Intermediate

    Assume we have the PivotTable shown below. What PivotTable Options setting(s) would we have to change from default settings in order to ensure that the columns did not resize on update, and to preserve the highlighting on the Food Modifiers row?

  3. 3
    Intermediate

    Assume we have the PivotTable shown below. What PivotTable Options setting(s) would we have to change from default settings in order to ensure that the columns did not resize on update, and to clear the highlighting on the Food Modifiers row?