Do in excel please show steps and formulas

Instructions el 201 EX16 XL_ CH04_GRADER CAP AS-Mountain View Realty 1.6 Project Description: You work at Mountain View Realty A coworker developed a spreadsheet cataloging houses listed and sold during the past veveral months. She included addresses, location, ist price, selling price, listing date, and date soid. You want to convert the fata to a table. You will manage the large woksheet prepare the worksheet for printing, sort and er the table include caloulations, and then Steps to Perform: Step Freeze the on the Sales Data worksheet 3 Convert the data to a table and apply the Table Style Medium 17. 4 Remove duplicate reconds Inpart a neu feld immedately to the right of the Seling Price feld. Name the new teld 8 Create a fomula with structned neferences to caloulabe the percetnge of the let pcs pn Format the field with Percent Style with one decimal place Insert a new feld to the right of the Sale Date Seld Name the new teld Days on Market of days on Apply the General Add a tofal now to display the approprtate 11 Sort the table by olty in alphabetica l arder and add a second level to sort by days on market with the houses on the markot the longst at the top within each city all data is visible.Wrap the cokm 4 Add a page break at Row 30 so thait the city dta doos no span between pages, and netumt 5 Add a footer with your name on the let side, the shet ede in the center, and name code on the right side Display the Fitered Dats worksheet Fiter the data to display the otes of Alpine, CederHik and Eagle Mountain Faerthe datatodspley records for houses f at ontho market 30 day"ormoo Apply the condsional formating 3Amows (Coloned) lcon set to the Days on Makot vaues 5 f29093 17 P 307-3 o he sheet 22 Selet Landscape oentation and set appropriate margis so that the data will prient onon close the Sie Submit the Se Total Points Instructions el 201 EX16 XL_ CH04_GRADER CAP AS-Mountain View Realty 1.6 Project Description: You work at Mountain View Realty A coworker developed a spreadsheet cataloging houses listed and sold during the past veveral months. She included addresses, location, ist price, selling price, listing date, and date soid. You want to convert the fata to a table. You will manage the large woksheet prepare the worksheet for printing, sort and er the table include caloulations, and then Steps to Perform: Step Freeze the on the Sales Data worksheet 3 Convert the data to a table and apply the Table Style Medium 17. 4 Remove duplicate reconds Inpart a neu feld immedately to the right of the Seling Price feld. Name the new teld 8 Create a fomula with structned neferences to caloulabe the percetnge of the let pcs pn Format the field with Percent Style with one decimal place Insert a new feld to the right of the Sale Date Seld Name the new teld Days on Market of days on Apply the General Add a tofal now to display the approprtate 11 Sort the table by olty in alphabetica l arder and add a second level to sort by days on market with the houses on the markot the longst at the top within each city all data is visible.Wrap the cokm 4 Add a page break at Row 30 so thait the city dta doos no span between pages, and netumt 5 Add a footer with your name on the let side, the shet ede in the center, and name code on the right side Display the Fitered Dats worksheet Fiter the data to display the otes of Alpine, CederHik and Eagle Mountain Faerthe datatodspley records for houses f at ontho market 30 day"ormoo Apply the condsional formating 3Amows (Coloned) lcon set to the Days on Makot vaues 5 f29093 17 P 307-3 o he sheet 22 Selet Landscape oentation and set appropriate margis so that the data will prient onon close the Sie Submit the Se