Matching
Match each of the following terms to its best description:
Premises:
Scenario Summary Report
Goal Seek Dialog Box
Scenario PivotTable
Optimization Model
Answer Report
Responses:
Tool to input the set cell, to value, and by changing cell
Organizes the results from a set of scenarios in a PivotTable for further analysis.
Organized structured table of scenarios, their input values, and their respective results that displays on a new worksheet
Output from Solver which displays on a new worksheet.
Finds the highest, lowest or exact value for a particular result by adjusting variables
Correct Answer:
Premises:
Responses:
Scenario Summary Report
Goal Seek Dialog Box
Scenario PivotTable
Optimization Model
Answer Report
Premises:
Scenario Summary Report
Goal Seek Dialog Box
Scenario PivotTable
Optimization Model
Answer Report
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
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
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