+3 votes
in Class 12 by kratos

Ms. Shipra, an IT professional in a Global Educational Institute has created following performance sheet in a spreadsheet application. Help her in finding out the maximum marks, total, average and remarks.

1 Answer

+1 vote
by kratos
 
Best answer

= max(b2: e2)

=sum(b2:e2) or =sum(B2,C2,D2,E2) =average(b2:e2

= if(h2>=40, “GO-AHEAD”, “REATTEMPT”)

...