Open the AnswerSheet worksheet in the Chapter $2$ DA Exercise $2$ workbook.

Define each component of the DATA Analytics Framework in the AnswerSheet worksheet. Read the assignment description before typing a response for each component of the framework.

Open the Sheet$1$ worksheet. Notice that row $6$ is a Totals row which sums the sales data for each year. When considering the Data Design component of the Data Analytics Model, is this an appropriate place to sum the data for this analysis? Briefly explain why this is or is not an appropriate design choice in the AnswerSheet worksheet.

Open the Sheet$1$ worksheet. For columns B through F$,$ the Total row $($row $6)$ is summing the values in rows $2$ through $5.$ Conduct a simple data audit by using the Sum information in the Excel Status Bar. Verify that the values in rows $2$ through $5$ in each column match the total value that is displayed in row $6.$ Note any discrepancies from your data audit in the AnswerSheet worksheet.

In the Sheet$1$ worksheet, type the year $2015$ into cell B$1.$

Use Auto Fill to fill the years $2016$ to $2019$ in the range C$1$:F$1($hint: you will need to use the Auto Fill dropdown menu$).$

Change the font style to Arial and the font size to $12$ points in the range A$1$:F$6.$

Insert a blank row above row $1.$

Merge and center the cells in the range A$1$:F$1.$

Enter the title for this worksheet into the merged range A$1$:F$1$ on two lines. The first line should read Sales Trend Analysis. The second line should read Annual Sales by Division.

Increase the height of Row $1$ to $50$ points.

KO Make the following formatting adjustments to the merged range A$1$:F$1$: bold, italics, change the font style to Arial, and change the font size to $14$ points.

Set the alignment of the merged range A$1$:F$1$ to Middle Align.

Change the cell fill color of the merged range A$1$:F$1$ to Purple $,$ Accent $4,$ Lighter $80\%.$

KO Increase the height of Row $7$ to $30$ points.

KO Format the range A$7$:F$7$ with bold and italics.

Format the values in the range B$3$:F$7$ with the Accounting Number Format and reduce the decimal places to zero.

Make the necessary adjustments to remove any pound signs $($####$)$ that may have occurred after formatting the values.

KO Increase the width of column A to $25$ points.

KO Apply the bold format to the range B$2$:F$2.$

KO Center align the years in the range B$2$:F$2.$

KO Add a blank worksheet to the workbook.

Open the Sheet$1$ worksheet.

KO Copy the data in the range A$2$:F$7$ in the Sheet$1$ worksheet.

KO Open the Sheet$2$ worksheet and activate cell A$1.$

KO Paste the data into the Sheet$2$ worksheet.

Increase the width of columns A through F to $15$ in the Sheet$2$ worksheet.

Rename the Sheet$2$ worksheet to Data Copy.

Rename the Sheet$1$ worksheet to Division Sales.

Add vertical and horizontal lines to the range A$1$:F$7.$

Add a very bold orange border around the perimeter of the range A$1$:F$7.$

Save the workbook by adding your name in front of the current workbook name $($i$.$e$.,$ Your Name Chapter $2$ DA Exercise $2).$

Close the workbook and Excel.