Gce Model Questions Vol1 2024 Computer Studies Question 36
Practice objective / multiple choice question 36 from the 2024 Gce Model Questions Vol1 Computer Studies examination.
An Excel worksheet records monthly sales (in Naira) for a year as follows: Jan 95 000, Feb 110 000, Mar 130 000, Apr 115 000, May 140 000, Jun 150 000, Jul 160 000, Aug 170 000, Sep 180 000, Oct 190 000, Nov 200 000, Dec 210 000. The company pays a progressive bonus: \(5\%\) of the amount exceeding \(\text{₦}1\,200\,000\), plus an additional \(3\%\) of the amount exceeding \(\text{₦}1\,500\,000\). Calculate the total bonus payable. The same amount is inserted into a Word mail‑merge field that formats the value as currency with two decimal places. What exact string appears in the merged document?
Answer Options
About This Question
This is Gce Model Questions Vol1 2024 Computer Studies Question 36. It is one of the objective questions from the 2024 Gce Model Questions Vol1 Computer Studies 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.