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 EXCELABOUT POWER POINT
Computer
dh ifjHkk"kk
ß
Computer,d rhoz xfr dk
electronic devicegS 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 Þ
ß
Computerog
electronic devicegS ftls x.kuk djus ds fy;s mi;ksx esa yk;k
tkrk gSA tks
arithmeticfdz;kvksa dks 'kq)rk o rhoz xfr lss dj ldrk gS A Þ
Computer
,d
electronic devicegSA ftlesa vf/kd ls vf/kd vk¡dM+s j[kus dh
{kerk gksrh gSA
P.C.B. (Printed Circuit Board),d
Mother boardgS tks
Computerls
connectgksrk gS ftl rjg euq"; dk viuk
braingksrk gS vkSj mldh viuh
memorygksrh
gS mlh rjg
Computerdk viuk
brain (C.P.U.)gksrk gS rFkk bldh viuh
memorygksrh
gSA tks izk;% nks izdkj dh gksrh gA
Computer dk vk’k;
Computer
,d
Electronic DevicegSA ;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 = CalculaterO = 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
,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
:- Computerds ;kaf=d oS|qr rFkk
ElectronicHkkx
Computer Hardwaredgykrs gSA
2- Computer software
:-;s os izksxzke gS tks
Computerdks ;g funsZ’k nsrs gS
fd fdl izdkj MkVk izkslsl fd;k tk, vkSj vko’;d lwpuk tfur fd tk,A
3- Computer personal or user
:-os yksx tks
Computerised DatarS;kj
djrs gS izksxzke fy[krs gS
Computerdks pykrs gS vkSj vkmViqV izkIr djrs gS
Computer Personal;k
Userdgykrs gSA
Computer ds ykHk
Computer
ds ykHkksa dk oxhZdj.k fuEufyf[kr #iksa esa fd;k gS
1- dk;Z{kerk &
Computerogqr 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
Computerds 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) %&
Computerus jkstxkj ds u;s {ks=ksa dks tUe fn;k gS la;a=ks o
Computer ds Hkkx
Computer ds fuEufyf[kr 3 Hkkx gksrs gS
1.Input :- Input device
og
Hardware devicegS tks
Computergsrq ckã txr ls
lwpuk izkIr djrs gSaA oLrqr% ;g og fo|qr vfHk;kaf=dh; midj.k gS tks ckã txr ls
dataa
aizkIr dj bUgsa
Computerds iz;ksx gsrq ifjofrZr djrs gSa
Input or Outputmidj.k nksuksa
feydj ,d nwljs ds foijhr dk;Z djrs gSa rFkk ckã txr dk
Computerls laca/k LFkkfir
djrs gSa
A InputfuEu izdkj gS tSls %&
♣ Keyboard ♣ Mouse ♣ Scanner
2.Output :- Output device
og fo|qr ;kaf=dh midj.k
(electro mechanical device )gS tks
computerls
data processingds ifj.kkeksa dks
Binary codeds :i esa izkIr djrk
gS rFkk mls iz;ksDrk }kjk le>us;ksX; :i esa ifjofrZr djrk gS A bl midj.k }kjk
outputlwpuk,¡ lwpuk izn’kZu
( display informations);k fu;a=.k ladsr
(control signal);k
recordingfdlh Hkh :i esa iznku dh tkrh gSA
outputfuEu izdkj ds gS a %&
♣ Monitor ♣ Printer ♣ Plotter
COMPUTER
Central processing unit (CPU)
:- CPUes
input Device,oa
Output devicels tqM+k jgrk gSA ;g
Computerdk
Braingksrk gSA
CPUlHkh
vadxf.krh; laca/kh dk;Z djrh gS rkfdZd fu.kZ; ysrh gS vkSj bldh
Unitsds dk;Z
dks fu;af=r djrh gSA
Computer memory
:- Memory Computerdk ,d vko’;d Hkkx gS ;g
C.P.U.
ds }kjk fdz;kfUor gksus okys izksxzke dks laxzzg djus ds fy, vko’;drk gSA
ftl izdkj ekuo ’kjhj es
Memorydh vko’;drk gksrh gSA mlh izkdkj
Computeres Hkh
Memorydh vko’;drk gksrh gSA
Primary Memory Secondary Memory
1-Primary Memory :-
bls vkarfjd eSseksjh ;k esu eSeksjh Hkh dgk tkrk gSA izkFkfed eSseksjh
dh lajpuk ,sls
semi-conductorsij vk/kkfjr gksrh gS tks vf/kd ykxr okys gksrs gSaA ;g
eSeksjh vR;f/kd rhoz xfr ls dk;Z djrh gSA
Primary memoryesa vkdM+ksa ds :i esa lwpukvksa
dk laxzg lhfer ek=k esa fd;k tkrk gSA ;g
Computerds
C.P.U.dk vko’;d vax gS
Primary memorynks izdkj dh gksrh gS A
a) Permanent memory (ROM) b) Temporary memory (RAM)
MEMORY
Primary
Memory
Secondary Memory
☻ ROM (Read Only Memory) :-
bl
memoryesa
ComputerfuekZ.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
memoryesa
laxzfgr lwpuk,¡ LFkk;h gksrh gSaaA
☻ RAM (Random Access Memory) :-
;g
memoryvLFkk;h
memorygksrh
gS D;ksafd
Computercan djus ij bl
memoryesa laxzfgr lHkh lwpuk,¡ Lo;a u"V
gks tkrh gSA
Computeresa
Inputdh tkus okyh dksbZ Hkh lwpuk loZizFke blh
memoryesa laxzfgr gksrh gSA ;gh dkj.k gS fd
Computerdk iz;ksx djrs le; bl
memorydks 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 memorygekjh
diary, notebookbR;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
diaryvFkok
notebookesa 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
datalajf{kr djus dk lokZf/kd lLrk vkSj lqxe lk/ku gSA blesa
datafeVk;sa ;k gVk;sa tkus rd
lqjf{kr jgrk gSA
Secondary memorylkekU;r%
floppy disk, Harddisk, C.D. Rom , D.V.D., Pendrive, Memory Card , Blue ray disk etc.ds :i esa gksrh gSA
Operating System ls vk’k;
,d
operating systemog
programmegS tks
Computeresa
loadgksus ds ckn
computerds lkjs
programmedk izca/ku djrk gSAnwljs 'kCnksa es]
Operating system programmesdk ,d leqg gksrk gSA tks
Computer systemds
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
programmegSA ;g oLrqr%
,d cM+k vkSj tfVy
programmegksrk gS tks fd 'ks"k lHkh
programmesds
loadingvkSj
operatingesa lg;ksx djrk gS A
Lkjy 'kCnksa esa]
Oerating system,d
main programmeg
ksrk gSA tks
ComputervkSj
userds chp
communicatedjrk gS A
Operating System ds dk;Z
1. User
dh Hkk"kk dks
Computerdh Hkk"kk esa vkSj
Computer dh Hkk"kk
dks Userdh
Hkk"kk esa cnyrk gSA
2. Memory Management
:-;g
Computer dh Primary & Secondary Memorydks izca/k djus dk dk;Z djrk gSA ;fn
Computeres ,d izksxjke [kqyk
gS vpkud nwljk izksxjke [kksyrs gS rks ;g igys izksxjke dks lkbZM es j[kdj nwljs
dks cM+s LFkku es [kksyrk gSA
3. Disk Management
:- Computer Filedks NksVs&NksVs VqdM+kssa esa
Memoryes
Savedjrk gSA blds ek/;e ls NksVs&NksVs VqdM+kssa dks tksM+dj
Computeres
Filedk 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
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 72-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 professionalBooting Process
Switch on Rom activated Boot strap loader
Operating starts loading into RAM
DESKTOP SCREEN
MS Suite
A Bundle of programme is known as suite.
MS Suite
ds vUrxZr fofHkUu izdkj ds
Programmesvkrs gSa
MS Suitedk ;g
Latest Version gSA%&
♣ MS Word Word editor
♣ MS Excelworkbook /charting programme
♣ MS AccessRDBMS (Relational Database Management System)
Programme ♣ MS Outlookorganizer programme ♣ MS Publisher D.T.P. package
♣ MS front pageWeb editor/Web designer.
MSWORD
MS Word
dk ifjp;
Word processor
og
toolgS ftlesa ge
letter, memo, report, newsletter, manualrFkk lHkh izdkj ds ,sls
textdk;Z dj ldrs gSa tgk¡ vk/kqfud jkstejkZ ds thou esa
fyf[kr laizs"k.k dh vko’;drk gksrh gS tks ,d
typewriteresa gksrh gSA
Word processoru
dsoy viuh fo’ks"krkvksa ds dkj.k oju~ mi;ksx dh fofo/krk ds dkj.k vkt
Computerdk
vko’;d ?kVd gSA blds ek/;e ls fdlh Hkh
textdks
typedjds
document;k
filedks
rS;kj fd;k tk ldrk gSA
Typingdh 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, paragraphdks
cutdjds
pasteHkh dj ldrk gS A
M.S. Word
dks ,d ,slh fdz;k ds :Ik esa ifjHkkf"kr fd;k tk ldrk gS ftlds }kjk
HardwarerFkk
Ss
oftwaredh enn ls
typefd;s x;s
text or materialdks rS;kj fd;k
tkrk gS
,enterfd;k tk ldrk gS
, editingdh tk ldrh gS okfil ik;k tk ldrk gS rFkk
printfd;k tk ldrk gSA
MS Word dh fo’ks"krk;sa %&
♫ Speed :-
;g ,d vfrrhoz
packagegS ftlesa fdlh Hkh
textdh
'kh?kzrk ls fy[kk tk ldrk gS ftlls le; dh cpr gksrh gSA
♫ Editing :-
MS Wordesa vko’;drkuqlkj
textdks tksMk] ?kVk;k
]gVk;k rFkk lq/kkjk tk ldrk gSA
♫ Storage :-
MS Wordesa
datadks rS;kj dj laxzg fd;k tk ldrk
gSA lqjf{kr
documentdks vko’;drkuqlkj izkIr fd;k tk ldrk gS rFkk
mldk
print outfudkyk tk ldrk gS A
♫ Formatting :-
MS Wordesa
typefd;s x;s
textdks
vko’;drkuqlkj
bold,italic,underline,subscriptfd;k tk ldrk gS vr%
text
ds
font ,font size,font colour or paragraphdh
formattingdh tk
ldrh gSA ftlls
textdks lqnaj cuk;k tk lds A
♫ Graphics :-
MS Wordesa
documentesa vko’;drkuqlkj
drawingdks
lfEeyr fd;k tk ldrk gS A
♫ Spell check :-
MS Wordesa
typefd;s x;s 'kCnksa dh
spelling checkdjrk gS rFkk mudk LFkkUkkiu 'kCn dk lq>ko nsus esa Hkh l{ke gS A ;gh
ugha ;g
grammerlaca/kh nks"kksa dk Hkh fuokj.k djrk gS A
♫ Mail Merge:-
MS Wordds }kjk ge ,d leku
textdks ,d ls
vf/kd
documentdks
printdj ldrs gSa A
♫ Table Construction :-
MS Wordesa
tabledks cuk;k tk ldrk
gSA
Computertxr esa
tablels vFkZ
rowrFkk
columnls cukbZ xbZ vkd`fr
gSA rFkk
row or columndh yEckbZ o pkSM+kbZ dks Hkh fu/kkZfjr fd;k tk ldrk
gS A
♫ Table of Contents:-
MS Wordesa
Table of contentsdks
,dlkFk ns[kus dh lqfo/kk gksrh gS rFkk izR;sd
contentesa Hkh lq/kkj 'kh?kzrk ls
fd;k tk ldrk gS A
♫ Automatic formatting :-
MS Wordesaa
automatic formattingMS Word
dks fuEu izdkj ls open fd;k tk ldrk gS
Start on Programs MS Office MS WordMS 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 :-
Windowsesa
page set up}kjk ge
documentds ml :Ik
dh tkudkjh izkIr dj ldrs gSa tks
printgksus ds ckn
pageij fn[kkbZ nasxh A blds fy;s
MS wordesa
short cut keysdk mi;ksx djds
pagedks 'kh?kzrk ls
setfd;k tk ldrk
gSA blds varxZr dkxt dk vkdkj ]izdkj ]fofHkUu izdkj ds ekftZZu
(top,bottom,left,right or gutterrFkk
headero
footervkfn dks vklkuh ls lqfuf’pr fd;k tk ldrk gS A
Print Preview :- ge
file menuds
print preview optiondk
usedjds
documentdks
screenij
printgksus ls igys gh ns[k ldrs gSa A
Print :-
Previewns[kus ds mijkar
documentdks
printfd;k tk ldrk gS A
Formatting
:- Formatting Tool Bardk mi;ksx
Textdks lqanj cukus ds fy, fd;k
tkrk gSA
blds vUrxZr fuEufyf[kr
Optiongksrs 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 Stylels
Typefd;k tk ldrk gSA tSls---
A A
A
A
2. Font Size :-
bles
Font Sizedks fuf’pr fd;k tkrk gSA blds ek/;e ls
Textdks
NksVk ;k cM+k fy[kk ldrk gSA
3. Font Colour :-
blds ek/;e ls
Fontds 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 Spacingnks ykbZu ds chp dk varj gSA ;g
Formatting Tool Bares gksrk gSA
Formatting Tool Bar
ds var es fpUg gksrk gSA bl ij
Left Clickdjrs gS
rks ,d
Dialogue BoxizkIr gksrk gSA ftles
Add or Remove Buttens Optiongksrk gSA bl ij fdfyd djus ls
Line Spacing OptionizkIr gksrk gSA bl
Optiondks
okdjus ls
Formatting Tool Bar Line Spacing WindowizkIr
1.0, 1.5, 2.0, 2.5, 3.0 more
bles ls fdlh ,d dks flysDV djds
okdj nsus
ls
Textes
line spacinggks tkrh gSA
Page Setup
:- File Menuds ek/;e ls
Page Setup Dialogue Box Openfd;k tkrk gSA bldh
Short Cut Key Alt+FVgSA
blds ek/;e ls
Pagedh
Margine,oa
Page Sizedks fuf’pr fd;k tkrk gSA
Tab :- Tab Setdjus ls
Textdk Lisl ,d tSlk vkrk gSA
Tab
ds izdkj
:- Tabik¡p izdkj ds gksrs gSA
Left Tab └
Right Tab ┘
Center Tab ┴ Decimal Tab ┴'
Bar Tab I
=>
;g fpUg
Vertical Rular,oa
Horizontal Rulards chp esa
M.S. Worddh
Windowses gksrk gSA bl fpUg ij fdfyd djus ij
Left, Right Tab, Center, Decimal & Bar Tabvkrs gSA
Horizontal Rularij fdfyd
djrs gS rks
TabizkIr gksrk gSA blds ckn blds ckn
Keybordds
Tabdks
Usedjus ls
computer ij tabizkIr gksrk gSA
Tab
gVkuk
:-tg¡k ij
tabyxk gS ml
tabij fdfyd djds uhps [khpsaxsA
First Line Indent
:- Paragraphdh igyh
LineFkksfM+ nwjh ls 'kq# gksrh gSA blh
Paragraphdh vU;
LinesizkjaHk ls fy[kh tkrh gSA igyk
Paragraphfy[krs
le;
First Line Indentyxkus ls dze’k% vkxs vkus ckys
ParagraphHkh mlh
LFkku ls izkjaHk gksrs gS tgk¡ ls igyk
Paragraphdks fy[kuk 'kq# fd;k gSA
First Line Indent dk mi;ksx
:-fcuk dqN
Typefd;S
Tabyxkus ij dsoy
Tabgh yxrk gS ysfdu dqN
Typedjus ds ckn igyh ykbu ds igys 'kCn ij
Tabyxkus ij
First Line Indent 0.5bap ij yx tkrk gSA
Paragraph Spacing :-nks
Paragraphds varj dks
Paragraph Spacinggksrk gSA ;g
ctrl+0ls gksrk
gSA
Styles
Automatic Formatting
djus ds fy,
Stylesdk
Usefd;k tkrk gSA ;s
Formatting Bards lcls
Left Cornerij fn[kkbZ nsrh gSA
Types of Styles
Heading 1 Heading 2 Heading 3 Body text
fdlh
Styledks cnyus ;k
Modifydjus ds fy, lcls igys
Iconij
Clickdjrs gSA ;g
Formattinges gksrk gSA
Right Hand Side Style And Formatting
uked
Task Panefn[kkbZ gksrk
gSA bl
Task Paneij ;fn
Heading 1dks
Modifydjuk gks rks
Heading 1 ij Mouse Pointerij ys tkrs gS ftlls
,slk fn[kkbZ nsus yxrk gS vkSj blds
Arrowij
Clickdjrs gS ftlls
Modify Optionfn[kkbZ nsrk gS vkSj ml ij
Clickdjrs gS rks ,d u;h
Window Opengksrh gSA
Modify option
fn[kkbZ nsrk gS ml ij
clickdjrs gS rks ,d
window opengksrh gSs bles
modifyfd;k tkrk gSA vr% bl rjg
modifyfd;k tkrk gSA
blh rjg vU; dks Hkh
modifydj ldrs gSA
mijksDr
task paneij ;fn
body text dks modifydjuk gS rks
show :
ij
clickdjsaxsa ftlls
dialogue boxfn[kkbZ nsrk gS
Heading 1 ▼vc bl
dialogue boxes ls
all styles dks selectdjsaxsa ftlls
pick formatting to apply ij body textizkIr gksrk gSA
body text
dks
modifydjus ds fy, bl ij
cursorys tk, ftlls
arrowfn[kkbZ nsrk gSA ,sls ij
clickdjus ls
modify optionfn[kkbZ nsrk gS bl ij
clickdjsxas rks ,d
window opengksrh gSA bl
windowes
format optiongksrk
gSA bl ij
clickdjus ls ,d
dialogue boxizkIr gksrk gSA blesa ls
paragraphdks flysDV djds ftlls ,d u;h
windowizkIr gksrh gSA vr% bl rjg
body textdks
modifyfd;k tkrk gSA
M.S. Word
esa Table Insert
:-M.S. Word
esa
table menudh lgk;rk ls
tableizkIr dj ldrs gS ysfdu
blesa
calculationdk dk;Z ugha dj ldrs gS blds fy,
M.S. Exceldk iz;ksx
fd;k tkrk gSA
vr% Li"V gS fd
M.S. wordes
insertdh xbZ
tableij
calculationdk
dk;Z ugh dj ldrs gSA ;g dk;Z djus ds fy,
M.S. officeds
m.s. excel softwaredk
usefd;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
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
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
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 Wordesa vklkuh ls ugha dj ldrs tSls
table work M.S.w
ordesa 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. Exceldks cuk;k x;k ftlesa Data entries dks
MICROSOFT EXCEL
MS Excel dk ifjp;
MS Excel
,d ,slk
powerful spreadsheet programmegSA tks
datadks
O;ofLFkr dj x.kuk djus ]fu.kZ; rd igq¡pus ]fjiksZV rS;kj djus ]O;ofLFkr
datadks osc ij
izdkf’kr djus dh xfrfof/k;k¡ rFkk
graphicsdk iz;ksx vR;ar ljy ,oa izHkkoh <ax ls djrk
gSA blesa ,d foLr`r
spreadsheet;k
worksheetgksrh gS ftlds izR;sd
columnes ,d
datafy[kk tkrk gSA p¡wd
MS Excelesa os lHkh dk;Z fd;s tk ldrs gSa tks
DOSesa dk;Z
djus okys
Lotus softwareesa gksrs gSa ]vr%
MS Exceldks
Lotusdks le`) ,oa lqfo/kktud
laLdj.k Hkh dgk tkrk gSA
;g ,d
Workbook;k
charting programmegS A
Exceldh
filedks
workbookdgrs gSa A
,d
workbookesa 16384
columnvkSj 1048576
rowsgksrh gSA
izR;sd
row or columnls feydj ,d
cellcurh gS A
izR;sd
celldk viuk
cell referencegksrk gS A
Excel
dks
customizedjus ds fy;s lcls igys
startij
clickdjuk gksrk gS
ftlls
start menu[kqy tkrk gS blesa
All programmesij
clickdjus ds ckn
sub-menuesa
Microsoft Excelij
clickdjuk gksrk gS ftlls
Microsoft Excel[kqy tkrk gS rFkk gesa
computer screenij ,d
windowsfn[kkbZ nsrh gS A
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. Exceldk
extention .xlsgSA
M.S. Excel
dks
startdjus dh izfØ;k
:-Start
All program
M.S. Office
M.S. Excel
bl rjg
M.S. Exceldks
startfd;k tkrk gS ftlls ,d
window opengksrh gS blesa fuEu
bargksrs 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 bargksrs gSA bl
tool baresa ls vkB
tool bar M.S. Wordes Hkh jgrs gS vkSj
tool baru;k tqM+k jgrk gSA og
data tool bargSA
bles
Sort, filter tablevkfn
optionjgrs gSA
Standard Tool Bar
:- standard tool bares
toolsgksrs gS tks
M.S. Wordes
izkIr gksrs gS tSls
open, save, permissionvkfnA
Formula bar :-
M.S. Excelesa
formula bargksrk gSA tc
M.S. Exceldh
cellses x.kuk djus ds fy, ftl
formula ,oa functionsdk iz;ksx djrs gS rks mldk
lw=
formula bares fy[kk jgrk gSA
CELL References
cell
ftl
columnls curh gS og
celldk
referencesgksrk gSA ;g lsy dk uke ;k
numbergksrk gSA
1. Relative cell reference 2. Absolute cell reference
Relative Cell Reference
:- Relative cell reference changinggksrk gS
blesa
formula,oa
cell referencenksuksa
copygksrh gSA
Ex.- A,B,C,………mnkgj.k ds ek/;e ls
Relative cell referencedks 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
B2, C2, D2 cell reference
dk
totalKkr djuk ds fy,
E2 cell referencees
= B2+C2+D2fy[kdj
enternckrs gS ftlls
B2, C2, D2 cell referencedk
total = 70 E2es izkIr gksrk gSA bl rjg jke ds
marksdk
totalizkIr gks tkrk gSA eksgu
ds
marks totaldjus ds fy,
E2dk
copydjds vFkkZr
E2 cell referencedks
selectdjds
cursordh lgk;rk ls
E3ij ys tk,saxs ftlls
E3es euksgj ds
marksdk
total = 85gh izkIr gksrk gSA vr% Li"kV gS fd bles
formula & cell referencenksuks
copygqbZ ftlds dkj.k
E2 & E3ds
markses vUrj gSA vr% ;g
relative cell referencegSA
Absolute Cell Reference
:- Absolute cell reference Fixedgksrk gS blesa
formula copygksrk gS ysfdu
cell refernce copyugh gksrk gSA bues
cell refernce chargingugh gksrk gS
fixedgksrk gSA
Absolute cell referencees
MkWyj
$dk mi;ksx gksrk gSA
Ex. $A$2mnkgj.k
:-blh mnkgj.k ls
Absolute cell referencedks le>rs gSA
jke ds
marksdk
total Absolute cell referenceds ek/;e ls Kkr djus ds
fy,
E2 cell referencees
= $B$2 + $C$2+$D$2fy[kdj
enterdjds ftlls
gesa budk
sumizkIr gksrk gSA
eksgu ds
marksdk
total Absolute cell referenceds ek/;e ls Kkr djus ds
fy,
E3 cell referencees
= $B$3 + $C$3+$D$3fy[kdj
enterdjds ftlls
gesa budk
sumizkIr 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
excelesa
userdjds vko’;d ifj.kke dks
izkIr fd;k tk ldrk gSA
lcls igys cjkcj dk fpUg yxk;k tkrk gSA mlds ckn vko’;d
formuladks
fy[kk ,oa mi;ksx fd;k tkrk gSA
M.S. Excel
es fuEufyf[kr
formulacuk dj
resultizkIr fd;k tk ldrk gS
- DAKkr djus dk
formula :-vFkkZr ;fn
D2>10000 rks 80%, D2 dk ugh rks D2 dk 65% - TAKkr djus dk
formula :-= if (D2>10000, 1000rs., 750rs.)
vFkkZr ;fn
D2>10000 rks 1000 rs.ugh rks
750rs.vr% ;fn ge bl rjg dbZ
formulacuk dj
Excel es userdjds
vko’;d ifj.kke izkIr dj ldrs gSA
2. Function
:- Exceles igys ls cus cuk;s
formulasgksrs gS ftudk uke “h gksrk
gSA
Functiondgykrs gSA
Standard tool bar
es ∑
;g ,d fpUg gksrk gS ftls
autosumdgrs gS bl ij
clickdjus ls ,d
dialogue box opengksrk gS ftles
functionds uke fn;s
jgrs gSA
M.S.excel
es x.kuk ds fy, fuEufyf[kr
functionsgksrs gSA
= if ( ) = concalenale ( ) = sum ( ) = max ( ) = min ( ) =average ( ) = date ( )bu lHkh
functionsdk 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;
functiondk mi;ksx
xf.krh; x.kukvksa ds fy, fd;k tkrk gSA
Function
ds dks"Bd es
syntaxfy[ks tkrs gSA tSls---
= sum (syntexfy[krs gS
);k
Graph
MS Word
esa vk¡dM+ks dks
graphds ek/;e ls Hkh iznf’kZr fd;k tk ldrk gSA blesa
fofHkUu izdkj ds
graphds ek/;e ls
dataadks iznf’kZr fd;k tkrk gSA tSls&
1- Coloumn / Bar chart :-
;g
chartfn;s x;s
datads e/; varj dks iznf’kZr djrk
gS A
2-
Pia chart :-;s
chartfn;s x;s
datads dqy
100%dks vk/kkj ekudj izHkkxksa dks
fn[kkrk gSA
Example :-
Graph
ds ek/;e ls
data
adks iznf’kZr djus ls
datadks ;k fdlh Hkh ifj.kke dks
vklkuh ls le>k tk ldrk gS A
pkVZ cukus dh fof/k %&
lcls igys
exceldh
tablees
datadks
typedjsxs
type data
dks
selectdjsxs
standard tool bar
es
chart wizara optionjgrk gS ;k
insert menuls pkVZ
option ij clickdjrs gS rks
chart window[kqyrh gSA
vc
type of chartses ls fdlh ,d ij
clickdjrs gSA
vc
sub typesij
clickdjrs gSA
click on next
click on next
fill the information as chart title, category, value etc.
click on next
bl rjg ls
chart sheetij cudj rS;kj gks tkrk gSA
vr%
MS Excelesa
graph,d egRoiw.kZ Hkqfedk fuHkkrs gaSA dqN dk;Z ,sls gSa tks
MS Wordo
Excelesa dj rks fy;s tkrs gSa ysfdu mls vPNs ls
Showugha dj ikrs blfy;s
vius dk;Z dks vkd"kZd rjhds ls show djus ds fy;s
MS Powerpointdks cuk;k x;k
MS POWERPOINT
Powerpoint ls vk’k;
MS powerpoint
,d
presentation graphic prorammegSA ;g
professionalrjhds ls
presentationdh lqfo/kk nsrk gSA
powerpointds izR;sd
pagedks
slidedgrs gSaA
powerpointesa ;g lqfo/kk gksrh gS fd
computerdks
projection deviceds lkFk
attachdjds
on-screen- audio-video presentationfn;k tk ldrk gSA izR;sd
new slidedksss
ysus ds fy;s
short cut key CTRL +Mdk
usefd;k tk ldrk gSA
powerpointds iz;ksx
ls izR;sd
slidedks
effectivecukdj
presentationdks
attractivecuk;k tk ldrk gS
MS powerpointesa fdlh Hkh fLFkj
objectdks
movedjkrk gqvkk fn[kk;k tk ldrk gSA blds
vraxZr fofHkUu izdkj ds
animation effectMkys tk ldrs gSa A
Slide show powerpoint presentation
dh ,d
effectiverduhd gSA ftlds
}kjk
mouse;k
keyboarddh
enter keyds }kjk ,d
slidels nwljh
slideij
movefd;k tk ldrk gSA
powerpoint}kjk izLrqrhdj.k ls iwoZZZ 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%
powerpointea fofHkUu
slidesdks
design templates ,colour schemesrFkk
animation effectds }kjk
attractive or effectivecuk;k tk ldrk gS A
Powerpoint Screen windows or layout
Powerpoint
dh fo’ks"krk;sa
bl
programmeds varxZr
menu bar,d ;k vf/kd
toolbartSls
formatting toolbar;k
drawing toolbar, ruler, navigation buttonvkfn dk mi;ksx fd;k
tkrk gSA
Powerpointds varxZr
graphics ,Charts, animationvkfn dk mi;ksx dj rF;ksa
,oa fopkjksa dk izHkkoh :Ik ls laizs?k.k fd;k tk ldrk gS A
Powerpointds varxZr
M.S. Wordls
text, tables,oa
graphicsrFkk
M.S. Excells
tables,oa
chartvkfn blds
slidesij vk;kr fd;s tk ldrs gSa A
Powerpointdk mi;ksx fofHkUu izfr"Bkuksa ,oa daifu;ksa }kjk laizs"k.k ,oa lapkyd
okrkZyki gsrq Hkh fd;k tkrk gS A
Powerpointdk mi;ksx djds tks
slidecukbZ tkrh gSA mUgsa vksojgsM
presentation ,35
MM slides;k
projected imageds :Ik esa Hkh mi;ksx fd;k tk ldrk gS A
slide
ds vfrfjDr blds }kjk
audience , handouts, outlinesrFkk
speakers notesds
printHkh 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.
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
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.
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.
Powerpoint
ds fofHkUu Versions
Microsoft powrpoint windows
esa fuEufyf[kr
versionlfEefyr 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)