Chapter 6

Question 1

Which what-if analysis tool is the best option for complex calculations requiring constrained optimization?

Answer 1

Solver

Question 2

What tool is used to edit pre-existing range names? (Check all that apply)

Answer 2

• One-variable data table

- Scenario Manager

Question 3

Which tool is most effective when comparing the impacts of various combinations of interest rates and down payments on a mortgage?

Answer 3

Two-variable data table

Question 4

This tool calculates the value required in a single cell to produce a desired result within a related cell.

Answer 4

Goal Seek

Question 5

This analysis tool has the ability to handle multiple adjustable cells while minimizing, maximizing, or meeting goals.

Answer 5

Solver

Question 6

Which of the following is an Excel add-in?

Answer 6

Solver

Question 7

Doug would like to purchase a new automobile. He has budgeted for $600 per month. If the interest and number of payments are constant variables that cannot change, which analysis tool should Doug use to calculate the amount to spend on a car?

Answer 7

Goal Seek

Question 8

Which dialog box enables you to specify the result cells for a scenario summary report?

Answer 8

Scenario Summary

Question 9

Which of the following tools can incorporate constraints?

Answer 9

Solver

Question 10

How can you determine if the Solver add-in is active?

Check all that apply

Answer 10

Solver appears in the Data tab of the Ribbon