1. Your Pivot Table has the products you purchase in Column A, and Sum of Total Purchases in Column B. Which mistake do users often make when creating filters? Select an answer:

1. filtering by the values associated with the products
2. filtering by using Value Filters
3. filtering in Sum of Total Purchases
4. filtering by Begins With

2. When you create a formula by using = then clicking on a value cell in a Pivot Table, which action are you taking? Select an answer:

1. You are using the value shown in the cell in the formula you are defining.
2. You are using a shortcut instead of typing out the cell references by column and row numbers.
3. You are using the range of cells in the Pivot Table in the formula you are defining.
4. You are using the underlying data in the formula you are defining.

3. How would you arrange your PivotTable to show the quantity sold for each product and each products contribution to total quantity sold? Select an answer:

1. Use two copies of the same field and changing Show Values as to % of Column Total.
2. Drag the Quantity field to Values in the Field List area.
3. Drag the Unit Price field to Values in the Field List area.
4. Use two copies of the same field and dragging Quantity to Values in the Field List area.

4. You can change your PivotTables configuration so that subtotals _____. Select an answer:

1. appear below each subgroup
2. all of these answers
3. are not displayed at all
4. appear above each subgroup