Module 1.2
Task 4- Percentage


A.M.D.G.

To convert numbers to percentages just press the percentage button on the toolbar, .

  • Open Module 1.2
  • Enter the following information on a new worksheet
 
A
B
C
D
E
1
  January Exam (Marks out of 30)      
2
  Name Exam Mark Percentage    
3
  John
19
      
4
 Philip 
22
      
5
 Jane 

27

      
6
 Helen
24
      
7
 Frank
13
      
  • In cell C3 enter the formula =B3/30
  • Press enter
  • Press the Percentage tool on the toolbar
  • Repeat for the other pupils
  • Save this spreadsheet

Answer the following questions in your jotter.

1. Convert the following values to percentages:

(a) 0.5

(b) 0.25

(c) 0.05

(d) 5

(e) 5.2

2. Calculate the following percentages:

(a) A pupil scores 12 out of 20 in an exam.

(b) A football player scores 7 goals in 18 matches.