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
   46   47   48   49   50   51   52   53   54   55   56