CONTENTS COMPUTER DEFINITION MEANINIG OF COMPUTER PARTS OF COMPUTER COMPUTER MEMORY ABOUT MS WORD USES OF MS WORD MENUS OF MS WORD ABOUT MS EXCEL MENUS OF MS EXCEL ABOUT POWER POINT VERSIONS OF POWER POINT
PROSYS EDUCATION & SERVICES, 5-CIVIL LINE, SAGAR (M.P.)
Computer dh ifjHkk"kk
ßComputer ,d rhoz xfr dk electronic device gS tks xf.krh; ,oa rkfdZd fdz;k dykiksa dk lQyrk ls lapkyu djrk gSA ;g vkadM+s dks ysrk gS vkSj ,d dzec) izfdz;k ?kfu"Vrk mls ckafNr ;k vko’;drk vuqlkj lwpuk ds :i esa izLrqr djrk gS A Þ ßComputer og electronic device gS ftls x.kuk djus ds fy;s mi;ksx esa yk;k tkrk gSA tks arithmetic fdz;kvksa dks 'kq)rk o rhoz xfr lss dj ldrk gS A Þ Computer ,d electronic device gSA ftlesa vf/kd ls vf/kd vk¡dM+s j[kus dh
{kerk gksrh gSA P.C.B. (Printed Circuit Board) ,d Mother board gS tks Computer ls connect gksrk gS ftl rjg euq"; dk viuk brain gksrk gS vkSj mldh viuh memory gksrh
gS mlh rjg Computer dk viuk brain (C.P.U.) gksrk gS rFkk bldh viuh memory gksrh gSA tks izk;% nks izdkj dh gksrh gA
Computer dk vk’k; Computer ,d Electronic Device gSA ;g vifjiDo (RAW) MsVk ,oa rF;ksa
dks fdlh izfdz;k fo’ks"k dh enn~ ls m|s’;iw.kZd lwpuk es ifjofrZr djrk gSA Computer fuEufyf[kr ’kCnksa ls fey dj cuk gS ftldk vk’k; fuEu izdkj gS C = Calculater O = Output that you can look at M = Machine P = Print U = Use it for drawing T= Type text E = Enjoy music with it R = Remember everything
Computer iz.kkyh PROSYS EDUCATION & SERVICES, 5-CIVIL LINE, SAGAR (M.P.)
,d ;k ,d ls vf/kd y{k;ksa dks gkfly djus ds fy, dk;Zjr bdkb;ksa ds lewg dks ,d iz.kkyh dgrs gSA
Computer ,d iz.kkyh ds #i esa dk;Z djrk gS ftlds fuEufyf[kr Hkkx gksrs gS
%& 1- Computer hardware :- Computer ds ;kaf=d oS|qr rFkk Electronic Hkkx Computer Hardware dgykrs gSA
2- Computer software :- ;s os izksxzke gS tks Computer dks ;g funsZ’k nsrs gS fd fdl izdkj MkVk izkl s sl fd;k tk, vkSj vko’;d lwpuk tfur fd tk,A 3- Computer personal or user :- os yksx tks Computerised Data rS;kj djrs gS izksxzke fy[krs gS Computer dks pykrs gS vkSj vkmViqV izkIr djrs gS Computer Personal ;k User dgykrs gSA
Computer ds ykHk Computer ds ykHkksa dk oxhZdj.k fuEufyf[kr #iksa esa fd;k gS
1- dk;Z{kerk & Computer ogqr rst xfr ls dk;Z djrk gS blds dk;Z djus dh xfr yk[kksa funsZ’k izfr lsds.M es gksrh gSA 2- mRikndrk & la;= a ks es Computer ds ek/;e ls Lopkfyr e’khuks }kjk vPNs mRiknksa dk fuekZ.k fd;k tkrk gS blls mRiknksa dk Lrj Hkh c<+rk gSA 3- jkstxkj es o`f) %& Computer us jkstxkj ds u;s {ks=ksa dks tUe fn;k gS la;a=ks o lax
PROSYS EDUCATION & SERVICES, 5-CIVIL LINE, SAGAR (M.P.)
Computer ds Hkkx COMPUTER
INPUT
OUTPUT
C.P.U.
Computer ds fuEufyf[kr 3 Hkkx gksrs gS 1.Input :- Input device og Hardware device gS tks Computer gsrq ckã txr ls
lwpuk izkIr djrs gSaA oLrqr% ;g og fo|qr vfHk;kaf=dh; midj.k gS tks ckã txr ls dataa izkIr dj bUgsa Computer ds iz;ksx gsrq ifjofrZr djrs gSa Input or Output midj.k nksuksa feydj ,d nwljs ds foijhr dk;Z djrs gSa rFkk ckã txr dk Computer ls laca/k LFkkfir djrs gSaA Input fuEu izdkj gS tSls %& ♣ Keyboard ♣ Mouse ♣ Scanner 2.Output :- Output device og fo|qr ;kaf=dh midj.k (electro mechanical device )
gS tks computer ls data processing ds ifj.kkeksa dks Binary code ds :i esa izkIr djrk gS rFkk mls iz;ksDrk }kjk le>us;ksX; :i esa ifjofrZr djrk gS A bl midj.k }kjk output lwpuk,¡ lwpuk izn’kZu ( display informations) ;k fu;a=.k ladsr (control signal) ;k recording fdlh Hkh :i esa iznku dh tkrh gSA output fuEu izdkj ds gS a %&
♣ Monitor ♣ Printer ♣ Plotter
PROSYS EDUCATION & SERVICES, 5-CIVIL LINE, SAGAR (M.P.)
Central processing unit (CPU) :- CPU es input Device ,oa Output device ls tqM+k jgrk gSA ;g Computer dk Brain gksrk gSA CPU lHkh
vadxf.krh; lac/a kh dk;Z djrh gS rkfdZd fu.kZ; ysrh gS vkSj bldh Units ds dk;Z dks fu;af=r djrh gSA Computer memory :- Memory Computer dk ,d vko’;d Hkkx gS ;g C.P.U. ds }kjk fdz;kfUor gksus okys izkx s zke dks laxzg djus ds fy, vko’;drk gSA
ftl izdkj ekuo ’kjhj es Memory dh vko’;drk gksrh gSA mlh izkdkj Computer es Hkh Memory dh vko’;drk gksrh gSA
Primary Memory
Secondary Memory
MEMORY
Primary
Secondary Memory
Memory 1-Primary Memory :- bls vkarfjd eSseksjh ;k esu eSeksjh Hkh dgk tkrk gSA izkFkfed eSseksjh
dh lajpuk ,sls semi-conductors ij vk/kkfjr gksrh gS tks vf/kd ykxr okys gksrs gSaA ;g eSeksjh vR;f/kd rhoz xfr ls dk;Z djrh gSA Primary memory esa vkdM+ksa ds :i esa lwpukvksa dk laxzg lhfer ek=k esa fd;k tkrk gSA ;g Computer ds C.P.U. dk vko’;d vax gS Primary memory nks izdkj dh gksrh gS A
a) Permanent memory (ROM) b) Temporary memory (RAM)
PROSYS EDUCATION & SERVICES, 5-CIVIL LINE, SAGAR (M.P.)
☻ ROM (Read Only Memory) :- bl memory esa Computer fuekZ.k ds le;
gh lwpuk,¡ laxzfgr dj nh tkrh gSa ftUgsa mi;ksxdrkZ dsoy i<+ ldrk gS rFkk bl laxfgr lwpukvksa es fdlh Hkh izdkj dk ifjorZu ugha dj ldrkA bl memory esa laxzfgr lwpuk,¡ LFkk;h gksrh gSaA ☻ RAM (Random Access Memory) :- ;g memory vLFkk;h memory gksrh
gS D;ksafd Computer can djus ij bl memory esa laxzfgr lHkh lwpuk,¡ Lo;a u"V gks tkrh gSA Computer esa Input dh tkus okyh dksbZ Hkh lwpuk loZiFz ke blh memory esa laxzfgr gksrh gSA ;gh dkj.k gS fd Computer dk iz;ksx djrs le; bl memory dks lcls vf/kd mi;ksx esa yk;k tkrk gS A
2-Secondary Memory :- Secondary memory vf/kla[; lwpukvksa dks Hk.Mkj.k djus dk
dk;Z djrh gS rFkk ;g C.P.U. ds ckgj vofLFkr gksrh gS Secondary memory gekjh diary, notebook bR;kfn dh rjg gS ftlesa ge Hkfo"; ds lanHkZ gsrq lwpuk;sa ,df=r djds
j[krs gSaA gekjs efLr"d esa lwpuk;sa dqN le;kUrjky ckn vklkuh ls foLe`r gks tkrh gS ysfdu diary vFkok notebook esa fy[kh lwpuk;sa ml le; rd LFkkbZ :Ik ls fpfUgr jgrh gS tc rd ge Lo;a mUgsa feVk;sa ugha A Secondary memory, Primary memory ls dkQh /kheh gksrh gS fdarq ;g data
lajf{kr djus dk lokZf/kd lLrk vkSj lqxe lk/ku gSA blesa data feVk;sa ;k gVk;sa tkus rd lqjf{kr jgrk gSA Secondary memory lkekU;r% floppy disk, Harddisk, C.D. Rom , D.V.D., Pendrive, Memory Card , Blue ray disk etc. ds :i esa gksrh gSA
PROSYS EDUCATION & SERVICES, 5-CIVIL LINE, SAGAR (M.P.)
Operating System ls vk’k;
,d operating system og programme gS tks Computer esa load gksus ds ckn computer ds lkjs programme dk izca/ku djrk gSAnwljs 'kCnksa es] Operating system programmes dk ,d leqg gksrk gSA tks Computer system ds Hardwaredk fu;a=.k
rFkk fufj{k.k djrk gS ,oa mi;ksxdrkZ dks lsok,¡ Hkh iznku djrk gS A Operating system Computer dk lokZf/kd egRoiw.kZ programme gSA ;g oLrqr%
,d cM+k vkSj tfVy programme gksrk gS tks fd 'ks"k lHkh programmes ds loading vkSj operating esa lg;ksx djrk gS A
Lkjy 'kCnksa esa] Oerating system ,d main programme gksrk gSA tks Computer vkSj user ds chp communicate djrk gS A
Computer
PROSYS EDUCATION & SERVICES, 5-CIVIL LINE, SAGAR (M.P.)
Operating System ds dk;Z 1. User dh Hkk"kk dks Computer dh Hkk"kk esa vkSj Computer dh Hkk"kk dks User dh Hkk"kk esa cnyrk gSA 2. Memory Management :- ;g Computer dh Primary & Secondary Memory dks izca/k djus dk dk;Z djrk gSA ;fn Computer es ,d izksxjke [kqyk
gS vpkud nwljk izkx s jke [kksyrs gS rks ;g igys izksxjke dks lkbZM es j[kdj nwljs dks cM+s LFkku es [kksyrk gSA 3. Disk Management :- Computer File dks NksVs&NksVs VqdM+kas esa Memory es Save djrk gSA blds ek/;e ls NksVs&NksVs VqdM+ksa dks tksM+dj Computer es File
dk izLrqr fd;k tkrk gSA Operating system dks nks Hkkxksa esa ck¡Vk x;k gS 1- Single User Operating System 2- Multiuser Operating System
Operating System ds izdkj
OPERATIG SYSTEM
SINGLE USER
MULTI USER
PROSYS EDUCATION & SERVICES, 5-CIVIL LINE, SAGAR (M.P.)
1- Single user ds vUrxZr fuEufyf[kr version vkrs gSa A
MS Windows DOS
MS Windows 95
MS Windows 98
MS Windows 98 SE
MS Windows ME
MS Windows XP
MS Windows Vista
MS Windows 7
2-Multi user ds vUrxZr fuEufyf[kr version vkrs gSa A MS WindowsNT Server
- MS Windows NT work station
MSWindows 2000 Server - MS Windows 2000 professinals MS Windows 2003 Server - MS Windows XP professional
PROSYS EDUCATION & SERVICES, 5-CIVIL LINE, SAGAR (M.P.)
Booting Process
Switch on
Rom activated
Boot strap loader
Operating starts loading into RAM
Operating Desktop appears
PROSYS EDUCATION & SERVICES, 5-CIVIL LINE, SAGAR (M.P.)
DESKTOP SCREEN
MS Suite A Bundle of programme is known as suite. MS Suite ds vUrxZr fofHkUu izdkj ds Programmes vkrs gSa MS Suite dk ;g Latest Version gSA %&
♣ MS Word Word editor ♣ MS Excelworkbook /charting programme ♣ MS Powerpoint Presentation graphic programme
PROSYS EDUCATION & SERVICES, 5-CIVIL LINE, SAGAR (M.P.)
♣ MS AccessRDBMS (Relational Database Management System) Programme ♣ MS Outlookorganizer programme ♣ MS Publisher D.T.P. package ♣ MS front pageWeb editor/Web designer.
PROSYS EDUCATION & SERVICES, 5-CIVIL LINE, SAGAR (M.P.)
MSWORD
MS Word dk ifjp;
Word processor og tool gS ftlesa ge letter, memo, report, newsletter, manual rFkk lHkh izdkj ds ,sls text dk;Z dj ldrs gSa tgk¡ vk/kqfud jkstejkZ ds thou esa
fyf[kr laizs"k.k dh vko’;drk gksrh gS tks ,d typewriter esa gksrh gSA Word processor u dsoy viuh fo’ks"krkvksa ds dkj.k oju~ mi;ksx dh fofo/krk ds dkj.k vkt Computer dk vko’;d ?kVd gSA blds ek/;e ls fdlh Hkh text dks type djds document ;k file dks rS;kj fd;k tk ldrk gSATypingdh leLr lqfo/kk ds vfrfjDr blesa editing , spelling check, grammer check etc. dh lqfo/kk;sa miyC/k gS tks gekjs ys[ku & dk;Z dks lq/kkjus
rFkk vkdf"kZr cukus esa lgk;rk djrk gSA ;g gekjs 'kCnks, lines, paragraph dks cut djds paste Hkh dj ldrk gS A M.S. Word dks ,d ,slh fdz;k ds :Ik esa ifjHkkf"kr fd;k tk ldrk gS ftlds }kjk Hardware rFkk Ssoftware dh enn ls type fd;s x;s text or material dks rS;kj fd;k
tkrk gS,enter fd;k tk ldrk gS, editing dh tk ldrh gS okfil ik;k tk ldrk gS rFkk print fd;k tk ldrk gSA
PROSYS EDUCATION & SERVICES, 5-CIVIL LINE, SAGAR (M.P.)
MS Word dh fo’ks"krk;sa %&
♫ Speed :- ;g ,d vfrrhoz package gS ftlesa fdlh Hkh text dh 'kh?kzrk ls fy[kk tk ldrk gS ftlls le; dh cpr gksrh gSA
♫ Editing :- MS Word esa vko’;drkuqlkj text dks tksMk] ?kVk;k ]gVk;k rFkk lq/kkjk tk ldrk gSA
♫ Storage :- MS Word esa data dks rS;kj dj laxzg fd;k tk ldrk gSA lqjf{kr document dks vko’;drkuqlkj izkIr fd;k tk ldrk gS rFkk mldk print out fudkyk tk ldrk gS A
♫ Formatting :- MS Word esa type fd;s x;s text dks vko’;drkuqlkj bold,italic,underline,subscript fd;k tk ldrk gS vr% text ds font ,font size,font colour or paragraph dh formatting dh tk
ldrh gSA ftlls text dks lqnja cuk;k tk lds A
♫ Graphics :- MS Word esa document esa vko’;drkuqlkj drawing dks lfEeyr fd;k tk ldrk gS A
PROSYS EDUCATION & SERVICES, 5-CIVIL LINE, SAGAR (M.P.)
♫ Spell check :- MS Word esa type fd;s x;s 'kCnksa dh spelling check djrk gS rFkk mudk LFkkUkkiu 'kCn dk lq>ko nsus esa Hkh l{ke gS A ;gh
ugha ;g grammer lac/a kh nks"kksa dk Hkh fuokj.k djrk gS A
♫ Mail Merge:- MS Word ds }kjk ge ,d leku text dks ,d ls vf/kd document dks print dj ldrs gSa A
♫ Table Construction :- MS Wordesa table dks cuk;k tk ldrk gSA Computer txr esa table ls vFkZ row rFkk column ls cukbZ xbZ vkd`fr gSA rFkk row or column dh yEckbZ o pkSM+kbZ dks Hkh fu/kkZfjr fd;k tk ldrk gS A
♫
Table of Contents:- MS Word esa Table of contents dks
,dlkFk ns[kus dh lqfo/kk gksrh gS rFkk izR;sd content esa Hkh lq/kkj 'kh?kzrk ls fd;k tk ldrk gS A
♫ Automatic formatting :- MS Wordesa automatic formatting djus dh lqfo/kk gksrh gSA
PROSYS EDUCATION & SERVICES, 5-CIVIL LINE, SAGAR (M.P.)
MS Word dks fuEu izdkj ls open fd;k tk ldrk gS Start on Programs MS Office MS Word
PROSYS EDUCATION & SERVICES, 5-CIVIL LINE, SAGAR (M.P.)
MS Word esa document dks print djus ds fy;s file menu
ds fuEufyf[kr commands dk vuqlj.k fd;k tkrk gS
Page set up :- Windows esa page set up }kjk ge document ds ml :Ik dh tkudkjh izkIr dj ldrs gSa tks print gksus ds ckn page ij fn[kkbZ nax s h A blds fy;s MS word esa short cut keys dk mi;ksx djds page dks 'kh?kzrk ls set fd;k tk ldrk
gSA blds varxZr dkxt dk vkdkj ]izdkj ]fofHkUu izdkj ds ekftZZu (top,bottom,left,right or gutter rFkk header o footer vkfn dks vklkuh ls lqfuf’pr fd;k tk ldrk gS A
Print Preview :- ge file menu ds print preview option dk use djds document dks screen ij print gksus ls igys gh ns[k ldrs gSa A
PROSYS EDUCATION & SERVICES, 5-CIVIL LINE, SAGAR (M.P.)
Print :- Preview ns[kus ds mijkar document dks print fd;k tk ldrk gS A
Formatting :- Formatting Tool Bar dk mi;ksx Text dks lqanj cukus ds fy, fd;k tkrk gSA blds vUrxZr fuEufyf[kr Option gksrs gSA 1. Font :- blesa vusd fy[kus ds rjhds fn, jgrs gSA fgUnh o vaxzsth vkfn vusd Hkk"kk
ds fy[kus ds rjhds bles gksrs gSA blds ek/;e ls Text dks Style ls Type fd;k tk ldrk gSA tSls---
A
A
A
A
2. Font Size :- bles Font Size dks fuf’pr fd;k tkrk gSA blds ek/;e ls Text dks
NksVk ;k cM+k fy[kk ldrk gSA 3. Font Colour :- blds ek/;e ls Font ds dyj dks flysDV fd;k tkrk gSA
Alignment Left Alignment (ctrl +L) Right Alignment (ctrl +R) Center Alignment (ctrl +E) Justified (ctrl +J) Force Justified
Line Spacing :- Line Spacing nks ykbZu ds chp dk varj gSA ;g Formatting Tool Bar es gksrk gSA Formatting Tool Bar ds var es fpUg gksrk gSA bl ij Left Click djrs gS
rks ,d Dialogue Box izkIr gksrk gSA ftles Add or Remove Buttens Option gksrk gSA bl ij fdfyd djus ls Line Spacing Option izkIr gksrk gSA bl Option dks ok djus ls Formatting Tool Bar Line Spacing
Window izkIr
gksrh gSA ftles nks ykbZu ds chp dk varj fn;k jgrk gSA ;g varj fuEu izdkj gS
PROSYS EDUCATION & SERVICES, 5-CIVIL LINE, SAGAR (M.P.)
1.0, 1.5, 2.0, 2.5, 3.0 more bles ls fdlh ,d dks flysDV djds ok dj nsus
ls Text es line spacing gks tkrh gSA Page Setup :- File Menu ds ek/;e ls Page Setup Dialogue Box Open fd;k tkrk gSA bldh Short Cut Key Alt+FV gSA blds ek/;e ls Page dh Margine ,oa Page Size dks fuf’pr fd;k tkrk gSA Tab :- Tab Set djus ls Text dk Lisl ,d tSlk vkrk gSA
Tab ds izdkj :- Tab ik¡p izdkj ds gksrs gSA
=>
Left Tab
└
Right Tab
┘
Center Tab
┴
Decimal Tab
┴
Bar Tab
I
└
'
;g fpUg Vertical Rular ,oa Horizontal Rular ds chp esa M.S.
Word dh Windows es gksrk gSA bl fpUg ij fdfyd djus ij Left, Right Tab, Center, Decimal & Bar Tab vkrs gSA Horizontal Rular ij fdfyd
djrs gS rks Tab izkIr gksrk gSA blds ckn blds ckn Keybord ds Tab dks Use djus ls computer ij tab izkIr gksrk gSA Tab gVkuk :- tg¡k ij tab yxk gS ml tab ij fdfyd djds uhps [khpsx a sA First Line Indent :- Paragraph dh igyh Line FkksfM+ nwjh ls 'kq# gksrh gSA blh Paragraph dh vU; Lines izkjaHk ls fy[kh tkrh gSA igyk Paragraph fy[krs
le; First Line Indent yxkus ls dze’k% vkxs vkus ckys Paragraph Hkh mlh LFkku ls izkjaHk gksrs gS tgk¡ ls igyk Paragraph dks fy[kuk 'kq# fd;k gSA First Line Indent dk mi;ksx :- fcuk dqN Type fd;S Tab yxkus ij dsoy Tab gh yxrk gS ysfdu dqN Type djus ds ckn igyh ykbu ds igys 'kCn ij Tab yxkus ij First Line Indent 0.5 bap ij yx tkrk gSA Paragraph Spacing :nks Paragraph ds varj dks Paragraph Spacing gksrk gSA ;g ctrl+0 ls gksrk gSA
Styles PROSYS EDUCATION & SERVICES, 5-CIVIL LINE, SAGAR (M.P.)
Automatic Formatting djus ds fy, Styles dk Use fd;k tkrk gSA ;s Formatting Bar ds lcls Left Corner ij fn[kkbZ nsrh gSA Types of Styles Heading 1 Heading 2 Heading 3 Body text
fdlh Style dks cnyus ;k Modify djus ds fy, lcls igys Icon ij Click djrs gSA ;g Formatting es gksrk gSA Right Hand Side Style And Formatting uked Task Pane fn[kkbZ gksrk
gSA bl Task Pane ij ;fn Heading 1 dks Modify djuk gks rks Heading 1 ij Mouse Pointer ij ys tkrs gS ftlls Heading 1
▼
,slk fn[kkbZ nsus yxrk gS vkSj blds Arrow ij Click djrs gS ftlls Modify Option fn[kkbZ nsrk gS vkSj ml ij Click djrs gS rks ,d u;h Window Open gksrh gSA
Modify option fn[kkbZ nsrk gS ml ij click djrs gS rks ,d window open gksrh gSs bles modify fd;k tkrk gSA vr% bl rjg modify fd;k tkrk gSA
blh rjg vU; dks Hkh modify dj ldrs gSA mijksDr task pane ij ;fn body text dks modify djuk gS rks show :
available formatting
▼
ij click djsx a as ftlls dialogue box fn[kkbZ nsrk gS
PROSYS EDUCATION & SERVICES, 5-CIVIL LINE, SAGAR (M.P.)
vc bl dialogue box es ls all styles dks select djsx a as ftlls pick formatting to apply ij body text izkIr gksrk gSA body text dks modify djus ds fy, bl ij cursor ys tk, ftlls arrow
fn[kkbZ nsrk gSA ,sls ij click djus ls modify option fn[kkbZ nsrk gS bl ij click djsxas rks ,d window open gksrh gSA bl window es format option gksrk
gSA bl ij click djus ls ,d dialogue box izkIr gksrk gSA blesa ls paragraph dks flysDV djds ftlls ,d u;h window izkIr gksrh gSA vr% bl rjg body text dks modify fd;k tkrk gSA
M.S. Word esa Table Insert :M.S. Word esa table menu dh lgk;rk ls table izkIr dj ldrs gS ysfdu
blesa calculation dk dk;Z ugha dj ldrs gS blds fy, M.S. Excel dk iz;ksx fd;k tkrk gSA vr% Li"V gS fd M.S. word es insert dh xbZ table ij calculation dk dk;Z ugh dj ldrs gSA ;g dk;Z djus ds fy, M.S. office ds m.s. excel software dk use fd;k tkrk gSA ftldh tkudkjh foLrkj ls fuEu izdkj gS
Create a Table To create a table:
Place the cursor on the page where you want the new table
Click the Insert Tab of the Ribbon
Click the Tables Button on the Tables Group. You can create a
table one of four ways:
Highlight the number of row and columns
Click Insert Table and enter the number of rows and columns
Click the Draw Table, create your table by clicking and entering the
rows and columns
Click Excel Spreadsheet and enter data
Enter Data in a Table
PROSYS EDUCATION & SERVICES, 5-CIVIL LINE, SAGAR (M.P.)
Place the cursor in the cell where you wish to enter the information. Begin typing. Modify the Table Structure and Format a Table To modify the structure of a table:
Click the table and notice that you have two new tabs on the Ribbon: Design and Layout. These pertain to the table design and layout.
Table Style On the Design Tab, you can choose:
Options
Table Styles
Draw Borders
To format a table, click the table and then click the Layout Tab on the Ribbon. This Layout tab allows you to:
View Gridlines and Properties (from the Table Group)
Insert Rows and Columns (from the Rows & Columns Group)
Delete the Table, Rows and/or Columns (from the Rows & Columns Group)
Merge or Split Cells (from the Merge Group)
Increase and decrease cell size (Cell Size Group)
Align text within the cells and change text directions (Alignment Group)
Short cuts:
To open a new file: CTRL+N
To switch other program: ALT+TAB
Alignments: a. Left: CTRL+L b. Right: CTRL+R
PROSYS EDUCATION & SERVICES, 5-CIVIL LINE, SAGAR (M.P.)
c. Center: CTRL+E d. Justify: CTRL+J
To select all: CTRL+A
To open font dialog box: CTRL+SHIFT+F
To zoom in or zoom out: CTRL+SCROLL BUTTON
Bold letters: CTRL+B
Italic letters: CTRL+I
Underline words: CTRL+U
Font size: a. Increase size: CTRL+SHIFT+> b. Increase size point vice: CTRL+] c. Decrease size: CTRL+SHIFT+< d. Decrease size point vice: CTRL+[
To save a file: i.
CTRL+S
ii.
SAVE ICON
iii.
F12
To change case: SHIFT+F3
To go at the end of the page: CTRL+END KEY
To go at the beginning of the document: CTRL+HOME KEY
Line spacing: i.
Double line space: CTRL+2
ii.
Single line space: CTRL+1
iii.
1.5 line space: CTRL+5
To delete a whole word: CTRL+BACK SPACE KEY
To select particular portion: SHIFT+ARROW KEYS
USES: 1. Letter drafting 2. Cover pages 3. Telephone directory
PROSYS EDUCATION & SERVICES, 5-CIVIL LINE, SAGAR (M.P.)
4. Thesis 5. Book work 6. Others File Extension: .doc: document file (word 2003 and before). .docx: document file (word 2007 and after).
MS WORD 2007 WINDOW
vr% tks dk;Z ge MS Word esa vklkuh ls ugha dj ldrs tSls table work M.S. word esa fd;k rks tkrk gS ysfdu dqN leL;kvksa dk lkeuk djuk iM+rk gS blfy;s Table work dks vklkuh ls djus ds fy;s M.S. Excel dks cuk;k x;k ftlesa Data entries dks vklkuh ls fd;k tk ldrk gSA
PROSYS EDUCATION & SERVICES, 5-CIVIL LINE, SAGAR (M.P.)
MICROSOFT EXCEL
MS Excel dk ifjp;
MS Excel ,d ,slk powerful spreadsheet programme gSA tks data dks
O;ofLFkr dj x.kuk djus ]fu.kZ; rd igq¡pus ]fjiksZV rS;kj djus ]O;ofLFkr data dks osc ij izdkf’kr djus dh xfrfof/k;k¡ rFkk graphics dk iz;ksx vR;ar ljy ,oa izHkkoh
djus okys Lotus software esa gksrs gSa ]vr% MS Excel dks Lotus dks le`) ,oa lqfo/kktud laLdj.k Hkh dgk tkrk gSA ;g ,d Workbook ;k charting programme gS A Excel dh file dks workbook dgrs gSa A ,d workbook esa 16384 column vkSj 1048576 rows gksrh gSA izR;sd row or column ls feydj ,d cell curh gS A izR;sd cell dk viuk cell reference gksrk gS A Excel dks customize djus
ds fy;s lcls igys start ij click djuk gksrk gS
ftlls start menu [kqy tkrk gS blesa All programmes ij click djus ds ckn sub-menu esa Microsoft Excel ij click djuk gksrk gS ftlls Microsoft Excel [kqy tkrk gS rFkk gesa computer screen ij ,d windows fn[kkbZ nsrh gS A
mi;ksfxrk %& ;g izksxzke data dks lkj.kh ,oa xzkQ #i es O;Dr djus dh {kerk j[krk gSA PROSYS EDUCATION & SERVICES, 5-CIVIL LINE, SAGAR (M.P.)
o daiuh ds mRiknu ds fooj.k dks laxzfgr dj x.kuk, djus esA o deZpkfj;ksa dh lwpukvksa dks laxzfgr dj dk;kZy; izca/ku es ,oa x.kuk,¡ djus esA o foi.ku esa o osru dh x.kuk esa o ,dkmfVax dk;Z esA Extention :- M.S. Excel dk extention .xls gSA M.S. Excel dks start djus dh izfØ;k :Start
All program
M.S. Office
M.S. Excel
Microsoft Excel Windows or Screen layout
PROSYS EDUCATION & SERVICES, 5-CIVIL LINE, SAGAR (M.P.)
bl rjg M.S. Excel dks start fd;k tkrk gS ftlls ,d window open gksrh gS blesa fuEu bar gksrs gSA Program Title Bar Menu Bar Standard Tool Bar Formatting Tool Bar Formula Bar
Program Title Bar :- tks program [kqyk gS mldk uke fy[kk jgrk gSA Menu Bar :- M.S. Excel es file, edit, view, insert, format, tools, data, windows ,oa help tool bar gksrs gSA bl tool bar esa ls vkB tool bar M.S. Word es Hkh jgrs gS vkSj tool bar u;k tqM+k jgrk gSA og data tool bar gSA
bles Sort, filter table vkfn option jgrs gSA Standard Tool Bar :- standard tool bar es tools gksrs gS tks M.S. Word es izkIr gksrs gS tSls open, save, permission vkfnA Formatting tool bar :- blesa font, font size, alignment vkfn izkIr gksrs gS
PROSYS EDUCATION & SERVICES, 5-CIVIL LINE, SAGAR (M.P.)
Formula bar :- M.S. Excel esa formula bar gksrk gSA tc M.S. Excel dh cells es x.kuk djus ds fy, ftl formula ,oa functions dk iz;ksx djrs gS rks mldk lw= formula bar es fy[kk jgrk gSA
CELL References cell ftl column ls curh gS og cell dk references gksrk gSA ;g lsy dk uke ;k number gksrk gSA
1. Relative cell reference 2. Absolute cell reference
Relative Cell Reference :- Relative cell reference changing gksrk gS blesa formula ,oa cell reference nksuksa copy gksrh gSA Ex.- A,B,C,………
mnkgj.k ds ek/;e ls Relative cell reference dks fuEu izdkj ls le>k tk ldrk gS A
B
C
D
E
1
Name
Hindi
Computer
English
Total
2
Ram
20
30
20
70
3
Mohan
15
40
30
85
izR;sd O;fDr ds marks ds total dk Kkr djuk gS & PROSYS EDUCATION & SERVICES, 5-CIVIL LINE, SAGAR (M.P.)
B2, C2, D2 cell reference dk total Kkr djuk ds fy, E2 cell reference es = B2+C2+D2 fy[kdj enter nckrs gS ftlls B2, C2, D2 cell reference dk total = 70 E2 es izkIr gksrk gSA bl rjg jke ds marks dk total izkIr gks tkrk gSA eksgu
ds marks total djus ds fy, E2 dk copy djds vFkkZr E2 cell reference dks select djds cursor dh lgk;rk ls E3 ij ys tk,saxs ftlls E3 es euksgj ds marks dk total = 85 gh izkIr gksrk gSA vr% Li"kV gS fd bles formula & cell reference nksuks copy gqbZ ftlds dkj.k E2 & E3 ds marks es vUrj gSA vr% ;g relative cell reference gSA
Absolute Cell Reference :- Absolute cell reference Fixed gksrk gS blesa formula copy gksrk gS ysfdu cell refernce copy ugh gksrk gSA bues cell refernce charging ugh gksrk gS fixed gksrk gSA Absolute cell reference es
MkWyj $ dk mi;ksx gksrk gSA Ex. $A$2
mnkgj.k :- blh mnkgj.k ls Absolute cell reference dks le>rs gSA jke ds marks dk total Absolute cell reference ds ek/;e ls Kkr djus ds fy, E2 cell reference es = $B$2 + $C$2+$D$2 fy[kdj enter djds ftlls gesa budk sum izkIr gksrk gSA eksgu ds marks dk total Absolute cell reference ds ek/;e ls Kkr djus ds fy, E3 cell reference es = $B$3 + $C$3+$D$3 fy[kdj enter djds ftlls gesa budk sum izkIr gksrk gSA Formula And Function :1. Formula :- ;g xf.krh; lehdj.k gksrs gSA bldk dksbZ uke ugh gksrk gSA bUgsa viuh vko’;drk ds vuqlkj cuk dj excel esa user djds vko’;d ifj.kke dks izkIr fd;k tk ldrk gSA lcls igys cjkcj dk fpUg yxk;k tkrk gSA mlds ckn vko’;d formula dks fy[kk ,oa mi;ksx fd;k tkrk gSA M.S. Excel es fuEufyf[kr formula cuk dj result izkIr fd;k tk ldrk gS - DA Kkr djus dk formula := if (D2>10000, D2*80%, D2*65%)
PROSYS EDUCATION & SERVICES, 5-CIVIL LINE, SAGAR (M.P.)
vFkkZr ;fn D2>10000 rks 80%, D2 dk ugh rks D2 dk 65% - TA Kkr djus dk formula := if (D2>10000, 1000rs., 750rs.)
vFkkZr ;fn D2>10000 rks 1000 rs. ugh rks 750rs. vr% ;fn ge bl rjg dbZ formula cuk dj Excel es user djds vko’;d ifj.kke izkIr dj ldrs gSA 2. Function :- Excel es igys ls cus cuk;s formulas gksrs gS ftudk uke “h gksrk gSA Function dgykrs gSA Standard tool bar es ∑ ;g ,d fpUg gksrk gS ftls autosum dgrs gS bl ij click djus ls ,d dialogue box open gksrk gS ftles function ds uke fn;s
jgrs gSA M.S.excel es x.kuk ds fy, fuEufyf[kr functions gksrs gSA = if ( ) = concalenale ( ) = sum ( ) = max ( ) = min ( ) =average ( ) = date ( )
bu lHkh functions dk rduhdh x.kukvksa ,oa lkf[;dh x.kukvksa ds fy, fd;k tkrk gS tSls =sum () dk mi;ksx tksM+us ds fy,] = min () dk mi;ksx lcls NksVk djus ds fy, fd;k tkrk gSA vr% blh rjg vU; function dk mi;ksx xf.krh; x.kukvksa ds fy, fd;k tkrk gSA Function ds dks"Bd es syntax fy[ks tkrs gSA tSls-------------= sum (syntex fy[krs gS )
;k = syn (A1+B1+C1)
PROSYS EDUCATION & SERVICES, 5-CIVIL LINE, SAGAR (M.P.)
Graph
MS Word esa vk¡dM+ks dks graph ds ek/;e ls Hkh iznf’kZr fd;k tk ldrk gSA blesa
fofHkUu izdkj ds graph ds ek/;e ls dataa dks iznf’kZr fd;k tkrk gSA tSls& 1- Coloumn / Bar chart :- ;g chart fn;s x;s data ds e/; varj dks iznf’kZr djrk
gS A
2- Pia chart :- ;s chart fn;s x;s data ds dqy 100% dks vk/kkj ekudj izHkkxksa dks fn[kkrk gSA
Example :-
PROSYS EDUCATION & SERVICES, 5-CIVIL LINE, SAGAR (M.P.)
Graph ds ek/;e ls dataa dks iznf’kZr djus ls data dks ;k fdlh Hkh ifj.kke dks
vklkuh ls le>k tk ldrk gS A
pkVZ cukus dh fof/k %& lcls igys excel dh table es data dks type djsxs type data dks select djsxs
standard tool bar es chart wizara option jgrk gS ;k insert menu ls pkVZ option ij click djrs gS rks chart window [kqyrh gSA
vc type of charts es ls fdlh ,d ij click djrs gSA vc sub types ij click djrs gSA click on next
click on next
fill the information as chart title, category, value etc.
click on next
click on finish
PROSYS EDUCATION & SERVICES, 5-CIVIL LINE, SAGAR (M.P.)
bl rjg ls chart sheet ij cudj rS;kj gks tkrk gSA
vr% MS Excel esa graph ,d egRoiw.kZ Hkqfedk fuHkkrs gaSA dqN dk;Z ,sls gSa tks MS Word o Excel esa dj rks fy;s tkrs gSa ysfdu mls vPNs ls Show ugha dj ikrs blfy;s
vius dk;Z dks vkd"kZd rjhds ls show djus ds fy;s MS Powerpoint dks cuk;k x;k ftlesa vlaHko dk;Z dks laHko cuk;k x;k A
PROSYS EDUCATION & SERVICES, 5-CIVIL LINE, SAGAR (M.P.)
MS POWERPOINT
Powerpoint ls vk’k;
MS powerpoint ,d presentation graphic proramme gSA ;g professional
rjhds ls presentation dh lqfo/kk nsrk gSA powerpoint ds izR;sd page dks slide dgrs gSaA powerpoint esa ;g lqfo/kk gksrh gS fd computer dks projection device ds lkFk attach
djds on-screen- audio-video presentation fn;k tk ldrk gSA izR;sd new slide dkss ysus ds fy;s short cut key CTRL +M dk use fd;k tk ldrk gSA powerpoint ds iz;ksx ls izR;sd slide dks effective cukdj presentation dks attractive cuk;k tk ldrk gS MS powerpoint esa fdlh Hkh fLFkj object dks move djkrk gqvkk fn[kk;k tk ldrk gSA blds
vraxZr fofHkUu izdkj ds animation effect Mkys tk ldrs gSa A Slide show powerpoint presentation dh ,d effective rduhd gSA ftlds
}kjk mouse ;k keyboard dh enter key ds }kjk ,d slide ls nwljh slide ij move fd;k tk ldrk gSA powerpoint }kjk izLrqrhdj.k ls iwoZ dh :ijs[kk rS;kj dh tk ldrh gS rFkk ckn esa vko’;drkuqlkj blesa lq/kkj Hkh fd;k tk ldrk gS A vr% powerpoint ea fofHkUu slides dks design templates ,colour schemes rFkk animation effect ds }kjk attractive or effective cuk;k tk ldrk gS A
bldk extension .ppt gksrk gS A
PROSYS EDUCATION & SERVICES, 5-CIVIL LINE, SAGAR (M.P.)
Powerpoint Screen windows or layout
Powerpoint dh fo’ks"krk;sa Powerpoint programme dh fo’ks"krk;sa fuEuor~ gSa A
PROSYS EDUCATION & SERVICES, 5-CIVIL LINE, SAGAR (M.P.)
bl programme ds varxZr menu bar ,d ;k vf/kd toolbar tSls formatting toolbar ;k drawing toolbar, ruler, navigation button vkfn dk mi;ksx fd;k
tkrk gSA Powerpoint ds varxZr graphics ,Charts, animation vkfn dk mi;ksx dj rF;ksa ,oa fopkjksa dk izHkkoh :Ik ls laizs?k.k fd;k tk ldrk gS A Powerpoint ds varxZr M.S. Word ls text, tables ,oa graphics rFkk M.S. Excel ls tables ,oa chart vkfn blds slides ij vk;kr fd;s tk ldrs gSa A
Powerpoint dk mi;ksx fofHkUu izfr"Bkuksa ,oa daifu;ksa }kjk laizs"k.k ,oa lapkyd okrkZyki gsrq Hkh fd;k tkrk gS A Powerpoint dk mi;ksx djds tks slide cukbZ tkrh gSA mUgsa vksojgsM presentation , 35 MM slides ;k projected image ds :Ik esa Hkh mi;ksx fd;k tk ldrk gS A slide ds vfrfjDr blds }kjk audience , handouts, outlines rFkk speakers notes ds print Hkh izkIr fd;s tk ldrs gSa A Microsoft Office Button: The Microsoft Office Button performs many of the functions that were located in the File menu of older versions of PowerPoint. This button allows you to create a new presentation, Open an existing presentation, save and save as, print, send, or close.
PROSYS EDUCATION & SERVICES, 5-CIVIL LINE, SAGAR (M.P.)
Ribbon: The ribbon is the panel at the top portion of the document It has seven tabs: Home, Insert, Design, Animations, Slide Show, Review and View. Each tab is divided into groups. The groups are logical collections of features designed to perform function that you will utilize in developing or editing your PowerPoint slides.
Commonly utilized features are displayed on the Ribbon. To view additional features within each group, click the arrow at the bottom right corner of each group.
Home: Clipboard, Slides, Font, Paragraph, Drawing, and Editing Insert: Tables, Illustrations, Links, Text, and Media Clips Design: Page Setup, Themes, Background Animations: Preview, Animations, Transition to this Slide Slide Show: Start Slide Show, Set Up, Monitors Review: Proofing, Comments, Protect View: Presentation Views, Show/Hide, Zoom, Window, Macros Quick Access Toolbar: The quick access toolbar is a customizable toolbar that contains commands that you may want to use. You can place the quick access toolbar above or below the ribbon. To change the location of the quick access toolbar, click on the arrow at the end of the toolbar and click Show Below the
PROSYS EDUCATION & SERVICES, 5-CIVIL LINE, SAGAR (M.P.)
You can also add items to the quick access toolbar. Right click on any item in the Office Button or the Ribbon and click Add to Quick Access Toolbar and a shortcut will be added.
Mini Toolbar: A new feature in Office 2007 is the Mini Toolbar. This is a floating toolbar that is displayed when you select text or right-click text. It displays common formatting tools, such as Bold, Italics, Fonts, Font Size and Font Color.
PROSYS EDUCATION & SERVICES, 5-CIVIL LINE, SAGAR (M.P.)
Navigation:Navigation through the slides can be accomplished through the Slide Navigation menu on the left side of the screen. Also, an outline appears from materials that have been entered in the presentation. To access the outline, click the outline tab.
Slide Views: Presentations can be viewed in a variety of manners. On the View tab, the Presentation Views group allows you to view the slides as Normal, Slide Sorter, Notes Page, Slide Show, Slide Master, Handout Master, and Notes Master.
PROSYS EDUCATION & SERVICES, 5-CIVIL LINE, SAGAR (M.P.)
Powerpoint ds fofHkUu Versions
Microsoft powrpoint windows esa fuEufyf[kr version lfEefyr gSa &
1. 1993 – Powerpoint 4.0 ( Office 4 X); 2. 1995 – Powerpoint 7(Office 95) 3. 1997 – powerpoint 97 ( Office 97) 4. 1999 – Powerpoint 2000 ( Office 2000) 5. 2001 – Powerpoint 2002 (Office XP) 6. 2003 – Powerpoint 2003 (Office 2003) 7. 2006-2007 – Powerpoint 2007 (Office 2007)
lkekU;r% Powerpoint dk izR;sd version vius iwoZ version ds format esa lqjf{kr dh xbZ files dks i<+ ldrk gSA powerpoint ds iqjkus version dqN & dqN uohu versions dh fo’ks"krkvksa dks support ugha djrs gSaA vr% vc ge Corel Draw ds ckjs esa v/;;u djsx a as tks D.T.P. ds varxZr vkrs gSaA
PROSYS EDUCATION & SERVICES, 5-CIVIL LINE, SAGAR (M.P.)