Question

8. On the basis of the given worksheet, answer the questions given at the end :
1x4=4
A
B
С
D
E
1
Name
Science
Maths
Total
Average
2
Ankur
70
80
3
Sunil
90
98
4.
Ashok
60
90
ол
Rohit
50
50
6
Maximum marks
I
Minimum marks
(a) Write a function to calculate the total marks for each student in column D.
(b) Write a formula to calculate the average for each student and display in
column E.
(c) Write a formula to display the maximum marks in Science in cell B6
(d) Write a formula to display the minimum marks in Maths in cell C7.​

Answer 1

worksheet ka pic bhejo

Explanation:

don't infringement

Answer 2

Answer:

I can't understand question

please send the worksheet then I can answer