Select individually columns G and J and change the column width to 10. Change the row height to 24 for the first row. Go to cell C101, read the questions, and type the correct answers in the respective highlighted cells in the range G102:6106. Do not copy and paste results from the subtotal rows. Type the numeric values rounded to the nearest whole number. Apply Accounting Number Format with zero decimal places to cell 6102. PivotTables help you analyze different perspectives of data. You will create a PivotTable using the Sales Data worksheet. Click the Sales Data worksheet and create a blank PivotTable on a new worksheet. Name the new worksheet PivotTable. Name the PivotTable Average City Prices. Part of the process is arranging and rearranging fields to provide the perspective to represent the data best. In addition, you want to display average values instead of total values. Place the City field in rows. the Selling Agent field in columns, and the Asking Price and Selling Price fields as values. Display averages rather than sums with Accounting Number Format with zero decimal places. Pivot the data by placing the City field below the Values field in the Columns area and moving the Selling Agent field to the Rows area. Now you want to focus on real estate data for only two cities. Add a filter to cell BB to display only Alpine and Cedar Hills. Go back to the Sales Data worksheet. You realize that a selling price is incorrect. Change the selling price for Number 40 from $140,000 to $1,400,000. Refresh the PivotTable