Matching
Match the following terms with the corresponding description.
Premises:
Objective cell
Solver Report
Goal Seek
Solver
Set Cell
Responses:
The formula cell to be optimized with Goal Seek
specifies the cell that contains a formula that produces a value that you want to optimize
A tool that identifies the necessary input value to obtain a desired goal
An add-in application that manipulates variables based on constraints to find the optimal solution to a problem
A new worksheet that contains the results of the Solver Add-in
Correct Answer:
Premises:
Responses:
Objective cell
Solver Report
Goal Seek
Solver
Set Cell
Premises:
Objective cell
Solver Report
Goal Seek
Solver
Set Cell
Responses:
Related Questions
Q4: In order to complete a two-variable data
Q16: The _ replaces the original input value
Q19: When creating a one-variable data table,one or
Q21: Match the following terms with the corresponding
Q23: Which of the following what-if analysis tools
Q53: A(n)_ is a constraint that does not
Q61: When calculating the optimal blend of down
Q62: Which what-if analysis tool is best to
Q68: In order to complete a two-variable data
Q70: When creating a one-variable data table with