Freeze the first row on the Sales Data worksheet. Convert the data to a table and apply the Table Style Medium 17. Remove duplicate records.Insert a new field immediately to the right of the Selling Price field. Name the new field Percent of List Price.Create a formula with structured references to calculate the percentage of the list price. Format the field with Percent Style with one decimal place.Insert a new field to the right of the Sale Date field. Name the new field Days on Market.Create a formula with structured references to calculate the number of days on the market. Apply the General number format to the values.Create a formula with structured references to calculate the number of days on the market. Apply the General number format to the values.Add a total row to display the average percentage of list price and average number of days on market. Format the average number of days on market as a whole number. Use an appropriate label for the total row.Sort the table by city in alphabetical order and add a second level to sort by days on market with the houses on the market the longest at the top within each city. Adjust column widths so that all data is visible. Wrap the column labels.Adjust column widths so that all data is visible. Wrap the column labels. Repeat the field names on all pages.Add a page break at Row 36 so that the city data does not span between pages, and return to Normal view, if necessary.Add 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.Display the Filtered Data worksheet. Filter the data to display the cities of Alpine, Cedar Hills, and Eagle Mountain.Filter the data to display records for houses that were on the market 30 days or more.Apply the conditional formatting 3 Arrows (Colored) icon set to the Days on Market values.Apply the Light Blue Data Bars conditional formatting in the Gradient Fill section to the selling prices.Create a new conditional format that applies yellow fill (fourth color under Standard Colors) and bold font to values that contain 98% or higher for the Percent of List Price column.

Excel Sheet to use

2 Lehi Carey 10 11 Number Address City Selling Agent 8687 Kenwood Road Cedar Hills Hernandez 11 West Oak Circle American Fork Carey 3 314 Timp View Drive American Fork Goodrich 4 614 West Cedar Drive Lugo 750 South Apple Way American Fork Goodrich 6 7 Kingston Court Alpine 618 West Cedar Drive Lehi Lugo 8 321 North Choctaw American Fork Minkus 9 1370 Pinellas Road Alpine Lugo 10 1971 Glenview Road Lehi Minkus 1971 Glenvie w Road Lehi Minkus 15 West Oak Circle American Fork Hernandez 12 575 South Choctaw Alpine Goodrich 13 10995 SW 88 Court Lehi Goodrich 14 143 North Mountain View American Fork Carey 29 East Oak Circle American Fork Merkin 16 8030 Steeplechase Drive Alpine Merkin 2006 Cutwater Court Alpine Minkus 18 9876 South Sunset Avenue Eagle Mountain Hernandez 321 West Walnut Grove American Fork Goodrich 4081 Lybyer Avenue Alpine Minkus 4081 Lybyer Avenue Alpine Minkus 1900 Glenvie w Road Lehi Hernandez 9000 South Sunset Avenue Eagle Mountain Lugo 8432 South Sunset Avenut Eagle Mountain Minkus 831 South Weber American Fork Lugo 714 Timp View Lane American Fork Goodnich 26 240 East Jefferson Way Eagle Mountain Lugo 224 Rockaway Street Alpine Pijuan 260 East Jefferson Way Eagle Mountain Hernandez 290 East Jefferson Way Eagle Mountain Pijuan 8307 S Indian River Drive Lehi Hernandez 8307 S Indian River Drive Lehi Hernandez 123 Ivy Lane Eagle Mountain Pijuan 9408 Forest Hills Circle Cedar Hils Reuter 245 Ivy Lane Eagle Mountain Goodrich 11971 SW 269 Terrace Cedar Hils Carey 1857 Pine Drive Cedar Hils Hernandez 3461 East Lindon Way American Fork Reuter List Price Selling Price Listing Date Sale Date 725,000 $ 645,250 4/1/2012 6/16/2012 350,000 $ 340,000 4/1/2012 5/15/2012 418,000 $ 400,000 4/1/2012 6/1/2012 215,800 $ 200,000 4/1/2012 5/25/2012 385,900 $ 385,900 4/1/2012 4/30/2012 500,000 $ 465,000 4/3/2012 6/10/2012 300,000 $ 290,000 4/3/2012 6/1/2012 565,000 $ 535,000 4/6/2012 9/30/2012 219,000 $ 215,000 4/8/2012 6/2/2012 165,000 $ 156,750 4/12/2012 6/12/2012 165,000 $ 4/12/2012 6/12/2012 325,000 $ 320,000 4/12/2012 5/30/2012 750,250 $ 700,000 4/12/2012 11/1/2012 110,000 $ 106,000 4/12/2012 7/3/2012 314,250 $ 304,000 4/13/2012 8/5/2012 555,000 $ 500,000 4/13/2012 10/15/2012 450,000 $ 382,500 4/15/2012 6/30/2012 345,000 $ 339,999 4/18/2012 6/23/2012 300,000 S 300.000 4/18/2012 4/30/2012 425,000 $ 415,000 4/18/2012 6/30/2012 325,000 $ 308,750 4/19/2012 7/2/2012 325,000 S 308,750 4/19/2012 7/2/2012 325,000 $ 302,250 4/28/2012 6/1/2012 325,000 320,000 4/28/2012 5/28/2012 285,750 S 300,000 4/28/2012 6/3/2012 425,815 $ 400.000 4/28/2012 9/15/2012 250,000 S 232,000 4/29/2012 9/1/2012 515,000 $ 485,750 4/29/2012 8/25/2012 400,000 $ 375,000 4/30/2012 6/19/2012 450,000 $ 400,000 4/30/2012 10/1/2012 310,000 $ 300,000 4/30/2012 7/1/2012 250,000 $ 255,000 5/1/2012 6/18/2012 250,000 S 255,000 571/2012 6/18/2012 375,500 $ 375,500 5/1/2012 5/5/2012 185,500 $ 179,000 5/1/2012 6/6/2012 395,000 $ 375,000 5/1/2012 7/16/2012 410,000 S 397,700 5/1/2012 8/26/2012 560.700 $ 550.000 S/1/2012 5/30/2012 450,000 S 400,000 5/2/2012 9/30/2012 20 20 28 41 of 3 e 4:07 PM et 3, 2/11/20 Test Presentation - .. 38 39 46 50 16235 Orange Boulevard Cedar Hills Lugo 614 Lincoln Drive Eagle Mountain Reuter 2448 Woodacres Road Lehi Hernandez 40 401 Pinecone Circle Alpine Goodrich 401 Pinecone Circle Alpine Goodrich 421 Ivy Lane Eagle Mountain Pijuan 765 East Sheridan Lane Eagle Mountain Minkus 61 East Walnut Grove American Fork Goodrich 1414 N Sheridan Road Alpine Pijuan 487 Blue Skies Drive American Fork Goodrich 10700 Lake Shore Lane Cedar Hils Carey 73 East Oak Street Eagle Mountain Merkin 48 81 Island Drive South Alpine Bethune 3412 Kimer Street Lehi Carey 605 Reservoir Drive Alpine Reuter 605 Reservoir Drive Alpine Reuter 51 77 East Oak Street Eagle Mountain Bethune 400 Ivy Lane Eagle Mountain Bethune 1 Southampton Place Lehi Goodrich 3418 North Sunset Lane Eagle Mountain Bethune 1892 North 250 West American Fork Carey 56 1629 NW 43rd Street Cedar Hils Carey 57 3400 North Sunset Lanc Eagle Mountain Merkin 876 South California Way American Fork Hen 21 Compass Road Cedar Hils Merkin 34 West Oakley Drive American Fork Carey 34 West Oakley Drive American Fork Carey 30 Kent Road Lehi Bethune 140 East 3rd Street Eagle Mountain Hen 160 West Sth Street Eagle Mountain Carey 240 West 5th Street Eagle Mountain Reuter 520 E Spring Street Alpine Minkus 678 Mountain Circle American Fork Goodrich 3490 North Sunset Lane Eagle Mountain Minkus 4916 Rock Spring Road Cedar Hills Lugo Minkus Alpine 8923 Harris Drive 376 West Hadley Way American ForkHernandez 70 American Fork Hemandez 876 West Hadley Way 71 1132 SW 52nd Street Cedar Hils Hernandez 72 416 Eat Oak Eagle Mountain Merkin 395,000 $ 475,000 $ 450,000 $ 1,500,120 $ 1,500,120 $ 500,000 $ 460,750 S 375,000 $ 1,250,000 $ 365,750 $ 650,000 $ 325,000 $ 147,800 S 180,000 $ 310,000 $ 310,000 $ 345,000 S 375,000 $ 215,000 $ 450,000 S 315,250 $ 475,000 $ 400,000 S 316,000 $ 289,900 $ 345,000 $ 345,000 S 259,900 $ 399,000 $ 410,000 $ 285,750 S 189,900 $ 385.000 $ 250,000 275,000 589,000 S 345,670 $ 345,670 254,500 $ 300.000 $ 380,000 5/5/2012 7/16/2012 425,250 5/5/2012 9/23/2012 382,500 5/5/2012 6/16/2012 1,400,000 5/5/2012 9/30/2012 1,400,000 5/5/2012 9/30/2012 425,000 5/5/2012 11/15/2012 435,500 5/5/2012 11/1/2012 376,000 5/6/2012 5/15/2012 1,225,000 5/12/2012 6/6/2012 355,000 5/13/2012 8/15/2012 598,000 5/15/2012 6/9/2012 325,000 5/18/2012 5/31/2012 150,000 5/22/2012 6/16/2012 175,000 5/23/2012 7/15/2012 291,400 5/22/2012 6/29/2012 291,400 5/22/2012 6/29/2012 335,000 5/23/2012 6/23/2012 330.000 5/26/2012 3/30/2012 195,000 5/28/2012 6/18/2012 400.000 5/28/2012 8/1 5/2012 300,000 5/28/2012 8/1/2012 450.000 5/31/2012 8/19/2012 375,000 5/31/2012 7/15/2012 316,000 5/31/2012 6/30/2012 279.000 5/31/2012 6/1/2012 330,000 8/1/2012 8/1 5/2012 330.000 671/2012 8/15/2012 246,905 6/2/2012 9/2/2012 350,000 6/2/2012 11/30/2012 350.750 6/3/2012 10/15/2012 300,000 6/5/2012 7/1/2012 186,102 6/6/2012 7/26/2012 330,000 6/10/2012 9/15/2012 275,000 8/12/2012 6/25/2012 284,000 6/13/2012 7/21/2012 575,000 6/18/2012 7/8/2012 345,000 6/20/2012 9/30/2012 345,000 6/20/2012 9/30/2012 236.685 8/23/2012 9/21/2012 250,000 6/28/2012 11/2/2012 58 59 86 68 2 of 3 4:12 PM ep 42/11/2020 Test Presentation -. X e Manning exploring MANNING, MATTHEW MM ? 73 74 75 76 77 10 Vestal Drive 425 East Oak 876 West Holiday 103 Jasper Drive 516 East Oak 123 Oak Avenue 600 Ivy Lane 144 Oak Avenue 144 Oak Avenue 1600 Reeves Street Cedar Hills Carey Eagle Mountain Bethune Alpine Goodrich Lehi Bethune Eagle Mountain Pijuan American Fork Carey Eagle Mountain Pijuan American Fork Goodrich American Fork Goodrich Cedar Hills Reuter 555,000 $ 275,900 $ 475,000 $ 165,900 $ 299,999 $ 400,000 $ 339,999 $ 380,500 $ 380,500 5 565,000 250.000 455,000 159 264 200,000 400,000 310.000 365,000 365,000 233,605 6/24/2012 6/30/2012 6/24/2012 8/15/2012 6/24/2012 9/18/2012 6/29/2012 9/6/2012 6/29/2012 9/30/2012 6/30/2012 7/15/2012 6/30/2012 10/1/2012 6/30/2012 9/1/2012 6/30/2012 9/1/2012 6/30/2012 8/16/2012 79 80 245,900 $ 4 4:12 PM 2/11/2020 x Manning exploring.. Test Presentation -... e DELL 2 Lehi Carey 10 11 Number Address City Selling Agent 8687 Kenwood Road Cedar Hills Hernandez 11 West Oak Circle American Fork Carey 3 314 Timp View Drive American Fork Goodrich 4 614 West Cedar Drive Lugo 750 South Apple Way American Fork Goodrich 6 7 Kingston Court Alpine 618 West Cedar Drive Lehi Lugo 8 321 North Choctaw American Fork Minkus 9 1370 Pinellas Road Alpine Lugo 10 1971 Glenview Road Lehi Minkus 1971 Glenvie w Road Lehi Minkus 15 West Oak Circle American Fork Hernandez 12 575 South Choctaw Alpine Goodrich 13 10995 SW 88 Court Lehi Goodrich 14 143 North Mountain View American Fork Carey 29 East Oak Circle American Fork Merkin 16 8030 Steeplechase Drive Alpine Merkin 2006 Cutwater Court Alpine Minkus 18 9876 South Sunset Avenue Eagle Mountain Hernandez 321 West Walnut Grove American Fork Goodrich 4081 Lybyer Avenue Alpine Minkus 4081 Lybyer Avenue Alpine Minkus 1900 Glenvie w Road Lehi Hernandez 9000 South Sunset Avenue Eagle Mountain Lugo 8432 South Sunset Avenut Eagle Mountain Minkus 831 South Weber American Fork Lugo 714 Timp View Lane American Fork Goodnich 26 240 East Jefferson Way Eagle Mountain Lugo 224 Rockaway Street Alpine Pijuan 260 East Jefferson Way Eagle Mountain Hernandez 290 East Jefferson Way Eagle Mountain Pijuan 8307 S Indian River Drive Lehi Hernandez 8307 S Indian River Drive Lehi Hernandez 123 Ivy Lane Eagle Mountain Pijuan 9408 Forest Hills Circle Cedar Hils Reuter 245 Ivy Lane Eagle Mountain Goodrich 11971 SW 269 Terrace Cedar Hils Carey 1857 Pine Drive Cedar Hils Hernandez 3461 East Lindon Way American Fork Reuter List Price Selling Price Listing Date Sale Date 725,000 $ 645,250 4/1/2012 6/16/2012 350,000 $ 340,000 4/1/2012 5/15/2012 418,000 $ 400,000 4/1/2012 6/1/2012 215,800 $ 200,000 4/1/2012 5/25/2012 385,900 $ 385,900 4/1/2012 4/30/2012 500,000 $ 465,000 4/3/2012 6/10/2012 300,000 $ 290,000 4/3/2012 6/1/2012 565,000 $ 535,000 4/6/2012 9/30/2012 219,000 $ 215,000 4/8/2012 6/2/2012 165,000 $ 156,750 4/12/2012 6/12/2012 165,000 $ 4/12/2012 6/12/2012 325,000 $ 320,000 4/12/2012 5/30/2012 750,250 $ 700,000 4/12/2012 11/1/2012 110,000 $ 106,000 4/12/2012 7/3/2012 314,250 $ 304,000 4/13/2012 8/5/2012 555,000 $ 500,000 4/13/2012 10/15/2012 450,000 $ 382,500 4/15/2012 6/30/2012 345,000 $ 339,999 4/18/2012 6/23/2012 300,000 S 300.000 4/18/2012 4/30/2012 425,000 $ 415,000 4/18/2012 6/30/2012 325,000 $ 308,750 4/19/2012 7/2/2012 325,000 S 308,750 4/19/2012 7/2/2012 325,000 $ 302,250 4/28/2012 6/1/2012 325,000 320,000 4/28/2012 5/28/2012 285,750 S 300,000 4/28/2012 6/3/2012 425,815 $ 400.000 4/28/2012 9/15/2012 250,000 S 232,000 4/29/2012 9/1/2012 515,000 $ 485,750 4/29/2012 8/25/2012 400,000 $ 375,000 4/30/2012 6/19/2012 450,000 $ 400,000 4/30/2012 10/1/2012 310,000 $ 300,000 4/30/2012 7/1/2012 250,000 $ 255,000 5/1/2012 6/18/2012 250,000 S 255,000 571/2012 6/18/2012 375,500 $ 375,500 5/1/2012 5/5/2012 185,500 $ 179,000 5/1/2012 6/6/2012 395,000 $ 375,000 5/1/2012 7/16/2012 410,000 S 397,700 5/1/2012 8/26/2012 560.700 $ 550.000 S/1/2012 5/30/2012 450,000 S 400,000 5/2/2012 9/30/2012 20 20 28 41 of 3 e 4:07 PM et 3, 2/11/20 Test Presentation - .. 38 39 46 50 16235 Orange Boulevard Cedar Hills Lugo 614 Lincoln Drive Eagle Mountain Reuter 2448 Woodacres Road Lehi Hernandez 40 401 Pinecone Circle Alpine Goodrich 401 Pinecone Circle Alpine Goodrich 421 Ivy Lane Eagle Mountain Pijuan 765 East Sheridan Lane Eagle Mountain Minkus 61 East Walnut Grove American Fork Goodrich 1414 N Sheridan Road Alpine Pijuan 487 Blue Skies Drive American Fork Goodrich 10700 Lake Shore Lane Cedar Hils Carey 73 East Oak Street Eagle Mountain Merkin 48 81 Island Drive South Alpine Bethune 3412 Kimer Street Lehi Carey 605 Reservoir Drive Alpine Reuter 605 Reservoir Drive Alpine Reuter 51 77 East Oak Street Eagle Mountain Bethune 400 Ivy Lane Eagle Mountain Bethune 1 Southampton Place Lehi Goodrich 3418 North Sunset Lane Eagle Mountain Bethune 1892 North 250 West American Fork Carey 56 1629 NW 43rd Street Cedar Hils Carey 57 3400 North Sunset Lanc Eagle Mountain Merkin 876 South California Way American Fork Hen 21 Compass Road Cedar Hils Merkin 34 West Oakley Drive American Fork Carey 34 West Oakley Drive American Fork Carey 30 Kent Road Lehi Bethune 140 East 3rd Street Eagle Mountain Hen 160 West Sth Street Eagle Mountain Carey 240 West 5th Street Eagle Mountain Reuter 520 E Spring Street Alpine Minkus 678 Mountain Circle American Fork Goodrich 3490 North Sunset Lane Eagle Mountain Minkus 4916 Rock Spring Road Cedar Hills Lugo Minkus Alpine 8923 Harris Drive 376 West Hadley Way American ForkHernandez 70 American Fork Hemandez 876 West Hadley Way 71 1132 SW 52nd Street Cedar Hils Hernandez 72 416 Eat Oak Eagle Mountain Merkin 395,000 $ 475,000 $ 450,000 $ 1,500,120 $ 1,500,120 $ 500,000 $ 460,750 S 375,000 $ 1,250,000 $ 365,750 $ 650,000 $ 325,000 $ 147,800 S 180,000 $ 310,000 $ 310,000 $ 345,000 S 375,000 $ 215,000 $ 450,000 S 315,250 $ 475,000 $ 400,000 S 316,000 $ 289,900 $ 345,000 $ 345,000 S 259,900 $ 399,000 $ 410,000 $ 285,750 S 189,900 $ 385.000 $ 250,000 275,000 589,000 S 345,670 $ 345,670 254,500 $ 300.000 $ 380,000 5/5/2012 7/16/2012 425,250 5/5/2012 9/23/2012 382,500 5/5/2012 6/16/2012 1,400,000 5/5/2012 9/30/2012 1,400,000 5/5/2012 9/30/2012 425,000 5/5/2012 11/15/2012 435,500 5/5/2012 11/1/2012 376,000 5/6/2012 5/15/2012 1,225,000 5/12/2012 6/6/2012 355,000 5/13/2012 8/15/2012 598,000 5/15/2012 6/9/2012 325,000 5/18/2012 5/31/2012 150,000 5/22/2012 6/16/2012 175,000 5/23/2012 7/15/2012 291,400 5/22/2012 6/29/2012 291,400 5/22/2012 6/29/2012 335,000 5/23/2012 6/23/2012 330.000 5/26/2012 3/30/2012 195,000 5/28/2012 6/18/2012 400.000 5/28/2012 8/1 5/2012 300,000 5/28/2012 8/1/2012 450.000 5/31/2012 8/19/2012 375,000 5/31/2012 7/15/2012 316,000 5/31/2012 6/30/2012 279.000 5/31/2012 6/1/2012 330,000 8/1/2012 8/1 5/2012 330.000 671/2012 8/15/2012 246,905 6/2/2012 9/2/2012 350,000 6/2/2012 11/30/2012 350.750 6/3/2012 10/15/2012 300,000 6/5/2012 7/1/2012 186,102 6/6/2012 7/26/2012 330,000 6/10/2012 9/15/2012 275,000 8/12/2012 6/25/2012 284,000 6/13/2012 7/21/2012 575,000 6/18/2012 7/8/2012 345,000 6/20/2012 9/30/2012 345,000 6/20/2012 9/30/2012 236.685 8/23/2012 9/21/2012 250,000 6/28/2012 11/2/2012 58 59 86 68 2 of 3 4:12 PM ep 42/11/2020 Test Presentation -. X e Manning exploring MANNING, MATTHEW MM ? 73 74 75 76 77 10 Vestal Drive 425 East Oak 876 West Holiday 103 Jasper Drive 516 East Oak 123 Oak Avenue 600 Ivy Lane 144 Oak Avenue 144 Oak Avenue 1600 Reeves Street Cedar Hills Carey Eagle Mountain Bethune Alpine Goodrich Lehi Bethune Eagle Mountain Pijuan American Fork Carey Eagle Mountain Pijuan American Fork Goodrich American Fork Goodrich Cedar Hills Reuter 555,000 $ 275,900 $ 475,000 $ 165,900 $ 299,999 $ 400,000 $ 339,999 $ 380,500 $ 380,500 5 565,000 250.000 455,000 159 264 200,000 400,000 310.000 365,000 365,000 233,605 6/24/2012 6/30/2012 6/24/2012 8/15/2012 6/24/2012 9/18/2012 6/29/2012 9/6/2012 6/29/2012 9/30/2012 6/30/2012 7/15/2012 6/30/2012 10/1/2012 6/30/2012 9/1/2012 6/30/2012 9/1/2012 6/30/2012 8/16/2012 79 80 245,900 $ 4 4:12 PM 2/11/2020 x Manning exploring.. Test Presentation -... e DELL