me reading or writing and editing k liye kiya jata hai.

a. View : Gridlines ko sheet par show or hide karne k liye view k aage check
( ) par click karna hota hai.
b. Print : Gridlines ko Print me bhi show or hide karne k liye Print k aage check
() par click karna hota hai.

Headings :- Rows k side me show hone wale numbers (1,2,3,4 etc.)ko Row heading or Column k uper
show hone wale letters (A,B,C,D etc.)ko Column heading kahte hai.
a. View : Row or Column Headings ko sheet me Show or hide karne k aage check
() par click karna hota hai.
b. Print : Row or Column Headings ko Print me Show or hide karne k liye Print k
aage check () par click karna hota hai.

Bring To Front :- Bring To Front ka use Selected object ko sheet k baki sabhi objects k uper ya Top me lane k liye
kiya jata hai,
Bring Forward ka use selected object ko ek-ek step karke baki sabhi shapes k Top me lane k liye
kiya jata hai.
Send To Back :- Send To Back ka use Selected object ko sheet k baki sabhi objects k sabse last me lane k liye
kiya jata hai,
Send Backward ka use selected object ko ek-ek step karke baki sabhi shapes k last lane k liye
kiya jata hai.

Selection Pane :- Selection Pane ka use sheets k objects 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.

Align :- Align command ka use selected objects ko properly alignment dene k liye kiya jata hai, iske liye pahle
sabhi shapes or objects ko SHIFT k sath select karke Top, Bottom, Left, Right, Middle, Center etc.
alignment de sakte hai. objects k beech ka Horizontally or Vertically Gap Distribute Horizontally or
Distribute Vertically command k use k equal kiya ja sakta hai. Shapes ya objectes ko gridlines k sath
snap karne ya magnat effect dene k liye Snap To Grid command ka use kiya jata hai, iske use se
Shapes Gridlines se touch hoker move hoti hai, Gridlines ko sheets me Show/Hide karne k liye Show
Gridlines ka use karte hai.

Group :- Do Ya Do se zyada Objects ko SHIFT k sath select karke Group command k use se joda ja sakta
hai, jisse sabhi Selected objects ek sath Group ho jate hai, Grouped objects ki movement, size changes,
Rotation etc effect ek sath hote hai.
Grouped objects ko vapas normal karne k liye ya alag-alag karne k liye Ungroup command ka use kiya
jata hai
Ungroup kiye huye objects ko vapas Group karne k liye Regroup command ka use kiya jata hai.
Rotation :- selected objects ko Rotate karne liye Rotation ka use kiya jata hai, iske use se Shape ko 900,
1800, 2700, 3600, etc k angle se rotate kar sakte hai.

FORMULAS
Trace Precedents :- iska use selected cell k formula me used cells ko arrow se show karta hai, ya selected
Cell ko effect karne wale cells ko arrow se show karta hai,

Trace Dependents :- jis cell ko apne select kiya hai us cell ki value ko agar kisi formula main use kiya ho to

wah uspar arrow laga deta hai. Example:-

Remove Arrows :- Trace Precedent Or Trace Dependents se lagaye gaye arrows ko hatane k liye iska
use hota hai.

Show Formulas :- iske use se Sheet me Formula Mode ON ho jata hai, jisse sheet k har ek cells me lage
huye k formula show ho jate hai.
(Ctrl+`) k use se bhi Formula mode on kiya ja sakta hai.

Error Checking :- iska use cells me lage huye formulas me galti ki checking karne k liye kiye jata hai, jab
kisi cell me galat formula enter karte hai to us cells me (#Value!) ka message show ho
jata hai, formula me huyi galati ko dhundne k liya, us cell ko select kar k Trace Error ka
use kiya jata hai, jisse Arrows show ho jate hai jaha galati hoti hai.
Evaluate Formula :- selected cell me lage huye formula ko evaluate karne k liye iska use kiya jata hai, iske
use se selected cells k formula k har part ko ek-ek karke sare steps alag se Dialog box
me show karta hai.

Watch Window :- kisi selected cells ke bare me sari information dekhne k liye watch window ka use kiya
jata hai. iske liye pahle watch window par click kake, Add watch par click karke fir
kuch
cells select karte hai, jinke bare me information dekhni hoti hai, fir ise Add kar dete hai
or selected cells se related sari information jaise cell address, value, sheet, file name,
formula etc.

DATA

Get External Data & Connection :- Excel ki Sheet par kisi dusre user se kisi bhi trah ka Data or information
import karne k liye in commands ka use kiya jata hai, iske use se hum
required information Microsoft Access, Web(Net), ya kisi or source se
 Data ko Import karke Link create kar sakte hai. jise Refresh command
ka
use karke Time to Time Update kiya ja sakta hai. Properties command
ka use karke in connections k bare me sari information Dekha sakte
hai.

Sort &Filter :- We already have been learnt these commands in Home.

Advance Filter :- iska use kisi Particular condition or Range k according Data ko kisi alag jagah par show karne k
liye kiya jata hai.
Steps:
1. iske liye pahle koi criteria ya condition kisi cell me likhte hai, eg. Total>350, class=12th etc.
2. fir Advance filter pe click karte hai, jisse ek Dialog Box khul jata hai.
3. ab isme sabse pahel Copy to another location par  Mark karke ,
4. List Range k aage click karke puri marksheet ya Data select karte hai.
5. Criteria Range k aage click karke condition or criteria select karte hai.
6. Copy To k aage click karke us jagah par click karte hai jaha par output show karna hota hai.

Text To Column :- ek hi cell me likhe huye Text matter ko alag-alag column me distribute karne k liye Text
To column ka use kiya jata hai,
Steps:
1. Sab se pahle us cell par click karna padta hai jiska matter alag-alag column me
Distribute karna hai,.
2. fir Text To Column par click karte hai.
3. jisse ek Dialog Box khul jata hai, ab isme Next kare.
4. fir Mark (Nishan) lagate hai jaha se Text ko Distribute karna hota hai.
5. fir dobara Next par click karke Finish karna hota hai.
isse Text matter alag-alag column me show hota hai.
Remove Duplicates : Sheet k Data me Duplicate values ko Remove or Delete karne k liye Remove Duplicates
command ka use kiya jata hai, isme column bhi specify kar sakte jinme se Duplicates
Rows ko Hatana ho.
Steps:
1. sabse pahle Data ko select karte hai.
2. fir Remove Duplicates me click karte hai, jisse ek Dialog Box khul jata hai.
3. ab un field par () check karna hota hai jinme se hum Duplicates values ko hatana
chahte hai, fir OK click karte hai.
4. ab screen par ek message show ho jata hai jise OK karte hai.
Selected Data ki Duplicates values Remove ho jati hai, or sirf Unique Data raha jata hai.
Data Validation :- iska use Selected Blank cells me Data enter karne ki limit ko specify k liye kiya jata hai,
jisse Invalid Data ko Blank cells me Enter karne se roka ja sakta hai or Data me
Wrong Entry hone k Chances ko kam kiya ja sakta hai, or file ki accuracy ko protect kiya
ja sakta hai.
Steps:
1. sabse pahle kisi bhi blank area or cells ko select karte hai jaha Data ko condition
dekar limit lagana chahte hai .
2. Fir Data validation par click karte hai jisse Data validation Dialog box open ho jata
hai.
3. Is Dialog Box me se Settings par click karke, ab valid Data k liye criteria de, eg.
Minimum value 1 and Maximum value 100.
4. ab Error Alert par click karke yaha invalid Data type karne par Show hone wale
message and Title type kare, eg. Title : STOP, Message : wrong entry
5. ab OK par click kare.

Isse Blank area par Valid Data enter karne ki limit Fix ho jati hai, Invalid Data blank area
me enter nahi hota ager galati se invalid Data likhte hai to vaha Dialog Box me ek
message Show ho jata hai Retry k liye.
Ise vapas normal karne k liye ya Blank Cells par se Validation hatane k liye, pale Cells
Select kare jaha Data Validation lagi hoti hai, fir Data Validation me jaker Clear All par
click karte hai.

Consolidate :- iska use same Title vale records ki values ko new Range me Combine karne k liye kiya jata hai,

Steps:
1. sabse pahle Blank Area select karte hai jaha par combine Data Show karna chahte hai.
 2. fir Consolidate pe click karte hai, jisse Consolidate Dialog Box khul jata hai.
3. Function k aage click karke function select karte jiske use se Data ko combine karna chahte
hai, eg. Count, Sum etc.
4. Reference k aage click karke, Data Select karte hai jiski values ko combine karna hota hai.
5. fir ise Add karte hai.
6. ab Top Row and Left column par () check mark karte hai.
7. ab OK par click karte hai.
isse Dusri khali jagah par same Title vale Data count ho kar show ho jate hai.

What If Analysis:-

a. Scenario Manager : iska use kisi bhi data or information ki values k alag-alag Groups or sample
banane in samples ko alag-alag situation me use karne k liye ya fir different
values k effect ko campare karne k liye kiya jata hai.

Steps:
1. Sabse pahle Data ya cells select karte hai jinke liye new data k alag-alag
Sample banana hai, iske liye koi bhi Column or Row select kar sakte hai.
2. Ab Scenario Manager par click karte hai, jisse ek Dialog Box khul jata hai.
3. Yaha selected Data k liye new sample banana k liye, Add par click karte hai
fir scenario or sample ko name dekar OK karte hai.
4. ab ek dusra Dialog Box khul jata hai, isme New values likhte hai, Tab key
ko press karke , fir OK karte hai.
5. ab dobara dusri values ka group banana k liye fir se Add kar ke Scenario
name Dekar OK karte hai, fir sample ki values ko Tab key use karke
change karte hai, or OK karte hai. is process ko bar bar tab tak repeat karte
hai jitne bhi sample ya Group banana ho.
6. Iske bad jis bhi Scenario k according value show karna chahte hai, us
sample par click kar ke Show par click karte hai.
7. Kisi bhi Scenario or Group ko Delete karne k liye Delete par click karte hai.
ab sheet me Data new scenario k according show ho jata hai.
b. Goal Seek : jab kisi cell Data or Output or Result accurate nahi aata tab iska use formula
me Wrong (Galat) Input ki huyi value ko Right(Sahi) karne k liye kiya jata hai,
jisse Data k Input or Output dono Right ho jaate hai.

Steps:
1. sabse pahle cell ko select karte hai jisme Wrong Answer or Output hota hai,
eg. Total
2. fir Goal seek command par click karte hai, isse Dialog Box Khul jata hai.
3. ab yaha To Value k aage click karke Right Output likhte hai, accurate hota
hai.
4. fir By Changing Cell k aage click karke us cell par click karte hai, jisme
Wrong Input or information hai, jiski vajah se Data me Wrong Output Show
ho raha hai.
5. ab OK par click karke, dobara OK kartehai.
isse Data ka Input and Output dono Right ho jate hai.

c. Data Table : iska use se kisi bhi Result k formula me alag se additional Input dekar same
time
par dusra result or Output dekha ja sakta hai.
eg. Students Mark sheet k Total me 10 Marks Plus or Minus karna.

Steps:
1. Sabse pahle us Formula k sath wale cell par click kare jisme Input ki
additional unit add karke alag se result show karna hota hai.
2. ab is cell me Formula enter karte hai. eg. ager Mark sheet me Students k
Math me 10 Marks Plus(+) karne hai, to cell me F3+10 Formula enter
karenge. F3(Math column).
 3. ab ise purane result k sath neeche tak select karte hai, jaha par records
khatam ho jate hai.
4. fir Data Table par click karte hai, jisse Dialog Box open ho jata hai.
5. fir Column Input Cell k aage click karke cell name likhte hai, jisme Marks
change or increase karne hai, eg. F3
6. ab OK par click karte hai.
new column me input ki huyi information k according new Data Show ho jata
hai.

Group :- Group : iska use kisi bhi selected area k Row or column ko ek sath Group karne k liye

kiya jata hai, jisse particular Group kiye gaye area ko Show or Hide kar sakte
hai.
Steps:
1. sabse pahle area select karte hai, jise Group karna hota.
2. ab Group me jaker Group command par click karte hai jisse ek Dialog Box
Open ho jata hai.
3. ab Row or Column jise bhi Group karna hota hai use  Mark kake, OK karte
hai.
4. yaha Group huye Row or Column par Grouping Line ban jati hai, jis par (+)
Show and (-) Hide k sign indicate ho jate hai.
5. yaha (+) par click karke Gouped Data ko File me Show and (-) par click karke
Hide kiya ja sakta hai.

Auto Outline : iska use bhi area Group karne k liye kiya jata hai, but uske liye Row or
column ko select karne ki zarurat nahi hoti ye Grouping line
Automatically insert ho jati hai jaha bhi koi formula laga hota hai or
Data ko Group kar deti hai, jisse use Show or Hide kiya ja sakta hai.

UnGroup :- UnGroup : iska use Group kiye gaye Data ko vapas UnGroup karne k liye kiya jata
hai, isse Row or column vapas pahle vali position me aa jate hai.
 Steps:
1. Sabse pahle Groupe area ko select karte hai.
2. Ager Groped area (-) Hide ho to pahle use (+)show karna padta hai.
3. Fir Ungroup me jaker UnGroup par click karte hai, isse Dialog Box khul
jata hai.
4. Yaha Row or column jise bhi Ungroup karna chahte hai us par  Mark
karte hai.
5. ab OK par click karte hi Selecte Grouped Data UnGroup ho jata hai.

Clear Outline : Auto Outline ko Remove karne k liye iska use kiya jata hai.

SubTotal :- SubTotal ka use Selected Data k Rows se Related Field ko ek sath Summarise karke Significant
Manner me Show karne k liye kiya jata hai.

Steps:
1. sabse pahle Data select karna hota hai, jise summarise karna chahte hai.
2. fir Data kid us Field or heading kop Acsending or Decsending Order me Sort karte hai, jiske
according Data ko Classify karna hota hai. eg. Class, Roll no.
3. ab SubTotal par click karte hai, isse Dialog box khul jata hai.
4. ab At each change In k neeche click karke us field par click karte hai, jiske according Data ko
classify karna hota hai eg. Class, Roll no.
5. ab Use Function k neeche click karte hai, yaha wo function llikhte hai, jisko Data
summerising karne k liye use karna hota hai, eg. Sum, Count etc.
6. ab Add SubTotal To k neeche click karke Data se related Field par () Mark karte hai, jin
par Function ka use kiya jayega. eg. Subjects, Total, Avg, class etc
7. ab OK par click karte hi Selected Data Diye gaye Function k According Summurized hoker
show ho jate hai.
8. selected Data kop vapas normal karne k liye, Subtotal me jakar Remove all par click karte
hai

REVIEW