Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 75 - Math_Genius_1 2
P. 75

    tc vki ,aVj (Enter) dh nckrs gSa] rks lsy D3 esa isafly dh dher fn•kbZ nsrh gSA vkWVksfiQy (Autofill) lqfo/k dk
                     mi;ksx djosQ] ge T;ksesVªh ckWDl (Geometry Boxes) ckWDl vkSj isu (Pens) dh dherksa dh x.kuk dj ldrs gSaA

                     LVsi 4  lcVksVy dh x.kuk djus osQ fy, lsy D6 esa =SUM(D3:D5) Vkbi djsaA
                     LVsi 5  dhcksMZ ls ,aVj (Enter) dh nck,¡A

                                                 ,l;w,e iaQD'ku dk mi;ksx (Using SUM function)
                     tc vki ,aVj (Enter) dh nckrs gSa] rks lc VksVy lsy D6 esa çdV gksrk gSA
                     LVsi 6  =(D6*7)*100 iQkWewZyk dk mi;ksx djosQ VSDl (Tax) dh x.kuk djsaA

                     LVsi 7  =SUM(D6:D7) iaQD'ku dk mi;ksx djosQ VksVy (Total) dh x.kuk djsaA vafre ifj.kke bl izdkj gS %

                                                       VksVy fn[kk;k x;k (Displaying Total)
                     VsDLV iaQD'kal (Text Functions)

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

                      CONCATENATE(text1,  ;g nks ;k nks ls vf/d fofHkUu VsDLV       Input: =CONCATENATE(“Touch”,

                      text2)                   fLVªax dks ,d lkFk tksM+rk gSA       “pad”)
                                                                                    Output: Touchpad
                                               ;g VsDLV fLVªax dh ckb± vksj ls v{kjksa   Input: =LEFT(“Touch”,3)
                      LEFT(text, num_chars)
                                               dh fufnZ"V la[;k nsrk gSA            Output: Tou

                      RIGHT(text, num_         ;g VsDLV fLVªax dh nkb± vksj ls v{kjksa   Input: =RIGHT(“Touch”,3)
                      chars)                   dh fufnZ"V la[;k nsrk gSA            Output: uch

                                                                                    Input: =LEN(“Touch”)
                      LEN(text)                ;g VsDLV fLVªax dh yackbZ ykSVkrk gSA
                                                                                    Output: 5

                                               ;g VsDLV fLVªax dks vij osQl esa duoVZ  Input: =UPPER(“Touch”)
                      UPPER(text)
                                               djrk gSA                             Output: TOUCH

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

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