7. Add a slicer to the table so you can filter by shoe name. Use the slicer to display data for the Avone shoe only. Notice the effect on the chart. 8. Create a PivotTable from the data in the Sales worksheet. Use the Sum of Price per Pair by Region recommended Pivot Table. a. Modify the PivotTable so the Price Per Pair data are averaged, not totaled. b. Add the Shoe field to the PivotTable. It should appear in the Rows section below the Region field. c. Format all the values in the PivotTable using the Accounting Number Format. 9. Create a column PivotChart based on the PivotTable data. Use the first recommended column chart type. a. Hide the chart title and legend. b. If necessary, move the PivotChart on the worksheet so it does not cover the PivotChart data. 10. Go to the By Region worksheet and add Column Sparklines in F3:F7 for data in columns B3:E7. 11. You have been told you will receive a commission between 5 and 10 percent On the Commission sheet, make a one-variable data table using cells A4:B14 to determine how much that commission may be. The column input cell is A4. 12. You owe $12,000 in student loans and would like to pay it all off with your commissions. Use Goal Seek to determine the amount you must sell (cell G5) in order for cell G3 (your commission) to equal $12,000 so you can fully pay off your student loans. Accept the Goal Seek solution