Page 73 - Math_Genius_1 2

LVsi 4 ,aVj (Enter) dh nck,¡A vkiosQ n~okjk ,aVj dh nckus osQ ckn cqd1 (Book1)] Cell A1 esa vkidk iQkWeZwyk
gksuk pkfg, = [Book2] Sheet1! $A$2-

bl jsiQjsal esa 3 Hkkx gSa %
1- ooZQcqd cqd2 (Book2) oxkZdkj dks"Bdksa esa
2- ooZQ'khV 'khV1 (Sheet1) osQ ckn ! laosQr
3- ,ClksY;wV jsiQjsal (absolute reference) okyk lsy

blfy,] ,DlVuZy ooZQcqd esa lsYl dks jsiQjsal djus osQ fy, ooZQcqd] fiQj ooZQ'khV vkSj fiQj ml lsy dks lysDV
fd;k tkrk gS ftlls vki jsiQjsal dks fyad djuk pkgrs gSaA

QaD'kal (Functions)
,Dlsy esa ljy vkSj tfVy nksuksa x.kukvksa dks djus osQ fy, iwoZfu/kZfjr iQkWewZys gSaA os vkxqZesaV~l (arguments) Lohdkj
djrs gSa vkSj ewY; (values) okil djrs gSaA vkxqZesaV (Argument) dk;ks± osQ fy, buiqV gSaA ;s vkxqZesaV~l la[;k ;k
VsDLV gks ldrs gSaA dks"Bd ( ) 'kq: djus vkSj can djus osQ chp eku (value) nh tkrh gSA

iaQD'ku iz;ksx djus osQ fu;e (Rules for using Functions)
lHkh ,Dlsy iaQD'ku ¾ fpg~u (sign) n~okjk 'kq: fd, tkrs gSaA
iaQD'ku dk uke ,d ekU; ,Dlsy uke gksuk pkfg,A

dks"Bd 'kq: vkSj can djus osQ ckn iaQD'ku dk ikyu fd;k tkuk pkfg,A
vf/dka'k dk;ks± esa blosQ Hkhrj ,d vkxqZesaV (argument) gksuk pkfg,A

iaQD'ku dh Jsf.k;k¡ (Categories of Functions)
,e,l ,Dlsy fuEufyf•r çdkj osQ dk;Z çnku djrk gS%
lkaf[;dh; dk;Z (Statistical Functions)% la[;kRed MsVk osQ ,d lsV osQ vf/dre] U;wure] vkSlr vkfn
dh x.kuk djrk gSA

fnukad vkSj le; dk;Z (Date and Time Functions)% fdlh fo'ks"k le; esa fnu] eghus vkSj o"kZ dh rkjh•
vkSj ?kaVs] feuV vkSj lsoaQM esa x.kuk djrk gSA

xf.krh; dk;Z (Mathematical Functions)% fdlh la[;k osQ oxZewy ;k ,ClksY;wV eku] la[;kvksa osQ xq.ku
vkfn dh x.kuk djrk gSA

rk£dd dk;Z (Logical Functions)% X > 5 tSlh fLFkfr;ksa dk ewY;kadu djrk gS vkSj ifj.kke dks lgh ;k xyr
crkrk gSA
VsDLV iaQD'kal (Text Functions)% fLaVªXl ij dbZ vkWijs'ku djrk gS (vFkkZr ^gSyks*] ^ÚsaM*] ^oaQI;wVj* vkfn
tSls v{kjksa dk laxzg) tSls fd ,d fLVªax dh yackbZ dk ,Mªsl yxkuk] nks fLVªaXl dks tksM+uk] ,d fLVªax dks vanj

lpZ djuk vU; vkfnA
vkb,] buesa ls oqQN Jsf.k;ksa ij foLrkj ls ppkZ djsaA

xf.krh; iaQD'kal (Mathematical Functions)

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

SUM(range) ;g ,d Js.kh dk ;ksx nsrk gSA Input: =SUM(4,8,12,16)
Output: 40

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