[The following information applies to the questions displayed below.] Chapman Realty Company is seeking your help in analyzing its monthly sales performance and the sales activity within its residential and commercial segments. During the most recent four-month period the companys 12 realtors sold 99 properties (residential, commercial, and land) across six counties for a total of $30,637,161. Click here to download the Excel template, which you will use to answer the questions that follow.

Click here for a brief tutorial on PivotTables in Excel.

Click here for a brief tutorial on PivotCharts in Excel.

Click here for a brief tutorial on IF Statements in Excel.

rev: 05_07_2020_QC_CS-210952, 01_09_2021_QC_CS-246235

2c. Which month had the highest Residential sales total? What was that total? 2d. Which month had the highest Land sales total? What was that total?

B G H M 1 Month 2 October 3 January 4 November 5 November 6 October 7 November 8 January 9 January 10 January 11 October 12 November 13 October 14 November 15 January 16 November 17 December 18 January 19 October 20 January 21 October 22 December 23 November 24 December 25 November 26 December 27 November 28 December 29 January 30 December 31 January 32 December 33 October 34 November 35 October 36 January 37 October 38 December 39 October 40 November 41 January 42 December 43 January 44 January 45 December 46 January 47 October 48 January 49 December 50 January 51 52 53 Selling Price Type $ 157,500 Commercial $ $ 88,800 Commercial $ 67,875 Commercial $ 53,938 Commercial $ 2,989,500 Commercial $ 2,027,375 Commercial $ 505,000 Commercial $ 242,500 Land $ 236,300 Commercial $ 127,250 Residential $ 108,125 Commercial $ 100,000 Land $ $ 98,750 Residential $ $ 64,400 Residential $ 62,719 Commercial $ 51,359 Commercial $ 44,258 Land $ 3,014,750 Commercial $ 717,000 Commercial $ 585,000 Commercial $ 288,422 Commercial $ 272,625 Land $ $ 204,469 Land $ 83,625 Residential $ 49,831 Commercial $ $ 47,500 Residential $ 536,844 Commercial $ 81,117 Commercial $ 50,158 Commercial $ 45,680 Land $ $ 41,875 Commercial $ 403,500 Commercial $ 368,938 Commercial $ 365,060 Land $ $ 287,000 Commercial $ 275,000 Residential $ S 218,000 Commercial $ 214,500 Residential $ $ 98,156 Commercial $ 66,000 Residential $ 57,031 Commercial $ 44,916 Residential $ 22,000 Land $ 950,000 Commercial $ 164,211 Commercial $ 151,500 Residential $ 102,105 Residential $ 60,316 Commercial $ 48,516 Residential D E F Realtor - RealtorID County David Pullen 101 McDowell David Pullen 101 Rutherford David Pullen 101 Buncombe David Pullen 101 Rutherford David Willis 102 Buncombe David Willis 102 Henderson David Willis 102 McDowell David Willis 102 McDowell David Willis 102 Polk David Willis 102 Polk David Willis 102 Buncombe David Willis 102 Polk David Willis 102 McDowell David Willis 102 Henderson David Willis 102 Buncombe David Willis 102 Polk David Willis 102 Henderson Hal Keefer 103 Rutherford Hal Keefer 103 Cleveland Hal Keefer 103 Rutherford Hal Keefer 103 Cleveland Hal Keefer 103 Rutherford Hal Keefer 103 Cleveland Hal Keefer 103 Polk Hal Keefer 103 McDowell Hal Keefer 103 Cleveland Jon Dolan 104 McDowell Jon Dolan 104 Buncombe Jon Dolan 104 Buncombe Jon Dolan 104 Buncombe Jon Dolan 104 Buncombe Arturo James 105 Buncombe Arturo James 105 McDowell Arturo James 105 Rutherford Arturo James 105 Buncombe Arturo James 105 Henderson Arturo James 105 Buncombe Arturo James 105 McDowell Arturo James 105 Buncombe Arturo James 105 Buncombe Arturo James 105 Buncombe Arturo James 105 Henderson Arturo James 105 Polk Marcus Jackson 106 Henderson Marcus Jackson 106 Buncombe Marcus Jackson 106 Cleveland Marcus Jackson 106 Rutherford Marcus Jackson 106 Polk Marcus Jackson 106 Buncombe Month Selling Price Type Realtor Realtorld County November $ 43,750 Residential Marcus Jac 106 Polk January $ 445,000 Commercia Megan Coc 107 Buncombe January $ 245,000 Commercia Megan Coc 107 Buncombe October $ 70,000 Land Megan Coc 107 Rutherford November $ 69,375 Residential Megan Coc 107 Polk November $ 55,000 Commercia Megan Coc 107 Henderson November $ 50,906 Land Megan Coc 107 Henderson December $ 47,344 Land Megan Coc 107 Buncombe October $ 354,600 Land Melanie Aa 108 Rutherford November $ 176,250 Commercia Melanie Aa 108 Cleveland November $ 118,650 Residential Melanie Aa 108 Polk January $ 60,559 Residential Melanie Aa 108 Buncombe December $ 59,663 Residential Melanie Aa 108 Buncombe January $ 50,279 Land Melanie Aa 108 Rutherford January $ 47,270 Commercia Melanie Aa 108 Buncombe October $2,671,500 Commercia Eun Jung B $ 109 Henderson November $ 697,875 Commercia Eun Jung B 109 Buncombe November $ 202,530 Land Eun Jung B 109 Henderson November $ 80,633 Commercia Eun Jung B 109 Cleveland November $ 79,325 Land Eun Jung B 109 Cleveland January $ 67,500 Residential Eun Jung B B 109 Polk January $ 54,539 Land Eun Jung B 109 McDowell December $ 45,453 Residential Eun Jung B 109 Buncombe January $1,150,000 Residential Mitch Davi 110 Rutherford November $1,033,688 Land Mitch Davi 110 Cleveland October $ 221,750 Commercia Mitch Davi 110 Polk October $ 197,300 Residential Mitch Davi 110 Henderson December $ 122,234 Residential Mitch Davi 110 Buncombe October $ 95,750 Residential Mitch Davi 110 Polk January $ 42,840 Commercia Mitch Davi 110 Cleveland October $ 312,500 Residential Nicole Ashl 111 McDowell January $ 163,500 Commercia Nicole Ash| 111 McDowell November $ 156,313 Commercia Nicole Ash 111 Henderson November $ 130,875 Commercia Nicole Ashl 111 Buncombe November $ 121,265 Residential Nicole Ashl 111 McDowell January $ 95,000 Land Nicole Ash 111 Buncombe November $ 85,438 Commercia Nicole Ashl 111 Henderson November $ 74,063 Commercia Nicole Ashl 111 Buncombe December $ 69,078 Commercia Nicole Ashl 111 Polk October $1,355,750 Commercia Pete Jacob 112 Cleveland October 970,500 Commercia Pete Jacob: 112 Buncombe October $ 505,250 Commercia Pete Jacob: 112 Cleveland January $ 486,800 Commercia Pete Jacob: 112 Polk January $ 138,150 Land Pete Jacob: 112 Cleveland January $ 129,000 Residential Pete Jacob: 112 Buncombe November $ 61,813 Residential Pete Jacob 112 Buncombe November $ 54,688 Commercia Pete Jacob 112 Polk November $ 46,969 Residential Pete Jacob: 112 Rutherford January $ 41,420 Commercia Pete Jacob: 112 Polk December $ 40,938 Land Pete Jacob: 112 Henderson