Exam 23: Excel : What-If Analysis

Which what-if analysis tool is the best tool for evaluating various scenarios based on variables within a formula?

If not specified by the user,Solver optimization models can produce negative results.

Which of the following what-if analysis tools updates date in real time?

Which what-if analysis tool is best suited to calculate the impact of interest rate changes based on different economic climates?

Solver can solve linear and nonlinear problems.

Which of the following tools is best suited for comparing the effects of one set of substitution values on a formula?

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

________ has the ability to generate Answer Reports.

Solver models can be saved and restored.

Scenario summary reports are placed on/in a ________.

Which is the best tool for determining the optimal blend of products to produce in order to maximize profit?

Solver models can be restored from the ________.

Which what-if analysis tool is best to determine the number of t-shirts to sell in order to earn $500 with no constraints?

A(n)________ is a constraint that does not restrict the target value that Solver finds.

When creating a one-variable data table with substitution values in a horizontal row,the formula reference must be on the row below and one column to the left of the first substitution value.

When creating a one-variable data table,one or more formulas that relate to the variable must be used.

In order to complete a two-variable data table,a formula or reference to a formula must be entered in the top-left corner.