• No results found

msoffice hindi.pdf

N/A
N/A
Protected

Academic year: 2021

Share "msoffice hindi.pdf"

Copied!
40
0
0

Loading.... (view fulltext now)

Full text

(1)

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

(2)

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

(3)

,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 izkslsl 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

(4)

Computer ds Hkkx

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

dat

aa

a

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 gSa

A 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

COMPUTER

(5)

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; laca/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 izksxzke dks laxzzg 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

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)

MEMORY

Primary

Memory

Secondary Memory

(6)

☻ 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 gSaaA

☻ 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 loZizFke 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

(7)

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

Hardware

dk 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

g

ks

rk gSA tks

Computer

vkSj

user

ds chp

communicate

djrk gS A

(8)

Operating System ds dk;Z

1. User

dh Hkk"kk dks

Computer

dh Hkk"kk esa vkSj

Computer d

h 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 izksxjke [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+kssa esa

Memory

es

Save

djrk gSA blds ek/;e ls NksVs&NksVs VqdM+kssa 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

(9)

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

(10)

Booting Process

Switch on    Rom activated   

Boot strap loader



Operating starts loading into RAM

  

(11)

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 Excelworkbook /charting programme

(12)

♣ MS AccessRDBMS (Relational Database Management System)

Programme  ♣ MS Outlookorganizer programme ♣ MS Publisher D.T.P. package

♣ MS front pageWeb editor/Web designer.

(13)

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 gSA

Typing

dh 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

S

s

oftware

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

(14)

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 lqnaj cuk;k tk lds A

♫ Graphics :-

MS Word

esa

document

esa vko’;drkuqlkj

drawing

dks

lfEeyr fd;k tk ldrk gS A

(15)

♫ 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

laca/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 Word

esa

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 Word

esaa

automatic formatting

(16)

MS Word

dks fuEu izdkj ls open fd;k tk ldrk gS

Start on   Programs   MS Office   MS Word

(17)

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

(18)

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

(19)

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 [khpsaxsA

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

(20)

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

,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 :

ij

click

djsaxsa ftlls

dialogue box

fn[kkbZ nsrk gS

Heading 1 ▼

(21)

vc bl

dialogue box

es ls

all styles dks select

djsaxsa 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

(22)

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

(23)

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

(24)

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.

w

ord

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

(25)

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 <ax ls djrk

gSA blesa ,d foLr`r

spreadsheet

;k

worksheet

gksrh gS ftlds izR;sd

column

es ,d

data

fy[kk tkrk gSA p¡wd

MS Excel

esa os lHkh dk;Z fd;s tk ldrs gSa tks

DOS

esa dk;Z

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

(26)

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

(27)

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

(28)

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

(29)

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

(30)

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

(31)

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

(32)

Graph

ds ek/;e ls

dat

a

a

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

(33)

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

(34)

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

dksss

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

powerpoint

ea fofHkUu

slides

dks

design templates ,colour schemes

rFkk

animation effect

ds }kjk

attractive or effective

cuk;k tk ldrk gS A

(35)

Powerpoint Screen windows or layout

Powerpoint

dh fo’ks"krk;sa

(36)

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.

(37)

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

(38)

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.

(39)

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.

(40)

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 djsaxsa

References

Related documents