• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

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.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint