Using the Internet, conduct a thorough search for more information on performing What-If Analysis in Excel. Choose one bullet listed below and explain and also include a reason to use in your worksheet that may benefit you in your chosen career field.

• Explore the principles of cost-volume-profit relationships
• Create a one-variable data table
• Create a two-variable data table
• Create and apply different Excel scenarios with the Scenario Manager
• Generate a scenario summary report
• Generate a scenario PivotTable report
• Explore the principles of a product mix
• Run Solver to calculate optimal solutions
• Create and apply constraints to a Solver model
• Save and load a Solver model