c. Create a new worksheet in the same spreadsheet. Include the aggregated calculations: these are calculations that combine data from several different places. Your new worksheet should look at both the weekly average and the average for a single day (Monday, Tuesday, etc.) for each of the following areas: The average sales for each department The average cost of purchasing (CoG) these goods for each department Use the appropriate formulas in the spreadsheet. You don't need to do these calculations yourself (on paper or with a calculator). Instead, use these formulas and functions: SUM AVERAGE PRODUCT or multiplication QUOTIENT or division COUNTIF or COUNTA IF d. Use charts and graphs to accurately display the financial data. This will help your manager quickly make sense of the data. For each display, be sure to create an appropriate title and to label all data directly on your display so that any reader will be able to understand the information you are sharing. Choose two of these items to represent graphically: A bar chart that shows the average daily revenue (in dollars) for each department A pie chart that shows the average daily gross profit (in percentages) for each department A bar chart