Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 77 - Math_Genius_1 2
P. 77

    vkb,] ,e,l ,Dlsy esa rk£dd dk;ks± dk mi;ksx djsaA
                     rk£dd dk;ks± dk mi;ksx djus osQ fy, fuEu LVsIl dk ikyu djsa %
                     LVsi 1  ,e,l ,Dlsy (MS Excel) ooZQ'khV esa fuEu MsVk Vkbi djsaA
                     LVsi 2  vf/dre vad lpZ djus osQ fy, lsy G3 esa =MAX(B3:F3) iaQD'ku Vkbi djsaA
                     LVsi 3  dhcksMZ ls ,aVj (Enter) dh nck,¡A

                                                MAX iaQD'ku dk mi;ksx djuk (Using MAX function)
                     tc vki ,aVj (Enter) dh nckrs gSa] rks lsy G3 esa vf/dre vad fn•kbZ nsrs gSaA vkWVksfiQy (Autofill) lqfo/k dk
                     mi;ksx djosQ çR;sd Nk=k osQ vf/dre vad Kkr djsaA blh rjg] ge MIN ( ) iaQD'ku dk mi;ksx djosQ U;wure vad
                     çkIr dj ldrs gSaA
                     LVsi 4  vadksa dk vkSlr Kkr djus osQ fy, lsy I3 esa =AVERAGE(B3:F3) iaQD'ku Vkbi djsaA
                     LVsi 5  dhcksMZ ls ,aVj (Enter) dh nck,¡A

                                              AVERAGE iaQD'ku dk mi;ksx (Using AVERAGE function)
                     tc vki ,aVj (Enter) dh nckrs gSa] rks lsy I3 esa vadksa dk vkSlr fn•kbZ nsrk gSA vkWVksfiQy (Autofill) lqfo/k dk
                     mi;ksx djosQ] ge çR;sd Nk=k osQ vkSlr vadksa dh x.kuk dj ldrs gSaA

                                                  vadksa dk vkSlr (Calculating average of marks)
                     MsV ,aM Vkbe iaQD'kal (Date and Time Functions)

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

                     TODAY()                ;g orZeku frfFk ykSVkrk gSA                   Input: =TODAY()
                                                                                          Output: 7/23/2019

                     MONTH(TODAY())         ;g pkyw ekg ykSVkrk gSA                       Input: =MONTH(TODAY())
                                                                                          Output: 7

                     YEAR(TODAY())          ;g pkyw o"kZ ykSVkrk gSA                      Input: =YEAR(TODAY())
                                                                                          Output: 2019

                     DAY(TODAY())           ;g orZeku fnu ykSVkrk gSA                     Input: =DAY(TODAY())
                                                                                          Output: 23
                                                                                          Input: = NOW()
                     NOW()                  ;g orZeku flLVe fnukad vkSj le; nsrk gSA
                                                                                          Output: 21-05-2020 11:24

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

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