Class-31(Excel)

31 K¬vk

Result Sheet - 02

wb‡gœi kZ©mv‡c‡¶ GKwU IqvK©kxU ˆZwi K‡i †UvUv‡ji Dci †MÖW ‡ei Kiv hvq|

kZ©mg~n t

·      GKRb QvÎ †h †Kvb GKwU wel‡q 10 Gi Kg †c‡j djvdj †dj n‡e|

·      ‡gvU b¤^i 80 ev Zvi †ewk n‡j †MÖW n‡e A+

·      ‡gvU b¤^i 70 ev Zvi †ewk n‡j †MÖW n‡e A

·      ‡gvU b¤^i 60 ev Zvi †ewk n‡j †MÖW n‡e A-

·      ‡gvU b¤^i 50 ev Zvi †ewk n‡j †MÖW n‡e B

·      ‡gvU b¤^i 40 ev Zvi †ewk n‡j †MÖW n‡e C

·      ‡gvU b¤^i 33 ev Zvi †ewk n‡j †MÖW n‡e D

·      †gvU b¤^i 33 Gi Kg n‡j †MÖW n‡e F

·      Total Gi wfwˇZ †UwejwU‡K Decending Order G mvRv‡Z n‡e|

G2 ‡m‡j †hvMdj †ei Kivi Rb¨-

·      ‡mj c‡q›Uvi G2 G ivL‡Z n‡e|

·      =Sum(C2:F2) UvBc K‡i G›Uvi Pvc‡Z n‡e| cieZx© †mj¸‡jv‡Z Kwc Ki‡Z n‡e|

‡UvUv‡ji Dci wfwË K‡i †MÖW †ei Kivi Rb¨ H2 ‡m‡j Kvimi †i‡L

=If(Or(C2<10,D2<10,E2<10,F2<10),"F",If(G2>=80,"A+",If(G2>=70,"A",If(G2>=60,"A-",If(G2>=50,"B",If(G2>=40,"C",If(G2>=33,"D","F"))))))) wj‡L G›Uvi Pvc‡Z n‡e| cieZx© †mj¸‡jv Kwc Ki‡Z n‡e|

Total Gi Dci Decending Sort Kivi Rb¨

·      Data ‡gby †_‡K Sort wK¬K Ki‡Z n‡e|

·      Sort by e‡K&ª Total Ges Decending Ackb wm‡j± Ki‡Z n‡e|

·      Ok evUb wK¬K Ki‡Z n‡e|

CSV—Comma-Separated Values

COBOL—Common Business-Oriented Language

CGI—Common Gateway Interface /Computer-Generated Imagery

DAO—Data Access Objects

DHTML—Dynamic Hypertext Markup Language

DAT—Digital Audio Tape

DB—Database

DIVX—Digital Video Express

DVD—Digital Video Disc

DVD-R—DVD-Recordable