Neco 2024 Data Processing Question 24
Practice objective / multiple choice question 24 from the 2024 Neco Data Processing examination.
A spreadsheet records monthly sales (units) of three products for a quarter. The data are:\n\n- Product A: Jan B2=120, Feb B3=150, Mar B4=130\n- Product B: Jan C2=80, Feb C3=95, Mar C4=100\n- Product C: Jan D2=200, Feb D3=210, Mar D4=190\n\nUnit prices are: A = \(\text{₦}500\), B = \(\text{₦}750\), C = \(\text{₦}300\). Commission is 5 % of the sales value for each product each month. In addition, if the total units sold in a month exceed 400, a bonus of \(\text{₦}20{,}000\) is added to that month's commission. Using appropriate spreadsheet formulas (you may describe them), calculate the total commission earned over the three months. State the final amount in naira.
Answer Options
About This Question
This is Neco 2024 Data Processing Question 24. It is one of the objective questions from the 2024 Neco Data Processing examination.
Difficulty level: Hard .
Master the Exam!
You've seen a preview, but there are thousands more questions plus AI tutor to break down complex solutions.