11- পরিচিতিপর্ব এক্সেল এর ইনসার্ট মেনু ; Introduce of XL Insert Menu
Insert Menu
Introduce of Insert Menu
Break: GKwU †cR Gi wKQz Ask †i‡L
evwK Ask cieZx †cR G wcÖ›U Ki‡Z GB KgvÛwU e¨eüZ nq| Insert G wK¬K Break G wK¬K Þ Select
option (as your choice) ok G wK¬K |
Insert : Insert
k‡ãi A_©
n‡jv †Kvb wKQz mwbœ‡ewkZ Kiv ev ms‡hvRb Kiv| †hgb: †mj/ Kjvg/ †iv/ IqvK©kxU
BZ¨vw` evov‡bv ev PvU MÖvd ˆZix Kiv hvq|
Insert Cells : G KgvÛ w`‡q
IqvK©kx‡U wbe©vwPZ †mj Gi wb‡P ev Wv‡b †mj ev †mj mg~n
mwbœ‡ewkZ Kiv hvq|
Insert Row/ Column : †iv ev Kjvg
evov‡Z G KgvÛwU e¨eüZ nq| †hLv‡b †iv ev Kjvg evov‡bv cÖ‡qvRb †mLv‡b Kvm©vi †i‡L
Insert G wK¬K Þ Row or Column G wK¬K ‡iv / Kjvg evov‡Z
GB KvRwU Kie|
Insert Worksheet : GKwU IqK© ey‡K K‡qKwU IqvK©kxU _vK‡Z cv‡i| cÖ‡qvR‡b Avgiv
AviI IqvK©kxU evov‡Z cvwi| IqvK©eyKwU I‡cb K‡i| Insert G wK¬K Þ Work book G wK¬K IqvK©kxU evo‡e| Zv Qvov IqvK©kx‡Ui bvg cwieZ©b Kiv
cÖ‡qvR‡b †m kx‡Ui bv‡gi Dci gvBm c‡q›Uvi wb‡q Wvb †evZvg Pvc w`b| c`©vq mU©KvU
†gby I‡cb n‡e| Renamr G wK¬K Þ ‡h bvg PvB‡eb †m bvg wj‡L Enter w`b|
Insert Chart & Ghaph : MvwYwZK Z_¨ mg~n‡K ev RwUj
msL¨vZ¡K wee„wZ‡K wP‡Îi gva¨‡g AvKl©Yxq/ mnRfv‡e eySv‡bvi Rb¨ GB MÖvd ˆZix Kiv
nq| GB MÖvd PvU© Z_¨ A‡cÿv PgKcÖ` I wPËvKl©K, mn‡RB g‡b `vM Kv‡U, mswÿß avibv
†`q, Zzjbv‡K mnR K‡i, mn‡R †evaMg¨ nq Ges mgq evuPvq| †hgb t
PvU© ˆZix Kivi wbqg t
cÖ_‡g GKwU WvUvkwU ˆZix
Ki‡Z n‡e| Wvbcv‡ki WvUv †Uwej Abyhvqx A1:F4 wm‡j±
Ki‡Z n‡e| Gevi PvU© G wK¬K | PvU© Gi aib wm‡j± K‡i †b± G wK¬K Ki‡Z n‡e|
GLb
cÖ‡qvRb Abymv‡i Pv‡U©i aib Abyhvqx Title, Axes, Gridlines, Legend, Date, Labels, Data, Table BZ¨vw` U¨ve Gi Aaxb wewfbœ
Ackb wm‡j± K‡i Next w`‡q
me‡k‡l Finish evU‡b wK¬K K‡i AZ¨šÍ AvKl©Yxq iƒ‡c †h †Kvb PvU© ˆZix Kiv
hvq| [†cÖKwUm Kiæb]
be Kw¤úDUvi
GÛ d‡UvKwc, cyivZb evmó¨Û, gvae`x nvB¯‹zj gv‡Vi cwðg cv‡k¦©, c„ôv bs-25
GwWU Kiv : PvU©
‰Zix Kivi ci Zv‡Z Avevi wewfbœ cÖKvi dig¨vU
( cøU Gwiqvi Kvjvi KiY , MªxW jvBb †`qv ,wj‡RÛ cwieZ©b Kiv
†WUv †Uwej mshy³ Kiv BZ¨vw` ) Ki‡Z
n‡j wm‡j± KiZ:
PvU© †gby‡Z wK¬K K‡i
PvU© Ack‡b wK¬K Ki‡j GKwU WvqvjM e· Avm‡e |
GLvb †_‡K hveZxq KvR Kiv hv‡e |
Insert Menu
Ø function...: GK‡m‡j MvwYwZK dg~jv MVb K‡i ¯^qswµq fv‡e we‡kl cwiMbYv (RwUj wnmve wbKvk)Kivi Rb¨ G KgvÛwU e¨ewüZ nq |
Ø
m~Î me
mgq mgvb (=) wPý w`‡q ïiæ Ki‡Z nq |
Ø
†h N‡i
djvdj Avbv cÖ‡qvRb †m N‡i Kvm©i /†mj c‡q›Uvi †i‡L m~Î UvBc Ki‡Z n‡e |
Ø
Z‡e
g‡b ivL‡Z n‡e Insert >Function KgvÛwU
e¨envi bv K‡i mvaviYZ :wK †evW© w`‡qB UvBc K‡i G›Uvi w`‡Z nq | wewfbœ iK‡gi dvskb i‡q‡Q
†hgb :-
wb‡¤œ
K‡qKwU ¸iæZ¡c~Y© m~Î †`qv n‡jv :
1
|
=Now( )wj‡L G›Uvi |
|
eZ©gvb ZvwiL I mgq Avm‡e
|
2
|
ctrl+; wj‡L G›Uvi |
|
ïay eZ©gvb ZvwiL Avm‡e |
|
3
|
=sum(A1:A5)G›Uvi orUyjevi n‡Z A‡Uvmvg å AvBK‡b wK¬K K‡iI †hvMdj wbY Kiv hvq |
|
‡hvM K‡i †iRvë Avm‡e
|
4
|
=B2- C2 G›Uvi |
|
we‡qvMdj †`Lv‡e |
|
5
|
=B2*C2 G›Uvi|
|
¸bdj Avm‡e
|
6
|
=B2/ C2 G›Uvi |
|
fvMdj †ei ei‡e |
|
7
|
=Count(B1:B8) G›Uvi |
|
†i‡Äi wfZ‡i K‡qKwU msL¨v i‡q‡Q Zv MYbv K‡i
cÖKvk Ki‡e |
|
8
|
=Average / Min/max(B1:B8) G›Uvi |
|
msL¨vi
Mo ,‡QvU/eo msL¨v †ei Kiv |
|
9
|
=sqrt (B2) G›Uvi| we:`ª:b2 ¯’‡j 64 wj‡L
w`‡jI Pj‡e)
|
eM©g~j [8] †ei Ki‡e
|
10
|
=A1+c3+e5 G›Uvi |
|
wfbœ wfbœ †m‡ji †hvMdj n‡e |
|
11
|
=if(C2>8, C2-8,0)Enter.
|
Ifvi UvBg †ei Ki‡e
|
12
|
=if(d2>0,d2*20+8*15,c2*15
|
IqvKv©i‡`i †c‡g›U †ei Ki‡e |
|
Logical Function: ‡h mKj
m~Î mg~n wbw`©ó †Kvb k‡Z©i Dci wfwË K‡i djvdj
cÖKvk K‡i ZvB hyw³MZ m~Î |
Ø GmKj
m~‡Î me©`v =if w`‡q
ïiæ Ki‡Z nq | †hgb := if (condition , xy) Enter.
Ø If Gi
mv‡_ ‡h Condition
_vK‡e †mwU mZ¨ n‡j 1g djvdj †`Lv‡e Avi False n‡j
c‡ii djvdj †`Lv‡e |
Ø If Gi ci
mgq First
Braket w`‡q ïiæ Ki‡Z n‡e |
Ø cª‡Z¨K
AvB‡Ug‡K ( , ) w`‡q ïiæ Ki‡Z n‡e | hZ¸‡jv If _vK‡e
dg~jvi †k‡l ZZwU eª¨v‡KU w`‡q Close Ki‡Z n‡e |
be Kw¤úDUvi GÛ d‡UvKwc,
cyivZb evmó¨Û, gvae`x nvB¯‹zj gv‡Vi cwðg cv‡k¦©, c„ôv bs-26
Ø GKvwaK
k‡Z© and `¦viv
hy³ Ki‡Z n‡j - If
eª¨v‡KU †`qvi ci And wj‡L Zvici Avevi eª¨v‡KU w`‡q ïiæ Ki‡Z n‡e Ges
Av¸©‡g›U¸‡jv eª¨v‡K‡U Close Ki‡Z n‡e | †cÖKwUm Kivi Rb¨ wb‡¤œ AviI KwZcq m~Î Aci
c„ôvq †`qv n‡jv :
1.
|
=if (b2>=100,''Thue”, “False”)
Enter v
|
hw`b2gvb100Õimgvb
ev Zvi †P‡q †ewk nq Zvn‡j True bv n‡j False ‡`L‡e |
|
2
|
=if(b5>50,”Good” Bad”) “
|
B5N‡i 50Õi †ewk n‡j Good,bq‡Zv
bad ‡`Lv‡e |
|
3
|
=if(b2>=2000,d2,
“Too Loo” )
|
d2‡Z 2000Gi mgvb ev †ewk n‡j H msL¨v em‡e wKš‘ Kg
n‡j Too Loo em‡e |
|
4
|
=if (And (1<B2, B2<100),B2, “None”) “
|
hw`b2gvb1Gi
†P‡q †ewk Ges 100Õi Kg nq Zvn‡j gvb †`Lv‡e b‡PrNone. wjLvwU
Avm‡e
|
or
|
=if(And(B2>1,B2<100),B2,''None'')''
|
|
5
|
=If(B2<100,B2,''None'')
|
hw` b2 gvb
100Õi Kg nq Zvn‡j gvb †`Lv‡e b‡Pr None ‡jLvwU Avm‡e
|
GmKj
wKQz MwYwZK m~Î e¨envi Kivi Rb¨ if Gi mv‡_ KwZcq KwZcq Acv‡iUi e¨eüZ
nq ‡hgb :
= mgvb
A_© cÖKvk K‡i | <= A‡cÿvK„Z †QvU ev mgvb eySvq|
> A‡cÿvK…Z eo eySvq | >= A‡cÿv mgvb ev eo eySvq |
< A‡cÿvK…Z †QvU eySvq | <> Amgvb eySvq |