Page 51 - Math_Genius_1 2
P. 51
LVsi 4 fØ,V (Create) ij fDyd djsaA ubZ ooZQcqd iQkby •qy tk,xh vkSj vki viuk MsVk tksM+uk 'kq: dj ldrs
gSaA
Z
od'khV esa MsVk Mkyuk (Entering Data in a Worksheet)
uacj ;k VsDLV osQ :i esa MsVk osQoy ,d lsy ij fDyd djosQ vkSj dhcksMZ dh enn ls Vkbi djosQ ntZ fd;k tk
ldrk gSA vki lh/s lsy esa MsVk Vkbi dj ldrs gSa ;k vki iQkWeZwyk ckj dk mi;ksx djosQ MsVk ntZ dj ldrs gSaA
ooZQ'khV esa MsVk ntZ djus osQ fy, bu LVsIl dk ikyu djsa %
LVsi 1 ml lsy ij fDyd djsa tgk¡ vki MsVk ntZ djuk pkgrs gSaA
ooZQ'khV esa MsVk Mkyuk (Entering data in a worksheet)
LVsi 2 MsVk ntZ djus vkSj ,d lsy dks uhps ys tkus osQ fy, ,aVj (Enter) dh nck,¡A
LVsi 3 LVsi 1 vkSj 2 dks rc rd nksgjk,¡ tc rd vki viuk lkjk MsVk ntZ djuk lekIr ugha dj ysrsA
ooZQ'khV (Worksheet)
s
,Dlsy esa MsVk d izdkj (Data Types in Excel)
,Dlsy esa rhu vyx&vyx çdkj osQ MsVk gksrs gSa ftUgsa vki LçsM'khV esa ntZ dj ldrs gSaA ;s gSa %
d- yscYl (Labels)% ,Dlsy esa ,d yscy ,d egRoiw.kZ ,aVªh (entry) gSA yscy dk mi;ksx LçsM'khV ij tkudkjh
dks ifjHkkf"kr djus osQ fy, fd;k tkrk gS] vFkkZr~ dkWye] VkbZVy (title) vkSj uke (names) dk 'kh"kZd
(heading)A ;g iQksu uacj] uacj] iQkWeZwys vkfn osQ vykok dksbZ Hkh VsDLV gSA ge yscy ij dksbZ xf.krh; x.kuk
ugha djrs gSaA yscy lsy osQ ckb± vksj iafDrc¼ (aligned) gksrs gSaA
[k- osY;w”k ;k uaclZ (Values or Numbers)% osY;w la[;kRed MsVk gksrs gSa ftu ij xf.krh; x.kuk dh tkrh gSA
bl çdkj osQ MsVk esa v{kj 0&9 vkSj fo'ks"k v{kj] tSls& -, +, [, /, ?, >, <, %. 'kkfey gSaA uacj vkSj v{kj ges'kk
lsy dh nk;ha vksj iafDrc¼ gksrs gSaA
x- iQkWewZyk (Formula)% iQkWewZyk ,d xf.krh; okD;ka'k (expression) gS] ftldk mi;ksx fdlh lsy (Cell) ;k cgqr
ls lsy esa lfEefyr la[;kRed MsVk dh ljy vkSj tfVy x.kuk djus osQ fy, fd;k tkrk gSA ,d lw=k ges'kk ,d
leku (¾) fpg~u ls 'kq: gksrk gS] mnkgj.k& = A2 + B2.
,e,l ,Dlsy 2010 dk ifjp; 49

