Exam 10: Data Tables, scenario Manager, and Solver

If you want to apply a conditional format that would format different cells with different colors,where one color is assigned to the lowest group of values,another color is assigned to the highest group of values,and gradient colors are assigned to other values,you would use ________.

The Scenario Manager dialog box enables you to add,edit,and delete scenarios.

If a large change in price is accompanied by a small amount of change in demand,a product or service is considered ________.

By selecting the Scenario Summary option,you can create a worksheet that includes subtotals and the results of the scenarios.

A(n)________ is an application with specific functionality geared toward accomplishing a specific goal.

To compare scenarios,create a scenario ________ report.

When using Solver,the constraint cell contains a formula that creates a value that you want to optimize.

The Simplex LP,Generalized Reduced Gradient Nonlinear,and Evolutionary are the three solving methods within the Solver Parameters dialog box.

To create scenario summary reports,click the ________ button in the Scenario Manager dialog box.

A(n)________ allows you to build a what-if analysis model that includes variable cells linked by one or more formulas or functions.

The Goal Seek command is located in the ________ command on the Data tab.

To add a scroll bar,you first need to add the ________ tab.

A constraint that does NOT affect the optimal solution is a(n)________ constraint.

The Reports list in the Solver Results dialog box displays the available report types.

The iteration settings cannot be changed.

Input values are listed in both columns and rows in a(n)________ data table.