Quiz

  1. 1
    Intermediate

    The following PivotTable is configured with Category on rows, Week on columns and Units on Values. You’d like to change the PivotTable so that it displays with no decimal places. How should you modify it to make that happen?

  2. 2
    Intermediate

    This PivotTable looks like it has holes in it. How would we fix that and plug the empty cells with 0?

  3. 3
    Intermediate

    The PivotTable below shows an excerpt from a PivotTable including cells in the Values area which are numeric, blank and errors. What will happen if we change the PivotTable options as follows: For error values show: <blank> For empty cells show: 0