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
