Question: 1. Excel Project: Aggregating Data at Different Levels You are an internal auditor for the city of Burlington, Vermont. Download the data file P6- 3Burlington

1. Excel Project: Aggregating Data at Different
1. Excel Project: Aggregating Data at Different Levels You are an internal auditor for the city of Burlington, Vermont. Download the data file "P6- 3Burlington VermontData.xlex" from the student download page at http://www.pearsonhighered.com/romney, which contains all the annual account balance information for city departments for six fiscal years. In this workbook are two sheets. The "Annual Data" sheet contains data aggregated to the annual level for the different city departments. The "Monthly Data" sheet contains data aggregated to the monthly level for the different city departments. You are planning to perform audit procedures on the "Monthly Data." But before you do, you need to verify that the data in this sheet matches the data in the "Annual Data" worksheet, which you already verified is correct. REQUIRED Analyze the two sheets and based on your analysis, answer the following questions: a) Under what circumstances can you not use the "Annual Data" sheet for your audit? Said differently, why might you need the data in the "Monthly Data" sheet? I will use the data in "Monthly Data" sheet when I need to analyze monthly performance and want to know the exact number in each month

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!