Microsoft Office Tutorials and References
In Depth Information
l The Scenario Values
dialog box appears.
8
Type the scenario
values.
9
Click Add to create
more scenarios.
The Add Scenario
dialog box reappears.
0
Click OK in the Scenario
Values dialog box
instead of Add when
you finish entering
scenarios.
l The Scenario Manager
dialog box appears.
!
@
8
#
9
0
$
!
Click Summary.
l The Scenario Summary dialog box
appears.
@
Click to select a report type (
changes
to
).
#
Click the field or type the cell address of
the field that calculates the results.
$
Click OK.
l The type of report you requested appears
on a new worksheet, displaying how each
value affects the result.
Did You Know?
If you share copies of a workbook and people add
their own scenarios, you can merge these scenarios
into a single list. To do so, open the workbooks
and click Data and then Scenario Manager. In the
Scenario Manager, click Merge. In the Merge
Scenarios window, select the workbooks and
individual worksheets to consolidate. Click OK
when you finish selecting.
Did You Know?
If you name the cells in your original worksheet,
your Scenario Summary becomes easier to read
because Excel displays the cell name instead of
the cell address. For example, in this task cell, cell
B2 is named Investment, cells B3 through B6 are
named Payment_1 through Payment_4, and cell B7
is named Interest_Earned. To learn how to name
cells, see Task #11.
Chapter 5: Explore the Patterns in Your Data
129
 
Search JabSto ::




Custom Search