Advanced Excel homeworks
Abbas1412
Alomran_EX16XLCH05GRADERML1HW_-_Mountain_View_Realty_11.zipEX16XLCH05GRADERML1HW_-_Mountain_View_Realty_11_Instructions.docx
Office 2016 – myitlab:grader – Instructions Excel Project
EX16_XL_CH05_GRADER_ML1_HW - Mountain View Realty 1.1
Project Description: <Project Description>
Instructions: For the purpose of grading the project you are required to perform the following tasks: Step Instructions Points Possible 1 Open exploring_e05_grader_h2_RealEstate.xlsx and save it as exploring_e05_grader_h2_RealEstate_LastFirst. 0.000 2 In cell G2 in the Sales Subtotals sheet, insert a formula to calculate the selling price percentage of the asking price, format it with Percent Style with one decimal place, and then copy the formula down the column. 5.000 3 In cell J2, enter a formula to calculate the number of days between the listing date and sale date. Copy the formula down the column. 5.000 4 Sort the list by City in alphabetical order, then by Selling Agent in alphabetical order, and finally by Listing Date in chronological order (oldest to newest). 9.000 5 Use the Subtotal feature to calculate the average selling price, percentage of asking price, and days on market by city. Ensure that Summary below data is selected, and then click OK. Group the data using the Auto Outline feature. Collapse the outline to hide the listing and sale dates. Click the outline symbol to display the grand average and city average rows only. 15.000 6 Format the average days on market as numbers with zero decimal places. Set a print area for the range C1:J88. 3.000 7 Go to cell C101, read the questions, and type the correct answers in the respective highlighted cells in the range G102:G106. Apply Accounting Number Format with zero decimal places to cell G102. 5.000 8 Click the Sales Data worksheet and create a blank PivotTable on a new worksheet. Name the new worksheet PivotTable. Name the PivotTable Average City Prices. 10.000 9 Place the City field in rows, the Selling Agent field in columns, and the Asking Price and Selling Price fields as values. Display averages rather than sums with Accounting Number Format with zero decimal places. Pivot the data by placing the City field below the Values field in the Columns area and moving the Selling Agent field to the Rows area. 9.000 10 Add a filter to cell B3 to display only Alpine and Cedar Hills. 2.000 11 Go back to the Sales Data worksheet. You realize that a selling price is incorrect. Change the selling price for Number 40 from $140,000 to $1,400,000. Refresh the PivotTable. 3.000 12 Change the widths of columns A, B, C, D, and E to 11. Change the widths of columns F and G to 14. Wrap text and center horizontally data in cells B4, D4, F4, and G4. Apply the Bottom Border to the range B4:E4. Change the label in cell A5 to Agent. Change the height of row 4 to 40. 10.000 13 Display the Sales Data worksheet. Create a recommended PivotTable using the Sum of Selling Price by City thumbnail. Change the name of the new PivotTable worksheet to Selling Price. 5.000 14 Change the value to display averages not sums. Apply the Accounting Number Format with 0 decimal places to the values. Apply Light Blue, Pivot Style Medium 2 to the PivotTable. Note, depending upon the version of Office being used, the style name may be Pivot Style Medium 2. 6.000 15 Create a clustered column PivotChart from the PivotTable on the Selling Price worksheet. Move the chart to a chart sheet named Sales Chart. 5.000 16 Change the chart title to Average Selling Price by City and apply Dark Blue font color. Remove the legend. Apply Blue, Accent 1 fill color to the data series. 6.000 17 Create a footer with your name on the left side, the sheet name code in the center, and the file name code on the right side of all worksheets. Adjust the scaling if needed. 2.000 18 Save the workbook. Ensure that the worksheets are named correctly and in the following order: Sales Subtotals, PivotTable, Sales Chart, Selling Price, Sales Data. Close the workbook and exit Excel. Submit the file as directed. 0.000 Total Points 100.000
Updated: 02/16/2017 1 Current_Instruction.docx
Alomran_exploring_e05_grader_h2_RealEstate.xlsx
Sales Subtotals
| Number | Address | City | Selling Agent | Asking Price | Selling Price | % of Asking Price | Listing Date | Sale Date | Days on Market |
| 1 | 8687 Kenwood Road | Cedar Hills | Hernandez | $ 725,000 | $ 645,250 | 4/1/18 | 6/16/18 | ||
| 2 | 11 West Oak Circle | American Fork | Carey | $ 350,000 | $ 340,000 | 4/1/18 | 5/15/18 | ||
| 3 | 314 Timp View Drive | American Fork | Goodrich | $ 418,000 | $ 400,000 | 4/1/18 | 6/1/18 | ||
| 4 | 614 West Cedar Drive | Lehi | Lugo | $ 215,800 | $ 200,000 | 4/1/18 | 5/25/18 | ||
| 5 | 750 South Apple Way | American Fork | Goodrich | $ 385,900 | $ 385,900 | 4/1/18 | 4/30/18 | ||
| 6 | 7 Kingston Court | Alpine | Carey | $ 500,000 | $ 465,000 | 4/3/18 | 6/10/18 | ||
| 7 | 618 West Cedar Drive | Lehi | Lugo | $ 300,000 | $ 290,000 | 4/3/18 | 6/1/18 | ||
| 8 | 321 North Choctaw | American Fork | Minkus | $ 565,000 | $ 535,000 | 4/6/18 | 9/30/18 | ||
| 9 | 1370 Pinellas Road | Alpine | Lugo | $ 219,000 | $ 215,000 | 4/8/18 | 6/2/18 | ||
| 10 | 1971 Glenview Road | Lehi | Minkus | $ 165,000 | $ 156,750 | 4/12/18 | 6/12/18 | ||
| 11 | 15 West Oak Circle | American Fork | Hernandez | $ 325,000 | $ 320,000 | 4/12/18 | 5/30/18 | ||
| 12 | 575 South Choctaw | Alpine | Goodrich | $ 750,250 | $ 700,000 | 4/12/18 | 11/1/18 | ||
| 13 | 10995 SW 88 Court | Lehi | Goodrich | $ 110,000 | $ 106,000 | 4/12/18 | 7/3/18 | ||
| 14 | 143 North Mountain View | American Fork | Carey | $ 314,250 | $ 304,000 | 4/13/18 | 8/5/18 | ||
| 15 | 29 East Oak Circle | American Fork | Merkin | $ 555,000 | $ 500,000 | 4/13/18 | 10/15/18 | ||
| 16 | 8030 Steeplechase Drive | Alpine | Merkin | $ 450,000 | $ 382,500 | 4/15/18 | 6/30/18 | ||
| 17 | 2006 Cutwater Court | Alpine | Minkus | $ 345,000 | $ 339,999 | 4/18/18 | 6/23/18 | ||
| 18 | 9876 South Sunset Avenue | Eagle Mountain | Hernandez | $ 300,000 | $ 300,000 | 4/18/18 | 4/30/18 | ||
| 19 | 321 West Walnut Grove | American Fork | Goodrich | $ 425,000 | $ 415,000 | 4/18/18 | 6/30/18 | ||
| 20 | 4081 Lybyer Avenue | Alpine | Minkus | $ 325,000 | $ 308,750 | 4/19/18 | 7/2/18 | ||
| 21 | 1900 Glenview Road | Lehi | Hernandez | $ 325,000 | $ 302,250 | 4/28/18 | 6/1/18 | ||
| 22 | 9000 South Sunset Avenue | Eagle Mountain | Lugo | $ 325,000 | $ 320,000 | 4/28/18 | 5/28/18 | ||
| 23 | 8432 South Sunset Avenue | Eagle Mountain | Minkus | $ 285,750 | $ 300,000 | 4/28/18 | 6/3/18 | ||
| 24 | 831 South Weber | American Fork | Lugo | $ 425,815 | $ 400,000 | 4/28/18 | 9/15/18 | ||
| 25 | 714 Timp View Lane | American Fork | Goodrich | $ 250,000 | $ 232,000 | 4/29/18 | 9/1/18 | ||
| 26 | 240 East Jefferson Way | Eagle Mountain | Lugo | $ 515,000 | $ 485,750 | 4/29/18 | 8/25/18 | ||
| 27 | 224 Rockaway Street | Alpine | Pijuan | $ 400,000 | $ 375,000 | 4/30/18 | 6/19/18 | ||
| 28 | 260 East Jefferson Way | Eagle Mountain | Hernandez | $ 450,000 | $ 400,000 | 4/30/18 | 10/1/18 | ||
| 29 | 290 East Jefferson Way | Eagle Mountain | Pijuan | $ 310,000 | $ 300,000 | 4/30/18 | 7/1/18 | ||
| 30 | 8307 S Indian River Drive | Lehi | Hernandez | $ 250,000 | $ 255,000 | 5/1/18 | 6/18/18 | ||
| 31 | 123 Ivy Lane | Eagle Mountain | Pijuan | $ 375,500 | $ 375,500 | 5/1/18 | 5/5/18 | ||
| 32 | 9408 Forest Hills Circle | Cedar Hills | Reuter | $ 185,500 | $ 179,000 | 5/1/18 | 6/6/18 | ||
| 33 | 245 Ivy Lane | Eagle Mountain | Goodrich | $ 395,000 | $ 375,000 | 5/1/18 | 7/16/18 | ||
| 34 | 11971 SW 269 Terrace | Cedar Hills | Carey | $ 410,000 | $ 397,700 | 5/1/18 | 6/26/18 | ||
| 35 | 1857 Pine Drive | Cedar Hills | Hernandez | $ 560,700 | $ 550,000 | 5/1/18 | 5/30/18 | ||
| 36 | 3461 East Lindon Way | American Fork | Reuter | $ 450,000 | $ 400,000 | 5/2/18 | 9/30/18 | ||
| 37 | 16235 Orange Boulevard | Cedar Hills | Lugo | $ 395,000 | $ 380,000 | 5/5/18 | 7/16/18 | ||
| 38 | 614 Lincoln Drive | Eagle Mountain | Reuter | $ 475,000 | $ 425,250 | 5/5/18 | 9/23/18 | ||
| 39 | 2448 Woodacres Road | Lehi | Hernandez | $ 450,000 | $ 382,500 | 5/5/18 | 6/16/18 | ||
| 40 | 401 Pinecone Circle | Alpine | Goodrich | $ 1,500,120 | $ 1,400,000 | 5/5/18 | 9/30/18 | ||
| 41 | 421 Ivy Lane | Eagle Mountain | Pijuan | $ 500,000 | $ 425,000 | 5/5/18 | 11/15/18 | ||
| 42 | 765 East Sheridan Lane | Eagle Mountain | Minkus | $ 460,750 | $ 435,500 | 5/5/18 | 11/1/18 | ||
| 43 | 61 East Walnut Grove | American Fork | Goodrich | $ 375,000 | $ 376,000 | 5/6/18 | 5/15/18 | ||
| 44 | 1414 N Sheridan Road | Alpine | Pijuan | $ 1,250,000 | $ 1,225,000 | 5/12/18 | 6/6/18 | ||
| 45 | 487 Blue Skies Drive | American Fork | Goodrich | $ 365,750 | $ 355,000 | 5/13/18 | 8/15/18 | ||
| 46 | 10700 Lake Shore Lane | Cedar Hills | Carey | $ 650,000 | $ 598,000 | 5/15/18 | 6/9/18 | ||
| 47 | 73 East Oak Street | Eagle Mountain | Merkin | $ 325,000 | $ 325,000 | 5/18/18 | 5/31/18 | ||
| 48 | 81 Island Drive South | Alpine | Bethune | $ 147,800 | $ 150,000 | 5/22/18 | 6/16/18 | ||
| 49 | 3412 Kilmer Street | Lehi | Carey | $ 180,000 | $ 175,000 | 5/23/18 | 7/15/18 | ||
| 50 | 605 Reservoir Drive | Alpine | Reuter | $ 310,000 | $ 291,400 | 5/22/18 | 6/29/18 | ||
| 51 | 77 East Oak Street | Eagle Mountain | Bethune | $ 345,000 | $ 335,000 | 5/23/18 | 6/23/18 | ||
| 52 | 400 Ivy Lane | Eagle Mountain | Bethune | $ 375,000 | $ 330,000 | 5/26/18 | 8/30/18 | ||
| 53 | 1 Southampton Place | Lehi | Goodrich | $ 215,000 | $ 195,000 | 5/28/18 | 6/18/18 | ||
| 54 | 3418 North Sunset Lane | Eagle Mountain | Bethune | $ 450,000 | $ 400,000 | 5/28/18 | 8/15/18 | ||
| 55 | 1892 North 250 West | American Fork | Carey | $ 315,250 | $ 300,000 | 5/28/18 | 8/1/18 | ||
| 56 | 1629 NW 43rd Street | Cedar Hills | Carey | $ 475,000 | $ 450,000 | 5/31/18 | 8/19/18 | ||
| 57 | 3400 North Sunset Lane | Eagle Mountain | Merkin | $ 400,000 | $ 375,000 | 5/31/18 | 7/15/18 | ||
| 58 | 876 South California Way | American Fork | Hen | $ 316,000 | $ 316,000 | 5/31/18 | 6/30/18 | ||
| 59 | 21 Compass Road | Cedar Hills | Merkin | $ 289,900 | $ 279,000 | 5/31/18 | 6/1/18 | ||
| 60 | 34 West Oakley Drive | American Fork | Carey | $ 345,000 | $ 330,000 | 6/1/18 | 8/15/18 | ||
| 61 | 30 Kent Road | Lehi | Bethune | $ 259,900 | $ 246,905 | 6/2/18 | 9/2/18 | ||
| 62 | 140 East 3rd Street | Eagle Mountain | Hen | $ 399,000 | $ 350,000 | 6/2/18 | 11/30/18 | ||
| 63 | 160 West 5th Street | Eagle Mountain | Carey | $ 410,000 | $ 350,750 | 6/3/18 | 10/15/18 | ||
| 64 | 240 West 5th Street | Eagle Mountain | Reuter | $ 285,750 | $ 300,000 | 6/5/18 | 7/1/18 | ||
| 65 | 520 E Spring Street | Alpine | Minkus | $ 189,900 | $ 186,102 | 6/6/18 | 7/26/18 | ||
| 66 | 678 Mountain Circle | American Fork | Goodrich | $ 335,000 | $ 330,000 | 6/10/18 | 9/15/18 | ||
| 67 | 3490 North Sunset Lane | Eagle Mountain | Minkus | $ 250,000 | $ 275,000 | 6/12/18 | 6/25/18 | ||
| 68 | 4916 Rock Spring Road | Cedar Hills | Lugo | $ 275,000 | $ 264,000 | 6/13/18 | 7/21/18 | ||
| 69 | 8923 Harris Drive | Alpine | Minkus | $ 589,000 | $ 575,000 | 6/18/18 | 7/8/18 | ||
| 70 | 876 West Hadley Way | American Fork | Hernandez | $ 345,670 | $ 345,000 | 6/20/18 | 9/30/18 | ||
| 71 | 1132 SW 52nd Street | Cedar Hills | Hernandez | $ 254,500 | $ 236,685 | 6/23/18 | 9/21/18 | ||
| 72 | 416 East Oak | Eagle Mountain | Merkin | $ 300,000 | $ 250,000 | 6/23/18 | 11/2/18 | ||
| 73 | 10 Vestal Drive | Cedar Hills | Carey | $ 555,000 | $ 565,000 | 6/24/18 | 6/30/18 | ||
| 74 | 425 East Oak | Eagle Mountain | Bethune | $ 275,900 | $ 250,000 | 6/24/18 | 8/15/18 | ||
| 75 | 876 West Holiday | Alpine | Goodrich | $ 475,000 | $ 455,000 | 6/24/18 | 9/18/18 | ||
| 76 | 103 Jasper Drive | Lehi | Bethune | $ 165,900 | $ 159,264 | 6/29/18 | 9/6/18 | ||
| 77 | 516 East Oak | Eagle Mountain | Pijuan | $ 299,999 | $ 280,000 | 6/29/18 | 9/30/18 | ||
| 78 | 123 Oak Avenue | American Fork | Carey | $ 400,000 | $ 400,000 | 6/30/18 | 7/15/18 | ||
| 79 | 600 Ivy Lane | Eagle Mountain | Pijuan | $ 339,999 | $ 310,000 | 6/30/18 | 10/1/18 | ||
| 80 | 144 Oak Avenue | American Fork | Goodrich | $ 380,500 | $ 365,000 | 6/30/18 | 9/1/18 | ||
| 81 | 1600 Reeves Street | Cedar Hills | Reuter | $ 245,900 | $ 233,605 | 6/30/18 | 8/16/18 | ||
| Answer these questions: | |||||||||
| 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? |
Sales Data
| Number | Address | City | Selling Agent | Asking Price | Selling Price | Listing Date | Sale Date |
| 1 | 8687 Kenwood Road | Cedar Hills | Hernandez | $ 725,000 | $ 645,250 | 4/1/18 | 6/16/18 |
| 2 | 11 West Oak Circle | American Fork | Carey | $ 350,000 | $ 340,000 | 4/1/18 | 5/15/18 |
| 3 | 314 Timp View Drive | American Fork | Goodrich | $ 418,000 | $ 400,000 | 4/1/18 | 6/1/18 |
| 4 | 614 West Cedar Drive | Lehi | Lugo | $ 215,800 | $ 200,000 | 4/1/18 | 5/25/18 |
| 5 | 750 South Apple Way | American Fork | Goodrich | $ 385,900 | $ 385,900 | 4/1/18 | 4/30/18 |
| 6 | 7 Kingston Court | Alpine | Carey | $ 500,000 | $ 465,000 | 4/3/18 | 6/10/18 |
| 7 | 618 West Cedar Drive | Lehi | Lugo | $ 300,000 | $ 290,000 | 4/3/18 | 6/1/18 |
| 8 | 321 North Choctaw | American Fork | Minkus | $ 565,000 | $ 535,000 | 4/6/18 | 9/30/18 |
| 9 | 1370 Pinellas Road | Alpine | Lugo | $ 219,000 | $ 215,000 | 4/8/18 | 6/2/18 |
| 10 | 1971 Glenview Road | Lehi | Minkus | $ 165,000 | $ 156,750 | 4/12/18 | 6/12/18 |
| 11 | 15 West Oak Circle | American Fork | Hernandez | $ 325,000 | $ 320,000 | 4/12/18 | 5/30/18 |
| 12 | 575 South Choctaw | Alpine | Goodrich | $ 750,250 | $ 700,000 | 4/12/18 | 11/1/18 |
| 13 | 10995 SW 88 Court | Lehi | Goodrich | $ 110,000 | $ 106,000 | 4/12/18 | 7/3/18 |
| 14 | 143 North Mountain View | American Fork | Carey | $ 314,250 | $ 304,000 | 4/13/18 | 8/5/18 |
| 15 | 29 East Oak Circle | American Fork | Merkin | $ 555,000 | $ 500,000 | 4/13/18 | 10/15/18 |
| 16 | 8030 Steeplechase Drive | Alpine | Merkin | $ 450,000 | $ 382,500 | 4/15/18 | 6/30/18 |
| 17 | 2006 Cutwater Court | Alpine | Minkus | $ 345,000 | $ 339,999 | 4/18/18 | 6/23/18 |
| 18 | 9876 South Sunset Avenue | Eagle Mountain | Hernandez | $ 300,000 | $ 300,000 | 4/18/18 | 4/30/18 |
| 19 | 321 West Walnut Grove | American Fork | Goodrich | $ 425,000 | $ 415,000 | 4/18/18 | 6/30/18 |
| 20 | 4081 Lybyer Avenue | Alpine | Minkus | $ 325,000 | $ 308,750 | 4/19/18 | 7/2/18 |
| 21 | 1900 Glenview Road | Lehi | Hernandez | $ 325,000 | $ 302,250 | 4/28/18 | 6/1/18 |
| 22 | 9000 South Sunset Avenue | Eagle Mountain | Lugo | $ 325,000 | $ 320,000 | 4/28/18 | 5/28/18 |
| 23 | 8432 South Sunset Avenue | Eagle Mountain | Minkus | $ 285,750 | $ 300,000 | 4/28/18 | 6/3/18 |
| 24 | 831 South Weber | American Fork | Lugo | $ 425,815 | $ 400,000 | 4/28/18 | 9/15/18 |
| 25 | 714 Timp View Lane | American Fork | Goodrich | $ 250,000 | $ 232,000 | 4/29/18 | 9/1/18 |
| 26 | 240 East Jefferson Way | Eagle Mountain | Lugo | $ 515,000 | $ 485,750 | 4/29/18 | 8/25/18 |
| 27 | 224 Rockaway Street | Alpine | Pijuan | $ 400,000 | $ 375,000 | 4/30/18 | 6/19/18 |
| 28 | 260 East Jefferson Way | Eagle Mountain | Hernandez | $ 450,000 | $ 400,000 | 4/30/18 | 10/1/18 |
| 29 | 290 East Jefferson Way | Eagle Mountain | Pijuan | $ 310,000 | $ 300,000 | 4/30/18 | 7/1/18 |
| 30 | 8307 S Indian River Drive | Lehi | Hernandez | $ 250,000 | $ 255,000 | 5/1/18 | 6/18/18 |
| 31 | 123 Ivy Lane | Eagle Mountain | Pijuan | $ 375,500 | $ 375,500 | 5/1/18 | 5/5/18 |
| 32 | 9408 Forest Hills Circle | Cedar Hills | Reuter | $ 185,500 | $ 179,000 | 5/1/18 | 6/6/18 |
| 33 | 245 Ivy Lane | Eagle Mountain | Goodrich | $ 395,000 | $ 375,000 | 5/1/18 | 7/16/18 |
| 34 | 11971 SW 269 Terrace | Cedar Hills | Carey | $ 410,000 | $ 397,700 | 5/1/18 | 6/26/18 |
| 35 | 1857 Pine Drive | Cedar Hills | Hernandez | $ 560,700 | $ 550,000 | 5/1/18 | 5/30/18 |
| 36 | 3461 East Lindon Way | American Fork | Reuter | $ 450,000 | $ 400,000 | 5/2/18 | 9/30/18 |
| 37 | 16235 Orange Boulevard | Cedar Hills | Lugo | $ 395,000 | $ 380,000 | 5/5/18 | 7/16/18 |
| 38 | 614 Lincoln Drive | Eagle Mountain | Reuter | $ 475,000 | $ 425,250 | 5/5/18 | 9/23/18 |
| 39 | 2448 Woodacres Road | Lehi | Hernandez | $ 450,000 | $ 382,500 | 5/5/18 | 6/16/18 |
| 40 | 401 Pinecone Circle | Alpine | Goodrich | $ 1,500,120 | $ 140,000 | 5/5/18 | 9/30/18 |
| 41 | 421 Ivy Lane | Eagle Mountain | Pijuan | $ 500,000 | $ 425,000 | 5/5/18 | 11/15/18 |
| 42 | 765 East Sheridan Lane | Eagle Mountain | Minkus | $ 460,750 | $ 435,500 | 5/5/18 | 11/1/18 |
| 43 | 61 East Walnut Grove | American Fork | Goodrich | $ 375,000 | $ 376,000 | 5/6/18 | 5/15/18 |
| 44 | 1414 N Sheridan Road | Alpine | Pijuan | $ 1,250,000 | $ 1,225,000 | 5/12/18 | 6/6/18 |
| 45 | 487 Blue Skies Drive | American Fork | Goodrich | $ 365,750 | $ 355,000 | 5/13/18 | 8/15/18 |
| 46 | 10700 Lake Shore Lane | Cedar Hills | Carey | $ 650,000 | $ 598,000 | 5/15/18 | 6/9/18 |
| 47 | 73 East Oak Street | Eagle Mountain | Merkin | $ 325,000 | $ 325,000 | 5/18/18 | 5/31/18 |
| 48 | 81 Island Drive South | Alpine | Bethune | $ 147,800 | $ 150,000 | 5/22/18 | 6/16/18 |
| 49 | 3412 Kilmer Street | Lehi | Carey | $ 180,000 | $ 175,000 | 5/23/18 | 7/15/18 |
| 50 | 605 Reservoir Drive | Alpine | Reuter | $ 310,000 | $ 291,400 | 5/22/18 | 6/29/18 |
| 51 | 77 East Oak Street | Eagle Mountain | Bethune | $ 345,000 | $ 335,000 | 5/23/18 | 6/23/18 |
| 52 | 400 Ivy Lane | Eagle Mountain | Bethune | $ 375,000 | $ 330,000 | 5/26/18 | 8/30/18 |
| 53 | 1 Southampton Place | Lehi | Goodrich | $ 215,000 | $ 195,000 | 5/28/18 | 6/18/18 |
| 54 | 3418 North Sunset Lane | Eagle Mountain | Bethune | $ 450,000 | $ 400,000 | 5/28/18 | 8/15/18 |
| 55 | 1892 North 250 West | American Fork | Carey | $ 315,250 | $ 300,000 | 5/28/18 | 8/1/18 |
| 56 | 1629 NW 43rd Street | Cedar Hills | Carey | $ 475,000 | $ 450,000 | 5/31/18 | 8/19/18 |
| 57 | 3400 North Sunset Lane | Eagle Mountain | Merkin | $ 400,000 | $ 375,000 | 5/31/18 | 7/15/18 |
| 58 | 876 South California Way | American Fork | Hen | $ 316,000 | $ 316,000 | 5/31/18 | 6/30/18 |
| 59 | 21 Compass Road | Cedar Hills | Merkin | $ 289,900 | $ 279,000 | 5/31/18 | 6/1/18 |
| 60 | 34 West Oakley Drive | American Fork | Carey | $ 345,000 | $ 330,000 | 6/1/18 | 8/15/18 |
| 61 | 30 Kent Road | Lehi | Bethune | $ 259,900 | $ 246,905 | 6/2/18 | 9/2/18 |
| 62 | 140 East 3rd Street | Eagle Mountain | Hen | $ 399,000 | $ 350,000 | 6/2/18 | 11/30/18 |
| 63 | 160 West 5th Street | Eagle Mountain | Carey | $ 410,000 | $ 350,750 | 6/3/18 | 10/15/18 |
| 64 | 240 West 5th Street | Eagle Mountain | Reuter | $ 285,750 | $ 300,000 | 6/5/18 | 7/1/18 |
| 65 | 520 E Spring Street | Alpine | Minkus | $ 189,900 | $ 186,102 | 6/6/18 | 7/26/18 |
| 66 | 678 Mountain Circle | American Fork | Goodrich | $ 335,000 | $ 330,000 | 6/10/18 | 9/15/18 |
| 67 | 3490 North Sunset Lane | Eagle Mountain | Minkus | $ 250,000 | $ 275,000 | 6/12/18 | 6/25/18 |
| 68 | 4916 Rock Spring Road | Cedar Hills | Lugo | $ 275,000 | $ 264,000 | 6/13/18 | 7/21/18 |
| 69 | 8923 Harris Drive | Alpine | Minkus | $ 589,000 | $ 575,000 | 6/18/18 | 7/8/18 |
| 70 | 876 West Hadley Way | American Fork | Hernandez | $ 345,670 | $ 345,000 | 6/20/18 | 9/30/18 |
| 71 | 1132 SW 52nd Street | Cedar Hills | Hernandez | $ 254,500 | $ 236,685 | 6/23/18 | 9/21/18 |
| 72 | 416 East Oak | Eagle Mountain | Merkin | $ 300,000 | $ 250,000 | 6/23/18 | 11/2/18 |
| 73 | 10 Vestal Drive | Cedar Hills | Carey | $ 555,000 | $ 565,000 | 6/24/18 | 6/30/18 |
| 74 | 425 East Oak | Eagle Mountain | Bethune | $ 275,900 | $ 250,000 | 6/24/18 | 8/15/18 |
| 75 | 876 West Holiday | Alpine | Goodrich | $ 475,000 | $ 455,000 | 6/24/18 | 9/18/18 |
| 76 | 103 Jasper Drive | Lehi | Bethune | $ 165,900 | $ 159,264 | 6/29/18 | 9/6/18 |
| 77 | 516 East Oak | Eagle Mountain | Pijuan | $ 299,999 | $ 280,000 | 6/29/18 | 9/30/18 |
| 78 | 123 Oak Avenue | American Fork | Carey | $ 400,000 | $ 400,000 | 6/30/18 | 7/15/18 |
| 79 | 600 Ivy Lane | Eagle Mountain | Pijuan | $ 339,999 | $ 310,000 | 6/30/18 | 10/1/18 |
| 80 | 144 Oak Avenue | American Fork | Goodrich | $ 380,500 | $ 365,000 | 6/30/18 | 9/1/18 |
| 81 | 1600 Reeves Street | Cedar Hills | Reuter | $ 245,900 | $ 233,605 | 6/30/18 | 8/16/18 |
