Page 72 - Math_Genius_1 2

çfr'kr gSA ,sls esa lsy D3 esa fMLdkmaV çfr'kr fn;k x;k gSA blfy,] iQkWewZyk gksxk =((B3*C3)&((B3*C3)*($D$3))) A
tc vki iQkWewZyk dks vxys lsy esa dkWih djrs gSa] rks lsy D3 dk ,Mªsl ogh jgsxk tSlk fd fn•k;k x;k gS %

;wftax ,ClksY;wV jsiQjsaflax (Using absolute referencing)

feDLM jsiQjsalsl (Mixed References)
,d feDLM jsiQjsal og jsiQjsal gS tks ,d fof'k"V jks ;k dkWye dks lanfHkZr djrk gSA ;g ewy :i ls fjysfVo vkSj
,ClksY;wV jsiQjsal dk ,d la;kstu gSA oqQN fLFkfr;ksa esa vkidks lsy jsiQjsal dks feDlM jsiQjsal osQ :i esa cukus dh
vko';drk gks ldrh gS] rkfd vki fdlh dkWye ;k jks dks MkWyj ($) osQ çrhd ls igys ykWd dj losaQA mnkgj.k
osQ fy,] $A1 ;k A$1A

vU; ooZQ'khV osQ jsiQjsafll (References to Other Worksheets)
vki mlh ooZQcqd esa vU; ooZQ'khV osQ lsYl dks mruh gh vklkuh ls lanfHkZr dj ldrs gSa] ftruh vklkuh ls vki
mlh ooZQ'khV esa lsYl dks lanfHkZr djrs gSaA
mnkgj.k osQ fy,] 'khV2 (Sheet2) esa lsy A2 osQ jsiQjsal dks 'khV1 (Sheet1) esa lsy A1 esa ,aVj djus osQ fy,
;g djsa %

LVsi 1 'khV1 (Sheet1) esa lsy A1 dks lysDV djsa vkSj ,d cjkcj (=) fpg~u Vkbi djsaA
LVsi 2 'khV2 (Sheet2) VSc ij fDyd djsaA
LVsi 3 lsy A2 ij fDyd djsa vkSj fiQj ,aVj (Enter) dh nck,¡A tc vki ,aVj dh nckrs gSa] rks 'khV1 (Sheet1) vc
lfØ; gSA
LVsi 4 lsy A1 dks lysDV djsa vkSj vki ns•saxs fd blesa iQkWewZyk = Sheet2! A2-
foLe;kfncks/d fcanq (exclamation point) lsy Hkkx ls jsiQjsal osQ ooZQ'khV Hkkx dks vyx djrk gSA

vU; ooZQcqd jsiQjsalsl (Other Workbook References)
vki fdlh ooZQ'khV osQ lsy dks vU; ooZQcqDl esa mlh çdkj jsiQjsalsl dj ldrs gSa ftl çdkj vki mlh ooZQcqd esa vU;
ooZQ'khV~l osQ lsYl dks jsiQjsalsl djrs gSaA bu jsiQjsalsl dks ,DlVuZy jsiQjsalsl (external references) dgk tkrk gSA
mnkgj.k osQ fy,] cqd1 (Book1) esa cqd2 (Book2) dk jsiQjsal ,aVj djus osQ fy, bu LVsIl dk ikyu djsa %
LVsi 1 cqd1 (Book1) vkSj cqd2 (Book2) uke dh nks ooZQ'khV~l cuk,¡A

LVsi 2 cqd1 (Book1) osQ 'khV1 (Sheet1) esa lsy A1 dks lysDV djsa vkSj ,d cjkcj (¾) fpg~u Vkbi djsaA
LVsi 3 dhcksMZ ls Alt+Tab dh nckdj cqd2 (Book2) ij fLop djsaA lsy A2 dks lysDV djus osQ fy,
fDyd djsaA

70 Play (Ver. 1.0)–VII