Page 70 - Math_Genius_1 2

+
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