Question

Suppose a student takes 25 marks in midterm exams and 10 marks in

assignments. His total score will be calculated by adding his midterm, 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 in Spreadsheet ?​

Answer 1

Answer:

hi dear friend please follow me and give thanks for my answer

Answer 2

Answer:

Suppose a student takes 25 marks in midterm exams and 10 marks in assignments. His total score will be calculated by adding his midterm, assignments and final term marks. If the student wants to make his total score equal to 70, find out the final term marks that he should take by using Goal Seek in Microsoft excel. Sample set of values before applying goal seek operation: You have to calculate final term marks by using the following values 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 goal seek and show the procedure. Tilings that you must remember Make sure the "Set Cell" cell is set to a formula or function or cell reference. Make sure the "By Changing Cell" cell is a number or blank, and not a formula, function or cell reference like =C5. Make sure there is a link by formulas between the two cells you entered in the Goal Seek. Finally, make sure your formula in the "Set Cell" cell is correct.