cameroon gce intermediate level digital marketing practice 3

cameroon gce intermediate level digital marketing practice 3

cameroon gce intermediate level digital marketing practice 3

SECTION A: COMPULSORY QUESTION
MONEY PLUS Company is located in Santa Cameroon and specialised in the money transfer in African and
Europeans countries appendix 1.
WORK REQUIRED
1.1 Start excel (7 marks)
1.2 Reproduce the table in appendix 1 by respecting the formatting (10 marks)
1.3 Introduce in cell E3 the following formula: =IF(OR(C3=”Gabon”,C3=”South Africa”,C3=”Ivory
Coast”),D3*2%),IF(OR(C3=”France”,C3=”Belgium”,C3=”Germany”),D3*10%) enabling to calculate
the sending fees paid by ABDOU, then calculate the fees paid by the other customers using the copy
function.
(15 marks)
1.4 Introduce in cell F3 the following formula = D3+E3 enabling to calculate the total amount to be paid
by ABDOU, then calculate the total amount to be paid by the other customers using the copy function
(4 marks)
1.5 Apply the conditional formatting in red for the amounts above or equal to 1000 000F (4 marks)
1.6 Print the table of calculation of fess and exit excel (4 marks)

click here to download spreadsheet

Spreadsheet

PDF is loading please wait...

 

Leave a comment

Your email address will not be published. Required fields are marked *

Download our application
kawlo
sponsors Ads