Observe the following spreadsheet in Calc and answer the
questions given below.
AA
AC
1
Std Name
2 Ajay
3 Neha
4 Divya
5 Asha
6 Pooja
AB
AD
AE
English Hindi Science Total Marks
(Out of 100) (Out of 100) (Out of 100) (Out of 300)
60
60
80
200
75
p
80
55
210
72
65
90
227
60
50
56
166
80
45
90
215
i.
ii.
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.
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
the remaining records?
iii.please answer
Answers
Answered by
2
Answer:
very dissorted image
Explanation:
Answered by
0
Answer:
the table is not understandable
Explanation:
Similar questions