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

÷kursf÷ fkÞkuo™ku W…Þku„ fhðk {kxu ™e[u™k …„÷ktyku ¼hku :
                 …„÷wt 1   MS Excel ðfoþex{kt ™e[u™ku zuxk ÷¾ku.
                 …„÷wt 2   {n¥k{ „wý þkuÄðk {kxu fku»k G3 {kt = MAX (B3: F3) fkÞo fhku.

                 …„÷wt 3   feƒkuzo{ktÚke yuLxh fe ˃kðku.








                                                 MAX VtõþLkLkku WÃkÞkuøk (Using MAX function)
                 ßÞkhu Œ{u yuLxh fe ˃kðku Aku, íÞkhu ‚u÷ G3 {kt {n¥k{ „wý Ëu¾kÞ Au. ykuxkurV÷ ‚wrðÄk™ku W…Þku„ fhe™u Ëhuf rðãkÚkeo™k

                 {n¥k{ „wý þkuÄku. yu s heŒu, y{u MIN () Vtõþ™™ku W…Þku„ fhe™u LÞq™Œ{ „wý þkuÄe þfeyu Aeyu.
                 …„÷wt 4   „wý™e ‚huhkþ þkuÄðk {kxu ‚u÷  13 {kt = AVERAGE (B3: F3) fkÞo fhku.
                 …„÷wt 5   feƒkuzo{ktÚke yuLxh fe ˃kðku.








                                            AVERAGE VtõþLkLkku WÃkÞkuøk (Using AVERAGE function)

                 ßÞkhu Œ{u yuLxh fe ˃kðku Aku, íÞkhu ‚u÷ 13 {kt „wý™e ‚huhkþ Ëu¾kÞ Au. ykuxkurV÷ ‚wrðÄk™ku W…Þku„ fhe™u, yk…ýu
                 Ëhuf rðãkÚkeo™k „wý™e ‚huhkþ™e „ýŒhe fhe þfeyu Aeyu.









                                            økwýLke MkhuhkþLke økýíkhe (Calculating average of marks)

                 Œkhe¾ y™u ‚{Þ Vtõþ™ (Date and Time Functions)


                          Vtõþ™                              nuŒw                                 WËknhý
                                                                                      Input: =TODAY()
                 TODAY()                Œu ðŒo{k™ õ÷ux …hŒ fhu Au.                    Output: 7/23/2019

                                                                                      Input: =MONTH(TODAY())
                 MONTH(TODAY())         Œu [k÷w {rn™u …hŒ fhu Au.                     Output: 7


                                                                                      Input: =YEAR(TODAY())
                 YEAR(TODAY())          Œu [k÷w ð»ko …hŒ fhu Au                       Output: 2019

                                                                                      Input: =DAY(TODAY())
                 DAY(TODAY())           Œu ðŒo{k™ rËð‚ …hŒ fhu Au                     Output: 23


                                                                                      Input: = NOW()
                 NOW()                  Œu ðŒo{k™ r‚Mx{™e Œkhe¾ y™u ‚{Þ yk…u Au.      Output: 21-05-2020 11:24





                                                           yu{yuMk yuõMku÷{kt Mk{efhýku, rðÄuÞku yLku yk÷u¾     75
   72   73   74   75   76   77   78   79   80   81   82