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

Exam 77-888: Microsoft Excel Expert 2010

3. Presenting Data Visually

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

Data: What If? Goal Seek

Here are the steps to try a Goal Seek.

 

1: Try It: Select the Goal

Go to the Pigs spreadsheet.

Select: Cell E25.

Go to Data -> Data Tools->What-If Analysis.

Click on Goal Seek.

 

2. Try This: Define the Options

You will be prompted to fill in the blanks:

Set cell: E25 (the SUM of the sales).

To value: 12000 (the Goal you want to make).

By changing cell: $B$1 (the Price)

 

Click OK...keep going.