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

