Question

16. Given the following spreadsheet, write the appropriate Formula/expression/funct
to be used for (a) to (c).
A
B
D
G
H
Maths
Total
%age
1 Student ID Name
2
3 1 Anmol
2
Akhil
English
80
46
50
80
45
35
E
Science
80
13
65
49
34.5
47.5
63
69
S.St
80
31.5
51.5
42
20
47
40
3
40
15
Archit
Alok
37
32
40
33
42
32
7
S
Amit
66
a. Write function to calculate the Total Marks of each student in H3.
b. Which feature is used for arranging the name of students alphabetically.
Write the function to calculate the percentage in cell 13.​

Answer 1

Answer:

the camputer can wark on the principal of ipo cycle