Neco 2021 Computer Studies Question 50
Practice objective / multiple choice question 50 from the 2021 Neco Computer Studies examination.
A spreadsheet calculates an employee's monthly net salary. The base salary (cell B2) is \(\text{₦}120{,}000\). An allowance (cell B3) equals 15\% of the base salary. Tax is applied to the gross amount (base + allowance) as follows: first \(\text{₦}100{,}000\) at 10\%, the next \(\text{₦}50{,}000\) at 20\%, and any amount above \(\text{₦}150{,}000\) at 30\%. After tax, a fixed pension contribution of \(\text{₦}5{,}000\) is deducted. Write the formula that would compute the net salary and give the resulting net salary value.
Answer Options
About This Question
This is Neco 2021 Computer Studies Question 50. 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.