both pages

7-9

a. In cell C6, enter a formula using the SUM function and a 3D reference to total the number of chocolate chip cookie dough packages sold in Quarter 1 (cell B6) in Jefferson elementary, middle, and high schools. b. Copy the formula in cell c6 to calculate the number of sales for the other flavors and quarters (range C6:F10), pasting the formula only. c. In cell C15, enter a formula using the SuM function and a 30 reference to total the sales amounts for chocolate chip cookie dough packages sold in Quarter 1 (cell B15) in Jefferson elementary, middle, and high schools. d. Copy the formula in cell c1s to calculate the sales for the other flavors and quarters (range C15:F19), pasting the formula only. 8. Allison wants to round the total sales values for each quarter so that they are easier to remember. a3. In cell c20, add the ROUNDup function to display the total sales for Quarter 1. rounded up to 0 decimal places. b. Fill the range D20:F20 with the formula in cell c20. 9. In cell G22, Allison wants to display the total fundraising sales from the previous year. This data is stored in another workbook, Insert the total as follower 5. Allison thinks each school has a good chance of increasing the average number of fundraising items sold to 125 in Quarter 4 next year. For Quarter 1 , she estimates 80 fundraising items sold, which is the average number sold each quarter this year. Project the average number of items sold next year by filling the series for the first projection (range H7:K7) with a linear trend. 6. Allison also wants to know how the average number of items sold would increase if people bought 5% more fundraising items next year. Project the average number of items sold next year for the second projection (range H9:K9) based on a growth series using 1.05 as the step value. 7. Allison wants to consolidate this year's sales data for the elementary, middle, and high schools on the All Schools worksheet. Ungroup the worksheets, go to the All sehools worksheet, and then consolldate the data as follows: a. In cell c6, enter a formula using the sum function and a 30 reference to total the number of chocolate chip cookie dough packages sold in Quarter 1 (cell B6) in Pefferson elementary, middie, and high schools