Question

create a table in excel to record the student information and marks of 20 students​

Answer 1

Answer:

1) Start “MS Excel” program

2) Fill your data by these information “SNO”, “Name”, “F/Name”, “English”, “Chemistry”, “Mathematics”, “Physics”, “Biology”, “Drawing”, “History”, “Total Marks”, “Marks Obtained”, “Minimum no”, “Maximum no”, “Average”, and “Grade”. Bold your text and then fill it by your own information as given below.

3) Use this function in first cell of “Marks Obtained” which is given above. =sum(F5:L5) As you will type this function “=sum(F5:L5)”. After type it press “Enter”. As you will press “Enter” our value will directly define as given below.

Answer 2

Answer:

10 20 30 40 50 60 70 80 90 40 50 60 70 80 90 20 10 40 30 50