Neco 2017 Computer Studies Question 16
Practice objective / multiple choice question 16 from the 2017 Neco Computer Studies examination.
A company uses the following spreadsheet formula to compute an employee's net bonus (in naira): Base bonus = IF(sales>=60000,0.12*sales, IF(sales>=40000,0.09*sales, IF(sales>=20000,0.06*sales,0.04*sales))) Region bonus = VLOOKUP(region, {North,0.025; South,0.020; East,0.022; West,0.021}, 2, FALSE)*sales Gross bonus = Base bonus + Region bonus Tax rate = IF(Gross<=3000,0.05, IF(Gross<=5000,0.08,0.12)) Net bonus = Gross bonus * (1 - Tax rate) If an employee in the West region records sales of \\(45,000\\) naira, what is the net bonus (rounded to two decimal places)?
Answer Options
About This Question
This is Neco 2017 Computer Studies Question 16. It is one of the objective questions from the 2017 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.