Percentages
With the total marks for all the students added up, Sean starts calculating the percentages of marks for each.
To calculate percentages,
1. Go to the Percentage column.
2. Place the cursor in cell J3.
3. Type the formula = I3/(100*5). You can type the formula either in cell or in the formula bar.
4. Press Enter.
The figure 72% appears in cell J3. If you see 0.72, just click on the Percent Style (%) button on the formatting toolbar.
5. To calculate results up to one decimal place, click on the increase Decimal button on the formatting toolbar.
The result changes to 75%
6. To find out Harry’s percentage, click inside the cell J4.
7. Type the formula =I4/(100*6).
8. Press Enter
9. Click on the Increase Decimal button to increase the number by one decimal place.
10. The figure, 78.33%, appears inside cell J4.
Activity: Calculate Peter’s percentage with the formula =J5/ (100*6). Create your own formulas to calculate the percentages for Henry, Jill and Mark.
Note: The / Symbol signifies division, and the * symbol signifies multiplication. When two functions of a similar ranking are used in a formula, the function which comes first from the left is calculated first. For instance, in a formula which uses both multiplication and division, (* and /), the order of appearance determines which function will be calculated first.
