Gce Model Questions Vol1 2023 Computer Studies Question 35

In a spreadsheet the columns are: A - Salesperson, B - UnitsSold, C - UnitPrice, D - Commission. The commission policy is:\n\n- If total sales \(=B\times C\) are less than ₦5,000, commission = 5 % of sales.\n- If total sales are between ₦5,000 and ₦20,000 inclusive, commission = 7 % of sales plus a fixed bonus of ₦2,000.\n- If total sales exceed ₦20,000, commission = 10 % of sales minus a penalty of ₦1,000.\n\n(i) Write a single Excel formula for cell D2 that implements this policy using nested IF functions.\n(ii) Using the formula, calculate the total commission payable for the following three salespeople:\n • Alice: 120 units at ₦30 each\n • Bob: 80 units at ₦250 each\n • Cara: 300 units at ₦80 each\nProvide the formula and the total commission (in ₦).