Neco 2021 Computer Studies Question 31
Practice objective / multiple choice question 31 from the 2021 Neco Computer Studies examination.
In a spreadsheet, column A lists employee IDs, column B records total sales in naira, and column C computes commission using the formula: \(=IF(B2>100000,0.10*B2,IF(B2>50000,0.07*B2,0.05*B2))\). A VLOOKUP table in cells E1:F4 maps IDs to a fixed bonus: ID 101 → 2000, 102 → 1500, 103 → 2500, 104 → 1800. Total earnings are calculated as commission plus the bonus. The company then applies income tax: if total earnings exceed \(\text{₦}8000\) the tax rate is 15\%, otherwise 10\%. If employee ID 103 has total sales of \(\text{₦}68,000\), what is the net pay after tax (in naira)?
Answer Options
About This Question
This is Neco 2021 Computer Studies Question 31. It is one of the objective questions from the 2021 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.