10- পরিচিতি পর্ব এক্সেল এর ফাইল ইডিট ও ভিউ মেনুর
File Menu
Introduce of File Menu
Save : Excel-G wKQz
wj‡L Zvi ci D‡jøwLZ Kgv‡Ûi gva¨‡g bv‡g
dvBjwU msiÿY Kiæb |
( Ms Word Gi wbqg Abymv‡i)
Open
File : Ctrl+O) dvBj A‡cb Kivi Rb¨
(``Alam”bv‡gi dvBjwU A‡cb Kiæb|)
i. File Open
†gby‡Z wK¬K | ii. Open G
wK¬K | ÔÔ Alam ÕÕ
bv‡g dvBjwU wm‡jó K‡i Open G wK¬K |
Close File : Ctrl + W) dvBj eÜ Kivi Rb¨| (Ms Word Gi wbqg cÖ‡hvR¨) “Alam” bv‡g dvBjwU Ly‡j Zvici Avevi
eÜ Kie|
New File : bZzb
WKz‡gÛm †Lvjvi Rb¨ (Ms Word Gi wbqg cÖ‡hvR¨)
Save As : “Alam” bv‡g dvBjwU Ab K‡i Zv Avevi Wzwcø‡KU dvBj
wnmv‡e Ab¨ bv‡g ‡mf Kie| cÖ_g t Ò “ Alam” bv‡g dvBjwU Ab Ki‡Z n‡e|Zvici-
(i). File ‡gby‡Z wK¬K|
(ii). save As G wK¬K| WvqvjM e· Gi File name : G GKwU
bZzb bvg “ Ali” wj‡L save G
wK¬K|
To save a
File by Password : (cvmIqvW©
w`‡q dvBj msiÿb Kiæb, hv‡Z Ab¨ †KD H †Mvcb Aÿi ev †KvW UvBc K‡i dvBjwU Ab Ki‡Z
bv cvi| GKgvÎ †KvW cÖ`vbKvixB cvi‡eb|)
Excel- Ly‡j Ab Kie|
(i). File ‡gby‡Z wK¬K|
(ii). save As.... wK¬K|
(iii). Tools Ñ WªcWvDb
wj‡ó wK¬K K‡i General
options... G wK¬K|
(iv). Gevi
†Mvcb Aÿi Dfq N‡i wj‡L Ok.
Kbdvg© PvB‡j cybivq UvBc K‡i -. Ok
we: `ª: File Name “ New Name” wjLyb|)
be Kw¤úDUvi GÛ d‡UvKwc, cyivZb evmó¨vÛ, gvae`x
nvB¯‹zj gv‡Vi cwðg cv‡k¦©, c„ôv bs-22
Ø
Gevi H dvBjwU Lyj‡Z n‡j †h cvmIqvW© †`qv n‡q‡Q Zv
UvBc K‡i Ok.
Ø
Page Setup t Excel Gi †cR †mUAvc A‡bKUv Iqv‡W©i Abyiæc| Z‡e †cBR †mUAvc
WvqvjM e‡·i Page
U¨ve| Aaxb Adjust to: 100% KgvÛwU
LyeB ¸iæZ¡c~b©| GLv‡b 100% ‡_‡K
Kwg‡q 50% ch©šÍ
wj‡L Ok w`‡j
†cR Gi RvqMv A‡bKUv †e‡o hvq| Avi Ab¨vb¨ KgvÛ cÖvq GKB|
Ø
gviwRb U¨v‡K wK¬K Ki‡j Av‡iv bZyb 2 wU Ackb i‡q‡Q
Horizontally
& Vertically. †jLv †c‡Ri ga¨¯’v‡b wcÖ›U Ki‡Z GwU wm‡j± Ki‡Z nq|
Ø
print t (Ctrl + p)- dvBj wc›U Kivi Rb¨| “Alam” bv‡gi dvBjwU Open Kiæb|
1 bs †cRwU wcÖ›U Kiæb|
(i). File ‡gby‡Z wK¬K|
(ii). Print
G wK¬K| GKwU WvqvjM e· Avm‡e|
GLvb †_‡K Page- From e‡·, 1 I To: e‡· 1wj‡L ( †h ‡cRwU wcÖ›U Kiv `iKvi UvBc K‡i) Ok.
Edit Menu
Introduce of Edit Menu
* G †gby¯’ wewfbœ KgvÛ Ackb wbe©vPb K‡i †h KvR Kiv hvq Zv n‡jv t
Undo / Redo
t m`¨
cÖ‡qvMK…Z †Kvb KgvÛ ev` †`qv ev cybivq wd‡i cvIqv|
( Ms Word Gi
wbqg )
Copy or Cut
/ past t ‡jLv
GK RvqMv †_‡K Ab¨G Kwc A_ev ¯’vbvšÍi Ki‡Z G KgvÛwU e¨eüZ nq- (Ms Word Gi
wbqg †`Lyb)
Paste
Speacial....‡jLv
KvUv/Kwc K‡i Ab¨ RvqMvq kZ©vbyhvqx emv‡Z G KgvÛwU e¨eüZ nqÑ
i. At first Block the text. ii. Edit G wK¬K,
iii. Cut/copy wK¬K iv.Avevi Edit G wK¬K
K‡i Paste Speacial...G
wK¬K|
GKwU WvqvjM e·
Avm‡e|GLv‡b wewfbœ Ackb i‡q‡Q G¸‡jv wm‡j± K‡i G‡KKfv‡e †có Kiv hvq|
Past
Speacial WvqvjM e‡·i Transport wm‡j± K‡i¢A1:A5¢ch©šÍ
wm‡j‡±W KwcK…Z AskUzKz B2- †Z
Kvm©i †i‡L †có Kiæb|
Cleart G
KgvÛwU w`‡q †Kvb †m‡j ev wbev©wPZ †mjmg~‡ni WvUv ev dig¨vU ev K‡g›U gyQv hvq|
i. Block the text.ii.Edit G
wK¬K, iii. Clear
G wK¬K K‡i Gi mve Ackb G wK¬K|
* Delete: G
AckbwU ‡cÖm K‡i ev ÔCtrl+-Õ G †cÖm Ki‡j GKwU WvqvjM e· Avm‡e|GLvb †_‡K †mj/‡iv ev
Kjvg wm‡j± K‡i wewfbœfv‡e ‡mj/‡iv/Kjvg gyPv hvq|
Find/Replace/Go
to eo
†Kvb IqvK©kxU ‡_‡K kã Ly‡R ‡ei Kiv ev
wi‡cøm Ki‡Z G KgvÛwU e¨eüZ nq|ZvQvov †Kvb wbw`ó †m‡j †h‡Z Go to KgvÛ
w`‡q †idv‡iÝ gv‡b †mj G‡Wªm (G50) wj‡L
G›Uvi|
Delete
Sheet: ‡h
IqvK©kxUwU gyQvi cÖ‡qvRb †mwU G¨KwUf KiZt G KgvÛwU w`‡q ok.
Move or
copy sheet:G Kgv‡Ûi gva¨‡g G‡·j Gi IqvK©kxU GK dvBj †_‡K Ab¨
dvB‡j ¯’vbvšÍi Kiv hvq|KgvÛwU e¨envi Ki‡j GKwU WvqvjM e· Avm‡e|
be Kw¤úDUvi GÛ d‡UvKwc, cyivZb evmó¨vÛ, gvae`x
nvB¯‹zj gv‡Vi cwðg cv‡k¦©, c„ôv bs-23
‡mLv‡b To Book:ÑevU‡b wK¬K K‡i ZvwjKv
†_‡K †h dvB‡j ¯’vbvšÍi Ki‡Z Pvb wm‡j± Kiæb Ges †h kxUwU wb‡Z Pvb wm‡j± Kiæb|Kwc
K‡i wb‡Z PvB‡j wb‡Pi Kwc AckbwU wm‡j± Ki‡Z n‡e| (Z‡e dvBjwU Ab K‡i wb‡Z n‡e)|
Fill: IhvK©kx‡U
µgvš^‡q m¤úwK©Z †jLv †hgb-Jan, Feb/ Sat, Sun, Mon /1,2,3../5,10/Date
BZ¨vw` A‡Uv Gw›Uª Kivi Rb¨ G KgvÛwU e¨eüZ nq| Avi G KvRwU fv‡e Kiv hvq|
Sat
|
Jan
|
1
|
|
Sun
|
Feb
|
2
|
|
Mon
|
3
|
h_v t
1| File Handle KgvÛ
e¨envi K‡i|
2| Edit ‡gby¯’
Fill mve
†gbyi Series AckbwU
e¨envi K‡i|Z‡e Fill Handle Gi
gva¨‡gB mvavibZt †ekx
mnR| [Wvb cv‡ki e·wU G Kgv‡Ûi gva¨‡g A‡Uv‡Z Kiv
n‡q‡Q|]
[wet `ªt-G‡·j Gi †Kvb
†m‡j Kvm©i †i‡L Ctrl+ ZvwiL
Avm‡e|] Zvici wdj †n‡Ûj e¨envi Kiæb|
View Menu
Introduce of View Menu
Gi wewfbœ Ackb wbev©Pb K‡i cÖ‡qvRbxq
Uzjevi,‡nWvi,dzUvi, †cR †eªK wcÖwfI BZ¨vw` †`qv hvqt
Normal:
mvavibZt G AckbwU wWdë wnmv‡e _v‡K|GwU wm‡j± K‡i mvavibZ KvR Kiv nq|
Page Break
Preview:
G KgvÛwU Øviv c„ôv wefvRb eySv hvq|
Toolbars : cÖ‡qvRbxq
Uzjevi mPjI ev` †`Iqvi Rb¨ G KgvÛwU e¨eüZ nq|Gg Gm .Iqv‡W© G wel‡q Av‡jvPbv Kiv
nq|
Formula
Bar: Kjvg
†nwWs Gi Dc‡ii eviwUB dig~jv evi| Gi evg w`‡Ki As‡k †mj G‡Wªm Gis Wvbw`‡K As‡k
†m‡j Gw›UªK„Z Z_¨ †`Lv hvq| G KgvÛ w`‡q G evi wU Avbqb I ev` †`Iqv hvq|
Status Bar:
G eviwU mPj I ev`
Rb¨ KgvÛwU e¨eüZ nq|
Header/Footer: Gi e¨envi
Gg, Gm Iqv‡W©i gZB| wKš‘ G·j WvqvjM e·wUi GKUz e¨vwZµg i‡q‡Q| KviY e· Gi wfZ‡i
Avevi Custom Header or Footer G wK¬K K‡i cÖ‡qvRbxq Ackb wm‡j± K‡i I‡K Ki‡Z n‡e| [ GwWwUs ev wWwjU
BZ¨vw` Kiv hvq|
Full Screen: G wb‡`©kwU w`‡q Uzjevi e¨vZxZ m¤ú~Y© c`©v Ry‡o
cÖvq 30wUi gZ mvwi cÖ`k©b Kiv hvq| Avevi Av‡Mi Ae¯’vq wd‡i †h‡Z Close full Screen (c`©vq cÖ`wk©Z
†QvU Uzjev‡i) wK¬K Ki‡Z n‡e|
Zoom: ‡jLv‡K ¯Œx‡b †QvU eo
K‡i ïay †`Lvi Rb¨ (eo wcÖ›U n‡e bv) G AckbwU e¨envi Kiv nq|
be Kw¤úDUvi GÛ d‡UvKwc, cyivZb evmó¨vÛ, gvae`x
nvB¯‹zj gv‡Vi cwðg cv‡k¦©, c„ôv bs-24