4.working With Excel

MSIT

Kw¤úDUvi cÖwk¶Y †K›`ª w·gvnbx evRvi (†ij†MU msjMœ), KzwoMÖvg| ‡dvb: 01914957344 / 01722855738 Email: [email protected] Web: www.msit.250m.com

Microsoft Excel Gi cwiPq

Microsoft Excel GKwU Spread Sheet Analysis Program. Gi gva¨‡g Data cÖ‡ek Kiv‡bv I we‡klY Kiv hvq| mvaviY ‡hvM, we‡qvM, ¸Y, fvM, Kiv mn cÖwZôv‡bi Avq-e¨q cªwZ‡e`b, †eZb kxU cÖbqY,AvqKi, we`y¨r wej, gRyix, Kwgkb,†iRvë kxU BZ¨vw` ˆZwi Ki‡Z GB Program e¨envi Kiv nq| g‡b ivLyb t Excel Gi File †K Work Book e‡j| cÖwZ Work Book G _v‡K 3 wU Work Sheet, cÖwZwU Work Sheet G 256 wU Kjvg, 65536 wU mvwi Ges 1677216 wU †mj _v‡K | Excel k‡ãi A_© DrK…ôZi, Spread Sheet k‡ãi A_© we¯Z…Z cvZv, Work Sheet k‡ãi A_© Kg© Dc‡hvMx cvZv| Microsoft Excel Pvjy Kib

Start evU‡b wK¬K Ki“b  All Program G wK¬K Ki“b  Microsoft Office G wK¬K Ki“b  Microsoft Office Excel 2003 G wK¬K Ki“b  wb‡Pi Qwei gZ GKwU Window Pvjy n‡e|

Name Box

Task pan

Cell Pointer

Column bar

Formulla bar Cell

Work ing area

Row bar

Scroll bar

Sheet Tab

Microsoft Excel G KvR Kivi wKQy ‡KŠkj

gvD‡mi mvnv‡h¨ ‡mj wm‡j± Kib t †mj wm‡j± Kivi Rb¨ wba©vwiZ †m‡j Kvm©vi ¯’vcb Ki“b| gvD‡mi evg cv‡ki †evZvg ‡P‡c †h mKj Cell select Ki‡Z Pvb, †mB w`‡K WªvM Ki“b| MSIT, w·gvnbx evRvi ,†ij‡MU,KzwoMÖvg| c„ôv bs 1

†MvUv columns / Row wm‡j± Kib t †h columns / Row wm‡j± Ki‡Z Pvb, ‡mB columns / Row ev‡ii bv‡gi Dci gvDm c‡q›Uvi wb‡q hvb, G¨v‡iv G‡j wK¬K Ki“b| wfbœ wfbœ columns / Row / cell wm‡j± Kib t cÖ_‡g columns / Row / cell wm‡j± K‡i wbb| Ctrl Kx †P‡c a‡i evwK columns/Row/cell wm‡j± Kiyb| Fill Handle Dragging: GKwU cell Gi Z_¨ †K avivevwnKZv eRvq †i‡L Ab¨ †m‡j cwiPvjbvi c×wZ †K Fill Handle Dragging e‡j| ‡h †Kvb †m‡j wK¬K Ki‡j gvDm c‡q›Uv‡ii GB iKg Qwe †`Lv hv‡e| Gi Wvb w`‡Ki wb‡Pi w`‡K Kvm©i Avb‡j + wPý avib Ki‡e | ZLb wK¬K K‡i gvDm c‡q›Uvi †K WªvM Ki‡j Z‡_¨i cwiPjb NU‡e| Save Work Space (Work Sheet †K mvBR, cwRkb mn †mf Kiv) GKwU Work Sheet G Data Entry Ki“b  †h mKj †mj Gi Ae¯’vb msi¶b Ki‡eb,Zv eK Ki“b File ‡gby‡Z hvb Save Work Space G wK¬K Ki“b dvB‡ji bvg w`bSave evvU‡b wK¬K Ki“b| Print Area (Work Sheet Gi wbw`©ó Ask wcÖ›U Kiv) GKwU Work Sheet Gi †h Ask UzKz wcÖ›U Ki‡eb Zv eK Ki“b  File †gby‡Z wK¬K Ki“b Print Area Gi Awab¯’ Set Print Area †Z wK¬K Ki“b| Fill (†mj mgyn†K A‡Uv‡gwUK¨vwj cyib Kiv) aiv hvK, 2,4,6,8,10,12,14 msL¨v ¸wj †m‡ji ci †mj avivevwnK fv‡e Avm‡e| †m‡¶‡Î,GKwU †m‡j 2Ges ciewZ© ‡m‡j 4 UvBc Ki“b  Dfq †mj wm‡j± Kiyb  wm‡j± K…Z †mj ؇qi n¨v‡Û‡j gvDm c‡q›Uvi ¯’vcb Ki‡j + wPý Avm‡e  + wPý G‡j wK¬K K‡i gvDm WªvM K‡i hZ ¸wj Cell Fill Kiv cÖ‡qvRb ZZ `y‡i wb‡q hvb| G fv‡e gv‡mi bvg;ZvwiL BZ¨vw` A‡Uv wdj Kiv hvq | Insert Work Sheet (Iqv©K kxU ms‡hvRb) ‡h Work Sheet Gi c~‡e© byZb Work Sheet ms‡hvRb Ki‡Z Pvb †mLv‡b †mj c‡q›Uvi ivLzb  Insert †gby‡Z wK¬K Ki“b  Work Sheet Ack‡b wK¬K Ki“b| Delete Work Sheet (IqvK© mxU gy‡Q †djv) †h Work Sheet gyQ‡eb †mLv‡b Kvmv©i ¯’vcb Ki“b  Edit ‡gby‡Z wK¬K Ki“b Delete Sheet G wK¬K Ki“b | Hide Work Sheet (Work Sheet jyKv‡bv ) †h Work Sheet jyKv‡eb †mLv‡b Kvmv©i ¯’vcb Ki“b Format ‡gby‡Z wK¬K Ki“b  Sheet Ack‡bi Aaxb Hide G wK¬K Ki“b| Work Sheet wU jywK‡q hv‡e| Show Work Sheet (jyKv‡bv Work Sheet †K cÖKvk Kiv) Format ‡gby‡Z wK¬K Ki“b  Sheet Ack‡bi Aaxb Unhide G wK¬K Ki“b  ‡Kvb Work Sheet wU Unhide Ki‡Z Pvb Zv wm‡j± Ki“b  Ok evvU‡b wK¬K Ki“b  Work Sheet wU cÖKvk n‡e| Rename Worksheet (Worksheet Gi bvg cwieZ©b) IqvK©kxU wU‡Z †mj c‡q›Uvi ¯’vcb Ki“b Format G wK¬K Ki“b  Sheet G wK¬K Ki“b Rename G wK¬K Ki“b Sheet wUi GKwU byZb bvg UvBc Ki“b Enter Pvcyb | Worksheet Gi Background G Qwe ms‡hvRb MSIT, w·gvnbx evRvi ,†ij‡MU,KzwoMÖvg| c„ôv bs 2

†h †Kvb GKwU †m‡j wK¬K Ki“b Format G wK¬K Ki“b Sheet G wK¬K Ki“b Background G wK¬K Ki“b  Gevi Kvw•LZ †dvìv‡ii wcK&Pvi dvBjwU Open Ki“b | Background gy‡Q ‡djv Background ms‡hvwRZ Worksheet Gi ‡Kvb GKwU †m‡j wK¬K Ki“b  Format G wK¬K Ki“b  Sheet G wK¬K Ki“b Delete Background wK¬K Ki“b | Column ms‡hvRb Work Sheet Gi †h Kjv‡gi c~‡e© Kjvg Avb‡Z Pvb †mLv‡b c‡q›Uvi ¯’vcb Ki“b Insert ‡gby‡Z wK¬K Ki“b  Column G wK¬K Ki“b| Column Lvwj Kiv Work Sheet Gi †h Kjvg evwZj Ki‡Z Pvb †mLv‡b †mj c‡q›Uvi ¯’vcb Ki“b Edit ‡gby‡Z wK¬K Ki“b Delete G wK¬K Ki“b  Entry Column G wK¬K Ki“b  OK evU‡b wK¬K Ki“b| Row ms‡hvRb Work Sheet Gi †h †iv Gi c~‡e© ‡iv Avb‡Z Pvb †mLv‡b c‡q›Uvi ¯’vcb Kiyb Insert ‡gby‡Z wK¬K Ki“b  Rows G wK¬K Ki“b| Row Lvwj Kiv Work Sheet Gi †h Kjvg evwZj Ki‡Z Pvb †mLv‡b c‡q›Uvi ¯’vcb Kiƒb  Edit ‡gby‡Z wK¬K Ki“b  Delete G wK¬K Ki“b Entry Column G wK¬K Ki“b OK evU‡b wK¬K Ki“b| Cell ms‡hvRb Work Sheet Gi †h †m‡ji c~‡e© ‡mj Avb‡Z Pvb †mLv‡b c‡q›Uvi ¯’vcb Kiƒb  Insert ‡gby‡Z wK¬K Ki“b  Cell G wK¬K Ki“b  Shift Cell Rights / Shift Cell Down wK¬K Ki“b| Cell Lvwj Kiv Work Sheet Gi †h Cell evwZj Ki‡Z Pvb †mLv‡b c‡q›Uvi ¯’vcb Kiƒb Edit ‡gby‡Z wK¬K Ki“b  Delete G wK¬K Ki“b  Shift cell left / Shift cell Up G wK¬K Ki“b OK evU‡b wK¬K Ki“b| Wrap text (eo †jLv‡K LwÛZ K‡i †m‡j cÖ`k©b) ‡jLvwU †K eK Ki“b  Format †gby‡Z wK¬K Ki“b  Cell Ack‡b wK¬K Ki“b  Alignment U¨v‡e wK¬K Ki“b  Wrap text Ack‡b wK¬K Ki“b  Ok Ki“b| Shrink (eo †jLv‡K ms‡KvPb K‡i GKB jvB‡b cÖ`k©b) ‡jLvwU †K eK Ki“b  Format †gby‡Z wK¬K Ki“b Cell Ack‡b wK¬K Ki“b  Alignment U¨v‡e wK¬K Ki“b  Shrink To Fit Ack‡b wK¬K Ki“b  Ok Ki“b | Merge Cells (GKvwaK ‡mj †f‡½ GKwU ‡m‡j cwieZ©b ) cÖ‡qvRbxq †mj mgyn wm‡j± K‡i wbb|Format †gby‡Z wK¬K Ki“b  Cell Ack‡b wK¬K Ki“b  Alignment U¨v‡e wK¬K Ki“b  Merge Cells Ack‡b wK¬K K‡i †PK gvK© Ki“b  Ok Ki“b| Rotate The Text (†jLv‡K Nyiv‡bv ) MSIT, w·gvnbx evRvi ,†ij‡MU,KzwoMÖvg| c„ôv bs 3

†h †m‡ji †jLv mgyn †K Nyiv‡Z Pvb Zv wm‡j± Ki“b  Dc‡ii c×wZ‡Z Alignment GwM‡q Degree Ack‡b ‡U·U& e‡· b¤^i Gw›Uª Ki“b  Ok Ki“b| Font msµvš— hveZxq KvR cÖ‡qvRbxq ‡jLv mgyn wm‡j± K‡i wbb  Format †gby‡Z wK¬K Ki“b  Cell Ack‡b wK¬K Ki“b  Font U¨v‡e wK¬K Ki“b  Avcbvi cÖ‡qvRb †gvZv‡eK wewfbœ Ackb wm‡j± K‡i Ok Ki“b| Currency (gy`ªvi wPý cwieZ©‡bi Rb¨) Format Cell Font Number  Category †_‡K Currency Ack‡b wK¬K Ki“b Symbol bvgK Wªc WvDb Kx‡Z wK¬K K‡i Currency wPý wbev©Pb Ki“b|| †hgb: Wjv‡ii Rb¨ $ UvKvi Rb¨ $| Border (†m‡ji eW©vi hy³ Kiv) ‡mj /†mj mgyn wm‡j± K‡i wbb Format †gby‡Z wK¬K Ki“b Cell Ack‡b wK¬K Ki“b  Border U¨v‡e cÖ‡ek Ki“b  Style, Outline, Color BZ¨vw` Ackb ‡_‡K cÖ‡qvRbxq Kvh©vejx m¤úbœ K‡i Ok Ki“b | (wk¶‡Ki mnvqZv wbb ) MÖvd ms‡hvRb †h ¯’v‡b MÖvd Avb‡Z Pvb †mLv‡b ‡mj c‡q›Uvi ivLyb  Insert ‡gby‡Z wK¬K Ki“b  Object Ack‡b wK¬K Ki“b  Object Type Gi Microsoft Graph Chart G wK¬K K‡i cÖ‡qvRbxq PvU© †e‡Q wbb  Ok †Z wK¬K Ki“b  Chaste Editliong ¯‹xb G‡j wk¶‡Ki mn‡hvwnZvq Data Entry Ki“b  gvDm c‡q›Uvi Work Sheet G wK¬K K‡i Pv©UwU ms‡hvRb m¤úbœ Ki“b| Data †_‡K PvU© ˆZwi †WUv ¸wj wm‡j± Ki“b Insert ‡gby‡Z wK¬K Ki“b Chart Ack‡b wK¬K Ki“b wjó †_‡K MÖvd †e‡Q wbbUvB†Uj U¨v‡e wK¬K K‡i U¨v‡e bvg w`b Next evU‡b wK¬K Ki“b AS New Sheet G wK¬K Ki“b Finish evU‡b wK¬K Ki“b| dvskb Gi e¨envi Excel G wewfbœ ai‡bi wnmve wbKvk Kivi Rb¨ dvskb e¨envi Kiv nq| wbw`©ó ‡m‡j m~Î wj‡L djvdj †ei Kiv hvq Avevi Insert †gby‡Z wM‡q Function Ack‡b wK¬K K‡i Insert Function bvgK WvqjM e‡·i Select Category †_‡K Category ‡e‡Q wb‡q wbw`©ó Function wm‡j± K‡i OK Ki‡Z n‡e| d‡j GKwU dg© Avm‡e hv cyib K‡i OK Ki‡j djvdj Avm‡e| AÎ †bv‡U Avgiv myÎ UvBc K‡i djvdj wbY©q K‡iwQ| G‡·‡j A‡bK cÖKvi dvskb Av‡Q hv Aí mg‡q wkLv‡bv m¤¢e bq Ges ‡kLvI Riƒix bq| mK‡ji Kv‡R jv‡M Ggb wKQy dvsk‡bi KvR wb‡q GB †bv‡U Av‡jvPbv Kiv n‡q‡Q| ‡m‡j dvskb †jLvi mgq wKQy wbqgKvbyb †g‡b Pj‡Z nq| ‡hgb t cÖ_‡g = wPý UvBc Ki‡Z n‡e| A¶i ¸wj †QvU nv‡Zi / eo nv‡Zi n‡Z cv‡i| dvskb I AvM©y‡g›Um‡K eª¨vwKU Øviv Ave× Ki‡Z n‡e| dvskb I AvM©y‡g›Um –Gi gv‡S †Kvb †¯úm _vKv Pj‡e bv| GKvwaK AvM©y‡g›Um m¤^wjZ dvskb Kgv ev †mwg‡Kvjb Øviv c„_K Kiv hv‡e| dvsk‡b msL¨v I A¶i e¨eüZ n‡Z cv‡i| d¨vskb I AvM©y‡g›Um SYNTAX n‡j †m‡¶‡Î Wvej †Kv‡Ukb Øviv AveØ Ki‡Z n‡e | m‡ev©cwi d¨vskb e¨env‡ii Av‡M mswkó wel‡hi Dci Ávb _vKv AZ¨vek¨K| MSIT, w·gvnbx evRvi ,†ij‡MU,KzwoMÖvg| c„ôv bs 4

ev¯—e wKQy Kv‡Ri bgybv (1) mvaviY wnmve wbKvk

GKwU IqvK© kx‡U bx‡Pi WvUv ¸wj Gw›Uª Ki“b

‡hvM Kiv t aiv hvK, cÖwZ QvÎ cÖ‡Z¨K wel‡q †h b¤^i Mywj †c‡q†Q ,Zvi †hvMdj †ei Ki‡Z Pvb| G2 †m‡j wK¬K Kiyb  UvBc Kiyb =SUM(B2+C2+D2+E2+F2)  Enter evUb Pvcyb| j¶ Kiyb B2 nB‡Z F2 ch©š— mKj †m‡ji †hvMdj G2 †m‡j G‡m‡Q| (djvdj 271) GKB my‡Îi gva¨‡g A‡bK mgvavb wbY©q t g‡bKiyb, †h c×wZ†Z †ivj bs 1 Gi mKj wel‡qi djvdj †ei n‡q‡Q, †mB c×wZ †Z 2 nB‡Z 5 bs †ivj avix Qv·`i djvdj †ei Ki‡Z Pvb| G2 †m‡j gvDm c‡q›Uvi ivLyb  Fill Handle G Kvm©i Avb‡j Kvm©I + AvKvi avib Ki‡e  GLv‡b wK¬K K‡i WªvwMs K‡i G6 ch©š— wb‡q Avmyb | j¶ Kiyb 2,3,4 I 5 bs †ivj avix Qv·`i djvdj G3, G4 ,G5, G6 †m‡j G‡m‡Q| (djvdj 271, 294, 244, 266, 274)

we‡qvM Kiv t aiv hvK, Avcwb Rvb‡Z Pvb 1bs QvÎ History A‡c¶v Islamic G KZ †ekx †c‡q‡Q| H2 †m‡j wK¬K Kiyb  wb‡æi myÎwU UvBc Kiyb =SUM(E2-F2) Enter evUb Pvcyb  djvdj ‡ei n‡e | Gevi Fill Handle WªvwMs K‡i H2 ‡_‡K H6 ch©š— djvdj mÂvjb Ki“b| ( djvdj t 30, 27, 27, -18, 36)

¸bb Kiv t aiv hvK, E2 †m‡ji Data Gi mv‡_ F2 †m‡ji Data Gi ¸bb Ki‡Z Pvb| I2 †mj wU †Z wK¬K Kiyb  wb‡æi myÎwU UvBc Kiyb =SUM(E2*F2)  Enter evUb Pvcyb  djvdj ‡ei n‡e| Gevi Fill Handle WªvwMs K‡i I2 ‡_‡K I6 ch©š — djvdj mÂvjb Ki“b| djvdj (3139,4510,2368,2944, 2701) g‡b ivLybt Kx‡ev‡Wi© * wPý †K ¸b‡bi wPý wnmv‡e e¨envi Kiv nq|

fvM Kiv t aiv hvK, E2 †m‡ji Data Gi mv‡_ F2 †m‡ji Data Gi fvM Ki‡Z Pvb| J2 †mj wU †Z wK¬K Kiyb  UvBc Kiyb =SUM(E2/F2)  Enter evUb Pvcyb  djvdj ‡ei n‡e | Gevi Fill Handle WªvwMs K‡i J2 ‡_‡K J6 ch©š— djvdj mÂvjb Ki“b| (djvdj t1.69,1.49,1.72,0.71,1.97) g‡b ivLyb t Kx‡ev‡W©i / wPý †K fv‡Mi wPý wnmv‡e e¨envi Kiv nq|

(2) Kwgkb wnmve Kiv MSIT, w·gvnbx evRvi ,†ij‡MU,KzwoMÖvg| c„ôv bs 5

g‡b Kwi, GKwU exgv †Kv¤úvbxi 5 Rb Kgx© wb‡Pi weeib gZ A_© Av`vq K‡i‡Q| Zv‡`i cÖvc¨ Kwgkb †ei Ki‡Z n‡e| GKwU IqvK© kx‡U wb‡Pi WvUv ¸wj Gw›Uª Ki“b|

hw` Av`v‡qi cwigvb 2000 UvKvi Kg nq, Zvn‡j Kwgkb cv‡e bv| hw` Av`v‡qi cwigvb 7000 UvKvi Kg nq, Zvn‡j Av`vqK…Z A‡_©i Dci 5% Kwgkb cv‡e| hw` Av`v‡qi cwigvb 7000-15000 UvKvi g‡a¨ nq, Zvn‡j Av`vqK…Z A‡_©i Dci 10% Kwgkb cv‡e| hw` Av`v‡qi cwigvb 15000 UvKvi ‡ewk nq , Zvn‡j Av`vqK…Z A‡_©i Dci 15% Kwgkb cv‡e| D2 ‡m‡j ‡mj c‡q›Uvi ivLyb Ges UvBc Kiyb =IF(C2<2000,0,IF(C2<7000,C2*5%, IF(AND ( C2>=7000,C2<=15000),C2*10%,IF(C2>15000,C2*15%))))  Enter Kx Pvcyb  Fill Handle WªvwMs K‡i D2 ‡_‡K D6 ch©š— djvdj mÂvjb Ki“b| (djvdj t 3000, 1500, 1000, 250)

(3) gRyix wbY©q g‡bKi“b, Avcbvi Awd‡m 5 Rb kªwgK Av‡Q| GKwU IqvK© kx‡U wb‡Pi WvUv ¸wj Gw›Uª Ki“b| cÖ_†g Over Time †ei Ki“b c‡i Zv‡`i gRyix wbY©q Ki“b|

kªwgK‡`i 8 N›Uv KvR Kiv eva¨ZvgyjK| hw` †KD 8 N›Uv KvR K‡i, Z‡e N›Uv cªwZ 10 UvKv nv‡i gRyix †`qv nq| hw` 8 N›Uvi Kg KvR K‡i, Z‡e N›Uv cªwZ 7 UvKv nv‡i gRyix †`qv nq| hw` 8 N›Uvi †ekx KvR K‡i ,Z‡e Zv‡K wba©vwiZ 8 N›Uv Kv‡Ri wej mn Over Time Gi Rb¨ N›Uv cÖwZ 15 UvKv K‡i †`qv nq| Over Time †ei Kivi wbqgD5 †m‡j ‡mj c‡q›Uvi ivLyb  UvBc Kiyb =IF(C5>8,C5-8,0)  Enter Kx Pvcyb  Fill Handle WªvwMs K‡i D5 ‡_‡K D9 ch©š— djvdj mÂvjb Ki“b|(djvdj t Over time=2,0,0,7, 6) gRyix †ei Kivi wbqgMSIT, w·gvnbx evRvi ,†ij‡MU,KzwoMÖvg| c„ôv bs 6

E5†m‡j ‡mj c‡q›Uvi ivLyb Ges UvBc Kiyb =IF(C5=8,C5*10,IF(C5<8,C5*7,IF(C5>8,8*10+D5*15)))  Enter Kx Pvcyb  Fill Handle WªvwMs K‡i E5‡_‡K E9 ch©š— djvdj mÂvjb Ki“b| (djvdj t 110,80,35,185,170)

(4) ‡eZb wnmve Kiv g‡bKwi,Avcwb GKwU cÖwZôv‡b KvR K‡ib| H cÖwZôv‡bi Kg©KZ©v M‡bi †eZb Gi Basic †eZb wbæ i“c| Avcbv‡K Basic e Gi Dci wfwË K‡i Ab¨vb¨ wnmve ¸wj †ei K‡i †gvU †eZb †ei Ki‡Z n‡e|

Medical / wPwKrmv fvZv †ei Kivi wbqg hw` †ewmK †eZb 3000 Gi mgvb ev Kg nq, Z‡e fvZv cv‡e †ewmK ‡eZ‡bi 5%, hw` †ewmK 7000 Gi mgvb ev Kg nq, Z‡e fvZv cv‡e †ewmK ‡eZ‡bi 7%,hw` †ewmK †eZb 10000 Gi mgvb ev Kg nq, Z‡e fvZv cv‡e †ewmK ‡eZ‡bi 10%, hw` †ewmK †eZb10000 Gi †ewk nq,Z‡e fvZv cv‡e †ewmK ‡eZ‡bi 12% D4 †m‡j ‡mj c‡q›Uvi ivLyb UvBc Kiyb =IF(C4<=3000,C4*5%,IF(C4<=7000,C4*7%,IF(C4<=10000,C4*10%,IF(C4> 10000,C4*12%,))))  Enter Kx Pvcyb Fill Handle WªvwMs K‡i D4 ‡_‡K D8 ch©š— djvdj mÂvjb Ki“b| House rent / evmv fvov †ei Kivi wbqg hw` †ewmK †eZb 3000 Gi mgvb ev Kg nq, Z‡e evmv fvov cv‡e Basic Gi 15%,hw` †ewmK †eZb 7000 Gi mgvb ev Kg nq, Z‡e evmv fvov cv‡e Basic Gi 20%,hw` †ewmK †eZb10000 Gi mgvb ev Kg nq,Z‡e evmv fvov cv‡e Basic Gi 25%,hw` †ewmK †eZb10000 Gi †ewk nq, Z‡e evmv fvov cv‡e Basic Gi 30%| E4†m‡j ‡mj c‡q›Uvi ivLybUvBc Kiyb =IF(C4<=3000,C4*15%,IF(C4<=7000,C4*20%,IF(C4<=10000,C4*25%,IF(C4 >10000,C4*30%,)))) Enter Kx PvcybFill Handle WªvwMs K‡i E4 ‡_‡K E8 ch©š— djvdj mÂvjb Ki“b| ‡jvb eve` UvKv KZ©‡bi wbqg MSIT, w·gvnbx evRvi ,†ij‡MU,KzwoMÖvg| c„ôv bs 7

cÖ‡Z¨‡K wKQy UvKv †jvb wb‡qwQ‡jb Ges cÖwZ gv‡m Zv‡`i †ewmK †eZb †_‡K 500 UvKv K‡i †K‡U ivLv nq| F4†m‡j ‡mj c‡q›Uvi ivLyb  UvBc Kiyb =SUM(C4-500) Enter Kx Pvcyb  Fill Handle WªvwMs K‡i F4 ‡_‡K F8 ch©š— djvdj mÂvjb Ki“b| ‡gvU †eZb †ei Kivi wbqg G4 †m‡j ‡mj c‡q›Uvi ivLyb UvBc Kiyb =SUM(D4+E4+F4)Enter Kx PvcybFill Handle WªvwMs K‡i G4 ‡_‡K G8 ch©š— djvdj mÂvjb Ki“b| djvdj MS Computer Salary sheet for the Month of September Name Designation Basic Medilcal MD.Osman Ali Director 10000 1000 Milon Chief Instructor 7000 490 Sumon Instructor of Fantasy 5000 350 Navel Instructor of Basic COM 5000 350 Amdadul Instructor of Mobile 6000 420

House Rent 2500 1400 1000 1000 1200

Basic-Loan 9500 6500 4500 4500 5500

Total 13000 8390 5850 5850 7120

(5) Electricity Bill ‰Zwi g‡bKwi,Avcwb GKwU we`y¨r Awd‡m KvR K‡ib| 5 Rb MÖvn‡Ki wgUvi wiwWs wbæiyc| wb‡Pi WvUv ¸wj †_‡K Avcbv‡K BDwb‡Ui cwigvb, BDwbU PvR©, mvwfR© PvR© Ges †gvU we‡ji cwigvb †ei Ki‡Z n‡e|

Unite †ei Kivi wbqgPresent Reading †_‡K Previous Reading ev` w`‡q Unite Gi cwigvb †ei Ki‡Z n‡e| E3 †m‡j ‡mj c‡q›Uvi ivLyb UvBc Kiyb =Sum(C3-D3)Enter Kx Pvcyb Fill Handle WªvwMs K‡i E3 ‡_‡K E7 ch©š— djvdj mÂvjb Ki“b| Unite Charge †ei Kivi wbqghw` Unite 200 Gi Kg ev mgvb nq, Zvn‡j cÖwZ BDwb‡Ui gyj¨ 2 UvKv, hw` Unite 300 Gi Kg ev mgvb nq, Zvn‡j cÖwZ BDwb‡Ui gyj¨ 2.50 UvKv, hw` Unite 500 Gi Kg ev mgvb nq, Zvn‡j cÖwZ BDwbU 3 UvKv, hw` Unite 500 Gi ‡ewk nq, Zvn‡j cÖwZ BDwbU 3.50UvKv| F3 †m‡j ‡mj c‡q›Uvi ivLyb UvBc Kiyb =IF(E3<=200,E3*2,IF(E3<=300,E3*2.50,

MSIT, w·gvnbx evRvi ,†ij‡MU,KzwoMÖvg| c„ôv bs 8

IF(E3< =500,E3*3,IF(E3>500,E3*3.50)))) Enter Kx Pvcyb  Fill Handle WªvwMs K‡i F3 ‡_‡K F7 ch©š— djvdj mÂvjb Ki“b| Service Charge †ei Kivi wbqghw` Unite 200 Gi Kg ev mgvb nq, Zvn‡j cÖwZ BDwb‡Ui mvwf©R PvR© .10UvKv, hw` Unite 300 Gi Kg ev mgvb nq, Zvn‡j cÖwZ BDwb‡Ui mvwf©R PvR© .20UvKv, hw` Unite 500 Gi Kg ev mgvb nq, Zvn‡j cÖwZ BDwb‡Ui mvwf©R PvR© .30 UvKv, hw` Unite 500 Gi ‡ewk nq, Zvn‡j cÖwZ BDwb‡Ui mvwf©R PvR© .50 UvKv w`‡Z n‡e| G3 †m‡j ‡mj c‡q›Uvi ivLybUvBc Kiyb =IF(E3<=200,E3*.10,IF(E3<=300,E3*.20, IF(E3<=500,E3*.30,IF(E3>500,E3*.50))))  Enter Kx Pvcyb Fill Handle WªvwMs K‡i G3 ‡_‡K G7 ch©š— djvdj mÂvjb Ki“b| Total Bill ‡ei Kivi wbqg t Unite Charge Ges Service Charge Gi †hvMdj †K Total Bill wnmv‡e MÖvnK †K cwi‡kva Ki‡Z n‡e| H3 †m‡j ‡mj c‡q›Uvi ivLybUvBc Kiyb =SUM(F3+G3)  Enter Kx Pvcyb  Fill Handle WªvwMs K‡i H3 ‡_‡K H7 ch©š— djvdj mÂvjb Ki“b| djvdj

(6) GKwU ‡iRvë kxU ˆZwi Kiv GKwU IqvK© kx‡U wb‡Pi WvUv ¸wj Gw›Uª Ki“b| cÖwZ wel‡q cÖvß b¤^i ‡K c‡q‡›U ‡Z i“cvš—i Ki‡Z n‡e| AZ:ci wRwcG †ei Ki‡Z n‡e Ges Zv †_‡K †MÖW wbY©q Ki‡Z n‡e|

b¤^i ‡K c‡q‡›U i“cvš—i Kivi wbqghw` †Kvb wel‡q 33 Gi Kg cvq, Zvn‡j c‡q›U n‡e 0, hw` 39 Gi Kg cvq, Zvn‡j c‡q›U n‡e 1, hw` 49 Gi Kg cvq, Zvn‡j c‡q›U n‡e 2| hw` 59 Gi Kg cvq, Zvn‡j c‡q›U n‡e 3| hw` 69 Gi Kg cvq, Zvn‡j c‡q›U n‡e 3.5| hw` MSIT, w·gvnbx evRvi ,†ij‡MU,KzwoMÖvg| c„ôv bs 9

79 Gi Kg cvq, Zvn‡j c‡q›U n‡e 4| hw` 80 Gi mgvb ev †ewk cvq, Zvn‡j c‡q›U n‡e 5| G4 †m‡j wK¬K Ki“bUvBc Ki“b =IF(C4<33,0,IF(C4<39,1,IF(C4<49,2,IF(C4<59,3, IF(C4<69,3.5,IF(C4<79,4,IF(C4>=80,5))))))) Enter Kx Pvcyb> Fill Handle WªvwMs K‡i G4 ‡_‡K G8 ch©š— djvdj mÂvjb Ki“b| G4†m‡j wK¬K Ki“b Ges myÎ wU‡K Copy K‡i H4, I4,J4 †m‡j Paste Ki“b| Fill Handle WªvwMs K‡i wb‡Pi ‡mj ¸wj‡Z djvdj mÂvjb Ki“b| GPA †ei Kivi wbqgK4†m‡j wK¬K Ki“bUvBc Ki“b =AVERAGE (G4:J4) Enter Kx Pvcyb Fill Handle WªvwMs K‡i K4 ‡_‡K K8 ch©š— djvdj mÂvjb Ki“b| Grade †ei Kivi wbqghw` wRwcG 1 Gi Kg nq, Zvn‡j F ‡MÖW cv‡e, hw` wRwcG 2 Gi bx‡P nq Zvn‡j D ‡MÖW cv‡e, hw` wRwcG 3 Gi bx‡P nq Zvn‡j C ‡MÖW cv‡e, hw` wRwcG 3.5 Gi bx‡P nq Zvn‡j B ‡MÖW cv‡e, hw` wRwcG 4 Gi bx‡P nq Zvn‡j A- ‡MÖW cv‡e, hw` wRwcG 5 Gi bx‡P nq Zvn‡j A ‡MÖW cv‡e, hw` wRwcG 5 Gi mgvb nq Zvn‡j, A+ ‡MÖW cv‡e| L4 †m‡j wK¬K Ki“b UvBc Ki“b=IF(K4<1,"F",IF(K4<2,"D", IF(K4<3,"C", IF(K4<3.5,"B",IF(K4<4,"A-",IF(K4<5,"A",IF(K4=5,"A+")))))))  Fill Handle WªvwMs K‡i L4 ‡_‡K L8 ch©š— djvdj mÂvjb Ki“b| djvdj: Result sheet Roll

Name

1 2 3 4 5

Shishr Tajul Mohosin Shaju Titas

Bangla 50 60 36 90 82

Mark Eng Math 65 76 68 69 79 97 82 95 40 57

Hist 35 86 43 83 54

Bangla 3 3.5 1 5 5

Point Eng Math 3.5 4 3.5 4 5 5 5 5 2 3

MSIT, w·gvnbx evRvi ,†ij‡MU,KzwoMÖvg| c„ôv bs 10

Hist 1 5 2 5 3

GPA

Grade

2.875 4 3.25 5 3.25

C A B A+ B