Tuesday, 24 March 2015

Ms Excel Assignments 3



Ms Excel for ICDL Students

Exercise 1

1) Type the table below.
2) Calculate the total number of items sold by Aladdin.
3) Calculate the Sales made by Paulatech on all items that were sold.
4) Calculate for each item the profit being made.

Paulatech Supermarket
Product
Items Sold
Wholesale Price
Selling Price
Mushrooms
50
0.19
0.25
Tomatoes
2500
0.16
0.30
Biscuits
4000
0.30
0.60
Tuna
2300
0.14
0.29
Ham
4500
0.13
0.30
Crisps
1902
0.10
0.21

Exercise 2
Paulatech music shop sold the amount of CD’s shown in the table.
1) Type in the table below.
2) Calculate the total Sales for each month.
3) Find the highest sale e.g. =max(a1:a6), the lowest sale e.g. =min(a1:a6), the average sale e.g. =average(a1:a6) for each category.

Paulatech Music Shop





Month
Classical
Rock
Jazz
Rumba
Jan
1 005
1340
450
300
Feb
950
1450
765
250
Mar
1100
2000
800
350
Apr
1025
1320
650
240
May
1230
976
590
290

ICDL Exams

1) Type the table below
2) Calculate the total mark of Each Student
3) Use the IF function to calculate who of the student passed the tests. The
Pass Mark for each test should be 75 so to Pass ICDL student must bring an average mark of 525 to Pass

Name
Module 1
Module2
Module3
Module4
Module5
Module6
Module7
Total
Pass/Fail
James Budi
36
56
75
80
72
36
79


Abere
75
76
79
80
80
75
72


Marion
45
55
80
75
55
36
70


Andrew
80
76 
75
75
76
78
80


Pauline G
76
80
75
77
79
79
79


Michael K.
45
55
63
74
75
45
36


Kevin
70
73
45
26
63
46
45


Jonnes
72
45
63
80
15
67
75


Said
45
63
60
45
80
40
12


Roseline
36
25
80
26
48
75
36



Propellerads