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
Q90: Optimization models find the highest, lowest, or
Q91: Solver is on the Formulas tab.
Q92: Match each of the following terms to
Q93: Match each of the following terms to
Q94: Match the following range names with their
Q95: Match each of the following terms to
Q96: Match each of the following terms to
Q98: Match each of the following tools to
Q99: Match each of the following what-if analysis
Q100: Match each of the following terms to
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