Devry BIS 155 Week 6 Quiz
(TCO 6) Which of the following tools is an add-in? (Points : 2)
- Goal Seek
- Solver
- Scenario Manager
- One-variable data table
Question 2. 2. (TCO 6) Which What-If Analysis tool is best suited to determine the exact interest rate required for a $600 car payment repaid over 5 years? (Points : 2)
- Solver
- Goal Seek
- One-variable data table
- Scenario Manager
Question 3. 3. (TCO 6) To compare monthly mortgage payments, total amounts to repay a loan, and total interest based on varying the interest rate, you would use _____. (Points : 2)
- a multi-variable data table
- a one-variable data table
- Solver
- Goal Seek
Question 4. 4. (TCO 6) Given an interest rate, the number of years, and a planned down payment, you would use _____ to find the highest cost of a house you can afford while maintaining the monthly payment. (Points : 2)
- a one-variable data table
- a two-variable data table
- Solver
- Goal Seek
Question 5. 5. (TCO 6) In order to complete a two-variable data table, which of the following must be included in the table? (Points : 2)
- Formula
- Constraint
- Absolute reference
- Integer
Question 6. 6. (TCO 6) A scenario _____ is used to compare multiple scenarios. (Points : 2)
- comparison table
- analysis table
- relationship report
- summary report
Question 7. 7. (TCO 6) Which What-If Analysis tool is best used for creating optimization models? (Points : 2)
- One-variable data table
- Two-variable data table
- Solver
- Goal Seek
Question 8. 8. (TCO 6) To optimize the monthly payments, you would designate the home cost, down payment, APR, and number of years for the loan as the _____ variable cells. (Points : 2)
- independent
- objective
- dependent
- changing
Question 9. 9. (TCO 6) When saving a Solver model, which of the following is not saved? (Points : 2)
- Objective value
- Changing variable cells
- Consgtraints
- Set cell
Question 10. 10. (TCO 6) _____are restrictions or limitations imposed on Solver as it determines the optimum value. (Points : 2)
- Bounds
- Constraints
- Restraints
- Controls
Question 11. 11. (TCO 6) Which What-If Analysis tool is best for manipulating one variable to determine one result? (Points : 2)
- Scenario Manager
- Goal Seek
- Solver
- One-variable data table
Question 12. 12. (TCO 6) Which What-If Analysis tool is best to determine the optimal amount of shoes to produce in order to maximize profit and use 100% of materials? (Points : 2)
- Goal Seek
- Solver
- Scenario Manager
- Two-variable data table
Question 13. 13. (TCO 6) Comments can be added to Scenarios in which tab or dialog box? (Points : 2)
- Goal Seek dialog box
- Home tab
- View tab
- Scenario Manager dialog box
Question 14. 14. (TCO 6) If Doug would like to determine how many hot dogs to sell at a profit margin of $10 to raise $250 without constraints, which What-If Analysis tool should he use? (Points : 2)
- Scenario Manager
- Solver
- Goal Seek
- Two-variable data table
Question 15. 15. (TCO 6) Which of the following options is required to complete a Solver model? (Points : 2)
- Objective cell
- Consgtraint
- Set cell
- Scenario
