Matching
Match each of the following terms to its description:
Premises:
Substitution Value
What-if analysis
Variable
Changing variable cell
Range name
Responses:
A word or string of characters that represents one or more cells
Replaces the original value of a variable in a data table
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
A value that you can change to see how that change affects other values
Correct Answer:
Premises:
Responses:
Substitution Value
What-if analysis
Variable
Changing variable cell
Range name
Premises:
Substitution Value
What-if analysis
Variable
Changing variable cell
Range name
Responses:
Related Questions
Q85: Goal Seek has the ability to restrict
Q86: Scenario Manager is not an Excel Add-in.
Q87: The number of scenarios that Scenario Manager
Q92: Match the following range names with their
Q93: Match each of the following terms to
Q95: Associate the following concepts with its corresponding
Q96: Match each of the following terms to
Q97: Match each of the following terms to
Q98: Match each of the following tools to
Q99: Match each of the following what-if analysis
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents