Advanced level 2026 BAEBOC ict 3

Based on the image provided for TASK 1 (SPREADSHEET), here are the extracted questions and instructions:

Setup & Layout Tasks

1. Create a workbook named BAEBOC26 and three worksheets: SUMMARY, GENERALREPORT, and CUSTOMERS.

2. Reproduce the two worksheets as seen in the image beginning from cell A1.

3. Format the SUMMARY worksheet:

   • i) Insert cell Borders in the range A1:L13.

   • ii) Set Row 1 to 20pts and Row 2 to 14pts, using the ALGERIAN font.

   • iii) Set Row 3 to Bold, and the rest of the text to Times New Roman.

4. Insert a column to the left of column A and enter the column heading (S/N). Use the fill series to number only the items (add borders to this column).

Calculation Tasks (SUMMARY Worksheet)

5. Total Number of Items: Calculate by summing the total per month. Write the formula in cell F5.

6. Custom Duties: Calculated as follows: If Company Price Per Item is greater than or equal to 2000, then multiply company price per item by 50%, else by 10%. Write the formula in H9.

7. Unit Price: Calculate by summing Company Price Per Item and Custom Duties. Write the formula in I6.

Data Reference Tables

The document also includes two tables to be reproduced:

• EMITEC COMPUTERS (Sales Analysis): Tracking October, November, and December sales for System Units, Monitors, Laptops, Mice, and Keyboards.

• CUSTOMERS Table: Including fields for CUS_CODE, CF_Name, CL_Name, Sex, and ADDRESS.

Would you like me to verify the handwritten formulas shown in the image or provide the clean versions for your spreadsheet?