Neco 2024 Data Processing Question 50

A spreadsheet records sales data as follows (columns A to E):\n- A: Quantity sold\n- B: Unit price (₦)\n- C: Discount % applied to the subtotal\n- D: Tax % applied after discount\n- E: Total amount payable\n\nThe intended formula for cell E2 is\n\(E = (A \times B) \times (1 - \frac{C}{100}) \times (1 + \frac{D}{100})\).\n\nRow 2 contains: Quantity (A2) = 12, Unit price (B2) = 850, Discount (C2) = 8, Tax (D2) = 5.\nThe value displayed in E2 is ₦9,720, which appears incorrect.\n\n(i) Compute the correct total amount payable for row 2 using the intended formula, rounding to the nearest naira.\n(ii) Identify the most likely error in the formula entered in cell E2 that would give the displayed result of ₦9,720.\n(iii) Write the corrected formula that should be entered in E2.