Question

Write functions for operations (a)- (e) based on the spreadsheet given below along with

the relevant cell address:

A B C D E F G

1 S.NO. NAME SCIENCE MATHS COMPUTER TOTAL AVERAGE

2 1 Swati 70 80 87

3 2 Shruti 90 98 88

4 3 Neelu 90 90 98

5 4 Rosy 60 76 79

6 5 Shreya 50 45 67

7 MAX

8 TOTAL

a) To calculate the total marks as sum of science, maths, and computer for each student and

display them in column F.

b) To calculate the average marks for each student and display them in column G.

c) To calculate the highest marks in computer and display it in cell E7.

d) To calculate lowest marks in maths and display it in D7.

e) To calculate the total number of students appearing in science test and display it in cell C8
​

Answer 1

Answer:

co me on dear ❤❤ygp neyu oip