Q&A

Q1:

I want to hide sections in my Scenario Summary report. What should I do?

A1:

Click on a minus sign (?) in the tree structure to the left of the row heading numbers in the Scenario Summary sheet. Excel hides the section in the report.

Q2:

Can I pause the goal-seeking process so that I can stop and start whenever I want?

A2:

Clicking the Pause button changes the choices in the Goal Seek Status dialog box to Stop and Continue.

Q3:

Can I use the Goal Seek tool to change the value of two cells in a 3D Area chart?

A3:

Sorry. When you use the Goal Seek tool to change the values in a chart, you can change the value of only one cell.



    Part I: Excel Basics