Page 67 - Math_Genius_1 2

,e,l ,Dlsy esa iQkWewZyk]

7 iaQD'kUl vkSj pkVZ

(Formulas, Functions and

Charts in MS Excel)

vkidk y{;

fuEu osQ fo"k; esa tkuuk %
x.kuk djus osQ fy, iQkWewZyk yxkuk dk;Z osQ vkns'k
iQkWewZyk yxkus osQ fofHkUu rjhosQ lsy jsat dks le>uk

iQkWewZys vkSj mlosQ rjhdksa ls lsy jsiQjsafLakx iaQD'kUl
,Dlsy esa pkVZ

tSlk fd ge fiNyh d{kk esa i<+ pqosQ gSa fd x.kuk djus osQ fy, iQkWewZyksa dk mi;ksx fd;k tkrk gSA bl vè;k; esa]
ge iQkWewZyk vkSj ooZQ'khV esa iQkWeZwyk tksM+us osQ fofHkUu rjhdksa osQ ckjs esa vkSj tkusaxsA ge ,Dlsy esa fofHkUu çdkj osQ

fcYV&bu iaQD'ku] fofHkUu çdkj osQ pkVZ vkSj MsVk dh N¡VkbZ (sorting) osQ ckjs esa Hkh tkusaxsA

s
x.kuk djus d fy, QkWewZyk yxkuk (Using Formulas to Perform Calculation)
,e,l ,Dlsy esa iQkWewZyk ,d cjkcj (¾) osQ fpg~u ls 'kq: gksrs gSaA tc fdlh lsy dk dkWUVsUV cjkcj (¾) osQ fpg~u
ls 'kq: gksrk gS] rks ,e,l ,Dlsy le>rk gS fd mi;ksxdrkZ us ;gk¡ ,d iQkWewZyk fn;k gSA ;fn vki leku fpg~u ntZ

ugha djrs gSa] rks ,Dlsy vkidh çfof"V dks VsDLV osQ :i esa ekusxk vkSj x.kuk foiQy gks tk,xhA
;g fn•kus osQ fy, fd iQkWeZwys oSQls dk;Z djrs gSa] ge CySad lsy A1 dk p;u djosQ ,d ljy vH;kl ls çkjaHk djsaxsA
mlosQ ckn] ¾ 5 $ 5 Vkbi djosQ ,aVj dh nck,¡A vkiosQ ,aVj dh nckrs gh] ,Dlsy x.kuk djosQ lsy A1 esa 10
ifj.kke fn[kk nsrk gSA
vU; lsy esa oqQN vkSj iQkWewZys ntZ djsa vkSj ns•sa fd ,Dlsy }kjk dkSu ls ifj.kke fn•k, tkrs gSaA
1. =8 – 5 2. =8 * 5 3. =8/5 4. =8 ^ 5
ifj.kke Øe'k% 3] 40] 1-6 vkSj 32768 gksaxsA

csMekl (BEDMAS) fu;e ij vk/kfjr oqQN iQkWewZyk bl çdkj ntZ fd, tk ldrs gSa %

1. =(8 + 5) – (2 + 3) ^ 2 2. =(9/3) * (4 ^ 2) – 5
vkvks tkusa!

,e,l ,Dlsy xf.krh; x.kuk djus osQ fy, (BEDMAS) fu;e dk ikyu djrk gS] tgk¡ B czSosQV dks n'kkZrk gS]
?kkrkad (Expotentiation) osQ fy, E] Hkkx osQ fy, D] xq.kk osQ fy, M] tksM+ osQ fy, A vkSj ?kVko osQ fy, SA

vki fuEu rjhosQ ls x.kuk djus osQ fy, lsy ,Mªsls”k (cell addresses) dk Hkh mi;ksx dj ldrs gSa %

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