Ordinary level 2026 South West mock computer science 3

Here are the specific questions and tasks extracted from the spreadsheet assessment image:

Formatting Tasks

• ii) Use a bold font, of size 12 for the column headers.

• iii) Merge and centralize the cells A1:O1 and A10:H10.

Formula & Calculation Tasks

• c) Enter the formula in cell I4 to calculate total saving of “Marvelous”. Write down the formula. Autofill to the corresponding cells.

• c) Enter the formula in cell I10 to calculate the TOTAL for total saving. Write down the formula. Autofill to the corresponding cells.

• d) Enter the formula in cell K9 to calculate 2% loan of “Augustine”. Write down the formula. Autofill to the corresponding cells.

• c) Enter the formula in cell L5 to calculate total loan of “Melody”. Write down the formula. Autofill to the corresponding cells.

• c) Enter the formula in cell M4 to calculate the interest for “Marvelous”. Write down the formula. Autofill to the corresponding cells.

• d) Enter the formula in cell N9 to calculate Final amount for “Augustine”. Write down the formula. Autofill to the corresponding cells.

• e) Enter a formula in O4 that makes a remarks GIFT for any member with final amount greater than 500,000, and NO GIFT for amount less than 500,000. Write down the formula. Autofill to the corresponding cells.

Charting Task

• f) Insert a bar chart of members, against interest obtained by members.

Would you like me to help you construct the specific Excel formulas for any of these calculation steps?