Excel Ch 5 L2

Using the original cell values in the first scenario created

Because Excel replaces the content of each changing cell when a new What-If scenario is shown, Chapter 5 recommends which of the following?

Scenario Manager dialog box.

Change the values associated with a scenario

Live preview

The Paste drop-down gallery includes a _ of how the data will be pasted to assist in choosing the correct paste option.

Rows to columns and columns to rows

The Transpose option at the Paste Special dialog box converts.

Scenario Manager

The _ feature allows storing multiple sets of assumptions about data and when viewing how each set if assumptions affects the worksheet.

Goal Seek

The _ feature is useful when you know the result of a formula but are not sure what input value to enter to achieve that result.

Transpose

The _ option at the Paste Special dialog box alters the physical arrangement of the data to be pasted.

What-If Analysis

To use Excel's Goal seek feature, click the _ button on the Data tab.

Provide data to the active cell

Use the Trace Precedents button in the Formula Auditing group to draw arrows to cells.

Evaluate Formula

Use the _ button in the formula Auditing to work through a formula value by value to determine where within the formula an error exist.

Formulas

Use the _ option at the Paste Special dialog box to paste only the source formulas to a destination cell.

Indirect relationships are shown

What happens when you click the Trace Precedents button a second time?

Values being pasted; values already in the destination cells

When you check the Divide option at the Paste Special dialog box, the _ are divided by the _.

only

When you click the Formats options at the Paste Special dialog box, Excel pastes _ the formatting options from the source cells into the destination cells.

#N/A

Which of the following error codes displays in a cell when required value for the formula is not found?

A green diagonal triangle appears in the upper left corner of the cell

Which of the following indicates that Excel has detected an error condition in a cell?

a dependent cell

Which of the following kinds of cell would you add to a watch window?

exponentiation

Which of the following mathematical operations cannot be performed at the Paste Special dialog box?

when data validation rules have been set up after data has been entered

Which of the following situations is described in chapter 5 as a time when the circle invalid data feature would be useful?

Select the source range

Which of the following steps should be performed first when transposing a range of data?

any number of

You can create _ models using the scenario Manager dialog box.

The destination cells to the same column widths as the source.

You can use the Column widths option at the Paste Special dialog box to adjust which of the following?

Select the scenario at the Scenario Manager dialog box and then click the Delete button

How do you delete a scenario?

data table

A _ range of cells that contains a series of input values.

down a column or across a row

A one-variable input data values in a series

a row along the top

Construct a two-variable data table with a column along with the left containing one set of variable input values and _ containing the second set of variable input values

PivotTable

Create a scenario summary report to compare scenarios side by side in a worksheet or a

At the top left cell in the table

In a two-variable data table, the source formulas is placed

In the first row above and one cell to the right of the table

Ina one-variable data table, when do you place the formula for calculating the various outcomes?

Dependent

_ cells contain that refer to other cells