City Guilds Model Questions Vol1 2022 Information Technology Question 32
Practice objective / multiple choice question 32 from the 2022 City Guilds Model Questions Vol1 Information Technology examination.
A spreadsheet stores sales data for three items as follows: Item A - 120 units at $85 each; Item B - 75 units at $132 each; Item C - 200 units at $47 each. The company pays sales commission on the total sales amount using a tiered rate: 5 % on the first $10 000, 7 % on the next $10 000, and 10 % on any amount above $20 000. Using spreadsheet logic, determine the total commission payable. Provide the numeric result in dollars.
Answer Options
About This Question
This is City Guilds Model Questions Vol1 2022 Information Technology Question 32. It is one of the objective questions from the 2022 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.