Ms-Excel 2007

HOME

Cut :- iska use kisi select kiye gaye records ko cut karne k kaam aata hai but ye data paste hone k

baad

he apne jagah se khatam hota hai.

Copy :- iska use kisi bhi selected matter ko copy karke kisi dusri jagah paste karne k liye hota hai.

Paste :- Cut or Copy kiye gaye matter ko dusri jagh paste karne k liye iska use hota hai.

Format Painter :- kisi selected matter k format or design ko copy karke kisi dusri jagah paste karta hai.

Font style :- selected matter k font style change karne k liye iska use kiya jata hai.

Font Size :- selected matter k font size change karne k liye iska use kiya jata hai.

Grow font :- selected matter k font ko increase karne k liye iska usae kiya jata hai.

Shrink font :- selected matter k font ko decrease karne k liye iska use kiya jata hai.

Bold :- selected text ko bold/dark karne k liye iska use hota hai.

Italic :- selected text ko tircha karne k liye iska use hota hahi.

Underline :- selected text ko single ya double underline dene k liye iska use kiya jata hai.

Border:- :- selected cells ko border dene k liye iska use kiya jata hai.

Fill color :- selected cells k base me color fill karne k liye iska use kiya jata hai.

Font color :- selected cells k text ko color karne k liye iska use kiya jata hai.

Alignments :- selected cells k matter ko Top align, Bottom align, left align, right align, middle align, ya
center Alignment de sakte hai.

Orientation :- selected text ki direction change karne k liye iska use kiya jata hai.
Decrease indent :- selected cells k border or usme likhe text k beech ki margin ko decrease karta hai.

Increase indent :- selected cells k border or usme likhe text k beech ki margin ko increase karta hai.

Wrap text :- kisi cell me likhe text jo cell se bahar lilkha ho use ek hi cell me adjust karne ke liye iska

Use kiya jata hai.

Merge :- selected cell ko ek sath jodne or Merge karne k liye iska use kiya jata hai.

a. Merge & center selected cells ko merge karke center se likhta hai.
b. Merge Across selected cells ko is tarah merge karta hai k sirf verticals lines gayab ho
jati hai or sirf horizontal lines rah jati hai.
c. Merge Cells bhi selected cells ko merge karta hai lekin us cell me left side se likhta hai.
d. Unmerge cells merge ki gai cells ko vapas unmerge kar deta hai.

Number :- iska use selected text me $, %, or decimal, commas etc. sign ko add karne k liye use
Kiya

Conditional Formatting :- iska use selected data ka condition deker format or design dene ke liye
kiya jata hai. Condition k according rules lagaye jate hai or fir data ka
format automatically rules k according change ho jata hai.
Cells ko vapas pahle jaisa karne k liye clear rules me jaker clear rule from
Selected cells karna padta hai.

Format As A Table :- iska use kisi selected data ko Decorate karne k liye kiya jata hai. Iske use se Normal
Data ko Designed Table me convert ho jata hai or us par automatically Filter lag jate
[Link] is pahle jaisa karne k liye Ctrl+Z ka use kiya jata hai.

Cell Style :- Selected Cells ko Decorate karne k liye isme Pre-Installed samples hote hai, in Samples
me se kisi bhi Sample par click karte hi Selected Data Choose kiye gaye Style k
according Decorate ho jata hai.

Insert :- iska use Sheet me New cells, rows, columns, ya sheets ko lane k liye kiya jata hai.

Delete :- iske use se extra cells, rows, columns, ya sheets ko delete karne k liye kiya jata hai.

Format :- Cell size

a. Row Height : iska use selected rows ki height ko increase ya

 decrease karne k liya kiya jata hai.
b. AutoFit Row Hight : Iska use selected row ki height ko vapas
normal karne kliye Kiya jata hai. Rows ki
normal height 12.75 hoti hai.
c. Column width : Iska use selected column ke width ko increase
ya decrease karne k liye kiya jata hai.
d. AutoFit Column width : selected cell mai likhe text ki length k
according column width ko adjust karta hai. Ise
vapas normal karne k liye column width me
jaker 8.43 type karna padta hai.
e. Default Width : ye columns ki standard width check karne k
liye kiya jata hai. Columns ki normal width
8.43 hoti hai.
Visibility

Hide & unhide : iska use selected rows, columns, sheets ko hide ya

Unhide karne k liye kiya jata hai.

Organize sheets

a. Rename Sheet : iska use sheet ka Name Change k liye kiya jata hai.
b. Move or copy sheet : iska use kisi bhi selected sheet ki copy create
karne ya usko ek jagah se dusri jagah par par
move karne k liye kiya jata hai.
c. Tab color : iska use sheets ko different colors dene k liye kiya jata hai.

Protection

a. Protect sheet : iska use selected sheet ko password deker lock lagane
k kiya jata hai. Or fir use par se lock hatane k liye
unprotect sheet me jakar same password dena hota
hai.
b. Lock cells : iske use se kuch selected cells ko is tarah lock kar diya
Jata hai jisse un cells par Protection ka koi effect nahi
padtda.
c. Format cells : selected cells ki formatting k liye is commad ka use kiya
Use kiya jata hai.

Sum :- iska use selected cells ka sum, avg, max, min, ya excel k or functions ka use karne k liye kiya
jata hai.
Fill :- Fill : Up, Down, Left, Right, fills command ka use kar k selected matter ko copy kar
sakte hai.

Across worksheet : iska use kisi bhi sheet k selected matter ko bina copy
Paste kiye 2 ya 2 se zyada sheets me ek bar me hi copy karne k
lye kiya jata hai.
 Series : iska use table banane, uska squre yani growth nikalne and date aadi ki series
nikalne k liye kiya jata hai.

Justify : iska use se ek hi cells me likhe huye matter ko is tarah adjust karne k liye kiya
jata hai k matter alag -alag rows me distribute ho jata hai.

Sort & Filter :- Sort A to Z : iska use selected column ko Ascending order me sort karne k liye kiya
jata hai.
Sort Z to A : iska use selected column ko Descending order me sort karne k liye kiya
jata hai.
Custom sort : custom sort k use se sort dialog box khul jata hai jiske multiple options
ko use kar k selected matter k kisi bhi columns ko sort kar sakte hai.

Filter : Filter command k use se Kisi bhi selected cells me filtration on ho jati
hai. Ek bar filter lagane k bad selected cells par filter box ban jate hai.
Iske liye filter box par bane arrow par click karke pahle condition di jati
hai. Jiske use se values me conditions lagakar record dekh sakte hai.
Example: agar hume sirf 12th k student ki list show karni ho to hum
class k upar lage filter box par click kar uski list main 12th k box ko tick
() kar k on karege or baki sabhi boxes ko off kar denge, to selected
Data me sirf 12th k students ki list show hogi, or baki records hide ho
jayenge.

Or agar filter ki condition ho hataker vapas normal karna ho to usi

column k arrow par click karke clear filter from class par click kar usko
hataya ja sakte hai.

Is tarah se koi bhi filter ka use kar hum selected Data me alag- alag
conditions laga kar records ko filter kar sakte hai.
 Clear : Selected data lage huye filter boxes or filter conditions ko hata
kar records ko vapas normal karne k liye clear command ka use kiya
jata hai.

Reapply : selected records mein conditions lagane k bad, ager new records add
kiye jate hai ya fir selected data me kuch changes kiye jate hai to un
new records par bhi same condition lagane k liye reapply ka use kiya
jata hai. Jisse new data bhi condition k according show ho jate hai.

Find & Selected :- Find : iska use words ko find karne k liye kiya jata hai.

Replace : iska usekisi word ko badalne k liye kiya jata hai.

GoTo : GoTo command ka use kisi bhi Particular cell par jane k liye hota hai.
Example: L 90, P20, H1000, K500.

GoTo Special : iska use kisi special command k area ko select karne k
liye kiya jata hai.
Example: Conditional Formatting , Data validation,
Trace Precedents , Last cell etc.

Formulas : iska use sheet me formula wale area ko select karne k

Liye kiya jata hai.

Comments : iska use sheet me lage huye comments ko select karne

k
liye kiya jata hai.

Conditional Formating : sheet me conditional formatting wale area ko select

karne k liye iska use kiya jata hai.

Constant : iska use sheet ki constant values ko select karne k liye kiya jata
hai. Constant values esi values hoti hai jo fix hoti h or jo
formula k according change nahi hoti hai. Sheet me lage
formula constant values par depend hote hai. Or usi k
according change hote hai.

Data Validation : iska use sheet k ese area ko select karne k liye kiya jata hai
jisme
Data validation lagi hoti hai.

Select Object : select object command on karne se selection cursor change ho

jata hai. Jiske use se sheet k objects ko select ya move kar
sakte hai. But sheet ka baki hissa jo object nahi hai normal text
hai select nahi kar sakte.

Selection Pane : is command ka use sheets k object ko individually select karne

k
 liya ya unka order change karne k liye ya selected objects ko
show or hide karne k liye bhi iska use kiya jata hai.

INSERT

Pivot Table :- Pivot table ka use Selected Data k liye ek alag sheet par summarized Table Banane k liye kiya
jata hai. Jisse Selected table new sheet me summarize ho jati hai. Or Table easily way me
arrange ho jati hai. Iske sath sath Table par Filter boxes bhi lag jate hai. Or Pivot table k tools
bhi khul jate hai jinka use kar k data se related graphs or charts banaye ja sakte hai.

Table :- seleted data ko usi sheet par Table provide karne k liye iska use kiya jata hai. Jisse single sheet
Par data ko sort, filter, or decorate karne k liye iska use kiya jata hai.

Picture :- sheet par picture lane k liye Picture command ka use kiya jata hai. Or Picture Tools k use se
Picture k style change kar sakte hai. Normal picture me brightness, contrast, color, picture
shape, rotation, crop etc. Effects de sakte hai.

Clip Art :- iska use sheet me picture, cartoon, photograph, movie clip, audio, etc. insert karne k liye kiya
jata hai . picture tools k use se in arts par alag alag effect de sakte hai.

Shapes :- sheet me ready made Shapes jaise circle, rectangle, triangle, arrows, lines, Heart, etc. lane
k
liye iska use kiya jata hai. Drawing Tools k use se insert ki huyi shape me alag-alag effet de
sakte hai.

Smart Art :- smart art k use se document me Data se related Diagrams insert kar sakte hai. Iske use se kisi
bhi information ya data ko diagrammatically show kar sakte hai. For example : Flow charts,
Process charts, cycle charts etc.

Tata Co.

del cal madras

cp ap

start Programme Ms-Office Ms-Excel

Chart ` :- chart kar use selected Data k liye Graph banana k liye kiya jata hai. But Data me numeric value
Honi zaruri hai. Is command k use se hum different types k chart use kar sakte hai, For
Example:
Bar Chart, Pie Chart, Column Chart etc.

Hyperlink :- is command ka use kisi file, folder, web page, picture, video etc k sath Direct link
banana k liye kiya jata hai, jisse link ki huyi file ko directly just click karke excel me khola ja sake.

[Link]

Text Box :- is command ka use file me Text Box lane k liye kiya jata hai. Jisme kuch bhi likha ja sakta hai, or
Drawing Tool k use se us box ko Formate or design bhi kar sakte hai , iski shape badal sakte hai,,
box ko sheet me kahi bhi move ya copy kar sakte hai.

Header & Footer :- iska use Document me Header or Footer lagane k liye kiya jata hai. Header me likhi
huyi Information Page k Top me or Footer me likhi huyi information har Printed Page k
Bottom me Show hoti hai. Header & Footer me hum Date & Time, Page umber,
Picture ya koi Text etc likh sakte hai. Ise hatane k liye vapas Header & Footer me jaker
likhi huyi Information ko erase karna padta hai. Or fir sheet normal karne k liye View
me jaker normal par click karna hota hai.

Word Art :- iske use se sheet me decorated Text ko lane k liye liya jata hai. Isme different style k Text
formate hote hai. Jinme se koi bhi style select karke apne Text matter Type kar sakte hai,
drawing toolbar k use se Text ko or bhi decorate kar sakte hai.

Signature Line :- Signature line ka use Digital signature add karne k liye kiya jata hai. jisse user ko digital ID
provide ki ja sake.

Object :- Object ka use file me kisi dusre Application ko Direct kholne k liye kiya jata hai. Jaise Paint
Kholne k liye Object me jaker Bitmap Image par click karna hota hai, isse excel me hi paint
khul jata hai.

Symbol :- is command ka use sheet me ese symbol or character lane k liye kiya jata hai, jo keyboard me
nahi hote. For Example : , ©, ™ , , , , 

PAGE LAYOUT
Themes :- +

Margins :- Margin ka use current document me page ko Left, Right, Top, Bottom se Margin Size dene k
liye kiya jata hai. Iske use se document ki margin ko apne according normal, wide, narrow ya
fir custom margin me jaker khud se margin set kar sakte hai.

Orientation :- Orientation k use se page ki position ko change kar sakte hai, iske use se Page ko Portrait ya
Landscape Positions de sakte hai.

Size :- is command k use se current paper ko Size dene k liye kya jata hai, Paper ko A4, A3, A5,
Letter, B4, B5, Legal etc. size de sakte hai.

Print Area :- Sheet k kisi selected area ko Set Print Area Command k use se Mark kar diya jata hai jisse Set
kiya gaya area hi Print preview or Print me Show hota hai , Sheet ka baki hissa Print me Show
nahi hota, ise wapas normal karne k liye Clear Print Area par click karna hota hai.

Breaks :- Break k use se Page me Breaks dale jate hai, Mouse se click karke Pahle Area Specify karna
padta hai jaha se hum naya page lana chahte hai ya fir jaha se Page ko Break karna chahte hai,
fir Insert Page Break par click karne k bad Specified or selected Cell k uper or Left side sehi
PageBreak ho jata hai, yaha Page Break ki line Bhi show ho jati hai. ise vapas normal karne k
liye ya fir Break ko hatane k liye, usi jagah par click karna hota hai jaha se break lagaya gaya tha
fir Clear Page Break command par click karke Break ko hataya ja sakta [Link] sheet me ek se
zyada Break Lage ho to un breaks ko normal karne k liye Reset all Page Breaks par click karna
hota hai.

Background :- Background k use excel ki sheet par koi Picture laga sakte hai, ye picture fir sheet k
background
me show hoti but background ki picture Print or Print Preview me Show nahi hoti. Background
ko hata kar sheet ko vapas normal karne k liye Delete Background par click karne padta hai.
Print Titles :- Print Titles ka use Sheet ki kuch Specific Rows or Columns ko set karne k liye kiya jata hai, jisse
specified rows or columns har Printed Page me as a Title Show hote hai.

Width, Height, Scale :- sheet me likhe matter ko Page limit a according adjust karne k liye in commands k
use
kiya jata hai. inke use se sheet k matter ko page limit k according Grow ya shrink kiya
ja
sakta hai, jisse page ki limit k bahar aane wala matter usi Page ki limit me fit ho jata
hai. sheet k matter ka Grow ya shrink hona Scale percentage (%) par depend karta hai:

a. agar scale 100% se kam hai, (<100%) to Sheet k matter ka Font Shrink hota hai, or
Data page ki limits k according Shrink ho jata hai,
b. agar scale 100% se zyade hai, (>100%) to sheet k matter ka Font Grow hota hai,
c. scale k 100% hone par, (=100%) ye matter ka actual size show karta hai.

Gridlines :- Sheet k rows and columns k beech ki lines ko Gridlines kahte hai, inka use Data ko easily way