Ms. Chavez has asked you to create a spreadsheet for three of the top Realtors for the past month. In the spreadsheet, she would like to be able to see the total sales by city and by realtor as well as the income to the Realtor and to Move NOW! at 4% each commission on each selling price. Sales are as follows: Murray Sold 8 houses in the cities shown at the prices below: Denver - 105,000 Brighton - 352,000 Louisville - 647,000 Aurora - 529,000 Lakewood - 272,000 Lafayette - 785,000 Lone Tree - 674,000 Broomfield - 426,000 Guled Sold 4 houses at the following prices: Lousiville - 738,000 Broomfield - 123,800 Aurora - 342,000 Thornton - 569,000 Jones Sold 5 houses at the following prices: Aurora - 1,782,072 Denver - 922,000 Broomfield - 728,200 Lakewood - 255,000 Thornton - 499,000 Instructions Create a Spreadsheet: The layout for your spreadsheet needs to have the ability to calculate: Total sales for each Realtor Total sales per city in the Metro area Average Sale per city Average Sale per Realtor Total Commission per Realtor Total Commission for Move NOW! Average Commission per Realtor To complete the calculations based on commissions, enter the commission percentage (4%) one time on your spreadsheet, and use an Absolute Reference to calculate each individual commission amount. Do not create a new formula for each cell for those calculations. Format: Use the formatting techniques learned in this Module, and include the following at a minimum: Borders and Shading Merged Cells Use proper cell format for each cell based on the information in the cell Chart: Create two Charts and place them in a New Worksheet One Chart for total sales by Realtor One Chart for total sales by City Use the Chart Format of your choice