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
Q40: What are the row and column input
Q41: The biggest difference between Scenario Manager and
Q42: How many variables does Goal Seek change
Q43: _ results are mathematically feasible but physically
Q44: A(n)_ is a program in Excel which
Q46: A(n)_ is a label for a cell
Q47: Discount Rate is a valid range name.
Q48: What selections in the File tab do
Q49: You have a worksheet with a calculation
Q50: A(n)_ constraint does not restrict the target