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.
= max(b2: e2)
=sum(b2:e2) or =sum(B2,C2,D2,E2) =average(b2:e2
= if(h2>=40, “GO-AHEAD”, “REATTEMPT”)