Matching
Match each of the following terms to its best description:
Premises:
Scenario Manager
Goal Seek
One-variable data table
Solver
Two-variable data table
Responses:
A structured range that contains different values for one variable to compare how these values affect one or more calculated results
Finds the best way to optimize values within specified constraints.
Sets up and compares multiple situations
A structured range that contains different values for two variables to compare how these differing values affect the results for one calculated value.
Solves for a desired result of a formula by changing values
Correct Answer:
Premises:
Responses:
Scenario Manager
Goal Seek
One-variable data table
Solver
Two-variable data table
Premises:
Scenario Manager
Goal Seek
One-variable data table
Solver
Two-variable data table
Responses:
Related Questions
Q63: The Solver Add-in is loaded by default.
Q64: If you are analyzing how much a
Q65: Given this worksheet, which cell would you
Q66: What is an Excel Add-in?<br>A)All what-if analysis
Q67: What-if analysis always provides a definitive solution
Q69: Goal Seek differs from one and two-variable
Q70: Where would you setup the two substitution
Q71: A two-variable data table is the most
Q72: Scenario manager is on the _ tab.
Q73: Match each of the following what-if analysis