Question: 1.Gi||:ierto Ray is a nancial analyst for Flex'f Wireless Communications. a telecommunications company in Sacramento. California. In addition to cell phones and wireless plans. Flex};r

1.Gi||:ierto Ray is a nancial analyst for Flex'f Wireless Communications. a telecommunications company in Sacramento. California. In addition to cell phones and wireless plans. Flex};r 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 anaiysis. Go to the Annual Sales worksheet. In the range 85:39. Gilberto wants to consolidate the sales data from Quarters 14 in the previous year. in cell BS. enter a formula using the SUM function and 313 references to total the sales for batteries and chargers using the data on the Quarter 1. Quarter 2. waiter 3. and {marter 4 worksheets. Fill the range 35:39 with the formula in cell ES to calculate the total annual sales for the other types of accessories
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
