Question

(b)
Consider the following worksheet data :
с
E
D
B
А
Total
1
Roll No.
Marks in
Science
Name of
Students
Marks in
Computer
Average
Marks
Marks in
Maths
Marks
81
78
77
2
1
Amarjeet
85
88
88
3
Kaushal
2
92
72
92
4
Shraboni
3
93
89
5
88
Ruchit
4
94
84
6
90
Rishi
5
7
Total
On the basis of the above data, write the formula for the following: 1x4=4
(i) To find the lowest total marks obtained in each subject in cell F7.
(ii) To find the average of Kaushal's marks in cell G3.
ushal
(iii) To find the total marks in computers for all students in cell D7.
(iv) To find the highest average of the class in cell G7.​

Answer 1

Answer:

ruchi either of the time and consideration

Answer 2

Answer:

answer will be 0 bqtvtvtvfecece