Question

Q10. Answer the following questions in reference to the figure below:
A
В
D
E
F
G
1
Sno
name
english maths Science
Total marks
Average
2
1
shweta
67
59
72
3
2
Anaya
84
60
63
4
3
Paarth
79
54
68
5
4
Ravi
92
69
76
6
5
Irfan
83
74
91
7
a.
Write the formula to calculate the total marks of student in cell F2.
b. Write the formula to calculate the average marks of student in cell G3.
C. Write the formula to calculate the highest marks of english in cell 07.
d. Name the feature through which you can compute automatically sum without entering any formula.
e. Mention the feature to arrange the student data in ascending order as per name.
f. Mention the feature name to present the data in graphical form.​

Answer 1

Answer:

sorrryyyyyyyyyyyy mujhe nahi patasorrryyyyyyyyyyyy mujhe nahi pata

Explanation:

꧁•ᏒคᎥຮᴛαʀ࿐