Gce Model Questions Vol1 2017 Computer Studies Question 33
Practice objective / multiple choice question 33 from the 2017 Gce Model Questions Vol1 Computer Studies examination.
A spreadsheet contains three employees, each with a base salary of \(30{,}000\) ₦. Their sales figures are: Employee A - \(120{,}000\) ₦, Employee B - \(85{,}000\) ₦, Employee C - \(45{,}000\) ₦. Commission is paid as follows: up to \(50{,}000\) ₦ sales → 5 % of sales; \(50{,}001\) ₦ to \(100{,}000\) ₦ → 7 %; above \(100{,}000\) ₦ → 10 %. Using appropriate spreadsheet formulas, determine the total payroll (base salary plus commission) for all three employees.
Answer Options
About This Question
This is Gce Model Questions Vol1 2017 Computer Studies Question 33. It is one of the objective questions from the 2017 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.