Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 73 - Math_Genius_1 2
P. 73

    LVsi 4  ,aVj (Enter) dh nck,¡A vkiosQ n~okjk ,aVj dh nckus osQ ckn cqd1 (Book1)] Cell A1 esa vkidk iQkWeZwyk
                            gksuk pkfg, = [Book2] Sheet1! $A$2-

                     bl jsiQjsal esa 3 Hkkx gSa %
                         1-  ooZQcqd cqd2 (Book2) oxkZdkj dks"Bdksa esa
                         2-  ooZQ'khV 'khV1 (Sheet1) osQ ckn ! laosQr
                         3-  ,ClksY;wV jsiQjsal (absolute reference) okyk lsy

                     blfy,] ,DlVuZy ooZQcqd esa lsYl dks jsiQjsal djus osQ fy, ooZQcqd] fiQj ooZQ'khV vkSj fiQj ml lsy dks lysDV
                     fd;k tkrk gS ftlls vki jsiQjsal dks fyad djuk pkgrs gSaA

                         QaD'kal (Functions)
                     ,Dlsy esa ljy vkSj tfVy nksuksa x.kukvksa dks djus osQ fy, iwoZfu/kZfjr iQkWewZys gSaA os vkxqZesaV~l (arguments) Lohdkj
                     djrs gSa vkSj ewY; (values) okil djrs gSaA vkxqZesaV (Argument) dk;ks± osQ fy, buiqV gSaA ;s vkxqZesaV~l la[;k ;k
                     VsDLV gks ldrs gSaA dks"Bd ( ) 'kq: djus vkSj can djus osQ chp eku (value) nh tkrh gSA

                     iaQD'ku iz;ksx djus osQ fu;e (Rules for using Functions)
                        lHkh ,Dlsy iaQD'ku ¾ fpg~u (sign) n~okjk 'kq: fd, tkrs gSaA
                        iaQD'ku dk uke ,d ekU; ,Dlsy uke gksuk pkfg,A

                        dks"Bd 'kq: vkSj can djus osQ ckn iaQD'ku dk ikyu fd;k tkuk pkfg,A
                        vf/dka'k dk;ks± esa blosQ Hkhrj ,d vkxqZesaV (argument) gksuk pkfg,A

                     iaQD'ku dh Jsf.k;k¡ (Categories of Functions)
                     ,e,l ,Dlsy fuEufyf•r çdkj osQ dk;Z çnku djrk gS%
                         lkaf[;dh; dk;Z (Statistical Functions)% la[;kRed MsVk osQ ,d lsV osQ vf/dre] U;wure] vkSlr vkfn
                         dh x.kuk djrk gSA

                         fnukad vkSj le; dk;Z (Date and Time Functions)% fdlh fo'ks"k le; esa fnu] eghus vkSj o"kZ dh rkjh•
                         vkSj ?kaVs] feuV vkSj lsoaQM esa x.kuk djrk gSA

                         xf.krh; dk;Z (Mathematical Functions)% fdlh la[;k osQ oxZewy ;k ,ClksY;wV eku] la[;kvksa osQ xq.ku
                         vkfn dh x.kuk djrk gSA

                         rk£dd dk;Z (Logical Functions)% X > 5 tSlh fLFkfr;ksa dk ewY;kadu djrk gS vkSj ifj.kke dks lgh ;k xyr
                         crkrk gSA
                         VsDLV iaQD'kal (Text Functions)% fLaVªXl ij dbZ vkWijs'ku djrk gS (vFkkZr ^gSyks*] ^ÚsaM*] ^oaQI;wVj* vkfn
                         tSls v{kjksa dk laxzg) tSls fd ,d fLVªax dh yackbZ dk ,Mªsl yxkuk] nks fLVªaXl dks tksM+uk] ,d fLVªax dks vanj

                         lpZ djuk vU; vkfnA
                     vkb,] buesa ls oqQN Jsf.k;ksa ij foLrkj ls ppkZ djsaA

                     xf.krh; iaQD'kal (Mathematical Functions)

                         iaQD'kal (Functions)               mn~ns'; (Purpose)                   mnkgj.k (Example)

                      SUM(range)                  ;g ,d Js.kh dk ;ksx nsrk gSA            Input: =SUM(4,8,12,16)
                                                                                          Output: 40

                                                                              ,e,l ,Dlsy esa iQkWewZyk] iaQD'kUl vkSj pkVZ  71

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