Neco 2025 Computer Studies Question 9

In a spreadsheet, column A holds product codes (text), column B holds quantity sold (integer), and column C holds unit price (currency). Column D should display the revenue for each row using the following rules: - If quantity \(\ge 100\), apply a 10 % discount to the unit price. - Else if the product code starts with "X" **and** quantity \(< 50\), apply a 5 % surcharge to the unit price. - Otherwise use the unit price unchanged. Write the Excel formula for cell D2 (assuming the data start in row 2). Then, using the data below, compute the total revenue (sum of D2:D4). | Row | A (code) | B (qty) | C (price) | |-----|----------|----------|-----------| | 2 | X12 | 30 | 20 | | 3 | A5 | 120 | 15 | | 4 | X99 | 80 | 10 |