what are the steps for this excel lab?

4 Lab Exercises (for submission) Open Excel_Sess4_Lab1.xlsx. 1. Fill in the Sales Forecasts for years 2 to 5, based on the given Growth Assumptions. This is the "Normal scenario 2. Load the Solver add-in, and create two more scenarios as follows: Optimistic' scenario - the total sales in year 5 is $2,000,000 Pessimistic' scenario - the total sales in year 5 is $1,000,000 3. Using a suitable chart type, display the Total Sales from Year 1 to Year 5. Company A's sales forecast for the next 5 years Sales Forecasts Year 3 Year 4 Year 2 Year 5 Shoes Jeans Belts Caps Total Sales Year 1 $125,000 $500,000 $240,000 $80,000 $945,000 Growth Assumptions 15% 10% 15% 20%