YOU want to tormat the PivotTable. Change the widths of columns A, B, C, D, and E to 11. Change the width of column F to 14 and the width of column G to 13.14. Wrap text and center horizontally data in cells B4, D4, F4, and G4. Apply the Bottom Border to the range B4:E4. Change the label in cell A5 to Agent. Change the height of row 4 to 40. You want to create another PivotTable to look at the selling prices by city. Display the Sales Data worksheet. Create a Recommended PivotTable using the Sum of Selling Price by City thumbnail. Note, Mac users, insert a PivotTable on a new worksheet. Add City to the Rows area and Selling Price to the Values area. Change the name of the new PivotTable worksheet to Selling Price. Change the value to display averages not sums. Apply the Accounting Number Format with zero decimal places to the values. Apply Light Blue, Pivot Style Medium 2 to the PivotTable. Note, depending upon the version of Office being used, the style name may be Pivot Style Medium 2. You decide to create a PivotChart to illustrate the PivotTable data visually. Create a clustered column PivotChart from the PivotTable on the Selling Price worksheet. Move the chart to a chart sheet named Sales Chart