Gce Model Questions Vol1 2018 Computer Studies Question 26
Practice objective / multiple choice question 26 from the 2018 Gce Model Questions Vol1 Computer Studies examination.
A spreadsheet records quarterly sales quantities for three products. The quantities are:\n- Product A: \(120\), \(150\), \(130\), \(140\) units\n- Product B: \(80\), \(90\), \(85\), \(95\) units\n- Product C: \(60\), \(70\), \(65\), \(75\) units\nThe unit prices are ₦200 for product A and ₦350 for product B. The price per unit of product C is unknown and is the same for all quarters. The spreadsheet uses the formula:\n\(FinalRevenue = IF(TotalUnits>1000, 0.95*SUMPRODUCT(PriceRange, QuantityRange), SUMPRODUCT(PriceRange, QuantityRange))\)\nwhere \(TotalUnits\) is the sum of all quantities. The final revenue displayed is ₦603,725. Determine the unit price of product C (in ₦).
Answer Options
About This Question
This is Gce Model Questions Vol1 2018 Computer Studies Question 26. It is one of the objective questions from the 2018 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.