7. Olivia wants to consolidate the sales data in the United States, Canada, and Australia on the All Locations worksheet. Ungroup the worksheets, go to the All Locations worksheet, and then consolidate the data as follows: a. b. C. d. In cell B6, enter a formula using the SUM function and a 3D reference to total the number of downloads of Adventure audio books in January (cell B6) in the United States, Canada, and Australia. I Copy the formula in cell B6 to calculate the number of downloads for the other types of books and months (ranges B7:B11 and C6:E11), pasting the formula only. In cell B16, enter a formula using the SUM function and a 3D reference to total the sales of Adventure audio books in January (cell B16) in the United States, Canada, and Australia. Copy the formula in cell B16 to calculate the sales for the other types of books and months (ranges B17:B21 and C16:E21), pasting the formula only.