Question Suppose a student takes 25 marks in midterm exams and 10 marksin assign

Question

Question

Suppose a student takes 25 marks in midterm exams and 10 marksin assignments. 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 before applying goal seek operation:

Applying Goal Seek to Find Final TermMarks

25

Midterm Marks

10

Assignment Marks

0

Final Term Marks

35

Total Score

You have to calculate final term marks by using the followingvalues of goal seek input dialog box:

Set cell = Total Score

To Value = 70

By changing cell = Final Term Marks

Show the values of used cells before and after the goalseek and show the procedure.

Things that you must remember!!

v     Make sure the "SetCell" cell is set to a formula or function or cellreference.

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.

Goal Seek input dialog

Applying Goal Seek to Find Final TermMarks

25

Midterm Marks

10

Assignment Marks

0

Final Term Marks

35

Total Score

Explanation / Answer

ResponseDetails: ResponseDetails:
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 Q
• Subjects

---

---

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