Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 19 - Math_Genius_1 2
P. 19

    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

| 14 15 16 17 18 19 20 21 22 23 24 |