Page 224 - CITS - Computer Software Application -TT

COMPUTER SOFTWARE APPLICATION - CITS

Solution: Let's do Goal Seek to determine the minimum score on exam 3:
• Cell - the formula that averages the scores of the 3 exams (B5).
• To value - the passing score (70%).
• By changing cell - the 3rd Set exam score (B4).

Result: In order get the desired overall score; the student must achieve a minimum of 67% on the last exam.

Example 3: What-If analysis of the election
Problem: You are running for some elected position where a two-thirds majority (66.67% of votes) is required to
win the election. Assuming there are 200 total voting members, how many votes do you have to secure?

Currently, you have 98 votes, which is quite good but not sufficient because it only makes 49% of the total voters.

211

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