1- What is the recommended way to create a new PivotTable style that is close to an existing style?

1. Duplicate the existing style and then Modify the new style.
2. Apply the existing style to your PivotTable and then change the PivotTable cells' formatting.
3. Write down the existing style's settings and use them as the base for the new style.
4. Modify the existing style.

2- Why might your PivotTable include values that were NOT part of a data list you meant to use to create the PivotTable?

1. The extra values were left over from the most recent PivotTable and will disappear when the PivotTable is refreshed.
2. The extra values were stored on another worksheet in the workbook where you created the PivotTable.
3. The extra values were in a row or column next to the data list.
4. The extra values were stored elsewhere on the worksheet that contains your data list.

3- If you have the Product Category and Sales Region fields in the Rows area in that order, how will the first set of PivotTable's results be organized?

1. A row with sales by Sales Region for the first Product Category.
2. A column with sales by Sales Region for the first Product Category.
3. A row with sales by Product Category for the first Sales Region.
4. A column with sales by Product Category for the first Sales Region.

4- Why would you use Data Bars with a Pivot Table?

1. to highlight the values of data in a cell
2. to horizontally display the relative magnitude of values in a cell
3. to highlight the relative magnitude of values in a cell
4. to horizontally display the values of data in a cell