Microsoft Excel Exercise

Lab :

Code No.             3001                    3002                     3003

Employee            Ritesh                  Suresh                 Arun

Basic Salary         12000                  25000                  5400

Allowance            ?                           ?                           ?

Provident Fund   ?                           ?                           ?

Net Salary           ?                           ?                           ?

Questions:

Calculate allowance, provident fund and net salary

ÿ Allowance=5% of Basic Salary

ÿ Provident=10% of Basic Salary

ÿ Net Salary=(basic Salary + Allowance)-Provident Fund