Quiz

  1. 1
    Beginner

    We have a PivotTable with the following configuration of fields: Class on Columns, Category and Item Name on Rows, and Amount on Values. Which options can we guarantee were changed from the default layout in order to display the PivotTable as shown below?

  2. 2
    Beginner

    We have a PivotTable with the following configuration of fields: Hours on Rows, Class on Columns and Amount on Values. What can we guarantee is true in the following setup?

  3. 3
    Beginner

    How did the author manage to display both the Sum and Average of the Amount column in the following PivotTable?