Page 19 - Math_Genius_1 2

LVsi 2 ,d MªkWi Mkmu lwph •ksyus osQ fy, gkse VSc osQ varxZr laiknu lewg ls lkWVZ vkSj fiQYVj dekaM ij
fDyd djsaA
LVsi 3 MªkWi&Mkmu lwph ls fiQYVj ij fDyd djsaA vki ns•saxs fd lHkh dkWye gsMj osQ lkeus NksVs rhj fn•kbZ ns

jgs gSaA
LVsi 4 MªkWi&Mkmu lwph •ksyus osQ fy, gsMj izkIr fd, x, ekDlZ osQ lkeus okys rhj ij fDyd djsaA vki ns•saxs
fd dkWye esa lHkh çfof"V;k¡ lwph esa 'kq#vkr esa NksVs psd ckWDl osQ lkFk ekStwn gSaA oqQN psd ckWDlksa dks
vupsd djus osQ fy, mu ij fDyd djsa vkSj vksosQ cVu ij fDyd djsaA

fiQYVj fd;k x;k MsVk (Filtered data)
vki ns•saxs fd vupsDM MsVk dh jks”k dks lwph ls gVk fn;k x;k gSA vkidks fpark djus

dh t:jr ugha gS D;ksafd MsVk [kksrk ugha gSA jkst 'kh"kZdksa ij è;ku nsaA oqQN jks 'kh"kZd
xk;c gSaA vupsDM jks”k dks vHkh çn'kZu ls fNik;k x;k gSA
MsVk okil ikus osQ fy,] fiQYVj lwph dks fiQj ls •ksysa vkSj vopsDM çfof"V;ksa dh fiQYVj fodYiksa dk mi;ksx djuk
tk¡p djsaA (Using Filter options)

eku yhft,] vki mu Nk=kksa osQ uke tkuuk pkgrs gSa ftUgksaus 80 ls vf/d vad çkIr fd, gSaA bl laca/ esa vko';d
tkudkjh çkIr djus osQ fy, bu LVsIl dk ikyu djsa%

LVsi 1 MsVk ij fiQYVj ykxw djsaA

LVsi 2 fiQYVj MªkWi&Mkmu lwph •ksyus osQ fy, çkIr ekDlZ dkWye gsMj ij fDyd djsaA

LVsi 3 mi&esuw •ksyus osQ fy, viuk ekml uacj fiQYVj fodYi ij j•saA dLVe vkWVksfiQYVj Mk;ykWx ckWDl
•ksyus osQ fy, xzsVj nSu fodYi dk p;u djsaA
LVsi 4 ØkbVsfj;k (criteria) ckWDl esa 80 ntZ djsa vkSj vksosQ cVu ij fDyd djsaA

è;ku nsa fd osQoy 80 ls vf/d vad çkIr djus okys Nk=kksa dk fooj.k izn£'kr fd;k tkrk gS vkSj 'ks"k jks”k dks
fNik fn;k tkrk gSA

fiQYVj gVk,¡ (Remove Filters) vkvks tkusa!
,d ckj yxkus osQ ckn fiQYVj dks vklkuh ls gVk;k tk ldrk gSA

ooZQ'khV esa dgha Hkh fDyd djsa vkSj fiQYVj ykxw djus osQ fy, fiQYVj dekaM dk p;u djosQ MsVk VSc osQ varxZr
LVsiksa dks nksgjk,¡A vki ns•saxs fd dkWye gsMj osQ lkeus fiQYVj rhj lkWVZ vkSj fiQYVj lewg osQ ekè;e ls Hkh fiQYVj
xk;c gks x, gSa vkSj fNih gqbZ jks”k Hkh fiQj ls fn•kbZ gksus yxh gSaA ykxw fd;k tk ldrk gSA

dafM'kuy QkWesZfVax (Conditional Formatting)
eku yhft, fd vki fdlh Hkh jks dks fNikuk ugha pkgrs gSa] ysfdu fiQj Hkh mu lHkh lsy dks gkbykbV djuk pkgrs
gSa tks ,d 'krZ dks iwjk djrs gSa] mnkgj.k osQ fy, 80 ls vf/dA bl çdkj osQ iQksWesZ¯Vx dks ,Dlsy esa oaQfM'kuy
iQkWesZ¯Vx osQ :i esa tkuk tkrk gSA

,Dlsy dh mUur fo'ks"krk,¡ 17