Open the AnswerSheet worksheet in the Chapter $2$ DA Exercise $1$ workbook. $2.$ 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. $3.$ The description provided for this assignment states that two additional years of data will be added to this workbook. When considering the Data Design component of the Data Analytics Model, where should totals or a summary of the data be placed in this workbook? Type your answer in the AnswerSheet worksheet. $4.$ Briefly explain how you would conduct a basic data audit based on the description for this assignment. Type your answer in the AnswerSheet worksheet. $5.$ Highlight the range A$1$:H$25$ in the Sheet$1$ worksheet. $6.$ In the Home tab of the Ribbon, set the font style to Arial and the font size to $12$ points. $7.$ Set the width of column A to $20$ points. Click any cell in column A and use the Format button in the Home tab of the Ribbon. $8.$ Insert a column between columns A and B$.$ Click any cell in column B and use the Insert button in the Home tab of the Ribbon. $9.$ Type the words "Category Count" into cell B$1.$ This column will be used to conduct a basic data audit to verify that there are eight expense categories for each year. $10.$ Type the number $1$ in cell B$2$ and then type the number $2$ in cell B$3.11.$ Highlight cells B$2$ and B$3.12.$ Use Auto Fill to complete the number sequence down to the last row for the year $2017$ which is cell B$9.$ To use Auto Fill, place the mouse pointer over the Fill Handle in the lower right corner of cell B$3.$ When the mouse pointer changes to a black plus sign, click and drag down to cell B$9.$ The value in cell B$9$ should be the number $8.$ This shows that there are eight expense categories for the year $2017.13.$ To continue the basic data audit, type the number $1$ in cell B$10$ and the number $2$ in cell B$11.14.$ Highlight cells B$10$ and B$11.$ Use Auto Fill as instructed in step $12$ to complete the sequence down to the last row for $2018,$ which is B$17.15.$ To complete the basic data audit, type the number $1$ in cell B$18$ and the number $2$ in cell B$19.16.$ Highlight cells B$18$ and B$19.$ Use Auto Fill as instructed in step $12$ to complete the sequence down to the last row for $2019,$ which is B$25.17.$ Since the basic data audit is complete, column B can be hidden. Click any cell in column B and then hide the column by using the Format button in the Home tab of the Ribbon. $18.$ Insert a blank column to the left of column A$.$ Click any cell in column A and use the Insert tab in the Home tab of the Ribbon. $19.$ KO Highlight the range D$1$:D$25$ and use the Cut command by pressing the CTRL key and then tapping the X key on your keyboard. $20.$ KO Use the arrow keys on your keyboard to activate cell A$1.$ To use the Paste command, press and hold the CTRL key and tap the V key on your keyboard.