Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 70 - Math_Genius_1 2
P. 70

    +
                      f'kÝV dh dk mi;ksx djosQ fdlh Js.kh dk p;u djus osQ fy, fuEu LVsIl dk ikyu djsa %
                      LVsi 1  ml igys lsy ij fDyd djsa ftlls vki jsat 'kq: djuk pkgrs gSaA
                                          +
                      LVsi 2  dhcksMZ ls f'kÝV (Shift) dh dks nckdj j•sa vkSj ml vafre lsy ij fDyd djsa ftldk vki p;u djuk
                             pkgrs gSaA
                                +
                      LVsi 3  f'kÝV (Shift) dh dks NksM+ nsaA jsat lysDV gks tkrh gSA

                      lsy jsat dk uke Mkyuk (Naming a Cell Range)
                      ,e,l ,Dlsy gesa lsy jsat dks ,d uke vlkbu djus dh vuqefr
                      nsrk gSA bl uke dk mi;ksx iQkWewZyk”k (Formulas) esa lsy osQ

                      ,Mªsl osQ LFkku ij fd;k tk ldrk gSA fdlh lsy jsat dks uke
                      fufnZ"V djus osQ fy, fuEu LVsIl dk ikyu djsa %
                      LVsi 1  mu lsYl dh jsat dk p;u djsa ftUgsa vki ,d uke
                             fufnZ"V djuk pkgrs gSaA
                      LVsi 2  fjcu  (Ribbon) ls iQkWewZyk”k  (Formulas) VSc ij
                             fDyd djsaA
                      LVsi 3  fMiQkbu use (Define Name) lewg osQ rgr fMiQkbu
                             usEl (Define Names) dekaM ij fDyd djsaA                  lsy jsat lysDVsM (Cell range selected)

                                     U;w use (New Name) Mk;ykWx ckWDl çdV
                             gksrk gSA
                      LVsi 4  uke Vkbi djsa vkSj vksosQ (OK) cVu ij fDyd djsaA vlkbu fd;k x;k uke use (Name) ckWDl esa fn•kbZ
                             nsrk gSA

                             U;w use Mk;ykWx ckWDl (New Name dialog box)   usfeax lsy jsat (Naming cell range)
                      vc] ge bl uke dk mi;ksx iQkWewZyk”k esa lsy osQ ,Mªsl osQ LFkku ij dj ldrs gSaA

                                             s
                          QkWewZys vkSj bld rjhdksa esa lsy jsQjsaflax (Cell Referencing in Formulas and its Types)
                      ,d lsy jsiQjsal (cell reference) ,d lsy ,Mªsl gS ftldk mi;ksx fdlh fof'k"V lsy dks n'kkZus osQ fy, iQkWewZys esa
                      fd;k tk ldrk gSA ,d iQkWewZys esa vU; lsy dk jsiQjsal gks ldrk gSA ,sls ekeys esa] iQkWewZys dk ifj.kke jsiQjsal fd,

                      gq, lsy osQ ekuksa (values) ij fuHkZj djrk gSA ;fn vki jsiQjsal fd, gq, lsyksa esa dksbZ ifjorZu djrs gSa] rks ifj.kke
                      Lor% ifjofrZr gks tk,xkA
                      ;g oSQls dke djrk gS ;g ns•us osQ fy, %
                         lsy A1 esa 10 ,aVj djsaA

                         vc lsy A2 lysDV djsaA
                         vkSj Vkbi djsa =A1*2 vkSj
                         ,aVj (ENTER) dh nck,¡A                                     lsy jsiQjsal dk iz;ksx (Using cell reference)

                         68  Play (Ver. 1.0)–VII

| 65 66 67 68 69 70 71 72 73 74 75 |