Logo
0

question number 2 help Module 10 1b

  1. Go to the Monthly Sales worksheet, which lists the sales per month for the previous year in a table and compares the sales in a chart. Lucia imported this data from the Orders table in an Access database. She wants to track the changes in monthly sales and project the first six months of this year's sales.

Create a forecast sheet as follows to provide the data Lucia requests:

  • a. Based on the data in the range B2:C14, create a forecast sheet.
  • b. Use 6/30/2022 as the Forecast End date to forecast the next six months.
  • c. Use Jan to June 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 E13.

mentalmavensmentalmavens asked a year ago

·

Answers

It's lonely here.

Post your answer

Recommended Books

Reading books is a great way to learn. Here are some of the books we recommend.