Exam 77-888: Microsoft Excel Expert
2010
3. Presenting Data Visually
3.2. Apply data analysis: Data Tools
What-If Analysis
Goal Seek asks the question backwards,
starting from the answer. In this spreadsheet, the question is: how
much money did you make? The answer is the SUM in Cell E25.
In this sales spreadsheet, Goal Seek asks: How much
do you want to make?
Which value do you want to change: Price, Start or
Increment?
Keep going, please... Data ->
Data Tools |
|
| |
