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