06 Advance Excel - Mark Sheet

  टीप : Smart-phone मध्ये  screen Rotate केल्यास file accurate दिसेल.

Advance Excel-Excel-2013

This Topic

Mark Sheet

Format 

Sr.no | Student name | Marathi | Hindi | English | Math | Science | Social Science | Total | Percentage |  Results | Grade | Class | Max | Min

Formula 

 Total

 =Sum(B2:G2) Enter (B2:G2= All Subject Select) (Marathi to Social Science)  Percentage= Average(B2:G2) Enter (B2:G2= All Subject Select)Marathi to Social Science) 

 Result

=if(C5<35,”fail”,if(D5<35,”fail”,if(E5<35,”fail”,if(F5<35,”fail”,if(G5<35,”fail”, if(H5<35,”fail”,”pass”)))))) Enter 

(Subject=Marathi, Subject= Hindi, Subject= English, Subject= Math, Subject= Science, Subject= Social Science) 

 Grade 

=if(K7<45,”cgrade”,if(K7<60,”bgrade”,if(K7<75,”Agrade”,”A+grade”))) 

K7= Percentage 

 Class 

=if(K7<45,”iii class”, if(K7<60,”ii class”, if(K7<75,”I class”,”Dist.”))) Enter K7 = Percentage 

 Maximum 

= Max(Range) Enter (All subject Select) (Marathi to Social Science) 

 Minimum 

= Min(Range) Enter (All subject Select) (Marathi to Social Science)