please help me solve and explain how you go about it in excel. DETAILED

1. Open HROct Sales.xlsx 2. Save the workbook and name it EL2-C4-VB-HROctSales. 3. Create the Pivot Table shown in Figure 4.11 in a new worksheet named Pivot Table. Apply the Pivot Style Medium 11 style and set the column widths to 18 characters. 4. Create the PivotChart shown in Figure 4.12 in a new worksheet named PivotChart. Use the 3-D Clustered Column chart type and apply the Style 11 style. 5. Print the Pivot Table and PivotChart worksheets. 6. Save and then close EL2-C4-VB-HROctSales.xlsx Figure 4.11 Visual Benchmark Pivot Table SOLD FOR SALE Hillsdale Realtors 3 Sum of Sale Puce 4 Bow Label 5 Chandler 6 Glendale 7 Mesa 8 Phoenix 9 Grand Total October Sales Column label Concm Single om hom $ 610.9005 325.500 5 640.400 881 375 275 800 946.750 695.000 2.148.100 $ 2.222. 100$ 4.201.7255 Townhome 952.100 5 165,800 174.900 1.292.800 $ Grand Tote 1.888.500 1.521.775 1.288.350 3.018.000 7.716.625 Figure 4.12 Visual Benchmark PivotChart SOLO FOK SALE Hillsdale Realtors October Sales 200 ILL Styles A4 4 x fx =DATE(2015,10,1) B D E G H SOLD FOR SALE Hillsdale Realtors 1 2 3 4 6 7 8 9 10 11 12 13 14 October Sales and Commissions Sale Date Listing # Agent Last Name Property Type City Sale Price Commission 10/1/15! 282715 Femandez Single family home Phoenix $ 325,500 $ 11,392.50 10/2/15 315825 O'Brien Townhome Phoenix $ 174,900 $ 6,121.50 10/5/15 458215 O'Brien Single family home Mesa $ 225,500 $ 7,892.50 10/7/15 351245 Youngblood Single family home Chandler $ 325,500 $ 11,392.50 10/9/15 312548 Williamson Townhome Mesa $ 165,800 $ 5,803.00 10/9/15 291524 Femandez Single family home Phoenix $ 425.800 $ 14.903.00 10/12/15 263412 Youngblood Single family home Phoenix $ 375,800 $13,153.00 10/14/15 254853 O'Brien Townhome Chandler $ 341,500 $11.952.50 10/15/15 302154 Fernandez Townhome Chandler $ 225,600 $ 7,896.00 10/15/15 311452 Youngblood Condominium Phoenix $ 349,900 $ 12,246.50 10/19/15 302785 O'Brien Single family home Glendale $ 425,675 $ 14,898.63 10/19/15 268457 O'Brien Condominium Glendale $ 225,400 $ 7,889.00 10/21/15 316548 Youngblood Condominium Phoenix $ 345,100 $ 12,078.50 10/21/15 315863 Femandez Single family home Glendale $ 455,700 $ 15.949.50 10/22/15 294563 O'Brien Condominium Glendale $ 415,000 $ 14,525.00 10/23/15 288451 Femandez Townhome Chandler $ 385,000 $13,475.00 10/26/15 275143 Femandez Single family home Mesa $ 275,500 $ 9.642.50 10/26/15 311148 Youngblood Single family home Mesa $ 345,750 $ 12,101.25 10/28/15 325984 Youngblood Condominium Chandler $ 285,900 $ 10,006.50 10/28/15 246845 Youngblood Single family home Phoenix $ 545,200 $ 19,082.00 10/29/15 334567 O'Brien $ Single family home Phoenix 475,800 $ 16,653.00 10/30/15 266845 Femandez Condominium Chandler $ 325,000 $ 11,375.00 254836 Youngblood Mesa 10/30/15 Condominium $ 275,800 $ 9,653.00 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31