1. Open the AnswerSheet worksheet in the Chapter 2 DA Exercise 2 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. Open the Sheet1 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. 4. Open the Sheet1 worksheet. For columns B through F, the Totals 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. 1 2 Cloud Services 100000 3 Laptops and Tab 4 Cell Phones 5 Servers 6 Totals 7 176000 240000 185000 190000 195000 200000 220000 240000 400000 330000 280000 885000 916000 955000 330000 370000 200000 205000 270000 300000 180000 150000 800000 1025000 A B C D E F G H 1 Use this worksheet to answer any written questions for this exercise. 2 Type your answer in the Reponse column. Questions 1, 2, and 3 Response 34567 00 6 D 10 HO 11 12 A 13 T 14 15 16 456 17 A 18 19 20 21 Data 22 Design 22222 23 24 25 Data 26 Audit 27 28