5. Create a spreadsheet on marks obtained by 5 students of 10th standard in 3 subjects. Use the following
data:
Name of the Student
Marks in English Marks in Science
Marks in Maths Total Marks
Shalini
88
76
Average
89
Malini
85
88
87
Tanuj
92
97
99
Vikas
55
68
77
Arun
84
92
80
Do the following operations:
a. Enter the datasheet of numbers in Excel sheet.
b. Compute the total marks scored by each student using formula.
C. Compute the average of each student using formula.
d. Display a sorted list of students in terms of average marks in the descending order.
Answers
Answer:
5. Create a spreadsheet on marks obtained by 5 students of 10th standard in 3 subjects. Use the following
data:
Name of the Student
Marks in English Marks in Science
Marks in Maths Total Marks
Shalini
88
76
Average
89
Malini
85
88
87
Tanuj
92
97
99
Vikas
55
68
77
Arun
84
92
80
Do the following operations:
a. Enter the datasheet of numbers in Excel sheet.
b. Compute the total marks scored by each student using formula.
C. Compute the average of each student using formula.
d. Display a sorted list of students in terms of average marks in the descending order.
Answer:
Create a spreadsheet on marks obtained by 5 students of 10th standard in 3 subjects. Use the following
data:
Name of the Student
Marks in English Marks in Science
Marks in Maths Total Marks
Shalini
88
76
Average
89
Malini
85
88
87
Tanuj
92
97
99
Vikas
55
68
77
Arun
84
92
80
Do the following operations:
a. Enter the datasheet of numbers in Excel sheet.
b. Compute the total marks scored by each student using formula.
C. Compute the average of each student using formula.
d. Display a sorted list of students in terms of average marks in the descending order.