chapter 4 (front and back) excel

chapter 3 (front and back)

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 pne 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 Apply the General percentage of list price 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 Add a page break at Row 38 so thait the city dta doos no span between pages, and netumt 4 5 Add a footer with your name on the let side, the shet ede in the name code on the right side and Eagle Mountain Faerthe datatodspley rooods for houses f at ontho market 30 day"ormoo Display the Fitered Dats worksheet Fiter the data to display the otes of Alpine, CederHik 5 f29w9J 17 Apply the condsional formating 3Amows (Coloned) lcon set to the Days on Makot vaues 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 EX16 XL_CH03 GRADER CAP AS-Movie Source 1.11 Steps to Perfom Remove the legend Select he range B5.E11.Inet ine Sparkines in the range Show the high paint and makers for the spakines Change the high point marker color to Red Change the low point marker to e Chart for Genre Apply bold and ue font color to the bar chart chat Move he chart to new sheet. Type Br chart and type Novenber 213 Weelky Dewnloads by 13 Apply 11 pt font size to the category and the legend r he bar chart 15 Change colors and apply Monachromaic Paiene&to the bar chan(lue gradent, light to Step 6 Apply a gradient si, using any preset or color, to the plot area in the bar chart P 212-233 17 Apply landscape orientation for the Dats worksheet Apply horinontal and vertical centering on the page options for the Deta worksheet Ensure that the worksheets are corectly named and placed in the following order in the and then exdt Excel Total Point 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 pne 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 Apply the General percentage of list price 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 Add a page break at Row 38 so thait the city dta doos no span between pages, and netumt 4 5 Add a footer with your name on the let side, the shet ede in the name code on the right side and Eagle Mountain Faerthe datatodspley rooods for houses f at ontho market 30 day"ormoo Display the Fitered Dats worksheet Fiter the data to display the otes of Alpine, CederHik 5 f29w9J 17 Apply the condsional formating 3Amows (Coloned) lcon set to the Days on Makot vaues 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 EX16 XL_CH03 GRADER CAP AS-Movie Source 1.11 Steps to Perfom Remove the legend Select he range B5.E11.Inet ine Sparkines in the range Show the high paint and makers for the spakines Change the high point marker color to Red Change the low point marker to e Chart for Genre Apply bold and ue font color to the bar chart chat Move he chart to new sheet. Type Br chart and type Novenber 213 Weelky Dewnloads by 13 Apply 11 pt font size to the category and the legend r he bar chart 15 Change colors and apply Monachromaic Paiene&to the bar chan(lue gradent, light to Step 6 Apply a gradient si, using any preset or color, to the plot area in the bar chart P 212-233 17 Apply landscape orientation for the Dats worksheet Apply horinontal and vertical centering on the page options for the Deta worksheet Ensure that the worksheets are corectly named and placed in the following order in the and then exdt Excel Total Point