Practice for MS Excel

1)     Type the above table in your sheet

2)     Find out bonus with below conditions next to the Working Days Column

      Salary>=Rs. 15,000 give 50% Bonus

      Salary >= Rs. 10,000 give 30% Bonus

      Salary <Rs. 10,000 give 10% Bonus

3)     Find out the Net Salary next to the Bonus Column

      Net Salary = Salary + Bonus

4)     Create 2 Columns, Name with Initial & Full Name next to the Net Salary                 Column

5)     Find out the end letter of the Last Name

6)     Count the Male and Female numbers

7)     Calculate the Average of Working Days

8)     You are going to give Promotion to the Staffs with these two conditions

      Working days >=250 and Salary>=Rs. 15,000 if these 2 condition is true then           you may give “Yes, Promoted”, otherwise “No, Not Promoted”.

9)      Create Line Chart, Pie Chart Using Working Days and Name

10) Rename the sheet as Staffs Details

Index No	Title	First Name	Last Name	Salary	Working Days
2001	Mr	Vasuthevan	Mathavan	Rs.8,540.00	210
2002	Mr	Rakshakan	Harish	Rs.10,596.00	200
2003	Ms	Vincent	Pragya	Rs.5,100.00	250
2004	Ms	Seguvaro	Mahashini	Rs.7,050.00	180
2005	Mr	Gastro	Ruthran	Rs.8,000.00	190
2006	Mr	Maathumaiyan	Maxican	Rs.15,000.00	260
2007	Ms	Veerakaththi	Rukmani	Rs.18,000.00	230
2008	Mr	Vijayan	Roshan	Rs.9,000.00	170
2009	Ms	Thiruthan	Geetha	Rs.9,550.00	130
2010	Ms	Mithuran	Maalini	Rs.5,400.00	220
2011	Ms	Maalmarugan	Sugashini	Rs.7,480.00	205