What is Excel, Worksheet, Workbook?

What is excel?

Excel k‡ãi A_© †kªôZ¡| Bnv GKwU  Spreadsheet Analysis RvZxq mdUIq¨vi |mdUIq¨viwU gvB‡µvmdU Gioffice package †cÖvMÖvg | gvB‡µvmdU G‡·j GKwU †¯úWkxU  DB‡ÛvR wnmve,MÖvwdK&ª Uzjm,wcfU †Uwej Ges GKwU g¨v‡K&ªv‡cÖvMÖvwgs cÖ‡qvM mgy‡ni Rb¨ wfRy¨qvj †ewmK bvgK fvlv AwZwi³ ˆewkó¨¸wj I i‡q‡Q|

g~jZtG·‡ji mvnv‡h¨ WvUv Gw›Uª Ges A¨vbvjvBwmm Dfq myweav cvIqv hvq|

What is Worksheet?

Iqv©K A_© KvR Ges kxU A_© cvZv| Iqv©K kxU nj Kv‡Ri wbwg‡Ë cvZv| gvB‡K&ªvmd&U Iqv‡W©i dvB‡j _v‡K GK ev GKvwaK †cR| Avi G‡·‡ji Iqv©K eyK G _v‡K GK ev GKvwaK Iqv©KkxU| G‡·‡j ‡h †Kvb KvR Kivi GKgvÎ ¯’vb n‡jv Iqv©KkxU| mvwi (‡iv) I Kjvg m¤^wjZ Kv‡Ri RvqMv‡K e‡j G·‡ji  Iqv©KkxU| G·‡ji  Iqv©K ey‡Ki  GK ev GKvwU Ask ev cvZv†K e‡j Iqv©KkxU.GKwU LvZvq †hgb A‡bK¸wj cvZvq †jLv hvq, Gi·ª‡jI †Zgwb wfbœ webœ IqvK©kxU Ly‡j Zv‡Z KvR Kiv hvq|

What is Workbook?

GK ev GKvwaK Iqv©K kxU m¯^wjZ gvB‡K&ªvmdU G‡·‡ji GK GKwU dvBj‡K e‡j Iqv©K eyK| Iqv©K ey‡K cÖ‡qvRbxq KvR K‡i Zv msiÿ‡Yi Rb¨ †mf KgvÛ cÖ‡qvM Ki‡j  Save as   WvqvjM e‡·i NameAck‡bi †UK÷ e‡· GKwU bvg Gw›U K‡i †mf evU‡b wK¬K Ki‡j Pjgvb Iqv©KkxU¸wj GKwU Iqv©K ey†K cwibZ nq| GKwU  Iqv©K ey‡K  GK ev GKvwaK Iqv©KkxU m¤^wjZ n‡Z cv‡i| ‡Kvb IqvK©kxU I‡cb Kivi Rb¨ Av‡M I‡cb Ki‡Z nq mswkø÷ Iqv©K ey‡K| ms‡ÿ‡c avibv G ‡h, gvB‡K&ªvmcd&U Iqv‡W© hv‡K WzKz‡g›U ejv nq  gvB‡K&ªvmcd&U G·‡j Zv‡K e‡j  Iqv©K eyK|

Spreadsheet  : SpreadGi A_© n‡jv Qov‡bv  sheet Gi A_© n‡jv cvZv| Spreadsheet Gi A_© `vovq Qov‡bv cvZv| MÖvd KvM‡Ri b¨vq Aÿ Aÿ eivei †Lvc †Lvc N‡ii b¨vq A‡bK Ni m¤^wjZ kxU‡K  †¯úªWkxU ejv nq|

Microsoft Excel Run

v   cÖ_g t Iqvj m‡K‡Ui myBP Ab Kiæb

v   wØZxq t hw` ÷¨vwejvBRvi _v‡K Zvn‡j ÷¨vwejvBRv‡ii myBP Ab Kiæb Ges Gi meyR jvBwU R¡‡j DVv ch©šÍ A‡cÿv Kiæb|

v   hw` BDwcGm _v‡K Zvn‡j meyR evwZwU R¡‡j DVvi ci BDwcGm Gi myBP Ab Kiæb|

me‡k‡l wm‡÷‡gi Gi cvIqvi evU‡b cwigvb g‡Zv Pvc w`‡q mv‡_ mv‡_ †Q‡o w`b I cvIqvi evU‡b Pvc w`bGes wKQzÿb A‡cÿv Kiæb| Gici Kw¤úDUvi GKv GKv Pvj~ n‡e Ges GKwU wbw`ó c`©vq G‡m †_‡g hv‡e| GLvb †_‡KB Avcbv‡K KvR ïiæ Ki‡Z n‡e|

Click Start buttonàClick Prorograms /All Prorogramsà Microsoft OfficeàClick Microsoft Excel

wKQzÿ†bi g‡a¨B Microsoft Excel Gi QK KvUv GKwU dvuKv ¯Œxb Avm‡e| GLv‡b †Uwe‡ji gZ wewfbœNi (Column), Kjvg  Ges mvwi (Row) ‡Z wewf³  _vK‡e|

Microsoft Excel G hLb Ready Mode  _vK‡e ZLb Excel  G Kv‡Ri Dc‡hvwM n‡e l

Cloumn: Worksheet Gi Dc‡i Avgiv   A.B.C  BZ¨vw` †jLv †`L‡Z cvB| GB cªwZwU A.B.C  -B nj GK GKwU  Excel †cÖvMÖv‡g Cloumn  Gi msL¨v n‡jv 2003 f©vm‡b 256wU 2007 f©vm‡b 16,384 wU| Last Column= XFD

Row:  Gi  evg cv‡k¦© 1.2.3 BZ¨vw` †jLv †`L‡Z cvB| GB ¸‡jv cÖwZwU GK GKwU Row  wn‡m‡e Mb¨ nq| Excel  †cÖvMÖv‡g †gvU Row Gi msL¨v nj 2003 f©vm‡b 65,536 wU  2007 f©vm‡b 10,48,576 wU| Last Row=1048576

Cell: GKwU Kjvg Ges GKwU  wg‡j  Cell MwVZ 1,67,77,216 wU 2007 f©vm‡b 1717,98,69,184 wU|

 UvB‡Uj evi: Microsoft Excel c¨v‡KR †cÖvMÖvgRun Kivi ci Screen  Dc‡ii cÖ_g jvBbwU nj UvB‡Ujevi|

Z„ZxqZ: Wvbc¦v‡k©i †QvU †QvU AvBKb My‡jvi Øviv Window †K Miximize,Minimize Close BZ¨vw` KvR Kiv hvq|

TitleBar DB‡Ûvi kxl©‡`k‡K e‡j UvB‡Uj evi| Pjgvb DB‡Ûv‡Z  ev‡ii gvSvgvwS Pjgvb †cÖvMÖvg Ges D³ †cªvMÖv‡g Pjgvb IqvK©eyK  dvBjwUi bvg  Zv cÖ`wk©Z nq UvB‡Uj ev‡i| GB ev‡ii evg cÖv‡šÍ Quick Access toolbar Ges Wvb cÖv‡šÍ Excel Window  Controls Gi Ae¯’vb

 KvR: UvB‡Uj ev‡ii mvnv‡h¨ Avgiv AeMZ n‡Z cvwi †h, c`©vq †Kvb †cÖvMÖvgwU Pvjy Av‡Q|

w`¦ZxqZ: †Kvb dvBj wb‡q KvR Ki‡j †mB dvB‡ji bvg|

K‡›Uªvj e·t DB‡Ûvi UvB‡Uj ev‡ii me©ev‡g we`¨gvb e·†K K‡›Uªvj e· e‡j|†hgbt- Restor,Move,Size,Miximize,Minimize,Close .

Tab  Bart DB‡Ûvi UvB‡Uj ev‡ii bx‡P we`¨gvb Home,Insert, Page Layout,Refarance, Mailing,Review BZ¨vw` †jLv mw¤^wjZ evi‡K e‡j Tab  Bar. Tab  Bar    cÖ‡Z¨KwU AckbB GK GKUv †gbyi gZ KvR K‡i| GB  †gby evi ¸‡jvi bx‡P AvÛvijvBb Kiv Aÿi My‡jv w`‡q Kx‡evW© KgvÛ K‡i  H †gby GKwUf Kiv hvq | ‡hgb: Alt+F KgvÛ  w`‡j dvBj †gby I‡cb n‡e|

Tool Bart Gi bx‡P wewfbœ cÖZxK m¤^wjZ evi‡K Uzjevi e‡j| cÖ‡Z¨KwU cÖZx‡Ki evU©b‡K AvBKb ev Uzj evU©b e‡j| GB Uzjevi e¨envi K‡i Lye `ªæZ KvR Kiv hvq|

Strat/Taskbar: Desktop Avvm‡e Ges GKwU j¤^v wdZvi gZ e¨vÛmn  wb‡P  evgw`‡K GKwU Strat evUb _vK‡e|G‡K e‡j Taskbar Ges GwU me mgq cÖ`wk©Z n‡Z _v‡K|GB Taskbar†_‡K wKQy AvBKb _vK‡e| GB AvBKb †_‡K I mswkó †cÖvMÖvg Pvjv‡bv hv‡e|

  Status Bar :IqvK©eyK DB‡Ûvi me©wb‡¤œ Uv¯‹ev‡ii Dc‡ii evi‡K †÷Uvm evi e‡j| G‡Z Wz‡Kv‡g›U Gi †÷Uvm ev Ae¯’v( Ab/Ad) cÖ`wk©Z nq|GB †÷Uv‡mi ev‡ii evg cv‡kReady †jLv _vK‡j eyS‡Z n‡e Kvm©i †m‡jAv‡Q Ges G Ae¯’vX KvR Kiv hv‡e| †Kvb †jLv Edit Kivi mgq GLv‡b GB GwWU †jLv †`Lv hv‡e Ges †kl n‡j Avevi †iwW gyW wd‡i Avm‡e|

 Workspace/Workarea  Worksheet  Gi  A†_‡K U ch©šÍ 21(GKzkwU) Kjvg Ges  1 †_‡K 25 ch©šÍ  Row me©mgq c`©vq  weivRgvb Z‡e gwbU‡ii AvqZ‡f‡` Gi msL¨v Kg-‡ekx n‡Z cv‡i | GB `©k¨gvb  Total Column  TotalRow m¤^wjZ RvqMv‡K e‡j Workspace .FormulaBar Ges Status BarcÖ`k©‡bi Dci `„k¨gvb Row msL¨v wbf©i K‡i|

FormulaBar : Worksheet  Gi Cloumn ev‡ii Dc‡i Geq Uyjev‡ii wb‡P eviwU‡K FormulaBar e‡j| dgy©jvev‡ii evg cv‡ki As‡k †hLv‡b Cell Adderss (A1)cÖ`©wkZ nq †m Ask‡K NameBoe‡j|A_©¨v_© †mj c‡q›Uvi †h †m‡j ivLv n‡e NameBox †mB †m‡ji G‡Wªm cÖ`wk©Z n‡e| Gi Wv‡b we`¨gvb evi‡K FormulaBar e‡j|†m‡j  †Kvb †U·U ev dg©~jv wjL‡j D³ †mj GKwUf¨¨vjywU GB FormulaBar  G cÖ`wk©Z nq|Avevi IqvK©kx‡U †Kvb †mj wm‡j±W Ae¯’vq  GB FormulaBar  G †U·U ev dgy©jv wjL‡j Zv D³ †m‡j Kvh©Ki nq|

Formula  e¨env‡ii †ÿ‡Î Kibxqt †jLvi cÖ_‡g mgvb (=) wPý e¨envi Ki‡Z n‡e|

If , And  Gi c‡i (First Bracket) w`‡Z n‡e|

 And n‡j `ywU kZ©‡K  First Bracket () w`‡q Close Ki‡Z n‡e

Formula Gi g‡a¨ hZ¸‡jv If _vK‡e ZZ¸‡jv Formula Gi †k‡l First Bracket () w`‡q Close Ki‡Z n‡e|

 hyw³‡K Kgv (,) w`‡q wef³ Ki‡Z n‡e|

Formula Gi †jLvi †QvU-eo Aÿ‡ii †f`v‡f` bvB|  

= Funtion

Functin Name: Functin wK KvR K‡i Zv wba©viY K‡i|

Arguments: †Kvb †Kvb †mj ev gvb  †idv‡iÝ e¨envi K‡i wn‡me Ki‡Z n‡e Zv wba©viY K‡i|

Functin e¨env‡ii Logical Symbol   

+ †hvM mgvb wPý   

- we‡qvM wPý   

/ fvM wPý 

* ¸bb wPý 

Õ Kgv wPý

Equal to          = mgvb wPý

Grater than  >†ekx ev D‡a©Ÿ 

Less than     < Kg ev wb‡¤œ

Grater than  or Equal to>= mgvb ev Zvi ‡P‡q †ekx 

Less than  or Equal to <= mgvb ev Zvi †P‡q Kg

‡¯Œvj evit Pjgvb DB‡Ûv‡Z we`¨vgvb Af¨šÍixb welqvw`i  Dc‡i,bx‡P, ev‡g,Wv‡b †`Lvi Rb¨ †¯Œvj evi e¨envi Ki‡Z nq| ‡¯Œvj evi 2wU †hgb-

Virtical scroll Bar t       wP‡ý wK¬K Ki‡j WKz‡g›U Gi †cR  Dc‡i  DV‡Z _v‡K Avi     wP‡ý wK¬K Ki‡j WKz‡g›U Gi †cR bx‡P bv‡g|

  Horizontal scroll Bar t à Gi wb¤œvs‡ki w`‡K ZvKv‡j Ges ß wPý GKevi wK¬K Ki‡j WKz‡g›U Gi †cR evg ‡_‡K Wv‡b cÖ`©kxZ nq|   

Cursor Movement

Key Action	Activity
Press Left Arrow	Move Cell Pointer One Cell Left Side
Press Right Arrow	Move Cell Pointer One Cell Right Side
Press Up Arrow	Move Cell Pointer One Cell Up
PressDown Arrow	Move Cell Pointer One Cell Doewn
PressPageup	Move Cell Pointer One Page Up or One Screen Up
PressPagedown	Move Cell Pointer One Page Down or One Screen Down
Press Ctrl+Home  Key	Move Cell Pointer at the  Top of the document
End,Down Arrow	Move Cell Pointer at the  End of the Row
Press Ctrl+End Key	Move Cell Pointer at the  Bottom of the document
Press Home	Move Cell Pointer One Cell Left
Press Shiftl+Tab Key	Move Cell Pointer One Cell Left
Tab	Move Cell Pointer One Cell  to the Right .

Kw¤úDUvi eÜ Kivi c×wZ

cÖ_‡g Pjgvb †cÖvMÖvg eÜ Kivi Rb¨ Worksheet  ‡_‡K  Close Zvici Workbook †_‡K Exit n‡q   

 †W·Uc G‡m wb‡¤œi KgvÛ w`‡Z n‡e| K‡›Uªvj e· Miximize,Minimize,Close †_‡K X w`‡q †ei   

nIqv hvq|

v Kw¤úDUvi Pvjy Kivi ci †h ¯Œx‡b A_v©r †W·Uc G‡m †_‡g hvq, †m ¯Œx‡bi wb‡P GKev‡i ev‡gi ÿ wPü‡jLv hv‡e| Kw¤úDUvi e× Kivmn hveZxq KvR GLvb †_‡K m¤úbœ Kiv hvq|

v gvDm w`‡q ÿ wPü Dci wK¬K Kiæb| wK¬K Ki‡j wb‡Pi wPGwU Avm‡e GLvb n‡Z Wvb cv‡k©¦i Shut down wK¬K|

=