Quiz

  1. 1
    Beginner

    What is the easiest way to create a PivotTable?

  2. 2
    Beginner

    Assume that our data source has only three fields: Class (containing Alcohol and Food), Category (Appetizers, Bottled Beer, etc…) and Sales $, how would you configure the Pivot Table shown below?

  3. 3
    Beginner

    An important concept of PivotTables is to realize that the data is not “live”. What is the fastest way to refresh the data in this PivotTable (only) to ensure that it is up to date?