Sunday, August 10, 2014

File Menu Microsoft Excel XP


** File Menu **

1.To Create A New Book (GKwU bZzb eB ˆZix Kiv) t
_ File Click
_ New Click
_ Ok Click Ki‡jB bZzb GKwU eB ˆZix n‡e| Microsoft Word Program Gi g‡a¨ hv Avgiv Document
wnmv‡e wP‡bwQjvg|
[ NB t To Create A New Book (GKwU bZzb eB ˆZix Kiv) GB KvRwU Avgiv Ab¨fv‡eI Ki‡Z cvwi †hgb
Standard Tool Bar Gi New Icon Gi g‡a¨ Click K‡i A_ev KeyBoard Key Ctrl + N Press Gi gva¨‡g|

2. Save to the Book (msi¶b Kiv) t
_ cÖ‡g msi¶b Kivi Rb¨ †Kvb wKQy ˆZix K‡i Zvici †h †Kvb RvqMvq Cursor ‡i‡L
_ File Click
_ Save Click Ki‡j mv‡_ mv‡_ Save As Dialog Box Avm‡e ZLb Save As Type Box G Microsoft Excel
Workbook Select K‡i File Name Box Gi g‡a¨ †h bv‡g Save Ki‡Z PvB †mB bvgwU wj‡L
_ Save Click Ki‡jB H bv‡g msiw¶Z n‡e| cieZ©x‡Z Open K‡i ‡`L‡Z cvwi|
[ NB t Save As Dialog Box wU Avgiv Ab¨fv‡eI Avb‡Z cvwi †hgb Standard Tool Bar Gi Save Icon Gi
g‡a¨ Click K‡i A_ev KeyBoard Key G Ctrl + S Press Gi gva¨‡g| cieZ©x KvR¸‡jv GKB iKg Ki‡Z n‡e|
we¯—vwiZ wk¶‡Ki wbKU †_‡K †R‡b wbb|

3. To Close A File Or Book (GKwU dvBj ev eB eÜ Kiv) t
_ ‡Kvb GKwU File ev Book Open _vKve¯’vq
_ File G Click
_ Close Click Ki‡jB Open K„Z File ev Book wU Close n‡e| Z‡e Close Click KivgvÎB Yes/No K_vwU mn
WvqvjM e· Avm‡Z cv‡i ZLb hw` H File ev Book wU Save (msi¶b) Ki‡Z PvB Z‡e
_ Yes Click Ki‡jB msi¶b Kivi Rb¨ Save As Dialog Box Avm‡e ZLb msi¶b Kivi c×wZg‡Zv msi¶b Kiv
hv‡e Z‡e hw` msi¶b Ki‡Z bv PvB ZLb
_ No Click Ki‡jB File ev Book wU Close n‡e|
[ NB t Close Avgiv Ab¨fv‡eI Ki‡Z cvwi †hgb Standard Tool Bar Gi g‡a¨ Close hw` †jLv _v‡K Z‡e GB Close G
Click K‡i A_ev KeyBoard Key Alt + F4 Press Gi gva¨‡g| cieZ©x KvR¸‡jv GKB iKg Ki‡Z n‡e| we¯—vwiZ wk¶‡Ki
wbKU †_‡K †R‡b wbb|

4. To Open A File (GKwU dvBj †Lvjv ev ¯OEx‡b wb‡q Avmv) t
_ cÖ‡g Open Kivi Dc‡hvMx K‡i GKwU Book †K Save K‡i File G cwibZ Kwi Zvici
_ File G Click
_ Open Click Ki‡j Open Dialog Box Avm‡e ZLb †h bv‡gi File wU Open Ki‡Z PvB †mB File wU Location
g‡Zv Lyu‡R †ei K‡i Select Kivi ci
_ Open Click Ki‡jB Save K…Z File wU Open n‡e|
[ NB t Open Dialog Box wU Avgiv Ab¨fv‡eI Avb‡Z cvwi †hgb Standard Tool Bar Gi Open Icon Gi g‡a¨ Click
K‡i A_ev KeyBoard Key Ctrl + O Press Gi gva¨‡g| cieZ©x KvR¸‡jv GKB iKg Ki‡Z n‡e| we¯—vwiZ wk¶‡Ki wbKU
†_‡K †R‡b wbb|

5. Save As (GKwU dvBj Ab¨ †Kvb bv‡g Kwcc~e©K msi¶b Kiv) t
_ cÖ‡g †h dvBjwU Kwcc~e©K msi¶b Ki‡Z PvB †mwU Open Ki‡Z n‡e Zvici
_ File Click
_ Save As Click Ki‡j mv‡_ mv‡_ Save As Dialog Box Avm‡e ZLb Save As Type Box G MicroSoft Excel
Workbook Select K‡i File Name Box Gi g‡a¨ †h bv‡g Kwcc~e©K msi¶b Ki‡Z PvB †mB bvgwU wj‡L
_ Save Click Ki‡jB H bv‡g Open Kiv File Gi GKwU Copy msiw¶Z n‡e| cieZ©x‡Z Open K‡i ‡`L‡Z cvwi|

6. Save As Web Page (I‡qe mvB‡W msi¶b Kiv) t
_ ‰ZixK…Z File wU Web Page Gi g‡a¨ msi¶b Ki‡Z n‡j GB Save As Web Page Option wUi mvnvh¨ wb‡Z nq
A_©vr GB Option wUi mnvqZvq ‰ZixK…Z File wU Web Page Gi g‡a¨ msi¶b Kiv hvq| hw` Avcbvi Computer
wU‡Z Internet Gi ms‡hvM †`Iqv _v‡K Ges Internet m¤ú‡K© hw` Avcbvi my¯úó avibv _v‡K Z‡e wk¶‡Ki wbKU †_‡K
†R‡b wbb|

7. Save As Workspace (GKvwaK dvBj GKwÎZ K‡i msi¶b Kiv) t
_ cÖ‡g †h KqwU (GKvwaK) dvBj GKwÎZ K‡i Save (msi¶b) Ki‡Z PvB †mB KwU dvBj‡K Open Kwi Zvici
dvBj¸‡jv Open _vKve¯’vq
_ File Click
_ Save As Workspace Click Ki‡j Save Workspace Dialog Box Avm‡e Ges Save As Type Box G Workspace
‡jLv _v‡K GB Ae¯’vq File Name Box Gi g‡a¨ †h bv‡g GKvwaK GKwÎZ K‡i msi¶b Ki‡Z PvB †mB bvgwU wj‡L
_ Save Click Ki‡j Open Kiv dvBj¸wj H bv‡g GKwÎZ n‡q Save (msi¶b) n‡e|

8. To See Web Page Preview (I‡qe †cBR †`Lv) t
_ cÖ‡g I‡qe †cB‡R †`Lvi Rb¨ GKwU dvBj ˆZix Kwi Zvici
_ File Click
_ Web Page Preview Click Ki‡j Internet Mode G Microsoft Internet Explorer Open n‡e| mv‡_
mv‡_ ˆZixK…Z File ev Book wU c`wk©Z n‡e|

9. Page Setup (c„óvi gvwR©b, mvBR BZ¨vw` †mwUs Kiv) t
_ cÖ‡g Page Setup Kivi Rb¨ Page Gi g‡a¨ †Kvb wKQy wj‡L Zvici
_ File Click
_ Page Setup Click Ki‡j mv‡_ mv‡_ Page Setup Dialog Box Avm‡e ZLb Page Tab Gi g‡a¨ Click K‡i,
_ Potrait Click Ki‡j Page wU Lvovfv‡e Print n‡e Ges Landscape Click Ki‡j Page wU evuKvfv‡e Print n‡e
(Lvov Ges evuKv Ae¯’v `ywU bv eyS‡j wk¶K‡K wRÁvmv Ki“b)
_ Paper Size Box Gi g‡a¨ Click K‡i Avgiv †h Size Gi Paper Gi g‡a¨ Print Kie †mB Size Gi Paper
Select Ki‡Z cvwi|
 
_ Print Quality Box Gi g‡a¨ Click K‡i Avgiv KZ dpi ‡Z Print Kie Zv Select Ki‡Z cvwi| cieZ©x‡Z
Margins Tab Gi g‡a¨ Click K‡i,
_ Top, Buttom, Left, Right, Header, Footer, BZ¨vw`i Margin Setup Ki‡Z cvwi|
_ Center Of Page Box Gi g‡a¨ Horizontally ‡Z Click c~e©K (_) wPý w`‡j †jLv¸‡jv Horizontally
Center n‡e Aciw`‡K Vertically ‡Z Click c~e©K (_) wPý w`‡j †jLv¸‡jv Vertically Center n‡e| Zvici
cÖ‡qvRb‡ev‡a GB Page Setup Box ‡_‡K Avgiv Print Preview ‡`L‡Z cvwi Ges Print Ki‡Z cvwi| cieZ©x‡Z
_ Ok Click Ki‡j g‡bi B‡”QgZ ‰Zix Kiv Page Setup Apply n‡e hv Avgiv c‡i ‡h †Kvb mgq Print Preview
‡`L‡Z cvwi|
[ NB t GB Page Setup Box ‡_‡K Avgiv Header & Footer Ki‡Z cvwi| Z‡e Microsoft Excel Gi g‡a¨ View Menu ‡Z
Header & Footer m¤ú‡K© Av‡jvPbv Kiv n‡q‡Q| ZvB G m¤ú‡K© View Menu ‡Z we¯—vwiZ Rvb‡Z cvie| ]

10. To Create Print Area (†Kvb c„óvi wbw`ªó wKQy ¯’vb wcÖ‡›Ui Rb¨ ˆZix Kiv) t
_ ‡Kvb GKwU Page Gi ga¨ †_‡K hw` wbw`ªó wKQy RvqMv Avjv`vfv‡e Print (wcÖ›U) Ki‡Z PvB Zvn‡j †h RvqMvUzKy
Avjv`vfv‡e Print (wcÖ›U) Ki‡Z PvB †mB RvqMvUzKz Block c~e©K Select K‡i
_ File Click
_ Print Area Click
_ Set Print Area Click Ki‡j H RvqMvUzKz Print (wcÖ›U) Kivi Rb¨ ˆZix n‡e| hv Avgiv Print (wcÖ›U) Kivi Av‡MB
Print Preview Click K‡i ‡`L‡Z cvwi| cieZ©x‡Z hLb wbw`ªó RvqMvUzKz Print (wcÖ›U) Kiv †kl n‡q hv‡e ZLb hw`
Avevi Print Area wU ev` w`‡q m¤ú~b© Page wU Print (wcÖ›U) Kivi cÖ‡qvRb nq Z‡e H RvqMvUzKz Block c~e©K Select
K‡i ev Gi cv‡k Cursor ‡i‡L
_ File Click
_ Print Area Click
_ Clear Print Area Click Ki‡j H RvqMvUzKz ‡_‡K Print Area Delete n‡e Ges m¤ú~b© Page wU Avevi Print
(wcÖ›U) Kivi Rb¨ ˆZix n‡e|

11. Print Preview (wcÖ›U Kivi Av‡M cª`k©b) t
_ ‡h dvBj ev eBwU Print (wcÖ›U) Ki‡Z PvB †mwU Open Kwi| Print (wcÖ›U) Kivi ci GwU wKfv‡e c`wk©Z n‡e Zv
†`Lvi Rb¨
_ File Click
_ Print Preview Click A_ev Standard Toolbar Gi Print Preview Icon Gi g‡a¨ Click Ki‡j Print
Preview ‡Z Page wU †QvU AvKv‡i c`wk©Z n‡e| c`k©b †k‡l Print Preview Toolbar ‡_‡K Close Button
Click Ki‡j Print Preview eÜ n‡q Worksheet Gi g‡a¨ P‡j Avm‡e|

12. Print (ˆZixK…Z Kv‡Ri AvDUcyU †`Iqv) t
_ Print Kivi we¯—vwiZ c×wZ wk¶‡Ki wbKU †_‡K †R‡b wbb| (Rvbv AZ¨vek¨K)

13. Send To (¯’vbvši— cÖm½) t
_ Open K…Z File ‡K GK¯’vb †_‡K Ab¨¯’v‡b ¯’vbvš—i Kivi Rb¨ Send To Menu Gi Awab¯’ wewfboe Sub Menu ¸‡jv
e¨envi Kiv n‡q _v‡K| Gi Rb¨ Internet Connection / Network cÖ‡qvRb nq| we¯—vwiZ wk¶‡Ki wbKU †_‡K †R‡b wbb|

14. Properties (dvBj m¤ú‡K© we¯v— wiZ Rvbv) t
_ Open K…Z File m¤ú‡K© we¯—vwiZ Rvbvi Rb¨ D³ Sub Menu wU e¨envi Kiv n‡q _v‡K| we¯—vwiZ e¨envi wk¶‡Ki wbKU
†_‡K †R‡b wbb|

15. Exit (cÖ¯’vb Kiv) t
_ KvR‡k‡l Spreadsheet Analysis Software (Microsoft Excel) ‡_‡K cÖ¯’vb Ki‡Z n‡j
_ File Click
_ Exit Click A_ev KeyBoard Gi ga¨ †_‡K Alt + F4 Press KivgvÎB Yes/No K_vwU mn WvqvjM e· Avm‡Z
cv‡i ZLb hw` H File ev Book wU Save (msi¶b) Ki‡Z PvB Z‡e
_ Yes Click Ki‡jB msi¶b Kivi Rb¨ Save As Dialog Box Avm‡e ZLb msi¶b Kivi c×wZg‡Zv msi¶b Kiv
hv‡e Z‡e hw` msi¶b Ki‡Z bv PvB ZLb
_ No Click Ki‡jB File ev Book wU Close n‡e Ges Operating System Gi Screen wU Open n‡e|

No comments:

Post a Comment