09 Nov computer applications homework
Using the Internet, conduct a thorough search for more information on using What-If Analysis as outlined in eText Excel Module 8. Choose one bullet listed below and explain and also include a reason to use in your worksheet for your bullet from the following:
Choose only one from the following and explain in detail; do not just list the steps to create unless stated:
Session 8.3
- 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
You may also answer one of the following questions with a 150-word count to reply to my post and meet the requirement:
- What is an add-in?
- What are three options for the objective cell using Solver?
- What is an objective cell? What is a variable cell?
- What are the six types of constraints you can put on a cell in a Solver model?
- What is an iterative process?
- What is the difference between a binding constraint and a nonbinding constraint?
- In the Solver report, what is meant by the term “slack”?
Be sure to cite your sources using APA style format.
