In a course where the final passing mark is 60%, a student has achieved 55% in the coursework which is worth 35% of the final mark (the remaining 65% weighting has been assigned to the Exam). To find out the minimum percentage that he needs to achieve in the exam in order to pass the course (cell C3), the following spreadsheet has been constructed: C. 1 Assessments Weightings Marks 2 Coursework 35 55.00% 3 Exam 65 4 Total 100 19.25 To do this, the Goal Seek function in Excel is used. (Assume that all calculations are formulated with proper cell references so that any impacts from changes will be automatically calculated in the spreadsheet) Goal Seek Set cell: To yalue: By changing cell: OK Cancel What value should be entered into the By changing cell box? O C3 O C4 O 60% O 0.6