Exam 10: Performing What If Analyses

As you begin to work with Solver, you have questions. So you turn to your co-worker, Aria, who you know is an expert in its usage. -Aria explains to you that if you want to use Solver to maximize a company's net income,you first need to understand that a(n)_______ is a cell that is maximized,minimized,or set to a specific value.

The ____________________ input cell is the cell on which values placed in the first column of the data table are based.

If Solver is taking too long to find a solution,you can halt the program at any time by pressing the _______ key.

In Solver,a(n)____________________ cell is a cell that you want to maximize,minimize,or change to a specific value.

The _______ report summarizes the results of a successful solution by displaying information about the target cell,changing cells,and constraints.

A(n)_______ procedure means that Solver starts with an initial solution and uses that as a basis to calculate a series of solutions.

If you orient a one-variable table so that the input values are in the first row,you would use the _______ input cell option.

The Scenario Manager refers to ____________________ cells as changing cells because these worksheet cells contain values that are changed under the scenario.

Once you enter an array formula,Excel will enclose the formula in a set of _______.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Searches for the optimal solution of a problem involving several variables

To activate Solver,click Solver Add-In in the _______.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Means that a constraint was not a limiting factor in a Solver solution

Two-variable data tables are often used to explore the impact of changing two values on a single result.

$\underline { \text { Nonbinding } }$ constraints always show a slack of 0._________________________

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Cells that contain the calculated values you want to examine

Cells that display the value _______ indicate that all of the values in the worksheet satisfy the Solver constraints.

At the break-even point,revenue equals expenses.

If your input values are in a column,you will use the Column input cell option when you use the Data Table command.

Before using Scenario Manager,you should assign _______ to all the input and result cells you intend to use in your scenarios.

You are planning to open a new restaurant and need to determine how many dinners need to be sold to stay above the break-even point. You will investigate Cost Volume Profit (CVP), also known as break-even analysis. -Another tool to help analyze several what-if analyses is data tables in Excel.Using a one-variable table,you can specify _______ input cell(s)and any number of result cells.