Advanced level 2026 South West mock ICT 3
Advanced level 2026 South West mock ICT 3
Based on the document provided, here are the specific questions and tasks extracted from the SALES sheet instructions:
Formatting & Layout Tasks
-
Merge cells A1 to G1, centralize the text, change the font size to 16 and font type to Algerian.
-
Merge cells B2 to G2, centralize the text, change font type to Arial Black and font size to 14.
-
Put a thick outside border from A3 to G17 as well as all borders.
-
Select from cell C4 to G17 and put a thousand separator and XAF currency.
Formula & Calculation Tasks
-
In cell C4, get the cost of item with PID P005 from the PRODUCT sheet. Copy the formula right up to C17 and write the formula found in cell C9.
-
In cell E4, compute the Total for item with PID P005. Copy the formula right up to E17. Write the formulae found in E10.
-
In cell F4, compute the discount for item with PID P005. It is calculated as follows: If total cost is greater than 300,000 or quantity greater than 20, a discount of 5 percent is awarded, else a discount of 3%. Copy the formula to get the discount for all the other items. Write the formula found in cell F5.
-
In cell G4, compute the final amount by subtracting discount from Total. Copy the formula right up to G17. Write the formula found in G13.
