Say you
wanted to create a Scenario that changed everything: the Price, the
Start and the Increment. The next couple of pages show how to add
more than one reference cell. 1.
Try it: Create a Different Scenario The
Scenario Manager is open. Click on:
Add You will
be prompted to fill in the blanks:
Scenario Name: Change Everything
Changing Cells: $B$1 You can
click on Cell B1, the Price, or type the reference. This is an
Absolute Reference. Add More
Cells to the Scenario: With your
cursor next to $B$1, Type a
comma (,) and add $B$2, the Start Type a
comma (,) and add $B$3, Increment Click
OK. Keep going...
Data -> Data Tools ->What-If
Analysis -> Scenario Manager
Exam 77-888: Microsoft Excel Expert
2010
3. Presenting Data Visually
3.2. Apply data analysis: Data Tools
What-If Analysis
|
|
| |
