I. Display the Sales Data worksheet. Insert the GETPIVOTDATA function in cell F$1$ to display the

overall average selling price from the PivotTable on the Selling Price worksheet. Format the

result with Accounting Number Format with $0$ decimal places.

m$.$ Create a column PivotChart from the PivotTable on the Selling Price worksheet. Move the

chart to a chart sheet named Sales Chart. Complete the following steps for the chart:

Change the chart title to Average Selling Price by City and apply Dark Blue font color.

Remove the legend.

Apply Dark Blue fill color to the data series.

n$.$ Save and close the file. Exit Excel. Based on your instructor's directions, submit:

e$05$m$1$RealEstate$\_$LastFirst