Goal Seek is part of a suite ofcommands sometimes called what-if analysis tools.

Question

Goal Seek is part of a suite ofcommands sometimes called what-if analysis tools. When you know thedesired result of a single formula but not the input value theformula needs to determine the result, you can use the Goal Seekfeature available by clicking Goal Seek on the Tools menu. Whengoal seeking, Microsoft Excel varies the value in one specific celluntil a formula that's dependent on that cell returns the resultyou want.
In Goal Seek there will be three boxes to fill in.

Question

Suppose astudent takes 25 marks in midterm exams and 10 marks inassignments. His total score will be calculated by adding hismidterm, assignments and final term marks. If the student wants tomake his total score equal to 70, find out the final term marksthat he should take by using Goal Seek inMicrosoft excel.

Sample set of values beforeapplying goal seek operation:

Applying GoalSeek to Find Final Term Marks

25

Midterm Marks

10

Assignment Marks

0

Final Term Marks

35

Total Score

You have to calculate final termmarks by using the following values of goal seek input dialogbox:

Set cell = Total Score

To Value = 70

By changing cell = Final TermMarks

Show the values of usedcells before and after the goal seek and show theprocedure.

Things that you mustremember!!

v     Make sure the "Set Cell"cell is set to a formula or function or cell reference.

v     Make sure the "By ChangingCell" cell is a number or blank, and not a formula,function or cell reference like =C5.

v     Make sure there is a link by formulasbetween the two cells you entered in the Goal Seek.

v     Finally, make sure your formula in the"Set Cell" cell is correct.

Applying GoalSeek to Find Final Term Marks

25

Midterm Marks

10

Assignment Marks

0

Final Term Marks

35

Total Score

Explanation / Answer

In cells: A1 type 25, B1 type Midterm Marks A2 type 10, B2 type Assignment Marks A3 type 0, B3 type Final Term Marks A4 type =sum(A1:A3), B4 type Total Score Under Data Tools tab > What-if Analysis choose Goal Seek (Excel 2008) In the Set Cell box, type A4 In the To Value box, type 70 In the By Changing cell box, type A3 Click OK

Related Questions

Navigate

• Browse (All)
• Browse G
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.