Matching
Match each of the following terms to its description:
Premises:
Range name
Changing variable cell
What-if analysis
Variable
Substitution Value
Responses:
A word or string of characters that represents one or more cells
A cell containing a variable whose value changes until Solver optimizes the value in the objective cell
Replaces the original value of a variable in a data table
The process of changing variables to observe how changes affect calculated results
A value that you can change to see how that change affects other values
Correct Answer:
Premises:
Responses:
Variable
A value that you can change to see how that change affects other values
Range name
A word or string of characters that represents one or more cells
Changing variable cell
A cell containing a variable whose value changes until Solver optimizes the value in the objective cell
What-if analysis
The process of changing variables to observe how changes affect calculated results
Substitution Value
Replaces the original value of a variable in a data table
Premises:
Variable
Range name
Changing variable cell
What-if analysis
Substitution Value
Responses:
A value that you can change to see how that change affects other values
A word or string of characters that represents one or more cells
A cell containing a variable whose value changes until Solver optimizes the value in the objective cell
The process of changing variables to observe how changes affect calculated results
Replaces the original value of a variable in a data table
Related Questions
Q1: This what-if analysis tool is best suited
Q3: A variable is an input value that
Q4: What is a scenario in Excel What-if
Q5: The what-if analysis tool which uses two
Q6: Goal Seek would be the best what-if
Q7: An objective cell is required to complete
Q8: If you set up a two-variable data
Q9: Business managers often create _ /worst-case scenarios.
Q10: A(n)_ is a rule that Solver has
Q11: A(n)_ specifies the cell that contains a