Gce Model Questions Vol1 2019 Computer Studies Question 43
Practice objective / multiple choice question 43 from the 2019 Gce Model Questions Vol1 Computer Studies examination.
In a spreadsheet, cell A1 contains the quantity of items ordered, cell B1 contains the standard price per item (₦250), and cell C1 must calculate the final amount payable. The pricing rules are: - If the quantity is at least 80, the price per item drops to ₦240; otherwise the price remains ₦250. - A discount is applied to the subtotal (quantity × unit price): 15 % if quantity ≥ 100, 10 % if quantity ≥ 50, otherwise 5 %. - After the discount, an 8 % sales tax is added. - If the amount after tax exceeds ₦20 000, a surcharge of ₦500 is added. Given that A1 = 78, what value should C1 display? (Provide the final amount in naira, rounded to the nearest whole naira.)
Answer Options
About This Question
This is Gce Model Questions Vol1 2019 Computer Studies Question 43. It is one of the objective questions from the 2019 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.