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

_ CURSOR MOVEMENT (Kvm©i ¯’vbvš—i Kiv) t

mywcÖq cÖwk¶bv_©xMb, AvkvKwi Avcbviv Key Board Gi Aš—M©Z Cursor Key Gi mwnZ fvjfv‡e cwiwPZ| GB

Cursor Key ¸‡jvi mnvqZvq Cursor Movement Ki‡Z nq| hw` †KD Cursor Key Gi mwnZ cwiwPZ bv _v‡Kb Z‡e

wk¶‡Ki mvnvh¨ wbb| Ges wb‡Pi Cursor Movement ms_vš— m~θ‡jv fvjfv‡e AvqË Ki“b| g‡b ivL‡eb KvR Kivi mgq

hZ ZvovZvox Cursor Movement Ki‡Z cvi‡eb KvR ZZB ZvovZvwo Ges mnR n‡e| Gevi wb‡Pi m~θ‡jv AvqË Kivi

Rb¨ †h †Kvb RvqMvq Cursor †i‡L,

Right Arrow Key Press Ki‡j Cursor wU GK Cell Wv‡b hv‡e|

Left Arrow Key Press Ki‡j Cursor wU GK Cell ev‡g hv‡e |

Up Arrow Key Press Ki‡j Cursor wU GK Cell Dc‡i hv‡e|

Down Arrow Key Press Ki‡j Cursor wU GK Cell wb‡P hv‡e|

Home Key Press Ki‡j Cursor wU H Row Gi cÖg Cell Gi g‡a¨ P‡j hv‡e|

End Key ‡Z GKevi Press K‡i mv‡_ mv‡_ Right Arrow Key Press Ki‡j Cursor wU H Row Gi ‡k‡l hv‡e|

End Key ‡Z GKevi Press K‡i mv‡_ mv‡_ Left Arrow Key Press Ki‡j Cursor wU H Row Gi ïi“‡Z P‡j hv‡e|

End Key ‡Z GKevi Press K‡i mv‡_ mv‡_ Down Arrow Key Press Ki‡j Cursor wU H Column Gi ‡k‡l hv‡e|

End Key ‡Z GKevi Press K‡i mv‡_ mv‡_ Up Arrow Key Press Ki‡j Cursor wU H Column Gi ïi“‡Z P‡j hv‡e|

Page Up Key Press Ki‡j Cursor wU GK ¯OExb Dc‡ii †m‡j hv‡e|

Page Down Key Press Ki‡j Cursor wU GK ¯OExb wb‡Pi †m‡j hv‡e|

Ctrl + Home Key Press Ki‡j Cursor wU dvB‡ji ïi“‡Z hv‡e|

Ctrl + End Key Press Ki‡j Cursor wU dvB‡ji ‡k‡l hv‡e|

[ NB t D‡j−L¨ †h, GLv‡b GK ¯OExb ej‡Z GKev‡i gwbU‡ii ¯OEx‡b IqvK©kx‡Ui hZUzKz †`Lv hvq Zv‡K eySv‡bv n‡q‡Q| ]