Practice for MS Excel

Admission No	Math’s	Science	English
003/SS/011	54	45	58
003/SS/012	25	85	98
003/SS/013	12	78	75
003/SS/014	45	98	26
003/SS/015	78	42	56
003/SS/016	65	36	45
003/SS/017	85	98	36
003/SS/018	45	89	95
003/SS/019	78	78	85
003/SS/020	98	23	45

1)     Create above table in your sheet

2)     Insert two Rows from row 1 and give a main Heading as “Challenge Tutor-             2016”, and give sub heading as “Students’ Marks Details” in Row 2

3)     Insert 3 Columns next to the English and name it as Total, Average, Grade,              Remark

4)     Insert following conditions to Grade & Remark

      Average>=75, “A”                     A = “Very Good Pass”

      Average >=65, “B”                    B = “Good Pass”

      Average >=50, “C”                    C = “Credit Pass”

      Average >=40, “S”                     S = “Pass”

      Average <40, “F”                       F = “Fail”

                5)   Count A, B, C, S, F

                6)   Create Mode and Median Function to each Subject

                7)   Create a Bar chart and pie chart with suitable values

                8)  Format the column Width and Row Height into “18”

                9)  if Average >=65 give Green Color to the cell if Average <65, give Red Colur                             using conditional formatting only

              10)Rename the sheet as “Challenge”