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 Schools worksheet, and then consolidate the data as follows:

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.

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.

In cell C15, enter a formula using the SUM function and a 3D 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.

Copy the formula in cell C15 to calculate the sales for the other flavors and quarters (range C15:F19), pasting the formula only.

Module 5 Textbook project