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.

Get Sams Teach Yourself Microsoft® Office Excel 2003 in 24 Hours now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.