cameroon gce advanced level June 2022 ICT 3

cameroon gce advanced level June 2022 ICT 3

cameroon gce advanced level June 2022 ICT 3 GROUP 1 AND GROUP 2

Open the SALES workbook in the candidate folder. This workbook contains three worksheets, Sales, OldSales
and Summary.
Questions 1 to 9 are based on the Sales sheet.
1. Change the font type of the first row (showing SN, NAME, 3% Discount …) to ALGERIAN.
2. Insert cell border in the range A1:G25.
3. Adjust the Name field width to 138 pixels.
4. Insert a formula in the 3% Discount field to calculate the discount for each item bought.
This discount is 3% of the product of Unit Price and Quantity.
Write down the formula in cell C4.

Write down the formula in to calculate the Payable Total in FI 2 in the line below.
F12: (2 marks)
6. Calculate the total of 3% Discount and total of the Payable Total in row 25.
Write down the formula in cell C25.
C25: (1 mark)
7. Set the font of row 25 to bold and size 14. (1 mark)
Ensure that you have written down the formulae in the cells in questions 4, 5 and 6 above before
attempting the questions that follow.
8. Rearrange the fields (columns) in this sheet to occur in the order SN, Name, Item, Unit Price,
Quantity, 3% Discount and Payable Total.
9. Format the numbers in the range D2:G25 to thousand separator without decimal place.
The next exercises are based on the OldSales and Summary sheets.
10. Insert a fill color of light blue to the cells that make up the field names in both sheets.

PDF is loading please wait...


Click here to download the candidate folder for ict 2022 group 1 and 2

Leave a comment

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

Download our application
sponsors Ads