Wednesday 29 February 2012

M.s word - Exacel --- 2003

     M.s word - 2003
1. How  to Open a New  Blank Document -  ,d ubZ QkbZy dSls [kksysaA
      File menu esa Click djsxsa New ij Click djsxsa] tSls gh New ij Click djsxsa rks New Window Open gksxh ;gka ge New Blank Document  ij  Click djsxsa vkSj vUr esa OK ij Click dj nsaxsa    File ® New ®  Blank Document ® OK
2. How To Save a File -   QkbZy dks lqjf{kr dSls djsaA
     File  Menu ij Click dj ds Save ij Click djsxsa tSls gh Save ij Click djsxsa rks Save As Window Open gksxh ;gka ge Save in Box esa File dh Location Select djsxsa  blds ckn New Folder Icon ij Click dj Folder cuk;sxsa  Folder dks Open djsxsa] rFkk File Name Box esa File Name Type djsxsa  vUr esa Save ij Click dj nsxsaA
uksV % QkbZy lso djrs le; ckj ckj QksYMj cukus dh vko’;drk ugha gksrh gS iqu% lso djrs le; igys ls cus QksYMj dks Open djds lh/kk gh QkbZy dk uke VkbZi djds lso djuk pkfg,A
       File ®  Save® Select Location in Save in Box  ® Create Folder  Open the Folder  ® Type File Name in File Name Box  ®  Save
3. How to Open a Old Filelcls igys ge lEcfU/kr izksxzke dks ju djok;sxsa] blds ckn ge File Menu ij Click djsxsa] Open ij Click djsxsa] tSls gh ge Open ij Click djsxsa rks gekjs lkeus Open Window Open gksxhA ;gka gesa Look in Box esa File dh Location Select djuh gksxh rFkk File Name Box esa File Name Type djuk gksxk vkSj vUr esa Open ij Click dj nsxsa rks gekjh File Open gks tk;sxhA
uksV % ;fn File, Folder esa gS rks gesa Folder Hkh Open djuk gksxk A
File ®  Open ®  Select Location in Look In Box    ®     Open the  Folder  ®  Type File Name in File Name Box  ®   Open
4. Save As  - bl Option ds }kjk ge igys ls Save dh gqbZ QkbZy dh Duplicate Copy nwljs uke ls mlh  Location ij ;k mlh uke ls nwljh Location izkIr gksrh gS bl vkWI'ku dks iz;ksx esa ysus ds fy, Save dh tSls gh dk;Z djuk gksxkA
    File ®  Save As   ® Select Location in Save in Box  ®  Create Folder
        Open the Folder  ®  Type File Name in File Name Box   ®   Save
5. Close -  bl vkWI'ku ds }kjk fdlh Hkh Open File dks Close fd;k tk ldrk gSA
6. Print PreviewPrint Out fudkyus ls igys gesa Print Preview ns[kuk pkfg, D;ksssafd blls gesa ;g irk pyrk gS fd gekjh QkbZy dk Text Printing Aria ls Out gS ;k In ] vxj In gS rks  ge Print Preview dks ESC key ;k Toolbar ds Close Option ls Close djds Print fudkysaxsa vkSj ;fn Out gS rks Text dks Set djds fQj Print fudkysxsa
  File      Print Preview Close / ESC key
7. Page Setup djukbl Option ds }kjk ge Paper dk Margin, Paper dh Size o Paper dk Orientation Set dj ldrs gSa blds fy, ge File Menu ij Click djasxs ] Page Setup ij Click djsaxs tSls gh ge Page Setup ij Click djsxsa rks gekjs lkeus Page Setup Window Open gksxhA ;gka ge Margin ij Click djds] Paper dk Top,  Bottom,  Left & Right  Side dk Margin Up & Down Arrows ds }kjk Set djsxsaA blds ckn ge Paper Size ij Click djuk gksxk vkSj ;gkWa ge Paper Size Box esa Paper dh Size tSls Legal , A4 ,A3 vkfn Set djsxsaA  o Orientation Box esa Paper dk Orientation  tSls & Portrait ¼[kM+k½] Landscape ¼vkMk½ Set djsxsa vkSj vUr esa OK ij Click dj nsxsa A
    File ®  Page Setup  ® Margin  ® Set Margin  ® Paper  Size  ® Set  
    paper       ®   Size     ®   OK
8. Print Out  fudkyuk &  bl vkWI'ku ds }kjk ge File dk Print fudky ldrs gSaA
 File menu  ij Click djsa ] Print ij Click djsa ]   tSls gh ge Print ij Click djsxsa rks gekjs lkeus Print Window Open gksxh   ;gka ge Page Range Box esa Page dh Range Set djsxsa fd gesa dkSuls Paper dk Print Out pkfg, A  Page Range pkj izdkj dh gks ldrh gSa &
1- All & ;fn gesa iwjh File dk Print Out pkfg, rks All ij Click djsxsaA
2- Current Page & ;fn gesa Current Page ¼ftl Page esa Cursor gks½ dk Print Out pkfg, rks Current Page ij Click djsxsaA
3. Pages & ;fn gesa fdlh fuf’pr Page No. ls fdlh fuf’pr Page No.rd dk Print Out pkfg, rks ge Pages ij Click djds mlds lkeus cus Box esa Page No. Type djsxsaA
4. Selection -& ;fn gesa fdlh File ds Selected Text dk Print Out pkfg, rks ge Selection ij Click djsxsaA UkksV %& ;g Option Text Select gksxk rks gh Activate gksxkA
blds ckn ge Number of Copies Box esa  Number of Copy Set djsxsa A
uksV & ;fn gesa Print Out Set wise pkfg, rks ge Collate On j[ksxsa vU;Fkk Off j[ksxsa A
blds ckn ge Printer dh Property Check djssaxsa tSls gh ge Property ij Click djsxsa rks gekjs lkeus Property Box Open gksxk ;gka ge Paper ij Click djsxsaA 
;gka gesa Document Size Box esa Document dh Paper size tks geus Page Setup ds nksSjku dh gS Set djsxsa rFkk Print Size box esa Printer paper Size Set djsxsaA
uksV & nksuksa Boxes esa paper dh Size Match gksuh pkfg, vxj Paper Size Match ugha gksxh rks Printing ds nkSjku Paper Miss feed gksxkA blds ckn Paper Source Box esa Paper dk Source tSls  Tray-1, Tray-2,  Auto Tray,  By pass vkfn Select djuh gksxh vkSj vUr esa OK ij Click dj nsxsaA
File ® Print  ®   Set  Page Range   ®  Set Number of  Copies     Collate On / Off  ®  Property  ®  Match Document & Print Size   Select Tray     ®  OK ®   OK

Edit Menu  ds Options
uksV %& Do, Undo, Redo rhuksa Option ,d nwljs ds iwjd gksrs gSa] D;ksfd Do djus ds ckn Undo ,  Undo djus ds ckn Redo dj ldrs gSaA
3-Cut – bl Option ds }kjk Selected Text dks ewy LFkku ls gVk;k tk ldrk gS rFkk vko’;drkuqlkj Paste fd;k tk ldrk gSA
Select The Text  ®   Edit  ®  Cut®  Paste djukA
4-Copy – bl Option ds }kjk ge Selected Text dh Copy dj ldrs gS vkSj vU; LFkku ij Paste fd;k tk ldrk gSA
Select The Text  ®  Edit  ® Copy ®  Paste djukA
uksV %& Cut o Copy fd;s x;s Text dks ckj ckj tgka Cursor gks] Paste fd;k tk ldrk gSA Cut o Copy ds fy, Text dks Select djuk vko’;d gksrk gSA
5- Paste – bl Option ds }kjk Cut o Copy fd;s x;s Text dks Paste fd;k tk ldrk gSA
6- Select All – bl Option ds }kjk iwjh File dks ,d lkFk Select fd;k tk ldrk gSA 'kksVZdV rjhdk & ctrl+A
7- Find / Replace / Go To Find Option ds }kjk ge fdlh Hkh File esa fdlh Word, Line , Character dks Find dj ldrs gSa rFkk Replace Option ds }kjk Replace dj ldrs gSA rFkk Go to Option ds }kjk ge fdlh Hkh File esa fdlh Hkh fuf’pr Page No.,  Line vkfn ij tk ldrs gSA blds fy, gesa buds lkeus cus Box esa Page no., line No. Type djus gksxsaA
8.Find/ Replace djuk & lcls igys Edit Menu ij Click djssa ] Find/ Replace ij Click djsaA tSls gh ge Find/ Replace ij Click djsaxsa rks gekjs lkeus Find & Replace Window Open gksxhA ;gka gesa Find What Box esa tks v{kj] ’kCn Find djuk gS Type djsxsa rFkk Replace With Box esa ftlds lkFk Replace djuk gks Text dks Type djsaxsa   vkSj ;fn One By One Replace djuk gks rks Replace ij Click djsxsa vkSj ;fn iwjh File esa ,d lkFk Replace djus gksa rks  Replace All ij Click djsxsaA
    Edit ® Find/Replace   ® Type Finding Text in Find What Box  ®                  
   Type Replacing Text in Replace With Box    ®  Replace  / Replace 
    All                   

View Menu ds Options
1- Normal View – bl View esa Page dk End utj ugha vkrk gS rFkk bl dh igpku ds fy, Cursor ds lkFk lkFk ,d NksVh Underline jgrh gSA
2- Print / Page Layout – bl View esa Page dk Original Layout fn[kkbZ nsrk gS gesa fdlh Hkh File esa Work djrs le; Layout Page/Print layout j[kuk pkfg,A
  uksV & tc dHkh Printing ds nkSjku dksbZ Table ;k Text Print Preview esa dV jgk    gks  rks ge Page dk Layout Normal djds mls Control djsxsaA
3- Toolbars – bl Option ds }kjk ge Toolbars dks On/ Off dj ldrs gSaA
4- Ruler – bl Option ds }kjk Ruler Bar  dks On / Off dj ldrs gSA
5- Header & Footer – bl Option ds }kjk ge fdlh Hkh File esa File ds Top esa Header o File ds Bottom esa Footer  Insert dj ldrs gSaA
6. Header & Footer Insert djuk – View Menu ij Click djsxsa]  Header & Footer ij Click djsxsaA tSls gh Header & Footer ij Click djsxsa rks File ds Top esa Header ds uke o Bottom esa  Footer uke dk Box Open gksxk vkSj lkFk gh Header & Footer dh Tool Bar By Default On gks tk;sxh bldh igpku ds fy, blesa Left Side esa Insert Auto Text fy[kk feysxkA
;gka ge viuh bPNkuqlkj Text Type dj ldrs gSa] rFkk ToolBar ds Insert Auto Text Icon }kjk Auto Text tSls& Page,  Page No. &Date, Created On , Created by, File Name ,File Name & Path vkfn Insert dj ldrs gSaA
UkksV & gesa lnSo Footer esa File Name o Path Insert djuk pkfg, D;ksfd blls File ij mldk iwjk Path o uke Type gksrk gS vkSj bl Path ls File dks Open djus esa vklkuh jgrh gSA
uksV%&tgka gekjk Cursor gksxk ogha gekjk Text Type/Insert  gksxkA
View ® Header & footer   ®  Locater Cursor Header/Footer    Type/ Insert     ® File Name & Path
Insert Menu ds Option
1- Break – bl Option ds }kjk ge fdlh Hkh File esa Page Break o Colum Break Insert dj ldrs gSaA ;fn gesa Page Break djuk gS rks Page Break ij o Colum Break djuk gS rks Colum Break ij Click dj nsxsaA
uksV& tgka gekjk Cursor gksxk ogha ls gekjk Colum , Page Break gksxkA
2- Page Number- bl Option ds }kjk ge fdlh Hkh File esa Page Number Insert dj ldrs gSA
Page Number Insert djuk & Insert ij Click djsxsa]  Page Number ij Click djsxsaA tSls gh ge Page Number ij Click djsxsa rks gekjs lkeus Page Number Window Open gksxh ;gka ge Position Box esa Page Number dh Position tSls& Top, Bottom vkfn Set djsxsa rFkk Alignment Box esa Number dk Alignment tSls &Left, Right,Center vkfn Set djsxsa  vkSj vUr esa Ok ij Click djsxsaA
Insert  ® Page Number ® Select Position in Position Box ®  Select Alignment ® OK
3- Date & Time – bl Option ds }kjk ge fofHkUu Formats esa ls Format Select djds Date & Time Insert dj ldrs gSaA
uksV %& tgka gekjk Cursor gksxk ogha Date & Time Insert gksxsa A
Locate Cursor  ® Insert  ® Date & Time  ®  Select Format ® Inser     
4- Symbolbl Option ds }kjk ge fo’ks"k Symbol o fo’ks"k Character Insert  dj ldrs
Locate Cursor   ®  Insert   ® Symbol  ®  Select Symbol  ®   Insert
5- Text Boxbl Option ds }kjk ge Text Box Insert dj ldrs gSa ¼ftl txg fy[kuk lEHko ugh gks ogka fy[kus ds fy, ge Text Box dk iz;ksx djrs gSaA½A
6. Text Box cukuk – Insert ij Click djsa] Text Box ij Click djsaA tSls gh ge Text Box ij Click djsxsa rks gekjk Mouse Pointer Plus ds fu’kku esa Convert gks tk;sxkA vc ge ftl LFkku ij Text Box cukuk pkgrs gSa ml LFkku ij Pointer ys tk;sa] Left Button dks Press djds j[ksa vkSj Drag dj viuh bPNkuqlkj Text Box cuk;ssaxsaA
Insert®Text Box®  locate Position ® Press Left Button  ®  Drag
7- Picture – bl Option ds }kjk ge fdlh Hkh File esa Picture, Chart,Word Art   
   Style Insert  dj  ldrs gSaA
ü Picture Insert djuk- Picture ge nks izdkj ls Insert dj ldrs gSa
1- Clip Art – bl Option ds }kjk ge Computer dh Clip Art Gallery ls   Selected Picture Insert dj ldrs gSaA
Locate Cursor® Insert ®Picture ® ClipArt ®  Select Picture ®   Insert
   2- From File- bl Option ds }kjk ge User ds }kjk cuk;h xbZ ;k Ldsuj] Web cam vkfn Devices ds }kjk File ds :i esa Save dh x;h Picture Insert dj ldrs gSA blds fy;s gesa ClipArt ds LFkku ij From File ij Click djds] Browse djds ml File dh Location Select djds Insert ij Click dj nsxsaA
  Locate Cursor ®  Insert  ®   Picture ®  From File  ®  Select file   ®      Insert
ü Chart  Insert djuk& bl Option ds }kjk ge fdlh Hkh File esa fn;s x;s vkadM+ksa dk Selected type dk Chart cuk ldrs gSa] rFkk viuh bPNk ds vuqlkj Formatting dj ldrs gSaA Insert ij Click djsa]  Picture ij Click djsa] Chart ij Click djsa]  tSls gh ge Chart ij Click djsxsa rks gekjs lkeus Chart dh Data Sheet Open gksxhA  ;gka ge vius vkadMksa dks Type djsxsa vkSj vUr esa Data Sheet dks Close dj nsxsa rFkk viuh bPNk ds vuqlkj Chart dks Select djds Size dks NksVk o cMk fd;k tk ldrk gS
    Insert   ®   Picture ®   Chart   ®    Type Data in Data Sheet  ®  Close Data Sheet

Format Menu ds options

ü Font – bl Option ds }kjk ge Font dk Type tSls&fgUnh ds fy, Devleyas 010, Kuruti vkfn rFkk vaxszth ds fy, Times New Roman, Arial, Arial Black vkfn ] Font dk Style tSls& Bold , Italic, Bold  Italic, Regular vkfn] Font dk Color, Font dh Under Line vkfn Set dj ldrs gSaA

ü Font dh Formatting djuk & ;fn Font igys ls Type gS rks lcls igys ge Text dks Select djsxsa] Format ij Click djsxsa] Font ij Click djsxsa A tSls gh Font ij Click djsxsa rks gekjs lkeus Font Window Open gksxhA ;gka gesa Font Type Box esa Font dk Type , FontStyle Box esa Font dk style, Font Size Box esa Font dk Size, Font Color rFkk Un der line Box esa Under line dh Style  Select djsxsaA

uksV & ge tks Hkh Formatting djsxsa mldk Preview ge Preview Box esa ns[k ldrs gSaA vUr esa ge OK ij Click dj nsxsa rks gekjs }kjk dh x;h Formatting Text ij Apply gks tkosxhA

ü Bullets & Numbering – bl Option ds }kjk ge fdlh Hkh File esa Bullets  o Number Insert dj ldrs gSaA  ge bl Option esa Bullets & Number dh Formatting Hkh dj ldrs gSa tSls & Number dgka ls Start gksxsa] Number dk Font dSlk gksxk] Number dk Style o Position dSlh gksxh vkfnA

ü Bullets & Number Insert djuk & ;fn Text igys ls Text gS rks lcls igys Text dks Select djsaA Format ij Click djsa] Bullets & Number ij Click djsa ] tSls gh ge Number & Bullets ij Click djssxsa rks gekjs lkeus Bullets & Number Window Open gksxhA ;gka gesa Number Insert djusa gSa rks Numbered ij o Bullet Insert djus gSa rks Bullet ij Click djsxsa vkSj viuh bPNkuqlkj Number o Bullet dk Type Select djsxsa o vUr esa OK ij Click dj nsxsaA

Format ®  Bullets &Number ® Select Bullet &Number Type ®    OK

ü  Border & Shading – bl Option ds }kjk ge fdlh Hkh File esa Page, Line , Paragraph vkfn ds lkFk fofHkUu izdkj ds Border Insert dj ldrs gSA

ü  Border Insert djuk & Format ij Click djsxsa ] Border & Shading  ij Click djsxsa ]tSls gh ge Border & Shading ij Click djsxsa rks gekjs lkeus Border & Shading Window Open gksxhA ;fn gesa fdlh Line , Paragraph ij Border Apply djuk gS rks Border ij Click djsxsa o iwjs Page ij Border Apply djuk gS rks Page Border ij Click djuk gksxk blds ckn ge Border dh Setting, Style Box esa Border dh Style Color vkfn  Set djsxsa vkSj vUr esa OK ij Click dj nsxsa A

Format  ®  Border & Shading  ®  Border / Page Border  ®  Select Style ®  Ok

ü  Columns – bl Option ds }kjk ge fdlh Hkh File esa Prest o viuh bPNk ds vuqlkj Columns Insert dj ldrs gSA

ü  Columns Insert djuk& Format ij Click djssa ] Columns ij Click djsa ] tSls gh ge Columns ij Click djsxsa rks gekjs lkeus Columns Window Open gksxhA ;gka ge Presets Box esa Preset Columns dks Select djsa ;k Number of  Columns Box esa Number Of Columns dks Set djsxsa vkSj vUr esa OK ij Click dj nsxsaA

uksV Preview Box ge gekjs }kjk Set fd;s x;s Columns dk Preview ns[k ldrs gSA

    Format   ®  Columns  ®   Select Column No.  ®      OK



Tools Menu ds Option

1-Spelling & Grammar  - bl Option ds }kjk ge Type fd;s x;s Text dks Select djds  Spelling o Grammatical Errors dks Bhd dj ldrs gSa

UkksV & Red Line Spelling Error o Green Line Grammatical Error dks Show djrh gS A ;fn ge Text ij Right Click djds Ignore All dj nsrs gS rks fdlh Hkh izdkj dh Error Show ugha gksxhA

2- Auto Correct – bl Option ds }kjk ge fdlh Hkh v{kj ;k 'kCn dks  Auto Correct dj ldrs gSa vFkkZr fdlh 'kCn v{kj dks Auto Correct dj ysrs gS rks ml 'kCn ;k v{kj dk First Character Type djrs gh tSls gh Tab Key dks Press djsxsa rks  og vius vki gh iwjk fy[kk tk;sxkA

blds fy, gesa Tools Menu ds Auto Correct Option ij Click djsxsa rks gekjs lkeus bldh Window Open gksxh A ;gka gesa Replace Box esa og 'kCn ;k v{kj Type djsxsa tks Auto Correct djuk gS rFkk Width Box esa ml v{kj dk lgh :i Type djuk gksxk vkSj vUr esa Add ij Click dj nsxsa rFkk OK ij Click dj nsxsaA

3-Mail- Merge djuk-& Mail Merge  rhu pj.kks esa iwjk gksrk gS ;fn geus izFke pj.k lQyrkiwoZd fd;k gS rc gh f}rh; o r`rh; pj.k Activate gksxk A

lcls  igys gesa Blank Document esa viuk Letter Type djuk gksxkA blds ckn ge Tools Menu ij click djssa] Mail Merge ij Click djsa ] tSls gh ge Mail Merge ij Click djsxsa rks gekjs lkeus Mail Merge Helper Window Open gksxhA

1- izFke pj.k & ;g pj.k Main Document ds fy, gksrk gSSA

 Syntax –  Create      ®    From Letters      ®    Active Window  

Active  Window ij Click djsxsa rks gekjk izFke pj.k iwjk gks tk;sxk rFkk f}rh; pj.k Activate gks tk;sxkA               

2. f}rh; pj.k & ;g pj.k Data Source ds fy, gksrk gSSA

 UkksV &  Data Source nks izdkj ls Use ys ldrs gSa 1- Create Data Source & Male Merge djrs le; gh User viuk Data Source rS;kj djuk pkgs rks Create Data Source Use ysxsaA     2- Open Data Source & ;fn Data dh List gekjs ikl igys ls gSa rks ge Open Data Source Use ysxsaA

Syntax  -   Get Data           Create Data Source

tSls gh ge Creat Data Source ij Click djsxsa rks gekjs lkeus Creat Data Source Window Open gksxhA

;gka ge Remove Field Name Button ls igys ls cus LkHkh Field dks Select djrs gq;s Remove djsxsa rFkk Field Name Box esa fcuk fdlh Space ds vius bfPNr Field dk uke Type djxsa vksj Add Field Name Button ls Add djrs jgssxsaA tc Field iwjs gks tk;s rsk Ok ij click dj nsxsaA
Remove Field Name   ®      Add Field Name       ®      OK
UkksV & tSls gh ge OK ij Click djsxsa rks gekjs lkeus Save AS Window Open gksxh ] ;gka gesa fdlh Hkh uke ls Data Source dks Save djuk gksxkA
tSls gh Save ij Click djsaxsa rks gekjs lkeus ,d Window Open gksxh] ;gka gesa Edit Data Source ij Click djuk gksxkA tSls gh ge Edit Data Source ij Click  djsxsa rks gekjs lkeus Data Form Open gksxk ]
;gka gesa vius Fields dh Entry djuh gksxh rFkk gj Entry ds ckn Add New ij Click djuk gksxk rFkk ge Record Box esa ge viuh Total Entry ns[ks ldrs gSaA
tc Entry iw.kZ gks tkosa rc ge Ok ij Click dj nsxsaA
 Record Entry     ®     Add New      ®      Ok
tSls gh ge Ok Click djsxsa rks Data Form Close gks tk;sxk o Mail Merge dh Tool Bar  By default  On gks tk;sxhA bldh igpku ds fy, blesa Insert Merge Field  fy[kk gqvk feysxkA " ;gka ge Insert merge Field Button ds }kjk vius Merge Field Insert djsxsa fd os Letter esa dgka Locate gksxasaA
3- rhljk pj.k & ;g pj.k  Data dks Document ds lkFk Merge djus ds fy, gksrk gS
Tools ®  Mail Merge ®   Merge ®    Merge ®    OK
UkksV & ;fn Data igys ls Type gS rks gesa fuEu Syntax esa Mail Merge djuk gksxkA
1- Tools ®  Mail Merge ®  Create ®   From Letters ®  Active Window
2- Get Data ®  Open Data  ®  Select Data Location & Data File ®    Open ®   OK  ® Edit Main Document  
3- - Insert Merge Field   ® Tools    ®     Mail Merge    ®   Merge  ®   Merge   ®    OK

Table Menu ds Option
ü Table cukuk & Ms Word esa ge nks izdkj ls Table cuk ldrs gSa %&
 1- Draw Table Option ds }kjk &  lcls igys Table Click djsxsa] Draw Table ij Click djsa ] tSls gh Table ij Click djsxsa rks Table dh Tool Bar  open gks tkrh gS rFkk gekjk Mouse Pointer Iyl ds fu’kku esa cny tkrk gSA blds }kjk ge tgka Table cukuk pkgrs gSa igys ogka viuk Pointer ys tkosa  Left Button dks Press djds j[ksa o Drag dj Table dk Outer Frame cukosa vkSj ckn esa viuh bPNkuqlkj Row o Column cukrs jgasaA
   2- Insert Option ds }kjk & bl Option ds }kjk ge Number Of Columns o Number of Row Set djds Table cuk ldrs gSaSA
ü Table Insert djuk & Table  ij Click djsa ] Insert ij Click djsa ] Table ij Click djsa tSls gh ge Table ij Click djsxsa rks gekjs lkeus Insert Table Window Open gksxhA ;gka ge Number Of Columns Box esa Number of Columns o Number Of Rows Box esa Number Of Row Set djsxsa vkSj vUr esa OK ij Click dj nsxsaa rks gekjs }kjk fn;s x;s Columns o Row dh Table Insert gks tkosxh A
ü -Cell/Row/Column Insert djuk%&;fn gesa fdlh Vscy esa Cell/Row/Column Insert  djuk gS rks VsCky ehuw ij fDyd djsa] bUlVZ ij fDyd djsa] tSls gh ge bUlVZ ij fDyd djsaxs rsk gekjs lkeus bUlVZ dh fyLV vksiu gksxh ;gk¡ ge Øe'k% Table, Column to the left, Column to the Right, Row above, Row below, Cell Optionfeysaxsa A buesa ls ge viuh vko';drkuqlkj fDyd djds Cell/Row/Column Insert dj ldrs gaSA

uksV%& ;fn gesa Cell/Row/Column  ls lacaf/kr dksbZ Hkh dke djuk gS rks lcls igys mls lysDV djsa] jkbZV fDyd djsa ] tSls gh ge jkbZV fDyd djsaxs rks gekjs lkeus lysDVsM Cell/Row/Column  ds lkFk tks Hkh dke ge dj ldrs gSa mudh fyLV vksiu gksxh] lacaf/kr ij fDyd djds ge viuk dke dj ldrs gSaA
ü Cell/Row/Column Merge  djuk & ;fn ges fdlh Vscy esa Cell/Row/Column Merge  djuk gS rks lcls igys mls lysDV djsa ftUgsa etZ djuk gSA Table menu  ij fDyd djsa] Merge Cell  ij fDyd djsa] tSsls gh ge Merge Cell ij fDyd djsaxs rks gekjh lysDVsM Cell/Row/Column Merge gks tkosxhA

New
bl dekaM dh lgk;rk  ls ge ubZ QkbZy cuk ldrs gSA bldh 'kksVZ dV dekaM ctrl+n gSA
Open
bl dekaM dh lgk;rk ls ge QkbZy dks [kksy ldrs gSa A bldh 'kksVZ dekaM ctrl+o gSA
Close
bl dekaM dh lgk;rk ls ge [kqyh gqbZ QkbZy dks can dj ldrs gSA
Save
bl dekaM dh lgk;rk ls QkbZy dks lso dj ldrs gSa igyh ckj lso djus ij QkbZy dks u;k uke nsuk iMrk gSA ckj ckj uke nsus dh t:jr ugha iMrh gSA bldh 'kksVZ dV key ctrl + s gSA
Save As
bl dekaM dh lgk;rk ls ge iqjkuh  QkbZy dsk u;s uke ls lso dj ldrs gSaA ,slk djus ij nks QkbZysa cu tk;sxh ,d iqjkus uke ls vkSj nwljh u;s uke ls A
Save Workspace
bl dekaM dh lgk;rk ls ge gekjh QkbZy ds vanj fdlh fo'ks"k LFkku dks tgka geus dksbZ LIsk'ky dk;Z dj j[kk gS] dks vyx ls odZ LIksl ds :i esa lso djok ldrs gS tc ge ml odZ LIskl dks vksiu djsaxs rks dlZj vkWVksesfVd ml txg ij igqWp tk,xk tgk geus Lis'ky odZ dj j[kk gSA
Properties
bl dekaM dh lgk;rk ls ge gekjh QkbZy ds ckjs esa information izkIr dj ldrs gSA bl dekaM dh lgk;rk ls ge ;g Hkh irk yxk ldrs gSA fd gekjh QkbZy esa dqy fdrus ist] isjkxzkQ] ykbZu o oMZ gSaA
Print Area
bl dekaM dh lgk;rk ls ge gekjh QkbZy esa fLFkr og fo'ks"k ,fj;k ftldks ge fizaV djokuk pkgrs gSa dsk lysDV dj fizaV ds fy, fMQkbZu dj ldrs gSaA
Page Set Up
bl dekaM dh lgk;rk ls ge ist dh lsfVax lsV dj ldrs gSaA blds }kjk ge ist dk vkdkj] ekftZu] vkfn Hkh lsV dj ldrs gSaA
Print Preview
bl dekaM dh lgk;rk ls ge ;g ns[k ldrs gSa fd gekjh QkbZy fdl rjg fizaV gksxhA
Print
bl dekaM dh lgk;rk ls ge gekjh QkbZy dks fizaV djok ldrsa gSaA
Exit
bl dekaM dh lgkrk ls ge MS-Excel ls ckgj fudy ldrs gSA

Undo
bl dekaM dh lgk;rk ls ge ykLV esa fd, x;s dke dks Cancel dj ldrs gSa A
Redo
bl dekaM dh lgk;rk ls ge Undo fd, x;s dke dks Cancel  dj ldrs gSaA vFkkZr ;g dekaM Undo dk mYVk gSA
Cut
bl dek.M dh lgk;rk ls ges select fd, x, matter  dsk dkV dj dgha vkSj yxk ldrs gSaA
Copy
bl dek.M dh lgk;rk ls ge select fd, x, matter dks MqIyhdsV dkWih cuk ldrs gSaA
Paste
bl dek.M dh lgk;rk ls ge dkWih ;k dV fd, x, matter  dsk dgha Hkh isLV dj ldrs gSA
Paste Special
bl dekaM dh lgk;rk ls ge dkWih fd, x, matter  esa ls dsoy QksjesV dsk] dsoy dUVsaV] dsoy desaV dks] dsoy QkeqZyk] dsoy osyhMs'ku] vkfn dks isLV djok ldrs gSA ,oa bldh lgk;rk ls ge dkWih fd, x, matter  dsk QkbZy esa fLFkr nwljs matter  esa ,M] lcLVªsd] eYVhIykbZ ,oa fMokbZM dj ldrs gSA

Paste As Hyperlink
bl dek.M dh lgk;rk ls ge ftl matter dks copy  fd;k gS mldks isLV djus ds lkFk gh mldk link, copy matter ls dj ldrs gSa A blls ;g irk yxk ldrs gSa fd paste esa fd, x;s matter  dsk dgak ls copy  fd;k x;k gSA
Fill
bl dekaM dh lgk;rk ls ge lysDV fd xbZ lsy ds vUnj QLVZ lsy esa fLFkr la[;k dks ysQ~V jkbZV] vi] Mkmu esa fQy dj ldrs gSA rFkk bl dekUM dh lgk;rk ls lysDV fd xbz lsy esa ykbZuj ] xq.kksrj ,oa MsV okbZt fljht cuk ldrs gSA
Clear
bl dekaM dh lgk;rk ls ge lysDV fd, x, lsy ds vanj fLFkr esVj esa ls dsoy QksjesV] dsoy desUV] dsoy dUVsaV ,ao lHkh dks ,d lkFk gVk ldrs gSaA
Delete
bl deakM dh lgk;rk ls ge lsy dks fMyhV dj ldrs gSaA
Delet Sheet
bl dekaM dh lgk;rk ls ge QkbZy dh ,DVho odZ 'khV dks fMyhV dj ldrs gSA
Move or Copy Sheet
bl dekaM dh lgk;rk ls ge ,DVho odZ 'khV dh MqIyhdsV dkWih cuk ldrs gSa ,oa ,fDVo 'khV dks viuh bPNkuqlkj fdlh Hkh 'khV ds vkxs ;k ihNs ewo djk ldrs gSaA
Find
bl dek.M fd lgk;rk ls ge QkbZy esa dskbZ Hkh 'kCn ;k v{kj dks search  djok ldrs gSA
Replace
bl dek.M fd lgk;rk ls ge QkbZy esa dskbZ Hkh 'kCn ;k v{kj dks ifjofrZr  djok ldrs gSA
Goto
bl dek.M dh lgk;rk ls ge QkbZy ds fdlh Hkh lsy] ykbZu] cqdekdZ] ,uksVs'ku] vkfn ij Mk;jsDV tk ldrs gSA
Link
bl dek.M dh lgk;rk ls ge nk QkbZy ds chp esa fyad cuk ldrs gSaA
Objects
bl dekaM dh lgk;rk ls ge QkbZy esa insert fd;s x;s object  dsk replace or convert  djok ldrs gSaA

view Menu

Normal
bl dekaM dh lgk;rk ls ge ,sDly dh QkbZy dks ukWeZy :i esa ns[k ldrs gSaA
Page Break Preview
bl dekaM dh lgk;rk ls ge ,sDly dh QkbZy esa fLFkr ist dks ist uacj lfgr LØhu ij ns[k ldrs gSA
Toolbars
bl dek.M fd lgk;rk ls ge ftl Vwyckj dks lysDV djrs gS og Vwyckj LØhu ij fn[kkbZ nsus yxrh gSA
Formula Bar
bl dekaM dh lgk;rk ls ge QkWeZqyk ckj 'kks ,oa gkbZM dj ldrs gSaA
Status
bl dekaM dh lgk;rk ls ge LVsVl ckj dks 'kks o gkbZM dj ldrs gSaA
Header and Footer
bl dekaM dh lgk;rk ls ge ,sDly dh QkbZy esa gsMj o QqVj ns ldrs gSaA
Comments
bl dekaM dh lgk;rk ls ge ,sDly dh QkbZy esa desUVl ns ldrs gSaA
Custom View
bl dekaM dh lgk;rk ls ge gekjh QkbZy ds vanj viuh bPNkuqlkj lsy dks lysDV dj mudk O;w cuk ldrs ftldks ge tc pkgs rc Mk;jsDV ns[k ldrs gSA
Report Manager
bl dekaM dh lgk;rk ls ge ,sDly dh QkbZy ds vanj viuh bPNkuqlkj ubZ fjiksVZ cuk ldrs gS ftlesa ge scenarios o dLVe O;w dks ,M djok ldrs gSa ,ao ckn esa eksMhQkb Hkh dj ldrs gSaA
Full Screen
bl dekaM dh lgk;rk ls ge QkbZy dks Qqy LØhu ij ns[k ldrs gSA
Zoom
bl dek.M dh lgk;rk ls ge gekjh QkbZy dks bPNkuqlkj NksVh cMh djds ns[k ldrs gSaA

Cell
bl dekaM dh lgk;rk ls ge QkbZy esa lsy bUlVZ djok ldrs gSaA u;k lsy bUlVZ djokus ij igys okys lsy ;k jkbZV esa ;k uhps dh rjQ f[kld tkrs gSaA
Row
bl dekaM dh lgk;rk ls ge QkbZy esa ubZ Row Insert  djok ldrs gSA
Columns
bl dekaM dh lgk;rk ls ge QkbZy esa u;k dkWye bUlVZ djok ldrs gSaA
Worksheet
bl dekaM dh lgk;rk ls ge QkbZy esa ubZ odZ 'khV bUlVZ djok ldrs gSaA
Chart
bl dekaM dh lgk;rk ls ge QkbZy esa fdUgha Hkh nks QhYMksa ds chp nks xzkQ cuk ldrs gSaA MS-Excel  esa 14 izdkj ds xzkQ gksrs gSaA rFkk 66 izdkj ds mixzkQ gksrs gSaA
Page Break
bl dekaM dh lgk;rk ls ge gekjh QkbZy dk viuh bPNkuqlkj ist czsd djok ldrs gSaA
Function
bl dekaM dh lgk;rk ls ge QkbZy ds vanj QaD'ku bUlVZ djok ldrs gSaA
Name
bl dekaM dh lgk;rk ls ge QkbZy esa fdlh Hkh lsy ds address  dsk u;k uke ns ldrs gSaA
Note(Comment)
bl dekaM dh lgk;rk ls ge QkbZy ds fdlh Hkh lsy dks uksV ¼desUV½ ns ldrs gSaA
Picture
 bl dekaM dh lgk;rk ls ge QkbZy ds vanj dksbZ Hkh fiDpj bUlVZ djok ldrs gSaA
Object
bl dekaM dh lgk;rk ls ge QkbZy ds vanj vksCtsDV bUlVZ djok ldrs gSaA
Hyperlink
bl dekaM dh lgk;rk ls ge gekjh QkbZy esa nwljh QkbZy dk fyad cuk ldrs gSaA

Cell
bl dekaM dh lgk;rk ls ge QkbZy ds vanj fLFkr lsy dh QksesZfVax dj ldrs gSA
Column
bl dekaM dh lgk;rk ls ge dkWye dh QksesaZfVax dj ldrs gSa A bl deakM dh lgk;rk ls ge dkWye dh pkSMkbZ Hkh c<k ldrs gSA bl dekaM ls ge dkWye dks gkbZM o vugkbZM Hkh dj ldrs gSaA
Row
bl dekaM dh lgk;rk ls ge row dh QksesaZfVax dj ldrs gSa A bl deakM dh lgk;rk ls ge row dh pkSMkbZ Hkh c<k ldrs gSA bl dekaM ls ge row dks gkbZM o vugkbZM Hkh dj ldrs gSaA
Worksheet
bl deakM dh lgk;rk ls ge worksheet  fd QksjesfVax dj ldrs gSaA bl dekaM dh lgk;rk ls ge dkWye dh pkSMkbZ Hkh c<k ldrs gSA bl dekaM dh lgk;rk ls odZ'khV dk uke Hkh psat dj ldrs gSaA bl dekaM dh lgk;rk ls odZ'khV dks gkbZM o vugkbZM Hkh dj ldrs gSaA bl dekaM dh lgk;rk ls odZ'khV dk cSdxzkmaM Hkh lsV dj ldrs gSaA
Auto Format
MS-Excel  ds vanj dqN cus cuk;s QksjesV gSaA ;fn geus MS-Exceld esa vanj dqN dke fd;k gS] rks ge bl dke dks mu cus cuk;s QksjesV esa ifjofrZr dj ldrs gSaA
Style
 bl deakM dh lgk;rk ls ge select matter ds vanj dh fLFkr cells dh lsfVax lsV dj ldrs gSA
Placement
bl deakM dh lgk;rk ls ge MS-Excel ds vanj cus vkWCtsDV~l dks ,d nwljs ds vkxs ihNs dj ldrs gSaaA

Spelling
bl dekaM dh lgk;rk ls ge QkbZy esa fLFkr esVj dh Lisfyax psd djok ldrs gSaA
Auto Correct
bl deakM dh lgk;rk ls ge ,slh Lisfyax ftlds xyr gksus dh laHkkouk T;knk gks mldks lgh Lisfyax ds lkFk esa ,M djok ldrs gSa fQj ;fn ckn esa ml xyr Lisfyax dks QkbZy esa fy[skaxs rks osk vius vki lgh gks tk,xhA
Look Up Reference
bl dekaM dh lgk;rk ls ge fdlh lhMh esa fLFkr fMD'kujh dh lgk;rk ls Lisfyax psd djok ldrs gSaA
Share Workbook
bl dekaM dh lgk;rk ls ge gekjh QkbZy dks ,d lkFk ysu esa tqMs gq, nks ;k nks ls vf/kd dEI;wVjksa esa ,d lkFk [kksy ldrs gSaA
Track change
bl dekaM dh lgk;rk ls ge QkbZy dks lso djus ds ckn fd, x, ifjorZu dks vyx ls gkbZykbZV djok ldrs gSaA
Merge Workbooks
bl dekaM dh lgk;rk ls ge vksfjtuy QkbZy ds vanj Vªsd psat dh xbZ MqIyhdsV QkbZy ds esVj dsk etZ djok ldrs gSaA

Protection
bl dekaM dh lgk;rk ls ge gekjh QkbZy dks ikloMZ nsdj izksVsDV dj ldrs gSaA

Goal Seek
bl dekaM dh lgk;rk ls ge QkWeqZys okyh lsy esa viuh bPNkuqlkj osY;q izkIr dj ldrs gSA rFkk ml osY;q dks izkIr djus ds fy;s ftl lsy esa ifjorZu djuk gksrk gS ml lsy esa vkWVksesfVd ifjorZu gks tkrk gSA
Scenarios
bl dekaM dh lgk;rk ls ge lysDV dh lsyksa esa fLFkr la[;k dks MsVk ds :i esa LVksj djok ldrs gSaA
Auditing
bl dekaM dh lgk;rk ls ge ;g fuf'pr djrs gSa fd ,fDVo lsy dkSulh vU; lsy ij fuHkZj djrh gS ;k ,fDVo lsy ds eku ij vU; dkSu lh lsy fuHkZj gSA
Solver
;g dekaM xksy lhd dekaM dh rjg gh mi;ksx esa vkrh gS ysfdu blds }kjk ge QkWeqZys okyh lsy esa viuh bPNkuqlkj osY;q izkIr djus ds fy, ,d ls vf/kd lsy esa ifjorZu djok ldrs gSaA
Macro
bl dekaM dh lgk;rk ls ge ,slh dksbz Lisfyax ;k lsUVsal tks gekjh QkbZy esa ckj ckj iz;ksx esa vk jgk gks mldh 'kksVZ QksEkZ cuk ldrs gSaA
Add-Ins
bl dekaM dh lgk;rk ls ge ,sDlsy ds vanj vU; MkVk csl lacaf/kr vkWi'ku dks bUlVZ djok ldrs gSaA
Customize & Options
bu deakM dh lgk;rk ls ge ,sDly ds vanj dh lsfVax past dj ldrs gSaA

Sort
bl deakM dh lgk;rk ls ge lysDV fd;s x;s MkVk dks ,d fuf'pr Øe esa ¼?kVrs ;k c<rs gq,½ tek ldrs gSaA
Filter
bl dekaM dh lgk;rk ls ge lysDV fd;s x;s MkVk dks ge fQYVj djds viuh bPNkuqlkj fjdkMZ ns[k ldrs gSaA
Form
bl dekaM dh lgk;rk ls ge lysDV fd;s x;s MkVk dks ge ,d ckWDl ds :i esa ns[k ldrs gSa A ftlesa ls ge viuh bPNkuqlkj fjdkMZ dks tksM ldrs gSa] ?kVk ldrs gSa ,oa lpZ dj ldrs gSaA
Subtotals
bl dekaM dh lgk;rk ls ge lysDV fd;s x;s MkVk dk VksVy o lcVksVy dj ldrs gSaA ysfdu blds fy, igys lysDV fd;s x;s fjdkMZ dsk Øe esa tekuk t:jh gSA
Validation
bl dekaM dh lgk;rk ls ge lysDV fd;s x;s lsy dks fdlh Hkh la[;k ds fy, ekU; dj ldrs gSaA
Table
bl deakM dh lgk;rk ls ge Vscy cuk ldrs gSaA
Text to Columns
bl dekaM dh lgk;rk ls ge fdlh Hkh lsy fy[ks x;s VsDLV dks vyx vyx dkWye esa foHkkftr dj ldrs gSaA
Consolidate
bl dekaM dh lgk;rk ls fn;s x;s lsyksa dks VksVy] vkSlr] vkfn fudky ldrs gSaA
Group and Outline
bl dekaM dh lgk;rk ls ge lysDV fd;s x;s dkWye ;k jsk dk xzqi cuk ldrs gSaA o mudks vuxzqi Hkh dj ldrs gSaA
Pivot Table
;g ,d Vscy foTkkMZ gS ftldh lgk;rk ls ge Vscy cuk ldrs gSA

Sum
bl QaD'ku dh lgk;rk ls fn, x, lsyksa esa fLFkr la[;k dk VksVy dj ldrs gSA
SYNTAX :-  SUM(N1:N2)
INT
bl QaD'ku dh lgk;rk ls fn, x, lsy esa fLFkr la[;k dks iw.kkZad esa psat dj ldrs gSA
SYNTAX:- INT(N)
AVERAGE
bl QaD'ku dh lgk;rk ls fn, x, lsyks esa fLFkr la[;k dk vkSlr fudky ldrs gSaA
SYNTAX:- AVERAGE(N1:N2)
ABS
bl QaD'ku dh lgk;rk ls ge _.kkRed la[;k dks /kukRed la[;k esa ifjofrZr dj ldrs gSaA
SYNTAX:- ABS(N1)
MOD
bl QaD'ku dh lgk;rk ls ge 'ks"kQy la[;k dk eku fudky ldrs gSaA
SYNTAX :-MOD(N,A)
ROUND
bl QaD'ku dh lgk;rk ls ge ;g r; djrs gSa fd Msfley ds ckn fdruh la[;k pkfg,A  SYNTAX :- ROUND(N,A)
COUNT
bl QaD'ku dh lgk;rk ls fn, x, lsyksa esa fLFkr la[;k dks fxu ldrs gSaA
SYNTAX :- COUNT(N1:N2)
MAX
bl QaD'ku dh lgk;rk ls fn, x, lsyksa esa fLFkr la[;kvksa esa ls cMh la[;k dk eku fudky ldrs gSaA
SYNTAX :- MAX(N1:N2)
MIN
bl QaD'ku dh lgk;rk ls fn, x, lsyksa esa fLFkr la[;kvksa esa ls NksVh la[;k dk eku fudky ldrs gSaA
SYNTAX :-MIN(N1:N2)
SQRT
bl QaD'ku dh lgk;rk ls ge lsy esa nh xbZ la[;k dk oxZewy fudky ldrs gSaA
SYNTAX :- SQRT (N)
LOWER
bl QaD'ku dh lgk;rk ls ge lsy esa fLFkr fdlh Hkh fLVªax dks NksVh ABCD  Eks ifjofrZr djus ds dke vkrk gSA
SYNTAX:- LOWER(N)
UPPER
bl QaD'ku dh lgk;rk ls ge lsy esa fLFkr fdlh Hkh string dks cMh ABCD  esa ifjofrZr dj ldrs gSaA
SYNTAX:- UPPER(N)
PROPER
bl QaD'ku dh lgk;rk ls ge lsy esa fLFkr fdlh Hkh fLVªax ds gj 'kCn ds izFke v{kj dks cMh ABCD  'ks"k dks NksVh ABCD esa ifjofrZr dj ldrs gSaA
SYNTAX:- PROPER(N)
NOW
bl QaD'ku dh lgk;rk ls ge vkt ds fnukad o le; fudky ldrs gSaA
SYNTAX :- NOW()
TODAY
bl QaD'ku dh lgk;rk ls vkt dh fnuakd fudky ldrs gSaA
SYNTAX:- TODAY()
REPT
bl QaD'ku dh lgk;rk ls ge lsy esa fLFkr fdlh Hkh fLVªax dks ckj ckj fy[k nksgjk ldrs gSaA
SYNTAX:-  REPT(N,A)