Gce Model Questions Vol1 2022 Computer Studies Question 31
Practice objective / multiple choice question 31 from the 2022 Gce Model Questions Vol1 Computer Studies examination.
In a spreadsheet, column A contains Quantity, column B Unit Price, column C Discount % and column D Tax % . Column E is calculated with the formula: if Quantity > 100 an extra 5 % discount is applied on top of the Discount % in column C; otherwise no extra discount. The price after discounts is multiplied by Quantity to give a subtotal, and the tax from column D is then added to obtain the final amount in column E. For a row where Quantity = (120), Unit Price = (₦45.50), Discount % = (10%) and Tax % = (8%), what value is stored in column E (rounded to two decimal places)?
Answer Options
About This Question
This is Gce Model Questions Vol1 2022 Computer Studies Question 31. It is one of the objective questions from the 2022 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.