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 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 entire table of data in the Previous Year worksheet, create a forecast sheet.
b. Use 6/30/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 it covers the range C2:E13.
