Go to the Previous Year worksheet, which lists the sales per month for the previous year in a table and compares the sales in a chart. Jacob imported this data from the Orders table in an Access database. He wants to track the changes in monthly sales and project

erspectives Excel $365/2021|$ Module $10$: SAM Project la

the first six$-$months of this year's monthly sales. Create a forecast sheet as follows to provide the data Jacob requests:

a$.$ Based on the data in the range $A2$:$B14,$ create a forecast sheet.

b$.$ Use $\frac{6}{30}\frac{?}{2025}$ as the Forecast End date to forecast the next six months.

c$.$ Use Six Month Forecast as the name of the new sheet.

d$.$ Resize and move the forecast chart so that the upper$-$left corner is within cell $C2$ and the lower$-$right corner is within cell E$12.$