Matching
Match the following terms with the corresponding description.
Premises:
Goal Seek
Solver
Set Cell
Objective cell
Solver Report
Responses:
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
The formula cell to be optimized with Goal Seek
A new worksheet that contains the results of the Solver Add-in
specifies the cell that contains a formula that produces a value that you want to optimize
Correct Answer:
Premises:
Responses:
Goal Seek
Solver
Set Cell
Objective cell
Solver Report
Premises:
Goal Seek
Solver
Set Cell
Objective cell
Solver Report
Responses:
Related Questions
Q66: Where do scenario summary reports appear?<br>A)A new
Q67: Substitution values can be manually entered.
Q68: In order to complete a two-variable data
Q69: A(n)_ specifies the cell that contains a
Q70: When creating a one-variable data table with
Q72: Solver constraints can be set to restrict
Q73: Which is the best tool for determining
Q74: The Solver add-in appears in which tab
Q75: Which of the following tools is best
Q76: When creating substitution values using the Series