**
Edit Menu **
_ BLOCK
Kiv t ‡h †jLv
e−K Ki‡Z Pvb †mj c‡q›Uvi †m †jLvi ïi“‡Z wb‡q gvD‡mi evg ‡evZvg †P‡c a‡i Drag
Ki‡j ‡jLv e−K n‡e| A_ev Shift Kx †P‡c a‡i ‡i‡L †h ‡Kvb Arrow Kx Pvc w`‡j †h Arrow Kx Pvc w`‡eb †mB w`‡Ki
†jLv e−K n‡e| GLv‡b D‡j−L¨ †h, e−K
Ki‡j Ab¨ †mj ¸‡jv Kvj †`Lv‡jI cÖg †h Cell
wU e−K Kiv nq †mwU mv`v †`Lv hvq|
Z‡e a‡i wb‡Z n‡e H cÖg Cell wU Block Kiv n‡q ‡M‡Q|
_ BLOCK
Zz‡j †`Iqv t Worksheet
Gi †h ‡Kvb hvqMvq gvDm wK¬K Ki‡j A_ev †h ‡Kvb Arrow
Kx Pvc w`‡j Block (e−K) D‡V hv‡e|
1.
Cut & Paste (‡jLv‡K ¯’vbvši—
Kiv) t
‡h mg¯’ Cell Gi †jLv‡K ¯’vbvš—i Ki‡Z
PvB †mB Cell ¸‡jv Block (e−K) K‡i
_ Edit
Click
_ Cut
Click Ki‡j H †jLv¸‡jvi Pvicv‡k GKiKg Lighting cª`wk©Z n‡e ZLb †h RvqMvq
¯’vbvš—i Ki‡Z PvB †mB
Cell Gi g‡a¨ Cursor ‡i‡L
_ Edit
Click
_ Paste
Click Ki‡jB Block
(e−K) Kiv †jLv¸‡jv ¯’vbvš—i n‡q Cursor ‡h RvqMvq ivLv n‡qwQj †mB
RvqMvq
¯’vwcZ n‡e|
NB t Avgiv AviI A‡bK c×wZ‡Z †jLv‡K
¯’vbvš—‡ii KvR Ki‡Z cvwi| cÖgZ t Standard
Tool Bar Gi gva¨‡g
Ges wØZxqZ t Key Board e¨envi K‡i| cÖ‡qvRb g‡b
Ki‡j c×wZ¸‡jv wk¶‡Ki wbKU †_‡K †R‡b wbb|
2.
Copy & Paste (GKB ‡jLv‡K
GKvwaKevi ¯’vcb Kiv) t
_ ‡h
mg¯’ Cell Gi
†jLv‡K GKvwaKevi ¯’vcb Ki‡Z PvB †mB Cell
¸‡jv Block
(e−K) K‡i
_ Edit
Click
_ Copy
Click Ki‡j H †jLv¸‡jvi Pvicv‡k GKiKg Lighting cª`wk©Z n‡e ZLb †h RvqMvq
GKvwaKevi ¯’vcb
Ki‡Z PvB †mB Cell Gi g‡a¨ Cursor ‡i‡L
_ Edit
Click
_ Paste
Click Ki‡jB Block
(e−K) Kiv †jLv¸‡jv Cursor ‡h RvqMvq ivLv n‡qwQj †mB
RvqMvq GKvwaKevi ¯’vwcZ
n‡e|
NB t Avgiv AviI A‡bK c×wZ‡Z †jLv‡K
GKvwaKevi ¯’vc‡bi KvR Ki‡Z cvwi| cÖgZ t Standard
Tool Bar Gi gva¨‡g
Ges wØZxqZ t Key Board e¨envi K‡i| cÖ‡qvRb g‡b
Ki‡j c×wZ¸‡jv wk¶‡Ki wbKU †_‡K †R‡b wbb|
3.
Paste Special (Ab¨ †Kvb †cÖvMÖvg
†_‡K G‡b G‡·‡j †c÷ Kiv) t
_ Spreadsheet
Analysis Software Microsoft Excel Gi g‡a¨
KvR Kivi mgq A‡bKmgqB Microsoft
Word Or Microsoft Access ‡_‡K †jLv‡K ‡có Kiv hvq| †h WvqvjM e· Avm‡e Zv‡Z Ok Click Ki‡jB
wbw`ªó Mode
G Paste
n‡e|
4.
Paste As Hyperlink (nvBcviwj¼
Gi g‡a¨ †c÷ Kiv) t
_ GB
Option wU Internet (B›Uvi‡bU) Gi Rb¨ cÖ‡qvRb
nq| Internet (B›Uvi‡bU)
ms‡hvM bv _vK‡j GB Option
wUi KvR Kiv m¤¢e b‡n| mPivPi GB Option wUi cÖ‡qvRb nq bv|
Microsoft Excel XP
Created By: Kamrul Hassan
Bappy Bappy Computer Education Centre
5.
Clear (†jLv ev Ae‡R± †gvQv) t
_ cÖ‡g
†h †jLv ev Ae‡R±‡K †gvQ‡Z PvB †mwU Block/Select
Kwi Zvici
_ Edit
Click
_ Clear
Gi g‡a¨ Mouse
Pointer wb‡q
_ All
Click Ki‡jB Block/Select
Kiv †jLv ev Ae‡R±wU †gv‡Q hv‡e| GB ‡gvQvi KvRwU
Avgiv Ab¨ c×wZ‡Z
Ki‡Z n‡j †jLv ev Ae‡R±‡K Block/Select Kivi ci KeyBoard Gi Delete Key Press Ki‡jB
†jLv ev
Ae‡R±wU †gv‡Q hv‡e|
6.
Undo (KgvÛ evwZj Kiv) t
_ GBgvÎ
cÖ‡qvM Kiv †Kvb Command (KgvÛ) evwZj Ki‡Z n‡j Avgiv Undo
Gi mvnvh¨ wb‡Z cvwi
_ Edit
Click
_ Undo
Click Ki‡j Clear/Delete
Gi gva¨‡g †gv‡Q †djv †jLvwU wd‡i Avm‡e A_ev GB
GKB Command
(KgvÛ) Gi gva¨‡g me©‡kl †`Iqv †h ‡Kvb
Command (KgvÛ)B
evwZj n‡q hv‡e|
NB t Avgiv AviI A‡bK c×wZ‡Z KgvÛ evwZj
Kivi KvR Ki‡Z cvwi| cÖgZ t Standard
Tool Bar Gi gva¨‡g
Ges wØZxqZ t Key Board e¨envi K‡i| cÖ‡qvRb g‡b
Ki‡j c×wZ¸‡jv wk¶‡Ki wbKU †_‡K †R‡b wbb|
7.
Redo (evwZj Kiv KgvÛ †dir wb‡q
Avmv) t
_ Undo
Gi gva¨‡g †Kvb Command
(KgvÛ) †K evwZj Kivi ci hw` GiKg g‡b nq †h Command (KgvÛ)wU
evwZj Kiv wVK nqwb ZLb
_ Edit
Click
_ Redo
Click Ki‡jB evwZj Kiv KgvÛwU †dir P‡j Avm‡e|
NB t Avgiv AviI A‡bK c×wZ‡Z evwZj Kiv KgvÛ
†dir wb‡q Avm‡Z cvwi| cÖgZ t Standard
Tool Bar Gi gva¨‡g
Ges wØZxqZ t Key Board e¨envi K‡i| cÖ‡qvRb g‡b
Ki‡j c×wZ¸‡jv wk¶‡Ki wbKU †_‡K †R‡b wbb|
8.
Delete …(CELL, ROW & COLUMN miv‡bv
I ‡gvQv) t
_ wbw`©ó
‡mj gy‡Q Wv‡b cv‡ki †jLv ev‡g mviv‡bv t
_ ‡h
Cell wU
†gvQ‡Z PvB †mwU Select K‡i
_ Edit
Click
_ Delete
Click
_ Shift
Cell Left Click
_ Ok
Click Ki‡jB Cursor
‡h Cell
Gi g‡a¨ wQj †mB Cell
wU †gv‡Q hv‡e Ges H Row Gi Aš—M©Z
Wvb w`‡Ki Ab¨vb¨ Cell ¸‡jv G‡m †gv‡Q hvIqv Cell wU c~ib Ki‡e|
_ wbw`©ó
‡mj gy‡Q wb‡Pi †jLv Dc‡i DVv‡bv t
_ ‡h
Cell wU
†gvQ‡Z PvB †mwU Select K‡i
_ Edit
Click
_ Delete
Click
_ Shift
Cell Up Click
_ Ok
Click Ki‡jB Cursor
‡h Cell
Gi g‡a¨ wQj †mB Cell
wU †gv‡Q hv‡e Ges H Column Gi
Aš—M©Z wb‡Pi w`‡Ki Ab¨vb¨ Cell ¸‡jv G‡m †gv‡Q hvIqv Cell wU c~ib Ki‡e|
_ wbw`©ó
GKwU †iv †gvQv t
_ ‡h
Row wU
†gvQ‡Z PvB †mB Row Gi Aš—M©Z †h †Kvb GKwU Cell
Gi g‡a¨ Cursor
‡i‡L
_ Edit
Click
_ Delete
Click
_ Entire
Row Click
_ Ok
Click Ki‡jB Cursor
‡h Row
Gi g‡a¨ wQj †mB Row
wU †gv‡Q hv‡e Ges wb‡Pi w`K †_‡K
Row ¸‡jv G‡m †gv‡Q hvIqv Row
wU c~ib Ki‡e|
_ wbw`©ó
GKwU Kjvg †gvQv t
_ ‡h
Column wU
†gvQ‡Z PvB †mB Column Gi Aš—M©Z †h †Kvb GKwU Cell
Gi g‡a¨ Cursor
‡i‡L
_ Edit
Click
_ Delete
Click
_ Entire
Column Click
_ Ok
Click Ki‡jB Cursor
‡h Column
Gi g‡a¨ wQj †mB Column
wU †gv‡Q hv‡e Ges Wvb w`K
†_‡K Column
¸‡jv G‡m †gv‡Q hvIqv Column wU c~ib Ki‡e|
9.
Delete Sheet (IqvK©kxU †gvQv) t
_ Avgiv
Rvwb †h †Kvb GKwU Book/File Gi g‡a¨ mvavibZ wZbwU Worksheet
_v‡K| cieZ©x‡Z Avgiv Bnv bZzb K‡i ˆZix
Ki‡Z cvwi, ‡gvQ‡Z cvwi Ges GKB kx‡Ui
GKvwaK Kwc ˆZix Ki‡Z cvwi| GQvovI kx‡Ui AviI A‡bK wKQy Kiv hvq| Avgiv
GLb †gvQv wkLe Ges kx‡Ui Ab¨vb¨ KvR
wkLe cieZ©x‡Z| Worksheet †gvQvi Rb¨ Avgiv †h Worksheet wU †gvQ‡Z PvB
†mwU Select
K‡i Zvici
_ Edit
Click
_ Delete
Sheet Click
_ Ok
Click Ki‡jB Select
Kiv Worksheet
wU †gv‡Q hv‡e| †gvQv Worksheet KLbI †dir Avbv hvq bv|
10.
Move Or Copy Sheet (GKB
kx‡Ui GKvwaK Kwc ˆZix Kiv) t
_ Avgiv
Rvwb †h †Kvb GKwU Book/File Gi g‡a¨ mvavibZ wZbwU Worksheet
_v‡K| cieZ©x‡Z Avgiv Bnv bZzb K‡i ˆZix Ki‡Z
cvwi, ‡gvQ‡Z cvwi Ges GKB kx‡Ui
GKvwaK Kwc ˆZix Ki‡Z cvwi| GQvovI kx‡Ui AviI A‡bKwKQy Kiv hvq| Avgiv GLb GKB
kx‡Ui GKvwaK Kwc ˆZix Kiv wkLe Ges
kx‡Ui Ab¨vb¨ KvR wkLe cieZ©x‡Z| GKB kx‡Ui GKvwaK Kwc ˆZix Kivi Rb¨ Avgiv †h
Worksheet Gi GKvwaK Kwc ˆZix Ki‡Z PvB †mwU Select
K‡i Zvici
_ Edit
Click
_ Move
Or Copy Sheet Click Ki‡j Move Or Copy Dialog Box Avm‡e
ZLb †h Book/File Gi
g‡a¨
KvR Kiv n‡”Q †mwU Select K‡i Gi Aaxb¯’ †Kvb Sheet Copy Kie †mwU Select K‡i Zvici
_ Create
A Copy Box G (_) wPý w`‡q
_ Ok
Click Ki‡jB H kx‡Ui Abyiƒc Av‡iKwU Kwc ˆZix n‡e| Gi
d‡j hw` GKwU Worksheet Delete n‡q hvq
Z‡e Kwc Kiv Ab¨ Worksheet wU w`‡q KvR Kiv hv‡e|
11.
Find (kã †LuvRv) t
_ ‡jLv
ev dvB‡ji ïi“‡Z Cursor ‡i‡L
_ Edit
Click
_ Find
Click Ki‡j Find
Dialog Box Avm‡e ZLb Find What Box Gi g‡a¨ †h Word wU LyuR‡Z n‡e Zv wj‡L
_ Find
Next Click Ki‡j hw` H Word wU Luy‡R cvIqv hvq Zvn‡j Word wU †h Cell Gi g‡a¨ Av‡Q Cursor H
Cell Gi g‡a¨ P‡j hv‡e| cieZ©x‡Z c~bivq
_ Find
Next Click Ki‡j hw` H Word wU GKvwaKevi _v‡K Ges
Luy‡R cvIqv hvq Zvn‡j Word wU †h †h Cell
Gi g‡a¨ Av‡Q Cursor H mKj Cell Gi g‡a¨ G‡K G‡K P‡j hv‡e|
†LvRv †kl n‡j
_ Close
Click Ki‡jB Find
Dialog Box P‡j hv‡e|
[ NB t Find KgvÛ Avgiv Key Board Gi gva¨‡g w`‡Z cvwi| Find
KgvÛ Gi Key
Board Key n‡jv Ctrl
+ F ]
12.
Replace (kã cÖwZ¯’vcb Kiv) t
_ ‡jLv
ev dvB‡ji ïi“‡Z Cursor ‡i‡L
_ Edit
Click
_ Replace
Click Ki‡j Replace
Dialog Box Avm‡e ZLb Find What Box Gi g‡a¨ †h Word wU cÖwZ¯’vcb
Ki‡Z n‡e Zv wj‡L Ges Replace With Box Gi g‡a¨
cÖwZ¯’vcb K‡i hv emv‡Z PvB Zv wj‡L
_ Find
Next Click Ki‡j hw` H Word wU Luy‡R cvIqv hvq Zvn‡j Word wU †h Cell Gi g‡a¨ Av‡Q Cursor H
Cell Gi g‡a¨ P‡j hv‡e| cieZ©x‡Z
_ Replace
Click Ki‡j †h Cell
Gi g‡a¨ Cursor
_vK‡e H Cell
Gi †jLvwU cÖwZ¯’vwcZ n‡e| Ges Replace All
Click Ki‡j †h Cell Gi g‡a¨ Cursor _vK‡e H Cell Gi †jLvwU GKvwaKevi _vK‡j me¸‡jv GKmv‡_ cÖwZ¯’vwcZ
n‡e| g‡bi B‡”QgZ cÖwZ¯’vcb Kiv †kl
n‡j
_ Close
Click Ki‡jB Replace
Dialog Box P‡j hv‡e|
NB t Replace KgvÛ Avgiv Key Board Gi gva¨‡g w`‡Z cvwi| Replace
KgvÛ Gi Key
Board Key n‡jv Ctrl
+ H
13. Go To (wbw`©ó †Kvb †m‡j hvIqv) t
_ Avgiv
Rvwb Spreadsheet Analysis Software Microsoft
Excel Gi g‡a¨ cÖ‡Z¨KwU Worksheet
(IqvK©kxU)
G 256 wU Column (Kjvg) Ges 65536 wU Row (†iuv) _v‡K| KvR Kivi mgq
Avgv‡`i Lye ZvovZvwo †h †Kvb
Cell (†mj) Gi g‡a¨ hvIqvi cÖ‡qvRb n‡e| GRb¨
_ Edit
Click
_ Go
To Click Ki‡j Go
To Dialog Box Avm‡e ZLb Reference Box Gi g‡a¨ †h Cell G †h‡Z PvB †mB
Cell Address wj‡L
_ Ok
Click Ki‡jB Cell
Address Abymv‡i Cursor
wbw`ªó Cell
Gi g‡a¨ P‡j hv‡e|
[ NB t Go To KgvÛ Avgiv Key Board Gi gva¨‡g w`‡Z cvwi| Go
To KgvÛ Gi Key
Board Key n‡jv Ctrl
+ G. ]
No comments:
Post a Comment