Page Na
Date
NAME KUS HAL CrtRISH DHARYA
ROLL NOD
BATCH TYBCOM BATH 2 MG)
Page Na
Date
M$ EXCEL
A PRACTiCAU A2O MA
Calculat ti total fon Rak uouo
And La olumu
Sn &huut nte tlaegelloug
data
A
B D Cr
RuanchJan eb Ua may un
Muwbo 50000 O000 7O00 T5000 75t00 TOCC
Delni 20000 24000 30000 20000 3500o 40000
Lhinnq 4s000 SO00o550006o0c0 SSOCO SOOoO
) Calculoui twtol ach Row
selert ull H2
Lpe t hounula aA =Sum (B2:G2
iing ha jilhandle duoq tll H
i) Calculale total sf Lech column
ARll
Tupt AVS ourmuulo as = Sum (B2 Ba.)
L a he handle dua i CS
Qutpu
Page No.
Date
C D E F
Buanthan ab Ma dpo May unTota
Munbal
ibal 50000
5 6000o 10000 75000 1500o 70000 40000o
2/
35000 40000 I6a0obo
Delhi 20000 24000 50000X000
3Delhi
5Do00 3 150DO
Lhennau 50000 50DD0 5500060000 55000
160000
TOto 5000 13400O 155000 155000165000
5
Duplau Aels detali wheu buanch
totalLKULOLS 26DOCO
elutul AL (ou hi whole data)
go o data tab and sulut l t
Dpluen
selet th duop doen ADO button
Totou andAlt numbu Ulter
uk n uoÜu opton cunol i n
th guen duolco bok.
upe 250000ancd clk Ante
Output
A D
Boordh an Jeb JUa apu ay un To
2umboi 50000 60000 TOUOO 5D0O 7500o 10000 40000
thunnail 50000 50000 55000 600005500o SOO003500
3Laluulate theauage min and
max Nauuus Hou Ah uDu anc
colunun
/ PageNa
Date
o oluwns
DJarns oumn TL JLAnol kau JUa
Jun Lno uage
Alut l 12 ano tupe h i umula
OL =a x (B2 q2)
Juing he lhanddle c a g Ul D4
ii) 8elt ull Jand tupk the oumul
CL Mun (82: 2
uinath hlhanclle duog til J
tt tluct kall k2 Anol typt tha Houmula
OA duuage (82:G2)
Alng thu i l hanoll duag tiu E
ou RDLLL
cAR AG ATand A& speiluuely
lu LOU BG cnel upe thi
Ounula cA MaxCB2:84
wwwwq h handeoduay til G6
i) Aetet cull 87 ano Jupt umula
Os Mun (B2 B4)
Llng handlu duog iu T7
)4i Lll 88 ond kyp foumula
JALng uLR handu duaQ till G8
A B D
uanch Jan tb JUae p u May
2 mbaiS0000 15c6
6C000 70000 75C00
3 OLLhi 20000 24000 5000020000|3500o
4 channou 45000 50COD55000 6OC00 55 000
15000 34000 155000 155000 6SDOo
5 Jota
50000 6OC00 70000 7500015O00
20000 24000 30000 20000 35000
5500Do
3 duwuoage 38322333 44666-67 51666 67
6166667
G
un Total min AuULOge
2 700C 400000 75000 50000 66666.67
3 40000 6c00 4000020000 28t66. 67
45DCOo3150o0 6o00 45000 52500
6obo
TOOoO
40000
5353 33
4 uae chaut Jnclicating
peLCniage coniuubuuo s toe
unoui ko umbai and chennal
Beanch
slect ul A2 (Mumbai)A-Cchennai
Ha(dotal Uunmboi) and H4ctal s
Chenno
Page Na
Date
Co JD InAut, &ilt pie chaut 2d
Wous cuuk n th pilduaguam
Rignt RicR ond selut poumat dalo
Lobe
Nou ALlt ht pu craut AgCun. o
o oumat dcta cbels
puiinlage un tabe 0plion
uthut
p chcut undicoting Jetol tuunsu
RO urnbotcun Chunnou Beuanch.
Murvbol
DOnnai
40000o
561
Piechooit
5CLL o une guaph that alleu
conmhouuuonebeuonch tunower
mDnAh umoal
Page Na
Date
&eliutAeeom Al te CS
Alocl lunt
chaut2o unu charlD
Qutpuut
n Lhou
20002
10000
60000|
50000
40000
30000
20000
10000
Jan feb Ma dbr ay un
Mumbai
ChennOL
.2
9p hexl 2 n Jhe Aolloung table
A B C
2006 07 2007-OR 2008 -09
2 2361 (4-5 178 55
Page Na
Date
heBock Nalu bu hau o
houutng Ranance connhanyou Lo
east axt hLL tau Ahouon un th
tablebelous Rucus coumn chco
ento h foRlouing tahl un het
A C
2006-07 2001-08 2008-09
l23.67 145 78.55
AARL2-D column c h a t
ure
ArehLAcding Os ouLung dtnance
HpuAung unonce
200
150
100
50
2006-01 2001-08 2008-02
Page Na
Date
.3
nAhut3, entu thu jolLcutng detau
A I03 B
D
emp NNo Namne Oebautmrd Salau
A23
2
E30
Sughant dupuw 50000
4 A12
ouport 35000
5 920
PauLa dccDuntu 40000
&alu 30000
6 ED5 Madhuaenpouts 22C0o
814 Kiuan 60000
s l t Jhetabl
o o Aata tablu and cick on fin
oplip
DLAploau only MoLl ou uohuRAalauy
A moue h a n 45000
K c the duop douon auLOLS buttor a
Balay nd selct mumbu t
Llick on qural oplion And un the
iendialog beo.
Juhe 45D00 and liok entu
uthwt
A D
ump No Warne Oectmnt Solaus
2 A23 uhantoccomu 50000
S14 Kuan Aals 60000
Page Na O
Date
o)Dihlay onlu thot D hlle Aalo
LeAslessh a n 0 0 o l Jo 30000
Alu the duo douonAuous buUon
Aalauy and Aluot nuum.ben 4Ul
COick on esa thon OL auol tb Lti
un the win dicloa box
upe30000 Ano cluck unlo
A B C D
mp Wo Name Nobautmert Relauy
5 S20
30000
GEO5 Wachuwa uot 22000
Auplou only dho MOuL wheuue Aalou
LS mo than 35000 but lessJUnaun 5
Al Ihi duoe doun elouS button o
Lalouy Anc &lLct number U
CoR n buiwLL OlaUon
unCue
dialeg boo
Nype 35 bOO Anc 50000 ick ne
A
D
nmp o Wame Depautment
A23 Auahant AUDun olau
B30 50000
4 A1
20gdap 35000
fouu UDwiu 40000
PageNa
L
pale
4)Display only those u0ue h u
dlhaitnmintissalus
Aeteul th duoh down auuo hulb &g
defauinunt and silri wt ter
clck Dn equals n he Quien diaLea
6k pe &eulu Cnd eluuk un
A
1CumpNo WameQebaui Lau
592C gauuu 30000
7 St4 KuanAal 6O0O0
SQshlay ony thoae UDS Jh0L Name
ConlounA R
-AAlaU Jhe duo olpus C DusbuulOn
name ndAluo n t Rutu ohtton
- ClicR on ohtionu n diolcq b o
tontoun
yneAancl cliuk tte
C D
A
mp b WameDepautmont &alau
At2 Fou Ccounu 4D000
5320 Cou Sels 30000
22000
6 E05 Madhwa ubot
S14 &als 60000
