How to calculate employee salary

 2. Enter the following details for 10 employees. Employee code, employee name, basic salary, DA, HRA, Loans, Total salary and tax.

Salary for the month
Employee code	Employee name	Basic salary	DA	HRA	Loan	Total salary	Tax

a) Type the employee code, employee name, basic salary and loan amount data for 10 employees in the spreadsheet.

b)  b)   Format all numbers as a currency

c)    c)  Center the spreadsheet headings across the spreadsheet

d)  d)   Format all text.

e)    e) Create a formula to compute DA as 50% of the basic salary and copy this to all the cells

f)    f) Create a formula to compute HRA as 12% of the basic salary and copy this to all the cells

g)    g) Create a formula to compute total salary and copy this to all the cells.

h)   h) If total salary is greater than 500000 compute tax as 20% of total salary otherwise 10% of the total salary using a formula.