Gilberto Ray is a financial analyst for Flexy Wireless Communications, a telecommunications company in Sacramento, California. In addition to cell phones and wireless plans, Flexy sells electronic accessories, such as charging pads and headphones. Gilberto is analyzing the revenue generated from the sales of accessories and asks for your help in completing the analysis.
I
画
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. In excel
, you can do this by using a 3D reference to sum the sales data from multiple worksheets.
Here's how you can do it:
1. Click on cell B5 in the Annual Sales worksheet.
2. Enter the formula =SUM('Quarter 1:Quarter 4'!B5) and press Enter. This formula will sum the sales data in cell B5 from the Quarter 1, Quarter 2, Quarter 3, and Quarter 4 worksheets.
3. Fill the range B6:B9 with the same formula in cell B5 to calculate the total annual sales for the other types of accessories. You can do this by dragging the fill handle (the small square at the bottom right corner of the cell) down to fill the range B6:B9 with the formula.
Once you have completed these steps, the range B5:B9 in the Annual Sales worksheet will display the total annual sales for each type of accessory based on the data from Quarters 1-4 from the previous year. Gilberto will be able to use this information to analyze the revenue generated from the sales of accessories at Flexy Wireless Communications.