Module 1.2
Task 6 - More Percentages


A.M.D.G.

Many calculations are carried out involving percentages. To calculate 50% of £1400 in Excel just multiply the two cells together.

  • Open Module 1.2
  • Enter the following information on a new worksheet
 
A
B
C
D
E
1
  Item Price Discount Reduction Sale Price
2
 CD Player
 60
0.1
    
3
 MD Player  
150 
0.1
    
4
 Stereo
230 
0.15 
    
5
  Widescreen TV
370 
0.15 
    
6
  DVD Player
180 
0.1 
    
  • Calculate the reduction in cell D2 for the compact disc player by multiplying
    cells B2 and C2 together
  • Calculate sale price in cell E2 by subtracting D2 from B2
  • Format all amounts of money using the currency button and display each amount with 2 decimal places
  • Format all percentages using the percentage button
  • Save your work

Answer the following questions in your jotter.

1. Find the following:

(a) 50% of £250

(b) 20% of £120

(c) 5% of £80

(d) 113% of £ 1080