Page 78 - Math_Genius_1 2

vkb,] ge vxzfyf•r LVsIl dk ikyu djosQ ,e,l ,Dlsy esa fnukad dk;ks± dk mi;ksx djsa %
LVsi 1 lsy esa =TODAY () Vkbi djsaA

LVsi 2 dhcksMZ ls ,aVj (Enter) dh nck,¡A

TODAY iaQD'ku dk mi;ksx (Using TODAY function)
tc vki ,aVj (Enter) dh nckrs gSa] rks lsy esa orZeku frfFk fn•kbZ nsrh gSA
LVsi 3 lsy esa =MONTH(TODAY()) iaQD'ku Vkbi djsa vkSj dhcksMZ ls ,aVj (Enter) dh nck,¡A

MONTH iaQD'ku dk mi;ksx (Using MONTH function)
orZeku frfFk dk eghuk fn•kbZ nsxkA ge fnukad okys lsy dk jsiQjsal MONTH() iaQD'ku dks Hkh ns ldrs gSaA blh
rjg] ge Øe'k% o"kZ vkSj fnu çkIr djus osQ fy, YEAR() vkSj DAY() iaQD'ku dk mi;ksx dj ldrs gSaA

oaQI;wVj

Kku SUM, AVERAGE, MAX, MIN, tSls lkekU; dk;ks± dk
mi;ksx Autosum dekaM osQ Mkmu ,jks dk mi;ksx djosQ Hkh
fd;k tk ldrk gSA

vU; dk;ks± dk mi;ksx djus osQ fy, eksj iaQD'kal (More
Functions) fodYi ij fDyd djsaA

,Dlsy esa pkVZ (Charts in Excel)
,d pkVZ MsVk dks lfp=k :i esa izn£'kr djus dk ,d çHkkoh rjhdk gSA ;g rqyuk djuk vklku cukrk gS vkSj Vscy esa
ewY;ksa osQ chp xzksFk (growth), fjys'kuf'ki (Relationship) vkSj VªsaM~l (trends) dk fo'ys"k.k djrk gSA

pkVZ osQ dkWEiksusaV~l (Components of a Chart)
pkVZ VkbVy (Chart Title)% pkVZ 'kh"kZd pkVZ osQ eq[; mn~ns'; vkSj dkWUVsUV dk o.kZu djrk gSA
X&,fDll (X-axis)% X&,fDll pkVZ dk gkWfjtkWUVy ,fDll (horizontal axis) gSA bls oSQVsxjh ,fDll Hkh
dgk tkrk gSA

Y&,fDll (Y-axis)% Y&,fDll pkVZ dk o£Vdy ,fDll (vertical axis) gSA bls osY;w ,fDll Hkh dgrs gSaA

IykWV ,fj;k (Plot Area)% ;g nks v{kksa ls f?kjk vk;rkdkj {ks=k gSA blesa okLrfod pkVZ gksrk gS vkSj blesa IykWV
fd, x, MsVk] IykWfVM ,fj;k] MsVk lhjht] oSQVsxjh vkSj osY;w ,fDll 'kkfey gksrs gSaA

76 Play (Ver. 1.0)–VII