PROJECT STEPS

Cilberto 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.

Go to the Annual Sales worksheet. In the range B$5$:B$9,$ Gilberto wants to consolidate the sales data from Quarters $1-4$ in the previous year. In cell B$5,$ enter a formula using the SUM function and $3$D 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 B$6$:B$9$ with the formula in cell B$5$ to calculate the total annual sales for the other types of accessories.

Gilberto also wants to display the total accessory sales from the previous year. This data is stored in another workbook.

In cell B$12$ of Gilberto's workbook, insert a formula using an external reference to cell B$10$ in the Accessories worksheet in the Support$\_$EX$365\_2021\_$EOM$51\_$Accessories.xlsx workbook.

Gilberto wants to make some changes to all five worksheets, which have the same structure,

Group the Annual Sales, Quarter $1,$ Quarter $2,$ Quarter $3,$ and Quarter $4$ worksheets. In cell $F1$ of the Annual Sales worksheet, enter a formula using the TODAY function to display today's date.

In the range D$5$;D$9$ on all five worksheets, Gillberto wants to project next year's sales for each accessory, rounded up to zero decimal places so the values are easier to remember,

In cell D$5,$ enter a formula using the ROUNDUP function that adds the sales for batteries and chargers in $2023($cell B$5)$ to the sales for the same accessories $($cell B$5)$ multiplied