Question

Observe the following spreadsheet in Calc and answer the
questions given below.
AA
1
Std Name
2 Ajay
3 Neha
4 Diva
5 Asha
6 Pooja
AB
AC
AD
AE
English Hindi Science Total Marks
(Out of 100) (Out of 100) (Out of 100 (Out of 300)
60
60
80
200
75
80
55
210
72
65
90
227
60
50
56
166
80
45
90
215
i.
Write a function to assign 'GOOD' to all those who
have scored Total Marks more than or equal to 225.
It should also assign 'FAIR' to those who have scored
Total Marks less than 225.
ii.
Which feature will you use to arrange the names of
the students in alphabetical order?
Which feature will you use to view the records of
students having Total Marks' less than 210 and hide
III.​

Answer 1

Answer:

ye question kis tarah ki he