$8.$ Refresh the data source so that it displays accurate data, including the new record you added to the Orders table.

$9.$ Sandra wants to display the average discount for each product rather than the sum of discount values in the Products PivotTable.

Modify the Products PivotTable as follows:

a$.$ Change the Value Field Settings for the Sum of Discount values to determine the Average discounts.

b$.$ Use Average Discount as the custom field name, which appears as the column heading.

c$.$ Apply the Percentage number format with $\backslash (\backslash$mathbf$\{1\}\backslash )$ decimal place.

$10.$ Sandra wants to change the format of Average Discounted Price values, which are difficult to interpret.

Modify the Average Discounted Price values by applying the Currency number format with $2$ decimal places and the $\backslash$$ symbol so that these values are easier to understand.

$11.$ Go to the Monthly Sales worksheet, which contains a PivotTable named MonthlySales. Sandra wants to provide another way to visualize this data.

Create a PivotChart as follows:

a$.$ Create a Clustered Column PivotChart based on the MonthlySales PivotTable.

b$.$ Move and resize the PivotChart so that its upper$-$left corner is within cell A$20$ and its lower$-$right corner is within cell G$38.$

c$.$ Add the title Monthly Sales to the PivotChart in the above position.

d$.$ Apply Layout $3$ to the PivotChart to display the legend at the bottom of the chart area.

$12.$ Add a slicer to the PivotChart as follows to make it easy for Sandra to filter the data:

a$.$ Add a slicer to the PivotChart based on the Region field.

b$.$ Position the slicer so that its upper$-$left corner is within cell H $20$ and its lower$-$right corner is within cell J$33.$

$13.$ Sandra thinks the Midwest quantity amount for September seems high. Examine the details of this amount as follows:

a$.$ Drill down into the Midwest quantity amount for September to display the details of the sales on a new worksheet. $($Hint: Double$-$click the amount.$)$

b$.$ Use Sep Midwest as the name of the new worksheet.

$14.$ Go to the Region PivotChart worksheet, which shows the May product orders in the Pacific region based on the data in the Regions worksheet. Sandra wants to compare all the product order amounts, not just those for May.

Modify and format the PivotChart as follows to show all months:

a$.$ Refresh the PivotChart to make sure it contains updated order information.

b$.$ Change the PivotChart filter to compare data for all months. $[$Mac Hint: Deselect the date filter to perform this step.$]$

c$.$ Apply Style $\backslash (\backslash$mathbf$\{10\}\backslash )$ to the PivotChart to display the data more clearly.