Project Management Answers

In the Innovative Speakers case, Solver was used to generate an optimal outcome by trying every possible value in a range of cells in the model.

Q: In the Innovative Speakers case, Solver was used to generate an optimal outcome by trying every possible value in a range of cells in the model.

or

Q: By attempting every value in a range of model cells, Solver was utilized in the Innovative Speakers scenario to provide the best result.

  • F8:H10
  • C13:E13
  • C4:E4
  • H4
  • All of these

Explanation: Solver requires an objective function to be a single value (e.g., a cell with a formula to maximize, minimize, or set to a specific value). The cell contains the result that the Solver will try to optimize.

Leave a Reply

Your email address will not be published. Required fields are marked *