need to open the existing workbook they provided, save it with a new name, and

Mark’s Construction and Realty Mark’s Construction and Realty buys and flips houses. They have hired you to look at their sales numbers from last year to analyze the data. They have instructed you to see if there are any trends in the types of houses they typically purchase, if there is a correlation between the number of houses sold and sale date, and which sales should be included in the project managers’ year-end bonus. You need to open the existing workbook they provided, save it with a new name, and make a few preliminary modifications. a. Open the workbook and save the workbook as . b. Change the width of column E to . c. Insert a new row above row 1. d. Enter the text in , change the font size to and apply . e. Add a fill color of for . f. the . g. Freeze the headers so when you scroll down the headers are always visible. You are ready to calculate the total costs. h. Insert two columns after Sale Price named and respectively. i. Insert a function in to calculated the total cost of each project. j. Insert a function in to calculated the profit of each project. k. Create an IF statement in where if the profit is greater than $50,000 it will display the text , otherwise it will display the text . l. Copy the three formulas down their respective columns. The company has already collected data about how many of each type of house they sold each month. You will convert the data into a table, apply a table style to make the data more visually appealing, and add total rows for use in the analysis grids later. m. Click the worksheet and rename it . n. Convert the entire dataset into a new table named with a table style of . o. Calculate a total for each house type in column N. You will analyze each house type to determine if the company has a tendency to purchase a certain type of a house. p. Create a that displays the total number of houses by house type and apply chart type . q. Move the chart to the left side of the screen directly under the table data. r. Change the chart title to . s. Move the legend to the top-left corner. t. Explode the largest piece of the pie to a Point Explosion of u. Add data labels to the chart. You will analyze the sales numbers across each month to determine in which months buyers tend to purchase houses. v. Calculate a new total row for each month. w. Create a that displays total house sales by Month and apply chart style and move it to the right of the pie chart. x. Change the chart title to y. Change the plotted line color to . z. Add a column to the Date table after called . aa. Add a sparkline for each house type over the 12-month period in the new Sparkline column. You will make some small formatting changes. bb. Set the page orientation to . cc. Insert a footer with your instructor’s name on the left side, the date in the center, and your Last,First name on the right side. dd. Save and close the workbook. Based on your instructor’s directions, submit e00_cumexam_LastFirst.