Ordinary level 2026 South West mock digital marketing practice 3

Examination Questions Extraction: Section A

The following practical Excel task has been extracted from the provided document image:

1. EXCEL

You have just completed the annual inventory at the KeyTech Company Ltd where you are on internship. Madam Pullcherie, the manager, ask you to fill in the stock card using the First-in-First Out (FIFO) method of stock valuation.

Madam Pullcherie asks you to fill in the stock form in the appendix 2, taking into account the following information in appendix 1, for the year 2025.

Work required:

• i. Start a spread sheet application. (1 mark)

• ii. Reproduce the table below while respecting the formatting. (5 marks)

• iii. Introduce in cell K4, the formula =(I4*J4) enabling to calculate the amount of stock in the warehouse on the 01/09/25. (1 mark)

• iv. In cell E5, introduce the formula =(C5*D5) enabling to calculate the amount of entries on the 02/09/25. (1 mark)

• v. Introduce a formula in cell K5 enabling you to calculate the amount of stocks. (1 mark)

• vi. In H6, introduce the formula =(F6*G6) enabling you to calculate the amount on exits on the 04/09/25. (1 mark)

• vii. Introduce a formula in cell K6 enabling you to calculate the amount of stocks. (0.5 mark)

• viii. Introduce the formula enabling you to calculate the amount on exits in cell H7 and the amount on stocks in cell K7. (1.5 marks)

• ix. Introduce the formula enabling you to calculate the amount of entries in cell E8 and the amount on stocks in cell K8. (1.5 marks)

• x. Introduce the formula enabling you to calculate the amount of entries in cell E9 and the amount on stocks in cell K9. (1.5 marks)

• xi. Introduce the formula enabling you to calculate the amount on exits in cell H10 and the amount on stocks in cell K10. (1.5 marks)

• xii. Introduce the formula enabling you to calculate the amount of entries in cell E11 and the amount on stocks in cell K11. (1.5 marks)

• xiii. Colour the blank spaces using any color or your choice. (1 mark)

• xiv. Calculate the total quantity of inventory in cell I12 and the total amount on stocks in cell K12 respectively. (1 mark)

APPENDIX 1

• 01/09: initial stock of 50 pairs of tennis at 1000FCFA each

• 02/09: Entries of 120 pairs of tennis at 500 FCFA each

• 04/09: Exit of 140 pairs of tennis

• 10/09: Exits of 20 pairs of tennis

• 14/09: Entries of 340 pairs of tennis at 400FCFA

• 16/09: Entries of 60 pairs of tennis at 500FCFA

• 20/09: Exits of 370 pairs of tennis

• 29/09: Entries of 40 pairs of tennis at 600FCFA