Quiz

  1. 1
    Beginner

    Assuming we have two separate tables: one contains sales records, and the other contains details on the cost of the products sold. We want to use them in a standard Excel PivotTable… what do we need to do?

  2. 2
    Beginner

    Assume we have the table of data shown below serving our PivotTable. We’d like to report the Total Sales $ for all products sold. Which is the easiest way to make this happen?

  3. 3
    Beginner

    Assume you have a data set that is 4,000 rows long, and you need to add 16 columns of variations to display the data correctly in your PivotTable. What is the biggest drawback to this approach?