Page 76 - Math_Genius_1 2

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

LOWER(text) ;g VsDLV fLVªax dks yksvj osQl esa cny nsrk gSA Input: =LOWER(”Touch”)
Output: touch
vkb,] ge fuEufyf•r LVsIl dk ikyu djosQ VsDLV iaQD'kal dk mi;ksx djsa %

LVsi 1 ,e,l ,Dlsy ooZQ'khV esa fuEu MsVk Vkbi djsaA
LVsi 2 Vkbi djsa =CONCATENATE(A3,B3) lsy C3 esa igys uke vkSj vafre uke dks tksM+us osQ fy, iaQD'kuA
LVsi 3 dhcksMZ ls ,aVj (Enter) dh nck,¡A

CONCATENATE iaQD'ku dk mi;ksx (Using CONCATENATE function)
tc vki ,aVj (Enter) dh nckrs gSa] rks la;kstu osQ ckn igyk uke vkSj vafre uke fn•kbZ nsrk gSA

LVsi 4 igys uke dks vijosQl esa cnyus osQ fy, lsy D3 esa =UPPER(A3) iaQD'ku Vkbi djsaA iaQD'ku Vkbi djus
osQ ckn dhcksMZ ls ,aVj (Enter) dh nck,¡A

UPPER iaQD'ku dk mi;ksx (Using UPPER function)
igyk uke vijosQl esa fn•kbZ nsrk gSA
LVsi 5 igys uke dks yksvjosQl esa cnyus osQ fy, lsy E3 esa =LOWER(A3) iaQD'ku Vkbi djsaA iaQD'ku Vkbi

djus osQ ckn dhcksMZ ls ,aVj (Enter) dh nck,¡A

LOWER iaQD'ku dk mi;ksx (Using LOWER Function)
rk£dd iaQD'kal (Logical Functions)

iaQD'kal (Functions) mn~ns'; (Purpose) mnkgj.k (Example)
Input: =MAX(4,16,12,9)
MAX(range) ;g nh xbZ jsat esa lcls cM+k eku nsrk gSA
Output: 16

MIN(range) ;g nh xbZ jsat esa lcls NksVk eku nsrk gSA Input: =MIN(4,16,12,9)
Output: 4
Input: =AVERAGE(12,3,6)
AVERAGE(range) ;g fdlh jsat esa nh xbZ la[;kvksa dk vkSlr ykSVkrk gSA
Output: 7

74 Play (Ver. 1.0)–VII