Go to the Annual Sales worksheet. In the range B5:B9, Gilberto wants to consolidate the sales data from Quarters 1-4 in the previous year. In cell B5, enter a formula using the SUM function and 3D references to total the sales for batteries and chargers using the data on the Quarter 1, Quarter 2, Quarter 3, and Quarter 4 worksheets. Fill the range B6:B9 with the formula in cell B5 to calculate the total annual sales for the other types of accessories.