Neco 2020 Computer Studies Question 37
Practice objective / multiple choice question 37 from the 2020 Neco Computer Studies examination.
Consider the following sales data for five employees (in Naira): Employee A: 80,000; B: 120,000; C: 95,000; D: 150,000; E: 110,000. The company pays commission as follows: 5\% on the first 100,000 of sales and 8\% on any amount above 100,000. Write the spreadsheet formula that computes the commission for a given sales figure in cell B2, and then calculate the total commission that must be paid to all employees whose sales exceed the overall average sales. What is that total commission amount?
Answer Options
About This Question
This is Neco 2020 Computer Studies Question 37. It is one of the objective questions from the 2020 Neco 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.