Page 77 - Math_Genius_1 2

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