Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 67 - Math_Genius_1 2
P. 67

    ,e,l ,Dlsy esa iQkWewZyk]

                          7            iaQD'kUl vkSj pkVZ

                                       (Formulas, Functions and

                                       Charts in MS Excel)

                              vkidk y{;

                                fuEu osQ fo"k; esa tkuuk %
                                   x.kuk djus osQ fy, iQkWewZyk yxkuk              dk;Z osQ vkns'k
                                   iQkWewZyk yxkus osQ fofHkUu rjhosQ              lsy jsat dks le>uk

                                   iQkWewZys vkSj mlosQ rjhdksa ls lsy jsiQjsafLakx     iaQD'kUl
                                   ,Dlsy esa pkVZ

                     tSlk fd ge fiNyh d{kk esa i<+ pqosQ gSa fd x.kuk djus osQ fy, iQkWewZyksa dk mi;ksx fd;k tkrk gSA bl vè;k; esa]
                     ge iQkWewZyk vkSj ooZQ'khV esa iQkWeZwyk tksM+us osQ fofHkUu rjhdksa osQ ckjs esa vkSj tkusaxsA ge ,Dlsy esa fofHkUu çdkj osQ

                     fcYV&bu iaQD'ku] fofHkUu çdkj osQ pkVZ vkSj MsVk dh N¡VkbZ (sorting) osQ ckjs esa Hkh tkusaxsA

                                         s
                         x.kuk djus d fy, QkWewZyk yxkuk (Using Formulas to Perform Calculation)
                     ,e,l ,Dlsy esa iQkWewZyk ,d cjkcj (¾) osQ fpg~u ls 'kq: gksrs gSaA tc fdlh lsy dk dkWUVsUV cjkcj (¾) osQ fpg~u
                     ls 'kq: gksrk gS] rks ,e,l ,Dlsy le>rk gS fd mi;ksxdrkZ us ;gk¡ ,d iQkWewZyk fn;k gSA ;fn vki leku fpg~u ntZ

                     ugha djrs gSa] rks ,Dlsy vkidh çfof"V dks VsDLV osQ :i esa ekusxk vkSj x.kuk foiQy gks tk,xhA
                     ;g fn•kus osQ fy, fd iQkWeZwys oSQls dk;Z djrs gSa] ge CySad lsy A1 dk p;u djosQ ,d ljy vH;kl ls çkjaHk djsaxsA
                     mlosQ ckn] ¾ 5 $ 5 Vkbi djosQ ,aVj dh nck,¡A vkiosQ ,aVj dh nckrs gh] ,Dlsy x.kuk djosQ lsy A1 esa 10
                     ifj.kke fn[kk nsrk gSA
                     vU; lsy esa oqQN vkSj iQkWewZys ntZ djsa vkSj ns•sa fd ,Dlsy }kjk dkSu ls ifj.kke fn•k, tkrs gSaA
                         1.  =8 – 5               2.  =8 * 5                 3.  =8/5                 4.  =8 ^ 5
                       ifj.kke Øe'k% 3] 40] 1-6 vkSj 32768 gksaxsA

                     csMekl (BEDMAS) fu;e ij vk/kfjr oqQN iQkWewZyk bl çdkj ntZ fd, tk ldrs gSa %

                         1.  =(8 + 5) – (2 + 3) ^ 2            2.  =(9/3) * (4 ^ 2) – 5
                       vkvks tkusa!

                       ,e,l ,Dlsy xf.krh; x.kuk djus osQ fy, (BEDMAS) fu;e dk ikyu djrk gS] tgk¡ B czSosQV dks n'kkZrk gS]
                       ?kkrkad (Expotentiation) osQ fy, E] Hkkx osQ fy, D] xq.kk osQ fy, M] tksM+ osQ fy, A vkSj ?kVko osQ fy, SA

                     vki fuEu rjhosQ ls x.kuk djus osQ fy, lsy ,Mªsls”k (cell addresses) dk Hkh mi;ksx dj ldrs gSa %

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

| 62 63 64 65 66 67 68 69 70 71 72 |