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. open up excel. type in the following values and convert them to percentages. Write down what you get for each one:

(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.