Page 20 - Math_Genius_1 2

MsVk dh Ük`a•yk esa iQkWesZ¯Vx ykxw djus osQ fy,] bu LVsIl dk ikyu djsa%
LVsi 1 ml MsVk dk p;u djsa ftl ij iQkWesZ¯Vx ykxw fd;k tkuk gSA

LVsi 2 MªkWi&Mkmu lwph •ksyus osQ fy, gkse VSc osQ varxZr LVkbYl lewg ls oaQfM'kuy iQkWesZ¯Vx (Conditional
Formatting) vkns'k ij fDyd djsaA ;g lwph fofHkUu ekunaM (Criteria) fn•krh gS tSls%
• gkbykbV lsy fu;e (Highlight Cells Rules) & ;g fodYi rc pquk tkrk gS tc vki fdlh nh xbZ
'krZ dks iwjk djus okys lHkh lsy dks gkbykbV djuk pkgrs gSaA tc vki bl fodYi ij ekml ?kqekrs gSa] rks
;g ,d mi&lwph •ksyrk gS tks ØkbVsfj;k fn•krk gS tSls xzsVj Fkku] ySl nSu] bDoy Vw] fcVohu] vkfnA
• VkWi@ckWVe #Yl (Top/Bottom Rules)& ;g fodYi rc pquk tkrk gS] tc vki fdlh MsVk Ük`a•yk
esa oqQN 'kh"kZ ;k fupys vkbVe dks gkbykbV djuk pkgrs gSaA tc vki bl fodYi ij ekml ?kqekrs
gSa] rks ;g ,d mi&lwph •ksyrk gS ftlesa 'kh"kZ 10 vkbVe] 'kh"kZ 10»] uhps 10 vkbVe] uhps 10»]
vkfn tSls ØkbVsfj;k fn•kbZ nsrs gSaA
• MsVk cklZ (Data Bars)& ;g fodYi rc pquk tkrk gS tc vki la[;kRed MsVk okys lsy esa MsVk
ckj tksM+uk pkgrs gSaA tc vki bl fodYi ij ekml ?kqekrs gSa] rks ;g ,d mi&lwph •ksyrk gS ftlesa
fofHkUu çdkj vkSj jaxksa osQ ckj fn•k, tkrs gSa ftUgsa lsyksa esa tksM+k tk ldrk gSA
• dyj LosQy (Colour Scales)& ;g fodYi rc pquk tkrk gS] tc vki lHkh p;fur lsyksa esa jax
;kstukvksa dks tksM+uk pkgrs gSa tks /hjs&/hjs Åij ls uhps dh oLrqvksa esa fHkUu gksrs gSaA tc vki bl
fodYi ij ekml ?kqekrs gSa] rks ;g ,d mi&lwph •ksyrk gS ftlesa fofHkUu jax fHkUurk,¡ fn•kbZ nsrh
gSa] ftUgsa lsyksa esa tksM+k tk ldrk gSA
• vkbdu lsV (Icon Sets)& ;g fodYi rc pquk tkrk gS] tc vki ;g fn•kus osQ fy, vkbdu lsV
tksM+uk pkgrs gSa fd dkSu ls lsy Lohdk;Z gSa] dkSu ls eè;e gSa vkSj ftu ij è;ku nsus dh vko';drk
gSA tksM+s tk ldus okys fofHkUu çdkj osQ vkbdu lsV mi&lwph esa fn•k, tkrs gSa] tks bl fodYi
ij ekml dks ?kqekus ij •qyrs gSaA

oaQMh'kuy iQkWesZ¯Vx dk mi;ksx djuk (Using Conditional Formatting)
p;fur oaQMh'kuy iQkWesZ¯Vx p;fur lsy Js.kh ij ykxw gksrk gSA vki oaQfM'kuy
iQkWesZ¯Vx MªkWi&Mkmu lwph ls u;k fu;e fodYi pqudj d{kksa dks gkbykbV

djus osQ fy, viuk Lo;a dk fu;e Hkh ifjHkkf"kr dj ldrs gSaA
MsVk Js.kh ij ykxw oaQMh'kuy iQkWesZ¯Vx lqfo/kvksa dks oaQMh'kuy iQkWesZ¯Vx MªkWi&Mkmu
lwph ls fDy;j :y fodYi dk p;u djosQ fDy;j fd;k tk ldrk gSA

l'krZ Lo:i.k ykxw
oZd'khV fçaV djuk (Printing a Worksheet) oaQI;wVj (Conditional Formatting applied)
ooZQ'khV fçaV djus osQ fy,] bu LVsIl dk ikyu djsa%
LVsi 1 ml MsVk dh Js.kh dk p;u djsa] ftls vki fçaV djuk

pkgrs gSa vkSj fiQj fDod ,Dlsl Vwyckj MªkWi&Mkmu fçaV Mk;ykWx ckWDl •ksyus
lwph ls fçaV izhO;w vkSj fçaV vkbdu ij fDyd djsaA Kku osQ fy, Ctrl $ P dht
;k
nck,¡A

18 Play (Ver. 1.0)-VIII