City Guilds Model Questions Vol1 2024 Information Technology Question 9
Practice objective / multiple choice question 9 from the 2024 City Guilds Model Questions Vol1 Information Technology examination.
A spreadsheet stores data for five products. Columns are: \(B\) - Units sold, \(C\) - Unit price (naira), \(D\) - Profit‑margin % (as a whole number). The data are: - Product A: Units 800, Price 25, Margin 15\n- Product B: Units 1500, Price 30, Margin 12\n- Product C: Units 600, Price 45, Margin 20\n- Product D: Units 2000, Price 22, Margin 10\n- Product E: Units 400, Price 55, Margin 18 A discount of 5 % off the unit price is applied to any product whose units sold exceed 1000. Using these rules, what is the total profit (in naira) for all five products? (Profit for a product = Units \(\times\) Effective price \(\times\) Margin/100.)
Answer Options
About This Question
This is City Guilds Model Questions Vol1 2024 Information Technology Question 9. It is one of the objective questions from the 2024 City Guilds Model Questions Vol1 Information Technology examination.
Difficulty level: Medium .
Master the Exam!
You've seen a preview, but there are thousands more questions plus AI tutor to break down complex solutions.