1. Open HROctSales.xlsx. 2. Save the workbook and name it EL2-C4-VB-HROctSales. 3. Create the Pivot Table...

  

Transcribed Image Text:

1. Open HROctSales.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 PivotTable SOLD FOR SALE 3 Sum of Sale Price Bow Labels 4 6 Chandler 6 Glendale 7 Mesa 8 Phoenix 9 Grand Total Hillsdale Realtors Column Lobels a Condominium S S October Sales ngle family home Townhome 325.500 $ 881.375 946.750 2.148.100 4.201.725 S 610,900 $ 640.400 275.800 695.000 2.222.100 S Figure 4.12 Visual Benchmark PivotChart SOLD FOR SALE Hillsdale Realtors October Sales 111 952.100 $ 165.800 174.900 1.292,800 $ Grand Tota 1.888.500 1.521.775 1.268.350 3.018.000 7.716.625 A4 1 23456∞ag. 8 9 21 22 23 24 25 = XV fx =DATE(2015,10,1) Sale Date Listing # 10/1/15 282715 10/2/15 315825 O'Brien 10/5/15 458215 O'Brien 10/7/15 351245 Youngblood 10/9/15 312548 Williamson 10/9/15 291524 Femandez 10/12/15 263412 Youngblood 10/14/15 254853 O'Brien 10/15/15 302154 Fernandez 10 11 12 13 10/15/15 311452 Youngblood 14 10/19/15 302785 O'Brien 10/19/15 268457 O'Brien 15 16 10/21/15 316548 Youngblood 17 10/21/15 315863 Femandez 10/22/15 294563 O'Brien 18 19 10/23/15 288451 Fernandez 20 10/26/15 275143 Fernandez 10/26/15 311148 Youngblood 10/28/15 325984 Youngblood 10/28/15 246845 Youngblood 334567 O'Brien 10/29/15 10/30/15 266845 10/30/15 254836 26 27 28 29 30 31 SOLD FOR SALE C Agent Last Name Femandez D Hillsdale Realtors October Sales and Commissions Phoenix Phoenix $ Property Type Single family home Townhome Single family home Single family home Townhome Single family home Mesa $ Chandler $ Mesa $ Phoenix $ Single family home Phoenix $ Townhome Townhome Condominium Single family home Condominium Condominium Single family home Condominium Townhome Chandler $ Chandler $ Phoenix $ Glendale $ Glendale $1 Phoenix $ Glendale $ Glendale $ Chandler $ Femandez Youngblood Single family home Single family home Condominium Styles Single family home Single family home Condominium Condominium E City Sale Price $325,500 Mesa Mesa $ Chandler $ Phoenix $ Phoenix Chandler $ Mesa $ G Commission $11,392.50 174,900 $ 6,121.50 225,500 $ 7,892.50 325,500 $11,392.50 165.800 $5.803.00 425,800 $14.903.00 375,800 $13,153.00 341.500 $11.952.50 225,600 $ 7,896.00 349,900 $12,246.50 425,675 $14,898.63 225,400 $7,889.00 345,100 $12.078.50 455,700 $15.949.50 415,000 $14,525.00 385.000 $13.475.00 275,500 $9.642.50 345,750 $12,101.25 285,900 $10,006.50 545,200 $19,082.00 475,800 $16,653.00 325,000 $11,375.00 275,800 $9,653.00 H 1. Open HROctSales.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 PivotTable SOLD FOR SALE 3 Sum of Sale Price Bow Labels 4 6 Chandler 6 Glendale 7 Mesa 8 Phoenix 9 Grand Total Hillsdale Realtors Column Lobels a Condominium S S October Sales ngle family home Townhome 325.500 $ 881.375 946.750 2.148.100 4.201.725 S 610,900 $ 640.400 275.800 695.000 2.222.100 S Figure 4.12 Visual Benchmark PivotChart SOLD FOR SALE Hillsdale Realtors October Sales 111 952.100 $ 165.800 174.900 1.292,800 $ Grand Tota 1.888.500 1.521.775 1.268.350 3.018.000 7.716.625 A4 1 23456∞ag. 8 9 21 22 23 24 25 = XV fx =DATE(2015,10,1) Sale Date Listing # 10/1/15 282715 10/2/15 315825 O'Brien 10/5/15 458215 O'Brien 10/7/15 351245 Youngblood 10/9/15 312548 Williamson 10/9/15 291524 Femandez 10/12/15 263412 Youngblood 10/14/15 254853 O'Brien 10/15/15 302154 Fernandez 10 11 12 13 10/15/15 311452 Youngblood 14 10/19/15 302785 O'Brien 10/19/15 268457 O'Brien 15 16 10/21/15 316548 Youngblood 17 10/21/15 315863 Femandez 10/22/15 294563 O'Brien 18 19 10/23/15 288451 Fernandez 20 10/26/15 275143 Fernandez 10/26/15 311148 Youngblood 10/28/15 325984 Youngblood 10/28/15 246845 Youngblood 334567 O'Brien 10/29/15 10/30/15 266845 10/30/15 254836 26 27 28 29 30 31 SOLD FOR SALE C Agent Last Name Femandez D Hillsdale Realtors October Sales and Commissions Phoenix Phoenix $ Property Type Single family home Townhome Single family home Single family home Townhome Single family home Mesa $ Chandler $ Mesa $ Phoenix $ Single family home Phoenix $ Townhome Townhome Condominium Single family home Condominium Condominium Single family home Condominium Townhome Chandler $ Chandler $ Phoenix $ Glendale $ Glendale $1 Phoenix $ Glendale $ Glendale $ Chandler $ Femandez Youngblood Single family home Single family home Condominium Styles Single family home Single family home Condominium Condominium E City Sale Price $325,500 Mesa Mesa $ Chandler $ Phoenix $ Phoenix Chandler $ Mesa $ G Commission $11,392.50 174,900 $ 6,121.50 225,500 $ 7,892.50 325,500 $11,392.50 165.800 $5.803.00 425,800 $14.903.00 375,800 $13,153.00 341.500 $11.952.50 225,600 $ 7,896.00 349,900 $12,246.50 425,675 $14,898.63 225,400 $7,889.00 345,100 $12.078.50 455,700 $15.949.50 415,000 $14,525.00 385.000 $13.475.00 275,500 $9.642.50 345,750 $12,101.25 285,900 $10,006.50 545,200 $19,082.00 475,800 $16,653.00 325,000 $11,375.00 275,800 $9,653.00 H

Answer rating: 100% (QA)

Answer 1 Open HROctSalesxlsx To open HROctSalesxlsx click on the File tab at the top of the Excel window From the File menu select Open and then browse to the location of the workbook When the workboo... View the full answer