Exam 77-888: Microsoft Excel Expert 2010

3. Presenting Data Visually

3.2. Apply data analysis: Data Tools What-If Analysis

Data -> Data Tools->What-If Analysis-> Goal Seek

Data: Goal Seek Options

3. What Do You See? The Goal Seek Status shows the Target Value of 12000. The Current Value in Cell E25 is set to $12,000.

 

What Else Do You See? The Price in Cell B1 changed from $3.25 to 4.355717. This is the new Price you need to reach the goal of $12,000 in sales. If you click OK, the new Price in Cell B1 will be kept.

 

Do This, Please: Click CANCEL to undo the changes made by the Goal Seek.

 

Memo to Self: The Price in Cell B1 looks odd with all the decimal places. You can format Cell B1 for currency if you wish.

 

  )