All of the following statements are TRUE regarding Solver EXCEPT: The purpose of using Solver is to perform what-if analysis to solve more complex problems and to optimize the outcome. For the Solver to work properly, the formula in the result cell must reference and depend on the variable cells for part of its calculation Prior to configuring the Solver variables , you need to ensure that you create a spreadsheet model that can be used to manipulate the values for your constraints . Business managers can use Solver to minimize or maximize the output based on the constraints