I need help with understanding

If necessary, move the chart so it does not cover the table data.

Add a slicer to the table so you can filter by shoe name. Use the slicer to display data for the Sperry shoe only.

Notice the effect on the chart.

Create a PivotTable from the data in the Sales worksheet. Use recommended PivotTable.

a$.$ Replace Sum of Total Sales field with the Price Per Pair field and modify it so that the data is averaged, not

totaled.

b$.$ Add the Shoe field to the Rows section. Delete the Sales Person field, then move the Region field to the Rows

Section.

c$.$

Format all the values in the PivotTable using the Accounting Number Format.

Create a clustered column PivotChart based on the PivotTable data.

a$.$ Hide the chart title and legend.

b$.$ If necessary, move the PivotChart on the worksheet so it does not cover the PivotChart data.

Go to the By Region worksheet and add Column Sparklines in F$3$:F$7$ for data in columns B$3$:E$7.$

On the By Region worksheet, create a pie chart to display the sales by region for the Sperry shoe.

a$.$ Display the data labels as data callouts.

b$.$ Hide the chart legend.

c$.$ If necessary, move the chart so it does not cover the table data.

You have been told that you will receive a commission between $5$ and $10$ percent. On the Commission sheet,

make a one$-$variable data table using cells A$4$:B$14$ to determine how much that commission may be based on

$$17,000$ in sales. The column input cell is A$4.$

You owe $$9,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 G$5)$ in order for cell G$3($your commission$)$ to equal $$9,000$ so you can