Students marks list in excel

 3. Enter the following details for 10 students. register number, name, subject1 marks, subject2 marks, subject3 marks, subject4 marks, total marks and percentage.

Test marks data of a class
Register number	Name	Subject1 marks	Subject2 marks	Subject3 marks	Subject4 marks	Total marks	percentage

a)   a)   Type the register number, name and marks of four subjects for 10 students in the spreadsheet.spreadshee

b)   b) Format all text and numeric data appropriately.

c)    c) Center the spreadsheet heading across the spreadsheet.

d)   d) Create a formula to compute the total marks and copy this to all the cells.

e)    e) Create a formula to compute percentage and copy this to all the cells.

f)     f) Create a formula to compute the highest and lowest score using a library function

g)    g) Draw a bar graph for register number against total marks.

h)   h) Draw a pie chart for one student showing his marks in different subject from total score.