The purpose of this exercise is to analyze a worksheet to determine whether there are any integrity flaws. First, read the scenario below. Then, open the file that is related to this exercise and analyze the worksheets contained in the workbook. Use the AnswerSheet worksheet for any written responses required for this exercise.

Scenario

You are sharing an Excel workbook with a coworker. She sends you the workbook as an attachment in an email and includes the following message: I added the 4th quarter (October, November and December) sales numbers from 2018 to 2019 in the Data worksheet. I saw that you already had a PivotTable created so the entire fiscal year should now be included in the Sales Report worksheet. It looks like sales grew about $11,000 from 2018 and 2019. I know there were concerns that sales would decline in 2019, but it looks like our sales actually grew.

Assignment

Analyze the data in this workbook carefully. Do you agree with your coworkers assessment that sales grew from 2018 to 2019? Use the AnswerSheet worksheet to briefly explain if you believe there are any issues with your coworkers conclusion.

Adjust the PivotTable in the Sales Report worksheet to verify it includes all of the data in the Data worksheet.

If your analysis reveals that the output on the PivotTable was not accurate based on the data in the Data worksheet, add the appropriate data internal controls to the workbook to ensure that would reduce the risk of similar problems occurring in the future.

Create a new PivotTable that compares the total sales for the entire year for 2018 and 2019. The worksheet tab should read New PivotTable. Make any appropriate formatting adjustments.