Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 72 - Math_Genius_1 2
P. 72

    ç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

| 67 68 69 70 71 72 73 74 75 76 77 |