Twitter Delicious Facebook Digg Stumbleupon Favorites More
Showing posts with label Ms-Office-Excel. Show all posts
Showing posts with label Ms-Office-Excel. Show all posts

Friday, March 18, 2011

Tools Menu


6 Tools menu Gi KvR
6.1 Spelling and grammar - evbvb  ï× Kiv
wbw`©ó †m‡j Kvm©i †i‡L A_ev cÖ‡qvRbxq †mj e­K K‡i Tools menu †_‡K Spelling and grammar KgvÛ w`‡q WvqvjM e‡·i wbqgvbyhvqx wb‡b¥i KgvÛ w`b
6.1a Ignore D‡c¶v Kiv
6.1b Ignore All me kã D‡c¶v Kiv
6.1c Add wWKkbvix‡Z kã ms‡hvRb Kiv
6.1d Change cwieZ©b Kiv
6.1e Change All me kã cwieZ©b Kiv

Format Menu


5. Format manu -Gi KvR
5.1 Cells
Number bv¤^vi †U·‡K wewfbœ di‡gU Kiv
cÖ_‡g cÖ‡qvRbxq †mj e­K K‡i Format menu ‡_‡K Cells KgvÛ w`‡q WvqvjM e‡·i Number Gwiqv †_‡K wbw`©ó Ackb wm‡j± K‡i Ok evU‡b Pvcyb|


5.1a Alignment -‡m‡ji †U·‡Ui gvwR©b wba©vib Kiv
wba©vwiZ †mj e­K K‡i format menu †_‡K Cells KgvÛ w`‡q WvqvjM e‡·i Alignment Gwiqvi wbw`©ó Ackb wm‡j± K‡i Ok evU‡b Pvcyb|

5.1b Font -†U·U wWRvBb
cÖ_‡g cÖ‡qvRbxq †U·U e­K K‡i Format menu †_‡K Cells KgvÛ w`‡q WvqvjM e‡·i Font Gwiqv †_‡K wbw`©ó Ackb wm‡j± K‡i Ok evU‡b Pvcyb|

Insert Menu


4 Insert menu -Gi KvR
Cells bZzb ms‡hK Kiv
wbw`©ó ¯’v‡b Kvm©i †i‡L ev cÖ‡qvRbxq †mj e­K K‡i  Insert manu †_‡K Cells KgvÛ w`‡j Insert WvqvjM e· Avm‡e| WvqvjM e‡·i cÖ‡qvRbxq Ackb wb‡j± K‡i  Ok evU‡b Pvcyb|

4.1 Rows -evov‡bv
wbw`©ó ¯’v‡b Kvm©i †i‡L ev cÖ‡qvRbxq †iv e­K K‡i  Insert manu †_‡K Rows KgvÛ w`b|

4.2 Columns- evov‡bv
wbw`©ó ¯’v‡b Kvm©i †i‡L ev cÖ‡qvRbxq †iv e­K K‡i  Insert manu †_‡K Columns KgvÛ w`b|

4.3 Worksheet -IqvK© mxU evov‡bv
Insert manu †_‡K Worksheet KgvÛ w`b|

4.4 Chart- ev MÖvd ˆZix Kiv
wbw`©ó ‡mj e­K K‡i  Insert manu †_‡K Chart KgvÛ w`‡j Chart Wizard WvqvjM e· Avm‡e| WvqvjM e‡·i cÖ‡qvRbxq  Next  evU‡b †P‡c cÖwZwU WvqvjM e‡·i cÖ‡qvRbxq  Ackb wb‡j± K‡i ke© †k‡l 
Finish evU‡b Pvcyb|


View-Menu


3 View- †gbyi KvR
Normal- mvavib c„ôv †`Lv‡e|
View †gbyi Number KgvÛ w`b|

3.1 Page Break Preview-c„ôv AvKv‡i †`Lv
View ‡gby †_‡K Page Break Preview-KgvÛ w`‡j c„ôvi bgybv †`Lv‡e|

3.2 Toolbar -Avbv †bIqv
View ‡gby †_‡K Toolbar G Kvm©i wb‡q wbw`©ó Uzjev‡i gvDm w`‡q KgvÛ w`‡j UzjeviwU Pwj hv‡e (hw` D³ UzjeviwU gwbU‡i Active _v‡K) Ges View-Toolbar G gvDm wb‡q D³ Uzjev‡i Pvc w`‡j Zv wd‡i Avm‡e|

Edit Menu


2 Edit menu  Gi KvR
Undo Kgv‡Ûi Kvh©KvixZv evwZj Kiv
cÖ_‡g †Kvb KgvÛ w`‡Z n‡e| Gevi Edit menu  †_‡K Undo KgvÛ  w`‡Z n‡e|
Redo evwZjK…Z KgvÛ cybt¯’vcb Kiv|
cÖ_‡g Undo KgvÛ w`‡Z n‡e| Edit menu  †_‡K Redo KgvÛ w`b|

2.1 Cut – Text †jLv gyQv/¯’vbvš—i Kiv
cÖ_‡g cÖ‡qvRbxq Text  ¸‡jv e­K K‡i wbb| Gevi   Edit menu †_‡K  Cut KgvÛ w`‡j †jLv gy‡Q hv‡e wKš‘ †jLv ¸‡jv Avcbvi wK¬c †ev‡W© Rgv _vK‡e hv Avcwb †`L‡Z cv‡eb bv| GLb †hLv‡b †jLv  ¸‡jv ¯’vbvš—i Kiv `iKvi †mLv‡b Kvm©i †i‡L  Edit menu ‡_‡K Paste KgvÛ w`b|
Keyboard short cut command è Block text àCtrl+x àCtrl+v

2.2 Copy- Abyiƒc †U·U ˆZix Kiv
cÖ_‡g †jLv¸‡jv e­K K‡i Edit menu †_‡K Copy  KgvÛ w`b Ges cÖ‡qvRbxq ¯’v‡b Kvm©i †i‡L  menu ‡_‡K Paste KgvÛ w`b|
Keyboard short cut command è Block text àCtrl+c àCtrl+v

File Menu


1. File Menu  Gi KvR

New-bZzb dvBj ˆZix Kivt
File menu †_‡K  New KgvÛ w`‡j New WvqjM e· Avm‡e | WvqjM e‡·i General ‡_‡K Blank workbook  wm‡j± K‡i Ok evU‡b Pvc w`b| or File à New à blank Document
Keyboard short cut command è Ctrl+N

1.1 Open -dvBj †Lvjv

File menu †_‡K Open KgvÛ w`‡j  File WvqvjM e· Avm‡e| WvqvjM e‡·i List Area ‡_‡K wbw`©ó dvBj wm‡j± K‡i Open evU‡b Pvc w`b|
Keyboard short cut command è Ctrl+O àSelect Your file à Open

1.2 Close -dvBj eÜ Kiv
File menu ‡_‡K Close evU‡b Pvc w`b| A_ev Title bar Gi wb‡Pi [X] (Close) AvBK‡b Pvc w`b|

Microsoft Excel


Microsoft Excel  nj Microsoft Office Gi GKwU c¨v‡KR application Software. Excel k‡ãi A_© nj Qvwo‡q †`Iqv| Microsoft Excel  †K Spread Sheet ejv nq| Spread k‡ãi A_© †g‡j †`Iqv| Sheet k‡ãi A_© Zv ev cvZv| A_©vr Spread Sheet A_© nj we¯—…Z RvqMv Ry‡i †g‡j †`Iqv cvZv|  g~jZ Excel ev Spread Sheet ‡cÖvMÖvgwU A‡bK¸‡jv Row Ges Column mg„× nq| wb‡b¥ Gi cwiwPwZ †`Iqv nj|

Excel ev  Spread Sheet †cÖvMÖv‡g Row Ges Column `viv m„ó  e·‡K Cell  e‡j Ges Row, column Ges Cell mg„× m¤ú~b© RvqMv‡K Sheet e‡j|