Exam 23: Excel : What-If Analysis

________ scenarios can be created within Scenario Manager.

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

Goal Seek is an Excel add-in.

What is the maximum number of scenarios supported by Scenario Manager?

Scenario Manager is an Excel add-in.

Which of the following tools can manipulate changing variable cells?

A two-variable data table allows two variables but only one result.

A(n)________ specifies the cell that contains a formula that produces a value that you want to optimize with Solver.

Where do scenario summary reports appear?

________ is the best what-if analysis tool to solve complex linear and nonlinear problems.

If Doug would like to determine how many hot dogs to sell at a profit margin of $10.00 to raise $250.00 without constraints,which what-if analysis tool should he use?

Goal Seek can be set to minimize the objective cell.

Scenario Manager can be set to maximize the objective cell.

Scenario Manager can create PivotTable reports.

What is the best tool to determine the required downpayment to reach a $700 car payment?

Which of the following tools is best suited for comparing the effects of two variables on a formula?

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?

All what-if analysis tools are located in the ________ tab.