cameroon gce intermediate level international financial accounting / computer aided accounting 2 setting 1
cameroon gce intermediate level international financial accounting / computer aided accounting 2 setting 1
A sales invoice realized by ZEZEM and BROS Ltd, BP 2096 Douala, Tel: 679928997 is given to you as seen
in appendix 1. (20 Marks)
1) Lunch MS excel and reproduce appendix 1, by respecting the formatting. 7 marks
2) Enter in the cell G12, the formula: =PRODUCT(E12,F12), in order to calculate the amount of paint. 1 mark
3) Copy the formula in the other cells to determine the rest of the amounts. 1mark
4) Enter in cell G17, the formula to calculate the gross amount 2 marks
5) In cell G18, enter the formula =G17*F18 , to determine the trade discount 1 mark
6) In cell, G19, enter the formula =G17-G18, to determine the commercial net 1mark
7) Enter in cells G20 and G21, the respective formulae to determine the cash discount and the financial net.
3marks
8) In cell G24, enter the formula: =SUM(G21:G23)*F24, to determine the value of VAT 1 mark
9) Enter the appropriate formula in the appropriate cell to determine the Net amount Payable. 2 marks
10) Save and print your work 1mark
