Chapter 6 Flashcards
Which what-if analysis tool is best suited to determine the exact interest rate required for a $600 car payment repaid over five years?
Goal Seek
Which of the following tools has the ability to generate a report?
Scenario Manager
Which of the following tools is an add-in?
Solver
Which of the following tools has the ability to manipulate constraints?
Solver
In business terms, break-even points refers to a point where total revenue is greater than total cost.
-true or false
false
Which of the following tools is best suited for comparing the effects of two variables on a formula?
Two-variable data table
Which what-if analysis tool is the best tool for evaluating various scenarios based on variables within a formula?
Scenario Manager
How can you determine if the Solver add-in is active?
Solver appears on the Data tab
Which what-if analysis tool is best suited to determine the exact interest rate required for a $600 car payment repaid over five years?
Goal Seek
What what-if analysis tool is best used for creating optimization models?
solver
