In the first quarter of the year, Flexy Wireless sold $2550$ units of a new smart home product called Home Hub. The company wants to increase the sales of the new product to $3000$ units by the fourth quarter.

Project the sales for Quarters $2,3,$ and $4$ by filling the series for the first projection $($range F$7$:I$7)$ with a linear trend.

Gilberto also wants to know how many Home Hub units the company would sell if sales increased by two percent each quarter.

Project the sales for Quarters $2,3,$ and $4$ for the second projection $($range F$9$:I$9)$ based on a growth trend using $1\mathrm{.}02$ as the step value.

Gilberto wants to visualize how the sales of each type of accessory contributed to the total annual sales for $2021.$

Create a $2-$D pie chart that shows how each type of accessory.$($range A$5$:A$9)$ contributed to the total $2021$ sales $($range B$5$:B$9).$ Move and resize the chart so the upper$-$left corner is in cell $A14{?}_{(})$ and the lower$-$right corner is in cell D$30.$

To make the $2-$D pie chart easier to interpret, type Accessory Sales $2021$ as the chart title. Add data labels to the chart on the Inside End of each slice. Display the Value and Percentage in the data labels.

Go to the Quarter $1$ worksheet. Gilbirrto wants to use a copy of the worksheet to track sales in $2022.$ Create a copy of the Quarter $1$ worksheet at the end of the workbook. Rename the copy using Quarter $12022$ as the worksheet name.

On the Quarter $12022$ worksheet, clear only the contents from the range $B5$:$B9.$ In cell B$4,$ use $2022$ Sales as the column heading. In cell D$4,$ use $2023$ Sales as the column heading.