Neco 2024 Computer Studies Question 25

In a spreadsheet, Sheet1 contains the following data (columns A and B):\n\n| A (Item) | B (Qty) | C (Unit Price) |\n|----------|--------|----------------|\n| A | 5 | 12 |\n| B | 3 | 20 |\n| C | 7 | 8 |\n\nSheet2 has a discount table based on the subtotal (column D):\n\n| D (Subtotal) | E (Discount %) |\n|---------------|----------------|\n| ≥ 200 | 15 |\n| ≥ 100 | 10 |\n| < 100 | 5 |\n\nWrite the formula that would compute the final amount payable (subtotal minus discount) in a single cell on Sheet1, and state the numeric final amount for the data given above.