Enter the number $14\mathrm{.}99$ into cell C$28$ in the Sheet$1$ worksheet.Enter the number $9500$ into cell E$28$ in the Sheet$1$ worksheet.Insert a new worksheet into the workbook.Highlight the range E$2$:E$28$ in the Sheet$1$ worksheet.Conduct a basic data audit by identifying the Sum in the Status Bar for the highlighted values in Sheet$1.$ Enter the Sum identified in the Status Bar into cell A$1$ in the Sheet$2$ worksheet.Enter $2019$ into cell A$17$ in the Sheet$1$ worksheet.Copy cell A$17$ and paste it into the range A$18$:A$28.$Highlight the range B$17$:B$18.$ Use Auto Fill to complete the months of the year in the range B$19$:B$28.$Delete the Sheet$3$ worksheet.Enter the word Year in cell A$1$ in the Sheet$1$ worksheet.Delete column D on the Sheet$1$ worksheet.Insert a column to the left of column C$.$Move the data in the range E$1$:E$28$ to column C into the range C$1$:C$28.$Edit cell B$1$ so the entry shows the word "Month".Edit cell D$1$ so the entry shows the words "Average Price".Insert a blank row above row $1.$Increase the width of column B to $12$ points.Increase the height of row $1$ to $39\mathrm{.}75$ points.Format cell D$2$ so the text wraps to a second line and does not run into cell E$2.$Set the horizontal alignment to Center for the column headings in the range A$2$:D$2.$Format the data in the range A$1$:D$29$ to an Arial font style.Format the values in the range C$3$:C$29$ with a comma and zero decimal places.Format the values in the range D$3$:D$29$ with the Accounting format.Hide rows $3,4,$ and $5.$Merge and center the cells in the range A$1$:D$1.$Type Unit Sales Data into merged cell A$1.$ Start a second line, and type the words $"$by Month".Set the vertical alignment for the merged cell A$1$ to Middle.Format the text in the merged cell A$1$ to Bold and Italics.Change the font size in the merged cell A$1$ to $14$ points.Change the color of the merged cell A$1$ to Blue, Accent $5,$ Lighter $80\%.$Change the color of the text in the merged cell A$1$ to Red.Add plain black horizontal and vertical borders to the range A$1$:D$29.$Add a double line border to the bottom of the range A$1$:D$2.$ Make the color of the border orange.Change the color of the Sheet$1$ worksheet tab to purple.Change the name of the Sheet$1$ worksheet to Sales Report.Save the workbook by adding your name in front of the current workbook name $($i$.$e$.,$ Joseph Manzo Chapter $2$ Skills Test$).$Close your workbook and exit Excel.