Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 76 - Math_Genius_1 2
P. 76

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

                       LOWER(text)              ;g VsDLV fLVªax dks yksvj osQl esa cny nsrk gSA  Input: =LOWER(”Touch”)
                                                                                     Output: touch
                      vkb,] ge fuEufyf•r LVsIl dk ikyu djosQ VsDLV iaQD'kal dk mi;ksx djsa %

                      LVsi 1  ,e,l ,Dlsy ooZQ'khV esa fuEu MsVk Vkbi djsaA
                      LVsi 2  Vkbi djsa =CONCATENATE(A3,B3) lsy C3 esa igys uke vkSj vafre uke dks tksM+us osQ fy, iaQD'kuA
                      LVsi 3  dhcksMZ ls ,aVj (Enter) dh nck,¡A

                                         CONCATENATE iaQD'ku dk mi;ksx (Using CONCATENATE function)
                      tc vki ,aVj (Enter) dh nckrs gSa] rks la;kstu osQ ckn igyk uke vkSj vafre uke fn•kbZ nsrk gSA

                      LVsi 4  igys uke dks vijosQl esa cnyus osQ fy, lsy D3 esa =UPPER(A3) iaQD'ku Vkbi djsaA iaQD'ku Vkbi djus
                             osQ ckn dhcksMZ ls ,aVj (Enter) dh nck,¡A

                                                  UPPER iaQD'ku dk mi;ksx (Using UPPER function)
                      igyk uke vijosQl esa fn•kbZ nsrk gSA
                      LVsi 5  igys uke dks yksvjosQl esa cnyus osQ fy, lsy E3 esa =LOWER(A3) iaQD'ku Vkbi djsaA iaQD'ku Vkbi

                             djus osQ ckn dhcksMZ ls ,aVj (Enter) dh nck,¡A

                                                  LOWER iaQD'ku dk mi;ksx (Using LOWER Function)
                      rk£dd iaQD'kal (Logical Functions)

                       iaQD'kal (Functions)                 mn~ns'; (Purpose)                      mnkgj.k (Example)
                                                                                               Input: =MAX(4,16,12,9)
                       MAX(range)           ;g nh xbZ jsat esa lcls cM+k eku nsrk gSA
                                                                                               Output: 16

                       MIN(range)           ;g nh xbZ jsat esa lcls NksVk eku nsrk gSA         Input: =MIN(4,16,12,9)
                                                                                               Output: 4
                                                                                               Input: =AVERAGE(12,3,6)
                       AVERAGE(range)       ;g fdlh jsat esa nh xbZ la[;kvksa dk vkSlr ykSVkrk gSA
                                                                                               Output: 7

                         74  Play (Ver. 1.0)–VII

| 71 72 73 74 75 76 77 78 79 80 81 |