Excel Exercise No 3 Create Salary Sheet In MS Excel | Download Excel Sheet

 


Employee  Salary  Calculation

"Write formula using cell name for the following expression. State where the

formula is placed.

i.        Basic Pay = Working Days * Rate.

ii.       Allowance are allocated at 10% of the Basic Pay.

iii.      Gross Pay = Basic Pay + Allowances.

iv.      Tax Deduction is calculated at 10% of the Gross Pay.

v.       Net Pay = Gross Pay – Tax Deductions – NSSF Contributions.

NSSF 🡪   National Small Savings Fund (Rate @5%),

(All this rates are an example it would be changed as per company rules.)"