Exam 77-428 Microsoft Excel 2013 EXPERT 3. Create Advanced Formulas 3.4 Create Scenarios: Use What If Analysis Tools Including Goal Seek

Data -> Data Tools->What-If Analysis-> Goal Seek 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 E29. 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: E29 (the SUM of the sales). To value: 15000 (the Goal you want to make). By changing cell: $B$1 (the Price).   Click OK. Keep going...