Question

1x5=5
Q.20. Write formulas/functions for the following cell.
|
G | H |
Total% Result
75
3
А
Name of
student
Amit
Sumit
| Ravi
Mohan
Kavita
77
4
в 1c p TE | F
Maths S.St. Eng IT Sci
(100) (100)| (100)| (100)| (100)
22 55 44
44
55 66 88 65
42 58 78 77 85
57 62 | 78 | 77 44
75 95 88 87
86.
Maximum
Marks
Minimum
Marks
5
6
Cell G2 for find total marks obtained by student.
Alte
Cell H2 for find % obtained by the student.
Cell 12 to find the result on the basic of % obtained by the student more than 33%
declared as Pass otherwise fail.
Cell G7 for find the maximum marks obtained by student.
Cell G8 for find the minimum marks obtained by student.
IV.
V.​

Answer 1

Answer:

gdhfnfhsbfgdjrsgdvdbddvdvdvdhdbstnstbtsbsgbfbsthetbrhwhetntkydhrntmtndtfnenen