Practice for MS Excel

Index No	Course	Branch	Name	Word	Excel	P.Point	Access
3001	DICP	Trincomalee	Maarshan	25	-12	-10	-20
3002	DDDICP	Trincomalee	Ravi	34	89	98	87
3003	MSO	Colombo	Rejeen	56	67	67	45
3004	DIEDDP	Vavuniya	Saravan	15	13	45	34
3005	DDTP	Trincomalee	Sathees	56	43	38	56
3006	DDMP	Vavuniya	Davied	34	13	12	45
3007	DICP	Colombo	Kulen	79	67	67	78
3008	MSO	Colombo	Jhon	88	54	65	76
3009	DOEDP	Trincomalee	Kamal	90	89	78	67
3010	DIP	Vavuniya	Muhunthan	13	15	34	23
3011	DMP	Trincomalee	Harshan	105	109	102	102
3012	DICP	Vavuniya	Varshini	65	89	87	98
3013	DIEDP	Trincomalee	Priya	45	34	45	67
3014	MSO	Colombo	Geetha	67	79	78	70
3015	DTP	Colombo	Mano	45	75	65	55

1)     Create above table in your sheet

2)     Insert 5 Rows from Row 1 and center align the Heading as “Victory Semester” in 3^rd Row

3)     Insert 4 columns next to the Access and name it as “Total, Average, Grade, Scholarship”

4)     Give following conditions to Grade & Scholarship

           Average>100,"Invalid Marks",                   Grade=A, “Yes Scholarship”

          Average>=75,"D",                                       Grade is not A, then “No Scholarship”

          Average>=55,"C",

          Average >=35,"S",

          Average >=0,"F",

          Average <0,"Invalid Marks"

5)  Count D, C, S, F, Invalid Marks

6)  Count how many people from Trincomalee

7)  Create a Column chart & Pie chart with Suitable values

8)  Create Header as Semester and Footer as Created By Director of the Tutor y

9)  Create Pivot table and Course against Name and Average of the Total

10)Rename the Sheet as “Victor is on the way”