• Requires a Sort and Filter at the top of each column with a filer arrow funnel image indicating that the table is filtered.
• Column 9: will require a function to illustrate the days on the market
• Averages: should be placed at the "Asking Price", "Selling Price", and "Days on the Market".
• The "Averages" should be seen after you set your filter
• Upon completion, filter the report Illustrating the following: I am looking for a house in Eagle Mountain, listed for 515,000. Who is the representative, and when was it listed?
• Please show all formulas

12:32 I LTE Chapter 4_solution.. Q Crain's Estate Realtor Office Number City Asking Price Selling Price Listing Date Sale Date 68 8214 Harris Drive 8/182, 018 720 Carey 350600 400,000 4492018 5/25/2016 54 4/1/2016 4/30/2016 4/3/2016 6/10/2016 68 615 West Cedar B Lehi 290,000 4/3/2018 6/1/2016 59 8 321 North Choctaw $ 535,000 4/8/2016 9/30/2016 75 876 West Holiday 75,000 $ 455,060 86 10 1971 Glenview Road 155,750 4/12/2016 6/12/2016 15 West Oak Circle Each Column 48 203 13 82 14 143 North Mountain View American F has a Sort/filter 114 15 20 Fast Dak Circle American Fo at the top 185 16 8030 Steeplechase Drive Alpine 16 76 27 224 Rockaway Street Alpine 50 18 9876 South Sunset wanue Eagle Mount 300,060 4/18/2016 4/3012018 321 West Walnut love Amarican For 415,000 4M8/2016 6/30/2016 -000 $ 330,959 22 1900 Glenview Road 412872016 34 9000 South Suns Avenue Eagle Mountain Lugo 5/28/2016 30 23 6/3/2016 36 24 8432 South Sung Avenue Eagle Mountain Minkus 831 South Webe 4/28/2016 9/15/2016 140 25 714 Timp View L umarican Fork 4/29/2016 9/1/2016 125 28 240 e Mountain 4/29/2018 8/25/2016 1 18 20 4081 you'll need to arrive 280 B Always replace at the answer using 308,750 my name with 400,D00 4/30/2018 10/1/2016 200 F $ 300,000 4/30/2016 62 30 8307 yours! Do $ 255,000 5/1/2018 8/18/2018 31 123 5/1/2018 6/5/2016 50 605 Reuter 310.000 $ 291400 522/2016 6/29/2016 38 Student Name Sales 204b1Houses_solution.xisx 5/1/2016 7/16/2016 1370 Pinellas Road Lugo 56 65 520 E Spring Street Minkus 189,900 $ 185,102 6/6/2016 7/26/2016 36 3451 East Lindon Way American Fork 450.000 $ 400,000 5/2/2016 5/30/2016 151 48 81 Island Drive South Apine Bethune 147 500 $ 150,000 5/22/2016 6/16/2016 25 38 614 Lincoln Drive Eagle Mountain Reuter 475.000 $ Cardamn /23/2016 39 Lehi Hemandez $ 382,500 500.000 $ 425,000 5/5/2016 11/15/2016 194 42 765 East Sheridan Lan Eagle Mountain Minkus 5/5/2016 11/1/2016 180 43 American Fork 5/6/2016 5/15/2016 44 45 487 Blue Skies Drive 365.750 $ 355,000 M13/2016 8/15/2016 8687 Kenwood Road Cedar Hills 725 000 8 645,250 4/1/2018 8/16/2016 73 East Dak Street 325,000 325,000 49 10700 Lake Shore Lane 3412 Kilmer Street 35 I have provided 100 5/1/2016 5/30/2016 51 1857 Pine Drive 77 East Oak Street Eap CO 23/2016 6/23/2016 52 boo 26/2016 8/30/2016 53 1 Southampton Place you with all this 4/28/2016 6/18/2016 54 3410 North Sunset Lan 28/2016 8/15/2018 55 1892 North 250 West data 24/2016 6/30/2018 58 58 1629 NW 43rd Street Cedar Hills Carey 31/2018 8/19/2016 34 Weat Oakley Drive American Fork 345 000 $ 330,000 6/1/2016 8/15/2016 81 30 Kent Road Lehi Bemune 8/2/2018 9/2/2016 62 140 East 3rd Street Eagle Mountain Han F/2/2016 11/30/2016 63 160 West 5th Street 410.000 350,760 8/2/2018 10/15/2016 240 West 5th Street Eagle Mountain Reuter 26 11971 8W 269 Terrace Carey 397,700 678 Mountain Circle Goodrich 236 000 330,000 97 67 3490 North Sunset Lan 250 000 $ 275,000 13 37 16236 Orange Boulevard Cedar Hills Lugo 396 000 $ 390,000 58 21 Compass Road Markin 289 900 $ 279,000 70 876 West Hadley Way American Fork 345 670 $ 345,000 20/2016 9/30/2016 102 4916 Rock Spring Road Cedar Hills obm 12/2016 7/21/2016 Student Name Sales 904b1 Houses_solution. xiox 12 Eagle Mountain Merkin 300 000 $ 250,000 132 71 416 East Oak 23/2016 11/2/2016 1132 SW 52ng Street Cedar Hills 254 500 $ 235,685 SO 425 Fast niak Fanin Mountain Refine Dashboard Calendar To Do Notifications Inbox12:32 LTE Chapter 4_solution.. 31 a Mountain 30 500 $ 375,500 5/1/2016 5/5/2016 50 123 1 310.000 $ 291,400 5/22/2016 6/29/2016 Student Name Sales 904b1 Houses_solution. xiox 33 245 Ivy Lane Eagle Mountain Goodrich 395,000 $ 375,000 5/1/2016 7/16/2016 1370 Pinellas Road 219,000 $ 215,000 4/8/2016 6/2/2016 76 Lugn 56 65 520 E Spring Street Alpine Minkus 189 900 $ 186,102 8/8/2018 7/26/2016 50 36 3481 East Lindon Way American Fork Reuter 5/2/2016 9/30/2016 48 81 Island Drive South Alpina 147 800 $ 150,060 1/22/2016 6/16/2016 38 614 Lincoln Drive Eagle Mountain Reuter 475 000 141 39 2448 Woodacres Road Lahi Hamandez 450,000 $ 382,500 515/2016 6/16/2016 42 40 401 Pinecone Circle Alpine Goodrich 1,500.120 $ 1.400,000 5/5/2016 9/30/2016 148 41 421 Ivy Lane Eagle Mountain Pljuan 500,000 $ 425,000 5/5/2016 11/15/2016 194 42 765 East Sheridan Lan Eagle Mountain Minkus 460 750 $ 435,500 515/2016 11/1/2016 180 43 61 East Walnut Grove American Fork Goodrich 375,000 $ 376,060 5/8/2018 5/15/2016 1414 N Sheridan Road Alpine Pijuan 1,250.000 $ 1,225,000 487 Blue Skies Drive American Fork Goodrich 386.750 $ 355,000 13/2018 8/15/2016 8657 Kenwood Road Cedar Hills Hemandez 725.000 $ 645,250 4/1/2016 6/16/2016 47 73 East Oak Street Eagle Mountain Merkin /18/2018 5/31/2016 48 10700 Lake Shore Lane Cec CO 15/2018 6/9/2018 49 3412 Kilmer Street Cec I have provided CO 23/2016 7/15/2016 35 1857 Pine Drive 5/1/2018 5/30/2016 77 Fast Oak Street 23/2016 6/23/2016 400 Ivy Lane 1 Southampton Place 3418 North Sunset Lar you with all this (28/2016 6/18/2016 28/2016 8/15/2016 56 20/2018 8/1/2016 73 1892 North 250 West 10 Vestal Drive Cec 57 3400 North Sunset Lame Eag data 24/2016 6/30/2016 0co 31/2018 7/15/2016 58 875 South California Way American 31/2016 6/30/2016 56 1629 NW 43rd Street Cedar Hills Carey 475,000 5 450,000 31/2016 8/19/2016 80 60 34 West Oakley Drive American Fork 445 000 330,DOC 8/1/2016 8/15/2016 30 Kent Road Lehi Bethune 259.900 $ 245,905 6/2/2016 9/2/2016 62 140 East Ard Street 350,000 8/272018 1 1/30/2018 181 160 West 5th Street Eagle Mountain Garey 410.000 $ 350,750 6/3/2016 10/15/2016 134 64 240 West 5th Street Eagle Mountain Reuter 285 750 5 300,000 6/5/2016 7/1/2016 26 34 11971 SW 289 Terrace Cedar Hills Garay 410 000 $ 397,700 5/1/2018 6/26/2016 56 675 Mountain Circle American Fork Goodrich 335 000 $ 330,000 10/2016 9/15/2016 3490 North Sunset Lanes Eagle Mountain Minkus $ 275,060 /12/2018 6/25/2016 16235 Orange Boulevard Cedar Hills Lugo 380,000 5/5/2016 7/16/2016 21 Compass Road Markin 279,DC0 70 876 West Hadley Way American Fork 348 570 $ 345,000 20/2016 9/30/2016 4916 Rock Spring Road Cedar Hills Lugo 275.000 5 264,000 13/2016 7/21/2016 38 Student Name Sales 204b1Houses_solution.xisx 72 416 East Oak Eagle Mountain Markin 300.000 $ 250,000 23/2016 11/2/2016 1132 SW 52ng Street Cedar Hills Hemandez 254.500 672042948 9/21/2016 74 425 East Oak Eagle Mountain Bethune 250,000 5/24/2016 8/15/2016 52 1600 Reaves Sreet Cedar Hills 245 900 233,606 5/30/2016 8/16/2016 47 78 103 Jasper Drive Lehi 6/2972018 916/2016 69 77 515 East Oak Eagle Mountain Pljust 6/29/2016 9/30/2016 93 78 123 Oak Avenue American Fork Carey Don't forget your 79 formluas 8/30/2018 7/15/2016 15 600 Ivy Lane Eagle Mountain Pijuan 6/30/2016 10/1/2016 93 80 144 Oak Avenue American Fork Goodhen STJOY2048 9/1/2016 83 9408 Forest Hills Circle Cedar Hills Reuter 5/1/2018 613/2016-3 38 Averages 72 Student Name Sales 904b1 Houses_solution.xisx O= Dashboard Calendar To Do Notifications Inbox12:31 I LTE