Microsoft Office Excel - 2003
gvB‡µvmdU Awdm c¨v‡K‡Ri Aax‡b †ek K‡qKwU Kvh©Kix
mdUIq¨vi Av‡Q, G¸‡jvi g‡a¨ wnmve wbKv‡ki Rb¨ wba©vwiZ GKwU c~Y©v½ mdUIq¨vi n‡jv
gvB‡µvmdU G‡·j| GB mdUIq¨vi w`‡q IqvW© cÖ‡mwms ev B‡gR cÖ‡mwms msµvšÍ †Kvb KvR
Kiv hvq bv| Z‡e WvUv wfwËK †h †Kvb MvwYwZK Kvh©vejx `ªæZ Ges wbf~©jfv‡e mnR
c×wZ‡Z Kiv hvq|
Excel n‡”Q Microsoft Corporation KZ…©K evRviK…Z GKwU Spreedsheet Analyses Program. GwU ev¯Íe
Rxe‡bi MvwYwZK mgm¨v mgvav‡bi GKwU †kªô †cÖvMÖvg wnmv‡e cwiwPZ|
Microsoft Excel Gi dvBj‡K e‡j IqvK© eyK| cÖwZwU IqvK©ey‡K _v‡K
KwZcq IqvK©kxU| cÖwZwU IqvK©kx‡U _v‡K 65536 (Qq nvRvi cuvPkZ QwÎk wU †iv) Ges
256 (`yBkZ Qvàvbœ) wU Kjvg| WvUv‡eR g¨v‡bR‡g›U †cÖvMÖv‡gi b¨vq G‡·‡ji IqvK©kx‡U
†iv Ges Kjvg Abymv‡i myk„sLjfv‡e WvUv Gw›Uª Kiv hvq| Gw›UªK…Z WvUvi Dc‡i
cÖ‡qvRbxq MvwYwZK K¨vjKz‡jkb Kiv hvq, WvUvi wfwˇZ PvU© ˆZix Kiv hvq| wewfbœ
ai‡bi Z_¨ Dc¯’vcb Kiv hvq| RwUj K¨vjKz‡jkb mn‡R mgvavb I we‡kølY Kiv hvq|
How to Run Microsoft
Excel ?
wKfv‡e gvB‡µvmdU Pvjy Ki‡eb ?
ðClick Start Ø Select Program Ø Click Microsoft Excel.
2) How to Exit From MS
Excel ?
G‡·j †_‡K wK fv‡e †ei n‡Z nq?
ðClick File Ø Click Close Ø Click File ØClick Exit
3) How to Save a File ? wKfv‡e GKwU dvBj msiÿY Ki‡Z nq?
ðClick File (Ctrl+S) Ø Click Save Ø Type Your File Name Ø Click Save
4) How to Close a File ? wKfv‡e GKwU dvBj eÜ Ki‡Z nq?
ðClick File Ø Click Close
5) How to Open a File ? wKfv‡e GKwU dvBj †ei Ki‡Z nq?
ðClick File (Alt+F) Ø Click Open (Alt+O) ØSelect Your Choiceable
File Ø
Click Open
6) How to See Print Preview
in a Document ?
wcÖ›U Kivi c~‡e© WKz‡g›U wK fv‡e wcÖ›U n‡e †mUv †`Lv ?
ðClick File Ø Click Print Preview
7) How to Define Block ? wKfv‡e eøK wba©vib Kiv hvq ?
ðTake the Cursor in Your
Desire Text Ø Press Shift Ø Arrow Key.
8) How to Edit Page Setup
? wKfv‡e †cR †mUAvc cwieZ©b Kiv
hvq ?
ðClick File Ø Click Page Setup Ø Select Your Choice-able
Page From Paper Size Ø Select Margin, Header & Footer on
That Page Ø Click Save/Ok.
9) How to Use the
Gridlines for a Document ? WKz‡g‡›U
wK fv‡e wMÖW jvBb e¨envi Kiv hvq?
ðClick File > Click
Page Setup Ø Click Sheet Ø Select Gridlines for
Printing Lines Ø Select Page Order Ø Click Ok.
10) How to Print Row
& Column Heading in a Document ? WKz‡g‡›U wK fv‡e †iv Ges Kjvg †nwWs e¨envi Kiv nq?
ðClick File Ø Click Page Setup Ø Click Sheet Ø Select Row & Column
Heading Ø
Click Ok
11) How to Insert Current
Date in a Document ?
WKz‡g‡›U wKfv‡e
eZ©gvb ZvwiL e¨envi Kiv hvq ?
ðType = Today ()Ø Press Enter Press Ctrl +
;
12) How to Insert Current
Time in a Document ?
wKfv‡e WKz‡g‡›U
eZ©gvb mgq e¨envi Kiv hvq ?
ðType = Now () Press Enter
Or Press Ctrl + Shift + :
13) How to Undo a Command
? gy‡Q hvIqv wjLv wK fv‡e wdwi‡q
Avbv hvq ?
ðClick Edit Ø Click Undo Or Press
(Ctrl + Z)
14) How to Copy &
Paste a Text ?
wKfv‡e Kwc Kiv †jLv
†Rvov †`Iqv hvq ?
ðSelect the Text in the
Cell by the Cursor Ø Click Edit Ø Click Copy or Press
(Ctrl + C) Ø Select the Cell Where You Want to Paste Ø Click Edit Ø Click Paste or Press
(Ctrl + V)
15) How to Cut &
Paste a Text ?
wKfv‡e KvU Kiv †jLv
†Rvov †`Iqv hvq ?
ðSelect the Text in the
Cell by the Cursor Ø Click Edit Ø Click Cut or Press (Ctrl
+ X) Ø
Select the Cell Where You Want to Paste Ø Click Edit Ø Click Paste Or Press
(Ctrl + V)
16) How to Use Fill
Command ?
wKfv‡e wdì KgvÛ
e¨envi Kiv hvq ?
ðType a Series of
Number/Month/Day Ø Select the Cell Ø Drug the Mouse With Free
Handle Where to Finish And Release The Mouse.
17) How to Clear Command
Text ? wKfv‡e †jLv †gvQv hvq ?
ðSelect the Cell Ø Press Delete
18) How to Insert Row in
a Document ?
WKz‡g‡›Ui gv‡Q wK
fv‡e GKwU †iv hy³ Kiv hvq?
ðPlace the Cursor Where to Insert Row Ø Click Insert Ø Click Row.
19) How to Delete Row in
a Document ?
WKz‡g›U †_‡K wK
fv‡e GKwU †iv gy‡Q †`Iqv hvq?
ðSelect the Cell of the
Row Ø
Click Edit Ø Click Delete Ø Select Delete Ø Entire Row Ø Click Ok
20) How to Insert Column
In A Document ?
wKfv‡e WKz‡g‡›Ui
g‡a¨ GKwU Kjvg hy³ Kiv hvq?
ðClick Insert Ø Click Column
21) How to Delete Column
in a Document ?
WKz‡g›U †_‡K wK
fv‡e GKwU Kjvg gyQv hvq ?
ðSelect the Cell of the
Column Ø
Click Edit Ø Click Delete Ø Select Delete Entire
Column Ø
Click Ok
22) How to Hide Row in a
Document ?
WKz‡g‡›U wK fv‡e
1wU †iv †K jyKv‡bv hvq?
ðSelect the Cell of the
Row Which You Want Hide Ø Click Format Ø Select Row Ø Click Hide
23) How to Unhide Row in
a Document ?
wKfv‡e WKz‡g‡›Ui
jyKv‡bv †iv †K wdwi‡q Avbv hvq ?
ðSelect Cell both Side of
the Hide Row Ø Click Format Ø Select Row Ø Click Unhide
24) How to Hide Column in
a Document ?
WKz‡g‡›U wKfv‡e
Kjvg jyKv‡bv hvq ?
ðSelect The Cell of The
Column Which You Want Hide Ø Click Format Ø Select Column Ø Click Hide
25) How to Unhide Column
in a Document ?
wK fv‡e WKz‡g‡›Ui
jyKv‡bv Kjvg †K wdwi‡q Avbv hvq ?
ðSelect Both Side of the
Hide Column Ø Click Format Ø Select Column Ø Click Unhide
26) How to Insert Cell in
a Document ?
WKz‡g‡›U wK fv‡e
GKwU †mj hy³ Kiv hvq ?
ðPlace the Cursor Where to
Insert Cell Ø Click Insert Ø Click Cell Ø Select the ‘Shift Cell
Right’ Ø
Click Ok
27) How to Delete Cell in
a Document ?
WKz‡g‡›U wK fv‡e
GKwU †mj †gvQv hvq ?
ðSelect the Cell >
Click Edit Ø Click Delete Ø Select Entire Cell Ø Ok.
28) How to Insert Work
Sheet ? WKz‡g‡›U wK fv‡e GKwU IqvK© mxU
†gvQv hvq ?
ðPlace the Cursor Where to
Insert Work Sheet Ø Click Insert Ø Click Work Sheet
29) How to Delete Work
Sheet ? wKfv‡e IqvK© kxU †gvQv hvq ?
ðSelect a Sheet Ø Click Edit Ø Click Delete Sheet Ø Click Ok.
30) How to Copy a Sheet ? wK fv‡e GKwU IqvK© kxU Kwc Kiv
hvq ?
ðSelect the Sheet Ø Click Edit Ø Select Move or Copy
Sheet Ø
Click the Box of Create Copy Ø Click Ok
31) How to Move a Sheet ? wK fv‡e GKwU mxU miv‡bv hvq ?
ðSelect the Sheet Ø Click Edit Ø Select Move or Copy
Sheet Ø
Select the Sheet Number Before Which You Want to Replace the Sheet.
32) How to Find a Word ? wKfv‡e GKwU kã †LuvRv hvq ?
ðClick Edit Ø Click Find Ø Type the Word in the
Find What Box That You Find Ø Click Find Next Ø Click Close.
33) How to Replace a Word
? wKfv‡e GKwU kã cwieZ©b Kiv hvq?
ðClick Edit Ø Click Replace Ø Type the Word in the
Find What Box The You Want to Find Ø Click Find Next Ø Type the Word in the
Replace With Box that You Want to Replace Ø Click Replace Or Replace
All.
34) How to Use Go To
Command ?
wKfv‡e †Mv Uz KgvÛ
e¨envi Kiv hvq ?
ðClick Edit > Click Go
To Ø
Write The Cell Address Ø Click Ok.
35) How to Rename a Sheet
? wKfv‡e GKwU mx‡Ui bvg cwieZ©b
Kiv hvq ?
ðDouble Click on The
‘Sheet Tab’ Ø Write A New Name Ø Click Ok.
36) How to Change Font,
Size, Style, Color in a Document ? wKfv‡e WKz‡g‡›U d›U, mvBR, Kvjvi I ÷¨vBj cwieZ©b Kiv hvq ?
ðSelect The Text Ø Click Format Ø Select Cell Ø Click Font Ø Select Font, Size,
Style, Color Ø Click Ok.
37) How to Format the
Cell Number ?
wKfv‡e †m‡ji g‡a¨
†jLv b¤^i di‡gU nq ?
ðSelect the Cell Ø Click Format Ø Click Cell Ø Click Number Ø Select the Category for
the Text Ø
Select Format Code Ø Click Ok
38) How to Alignment ? wKfv‡e GjvBb‡g›U Kiv hvq ?
ðClick Format Ø Click Cell Ø Click Alignment Ø Select the Horizontal
Alignment Ø Select the Orientation Ø Click Ok
39) How to Fomat Border ? wKfv‡e eW©vi di‡gU Kiv hvq ?
ðClick Format Ø Click Cell Ø Click Border Ø To Select the Border
Style Click In the Style Box and Select
40) How to Format Pattern
? wKfv‡e c¨vUvb© di‡gU Kiv hvq ?
ðClick Format Ø Click Cell Ø Click Pattern Ø Select Color Ø Click Ok
41) How to Format Row
Height ?
wKfv‡e †iv Gi D”PZv
di‡gU Kiv hvq ?
ðSelect the Row Ø Click Format Ø Select Row Ø Click Height Ø Write the Row Height Ø Click Ok.
42) How to Format Column
With ? wKfv‡e Kjv‡gi cÖ¯’ di‡gU Kiv hvq
?
ðSelect the Column Ø Click Format Ø Select Column Ø Click Width Ø Write the Column Width Ø Click Ok.
43) How to Auto Fit a
Text in a Column ?
wKfv‡e Kjv‡gi g‡a¨
†U·U ¯^qswµq ivL‡Z nq ?
ðSelect the Column Ø Click Format Ø Select Column Ø Click Auto Fit
44) How to Auto Format a
sheet ? wK fv‡e GKwU mxU‡K ¯^qswµq di‡gU
Kiv hvq ?
ðSelect the Sheet Ø Click Format Ø Click Auto Format Ø Select format from “Auto
format” Ø
Click Ok.
45) How to Insert Picture
? wKfv‡e GKwU Qwe mshy³ Kiv hvq ?
ðClick Insert ØSelect Picture Ø Click Clip Art Ø Select Picture Ø Click Insert Ø Click Close.
46) Calculation : wb‡Pi KgvÛ wb‡q KvR Kivi mgq
wba©vwiZ †m‡j Aek¨B msL¨v ewm‡q KgvÛ cÖ‡qvM Ki‡Z n‡e Ab¨_vq †iRvë cvIqv hv‡e
bv|
1| mvaviY †hvM Kivi wbqg t- = Sum(1st digit
+ 2nd digit)Enter
2| mvaviY we‡qvM Kivi wbqg t- = Sum(1st digit
- 2nd digit)Enter
3| mvaviY ¸Y Kivi wbqg t- = Sum(1st digit
* 2nd digit)Enter
4| mvaviY fvM Kivi wbqg t- = Sum(1st digit / 2nd
digit)Enter
5| kZKiv †ei Kivi wbqg t- = Sum (1st digit
* 5%/10%/7%) Enter
1)
Count t GK‡Î KZ¸‡jv msL¨v †ei Kiv|
ð wbqg t (m~Î = Count(A1:E78)Enter
2)
Average t A‡bK ¸‡jv msL¨vi Mo †ei Kiv|
ð wbqg t msL¨v¸‡jvi wb‡P Kvimvi †i‡L (m~Î = Average (A1:A5) Enter
3)
Max t
A‡bK ¸‡jv msL¨vi g‡a¨ me‡P‡q eo msL¨v †ei Kiv|
ð wbqg t msL¨v¸‡jvi wb‡P Kvimvi †i†L (m~Î = Max (A1:A5) Enter
4)
Min t A‡bK ¸‡jv msL¨vi g‡a¨ me‡P‡q
†QvU msL¨v †ei Kiv|
ðwbqg t msL¨v¸‡jvi wb‡P Kvimvi †i†L (m~Î = Min(A1:A5) Enter
= ev¯Íe †¶‡Î Excel
Gi e¨envi =
= (AsK bs # 1) =
General Salary Sheet : (‡eZb wbY©q) t
GLb Pjyb GKwU cÖwZôv‡bi Kg©Pvix‡`i †eZb wbY©q Kiv hvK|
g‡b Kwi cÖwZôv‡bi Kg©KZ©v‡`i †eZ‡bi cvkvcvwk weµ‡qi Dci 10% Kwgkb †`Iqv nq|
myZivs g~j †eZ‡bi mv‡_, †gvU weµ‡qi Dci 10% Kwgkb wbY©q K‡i †hvM Ki‡Z n‡e| Pjyb
Sheet wU ‰Zix Kiv hvK t-
ðwb‡Pi Q‡Ki g‡Zv GKwU Work Sheet ‰Zix Kiæb
A
|
B
|
C
|
D
|
|
1
|
Name
|
Salary
|
Sales
|
Total Pay
|
2
|
David
|
4200
|
12000
|
|
3
|
Michel
|
3500
|
32000
|
|
4
|
Ruddro
|
7000
|
7000
|
|
5
|
Khna
|
7900
|
||
6
|
Aharish
|
4800
|
53000
|
|
7
|
Roy
|
4000
|
3000
|
ðGLb D2 ‡m‡j c‡q›Uvi †i‡L dg©~jv UvBc Kiæb t = B2+C2*10% Ges Enter Pvcyb| D2 ‡m‡j Total
Payment cvIqv hv‡e|
ðD2 ‡m‡j wm‡j± _vKv Ae¯’vq †gby †_‡K Edit > Copy
KgvÛ w`b|
ðD3 ‡_‡K D8 ‡mj ch©šÍ Block K‡i
= (AsK bs # 2) =
(weµ‡qi Dci Kwgkb wbY©‡qi AsK)
cÖ‡R± t Pjyb GKwU weµq dv‡g©i Kwgkb †ei
Kiv hvK| G‡¶‡Î weµq Kgx©‡`i wewµi cwigv‡Yi Dci Kwgkb wba©viY Kiv n‡e| kZ© n‡”Q
hw` weµq 10,000 UvKvi mgvb ev Kg nq Z‡e Kwgkb 5%| hw` weµq 20,000 UvKvi mgvb ev
Zvi Kg nq Z‡e Kwgkb 7%| hw` weµq 30,000 UvKvi mgvb ev Zvi Kg nq Z‡e Kwgkb 10%|
hw` weµq 40,000 UvKvi mgvb ev Zvi Kg nq Z‡e Kwgkb 12% Ges hw` weµq 40,000 UvKvi
†ekx nq Z‡e Kwgkb 15%|
Pjyb ïiæ Kiv hvK t
ð ûeû wb‡Pi g‡Zv GKwU Work Sheet ‰Zix Kiæb|
A
|
B
|
C
|
|
1
|
Name
|
Sales
|
Commission
|
2
|
David
|
21000
|
|
3
|
Michel
|
8000
|
|
4
|
Ruddro
|
51000
|
|
5
|
Khan
|
47000
|
|
6
|
Aharish
|
31000
|
ð C2 ‡m‡j c‡q›Uvi †i‡L UvBc Ki|
=IF(B2<=10000,B2*5%,IF(B2<=20000,B2*7%,IF(B2<=30000,B2*10%,IF(B2<=40000,B2*12%,IF(B2>40000,B2*15%)))))Ges Enter w`b|
ð C2 ‡m‡j c‡q›Uvi †i‡L Edit>Copy KgvÛ w`b|
ð C3 ‡mj †_‡K C6 ch©šÍ eøK K‡i Edit>Past KgvÛ w`b| mg¯Í †m‡j djvdj cvIqv
hv‡e|
djvdj t
A
|
B
|
C
|
|
1
|
Name
|
Sales
|
Commission
|
2
|
David
|
21000
|
2100
|
3
|
Michel
|
8000
|
400
|
4
|
Ruddro
|
51000
|
7650
|
5
|
Khna
|
47000
|
7050
|
6
|
Aharish
|
31000
|
3720
|
= (AsK bs # 3) =
(kZ© Abyhvqx gvwmK wKw¯Í †ei Kiv)
ð wb‡Pi Z_¨wU wjLyb t
Loan Amount
|
30000
|
Rate of interest
|
13%
|
Period (monthly)
|
18
|
Payment
|
ð ‡c‡g›U Gi dvKv N‡i Kvm©i ivLyb|
ð Insert G wK¬K
ð Function G wK¬K
ð Dialog box Avm‡e
ð e· Gi Mv‡q †P‡c a‡i e·Uv‡K
Wvbw`‡K mwi‡q wbb|
ð ‡iU 13% Gi Dci wK¬K K‡i
wjLyb/12
ð Nper 18 Gi Dci wK¬K Kiæb
ð PV ‡Z GKwU gvBbvm wPý wjLyb Zvici 30000 Gi Dci wK¬K Kiæb
ð Gici Ok †Z wK¬K Kiæb
ð Avcbvi Kvw•LZ djvdj †c‡q hv‡eb|
= (AsK bs # 4) =
(Electricity
Bill wbY©q)
wbðq Rv‡bb †h, we`y¨r we‡ji †¶‡Î BDwbU e¨env‡ii Dci wej
ˆZix Kiv n‡q _v‡K| G‡¶‡Î e¨eüZ BDwb‡Ui cwigv‡bi Dci wej wbf©i K‡i| kZ© n‡”Q hw`
we`y¨r LiP 1 BDwbU †_‡K 200 BDwbU ch©šÍ nq, Zvn‡j 1.75 UvKv cÖwZ BDwbU, 201
†_‡K 400 BDwbU ch©šÍ 2.50 UvKv cÖwZ BDwbU, 401 †_‡K 500 BDwbU ch©šÍ 3.75 UvKv
Ges 500 BDwb‡Ui Dc‡i n‡j 4.50 UvKv cÖwZ BDwbU| Pjyb we`y¨r wej ˆZix Kiv hvK t
ð
cÖ_‡g ûeû wb‡Pi g‡Zv GKwU Workbook ‰Zix Kiæb|
1
|
Name
|
Meter No
|
Unit
|
Bill
|
2
|
David
|
1
|
23
|
|
3
|
Michel
|
2
|
187
|
|
4
|
Ruddro
|
3
|
306
|
|
5
|
Khna
|
4
|
900
|
|
6
|
Aharish
|
5
|
703
|
|
7
|
Roy
|
6
|
409
|
|
8
|
Hasan
|
7
|
55
|
|
9
|
Aristotol
|
8
|
203
|
|
10
|
Ram
|
9
|
175
|
ð=IF(C2<=200,C2*1.75,IF(C2<=400,C2*2.50,IF(C2<=500,C2*3.75,IF(C2>500,C2*4.50)))) Ges Enter w`b|
ð D2 †m‡j djvdj cvIqv hv‡e|
= (AsK bs # 5) =
(Result Sheet ‰Zwi Kivi c×wZ )
cÖ‡R±
t GKwU K‡j‡Ri cixÿvi djvdj †ei Kiv n‡e| Bangla, Englisg, Math G wZbwU wel‡q cÖvß †gvU bv¤^v‡ii
Dci wfwË K‡i hviv 180
ev Zvi Dc‡i bv¤^vi cv‡e
Zviv 1st
Class, 135 n‡Z 179 bv¤^vi ‡c‡j Zviv 2nd Class, 99 ‡_‡K 134 bv¤^vi †c‡j Zviv 3rd Class, 99 Gi Kg †c‡j Zviv AK…ZKvh© (Fail) Ges †h‡Kvb wel‡q 33 bv¤^vi Gi Kg †c‡j Zv‡`i‡K
AK…ZKvh© (Fail)
aiv n‡e|
Ü cÖ_‡g wb‡Pi gZ ûeû GKwU WorkBook ‰Zwi Kiæb |
A
|
B
|
C
|
D
|
E
|
F
|
G
|
|
1
|
Roll
No.
|
Name
|
Bangla
|
English
|
Math
|
Total
|
Result
|
2
|
101
|
Asraf
|
47
|
53
|
55
|
||
3
|
102
|
Rahim
|
60
|
72
|
50
|
||
4
|
103
|
Mahabub
|
70
|
65
|
65
|
||
5
|
104
|
Tanvir
|
40
|
55
|
35
|
||
6
|
105
|
Masum
|
45
|
30
|
49
|
||
7
|
106
|
Safiq
|
46
|
76
|
34
|
||
8
|
107
|
Mohsin
|
68
|
72
|
80
|
||
9
|
108
|
Radhid
|
45
|
31
|
55
|
܇mj c‡q›Uvi F2 ‡m‡j ivLyb|
ð=Sum(C2+D2+E2)
Ø
Click Enter.
Ü ‡mj c‡q›Uvi G2 ‡m‡j ivLyb|
ð=IF(C2<33,"Fail",IF(D2<33,"Fail",IF(E2<33,"Fail",IF(F2<99,"Fail",IF(F2<=134,"3rd
Class",IF(F2<=179,"2nd Class",IF(F2>=180,"1st
Class")))))))Ø Click Enter.
ÜG2 ‡m‡j djvdj cvIqv hv‡e|
ðG2 ‡m‡j c‡q›Uvi †i‡L Edit>Copy KgvÛ w`b|
ðG3 ‡mj †_‡K G9 ch©šÍ eøK K‡i Edit>Past KgvÛ w`b| mg¯Í †m‡j djvdj cvIqv
hv‡e|
ev¯Íe †¶‡Î Excel Gi e¨envi
mgvavb-1
gvwmK Avq 10,000/- UvKv n‡j 2% AvqKi, 15,000/- UvKv
ch©šÍ 3%, 20,000/- UvKv ch©šÍ 5%, 30,000/- UvKv ch©šÍ 7% Ges 30,000/- UvKvi
†ekx Av‡qi Rb¨ 10% AvqKi w`‡Z n‡e|
A
|
B
|
C
|
|
1
|
Name
|
Monthly Income
|
Income tax
|
2
|
Faruk
|
20000
|
|
3
|
Hasan
|
12000
|
|
4
|
Saddam
|
30000
|
|
5
|
Purobi
|
11000
|
mgvavb-2
e¨vsK †_‡K 10,000/- UvKv ch©šÍ ‡jvb wb‡j 2% my` w`‡Z
n‡e, 15,000/- UvKv ch©šÍ 3%, 20,000/- UvKv ch©šÍ 4%, 30,000/- UvKv ch©šÍ 5% Ges
30,000/- UvKvi †ekx †jv‡bi Rb¨ 7% my` w`‡Z n‡e| wb‡¤œi Z_¨ †_‡K cÖ‡Z¨‡Ki my`
wbY©q Kiæb|
A
|
B
|
C
|
|
1
|
Name
|
Lone Amount
|
Interest
|
2
|
Faruk
|
20000
|
|
3
|
Hasan
|
12000
|
|
4
|
Saddam
|
30000
|
|
5
|
Purobi
|
11000
|
|
6
|
Joea
|
13500
|
mgvavb-3
hw` cÖwZ kªwgK 8N›Uv KvR Kivi Rb¨ 600/- UvKv cvwikªwgK
cvq Ges AwZwi³ Kv‡Ri Rb¨ cwZ N›Uvq 100/- UvKv cvwikªwgK cvq| Z‡e, wb‡æi kªwgKMY
cÖ‡Z¨‡K KZ UvKv cvwikªwgK cv‡e?
A
|
B
|
C
|
D
|
|
1
|
Name
|
Work Hour
|
Over Time
|
Total Wages
|
2
|
Faruk
|
14
|
||
3
|
Hasan
|
10
|
||
4
|
Saddam
|
12
|
||
5
|
Purobi
|
13
|
||
6
|
Joea
|
9
|
mgvavb-4
ïb¨ †_‡K 200 BDwbU we`y¨r e¨env‡ii Rb¨ MÖvnK‡K 1.75 UvKv
we`y¨r wej w`‡Z n‡e| 201 †_‡K 400 BDwbU ch©šÍ we`y¨r wej 2.50 UvKv, 401 †_‡K
500 BDwbU ch©šÍ we`y¨r wej 3.75 UvKv, 500 BDwb‡Ui †ekx n‡j 4.50 UvKv nv‡i
we`y¨r wej w`‡Z n‡e| GQvov f¨vU 15% I mvwf©m PvR© 2% nv‡i MÖvnK‡K AwZwi³ UvKv
cwi‡kva Ki‡Z n‡e| wb‡æi Z_¨ †_‡K we`y¨r wej ˆZix Kiæb|
A
|
B
|
C
|
D
|
E
|
F
|
G
|
H
|
|
1
|
Meter No
|
Present Reading
|
Previous Reading
|
Total Use
|
Principal Amount
|
Vat (15%)
|
Service
Charj(2%)
|
Amount Paid
|
2
|
101
|
1120
|
1000
|
|||||
3
|
102
|
7150
|
6996
|
|||||
4
|
103
|
2000
|
1125
|
|||||
5
|
104
|
8444
|
8222
|
|||||
6
|
105
|
1026
|
0684
|
|||||
7
|
106
|
4185
|
3420
|
|||||
8
|
107
|
5274
|
4688
|
|||||
9
|
108
|
4521
|
3520
|
mgvavb-5
wb‡æi kZ©¸wj AbymiY K‡i Avgiv †eZb kxU ‰Zix Ki‡ev| GLv‡b
cÖ‡Z¨K PvKzwiRxex evwo fvov, wPwKrmv fvZv, hvZvqvZ fvZv D‡Ëvjb K‡ib Ges fwel¨r
Znwej Ges Ki †eZb ‡_‡K KZ©b Kiv nq| kZ©¸wj wbæiƒct
Basic
|
House Rent
|
Medical
|
Transport
|
Provident Fund
|
Tax
|
1,0000/- UvKvi Kg
|
20%
|
3%
|
5%
|
1%
|
0
|
1,0000/- UvKv †_‡K 15,000/- UvKvi Kg
|
25%
|
5%
|
7%
|
3%
|
2%
|
15,000/- UvKv †_‡K 20,000/- UvKvi Kg
|
30%
|
7%
|
8%
|
5%
|
3%
|
20,000/- UvKv †_‡K 25,000/- UvKvi Kg
|
35%
|
9%
|
9%
|
7%
|
5%
|
25,000/- UvKv †_‡K 30,000/- UvKvi Kg
|
38%
|
10%
|
12%
|
9%
|
7%
|
30,000/- UvKvi mgvb Ges †ekx
|
40%
|
12%
|
15%
|
10%
|
9%
|
A
|
B
|
C
|
D
|
E
|
F
|
G
|
H
|
I
|
J
|
|
1
|
Name
|
Basic
|
H. Rent
|
M. Alu
|
T. Alu
|
Total Pay
|
P.F
|
Tax
|
Total Decrease
|
Basic Salary
|
2
|
Faruk
|
25000
|
||||||||
3
|
Hasan
|
15000
|
||||||||
4
|
Saddam
|
12000
|
||||||||
5
|
Purobi
|
10000
|
||||||||
6
|
Joea
|
25000
|
Microsoft Office Excel – 2007
“OLD
IS GOLG” IS OUR ALWAYS CONCEDT. mg‡qi wbwi‡L mewKQz cwieZ©b nq; cwieZ©b N‡U‡Q| Z_¨
cÖhyw³ cÖwZwU gyû‡Z© wbZ¨ bZzb Avwe®‹vi wb‡q mvg‡b nvwRi n‡”Q Gi avivevwnKZvq
gvB‡µvmdU Awdm ‡cÖvMÖvgwU hy³ K‡i Pj‡Q bZzb bZzb welq| GKwU welq jÿbxq c~‡e©i mKj
KgvÛ‡K Aÿzbœ †i‡L bZzb wKQz hy³ Kiv n‡”Q| wcÖq wkÿv_x© G‡·j 2007 welqwU mswÿß
fv‡e myweav eY©bv †`qv n‡jv KviY G‡·j 2003- Gi g‡a¨ we¯ÍvwiZ eY©bv Kiv Av‡Q hv
iß Ki‡j GB †cÖvMÖvg wb‡q KvR Ki‡Z Av‡iv mnR n‡e t-
How To Run Microsoft
Office Excel 2007 (Awdm G‡·j- 2007 PvjyKiY) t Kw¤úDUvi Pvjy nIqvi ci wK †evW©
†_‡K Ctrl +
Esc Pvcyb ev gvD‡mi
Øviv (1) Start
Button (÷vU evUy‡b)
wK¬K
Kiyb Ø (2) All Programs  |
(3) Microsoft Office Ø (4) Microsoft Office Excel-
2007- G wK¬K Kiæb
A_ev hw` Avcbvi Kw¤úDUv‡ii †W·U‡c mU©KvU AvB‡Kvb _v‡K
 Zv n‡j
gvDm Øviv Wvej wK¬K Kiæb gvB‡µvmdU Awdm G‡·j 2007 Pvjy n‡e| bx‡Pi wP‡Îi b¨vq Home, Insert, Page
Layout, Formulas, Data, Review, View ‡gby wewkó Db‡Ûv Avm‡e| (wPÎ) |
gvB‡µvmd&U
Awdm G‡·j 2007 Pvjy Ki‡j cÖ_‡g ‡h AckbwU Av‡Q †mUvB Awdm evUb| Awdm evU‡bi cv‡k
i‡q‡Q KzBK G‡·R †gby †hLv‡b i‡q‡Q Save, Undo, Redo KgvÛ|(wPÎ)
Office Button
Save : Microsoft Excel- G KvR †k‡l msiÿY Kivi Kb¨ KgvÛwU
e¨envi Kiv nq|
ðOffice Button Ø Save Ø Save As Dialog Box G File Name Gi N‡ii †jLv gy‡Q GKwU UvBc Kiæb Ø Save G wK¬K Kiæb|
Close : Microsoft Excel G KvR m¤úbœ Kivi ci eÜ Kivi Rb¨
KgvÛwU e¨envi nq|
ðOffice Button Ø Close- G wK¬K Kiæb Yes or No ‡Z wK¬K Kiæb|
Open : Microsoft Excel- G c~‡e© †mf Kiv dvBj Open Ki‡Z Command wU e¨envi
Kiv nq|
ðOffice Button Ø Open Dialog Box ‡_‡K †mfK…Z bv‡gi dvBj ev Iqv©K
eyK Gi Dci wK¬K Kiæb Ø Open-
G wK¬K Kiæb|
Save As : GKwU Save Kiv dvBj‡K Aÿzbœ †i‡L bZzb bvg
w`‡q H dvB‡ji GKwU Kwc ˆZix Kivi
Rb¨ GB Command wU e¨envi Kiv nq|
ð Office
Button Ø Open
Ø Office
Button Ø File
Name Gi N‡ii bvgwU
gy‡Q Ab¨ GKwU bvg wj‡L Save-
G wK¬K Kiæb|
New : Microsoft Excel Pvjy Ae¯’vq GK ev GKvwaK bZzb Document Open ev †Lvjvi
Rb¨ GB Command e¨envi Kiv nq|
ðOffice Button Ø New Ø Blank Document- G Click Kiæb|
Print Preview : WKy‡g›U ‰Zix n‡j cvZvi g‡a¨ †Kgb Qvcv n‡e Zv †`Lvi Rb¨ KgvÛwU e¨envi Kiv
nq |
ðOffice Button Ø Print Gi Dci w`‡q gvDm wb‡q Ø Print Prieview - G wK¬K Kiæb|
Print : Work Book ‰Zwi K‡i KvM‡R Qvcv‡bvi Rb¨ bx‡P
ewY©Z Command
e¨envi Kiv nq|
ðOffice Button Ø Print Ø Print G wK¬K Kiæb Ø Print bx‡Pi wP‡Îi gZ Print Dialog Box Avm‡e| Printer Name Gi N‡i wcÖ›Uv‡ii bvg wm‡j± Kiæb Ø Properties Ø ‡ccvi mvBR wba©vib Kiæb Ø Print Range ‡_‡K All Select Ki‡j WKz‡g‡›Ui mKj c„ôv wcÖ›U
n‡e Pages(s)
Select Ki‡j KZ
bv¤^vi c„ôv †_‡K KZ bv¤^vi c„ôv Zv wba©viY Gwiqv wm‡j± K‡i Ok Ki‡j wm‡j‡±W Gwiqv wcÖ›U n‡e|
Exit : Ms Excel n‡Z †ei nIqvi Rb¨ GB Command wU e¨envi Kiv nq|
ðOffice Button Ø Excit- G wK¬K Kiæb Ø Yes or No ‡Z wK¬K Kiæb|
 |
Customize Quick Access
Toolbar :
G wK¬K Ki‡j evg
cv‡ki wP‡Îi gZ GKwU cc WvDb †gby Avm‡e Ø ‡h AckbwU cÖ‡qvRb Zvi evg cv‡k
wK¬K K‡i wUK wPý w`b d‡j Ackb ¸‡jv Uzjev‡i Ae¯’vb wb‡e I `ªæZ KvR Ki‡Z mnvqZv
Ki‡e|
|
 |
Home Menu
Home Menu : Microsoft Excel Open Ki‡j ïiæ‡Z i‡q‡Q Home ‡gby| GB †gby‡Z hy³ KgvÛ ¸‡jv Awdm G‡·j 2003 Gi File ‡gby¯’ cyjWvDb †gby‡Z hy³ Av‡Q|
(Awdm G‡·j 2003 As‡k we¯ÍvwiZ eY©bv †`Iqv n‡q‡Q)|
Insert Menu
Insert Menu : Work Sheet Gi g‡a¨ Qwe, jvBb ev †Kvb Shapes ev IqvW© AvU© ¯’vc‡bi Rb¨ GB
†gby e¨envi Kiv nq| Qwe ¯’vcb Kivi ci QwewU wm‡i± Ki‡j wb‡¤œv³ Format ‡gbyi Dc‡i †jLv Avm‡e Picture Tools ‡hLv‡b †_‡K Qwei mvR m¾v Kiv nq|
wb¤œ wP‡Îi mvnv‡h¨ ‡`Lv‡bv n‡jvt
Insert Shapes: Work Sheet Gi g‡a¨ jvBb ev †Kvb Shapes ¯’vcb Kivi c‡i Shape wm‡j± Ki‡j wb‡¤œv³ Format ‡gby hvi Dc‡i †jLv Avm‡e Draring Tools ‡hLvb †_‡K Shape mvR m¾v Kiv hv‡e| wb‡¤œ wP‡Îi
mvnv‡h¨ †`Lv‡bv n‡jv|
Insert word Art : Work Sheet Gi g‡a¨ Word Art ¯’vcb Kivi ci Word Art wm‡j± K‡i wb‡¤œv³ Format ‡gby †_‡K Word Art wWRvBb Kiv nq|
Page Layout Menu
c„ôvi
mvBR, gvwR©b BZ¨vw` wba©vi‡bi Rb¨ Page Layout Menu e¨envi Kiv nq|
Formulas Menu
‡h‡Kvb
ai‡bi m~Î cÖ‡qv‡M Formulas
Menu e¨envi nq |
Data Menu
‡h‡Kvb
ai‡bi WvUv mvRv‡bvi Rb¨ wb‡¤œv³ Data Menu e¨envi Ki‡Z nq| bx‡P wPÎ †`Lyb t
Review Menu
‡h‡Kvb
ai‡bi gšÍe¨ ev K‡g›U e¨envi Ki‡Z Review Menu e¨eüZ nq| (wPÎ)
View Menu
c„ôv
wewfbœ mvB‡R †`Lvi Rb¨ View
Menu e¨envi Kiv nq|
No comments:
Post a Comment