Exam 23: Excel : What-If Analysis

________ can be used to compare the effects of several scenarios on calculated results.

Which of the following tools has the ability to generate a report?

________ is an Excel add-in.

Which what-if analysis tool is best used for creating optimization models?

Deleted Solver constraints can be restored.

A(n)________ is used to compare the impacts of two variables on a calculated result.

Comments can be added to Scenarios in which tab or dialog box?

A(n)________ is a structured range that contains different values for one variable to compare how these values affect one or more calculated results.

When using Scenario Manager,scenarios can be edited.

Solver summary reports appear on/in a(n)________.

Where is the check box to activate Solver located?

When creating substitution values using the Series dialog box,what is the last number used in the substitution values?

Scenario summary reports update when input cells are changed.

Two reference formulas are required to complete a two-variable data table.

By default,the Solver add-in is active.

When creating a one-variable data table that depicts the effect of different interest rates on a car payment,the interest rate is an example of which of the following?

User created scenarios are stored in a(n)________.

Which of the following options is required to complete a Solver model?

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