1 2 3 Insert a formula in cell G13 to calculate the selling price percentage of the asking price, format it with percent with Insert a formula in cell J13 to calculate the number of days between the listing date and sale date. Copy the formu Use the Subtotal feature to calculate the average of the selling price, percentage of asking price, and days on mar a b c d What is the average selling price in Alpine? Which city has the highest average % of asking price? Which city has the least number of average days on market? What is the average days on market for all cities? Which city had the lowest average selling price? Number Address 1 8687 Kenwood Road 2 11 West Oak Circle 3 314 Timp View Drive 4 614 West Cedar Drive 5 750 South Apple Way 6 7 Kingston Court 7 618 West Cedar Drive 8 321 North Choctaw 9 1370 Pinellas Road ### 1971 Glenview Road ### 15 West Oak Circle ### 575 South Choctaw ### 10995 SW 88 Court ### 143 North Mountain View ### 29 East Oak Circle ### 8030 Steeplechase Drive ### 2006 Cutwater Court ### 9876 South Sunset Avenue ### 321 West Walnut Grove ### 4081 Lybyer Avenue ### 1900 Glenview Road ### 9000 South Sunset Avenue ### 8432 South Sunset Avenue ### 831 South Weber ### 714 Timp View Lane ### 240 East Jefferson Way ### 224 Rockaway Street ### 260 East Jefferson Way ### 290 East Jefferson Way ### 8307 S Indian River Drive ### 123 Ivy Lane ### 9408 Forest Hills Circle ### 245 Ivy Lane ### 11971 SW 269 Terrace ### 1857 Pine Drive ### 3461 East Lindon Way ### 16235 Orange Boulevard ### 614 Lincoln Drive ### 2448 Woodacres Road ### 401 Pinecone Circle ### 421 Ivy Lane ### 765 East Sheridan Lane ### 61 East Walnut Grove ### 1414 N Sheridan Road ### 487 Blue Skies Drive City Cedar Hills American Fork American Fork Lehi American Fork Alpine Lehi American Fork Alpine Lehi American Fork Alpine Lehi American Fork American Fork Alpine Alpine Eagle Mountain American Fork Alpine Lehi Eagle Mountain Eagle Mountain American Fork American Fork Eagle Mountain Alpine Eagle Mountain Eagle Mountain Lehi Eagle Mountain Cedar Hills Eagle Mountain Cedar Hills Cedar Hills American Fork Cedar Hills Eagle Mountain Lehi Alpine Eagle Mountain Eagle Mountain American Fork Alpine American Fork Selling Agent Hernandez Carey Goodrich Lugo Goodrich Carey Lugo Minkus Lugo Minkus Hernandez Goodrich Goodrich Carey Merkin Merkin Minkus Hernandez Goodrich Minkus Hernandez Lugo Minkus Lugo Goodrich Lugo Pijuan Hernandez Pijuan Hernandez Pijuan Reuter Goodrich Carey Hernandez Reuter Lugo Reuter Hernandez Goodrich Pijuan Minkus Goodrich Pijuan Goodrich Asking Price $ 725,000 $ 350,000 $ 418,000 $ 215,800 $ 385,900 $ 500,000 $ 300,000 $ 565,000 $ 219,000 $ 165,000 $ 325,000 $ 750,250 $ 110,000 $ 314,250 $ 555,000 $ 450,000 $ 345,000 $ 300,000 $ 425,000 $ 325,000 $ 325,000 $ 325,000 $ 285,750 $ 425,815 $ 250,000 $ 515,000 $ 400,000 $ 450,000 $ 310,000 $ 250,000 $ 375,500 $ 185,500 $ 395,000 $ 410,000 $ 560,700 $ 450,000 $ 395,000 $ 475,000 $ 450,000 $ 1,500,120 $ 500,000 $ 460,750 $ 375,000 $ 1,250,000 $ 365,750 Selling Price $ 645,250 $ 340,000 $ 400,000 $ 200,000 ### $ 465,000 $ 290,000 $ 535,000 $ 215,000 $ 156,750 $ 320,000 $ 700,000 $ 106,000 $ 304,000 $ 500,000 $ 382,500 $ 339,999 ### $ 415,000 $ 308,750 $ 302,250 $ 320,000 $ 300,000 $ 400,000 $ 232,000 $ 485,750 $ 375,000 $ 400,000 $ 300,000 $ 255,000 ### $ 179,000 $ 375,000 $ 397,700 $ 550,000 $ 400,000 $ 380,000 $ 425,250 $ 382,500 $ 1,400,000 $ 425,000 $ 435,500 $ 376,000 $ 1,225,000 $ 355,000 ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### 10700 Lake Shore Lane 73 East Oak Street 81 Island Drive South 3412 Kilmer Street 605 Reservoir Drive 77 East Oak Street 400 Ivy Lane 1 Southampton Place 3418 North Sunset Lane 1892 North 250 West 1629 NW 43rd Street 3400 North Sunset Lane 876 South California Way 21 Compass Road 34 West Oakley Drive 30 Kent Road 140 East 3rd Street 160 West 5th Street 240 West 5th Street 520 E Spring Street 678 Mountain Circle 3490 North Sunset Lane 4916 Rock Spring Road 8923 Harris Drive 876 West Hadley Way 1132 SW 52nd Street 416 East Oak 10 Vestal Drive 425 East Oak 876 West Holiday 103 Jasper Drive 516 East Oak 123 Oak Avenue 600 Ivy Lane 144 Oak Avenue 1600 Reeves Street Cedar Hills Eagle Mountain Alpine Lehi Alpine Eagle Mountain Eagle Mountain Lehi Eagle Mountain American Fork Cedar Hills Eagle Mountain American Fork Cedar Hills American Fork Lehi Eagle Mountain Eagle Mountain Eagle Mountain Alpine American Fork Eagle Mountain Cedar Hills Alpine American Fork Cedar Hills Eagle Mountain Cedar Hills Eagle Mountain Alpine Lehi Eagle Mountain American Fork Eagle Mountain American Fork Cedar Hills Carey Merkin Bethune Carey Reuter Bethune Bethune Goodrich Bethune Carey Carey Merkin Hen Merkin Carey Bethune Hen Carey Reuter Minkus Goodrich Minkus Lugo Minkus Hernandez Hernandez Merkin Carey Bethune Goodrich Bethune Pijuan Carey Pijuan Goodrich Reuter $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 650,000 325,000 147,800 180,000 310,000 345,000 375,000 215,000 450,000 315,250 475,000 400,000 316,000 289,900 345,000 259,900 399,000 410,000 285,750 189,900 335,000 250,000 275,000 589,000 345,670 254,500 300,000 555,000 275,900 475,000 165,900 299,999 400,000 339,999 380,500 245,900 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 598,000 ### 150,000 175,000 291,400 335,000 330,000 195,000 400,000 300,000 450,000 375,000 ### 279,000 330,000 246,905 350,000 350,750 300,000 186,102 330,000 275,000 264,000 575,000 345,000 236,685 250,000 565,000 250,000 455,000 159,264 280,000 ### 310,000 365,000 233,605 rmat it with percent with 1 decimal place and copy the formula down the column. ale date. Copy the formula down the column. price, and days on market by city and answer the following questions % of Asking Price Listing Date Sale Date Days on Market 4/1/2017 6/16/2017 4/1/2017 5/15/2017 4/1/2017 6/1/2017 4/1/2017 5/25/2017 4/1/2017 4/30/2017 4/3/2017 6/10/2017 4/3/2017 6/1/2017 4/6/2017 9/30/2017 4/8/2017 6/2/2017 4/12/2017 6/12/2017 4/12/2017 5/30/2017 4/12/2017 11/1/2017 4/12/2017 7/3/2017 4/13/2017 8/5/2017 4/13/2017 10/15/2017 4/15/2017 6/30/2017 4/18/2017 6/23/2017 4/18/2017 4/30/2017 4/18/2017 6/30/2017 4/19/2017 7/2/2017 4/28/2017 6/1/2017 4/28/2017 5/28/2017 4/28/2017 6/3/2017 4/28/2017 9/15/2017 4/29/2017 9/1/2017 4/29/2017 8/25/2017 4/30/2017 6/19/2017 4/30/2017 10/1/2017 4/30/2017 7/1/2017 5/1/2017 6/18/2017 5/1/2017 5/5/2017 5/1/2017 6/6/2017 5/1/2017 7/16/2017 5/1/2017 6/26/2017 5/1/2017 5/30/2017 5/2/2017 9/30/2017 5/5/2017 7/16/2017 5/5/2017 9/23/2017 5/5/2017 6/16/2017 5/5/2017 9/30/2017 5/5/2017 11/15/2017 5/5/2017 11/1/2017 5/6/2017 5/15/2017 5/12/2017 6/6/2017 5/13/2017 8/15/2017 5/15/2017 6/9/2017 5/18/2017 5/31/2017 5/22/2017 6/16/2017 5/23/2017 7/15/2017 5/22/2017 6/29/2017 5/23/2017 6/23/2017 5/26/2017 8/30/2017 5/28/2017 6/18/2017 5/28/2017 8/15/2017 5/28/2017 8/1/2017 5/31/2017 8/19/2017 5/31/2017 7/15/2017 5/31/2017 6/30/2017 5/31/2017 6/1/2017 6/1/2017 8/15/2017 6/2/2017 9/2/2017 6/2/2017 11/30/2017 6/3/2017 10/15/2017 6/5/2017 7/1/2017 6/6/2017 7/26/2017 6/10/2017 9/15/2017 6/12/2017 6/25/2017 6/13/2017 7/21/2017 6/18/2017 7/8/2017 6/20/2017 9/30/2017 6/23/2017 9/21/2017 6/23/2017 11/2/2017 6/24/2017 6/30/2017 6/24/2017 8/15/2017 6/24/2017 9/18/2017 6/29/2017 9/6/2017 6/29/2017 9/30/2017 6/30/2017 7/15/2017 6/30/2017 10/1/2017 6/30/2017 9/1/2017 6/30/2017 8/16/2017 Use the Subtotals feature to answer the following questions. Hint: You will need to create subtotals twice, once f Name of the Selling Agent who sold the most expensive property: Name of the Selling Agent who negotiated the highest % of asking price: Name of the Selling Agent who sold the least expensive property: Name of the Selling Agent who sold the property with the least Days on Market: Number 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 Address 8687 Kenwood Road 11 West Oak Circle 314 Timp View Drive 614 West Cedar Drive 750 South Apple Way 7 Kingston Court 618 West Cedar Drive 321 North Choctaw 1370 Pinellas Road 1971 Glenview Road 15 West Oak Circle 575 South Choctaw 10995 SW 88 Court 143 North Mountain View 29 East Oak Circle 8030 Steeplechase Drive 2006 Cutwater Court 9876 South Sunset Avenue 321 West Walnut Grove 4081 Lybyer Avenue 1900 Glenview Road 9000 South Sunset Avenue 8432 South Sunset Avenue 831 South Weber 714 Timp View Lane 240 East Jefferson Way 224 Rockaway Street 260 East Jefferson Way 290 East Jefferson Way 8307 S Indian River Drive 123 Ivy Lane 9408 Forest Hills Circle 245 Ivy Lane 11971 SW 269 Terrace 1857 Pine Drive 3461 East Lindon Way 16235 Orange Boulevard 614 Lincoln Drive 2448 Woodacres Road 401 Pinecone Circle 421 Ivy Lane 765 East Sheridan Lane 61 East Walnut Grove 1414 N Sheridan Road 487 Blue Skies Drive 10700 Lake Shore Lane 73 East Oak Street 81 Island Drive South City Cedar Hills American Fork American Fork Lehi American Fork Alpine Lehi American Fork Alpine Lehi American Fork Alpine Lehi American Fork American Fork Alpine Alpine Eagle Mountain American Fork Alpine Lehi Eagle Mountain Eagle Mountain American Fork American Fork Eagle Mountain Alpine Eagle Mountain Eagle Mountain Lehi Eagle Mountain Cedar Hills Eagle Mountain Cedar Hills Cedar Hills American Fork Cedar Hills Eagle Mountain Lehi Alpine Eagle Mountain Eagle Mountain American Fork Alpine American Fork Cedar Hills Eagle Mountain Alpine Selling Agent Hernandez Carey Goodrich Lugo Goodrich Carey Lugo Minkus Lugo Minkus Hernandez Goodrich Goodrich Carey Merkin Merkin Minkus Hernandez Goodrich Minkus Hernandez Lugo Minkus Lugo Goodrich Lugo Pijuan Hernandez Pijuan Hernandez Pijuan Reuter Goodrich Carey Hernandez Reuter Lugo Reuter Hernandez Goodrich Pijuan Minkus Goodrich Pijuan Goodrich Carey Merkin Bethune Asking Price $ 725,000 $ 350,000 $ 418,000 $ 215,800 $ 385,900 $ 500,000 $ 300,000 $ 565,000 $ 219,000 $ 165,000 $ 325,000 $ 750,250 $ 110,000 $ 314,250 $ 555,000 $ 450,000 $ 345,000 $ 300,000 $ 425,000 $ 325,000 $ 325,000 $ 325,000 $ 285,750 $ 425,815 $ 250,000 $ 515,000 $ 400,000 $ 450,000 $ 310,000 $ 250,000 $ 375,500 $ 185,500 $ 395,000 $ 410,000 $ 560,700 $ 450,000 $ 395,000 $ 475,000 $ 450,000 $ 1,500,120 $ 500,000 $ 460,750 $ 375,000 $ 1,250,000 $ 365,750 $ 650,000 $ 325,000 $ 147,800 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 3412 Kilmer Street 605 Reservoir Drive 77 East Oak Street 400 Ivy Lane 1 Southampton Place 3418 North Sunset Lane 1892 North 250 West 1629 NW 43rd Street 3400 North Sunset Lane 876 South California Way 21 Compass Road 34 West Oakley Drive 30 Kent Road 140 East 3rd Street 160 West 5th Street 240 West 5th Street 520 E Spring Street 678 Mountain Circle 3490 North Sunset Lane 4916 Rock Spring Road 8923 Harris Drive 876 West Hadley Way 1132 SW 52nd Street 416 East Oak 10 Vestal Drive 425 East Oak 876 West Holiday 103 Jasper Drive 516 East Oak 123 Oak Avenue 600 Ivy Lane 144 Oak Avenue 1600 Reeves Street Lehi Alpine Eagle Mountain Eagle Mountain Lehi Eagle Mountain American Fork Cedar Hills Eagle Mountain American Fork Cedar Hills American Fork Lehi Eagle Mountain Eagle Mountain Eagle Mountain Alpine American Fork Eagle Mountain Cedar Hills Alpine American Fork Cedar Hills Eagle Mountain Cedar Hills Eagle Mountain Alpine Lehi Eagle Mountain American Fork Eagle Mountain American Fork Cedar Hills Carey Reuter Bethune Bethune Goodrich Bethune Carey Carey Merkin Hen Merkin Carey Bethune Hen Carey Reuter Minkus Goodrich Minkus Lugo Minkus Hernandez Hernandez Merkin Carey Bethune Goodrich Bethune Pijuan Carey Pijuan Goodrich Reuter $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 180,000 310,000 345,000 375,000 215,000 450,000 315,250 475,000 400,000 316,000 289,900 345,000 259,900 399,000 410,000 285,750 189,900 335,000 250,000 275,000 589,000 345,670 254,500 300,000 555,000 275,900 475,000 165,900 299,999 400,000 339,999 380,500 245,900 need to create subtotals twice, once for max values and then for min values. , $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ Selling Price % of Asking Price Listing Date Sale Date Days on Market 645,250 89.0% 4/1/2017 6/16/2017 76 340,000 97.1% 4/1/2017 5/15/2017 44 400,000 95.7% 4/1/2017 6/1/2017 61 200,000 92.7% 4/1/2017 5/25/2017 54 385,900 100.0% 4/1/2017 4/30/2017 29 465,000 93.0% 4/3/2017 6/10/2017 68 290,000 96.7% 4/3/2017 6/1/2017 59 535,000 94.7% 4/6/2017 9/30/2017 177 215,000 98.2% 4/8/2017 6/2/2017 55 156,750 95.0% 4/12/2017 6/12/2017 61 320,000 98.5% 4/12/2017 5/30/2017 48 700,000 93.3% 4/12/2017 11/1/2017 203 106,000 96.4% 4/12/2017 7/3/2017 82 304,000 96.7% 4/13/2017 8/5/2017 114 500,000 90.1% 4/13/2017 10/15/2017 185 382,500 85.0% 4/15/2017 6/30/2017 76 339,999 98.6% 4/18/2017 6/23/2017 66 300,000 100.0% 4/18/2017 4/30/2017 12 415,000 97.6% 4/18/2017 6/30/2017 73 308,750 95.0% 4/19/2017 7/2/2017 74 302,250 93.0% 4/28/2017 6/1/2017 34 320,000 98.5% 4/28/2017 5/28/2017 30 300,000 105.0% 4/28/2017 6/3/2017 36 400,000 93.9% 4/28/2017 9/15/2017 140 232,000 92.8% 4/29/2017 9/1/2017 125 485,750 94.3% 4/29/2017 8/25/2017 118 375,000 93.8% 4/30/2017 6/19/2017 50 400,000 88.9% 4/30/2017 10/1/2017 154 300,000 96.8% 4/30/2017 7/1/2017 62 255,000 102.0% 5/1/2017 6/18/2017 48 375,500 100.0% 5/1/2017 5/5/2017 4 179,000 96.5% 5/1/2017 6/6/2017 36 375,000 94.9% 5/1/2017 7/16/2017 76 397,700 97.0% 5/1/2017 6/26/2017 56 550,000 98.1% 5/1/2017 5/30/2017 29 400,000 88.9% 5/2/2017 9/30/2017 151 380,000 96.2% 5/5/2017 7/16/2017 72 425,250 89.5% 5/5/2017 9/23/2017 141 382,500 85.0% 5/5/2017 6/16/2017 42 1,400,000 93.3% 5/5/2017 9/30/2017 148 425,000 85.0% 5/5/2017 11/15/2017 194 435,500 94.5% 5/5/2017 11/1/2017 180 376,000 100.3% 5/6/2017 5/15/2017 9 1,225,000 98.0% 5/12/2017 6/6/2017 25 355,000 97.1% 5/13/2017 8/15/2017 94 598,000 92.0% 5/15/2017 6/9/2017 25 325,000 100.0% 5/18/2017 5/31/2017 13 150,000 101.5% 5/22/2017 6/16/2017 25 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 175,000 291,400 335,000 330,000 195,000 400,000 300,000 450,000 375,000 316,000 279,000 330,000 246,905 350,000 350,750 300,000 186,102 330,000 275,000 264,000 575,000 345,000 236,685 250,000 565,000 250,000 455,000 159,264 280,000 400,000 310,000 365,000 233,605 97.2% 94.0% 97.1% 88.0% 90.7% 88.9% 95.2% 94.7% 93.8% 100.0% 96.2% 95.7% 95.0% 87.7% 85.5% 105.0% 98.0% 98.5% 110.0% 96.0% 97.6% 99.8% 93.0% 83.3% 101.8% 90.6% 95.8% 96.0% 93.3% 100.0% 91.2% 95.9% 95.0% 5/23/2017 7/15/2017 5/22/2017 6/29/2017 5/23/2017 6/23/2017 5/26/2017 8/30/2017 5/28/2017 6/18/2017 5/28/2017 8/15/2017 5/28/2017 8/1/2017 5/31/2017 8/19/2017 5/31/2017 7/15/2017 5/31/2017 6/30/2017 5/31/2017 6/1/2017 6/1/2017 8/15/2017 6/2/2017 9/2/2017 6/2/2017 11/30/2017 6/3/2017 10/15/2017 6/5/2017 7/1/2017 6/6/2017 7/26/2017 6/10/2017 9/15/2017 6/12/2017 6/25/2017 6/13/2017 7/21/2017 6/18/2017 7/8/2017 6/20/2017 9/30/2017 6/23/2017 9/21/2017 6/23/2017 11/2/2017 6/24/2017 6/30/2017 6/24/2017 8/15/2017 6/24/2017 9/18/2017 6/29/2017 9/6/2017 6/29/2017 9/30/2017 6/30/2017 7/15/2017 6/30/2017 10/1/2017 6/30/2017 9/1/2017 6/30/2017 8/16/2017 53 38 31 96 21 79 65 80 45 30 1 75 92 181 134 26 50 97 13 38 20 102 90 132 6 52 86 69 93 15 93 63 47 Real Estate Data 1 Create a PivotTable from the Real Estate Data set on a new worksheet. Name the new worksheet Average City Prices. 2 Place the City field, Selling Agent field, Asking Price and Selling Price fields in the appropriate areas (rows, columns and values) Number Address City Selling Agent Asking Price Selling Price Listing Date Sale Date 3 Modify the PivotTable by completing the following steps: 1 8687 Kenwood Road Cedar Hills Hernandez $ 725,000 $ 645,250 4/1/2018 6/16/2018 a) Display averages rather than sums with Accounting Number format with 0 decimal places for the two value fields. 2 11 West Oak Circle American Fork Carey $ 350,000 $ 340,000 4/1/2018 5/15/2018 b) Format and sort the PivotTable appropriately. 3 314 Timp View Drive American Fork Goodrich $ 418,000 $ 400,000 4/1/2018 6/1/2018 Lugo Goodrich Carey Lugo Minkus Lugo Minkus Hernandez Goodrich Goodrich Carey Merkin Merkin Minkus Hernandez Goodrich Minkus Hernandez Lugo Minkus Lugo Goodrich Lugo Pijuan Hernandez Pijuan Hernandez Pijuan Reuter Goodrich Carey Hernandez Reuter Lugo Reuter Hernandez Goodrich Pijuan Minkus Goodrich Pijuan Goodrich Carey Merkin Bethune Carey Reuter Bethune Bethune Goodrich Bethune Carey Carey Merkin Hen Merkin $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 614 West Cedar Drive Lehi 750 South Apple Way American Fork 7 Kingston Court Alpine 618 West Cedar Drive Lehi 321 North Choctaw American Fork 1370 Pinellas Road Alpine 1971 Glenview Road Lehi 15 West Oak Circle American Fork 575 South Choctaw Alpine 10995 SW 88 Court Lehi 143 North Mountain View American Fork 29 East Oak Circle American Fork 8030 Steeplechase Drive Alpine 2006 Cutwater Court Alpine 9876 South Sunset AvenueEagle Mountain 321 West Walnut Grove American Fork 4081 Lybyer Avenue Alpine 1900 Glenview Road Lehi 9000 South Sunset AvenueEagle Mountain 8432 South Sunset AvenueEagle Mountain 831 South Weber American Fork 714 Timp View Lane American Fork 240 East Jefferson Way Eagle Mountain 224 Rockaway Street Alpine 260 East Jefferson Way Eagle Mountain 290 East Jefferson Way Eagle Mountain 8307 S Indian River Drive Lehi 123 Ivy Lane Eagle Mountain 9408 Forest Hills Circle Cedar Hills 245 Ivy Lane Eagle Mountain 11971 SW 269 Terrace Cedar Hills 1857 Pine Drive Cedar Hills 3461 East Lindon Way American Fork 16235 Orange Boulevard Cedar Hills 614 Lincoln Drive Eagle Mountain 2448 Woodacres Road Lehi 401 Pinecone Circle Alpine 421 Ivy Lane Eagle Mountain 765 East Sheridan Lane Eagle Mountain 61 East Walnut Grove American Fork 1414 N Sheridan Road Alpine 487 Blue Skies Drive American Fork 10700 Lake Shore Lane Cedar Hills 73 East Oak Street Eagle Mountain 81 Island Drive South Alpine 3412 Kilmer Street Lehi 605 Reservoir Drive Alpine 77 East Oak Street Eagle Mountain 400 Ivy Lane Eagle Mountain 1 Southampton Place Lehi 3418 North Sunset Lane Eagle Mountain 1892 North 250 West American Fork 1629 NW 43rd Street Cedar Hills 3400 North Sunset Lane Eagle Mountain 876 South California Way American Fork 21 Compass Road Cedar Hills 215,800 385,900 500,000 300,000 565,000 219,000 165,000 325,000 750,250 110,000 314,250 555,000 450,000 345,000 300,000 425,000 325,000 325,000 325,000 285,750 425,815 250,000 515,000 400,000 450,000 310,000 250,000 375,500 185,500 395,000 410,000 560,700 450,000 395,000 475,000 450,000 1,500,120 500,000 460,750 375,000 1,250,000 365,750 650,000 325,000 147,800 180,000 310,000 345,000 375,000 215,000 450,000 315,250 475,000 400,000 316,000 289,900 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 200,000 385,900 465,000 290,000 535,000 215,000 156,750 320,000 700,000 106,000 304,000 500,000 382,500 339,999 300,000 415,000 308,750 302,250 320,000 300,000 400,000 232,000 485,750 375,000 400,000 300,000 255,000 375,500 179,000 375,000 397,700 550,000 400,000 380,000 425,250 382,500 140,000 425,000 435,500 376,000 1,225,000 355,000 598,000 325,000 150,000 175,000 291,400 335,000 330,000 195,000 400,000 300,000 450,000 375,000 316,000 279,000 4/1/2018 5/25/2018 4/1/2018 4/30/2018 4/3/2018 6/10/2018 4/3/2018 6/1/2018 4/6/2018 9/30/2018 4/8/2018 6/2/2018 4/12/2018 6/12/2018 4/12/2018 5/30/2018 4/12/2018 11/1/2018 4/12/2018 7/3/2018 4/13/2018 8/5/2018 4/13/2018 10/15/2018 4/15/2018 6/30/2018 4/18/2018 6/23/2018 4/18/2018 4/30/2018 4/18/2018 6/30/2018 4/19/2018 7/2/2018 4/28/2018 6/1/2018 4/28/2018 5/28/2018 4/28/2018 6/3/2018 4/28/2018 9/15/2018 4/29/2018 9/1/2018 4/29/2018 8/25/2018 4/30/2018 6/19/2018 4/30/2018 10/1/2018 4/30/2018 7/1/2018 5/1/2018 6/18/2018 5/1/2018 5/5/2018 5/1/2018 6/6/2018 5/1/2018 7/16/2018 5/1/2018 6/26/2018 5/1/2018 5/30/2018 5/2/2018 9/30/2018 5/5/2018 7/16/2018 5/5/2018 9/23/2018 5/5/2018 6/16/2018 5/5/2018 9/30/2018 5/5/2018 11/15/2018 5/5/2018 11/1/2018 5/6/2018 5/15/2018 5/12/2018 6/6/2018 5/13/2018 8/15/2018 5/15/2018 6/9/2018 5/18/2018 5/31/2018 5/22/2018 6/16/2018 5/23/2018 7/15/2018 5/22/2018 6/29/2018 5/23/2018 6/23/2018 5/26/2018 8/30/2018 5/28/2018 6/18/2018 5/28/2018 8/15/2018 5/28/2018 8/1/2018 5/31/2018 8/19/2018 5/31/2018 7/15/2018 5/31/2018 6/30/2018 5/31/2018 6/1/2018 c) Create a calculated field to estimate the Selling Agent's commission which is 3.5% of the Selling Price. Name the field Commission. d) Add the Selling Price field again and display as % of Grand Total and change the name to reflect that. 7 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 618 West Cedar Drive 34 West Oakley Drive 30 Kent Road 140 East 3rd Street 160 West 5th Street 240 West 5th Street 520 E Spring Street 678 Mountain Circle 3490 North Sunset Lane 4916 Rock Spring Road 8923 Harris Drive 876 West Hadley Way 1132 SW 52nd Street 416 East Oak 10 Vestal Drive 425 East Oak 876 West Holiday 103 Jasper Drive 516 East Oak 123 Oak Avenue 600 Ivy Lane 144 Oak Avenue 1600 Reeves Street Lehi American Fork Lehi Eagle Mountain Eagle Mountain Eagle Mountain Alpine American Fork Eagle Mountain Cedar Hills Alpine American Fork Cedar Hills Eagle Mountain Cedar Hills Eagle Mountain Alpine Lehi Eagle Mountain American Fork Eagle Mountain American Fork Cedar Hills Lugo Carey Bethune Hen Carey Reuter Minkus Goodrich Minkus Lugo Minkus Hernandez Hernandez Merkin Carey Bethune Goodrich Bethune Pijuan Carey Pijuan Goodrich Reuter $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 300,000 345,000 259,900 399,000 410,000 285,750 189,900 335,000 250,000 275,000 589,000 345,670 254,500 300,000 555,000 275,900 475,000 165,900 299,999 400,000 339,999 380,500 245,900 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 290,000 330,000 246,905 350,000 350,750 300,000 186,102 330,000 275,000 264,000 575,000 345,000 236,685 250,000 565,000 250,000 455,000 159,264 280,000 400,000 310,000 365,000 233,605 4/3/2018 6/1/2018 6/1/2018 8/15/2018 6/2/2018 9/2/2018 6/2/2018 11/30/2018 6/3/2018 10/15/2018 6/5/2018 7/1/2018 6/6/2018 7/26/2018 6/10/2018 9/15/2018 6/12/2018 6/25/2018 6/13/2018 7/21/2018 6/18/2018 7/8/2018 6/20/2018 9/30/2018 6/23/2018 9/21/2018 6/23/2018 11/2/2018 6/24/2018 6/30/2018 6/24/2018 8/15/2018 6/24/2018 9/18/2018 6/29/2018 9/6/2018 6/29/2018 9/30/2018 6/30/2018 7/15/2018 6/30/2018 10/1/2018 6/30/2018 9/1/2018 6/30/2018 8/16/2018