Page 74 - Play v1.0 gujarati class 7
P. 74

Vtõþ™                               nuŒw                              WËknhý
                                               ‚tÏÞk™u rð¼ksf îkhk rð¼kSŒ fÞko …Ae Œu   Input: =MOD(8,5)
                   MOD(number, divisor)
                                               ƒkfe™k …hŒ fhu Au.                      Output: 3

                                                                                       Input: =SQRT(81)
                   SQRT(number)                Œu ‚tÏÞk™u …qýkOf …hŒ fhu Au
                                                                                       Output: 9
                                                                                       Input: =INT(14.25)
                   INT(number)                 Œu ‚tÏÞk™u …qýkOf {qÕÞ{kt Vuhðu Au.
                                                                                       Output: 14

                                               Œu ‚{k™ þÂõŒ{kt W¼k fhu÷k ™tƒh™wt       Input: =POWER(5,3)
                   POWER(number, power)
                                               …rhýk{ yk…u Au                          Output: 125

                                               Œu …‚tË fhu÷ ©uýe{kt {qÕÞku™e ‚tÏÞk …hŒ fhu   Input: =COUNT(4,8,12)
                   COUNT(range)
                                               Au.                                     Output: 3

                   ROUND(number,               Œu r™ŠËü ytfku …h „ku¤kfkh fÞko …Ae yuf   Input: =ROUND(35.666,2)
                   number_of_digits)           ™tƒh yk…u Au.                           Output: 35.67

                                                                                       Input: =ABS(-25)
                   ABS(number)                 Œu yk…u÷ ‚tÏÞk™wt ‚t…qýo {qÕÞ yk…u Au   Output: 25





                   íkfLkefe


                        ¿kkLk
                                   rðÄuÞ{kt yk…ýu ®f{Œku™k MÚkk™u ‚u÷-yuzÙu‚™ku W…Þku„ …ý fhe þfeyu Aeyu.




                  [k÷ku yk…ýu MS EXCEL{kt „krýrŒf Vtõþ™™ku W…Þku„ fheyu.
                  „krýrŒf Vtõþ™ ™ku W…Þku„ fhðk {kxu ™e[u yk…u÷ …„÷wt ¼hku.
                  …„÷wt 1   MS Excel ðfoþex{kt ™e[u™ku zuxk ÷¾ku.
                  …„÷wt 2   …uÂL‚÷ku™e ®f{Œ™e „ýŒhe fhðk {kxu, ‚u÷ D3 {kt =PRODUCT(B3:C3) Vtõþ™ ÷¾ku.
                  …„÷wt 3   yuLxh fe ˃kðku.

















                                               «kuzõx VtõþLkLkku WÃkÞkuøk (Using PRODUCT function)

                  …uÂL‚÷ku™e ®f{Œ ‚u÷ D3 {kt Ëu¾kÞ Au. AUTOFILL FEATURE ™ku W…Þku„ fhe™u, yk…ýu ¼qr{rŒ ƒkuõ‚ y™u …u™™e



                     72  Play (Ver.  1.0)–VII
   69   70   71   72   73   74   75   76   77   78   79