Question

8. On the basis of the given worksheet, answer the questions given at the end 1x4-4

A

B

Science

70

90

60

50

Maths

80

98

90

50

D

Total

E

Average

1

2

3

4

5

6

7

Name

Ankur

Sunil

Ashok

Rohit

Maximum marks

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.

(e) 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

Answer:

sh of vo is ch bdrgbczvmffbhyc

Answer 2

qishridbckcjkfjvjfkxhsu2gdu849fbdb2woxjbsshw