Introduction Microsoft Excel XP

** Introduction **

What Is Excel (G‡·j wK) t

_ EXCEL t EXCEL k‡ãi AvwfavwbK evsjv A_© n‡”Q †kªôZ¡ jvf Kiv ev ¸‡b AwZ_g Kiv| EXCEL n‡jv GKwU

Windows wfwËK Application Program hv Microsoft Corporation KZ„K evRviRvZK…Z| GwU GK cªKvi

Spread Sheet Analysis Program (†¯cÖWkxU G¨vbvjvBwmm †cÖvMÖvg)| Lotus Gai‡bi Avi GKwU Spread Sheet

Analysis Program (†¯cÖWkxU G¨vbvjvBwmm †cÖvMÖvg)| g~jZ EXCEL Gi mvnv‡h¨ hveZxq wnmve wbKvk mn Data

Entry Ges Data Analysis Dfq myweav AR©b Kiv hvq|

What Is Spreadsheet (‡¯cÖWkxU wK) t

_ Spread Sheet t Spread Sheet k‡ãi AvwfavwbK evsjv A_© n‡jv Qov‡bv cvZv (Spread A_© Qov‡bv Ges Sheet

A_© cvZv)| MÖvd KvM‡Ri b¨vq X A¶ Ges Y A¶ eivei †Lvc †Lvc N‡ii b¨vq A‡bK Ni m¤^wjZ eo kxU‡K ejv nq

Spread Sheet. Excel Gi mywekvj ‡¯cÖWkxUwU‡Z wewfboe ai‡bi Z_¨ msi¶Y Ges MvwYwZK cwiMYbv Kiv hvq|

Starting The Excel (G‡·j Pvjy Kiv) t

_ c~‡e©B Avgiv †R‡bwQ Microsoft EXCEL n‡jv GKwU Windows wfwËK Application Program myZivs

Microsoft EXCEL Gi g‡a¨ cÖ‡ek Kivi Rb¨ cÖ‡gB Operating System Windows Gi Screen Open K‡i

Gi Aaxb¯’

_ Start Click

_ Programs G gvDm wb‡q Select Kivi ci †h ‡gbywU †ei n‡e †mLvb †_‡K

_ Microsoft Excel G Click Ki‡j Microsort Excel Pvjy n‡e| wb‡P Excel Program Window Gi Qwe

I cwiwPwZ †`Iqv nj|

AvkvKwi Dc‡i D‡j−wLZ ¯OExb Gi mv‡_ fvjfv‡e cwiwPZ n‡q‡Qb| g‡b ivL‡eb GB ¯OEx‡bi mv‡_ hZ fvj cwiPq _vK‡e

KvR Ki‡Z ZZB mnvqZv cv‡eb| Zvn‡j Avmyb Avgiv Aci c„óvq wM‡q we¯—vwiZ Rvbvi †Póv Kwi|

[ N.B: Microsoft Word G †hgb †jLvi hvqMv‡K A_©vr KvR Kivi RvqMv‡K Working Space (IqvwK©s

†¯úm) ejv nq, †Zgwb Microsoft Excel G †jLvi hvqMv‡K A_©vr KvR Kivi RvqMv‡K Worksheet (IqvK©kxU) ejv

nq| Microsoft Excel Gi GKwU Worksheet (IqvK©kxU) ‡K Avgiv Microsoft Word Gi GKwU †Uwe‡ji mv‡_

Zzjbv Ki‡Z cvwi| Microsort Excel 2000 G †h †Kvb dvB‡j cª‡gB wZbwU Worksheet (IqvK©kxU) _v‡K Ges

cÖ‡Z¨KwU Worksheet (IqvK©kxU) 256 wU Kjvg Ges 65536 wU †iv _v‡K| cª‡Z¨KwU †m‡j mvaviYZ 8wU A¶i a‡i,

Z‡e A¶‡ii mvB‡Ri Dci wbf©i K‡i G msL¨v Kg - †ekx n‡Z cv‡i| ¯^vfvweK Ae¯’vq Excel G Cursor (Kvm©i) †`Lv

hvq bv, ïay gvÎ †jLvi mgq Cursor (Kvm©i) †`Lv hvq Ab¨vb¨ mgq Kvm©i †h †m‡j _v‡K †mB †mjwUi cv‡k GKwU eW©vi

†`Lv hvq - G‡K †mj c‡q›Uvi e‡j| GQvov gvDm c‡q›UviwU EXCEL G c−vm wP‡ýi (+) gZ †`Lvq| ]

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|

Edit Menu Microsoft Excel XP

** 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|

View Menu Microsoft Excel XP

** View Menu **

1. Page Break Preview (c„óv ˆZix Kivi ci we¯v— wiZ †`Lv) t

_ cÖ‡g Worksheet Gi g‡a¨ †Kvb wKQy wj‡L †jLvi g‡a¨ Cursor ‡i‡L Normal Mode G _vKve¯’vq

_ View Click

_ Page Break Preview Click

_ Ok Click Ki‡jB ˆZixK…Z Page ¸‡jv fv½v Ae¯’vq †`Lv hv‡e| GLv‡b †h Ae¯’vq †`Lv hv‡e wVK †mB Ae¯’v‡ZB

Print (wcÖ›U) n‡e| GKB c„óvi Awa‡b KZ¸‡jv Row ev Column Print (wcÖ›U) n‡e Zv GB Page Break

Preview †Z Ae¯’vbKv‡j fvjfv‡e ‡`Lv hvq|

2. Normal (c„óv‡K ¯^vfvweK Ae¯’vq wb‡q Avmv) t

_ Excel Gi File/Book Page Break Preview ‡Z _vKve¯’vq

_ View Click

_ Normal Click Ki‡jB Worksheet Normal Mode G P‡j hv‡e|

3. Toolbars (wewfboe Uzjevi †Lvjv Ges eÜ Kiv) t

_ KvR Kivi mgq Menu bar ‡_‡K wewfboe Command bv w`‡q Toolbar Gi mvnv‡h¨ H GKB Command w`‡j

A‡bK `ª“Z KvR m¤úv`b Kiv hvq| Avgiv

_ View Click K‡i Mouse Pointer Toolbars Gi g‡a¨ wb‡q †M‡j Gi Awab¯’ wewfboe Toolbars List ‡`Lv hv‡e| GB

Ae¯’vq †h me Toolbars Gi ev‡g (_) wPý ‡`Iqv Av‡Q a‡i wb‡Z n‡e †m¸‡jv Screen (¯OExb) Gi g‡a¨ Active (¯^w_q)

Ae¯’vq Av‡Q| Aciw`‡K †h mKj Toolbars Gi ev‡g (_) wPý ‡`Iqv †bB a‡i wb‡Z n‡e †m¸‡jv Screen (¯OExb) Gi g‡a¨

Inactive (wb®OExq) Ae¯’vq Av‡Q| cieZ©x‡Z †h mKj Toolbars Gi ev‡g (_) wPý ‡`Iqv Av‡Q †m¸‡jvi g‡a¨ Mouse

Pointer Øviv c~bivq Click Ki‡j (_) wPý P‡j hv‡e Ges Inactive (wb®OExq) n‡q hv‡e Aciw`‡K †h mKj Toolbars Gi

ev‡g (_) wPý ‡`Iqv †bB †m¸‡jvi g‡a¨ Mouse Pointer Øviv c~bivq Click Ki‡j (_) wPý P‡j Avm‡e Ges Active

((¯^w_q) n‡q hv‡e| Gfv‡e Toolbars On/Off Kiv hvq|

4. Formula Bar (dg©~jvevi †Lvjv Ges eÜ Kiv) t

_ Microsoft Excel Program Gi g‡a¨ KvR Kivi mgq †h †Kvb Cell Gi g‡a¨ wK Av‡Q Zv (Cell Contant)

‡`Lvi Rb¨ GB Formula Bar (dg©~jvevi) e¨envi Kiv nq|

_ View Click Kivi ci Formula Bar (dg©~jvevi) Gi evg cv‡ki N‡i hw` (_) wPý ‡`Iqv _v‡K Zvn‡j a‡i wb‡Z n‡e

Formula Bar (dg©~jvevi) Screen (¯OExb) Gi g‡a¨ Active (¯^w_q) Ae¯’vq Av‡Q Aciw`‡K Formula Bar

(dg©~jvevi) Gi evg cv‡ki N‡i hw` (_) wPý ‡`Iqv bv _v‡K Zvn‡j a‡i wb‡Z n‡e Formula Bar (dg©~jvevi) Screen

(¯OExb) Gi g‡a¨ Inactive (wb®OExq) Ae¯’vq Av‡Q| cieZ©x‡Z Formula Bar (dg©~jvevi) Gi g‡a¨ Click K‡i

Toolbars Gi g‡ZvB Formula Bar (dg©~jvevi) †K On/Off Kiv hvq|

5. Status Bar (‡÷Uvmevi †Lvjv Ges eÜ Kiv) t

_ Microsoft Excel Program Gi g‡a¨ KvR Kivi mgq ‡h †Kvb Program Gi †÷Uvm m¤ú‡K© avibv cvIqvi Rb¨

GB Status Bar (‡÷Uvmevi) e¨envi Kiv nq|

_ View Click Kivi ci Status Bar (‡÷Uvmevi) Gi evg cv‡ki N‡i hw` (_) wPý ‡`Iqv _v‡K Zvn‡j a‡i wb‡Z

n‡e Status Bar (‡÷Uvmevi) Screen (¯OExb) Gi g‡a¨ Active (¯^w_q) Ae¯’vq Av‡Q Aciw`‡K Status Bar

(‡÷Uvmevi) Gi evg cv‡ki N‡i hw` (_) wPý ‡`Iqv bv _v‡K Zvn‡j a‡i wb‡Z n‡e Status Bar (‡÷Uvmevi)

Screen (¯OExb) Gi g‡a¨ Inactive (wbw®OEq) Ae¯’vq Av‡Q| cieZ©x‡Z Status Bar (‡÷Uvmevi) Gi g‡a¨ Click

K‡i Toolbars Gi g‡ZvB Status Bar (‡÷Uvmevi) †K On/Off Kiv hvq|

Microsoft Excel XP

Created By: Kamrul Hassan Bappy Bappy Computer Education Centre

6. Header & Footer (c„óvi ‡nWvi I dzUvi †`Iqv) t

_ View Click

_ Header & Footer Click Ki‡j Page Setup Dialog Box Avm‡e (hvi gva¨‡g Avgiv c~‡e© File Menu ‡Z

Page & Margin Setup wk‡LwQjvg) Zvici

_ Header & Footer Tab Select Kiv bv _vK‡j Select K‡i

_ Custom Header Click Ki‡j Header Box Avm‡e ZLb g‡bi B‡”QgZ Left Section, Center Section &

Right Section BZ¨vw`‡Z wjL‡Z cvwi, Toolbar Gi mnvqZvq †jLv wWRvBb, Page No, Date, Time, File

Name, Sheet Name BZ¨vw` Select Ki‡Z cvwi| Gme KvR wVKgZ Kivi ci

_ Ok Click Ki‡j Header Setting n‡q hvq| cieZ©x‡Z

_ Custom Footer Click Ki‡j Footer Box Avm‡e ZLb g‡bi B‡”QgZ Left Section, Center Section &

Right Section BZ¨vw`‡Z wjL‡Z cvwi, Toolbar Gi mnvqZvq †jLv wWRvBb, Page No, Date, Time, File

Name, Sheet Name BZ¨vw` Select Ki‡Z cvwi| Gme KvR wVKgZ Kivi ci

_ Ok Click Ki‡j Footer Setting n‡q hvq| Dc‡i D‡j−wLZ wbqgvbymv‡i Custom Header & Custom Footer

Setting Kiv †kl n‡j

_ Ok Click K‡i Print Preview Click Ki‡j Header & Footer h_v¯’v‡b cÖ`wk©Z n‡e|

7. Comments (gše— ¨ Kiv) t

NB t Spreadsheet Analysis Software (Microsoft Excel) Gi g‡a¨ KvR Kivi mgq A‡bK mgqB wewfboe

wel‡qi Dci ev wewfboe †jv‡Ki m¤ú‡K© gš—e¨ Kivi cÖ‡qvRb nq| Comments (gš—e¨ Kiv) Option wUi KvR Avgiv

View & Insert GB `yB Menu ‡_‡KB Ki‡Z cvwi| Z‡e View Menu ‡_‡KB Lye mn‡R KvRwU m¤úv`b Kiv hvq|

Avgiv †h †Kvb Cell Gi g‡a¨ Cursor ‡i‡LB Comments (gš—e¨ Kiv) Ki‡Z cvwi| A_©vr KvR Kivi Av‡M †h Cell

Gi g‡a¨ Cursor ivLv n‡e †mB Cell Gi g‡a¨B Comments (gš—e¨ Kiv) n‡e| Zvn‡j Avmyb Avgiv gš—e¨ Kiv wkwL