Page 223 - CITS - Computer Software Application -TT

COMPUTER SOFTWARE APPLICATION - CITS

Result: The Goal Seek analysis shows that in order to obtain $100,000 annual net profit, your fourth-quarter
revenue must be $185,714.

Example 2: Determine the exam passing score
Problem: At the end of the course, a student takes 3 exams. The passing score is 70%. All the exams have the
same weight, so the overall score is calculated by averaging the 3 scores. The student has already taken 2 out of
3 exams. The question is: What score does the student need to get for the third exam to pass the entire course?

210

CITS : IT&ITES - Computer Software Application - Lesson 63 - 77