14 5 The widths of the columns containing the Days on Market, List Price, and Sold Price data need to be adjusted for better appearance. Set the Days on Market column width to 9. Set the List Price and Sold Price column widths to 11.86. The property listings dataset is small. To improve readability on the printed copy for the other real estate agents, you will increase the scaling. Apply 120% scaling You don't need the data on the Properties sheet but you do want to insert another sheet for formulas. 2 15 5 16 Delete the Properties sheet and insert a new sheet named Formulas. Emphasis Heading 1 Heading 2 Normal Normal Od 17 You want to copy the original data to the new sheet so that you can modify the duplicated data Use the Select All feature to select all data on the Houses Sold worksheet and copy it to the Formulas worksheet 18 You do not want to display the columns containing dates on the new worksheet. Hide the Date Listed and Date Sold columns in the Formulas worksheet. HO 19 3 20 7 7 You want to review the formulas within the worksheet and prepare the Formulas sheet to be printed Display cell formulas. Set options to print row and column headings. Set 6.86 column width for column E and 6 for column H. You want to apply page setup options to both sheets, so you need to group the sheets first. Group the two worksheets. Select Landscape orientation Center the page horizontally and vertically between the margins. With both worksheets still grouped, insert a footer with the text Exploring Series on the left side, the sheet name code in the center, and the file name code on the right side. Save and close Exp19_Excel_Cho1 ML2 Sales.xlsx Exit Excel. Submit the file as directed. 21 5 22 0 14 5 The widths of the columns containing the Days on Market, List Price, and Sold Price data need to be adjusted for better appearance. Set the Days on Market column width to 9. Set the List Price and Sold Price column widths to 11.86. The property listings dataset is small. To improve readability on the printed copy for the other real estate agents, you will increase the scaling. Apply 120% scaling You don't need the data on the Properties sheet but you do want to insert another sheet for formulas. 2 15 5 16 Delete the Properties sheet and insert a new sheet named Formulas. Emphasis Heading 1 Heading 2 Normal Normal Od 17 You want to copy the original data to the new sheet so that you can modify the duplicated data Use the Select All feature to select all data on the Houses Sold worksheet and copy it to the Formulas worksheet 18 You do not want to display the columns containing dates on the new worksheet. Hide the Date Listed and Date Sold columns in the Formulas worksheet. HO 19 3 20 7 7 You want to review the formulas within the worksheet and prepare the Formulas sheet to be printed Display cell formulas. Set options to print row and column headings. Set 6.86 column width for column E and 6 for column H. You want to apply page setup options to both sheets, so you need to group the sheets first. Group the two worksheets. Select Landscape orientation Center the page horizontally and vertically between the margins. With both worksheets still grouped, insert a footer with the text Exploring Series on the left side, the sheet name code in the center, and the file name code on the right side. Save and close Exp19_Excel_Cho1 ML2 Sales.xlsx Exit Excel. Submit the file as directed. 21 5 22 0