Matching
Match each of the following what-if analysis tools to its most likely use:
Premises:
Goal Seek
One-variable data table
Two-variable data table
Scenario Manager
Solver
Responses:
You want to compare best-case, worst case and most-likely case scenarios for a business decision.
You want to know what interest rate you need to find to make a loan payment exactly $500 per month.
You want to compare the total interest paid on the lifetime of a loan with varying interest rates and terms.
You want to know how many products your production line can make with the least waste.
You want to compare different calculations like monthly payment and total interest paid on a loan with the different interest rates.
Correct Answer:
Premises:
Responses:
Goal Seek
One-variable data table
Two-variable data table
Scenario Manager
Solver
Premises:
Goal Seek
One-variable data table
Two-variable data table
Scenario Manager
Solver
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
Q97: Match each of the following terms to
Q98: Match each of the following tools to
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