Computer 4
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Computer 4 as PDF for free.
More details
- Words: 6,793
- Pages: 26
•••••••••••••• ••••••••••••••••••• •••••••
`mKw 4
Fw.F-kv. FIvk þ AXn-hn-]p-e-amb IW-¡p-]p-kvXIw l k¦oÀ®KWnX§Ä sRmSnbnSbn \S¯mw l l hÀ¡v_p¡v, hÀ¡vjoäv, skÃpIÄ l l IWs¡gp¯n\v Ffp¸hgnIÄ l l hÀ¡v_p¡n\v tamSntbImw l http://www.geocities.com/bluemangoaz http://bluemango.50webs.com/
]pXnb t{]m{KmamWv ]Tn¡m³ t]mIp¶Xv F¶Xnsâ {XnÃnembncp¶p cXojpw kp \nXbpw. AXn\m Xs¶ km[mcW ImÀ¯nI hcp¶Xn\v ap¼mbpÅ Iw]yq «À the¯c§Äs¡m¶pw AhÀ apXnÀ¶ncp¶nÃ. ImÀ¯nI hcpt¼mÄ Iw]yq «dpw {] nâdpsams¡ "HmWm'¡n, kvIqÄ hntijhpw ]dªncn¡pIbmbncp¶p Ccphcpw. "F´m, C¶v IgpXbpw hnUvVnbpw CSnbpw sXmgnbpsam¶panÃmsX \à Ip«n Ifmbncn¡p¶Xv?' IS¶]mtS ImÀ¯nI tNmZn¨p. "Hm, H¶panÃ,' kp\nX ]dªp. "R§Ä Asænepw \à Iq«pImctÃ?' "Ipd¨p kwkmcw, IqSpX A²zm\w', cXojv CSbv¡v Ibdn. "C¶v ]pXnb t {]m{KmatÃ?' "h¶ph¶v ]nÅmcnt¸mÄ Iev]n¡m\pw XpS§n,' ImÀ¯nI ]cn`hw t]mse ] dªp. "cmhnse apX sshIpt¶cw hsc Hm^okn t{]m{Kmw FgpXÂ, kÔy Ignªm ho«n t{]m{Kmw ]Tn¸n¡Â. Fsâsbmcp hn[ntb! B KÄ^pImc³ sI«nbh \msW¦n `mcysb¡pdn¨v hnNmchpanÃ.' "\ncmibmtIWvS, tN¨o. Fs¶¡mWp¶Xv Ahs \¡mWp¶Xn\v XpeyatÃ?' cXojv Nncn¨p. "FSm DWvS¡®m, acaWvSm, \o apd¯ot¡dns¡m¯pt¶mSm?' ImÀ¯nI Ahs\
FIvk FIvkÂkv
1 http://www.geocities.com/bluemangoaz http://bluemangoa2z.50webs.com/ (1 of 26)3/20/2009 10:24:45 PM
•••••••••••••• ••••••••••••••••••• •••••••
http://bluemango.50webs.com/
ASn¡m³ sN¶p. AhfpsS ssIbn Ibdn¸nSn¨v kp\nX ]dªp: "tN¨o, Ahs\ hnSv... ] mhw CUnbäv. \ap¡v ]pXnb t{]m{Kmw ]Tn¡mw.' "icn, Hcp§ns¡mÅpI', ImÀ¯nI Iw] yq«dn\v ap¼n h¶ncp¶p. "PmeI¸ cn]mSnbpw Fgp¯pw Aev]kzev]w Nn{X¸ WnIfpsams¡ \½Ä ]Tn¨pIgnªp. C\n \ap¡v Aev]w IW¡p Iq«epw IWs¡gp¯pw A¡uWvSv amt\Pvsaâpw ]Tn¡mw.' "At½m! Zm IW¡v hoWvSpw', Icbp¶Xp t]mse cXojv ]dªp. "kvIqfn Xs¶ B \ocmfn shdpsX hnSp ¶nÃ. Ct¸mÄ ChnsSbpw.' " ` b ¡ m s X S m tamt\. FIvk F¶ IWs¡gp¯pImcsâ coXnIÄ GXp aWvS\pw http://www.geocities.com/bluemangoaz http://bluemango.50webs.com/
Ffp¸w ]nSnIn«p¶XmWv. icn¡pw User-friendly. Asæn ]¯mw¢mÊn X«nap «n IW¡v IS¶ F\n¡v FIvkens\ CjvSs¸Sm³ ]äptam?' "Excel, Office-2000 ]mt¡Pnse Hcp t{]m{KmamsW¶tà tN¨n ]dªXv?' kp\nX tNmZn¨p. "AsX. \ap¡v XpS§mw. XpSt§WvSnS¯v XpS§mhp¶XmWv.' Start sa\phnÂ, Programs- Microsoft Excel FSp¯v Excel Bcw`n¡mw. Hm^okv tjmÀ«vI«v _mdn \n¶pw Excel Xpd¡mw. Excel Xpd¶v hÀ¡v Bcw`n¨pIgnbpt¼mÄ Windows- HmSp¶ GXv \à t{]m{Kmapw t]mse D]tbmKn¡m³ Ffp¸amWnsX¶v a\ÊnemIpw. File->Save tkhv sN¿pw; Edit->Copy ]IÀs¸Sp¡pw; Edit>Paste t]Ìv sN¿pw. A§s\ FÃmw Ffp¸w. Excel ASbv¡m³ File- Exit skeIvSv sN¿pI. Excel hn³tUmbn ssSän _mdnse Close _«¬ ¢nIv sNbvXpw Exit sN¿mw. hÀ¡v _p¡v, hÀ¡vjoäv, sk "Word- \½Ä tUmIypsaâ v, t]Pv Fs¶ms¡bmWv ]dªncp¶Xv,' ImÀ¯nI XpSÀ¶p. "Excel- hm¡pIÄ¡v Aev]w amäapWvSv.' Excel- tUmIypsaânsâ t]cv Workbook F¶mWv. A¡uWvSânsâ tai¸pds ¯ IW¡p]pkvXI§fntÃ? AXpt]mse¯s¶, ] e t]PpIÄ DÅXmImw Hcp hÀ¡v _p¡v. Workbook F¶ IW¡p]pkvXI¯nse Hmtcm t]Pnt\bpw Worksheet F¶mWv ]dbpI. hÀ¡vjoänemWv \mw ]WnsbSp¡pI. Excel hn³tUmbnse ]e L«§fpw aäv t{]m{KmapIfntet¸mse¯s¶bmWv. sa\p_mdn\v Xmsg, Excel tPmen¡mhiyamb _«WpIÄ DÅ cWvSv SqÄ_mdpIÄ ImWmw. Excel-sâ {][m \`mKw, hÀ¡vjoänse hÀ¡v Gcnb tImf§fpw hcnIfpw \nd ªXmWv. tImf§fneqsSbpw hcnIfneqsSbpw \o§m³ cWvSv kvt{ImÄ _mdpIfp WvSv. Excel Workbook-Â, ASnØm\]cambn tPmenIÄ sN¿p¶Xv Worksheet- BsW¶v ] dªtÃm! tImf§fpw hcnIfpw \ndª CXv \m«nse IW¡¸nÅamcpsS A¡uWvSv ] pkvXI¯nse XmfpIÄ t]me¯s¶bmWv. Name box Menu bar Title bar Formula bar Active Cell Cell row Cell column Work sheet
http://www.geocities.com/bluemangoaz http://bluemangoa2z.50webs.com/ (2 of 26)3/20/2009 10:24:45 PM
•••••••••••••• ••••••••••••••••••• •••••••
http://bluemango.50webs.com/
Hcp Excel hÀ¡v_p¡n aq¶v hÀ¡vjoäpIÄ BWv DWvSmIpI. IqSpX hÀ¡vjoäpIÄ Bhiysa¦n tNÀ¡mw. Xpd¶phcp¶ Hmtcm tUmIypsaân\pw, Document 1, Document 2 F¶n§s\ Word t]cv sImSp¯ncp¶Xpt]mse, Default Hcp hÀ¡v _p¡nse hÀ¡vjoäpIÄ¡v Sheet 1, Sheet 2 F¶mWv t]cv. Hmtcm hÀ¡v joänsâbpw t]cv joän\v Xmgs¯ Sm_pIfn ImWmw. Xpd¶ncn¡p¶ joänsâ t]cv sXfnªncn¡pw. Dt±in¡p¶ joäv Xpd¡m³, B joänsâ Sm_n ¢nIv sN¿pI. Sm_pIfpsS CSXp`mK¯v ImWp¶ kvt{ImÄ _mÀ D]tbmKn¨v Sm_pIfneqsS thK¯n \o§mw. Hcp hÀ¡vjoän\v {]kàamsbmcp t]cv \ÂImw. B Sm_n UºnÄ ¢nIv sNbvXv t]cv sImSp¡pI. "hÀ¡v joän \ndsb hcnIfpw tImf§fpamWtÃm!' ImÀ¯nI ]dªp. "Cu hcnIÄ¡v F®w C«n«pWvSv. Hcp hÀ¡v joän BsI F{X hcnIfpsWvS¶ dnbmtam? A´w hnScpXv þ 65,536. km[mcWbmbn CXn 26þ27 F®ta hn³tUmbn  ImWm³ Ignbq. tamWnädnsâ sdkeyqj³ amdp¶X\pkcn¨v CXn amäw hcpw. tImf§Ä¡v A, B, C, D F¶n§s\ A£c§Ä \ÂInbn«pWvSv. F{X tImf§ fmWv Hcp hÀ¡v joänset¶m? 256. Cw¥ojv A£camebn 26 A£c§ftà DÅq. Z F¶ tImfw Ignªm ASp¯hbv¡v AA, AB, AC F¶n§s\bmWv t]cp IÄ.' tImf§fpw hcnIfpw tNÀ¶v joänse hÀ¡v Gcnbbn \nd ª n c n ¡ p ¶ I Å n I Ä ¡ v skÃpIÄ (cells) F¶v ]dbp¶p. A £ c § f p w A ¡ § f p w t^mÀapeIfpw FÃmsagpXp¶Xv Cu skÃpIfnemWv. tImf ¯nsâ t]cpw hcn http://www.geocities.com/bluemangoaz http://bluemango.50webs.com/
bpsS t]cpw tImþHmÀUnt\äpIfmbn FSp¯mWv skÃns\ hnh£n¡pI. B20 F¶m B tImfhpw 20þmw hcnbpw tNÀ¶pWvSmIp¶ skÂ. CXv BZys¯ hÀ¡v joänsâ Imcy¯nÂ. hÀ¡v _p¡nse asämcp hÀ¡v joänse Hcp skÃnsâ A{UÊv Sheet 3! B22 F¶msW¦nÂ, B sk aq¶mas¯ joän B tImfhpw 22þmw hcnbpw tNÀ¶pWvSmIp¶XmWv F¶À°w. asämcp hÀ¡v _p¡nse Hcp sk A{UÊn\v ap¼n B hÀ¡v _p¡nsâ t]cpWvSmIpw. (Test.xls) Sheet 3 C25 F¶ A{UÊnsâbÀ°w Test.xls F¶ hÀ¡v _p¡nse aq¶mw joän C tImfhpw 25þmw hcnbpw tNÀ¶pWvSmIp¶ sk F¶mWv. "CsXms¡ ]pdwImgvNbpsS Imcy§fmWv,' ImÀ¯nI XpSÀ¶p. "Cu skÃp IÄ¡pw hÀ¡vjoäpIÄ¡pw hÀ¡v _p¡pIÄ¡psams¡ ]pdIn Excel-sâ A]mc iànbpÅ IW¡p¡q«Â b{´apWvSv. tai¸pd¯ncn¡p¶ ImÂIpteäÀ FSp ¡m³ \ap¡v thWvSkab¯nepw F{Xtbm Npcp§nb t\cw sImWvSv \½psS Bbnc ¡W¡mb IW¡pIsf Excel Nn«s¸Sp¯pw.' Excel PmeI¯nse ]cyS\w
http://bluemangoa2z.50webs.com/ (3 of 26)3/20/2009 10:24:45 PM
•••••••••••••• ••••••••••••••••••• •••••••
sa\p IamâpIfpw Iot_mÀUv Ipdp¡phgnIfpw, tjmÀ«vI«v sa\pIfpw, t^mÀape _mdpw Ìmäkv _mdpw D]tbmK¨v Excel-ambn \mw Bibhn\nabw \S ¯p¶p. IamâpIÄ {][m \ambpw cWvSv hgnIfneqsSbmWv þ sa\p_mdpw tjmÀ«v I«v sa\phpw. Nne IamâpIÄ¡v Iot_mÀUv tjmÀ«vI«pIfpWvSv. DZm: tkhv sN¿m³, Ctrl+S, tIm¸n sN¿m³ Ctrl+C. tjmÀ«vI«pIÄ sa\phnse IamâpIÄs¡m¸w tcJs ¸Sp¯nbncn¡pw. Hcp skÃntem, NmÀ«ntem, SqÄ_mdntem atäm ssdäv ¢nIv sN¿pt ¼mÄ tjmÀ«vI«v sa\p e`n¡p¶p. http://www.geocities.com/bluemangoaz http://bluemango.50webs.com/
t^mÀape _mÀ hÀ¡vjoänse hÀ¡v Gcnbbv¡v sXm«papIfn SqÄ_mdn\v sXm«v XmsgbmWv t^mÀape _mÀ. Excel-se cWvSv {][m\ [À½§Ä CXv \nÀÆln¡p¶p. 1. IgvkÀ Ccn¡p¶ skÃn Umä tNÀ¡m³ ChnsS ssS¸v sNbvXm aXn. Umä ChnsS Xncp¯m\pw Ignbpw. 2. A¸t¸mÄ tPmen sN¿p¶ skÃn F´msW¶Xv t^mÀape _mdn sXfnbpw. hÀ¡v joäntem, {]nâu«ntem t\m¡n Hcp skÃnse aqey¯n\v ]pdInse t^mÀape Xocpam\n¡m³ IgnbnÃ. AXn\m Excel- tPmen sN¿pt¼mÄ CXv t^mÀape _mdn hyàambncn¡pw. t^mÀape _mdnsâ CSXphi¯mWv Name Box. CXn ]e t]cpIfpw sk A{UÊpIfpw sXfnªphcpw. 1. Igvkdncn¡p¶ skÃnsâ A{UÊv; 2. Hcp \nc skÃpIÄ¡v aosX Drag sN¿pt¼mÄ, hcnIfptSbpw tImf§fptSbpw F®w; 3. skeIvSv sNbvX t{UmbnwKnsâtbm NmÀ«ns âtbm t]cv F¶nhsbms¡ t^mÀape _mdnse Name Box- sXfnªp \n¡pw. skÃpIÄ D]tbmKn¡m³ Excel-se Hcp sk skeIvSv sN¿pt¼mÄ AXv Active BIp¶p. AXn\v Npäpw I«nbpÅ Hcp t_mÀUÀ hcp¶p. skeIvSv sNbvX skÃnsâ hcn\¼dpw tImfwseädpw sXfnªp \n¡pw. skÃn Fs ´¦nepw F³{Sn DsWvS¦n AXv t^mÀape _mdn sXfnbpw. Active Bb skÃnte Umä FgpXm\mIq. Hcp skÃns\ ]e hn[¯n skeIvSv sN¿mw. * skÃn aukv ¢nIv sN¿pI. * Iot_mÀUnse Arrow IoIÄ D]tbmKn¨v skÃn \n¶pw skÃnte¡v \o§pI. * Edit sa\phn Go To FSp¡pI. (F5 Iobpw Ctrl+G-bpw CXn\mbn D]tbmKn¡mw). Go To UbtemKv t_mIvkv e`n¡pw. GXv skÃnte¡mtWm t]mtIWvSXv B skÃnsâ A{UÊv (DZm: P 1000) Reference- ssS¸v sN¿pI. hÀ¡vjoän ZriyaÃm¯ Hcp skÃnte¡v t] mIm³ Cu coXn klmbIcamWv. * H¶ntesd skÃpIÄ (Hcp \nc þ Range) skeIvSv sN¿m³ AhbneqsS aukv {UmKv sN¿pI. Shift AaÀ¯n, Arrow Io D]tbmKn¡pIbpw sN¿mw. * Hcp Range-sâ hnemkw ImWn¡p¶Xv AXnsâ CSXvþapIfnsebpw heXvþIogv`mKt¯bpw skÃpIÄ sh¨mWv (DZm: A1:K10). Hcp Range-sâ ske Ivj³ Hgnhm¡m³, asämcp skÃn ¢nIv sNbvXm am{Xw aXn. Go to special http://www.geocities.com/bluemangoaz http://bluemango.50webs.com/
http://bluemangoa2z.50webs.com/ (4 of 26)3/20/2009 10:24:45 PM
•••••••••••••• ••••••••••••••••••• •••••••
Umäbpw t^mÀapebpw FgpXm³ "AÛpXs¸Smdmbnà Ip«nItf', \mSIob kzc¯n ImÀ¯nI ]dªp. "{Xnà Sn¸n¡p¶ Excel AÛpX§Ä hcm\ncn¡p ¶tXbpÅp. Ct¸mÄ, skÃn Umäbpw t^mÀapebpw FgpXp¶Xv F§s\sb¶p ]dªp Xcmw. "Hcp tImf¯n 65,536 skÃp Ifpw Hcp hcnbn 256 skÃpIfpw DsWvS¶v Rm³ t\cs¯ ] dªtÃm! AXv sh¨v, {XnÃSn¸n¡p¶ Hcp kq{Xw Rm³ Aev]kab ¯n\pÅn ImWn¨pXcmw.' Hcp skÃn F{X IymcIvSdpIÄ Enter sN¿msat¶m? 32000-¯ntesd. Hcp t^mÀapebn F{X IymcIvSdpIÄ hscbm Imsat¶m? 1024 hsc. Hcp skÃn Umä sbgpXn Enter AaÀ¯n¡gnªm UmäbXn Dd¨p Ignªp. Enter AaÀ¯p¶ Xn\p ap¼v, Umä ambv¨p Ifbm³ Esc Io AaÀ¯pI. Hcp tPmen sNbvXv Ignªv, AXv Dt]£n¡m³ Edit- Undo skeIvSv sN¿pI. SqÄ_mdnse Undo _«Wpw D]tbmKn¡mw. Undo-hnse drop-down enÌv D] tbmKn¨v Ahkm\ambn sNbvX 16 {]hÀ¯nIÄ hsc Undo sN¿mw. Undo sNbvX Hcp {]hr¯n hoWvSpw C^IvSohm¡m³ Edit->Repeat FSp¡pI. Umäbpw t^mÀapebpw FgpXp¶ kab¯v skÃnsâ kuµcys¯¡pdn¨v thhem Xns¸tSWvS. t^mÀamänwKv ]ns¶ sN¿mw. "Ct¸mÄ ]cn]mSn ]Tn¨tÃm!', ImÀ¯nI ]dªp. "C\n Excel-sâ ImÂIptej³ ]hÀ {] mtbmKnIambn ]cntim[n¡mw. cXotj, A1 sk skeIvSv sNbvXv AXn 65536 F¶v Enter sN¿v. Enter AaÀ¯n IgvkÀ Xmgs¯ skÃn F¯n¡pI. C\n A2-hn 256. CXv Excel hÀ¡vjoänse hcnIfp tSbpw tImf§fptSbpw F®amWv. Enter Hcn¡Â IqSn AaÀ¯pI. "C\n A3 skÃn =A1*A2 F¶ t^mÀape ssS¸v sN¿pI. Equal (=) ASbmfw CSm³ ad¡cpXv. \£{X NnÓw (*) KpW\{Inbbv¡pÅ {]XoIamWv. Enter AaÀ¯ntb¡v. A3 skÃn Ct¸mÄ F´mWv ImWp¶Xv? 16777216 AtÃ? AXmbXv Hcp hÀ¡v joän 167 e£ ¯ntesd skÃpIÄ DsWvS¶v' "ât½m!' AÛpXkzcw hnZymÀ°nIÄ Ccphcn \n¶pw GIIme¯mWpWvSmbXv. C\n Excel-sâ hÀ¡v ]hÀ A1, A2 http://www.geocities.com/bluemangoaz http://bluemango.50webs.com/
t\m¡m\pÅ asämcp ]co£Ww \S¯mw. sk FUnäv sN¿p¶ hnZybmWnXv. A3 skÃnse t^mÀape amän Hcp hÀ¡v _p¡n F{X sk DsWvS¶v IWvSp]n Sn¡mw. * A3 skÃnÂ, AXnse Umä FUnäv sN¿m\mbn, UºnÄ ¢nIv sN¿pI. * t^mÀapebpsS Ahkm \¯n Insertion Point hcp¯m³ End Io AaÀ¯pI. F¶n«v *3 ssS¸v sN¿pI. * Enter AaÀ¯pI. * A3 skÃnse dnkÄ«v t\m¡pIþ50331648. "Hcp hÀ¡v_p¡nse skÃpIfpsS F®sa{X?' ImÀ¯nI tNmZn¨p. "hfsc Ipdhv, AtÃ? A©v tImSnbne[nIw!' Excel-sâ tijnbpsS cpNnbdnbm³ asämcp ]co£Ww FSp¡mw. A1, A2 skÃp Ifnse kwJyIÄ amän t\m¡pI. A3 skÃnse KpW\^ew amdnbXv {i²n¡m³ t]mepw \ap¡v t\cw In«nÃ. A{X s]s«¶mbncn ¡pw amäw.' Hcp t^mÀapebpambn _Ôs¸Sp¶ Umä a m d p ¶ X \ p k c n ¨ v t^mÀape ]p\ÀKWn ¡m³ Excel-\v Ignbp¶p. CsXmcnS¯Ã, Hcp hÀ¡v_p¡nse Hmtcm t^mÀapebnepw Cu doþIm¡ptej³ \S ¡p¶p. UmäIfpw t^mÀapeIfpw AS §p¶ Bbnc¡W¡n\v skÃpIfn C§s\ IW¡p Iq«Â \S¡p¶ http://bluemangoa2z.50webs.com/ (5 of 26)3/20/2009 10:24:45 PM
•••••••••••••• ••••••••••••••••••• •••••••
Imcyw BtemNn¡pI (skÃnse Unkvt¹, AXnse Umäsb _m[n ¡msX, amäm³ Ignbpw). * A1, A3 skÃpIÄ skeIvSv sN¿pI. A1 cell- \n¶v aukv sImWvSv A3 hsc {UmKv sN¿pI. * skeIvSv sNbvX skÃpIfn FhnsSsb¦nepw ssdäv ¢nIv sN¿pI. tjmÀ«v I«v sa\yphn \n¶v Format Cells FSp¡pI. Format Cells UbtemKv t_mIvkv Xpd¡p¶p. * Number F¶ Sm_v ¢nIv sN¿pI. CXn ske£\pIÄ \S¯pt¼mÄ sample t_mIvkn\I¯v \¼À sXfnbp¶Xv {i²n¡pI. * Category enÌn Number skeIvSv sN¿pI. Undo http://www.geocities.com/bluemangoaz http://bluemango.50webs.com/
* Use 1000 Separator F¶ check box ¢nIv sN¿pI. Decimal place- "]qPyw' CSpI. * OK ¢nIv sN¿pI. * A1, A2, A3 skÃpIfn 1000þ\v taepÅ kwJyIfpsS Unkvt¹ t\m¡pI. 1000þ§sf thÀXncn¡p¶ tIma ImWmw. DZm: 65,536. ]t£, Cu amäw bYmÀ°\¼ dns\ _m[n¡nÃ. Unkvt¹bn am{XamWo amäw. hyàambdnbm³ Hcp skÃn ¢nIv sNbvXv t^mÀape _mdn t\m¡pI. AhnsS sXfnbp¶ kwJybn tIma DWvSmhnÃ. kwJyIÄsImWvSpÅ Cu Ifn¡n Sbn Nne skÃpIfn Nnet¸mÄ # # # F¶ ASbmfta ImWq', ImÀ¯nI ]dªp. "]t£, `bs¸tSWvS. kwJyb{Xbpw ImWn¡m³ skÃn\v hoXnbnÃm¯ XpsImWvSmImanXv. Format amän, skÃnsâ hoXnIq«ntbm sNdnb t^mWvSp]tbmKnt¨m Cu {]iv\w ] cnlcn¡mw.' Hmt«m ImÂIpteäv skeIvSv sNbvXncn¡p¶ skÃpIfnse kwJyIfpsS XpI Unkvt¹ sN¿m\mbn Hcp henb kuIcyw Excel-\pWvSv. CXmWv Auto Calculate. B4 apX B9 hscbpÅ skÃpIÄ skeIvSv sNbvXncn¡pt¼mÄ (B4:B9) B Bdv skÃpIfnse kwJyIfpsS XpI (Sum =) Status bar- {]Xy£s¸Spw. sNt¿WvS tPmenbpsS t^mÀape FgpXmsX¯s¶ XpI ImWm\pÅ Gähpw \à Ffp¸ hgn CXmWv. (Auto Calculate C\nbpw kuIcy§fpWvSv. Auto Calculator Cânt¡ädn ¢nIv sNbvXm In«p¶ tjmÀ«vI«v sa\p D]tbmKn¨v, IW¡pIq«ensâ coXn amämhp¶XmWv.) Excel-se bm{XIÄ Excel hÀ¡vjoäv Hcp ]mcmhmcamsW ¶v a\ÊnembntÃ? ImÀ¯nI ]dªp. AXnsâ Hcp sNdnb `mKw am{XamWv \mw ImWp¶Xv. hÀ¡vjoänsâ asämcp `mKt¯¡v \o§m³ AhnsS Hcp sk skeIvSv sN¿pItb thWvSp. AXn\v autkm Iot_mÀtUm D]tbm Kn¡mw. Asæn AXn\mbn Iamâpap WvSv. Format Cells http://www.geocities.com/bluemangoaz http://bluemango.50webs.com/
skÃneqsS \o§m³ * Hcp Arrow Io AaÀ¯pI * kvt{ImÄ _mdnsâ cWvSä¯pÅ ArrowIfn GsX¦nepsam c®w ¢nIv sNbvXv AXv NqWvSp¶ `mKt ¯¡v Scroll sN¿mw. * Hcp sk skeIvSv s N ¿ p I . Iot_mÀUnse Scroll Lock
http://bluemangoa2z.50webs.com/ (6 of 26)3/20/2009 10:24:45 PM
•••••••••••••• ••••••••••••••••••• •••••••
AaÀ¯pI. ske Ivj³ amdmsX ¯s¶ hÀ¡v joänepsS \o§m³ kvt{ImÄ Arrow IoIÄ D]tbmKn¡mw. * aukn\v kvt{ImÄ ho DsWvS¦n AXp]tbmKn¨v hn³tUmbn kvt{ImÄ sN¿mw. kv{Io\neqsS \o§m³ * Hmtcm kv{Io³ apIfntebvt¡m Xmtgbvt¡m \o§m³ Page Up, Page Down IoIÄ. * Scroll Box _«Wv ]pd¯v kvt{ImÄ _mdn ¢nIv sN¿pI. * Scroll Box {UmKv sN¿pI. Scroll box {UmKv sN¿pt¼mÄ \n§Ä F¯ns¸Sp¶ tImfhpw hcnIfpw sXfnbp¶ Hcp Scroll Tip ImWmw. hÀ¡vjoäpIÄ amäm³ hn³tUmbpsS Iogv`mKs¯ Sm_pIfn ¢nIv sNbvXv BhiyapÅ hÀ¡v joäv FSp¡mw. Ctrl+Page Up, Ctrl+Page Down IoIfpw C¡mcy¯n\mbn D]tbmKn¡mw. IpXn¨pNm«§Ä ]et¸mgpw kv{Io\n ZriyaÃm¯ Hcp skÃntet¡m Range-tebvt¡m \ap¡v NmtSWvSn hcpw. CXn\v Go To UbtemKv t_mIvkv FSp¡mw. (Edit-Go To). UbtemKv t_mIvknse Go To enÌn \n¶v t]mtIWvS Range skeIvSv sN¿pItbm, Reference box- A{UÊv ssS¸v sN¿pItbm sN¿mw. Formula Box-se Name Box D]tbmKn¨pw C¯cw Nm«w \S¯mw. Name box- Hcp hnemktam Range Name-Hm ssS¸v sNbvXv Enter AaÀ¯nbm aXn. CXn\mbn t_mIvknsâ drop-down enÌpw D]tbmKn¡mw. http://www.geocities.com/bluemangoaz http://bluemango.50webs.com/
* Home Io AaÀ¯nbmÂ, tPmen sN¿p¶ hcnbpsS XpS¡¯n F¯mw. * Ctrl+Home D] tbmKn¨v \nehnepÅ hÀ¡v joänsâ A1 skÃnse¯mw. * Ctrl+End AaÀ¯pI. sXm«pap¼v tPmen sNbvX tImf¯nsebpw hcnbnsebpw skÃnse¯mw. End AaÀ¯nb tijw Home AaÀ¯nbmepw CXp Xs¶ ^ew. * End AaÀ¯n Enter sN¿pI. tPmen sNbvXpsImWvSncn¡p¶ hcnbn Ahkm \ambn D]tbmKn¨ skÃnse¯mw. hÀ¡v_p¡v amäm³ "Word- Htc kab¯v ]e tUmIypsaân tPmen sN¿p¶Xpt]mse, Excel Htc kab¯v ]e Workbook-Ifn tPmen sN¿mw', ImÀ¯nI ]dªp. "hn³tUm IÄ amdp¶ ]Wnt]mse Xs¶bmWv hÀ¡v_p¡pIÄ amdp¶Xpw.' * ASp¯ hÀ¡v_p¡v kv{Io \n ImWm\psWvS¦n AXn ¢nIv sN¿pI. * Window sa\phn \n¶v BhiyapÅ hÀ¡v_p¡v skeIvSv sN¿pI. * Ctrl+F6 AaÀ¯p¶Xv ASp¯ hn³tUmbnte¡v t]mIm³ klmbn¡p¶p. "Excel-eqsS bm{X sN¿m\pÅ amÀ¤§Ä CsXms¡bmWv. C\n \ap¡v SqÄ_mdp IÄ D]tbmKn¡p¶Xv F§s\bmsW¶v t\m¡mw þ ]Xnhv Im¸n ¡ptijw.' ImÀ¯nI Im¸nsbSp¡m³ apdnhn«pt] mbn. SqÄ_mÀ D]tbmKn¡p¶Xv I m ¸ n b p a m b n ImÀ¯nI hcpt¼mÄ kp\nXbpw cXojpw Excel-
http://bluemangoa2z.50webs.com/ (7 of 26)3/20/2009 10:24:45 PM
•••••••••••••• ••••••••••••••••••• •••••••
sâ ImÂIptej³ ]hÀ ]cntim[n¨psIm WvSncn¡pIbmbncp¶p. "AXv ]n¶oSmImw. \msf sshIo«v Rm³ hcp¶Xn\p ap¼v CjvSw t]mse kabapWvStÃm! Ct¸mÄ \ap¡v SqÄ_mdp IÄ t\m¡mw,' ImÀ¯nI ]dªp. Excel 2000 shÀjt\msSm¸w h¶ Hcp ]pXnb Hm]vj \mWv Personal SqÄ_mÀ. HcmÄ IqSpXembn D]tbmKn¡p¶ SqÄ_mdpIfpsS ]«nIbmWnXnsâ ASn¯d. Standard SqÄ_mdnsebpw Formatting SqÄ_mdntebpw _«WpIÄ Cu SqÄ_mdn ImWpw. SqÄ_mdn FÃm _«WpIfpw H¶n¨v \nc¯m³ thWvS ØeanÃm¯XpsImWvSv, IqSp Xembn D]tbmKn¡p¶ SqfpIfmbncn¡pw Personal SqÄ_mdn ImWpI. AXn \m¯s¶ Personal Toolbar-se Unkvt¹ sFäwkv hÀ¡\pkcn¨v amdns¡mWvSncn¡pw. http://www. geocities.com/bluemangoaz http://bluemango.50webs.com/
BhiyapÅ _«¬ SqÄ_mdn ImWp¶nsæn More Buttons _«¬ ¢nIv sN¿pI. Standard, Formatting SqÄ_mdpIfn ImWp¶ Personal Toolbar D]tbmKw \nÀºÔanÃ. Standard, Formatting SqÄ_mdpIÄ cWvSv \ncIfnembn¯s¶ display sN¿mhp¶XmWv. Personal Toolbar- FhnsSsb¦nepw ssdäv ¢nIv sN¿pI. Customize UbtemKv t_mIvkv e`n¡p¶p. UbtemKv t_mIvknse Options Sm_v skeIvSv sNbvXv B t]sPSp¡pI. Standard and Formatting Toolbars Share One Row F¶Xnsâ skeIvj³ \o¡w sN¿pI. OK ¢n¡v sN¿pI Standard, Formatting SqÄ_mdpIÄ IqSmsX ]ns¶bpw SqÄ_mdpIÄ DWvSv FIvken Â. ChsbSp¡m³ View sa\phn Toolbars skeIvSv sN¿pI, slÂ]v e`n¡m³ aq¶v hn[¯nepÅ Help, Excel 2000 hmKvZm\w sN¿p¶p. Office Assistant: Word-tet¸mse Hcp "Indp¡³' IYm]m{Xw tNmZy§Ä¡v icnbp ¯cw Xcp¶p. Help Topics: Excel-s \¡pdn¨pÅ hnhc§Ä AS§p¶ AkwJyw t]PpIÄ. DÅS¡hpw kqNnIbpw hgn CXv e`n¡pw. Help Topics e`n¡m³ F1 AaÀ¯pI. "C\n bYmÀ° tPmenbnte¡v', ImÀ¯nI ] dªp. "Excel D]tbmKnt¡WvS hn[w \n§Ä a\Ênem¡n¡gnªp. C\n Umä FâÀ sN¿m \pw FUnäv sN¿m\pw \msf ]Tn¡mw. Cs¶\n¡v Hm^okn \n¶pÅ Aev]w tlmwhÀ¡pWvSv. Good Night' "KpUvss\äv, tN¨o.'
Npcp-¡-¯nÂ... F{X k¦oÀ®amb F¡uWvSpIÄ kq£n¡m\pw MS Excel l Word-s\t¸mse¯s¶.D]tbmKn¡ms\fp¸w Excel l FIvk hÀ¡vjoäv AXnhn]pew l skÃpIÄ¡v A{U ÊpIÄ þ tImfhpw hcnbpw kwKan¡p¶X\pkcn¨v sk A{UÊv l IW¡pIÄ¡v t^mÀape l skÃpIfnse {]hr¯nIÄ A¸t¸mÄ t^mÀape _mdn ImWpI l FIvk IW¡pIq«epIÄ an¶ÂthK¯n \S¡p¶p l skÃpIfpsS Range skeIvSv sN¿mw, AXn tPmensN¿mw
http://www.geocities.com/bluemangoaz http://bluemangoa2z.50webs.com/ (8 of 26)3/20/2009 10:24:45 PM
•••••••••••••• ••••••••••••••••••• •••••••
http://bluemango.50webs.com/
FIvk hÀ¡vjoän IfnIfpw IÅ¡fnIfpambn Ccn¡pIbmbncp¶p kp\n Xbpw cXojpw. i_vZw tI«v hmXn¡te¡v t\m¡nbt¸mÄ AhÀ AÛpXs¸«p. ImÀ¯nIbpsS IqsS asämcmÄ. ImÀ¯nItbmfw Dbcw, GXmWvStX XSn. \oe Po³kv. SIvþC³ sNbvX, tImfdnÃm¯ sadq¬ SojÀ«v. BWp§sft¸mse t{Im¸p sNbvX apSn. tXmf¯v Xq§n¡nS¡p¶ _mKv. Imen kvt]mÀ«vkv jq. hbÊv 15þ\pw 25þ\pw CSbv¡v FhnsSbpamImw. N´apsÅmcp kpµcn. I®SbnÃ. (cXojnsâ a\ Ên Iw]yq«À cwK¯pÅhscÃmw I®S¡mcmWv). ImÀ¯nI ]pXpapJs¯ ]cn Nbs¸Sp¯n. "CXv \oena. thjw IWvSv ]Ibv¡pIsbm¶pw thWvS. X\n aebmfns¸¬sIm Snbm. thjw PmSbmbn Iq«nbm aXn. Fsâ Hm^oknse A¡uWvSvkv tkm^vävshbÀ FIvkvs]À«m. Excel BWnhnsS hnjbw F¶v ]dªt¸mÄ ChÄs¡mcp ]qXn, \n§sf AhÄ¡v ] Tn¸n¡Wsa¶v. C\n Excel Igntª t]mIq.' "lmbv... ' \oena Ip«nIÄ¡cnIn h¶p\n¶v kt´mjt¯msS ]dªp. "Ipg¸amIptam', kp\nX cXojnt\mSv ]ndp]ndp¯p. ]t£, \oenabXv tI«p. "Hcp Ipg¸hpanÃ', AhÄ ]dªp. "ImÀ¯nItb¡mÄ at\mlcambn Rm³ \n§sf ] Tn¸n¡pw.' Xncnªv ImÀ¯nItbmSv "FSo, Cu \mdp¶ thjw amdtWvS? H¶v Ipfn¡Ww, hni¸v amäWw.'
IW-¡nsâ hgn-IÄ
2 http://www.geocities.com/bluemangoaz http://bluemango.50webs.com/
"R§Ä Ipfnbpw Xoäbpw Ignªv hcmw, \n§Ä Ccn¡v' ImÀ¯nI ]dªp. "B, tN¨namÀ t]mbn«phm', sXsÃmcp kwibt¯msS cXojpw ]dªp. Umä tNÀ¡m³ Ipfnbpw Im¸nIpSnbpw Ignªph¶ tN¨namÀ t\sc Ip«nIÄ¡cnInse¯n. ImÀ¯nI F¶t¯bpw t]mse ss\änbnembncp¶p. F¶m \oenabpsS thjw cXojn\v t_m[n¨p. "ssIenbpw jÀ«pw.' B thj¯n AhÄ icn ¡psamcp B¬Ip«nbmsWt ¶ tXm¶q. Ft´m IpkrXn ]dbm\h³ hm Xpd¡pt¼mtg¡pw ImÀ¯nI ]dªp. " I p c p ¯ t ¡ sSm¶pw Fgp¶Ån¡WvS DWvS¡®m. ChÄ Bfev]w ioabm.' "] mhamsW¶tà tN¨n t\ct¯ ]d ªXv? kp\nX tNmZn¨p. "Hm, ]mhw {Iqc!' FÃmhcpw Nncn¨p. ImÀ¯nI Hcp ]pkvXIhpsaSp¯v I«nen Ibdnbncp¶p. "icn, XpS§mw', \oena ]dªp. "\n§Ä _me]mTsams¡ ]Tn¨p IgnªtÃm! http://bluemangoa2z.50webs.com/ (9 of 26)3/20/2009 10:24:45 PM
•••••••••••••• ••••••••••••••••••• •••••••
icn, CUnbäv XpS§v' (cXojv sR«n. Ipäs¸Sp¯pwt]mse ImÀ¯nIsb t\m¡n). "Hcp skÃn Hcp kwJy F³À sN¿v.' cXojv A1 skÃn 999 F¶ kwJy ssS¸v sNbvXp. "t^mÀape _mdn t\m¡v', \oena ]dªp. "999 AhnsS h¶XpItWvSm?' "DÆv, AXphcpsa¶v R§Ä¡v t\ct¯ Adnbmw' sXÃl´tbmsS cXojv ]dªp. "tIt«m ImÀ¯ntI, Cu CUnbän\v Adnh¸w IqSpXem' \oena ]dªp. "F¶m C\n tUm¦ntbmSmImw (C¯hW kp\nX sR«n). "t^mÀape _mdnÂ, kwJy IpSmsX F´pWvSv?' "Hm, AXnt¸mgm {i²n¨Xv', kp\nX ]dªp. "cWvSv _«WpIÄ. Hcp KpW\ NnÓw, ]ns¶sbmcp SnIv amÀIv. AsX´n\m?' "Hm, \n\s¡¦nepsamcp kwibapWvStÃm!' \oena ]dªp. "F¦n B KpW\ NnÓapff _«Wn H¶v ¢n¡v sN¿v' kp\nX KpW\NnÓ _«Wn ¢n¡v sNbvXp. skÃn ssS¸v sNbvX kwJy A{]Xy £ambn. http://www.geocities.com/bluemangoaz http://bluemango.50webs.com/
"Blm! CXmtWm kw`hw? At¸mÄ CXv Cancel Button', kp\nX ]dªp. "AsX. A§s\¯ s¶bmWXnsâ t]cv. Esc Io AaÀ¯nbXn\v Xpeyw. ]t£, kwJysbgpXn Enter sN¿p¶Xn\v ap¼v am{Xta AXp] tbm Kn¡m³ Ignbq', \oena hniZoIcn¨p. "F¦nÂ, SnIv amÀ¡v F´n\msW¶v Rm³ ]dbmw', cXojv CSbv¡p Ibdn. skÃn hoWvSpw ssS¸v sNbvXv Ah³ SnIv amÀ¡v DÅ _« Wn ¢n¡v sNbvXp. "atäXv Cancel _«Wm IgptX (kp\nXtbmSv), C\nbo kwJysbm¶v Im³k sN¿v.' "icnbmWv', \oena CSs]«p. "kwJysbgpXn Enter Io AaÀ¯pItbm, SnIv _«¬ ¢n¡v sN¿pItbm sNbvXmte kwJy hÀ¡vjoänsâ `mKamIq. asämcp Imcyw IqSnbp WvSv. Enter Io AaÀ¯n¡gnbp¶tXmsS \½Ä sXm«pXmgs¯ skÃn F¯n ¡gnªp. Shift AaÀ¯n Enter sN¿pIbmsW¦n IgvkÀ sXm«papIfnes¯ skÃnep sa¯pw.' "CXn§s \¯s¶tb ]äq F¶ptWvSm', kwibw kp\nXbptSXv. "CÃtÃm. AXv amäWsa¶psWvS¦n Tools- Option FSp¡pI. Edit F¶ Sm_v IymcIvSÀ kwJybv¡v ap¼nse + NnÓw E/e ]mc³Xnknkv þ {_m¡äv iXam\NnÓw (%) t^mÀhmÀUv Émjv (/) (lcW NnÓw) hyhIe\ NnÓw (-) kwJy¡v ap¼nse ]qPyw (0) Excel hymJym\w + NnÓs¯ AhKWn¡p¶p NnÓ¯n\v ]pdIn t^mÀape hcps¶¦n AXns\ = B¡n http://bluemangoa2z.50webs.com/ (10 of 26)3/20/2009 10:24:45 PM
•••••••••••••• ••••••••••••••••••• •••••••
amäpw. imkv{Xobambn [cn¡p¶p kwJy¡v Ccp]pd¯pamsW¦n s\Käohv kwJybm¡pw. 100þsâ iXam\ambn ImWpw. kwJyIfpsS IqsSbmsW¦n XobXnbmbn [cn¡p¶p. kwJyIfpsS IqsSbmsW¦n XnbXnbmbn IW¡m¡mw. ]qPys¯ AhKWn¡p¶p. F³{Sn +9,000 +90,$D$6 5.5e7 (600) 10% 9/12/92 6/29 8/02 11-02-97 0789 ^ew 9,000 =90+$D$6 5.5E+7 -600 0.10 12þ Sept-1992 June 29, (\S¸phÀjw) Aug, 2002 2-Nov-1997 789 Tab D]tbmKn¨v skeIvSv sNbvX td©neqsS \o§mw
http://www.geocities.com/bluemangoaz http://bluemango.50webs.com/
Xpd¶m In«p¶ Hm]vj³kv Cu \o¡¯n amä§Ä DWvSm¡m³ D]tbmKn¡mw.' \oena ]dªp. skÃpIfpsS Hcp Range-emWv Umä tNÀ¡p¶sX¦n Hcp Ffp¸hgnbpWvSv. Range skeIvSv sNbvXpIgnªm Tab Io D]tbmKn¨v XpS¡w apX Range-sâ Ahkm \s¯ sk hsc \o§mw. hoWvSpw Tab AaÀ¯nbm Xncn¨v Range-se BZys¯ skÃnse¯pw. UmäbpsS Excel hymJym\w \mw \ÂIp¶ Umäsb Excel kz´ambn hymJym\n¡pw þ H¶pIn kwJybmbn, Asæn sSIvÌv Bbn. sSIvkväv Bbn Excel http://bluemangoa2z.50webs.com/ (11 of 26)3/20/2009 10:24:45 PM
•••••••••••••• ••••••••••••••••••• •••••••
ImWp¶ Umäsb AXv se^vävþAsse³ sN¿pw. kwJybmbn ImWp¶Xns\ ssdävþAsse³ sN¿pw. ]qPyw (0) apX H¼Xv (9) hscbpÅ A¡§fpw +, -, E, e, (, ), $, %, / F¶nhbpw BWv kwJym Umäbmbn Excel ImWpI. _m¡n IymcIvSdpIÄ FÃmw Excel-\v sSIvÌmWv. AXpt]mse lcWNnÓanSpt ¼mgpw kq £n¡Ww. 1/25 F¶v lcW¯n \mbn tNÀ¯m Excel CXv XobXnbmbn sXän²cn¨v P \phcn 25 F¶v hymJym \n¡pw. 0.04 F¶ AÀ°¯nemWv \mw 1/ http://www.geocities.com/bluemangoaz http://bluemango.50webs.com/
25 Fs¶gpXp¶sX¦n AXn\v sNdnsbmcp kq{X{]tbmKw \S¯Ww. kwJybv¡v ap¼n \yq\NnÓw, k¦eNnÓw, ]qPyw(0) F¶nhbn GsX¦nepsam¶v tNÀ¡pI. F¶m kwJy¡v ap¼n ]qPyw (0) tNÀ¡p¶Xns\ Excel Imcyambn KWn¡nÃ. AXmbXv, 0484 Fs¶gpXnbm AXv FdWmIpf¯nsâ sSent^m¬ STD tImUÃ, shdpw 484 BWv. At¸mÄ ]ns¶ F´p hgn? 0484-\v ap¼n Hcp ' tNÀ¡pI ('0484). Format sa \phn Cells Iamân Number Sm_n Text skeIvSv sNbvXpw Cu {]iv\w ]cnlcn¡mw. Umä sSIvÌmbn ]cnKWn¡s¸«p Ignªm AXv se^vävþAsse³Uv Bbn amdpw. Nne IymcIvSdpIÄ thWvShn[w D]tbmKn¨nsænÂ, \mw Dt±in¡p¶ AÀ° ¯nembncn¡nà Excel hymJym\n¡pI. Umä ^n "Nne t\c§fn Htc Umätbm t^mÀapetbm Ht«sd tImf§fnepw hcnIfnepw BhÀ¯nt¡WvSXmbn hcmw', \oena ASp¯ L«¯nte¡v IS¶p. "Hmtcm skÃnepw copypaste {]tbmKn¡pIsb¶m t\cw IfbpI F¶p am{XamWÀ°w. Cu {]iv\w ]cnlcn¡m³ Excel \ÂIp¶ Ffp¸amÀ¤amWv Data Fill. BZy skÃnsâ DÅS¡hpw t^mÀamäpw Umä ^n ]IÀ¯p¶p. Hcp tImf¯neqsS Xmtgm«pw Hcp hcnbneqsS het¯m«pw Data Fill sN¿p¶XmWv km[mcW coXn. F¦nepw apIfnte ¡pw CSt¯m«pw Fill sN¿epw km[n¡pw. "sa\p D]tbmKn¨v ^n sN¿mw. ^n sNt¿WvS Range skeIvSv sN¿pI. Range-se BZy skÃnse DÅS¡ambncn¡pw (Xmtgmt«m heXphit¯t¡m) ^n sN¿s¸SpI. Edit sa\phn Fill FSp¯v GXv Znibnte¡mWv ^n sNt¿WvSsX¶v skeIvSv sN¿pI.' aukp]tbmKn¨pw Umäm ^n sN¿mw. CXn\v Excel-sâ ^n http://www.geocities.com/bluemangoaz http://bluemango.50webs.com/
lm³Un D]tbmKn¡p¶p. tIm¸n sNt¿WvS sk skeÎv sN¿pI. skÃnsâ Xmg¯v he¯v aqebn IgvkÀ (+) ¹kv ASbmf¯nemIpw. CXmWv Fill handle. AXn ¢n¡v sNbvXv {UmKv sN¿pI. Umäm kocnkv kzm`mhnIambn hÀ²n¡p¶ (Progression) http://bluemangoa2z.50webs.com/ (12 of 26)3/20/2009 10:24:45 PM
•••••••••••••• ••••••••••••••••••• •••••••
kwJyIfpsS Hcp t{iWnbmWv Data series. kwJyIÄ X½n GsX ¦nepw \nebv¡v _Ô s¸«ncn¡pw. DZm: 2, 4, 6, 8; 1, 2, 3... Cu cWvSv t{iWnbnÂs¸« kwJy Isfbpw Excel a\Ênem ¡pIbpw hymJym\n¡p Ibpw sN¿pw. am{XaÃ, Umä Enter sN¿p¶ skÃpIfpsS range- Umä \ndbv¡pIbpw sN¿pw. kocnkv CSm\pÅ Range skeIvSv sN¿pI. http://www.geocities.com/bluemangoaz http://bluemango.50webs.com/
Edit sa\phn Fill- Series F¶ Iamâ v skeIvSv sNbvXm Hcp UbtemKv t_mIvkv e`n¡pw. UbtemKv t_mIvkn aq¶v hn`mK§fnembn Hm]vj\pIÄ ImWmw. Series in:- skeIvSv sNbvXncn¡p¶ Range A\pkcn¨v Umä \ndbvt¡WvS Zni Excel \nÀ®bn¡pw. skÃpIfpsS Row (hcn), Columns F¶nhbn H¶v skeIvSv sN¿pI. Type Linear: skÃn \ÂInbn«pÅ kwJysb B[mcam¡n, Step value F¶ t_mIvkn \ÂIp¶ aqeya\pkcn¨v td©nse skÃpIfn Linear Progressiosn A\pkcn¨v Excel Umä \nc¯pw. td©nse BZyskÃn InS¡p¶Xv 10þDw Step value 10-Dw BsW¦n td©nse skÃpIfn 10, 20, 30, 40 F¶n§s\ Umä hogpw. Type-Growth: Step Value t_mIvkn \evInbncn¡p¶ aqeyw sImWvSv BZy skÃnse kwJybpsS km[mcW KpW\^e§Ä ASp¯ skÃpIfn \nc¯m \mWv Cu Hm]vj³. skÃnse aqeyw 1þDw Step value 2-Dw BsW¶ncn¡s«. 1, 1x2, 2x2, 4x2, 8x2 Ft¶m, 1, 2, 4, 8, 16 Ft¶m Excel Umä \ndbv¡pw. Type-Date: BgvNb \pkcnt¨m, amka\pkcnt ¨m, XnbXnIfpsS kocnkv \ndbv¡m\mWv Cu Hm]vj³. DZm: H¶mas ¯ skÃn 8/31/01 F¶v FâÀ sNbvXv Date Hm]vj³ Month FSp¡p IbmsW¦n 8/31/01, 9/ 30/01,10/31/01 F¶n §s\ Excel Umä \ndbv¡pw. Type-Autofill: Iptd skÃpIfn Umä FâÀ sNbvX tijw, Hcp td©nse _m¡n skÃp IÄ \ndbv¡m³ Excels\ A\phZn¡m³ A¡ §Ä X½nepÅ _Ôw hyàam¡p¶ Cu Hm]vj³ D]tbmKn¨m aXn. BZyskÃn 15þDw ASp¯ skÃn 25þDw \mw FâÀ sNbvXv Cu Hm]vj³ FSp¯m ASp¯ skÃpIfn 35, 45, 55 F¶n §s\ Excel kwJy \nc¯pw. Trend: Linear, Growth Hm]vj\pIÄt¡ Cu t_mIvkv e`yamIq. Step Value, Stop Value: kwJyIfptStbm XnbXnIfptStbm hÀ²\ F{]Imcw thWsa¶pw KpW\w F§s\ thWsa¶pw \nÀ®bn¡p¶Xv Step Value BWv. kocnknse Gähpw IqSnb kwJy Stop Value t_mIvkn \nÀt±in¡p¶p. http://www.geocities.com/bluemangoaz http://bluemango.50webs.com/ http://bluemangoa2z.50webs.com/ (13 of 26)3/20/2009 10:24:45 PM
•••••••••••••• ••••••••••••••••••• •••••••
"CXv kwKXn Ffp¸amWtÃm tN¨o', kp\nX ]dªp. "FÃm skÃnepw A¡ §Ä \ndt¡WvS KXntISnÃtÃm!' "AsX', \oena k½Xn¨p. "]t£, sImSp¡p¶ aqey§Ä IrXyambncn¡Wsa ¶pam{Xw.' "Aà tN¨o, CsX´m Ipsd Umä CSXp` mK¯pw thsd Iptdsb ®w heXp`mK¯pw Asse³ sNbvXncn¡p ¶Xv?' cXojv tNmZn¨p. "AXv \n\¡v t\cs¯ ]dªp X¶ XmWv. kwJyIÄ heXp `mK¯pw sSIvÌv CSXp `mK¯pamWv Asse³ sN¿pI', \oena ]dªp. "]t£, \o tNmZn¨sX\n¡v a\Ênembn. ]dbmw. \mw Hcp tS_nÄ DWvSm¡n F¶ncn ¡s«. AXns\¡pdn¨v Hcp Ipdn¸v AXnsâ http://www.geocities.com/bluemangoaz http://bluemango.50webs.com/
sbm¸w tNÀt¡WvSnht¶¡mw. AXv tS_nfnsâ heXp`mK¯v ssS¸v sN¿mw. ]t£, kv{Io \nÂ, Ipdn¸v apgph³ {]Xy£ambnsöv hcmw. At¸mÄ B sk skeIvSv sNbvXv Edit sa \phn Fill- Justify FSp¡pI. CXv ItWvSm? Ipdn¸v B tImf ¯n¯s¶ Xmtgm«v Xmtgm«v hn`Pn¨v \nc¶ntÃ?' "Great!' kp\nX ]dªp. ssdäv ¢n¡v "tIt«m, kp\ntX' cXojv kXoÀ°ysb hnfn¨p. "Excel- ssdäv ¢n¡n\v henb {]m[m\yw Csöm tXm¶p¶Xv.' "t]mSm, DWvS¡®m', D¯cw ]dªXv \oenabmWv. "\obÃtÃm AXv Xocpam\n¡p¶Xv. hntijn ¨v Autofill D]tbmKs ¸Sp¶XmWv ssdäv ¢ n¡v.' ^n sN¿m\pÅ Range sXcsªSp¡m³, ^n lm³Un {UmKv s N ¿ p ¶ X n \ p a p ¼ v heXp _«¬ AaÀ¯pI. td©v sXcs ªSp¯p Ignªm _«¬ hnSpI. Hcp tjmÀ«vI«v sa\p e`n ¡p¶p. Autofill sN¿m \pÅ ]e Hm]vj\pIÄ CXn DWvSv. Copy Cells: Hcp ]pXnb kocnkv krjvSn¡p¶Xn\v ]Icw, sXcsªSp¯ skÃnsâ tIm¸nbmbncn ¡pw Autofill BIpI. Fill Series: Autofill D]tbmKn¨v kocokv \ndbv¡p¶ AtX ^ew e`n¡p¶p. Fill Format: Edit sa\phn Paste Special-se Formats FSp¡p¶Xn\v kZriyam WnXv. tIm¸n sNbvX td©nse t^mÀamänsâ AtX {Ia¯nembncn¡pw tIm¸n sN¿ s¸Sp¶Xpw. Fill Values: skÃpIfnse aqey§Ä tIm¸n sN¿p¶p. ]t£, t^mÀamäpIÄ ] IÀ¯s¸Sp¶nÃ. XobXn ASnØm\s¸Sp¯nbpÅ range BsW¦n Days, Weekdays, Years F¶nh ^n sN¿m\pw, Linear Trend, Growth Trend, Series F¶nhbv¡pw ssdäv ¢n¡vþ {UmKv D]tbmKn¡mw. CXn Series skeIvSv sNbvXm Series UbtemKv t_mIvkv e`n¡pw. http://www.geocities.com/bluemangoaz http://bluemango.50webs.com/
IÌw ^n Hcp td©nse skÃpIfn H¶n\Sp¯ Znhkw ASp¯ skÃn hcpwhn[w BgvNbnse Znhk§sf \nc¯m³ Autofill-\v Ignbpw. DZmlcW¯n\v, BZy skÃn Monday http://bluemangoa2z.50webs.com/ (14 of 26)3/20/2009 10:24:45 PM
•••••••••••••• ••••••••••••••••••• •••••••
F¶v ssS¸v sNbvXv skÃnsâ ^n lm³Un hcnbneqsS IpdpsI {UmKv sNbvXm ASp¯ skÃpIfn ASp¯ Znhk§Ä (Tuesday, Wednesday...) sXfnbpw. BgvNbnse Znhk§Ä, amk§Ä F¶n§s\ Øntcm]tbmKw hcp¶ enÌpIÄ D]tbmKn¡p¶ Imcy¯n CXv hfsc {]tbmP\IcamWv. CXpt]mse aäp ]eImcy§fnepw (DZm: Hcp kq¸ÀamÀ¡änse tkm¸v {_m³UpIfpsS enÌv) C¯cw enÌpIÄ D]tbmKn¡m³ Ignbp¶Xv KpWIcamImw. t]cphnhc§fpsS (GXv sSIvÌnsâbpw) kz´amb Hcp enÌv (Custom List) Excel krjvSn¡m³ Ignbpw. C§s\ krjvSn¨ Hcp enÌv ]n¶oSv Autofill- D] tbmKn¡mw. AXmbXv enÌnse BZys¯ t]cv FâÀ sNbvXv {UmKv sNbvXm _m¡n t]cpIÄ {Ia¯n Autofill Bbns¡mÅpw. IÌw enÌv F§s\ DWvSm¡mw? hÀ¡vjoänse Hcp tImf¯n enÌnemt¡WvS t]cpIÄ ssS¸v sN¿pI. enÌn DÄs¸Spt¯WvS {Ia¯nembncn¡Ww ssS¸v sN¿p¶Xv. t]cpIÄ DÄs¡mÅp¶ Cell range skeIvSv sNbvXv Tools- \n¶v Options UbtemKv t_mIvkv FSp¡pI. AXnse Custom Lists Xpd¡pI. * Lists t_mIvkn New List sslsseäv Bbn«psWvS¶v Dd¸m¡pI. * skeIvSv sNbvX Range, Import List from cells F¶ t_mIvkn sXfnªncn ¡pw. http://www.geocities.com/bluemangoaz http://bluemango.50webs.com/
tNÀ¡s¸Spw. ]pXnb enÌv CSXphis¯ Custom Lists F¶ t_mIvknepw sXfnbpw. * OK sN¿pI. UbtemKv t_mIvkn t\cn«v ]pXnb enÌv FâÀ sN¿mw. Custom List t_mIvkn New List skeIvSv sNbvX tijw List Entries t_mIvkn ]pXnb enÌnse t] cpIÄ {Iaa\pkcn¨v ssS¸v sN¿pI. Hmtcm t]cn\pw tijw Enter AaÀ¯Ww. enÌv ssS¸v sNbvXp Ignªm Add ¢n¡v sN¿pI. CXpt]mse¯s¶ Xncp¯pIÄ¡mbn enkvänse t]cpIÄ FUnäv sN¿pIbpamImw. "CXp t]mse Excel- DÅ asämcp kuIcyamWv Auto complete. Htc Umä ]e skÃpIfn BhÀ¯nt¡WvSn hcpt¼mÄ CXv hfsc {]tbmP\{]ZamWv', \oena ]dªp. Auto complete {]mhÀ¯nIam¡m³ Tools- Options FSp¡pI. AXn Edit Sm_v Xpd¶v Enable Auto Complete for Cell Values F¶Xv skeIvSv sN¿pI. skÃn Umä ssS¸v sNbvXpsImWvSncns ¡, AXv ] qÀ¯nbm ¡m³ Excel {ian¨psIm WvSncn¡pw. ap³]v F³À sNbvX hnhc§fn \n¶pamWv Cu "Dulw' Excel \S¯p¶Xv. "Auto Complete- asämcp kuIcyw IqSnbp WvSv', \oena XpSÀ¶p. ap³]v FâÀ sNbvX UmäIfpsS Hcp dropdown http://bluemangoa2z.50webs.com/ (15 of 26)3/20/2009 10:24:45 PM
•••••••••••••• ••••••••••••••••••• •••••••
enÌn \n¶v ASp¯ skÃnte¡v thWvSXv skeIvSv sN¿mw.' FâÀ sN¿m\pÅ ASp¯ sk skeIvSv sNbvXv ssdäv ¢n¡v sN¿pI. Dropdown enÌn \n¶pw BhiyambXv skeIvSv sN¿pI. Umä Xncp¯m³ "Hcp skÃn F³À sNbvX Umätbm t^mÀapetbm Xncpt¯WvSnhcmw', \oena XpSÀ¶p. "CXn\v BZyw sk skeIvSv sN¿pI. t^mÀape _mdn AXnse DÅS¡w sXfnbpw. skÃnse Umä FUnäv sN¿m³ t^mÀape _mdn ¢n¡v sN¿pItbm F2 Io AaÀ¯pItbm sN¿pI. F´p kw`hn¡psa¶v t\m¡mw.' http://www.geocities.com/bluemangoaz http://bluemango.50webs.com/
\mw Edit tamUnemsW¶v ImWn¡m³ Ìmäkv _mdn Edit F¶v sXfnbpw. t^mÀape _mdn Umä Xncp¯m\pw, AXneqsS \o§m\pambn, Hcp IgvkÀ sXfnbpw. skÃn Xs¶ (In-cell) FUnäv sN¿m\pÅ Hm]vj³ Tools- skeIvSv sNbvXn«psWvS¦n IgvkÀ skÃn ImWmw. atäsXmcp t{]m{Kmantebpw t]mse¯s¶bmWv Excel-epw FUnänwKv. CXv GXv thÀUv t{] mÊdnsebpw t]mse Ffp¸hpamWv. an¡ hn³tUmkv t{]m{KmapIfntebpw t]mse Excel-epw Edit sa\phn Hcp Undo IamâpWvSv. Undo Iamsâ Sp¯m F´mWv kw` hn¡pIsb¶v sa\phn tcJs¸Sp¯nbncn¡pw. ÌmtâÀUv SqÄ_mdnse Undo _«¬ Cu {]hr¯n Xs¶ sN¿p¶p. IqSmsX, sXm«vap¼v sNbvX 16 {]hr¯nIfpsS Hcp enÌv Cu _«Wn \n¶v drop-down Bbn e`n ¡p¶p. CXn \n¶v GXv {]hr¯nbmWv Undo sNt¿WvSsX¶v sXcsªSp¡mw. UmäbpsS Øm\amäw "Cutting, Copying, Pasting F¶o {]hr¯nIÄ Excel- CSbv¡nsS BhÀ¯nt ¡WvSXmbn hcmdpWvSv', \oena ]dªp. "CXn\mbn FIvk ]e amÀ¤§Ä \evIp¶p. ]t £, FhnsSsb¦nepw Umä t]Ìv sN¿p¶psh¦n B skÃn ap¼p WvSmbncp¶ Umä ] ns¶ ImWnsöXv HmÀ½n¡Ww. hen¨p \o¡Â Hcp Øe¯v \n¶pw asämcnSt¯¡v Umä amäm\pÅ Excel-se Ffp¸amÀ ¤w Drag-and-drop BWv. CXn\mbn BZyw Øm\w amtäWvS td©v skeIvSv sN¿pI. td©nsâ t_mÀUdn aukv ]nSn¨v ]pXnb Øet¯¡v {UmKv sN¿pI. C§s\ \o§p¶tXmsSm¸w F¯ns¸Sp¶ skÃpIfpsS Øm\w Excel ImWn¨p Xcpw. Tools- Options FSp¯m In«p¶ UbtemKv t_mIvknsâ Edit Sm_v Xpd¶v AXnse Hm]vj\pIÄ D]tbmKn¨p thWw Drag-and- drop kuIcysaSp¡m³. skeIvSv sNbvX td©n\v Npäpw hoXnIqSnb t_mÀUÀ ImWp¶nsæn Cu UbtemKv t_mIvknse skänwKv amtäWvSnhcpw. http://www.geocities.com/bluemangoaz http://bluemangoa2z.50webs.com/ (16 of 26)3/20/2009 10:24:45 PM
•••••••••••••• ••••••••••••••••••• •••••••
http://bluemango.50webs.com/
CtX coXnbn Umä tIm¸n sN¿mw. Umä {UmKv sNbvXv drop sN¿p¶Xn\v ap¼v Ctrl Io AaÀ¯pI. Umä Cut sN¿pIbÃ, ]IÀ¯pIbmWv F¶v ImWn¡p¶ Hcp sNdnb ¹kv (+) ASbmfw Igvkdn\v apIfnembn sXfnbpw. UmäbpsS Cutting, Copying, Pasting F¶nhbv¡v Io t_mÀUv tjmÀ«v I«pIÄ Word-teXp t]mse¯s¶bmWv. Ctrl+X, Ctrl+C, Ctrl+V F¶n§s\. Edit sa\phnse IamâpIÄ D] tbmKn¨pw Cu {]hr¯nIÄ sN¿mw. SqÄ_mdnse _«WpIfpw CtX tPmenIÄ¡mbn D] tbmKn¡mw. "tN¨o, sk Cut sN¿pIsb¶v ]dªmÂ, FSp¯p amäp¶Xv sk Xs¶ bmtWm?' cXojnsâ kwibw. "\ymbamb tNmZyw', \oena Nncn¨p. "]dªp Xcmw.' Hcp hÀ¡vjoänsâ Hcp `mK¯p\n¶pw thsdmcp `mKt¯t¡m, Hcp hÀ¡vjoän \n¶pw asäm¶ntet¡m, asämcp hÀ¡v_p¡ntet¡m Umä amäm³ (t^mÀamäpw amämw) Cutting-Dw PastingDw D]tbmKn¡mw. Cutting F¶mWv hm¡v F¦nepw skÃnse Umä am{Xta amäs¸Sp¶pÅp. sk ]gb t^mÀam än \ne\n¡p¶p. Hcp hÀ¡vjoänse sk \o¡w sN¿m³ AXns\ delete sN¿Ww. "AsX§s\!', tNmZyw kp\nXbn \n¶v. "AXp ]ns¶ ]dbmw.' Hcp sktÃm tdt©m Cut sN¿pt¼mÄ AXn\vNpäpw Ip¯pIÄs¡mWvSpÅ Hcp sse³ sXfnbpw. Cut sNbvX Umä asämcnS¯v H«n¨p tNÀ¡p¶Xp hsc Excel Umäsb icn¡pw Cut sN¿nÃ. Umä asämcnS¯v t]Ìv sNbvXm Ip¯pIÄ sImWvSpÅ sse³ A{]Xy£amIpw. C u t t i n g -D w Pasting-Dw Ign ªmepw Umä bpsS sk sd^ d³kv ]gbXpXs ¶bmbncn¡pw. DZmlcW¯n\v A8*B8 F¶ t^mÀape Cut sNbvXv H8- Paste sNbvXmepw d^d³kv A8*B8 F¶p Xs¶bmbncn ¡pw. tImf§fpw hcnIfpw Hfn¸n¡mw, sXfnbn¡mw. Hcp tImfw Hfn¸n¡m³ tImfw slUnwKn ssdäv ¢n¡v sNbvXp In«p¶ sa\phn \n¶v Hide skeIvSv sN¿pI. tImfw hoWvSpw sXfnbn¡m³ Hfnªncn¡p¶ tImf ¯nsâ Ccp`mK¯papÅ tImf§Ä skeIvSv sNbvXv Hcp tImf¯n ssdäv ¢n¡v sN¿pI. sa\phnÂ\n¶v Unhide FSp¡pI. http://www.geocities.com/bluemangoaz http://bluemango.50webs.com/
"tN¨o, A§s\bmsW¦n Cutting-Dw Copying-Dw X½n F´mWv hyXymkw?' cXojv tNmZn¨p.
http://bluemangoa2z.50webs.com/ (17 of 26)3/20/2009 10:24:45 PM
•••••••••••••• ••••••••••••••••••• •••••••
"Copying-Dw Cutting-Dw an¡hmdpw kZri amWv', \oena hniZoIcn¨p. "]t£, hyXymk apWvSv. Cut sNbvXpIgnªm Umä AhnsS ]ns¶ ImWnÃ. Copy sN¿pIbmsW ¦n Umä AhnsS¯s¶ \ne\n¡pw. am{XaÃ, Copy sNbvX Umä F{X Øe§ fn thWsa¦nepw Paste sN¿mw.' Hcp sktÃm, tdt©m Copy sN¿pt ¼mÄ, Cut sN¿pt¼mgs¯t¸mse, AXn\v Npäpw Ip¯pIÄs¡mWvSv XoÀ¯ Hcp sse³ {]Xy£s¸Spw. CXv Umä ¢n]v t_mÀUnte ¡v \o§n F¶v kqNn¸n¡p¶p. C\n, FhnsSbmtWm Paste sNt¿WvSXv B td©v skeIvSv sN¿mw. F¶ment¸mÄ, Cut sNbvXv Paste sNbvXt¸mgs¯t¸mse, sse³ A{] Xy£amIp¶nÃ. CXnsâbÀ°w ¢n]v t_mÀUv Ct¸mgpw BIvSohv BsW¶pw C\nbpw t]ÌnwKv \S¯msa¶pamWv. Paste sN¿m\pÅ td©v sXcsªSp¡pt¼mÄ, apgp³ td©pw skeIvSv sN¿p ¶Xn\v ] Icw, td©nsâ CS¯p aqebnse sk am{Xw sXcsªSp¯m aXnbmIpw. tImf§fptSbpw hcnIfptSbpw IrXyamb kwJytbmÀ¯v Xs¶ Excel Paste sN¿pw. "Paste sN¿p¶Xv Word-tet¸mse¯s¶bmtWm tN¨o?' cXojv tNmZn¨p. "AXmWn\n ]dbp¶Xv', Paste Iamâ v \ÂInbmÂ, ¢n]v t_mÀUn InS¡p¶ Umä skeIvSv sNbvX `mK¯v H«n¨p shbv¡pI am{XamWv Excel sN¿p¶Xv. Hcp td©mWv tIm¸n sNbvXsX¦nÂ, Paste sN¿m³ Hcp sk am{Xw ¢n¡v sNbvXmepw, Umäbv¡v Bhiy amb td©v Excel sslsseäv sN¿pw. Copy sNbvX Umäbv¡v A\pkrXamb coXnbneà tImfhpw hcnbpw skeIvSv sNbvXsX¦n Excel Hcp Error Message ImWn¡pw. "Htc tIm¸n Xs¶ ]e Øe¯v Paste sN¿ms\m¡ptam, tN¨o', kp\nX tNmZn¨p. "tNmZn¨Xv \¶mbn', \oena ]dªp. "Excel- C¸Wn ]et¸mgpw Bhiyambn hcp¶XmWv.' Hscmä skÃns\ hyXykvX td©pIfnte¡v tIm¸n sN¿mw. BZyw, ] IÀt¯WvS Umä tIm¸n sN¿pI. AXn\ptijw e£yamb sk skeIvSv sN¿pI. C\n GsXms¡ td©nte¡mtWm ]IÀt¯WvSXv, Ctrl Io AaÀ¯n¸nSn¨v Ah skeIvSv sN¿pI. FÃmw skeIvSv sNbvXv Ignªm km[mcWt]mse¯s¶ Paste sN¿pI. 12 hyXykvX UmäIÄ (hyXykvX Office t{]m{KmapIfn \n¶pamImw) tiJZn cn¨v ¢n]vt_mÀUnen«v Ah Paste sN¿m\pÅ kuIcyhpw Excel Xcp¶pWvSv. Paste Special: hfsc {]tbmP\{]Zamb Nne Pasting kuIcy§Ä Paste Special
http://bluemangoa2z.50webs.com/ (18 of 26)3/20/2009 10:24:45 PM
•••••••••••••• ••••••••••••••••••• •••••••
F¶ UbtemKv t_mIvkv hgn Excel \ÂIp¶p. CXnse Paste hn`mK¯n Cu {]tXyI Hm]vj\pIÄ e`n¡p¶p. Paste All : efnXamb t]ÌnwKv Formulas : sk t^mÀamänwKv FSp¡msX t^mÀape am{Xw Paste sN¿mw. Values : tIm¸n sNbvX t^mÀapebpsS ^ew am {Xw Paste sN¿p¶p. Comments : Ipdn¸pIÄ Hcp skÃn \n¶v asäm¶nte¡v ]IÀ¯p¶p. Validation : \ÂInbn«pÅ {]tXyI aqey\nÀ®b am\ZWvU§Ä ]IÀ¯p¶p. All Except Borders : Umä ]IÀ¯pt¼mÄ ]pXnb td©nsâ t_mÀUdn\v amäap WvSmIp¶nÃ. "Paste Special tIm¸n sN¿m\pÅ Iamân\v am{Xta _m[IamIq. hÀ¡vjo än \n¶pw Cut sNbvX Umä ]IÀ¯m³ CXp]tbmKn¡m\mhnÃ', \oena HmÀ½n ¸n¨p. Paste Special UbtemKv t_mIvknse Operations hn`mKw, Paste sN¿pt¼mÄ \St¯WvS KWnXimkv{X {]{Inbsb´msW¶v \nÀt±in¡m\pÅXmWv. Umä Uneoäv sN¿mw "kp\nXbtà t\ct¯ Data Uneoäv sN¿p¶sX§s\sb¶v tNmZn¨Xv', \oena XpSÀ¶p. "AXv hntijn¨v ]dbms\m¶panÃ. F¦nepw \ap¡v t\m¡mw.' Umä cWvSp hn[¯n Delete sN¿mw. H¶v, skÃnse Umäsb am{Xambn \o¡w sN¿mw. Asæn sk Xs¶bpw Delete sN¿mw. Umä am{Xw \o¡w sN¿m³ ]e hgnIfpWvSv. http://www.geocities.com/bluemangoaz http://bluemango.50webs.com/
* skÃnÂ, FUnäv tamUnÂ, kwJyIÄ \o¡w sN¿pI. (Back space, Delete IoIÄ). * Edit sa\phnse Clear Iamâp]tbmKn¡pI. * skÃn ssdäv ¢n¡v sNbvXv t]m¸v A]v sa\phn Clear contents FSp¡pI. * ^n lm³Un CSXp`mK¯v apIfntem«v {UmKv sNbvXv skÃns\ aqSpI. Ìmäkv _mdn Drag Inside to Clear Cell ktµiw ImWmw. * skÃnse F³{Sn skeIvSv sNbvXv ]pXnb Umä ssS¸v sN¿pI. "CsXms¡ tIma¬ sk³knsâ ImcyamWtÃm!' cXojv \nÊmc`mh¯n ]dªp. "t]ms«, sk F§s \bmWv Delete sN¿p¶Xv?' "AXmtemNn¡m\pÅ tIma¬sk³kv \n\¡nÃ, AtÃ?' \oena Nncn¨p. "Hm, Ahs\mcp ]mhw CUnbätÃ?' kp\nX CSbv¡p Ibdn. "B t]ms«', \oena hne¡n. Umä Uneoäv sN¿p¶Xpt]mse A{X efnXaà skÃpIÄ \o¡w sN¿p¶Xv. ImcWw Hä sktÃm Hcp tdt©m Uneoäv sN¿p¶Xv hÀ¡vjoänsâ LS\sb _m[n¡pw. AXn\m C¸Wn¡v apXncp¶Xn\v ap¼v HcÂ]w Nn´n¡p¶Xv \à XmWv. Hcp sk am {Xambn Uneoäv sN¿p¶Xnepw t`Zw, an¡t¸mgpw, Hcp hcntbm tImftam At¸msS \o¡w sN¿p¶Xmbncn¡pw. ImcWw tS_nfpIfpw sk sd^ d³kpIfpsam¶pw XIcmdnemImXncn¡m³ CXv klmbn¡pw. "AXnsâ kq{X¸Wn Rm³ ImWn¨pXcmw', cXojv ]dªp. "hcnbpsStbm tImf ¯nsâtbm slUnwKn (hcnbpsS \¼À, tImf¯nsâ A£cw) ¢n¡v sN¿pI. C\n Edit sa\phn Delete FSp¡pI. t]mbntÃ? http://bluemangoa2z.50webs.com/ (19 of 26)3/20/2009 10:24:45 PM
•••••••••••••• ••••••••••••••••••• •••••••
http://www.geocities.com/bluemangoaz http://bluemango.50webs.com/
"AsX', \oena hnhcn¨p. "hcntbm tImftam \o¡w sN¿p¶Xnsâsbm¸w, Xmgs¯ hcnIsf apIfnte¡pw heXp`mKs¯ tImf§sf CSXp`mKt¯¡pw Excel sImWvSphcp¶p. H¸w Xs¶ FÃm t^mÀapeIsfbpw delete sNbvXX\pkcn¨v Xncp¯pIbpw sN¿p¶p. cWvSmaXv t^mÀapeIÄ FgpXn XIcmdnemthWvS.' "AsXmcp{K³ ]cn]mSnbmWtÃm!' kp\nX AÛpXw {]ISn¸n¨p. "tIma¬sk³kv thWsaSo, tUm¦o', cXojv Ifnbm¡n. "CUnbänsâ tIma¬sk³kv F\n¡ntÃ', kp\nX ssIaeÀ¯n ImWn¨p. "\nÀ¯v \nÀ¯v', \oena imkn¨p. "C\n Hcp sktÃm, tdt©m Uneoäv sN¿p¶ sX§s \sb¶v t\m¡mw.' hcntbm tImftam Uneoäv sN¿p¶ AtX {]{InbbmWv CXn\pw. ]t£, sNdnsbmcp Ipg¸w. CSbv¡p\ns¶mcp sk t]mIpt¼mÄ _m¡nbpÅ Umäsb F§ s \bmWv kÖoIcnt¡WvSsX¶v Excel-\v ]nSnIn«nÃ. A¡mcyw ]dªpsImSpt¡WvSn hcpw. sktÃm tdt©m skeIvSv sNbvXv Delete Iamâ v \ÂIpI. _m¡n skÃp Isf F§s \ kÖoIcn¡Wsa¶Xn\v Hm]vj\pIÄ \nÀt±in¡p¶ Hcp UbtemKv t_mIvkv e`n¡pw. ChnsSbpw delete sNbvXXpsImWvSpWvSmb {]iv\w XoÀ¡m³ t^mÀapeIÄ kzbw IW¡p Iq«m³ Excel {ian¡pw. F¶m Nne tIkp Ifn ]niIv ImWn¡p¶ #REF skÃn sXfnbpw. ChnsS \mw Xs¶ AXv icnbmt ¡WvSn hcpw. " A s X m c e v ] w {]iv\amWtÃm!' kp\nX ]dªp. "Cu ]Wn Hgnhm ¡m³ {ian¡pIbmWv \ÃXv.' ]ns¶ tN¨o, Umä Uneoäv sN¿msa ¦n C³kÀ«v sN¿m\pw IgnbntÃ?' " I g n b p a t à m ! ' \oena ]dªp. Umä XncpIn¡bämw Uneoäv sN¿p¶ AtX coXn Xs¶bmWv C³kÀ«v sN¿p¶Xn\pw Hcp hcntbm tImftam apgph\pamtbm, Hcp sktÃm, tdt©m am{Xamtbm CSbvs¡hnsSsb ¦nepw C³kÀ«v sN¿mw. UneoänwKn F¶ t]mse¯s¶ Hcp hcntbm tImftam apgph\pambn C³kÀ«v sN¿p¶XmWv Ffp ¸amb GÀ¸mSv. http://www.geocities.com/bluemangoaz http://bluemango.50webs.com/
Npcp-¡-¯nÂ... t^mÀape _mdn Im³kÂ, FâÀ _«WpIÄ l UmäbpsS FIvk hymJym\w hyà ambn a\Ênem¡Ww l ZimwikwJyIÄ \ÂIpt¼mÄ {]tXyI{i² Bhiyw l H¶ntesd tImf§fnepw hcnIfnepw Htc kwJy BhÀ¯n¡m³ Umäm ^n l kzm`mhnI hÀ²\bpWvSmIp¶ (Progression) kwJyIsf Umäm kocokneqsS FâÀ sN¿mw l koco knsâ \nÀ®bw Step value, Stop value F¶nh hgn l BgvNIfpw amk§fpw t]mse XpSÀ¨bmb Imcy§Ä FâÀ sN¿m³ Custom fill l 16 {]hr¯nIÄ hsc Undo sN¿m³ kuIcyw http://bluemangoa2z.50webs.com/ (20 of 26)3/20/2009 10:24:45 PM
•••••••••••••• ••••••••••••••••••• •••••••
Hcp hcntbm tImftam ]qÀ®ambpw C³kÀ«v sN¿m³, AXv skeIvSv sN¿pI. AXn\v Delete- sNbvXXpt]mse¯s¶ hcnbpsS \¼dntem tImf¯nsâ A£ c¯ntem ¢n¡v sN¿pI. hcnbmsW¦n skeIvSv sNbvXXn\v sXm«papIfnepw tImfamsW¦n sXm«v CS¯p`mK¯pw Insertion \S¡p¶p. ]pXnb hcnbpsS (tImf ¯nsâ) NpäpapÅ skÃpIÄ t^mÀamäp sNbvXn«pÅXmsW¦n ]pXnb skÃp IÄ¡pw AtX t^mÀamäv e`n¡pw. ChnsSbpw KWnX¯nsâ ]p\xkÖoIcWw Excel \S¯pw. Hcp sktÃm tdt©m C³kÀ«v sN¿p¶Xnepw, Delete sN¿pt¼mÄ DWvSmb sIm¨p{]iv \apWvSmIpw. sktÃm, tdt©m skeIvSv sN¿pI. Edit sa\phn Insert IamsâSp¡pI. skÃpIÄ het¯mt«m Xmtgmt«m amtäWvSXv F¶v tNmZn¡p¶ UbtemKv t_mIvkv sXfnbpw. Ft¸mgmWv C³kÀj³ Bhiyambn hcp¶Xv? Hcp hÀ¡vjoänsâ Hcp `mK¯v \n¶v thsdmcp `mKt¯t¡m, Hcp hÀ¡vjoän \n¶v thsdmcp hÀ¡vjoäntet¡m, Hcp hÀ¡v_p¡n \n¶v asämcp hÀ¡v _p¡ntet¡m Umä Cut sNbvtXm Copy sNbvtXm amtäWvSn hcpt¼mgmWtÃm Cu Bhiyw hcp¶Xv. CXnsâ thKw Iq«m³ Excel kuIcyapWvSv. skÃpIÄ Cut sN¿pItbm Copy sN¿pItbm sNbvXm Insert sa \phnse Hm]vj³ AX\pkcn¨v Cut cells Asæn Copied cells F¶mbn amdpw. C³kÀ«v sNt¿WvS `mKw skeIvSv sNbvXv Cu Hm]vj³ ¢n¡v sN¿pI. Cu {]hr¯nIÄ¡mbn ssdäv ¢n¡v sN¿pt¼mÄ In«p¶ t]m]v A]v sa\phnse IamâpIfpw D]tbmKn¡mhp¶XmWv. Hcp skÃnse FUnänwKv tPmen IÄ¡mbn tjmÀ«vI«v sa\phn Cut, Copy, Insert, Delete, Clear Contents XpS§nb Hm]vj³kv e`n¡p¶p. "C\n \ap¡v Excel-sâ bYmÀ° iàn ImWmw. C¶Ã, \msf', \oena ]dªp. ]t£, \msf Rm³ DWvSmhnÃ. AXn\m aä¶mÄ. C\n DuWv Ign¨v kpJamsbm ¶pd§mw.' http://www.geocities.com/bluemangoaz http://bluemango.50webs.com/
\oena¡v Hcp \mfs¯ tPmen Ignªt¸mtg¡pw Hch[n e`n¨p. Ip«nIÄ¡pw ImÀ¯nIbv¡pw Ah[n e`n¨nsöv am{XaÃ, B Znhkw ISp¯ ]Wnbmbncp¶p. hn³tUmkvþan apX Excel hsc ]Tn¨ ]mT§f{Xbpw {]mtbmKnIambn Iw]yq« dn Ip«nIÄ ]co£n¨p. ASp¯ Znhkw kÔy¡v ImÀ¯nIbpw \oenabpw Ibdnh¶t¸mÄ kp\n Xbpw cXojpw A £acmbncp¶p. Ft´m IWvSp]nSn¨ `mhambncp¶p CcphcpsSbpw apJ¯v. "Ft´m H¯ a«pWvStÃm!' \oena tNmZn¨p.
http://bluemangoa2z.50webs.com/ (21 of 26)3/20/2009 10:24:45 PM
•••••••••••••• ••••••••••••••••••• •••••••
"Hs¯t¶m?' kp\nXbmWv adp]Sn ]dªXv. "s]s«¶v Ipfn¨v Im¸n IpSn¨v hm. C¶v Excel R§Ä \n§sf ]Tn¸n¡pw.' ImÀ¯nIbpw \oenabpw ]ckv]cw t\m¡n. Xncn¨p h¶t¸mÄ, kv{Io\n Hcp hÀ¡vjoäpambn Ip«nIfncphcpw A£acmbn¯s¶ Ccn¡pIbmWv. "Cu tS_nÄ R§Ä X¿mdm¡nbXmWv,' cXojv ]dªp. "C\nbnXnsâ slUnwKpw tImfw slUnwKpw Hs¡ R§Ä at\mlcam¡m³ t]mIpIbmWv.' Format sa\phn \n¶pah³ Format Cells UbtemKv t_mIvskSp¯p. "skeIvSv sNbvX UmäbpsS Asse³saâ v, Zm, Cu Alignment F¶ Sm_v Xpd¶v AXnepÅ Hm]vj\pIÄ D]tbmKn¨v Nn«s¸Sp¯mw. Horizontal Hm]vj³ IpdpsI
3at\m-l-c-amb IW-¡p-]p-kvXIw http://www.geocities.com/bluemangoaz http://bluemango.50webs.com/
bpÅ hn\ymk¯n\v. CXn Indent \ÂIn skÃn sSIvÌnsâ Øm\w \nÀ® bn¡mw', BËmZt¯msS cXojv ]dªp. "At¸mÄ \n§Ä ]Tn¨p Ignªp', \oena Ahsc {]iwkn¨p. B Vertical- \nÀt±iw \ÂIn, Umäsb tImf¯n ew_am¡mw. tS_nfpIfn A¯cw tImfw slUnwKpIÄ at \mlcam bncn¡pw.' "IgnªnÃ', kp\nX \oenasb XSªp. "Cu Text control Hm]vj³ F {X {]tbmP\IcamsWt ¶m! CXn Wrap Text, Shrink to Fit F¶nh sSIvÌv hn\ymk¯n\v hyXykvX `wKnIÄ \ÂIp¶p.' "Umäsb XncÝo\ ambpw ew_ambpw am{Xa Ã, tImtWmSptIm Wmbpw \ÂImw', \oena ]dªp. "AXn\mWv Cu Orientation Hm]vj³. skÃn\I¯v sSIvÌv http://www.geocities.com/bluemangoaz http://bluemango.50webs.com/
F{X Un{Knbn thWsa ¦nepw CXp]tbmKn¨v Id¡mw.' CXp t]mse skÃp IÄ¡pw sk td©p IÄ¡pw `wKnbpÅ t _ m À U d p I f p w \ÂIm³ Ignbpw. Format Cell UbtemKv t_mIvknse Border Sm_v Xpd¶v B t]sPSp ¡pI. CXnse Line F¶ t_mIvknse Style enÌn \n¶v t_mÀUdn\ v CjvSs¸« ]mtä¬ skeIvSv sN¿pI. AXn\v Xmsg color F¶ drop-down enÌn \n¶v t_mÀUdn\mhiyamb \ndw sXcsªSp¡mw. http://bluemangoa2z.50webs.com/ (22 of 26)3/20/2009 10:24:45 PM
•••••••••••••• ••••••••••••••••••• •••••••
Presets hn`mK¯nse _«WpIfn Outline thtWm, Inside t_mÀUÀ thtWm F¶v Xocpam \n¡pI. t_mÀUÀ H¶pw thsWvS¦n None ¢nIv sN¿pI. "MS hn³tUmkpw, hntijn¨v MS Office-Dw \ÂIp¶ kuµcykwhÀ²t\m] http://www.geocities.com/bluemangoaz http://bluemango.50webs.com/
[nIÄ Word- F¶ t]mse Excel-Dw Hcp tUmIypsaâ v (ChnsSsbmcp Workbook) at \ml cam¡m³ sXsÃm¶pa à klmbn¡p¶Xv', ImÀ¯nI CSs]«p. AXphsc FÃmw IWvSnc n ¡ p I b m b n c p ¶ p ImÀ¯nI. "Hm, \n\¡sænepw apSn Nmbv¨pw sNcn¨pw sI«m\pw kuµcyw Iq«m \patà t\capÅp', \oena Ahsf Ifnbm ¡n. "apSnbnÃm¯hÀ ]ns¶ F§s\ Nmbv¡m³, sNcn¡m³, sI«nshbv¡m³...!' ImÀ¯nIbpw hn«nÃ. "sIm¨phÀ¯am\w \nÀ¯v So¨Àamsc', Kuch¯n kp\nX ]dªp. "kwKXn icnbm. Hmtcm hn`mKw F³{Sn¡pw Hmtcm tjbvUv \ÂIp¶Xv tS_nfn\v Hcp sKä¸v Xs¶bmWv.' skÃpIÄt¡m sk td©pIÄt¡m {]tXyI hÀ®§Ä \ÂImw. CXn\mbn Format Cells UbtemKv t_mIvknse Pattern Sm_v Xpd¡pI. CXn IfÀ t_mIvkn \n¶v Bhiyamb \ndhpw Pattern t_mIvkn \n¶v skÃn\v thWvS ]mtäWpw sXcsª Sp¡mw. Excel-2000, Personal Toolbar Fs¶mcp Hm]vj³ Xcp¶pWvSv. HcmÄ Øncambn D] tbmKn¡p¶ SqÄkv BWv Cu SqÄ_mdn {]Xy£s¸Sp¶Xv. ] pXnsbmcp SqÄ D]tbmKn¡p ¶X\pkcn¨v AXnsâ _«¬ SqÄ_mdn {]Xy £s¸Spw. am {XaÃ, W o r d -s e t ¸ m s e Toolbar-Ifpw sa\pIfpw http://www.geocities.com/ bluemangoaz http://bluemango.50webs.com/
FÃmw Iw]yq«À D]tbmKn¡p¶ BfpsS XmÂ]cya\pkcn¨v Customize sN¿m\pw Excel- kuIcyapWvSv. Tools sa\phnse Customize IamsâSp¯m Hcp UbtemKv t_mIvkv e`n¡p¶p. CXnse Toolbars Sm_v Xpd¶pIn«p¶ t]Pn Toolbars F¶ kvIvtdmÄ t_mIvkn \n¶v BhiyapÅXv sXcsªSp¯v D]tbmKn¡m\mbn \ap¡v hn³tUmbn sImWvSp hcmw. CXpt]mse¯s¶ Hmtcm sa\phnepw Bhiyamb IamâpIfpw Customize sN¿mw. Customize UbtemKv t_mIvknse Commands Xpd¶v In«p¶ t_mIvkp IÄ D] tbmKn¨v s]s«¶pÅ D]tbmK¯n\mbn Iamâ v _«WpIÄ drag-and-drop coXnbn SqÄ_mdn tNÀ¡mw. "BsI¡qSn CsXmcp kpJapÅ GÀ¸mSmWtÃm!' cXojv Iaâ v ]dªp. "AsX.' \oena k½Xn¨p.
http://bluemangoa2z.50webs.com/ (23 of 26)3/20/2009 10:24:45 PM
•••••••••••••• ••••••••••••••••••• •••••••
"Hcp Imcyw', kp\nX ]dªp. "R§Ä DWvSm¡nb sSent^m¬ \¼dpIÄ Hs¡ bptWvSm?' ]cnlmk¨phtbmsS ImÀ¯nI tNmZn¨p. "CtÃ, CÃ', kp\nX k½Xn¨p. "Excel {]hÀ¯\w ]cntim[n¡m\mbn sNbvsXt ¶bpÅp. Umä tN¨nbpsS C³UIvkv _p¡ntebm.' sSent^m¬ C³UIvkv X¿mdm¡nb hÀ¡v_p¡v kp\nX Xpd¶pImWn¨p. t_mÀUdpIfpw \nd§fpw sImWvSv at\mlcam¡n. C³UIvkv IWvSv So¨Àamcncphcpw Ip«nIsf {]iwkn¨p. "sImÅmatÃm', ImÀ¯nI ]dªp. "t]cpIÄ A£camem{Ia¯nÂXs¶. ]mSps] «ncp¶v ssS¸v sNbvXpImWpw?' http://www.geocities.com/bluemangoaz http://bluemango.50webs.com/
"aWvS¯cw ]dbmsXsâ tN¨o', cXojv ]dªp. "Excel- FÃm kq{XhpapWvSv.' "Rm³ ] dbmw,' kp\nX CSs]«p. "tN¨nbpsS C³UIvkv _p¡nsâ XpS¡w apX HSp¡w hsc¯s¶bmWv CXn FâÀ sNbvXXv F¶Xv t\cv. AXpsImWvSv cWvSmas¯bpw aq¶mat¯bpsams¡ A£c§Ä {Ia¯nÂXs¶ hcptam?' "IqSpX _p²nImWn¡WvS', ImÀ¯nIbv¡v CtaPv hosWvSSp¡Wambncp¶p. "AXn\mWv Data sa\phnse Sort UbtemKv t_mIvkv. t_mIvknse Ascending _«¬ skeIvSv sNbvXm A apX Z hscbpÅ {Ia ¯n sSIvÌv kÖoIcn ¡pw Excel. Descending _«¬ skeIvSv sNbvXm Z apX A hscbpw.' "At¸mÄ hnhcap WvSv', Ifnbmbn cXojv ]dªq. "t]mSm DWvS¡®m.' "Cu ImÀ¯nIbpw ]ntÅcpw Hcp t]msebm WtÃm!' \oena ]cmXn ] dªp. "Excel-sâ KpW §Ä C\nbpapWvSv.' Umä F³À sNbvXp Ignªv Insert sa\phnse Function UbtemKv t_mIvkv D]tbmKn¨v Im¡ptejsâ hnhn[ `mK§fnse {]iv \§Ä ]cnlcn¡mw. Financial, Math & Trig. (KWnXhpw {XntImWanXnbpw), Statistical, Logical F¶n§s\ hnhn[ hn`mKw [À½§Ä Function Category-bn DWvSmIpw. CXn \n¶v BhiyapÅXv skeIvSv sNbvXm Function Name t_mIvknÂ, B {]tXyI IymäKdnbpsS {]hr ¯nIÄ sXfnbpw. At¸mÄ e`n¡p¶ UbtemKv t_mIvknepsS {]iv \]cnlmcw £n{]km²yw. FIvkensâ At\zjWw Hcp skÃntem t^mÀapebntem sk sd^d³kntem td©v \ma¯ntem DÅ GsXmcp sSIvÌv `mKhpw At\zjn¨p IsWvS¯mw. IsWvS¯n¡gnªmeXv Hmtcm ¶mtbm, Replace Iamâp]tbmKn¨v HäbSnt¡m amämhp¶XpamWv. Hcp hÀ¡vjoäv apgph\ptam, Hcp hÀ¡v_p¡nse apgph³ joäpIfptam Excels\ s¡mWvSv At\zjn¸n¨v Bhiyamb sSIvÌv `mKw IsWvS¯mw. Hcp hÀ¡v_p¡v apgph³ sXcbm³, BZyw AXnse hÀ¡vjoäpIsf {Kq¸v sN¿Ww. {Kq¸v sN¿m³ BZyhÀ¡vjoäv skeIvSv sNbvXv, Shift Io AaÀ¯n¸nSn¨v Ahkm\ hÀ¡vjoäpw skeIvSv sN¿pI. http://bluemangoa2z.50webs.com/ (24 of 26)3/20/2009 10:24:45 PM
•••••••••••••• ••••••••••••••••••• •••••••
http://www.geocities.com/bluemangoaz http://bluemango.50webs.com/
skÀ¨v \S¯p¶Xv C{]Imcw 1. hÀ¡vjoän apgph³ skÀ¨v \S¯m³ Hscmä sk skeIvSv sN¿pI; Hcp td©v skÀ¨v sN¿m³, B td©v skevIvSv sN¿pI. 2. Edit sa \phn Find FSp¡pI (Ctrl+F IoIfpw D]tbmKn¡mw). Find UbtemKv t_mIvkv e`n¡p¶p 3. Find What F¶ t_mIvkn IsWvS t¯WvS sSIvÌv `mKw ssS¸v sN¿pI. 4. \ncIÄ (Rows) A\pkcn¨pw tImf§Ä A\pkcn¨pw skÀ¨v sN¿m³ Find- Hm]vj \pWvSv. 5. Look in Hm]vj\n F³{Sn \S¯pI. CXn Aev]w {i² \ÃXmWv. t^mÀapeIÄ, aqey§Ä (values), comment F¶nh Look in- \ÂImw. 6. Search-\v IrXy http://www.geocities.com/bluemangoaz http://bluemango.50webs.com/
amb Hcp ^ew (match) Xs¶ thWsa¦n Match Case skeIvSv sN¿pI. ChnsS, \mw At\zjn¡m³ ]dbp¶ sSIvÌnsâ AtX Case (upper/ lower) DÅ am¨pIfm bncn¡pw Find IsWvS¯pI. 7. Hcp skÃnse Umä b{Xbpw IsWvS ¯m³ Find Entire Cells Only sN¡v sN¿pI. 8. At\zjn¡m\mhiy s¸« sSIvÌv IsWvS¯nbmÂ, FIvk AXv sslsseäv sN¿pw. C\n skÃn ¢n¡v sNbvXv, thWsa¦n UmäXncp¯mw. Asæn Replace _«¬ D]tbmKn¨v AXns\ amämw. 9. CtX sSIvÌv C\nbpw FhnsSsb¦nepw DsWvS¦n IsWvS¯m³ Find Next ¢n¡v sN¿pI. 10. At\zjW^ew Xr]vXnIcambn e`n¨m Close. http://www.geocities.com/bluemangoaz http://bluemango.50webs.com/
sSIvÌv amä Find UbtemKv t_mIvkp]tbmKn¨v IsWvS¯nb sSIvÌns\ Replace _«¬ D]tbmKn¨v amämw. CXv Find-eqsSbÃmsXbpw sN¿mw. Edit sa\phnse Replace Iamtâm, Ctrl+H IoItfm D]tbmKn¨pw sSIvÌv amämw. Replace t_mIvkn Find-teXp t] mse Look in Hm]vj³ CÃ. t^mÀapeIfntebpw Øncaqey§fntebpw (Constant values) sSIvÌv `mK§sf IsWvS¯n amäp IbmWv Replace sN¿pI. Hcp IW¡pIq«ensâ ^es¯ IsWvS¯mt\m amämt\m Replace-\v IgnbnÃ. skeIvSv sNbvX HäskÃnse sSIvÌv Replace D]tbmKn¨v amämw. Asæn Replace All _«Wp]tbmKn¨v Hcp hÀ¡vjoänepÅXp apgph³ amämw. amtäWvSXmb sSIvÌv `mKw C\nsbmcnS¯pansöv h¶m Excel A¡mcyw Adnbn¡pw. At¸mÄ Close FSp¯v skÀ¨v Ahkm\n¸n¡mw. FIvskÃnsâ kvs]ÃnwKv amÌÀ thÀUnset¸mse, A£cs¯äpIÄ At\zjn ¨p IWvSp] nSn¡p¶ Hcp Spell Checker FIvkenepw DWvSv. Hcp hmt¡m, Hcp sSIvÌv F³{Sntbm, hÀ¡vjoäv apgph\ptam Bhiym\pkcWw CXv ]cntim[n¡pw. Tools sa\p hgntbm F7 D] tbmKnt¨m Spell
http://bluemangoa2z.50webs.com/ (25 of 26)3/20/2009 10:24:45 PM
•••••••••••••• ••••••••••••••••••• •••••••
Check FSp¡mw. Hscmä sk skeIvSv sNbvXv hÀ¡vjoän apgh³ ]cntim[\ \S¯mw. Hcp td©n am{XamWv ]cntim[\ \St¯WvS sX¦n B td©v am{Xw skeIvSv sN¿pI. Hcp skÃnse am{Xw sSIvÌv F³{Sntbm Hscmä hmt¡m thWsa¦nepw Spell sN¡v sN¿mw. CXn\mbn Edit Mode FSp¡Ww. t^mÀape _mdn ¢n¡v sNbvtXm F2 Io AaÀ¯ntbm Edit tamsUSp¡mw. ]cntim[nt¡WvS hm¡v skeIvSv sNbvXv Tools- Spelling FSp¡pI. FIvkensâ Spelling UbtemKv t_mIvkv Word-tâXn\v kZriamWv. ] cntim [n¡p¶ hm¡v sXfnª t_mIvkn\v Xmsg FIvkensâ \nÀ±njvS]Z§Ä ImWmw. Ignore, Ignore All, Change, Change All, Add, Autocorrect XpS§nb Hm]vj\pIÄ ChnsS bpapWvSv. http://www.geocities.com/bluemangoaz http://bluemango.50webs.com/
hÀ¡vjoäpIÄ \o¡w sN¿pI, tNÀ¡pI Hcp hÀ¡v_p¡n Default Bbn DÅXv aq¶v hÀ¡vjoäpIfmWtÃm! CXn hÀ¡vjoäv C³kÀ«v sNbvXv _p¡nsâ I\wIq«mw. \o¡w sNbvXv I\w Ipd¡mw. hÀ¡v_p¡n \n¶pw joäpIÄ \o¡w sN¿m³ joäpIÄ skeIvSv sN¿pI. BZyw Hcp joäv Sm_n ¢n¡v sNbvXv, Shift Io AaÀ¯n ASp¯ joäv Sm_v ¢ n¡v sN¿pI. Edit sa\phn Delete- Sheet FSp¡pI. Asæn skeIvSv sNbvX Hcp joäv Sm_n ssdäv ¢n¡v sNbvXv In«p¶ sa\phn Delete FSp¡pI. skÃpIÄ \o¡w sN¿pt¼mÄ kw`hn¡p¶Xpt]mse joäpIÄ \o¡w sN¿pt ¼mgpw, ASp¯ joäpIÄ hnShv \nI¯m³ CSt¯m«v \o§p¶p. F¶mÂ, skÃp IÄ Uneoäv sNbvX tijw, CSt¯m«v \o§nhcp¶ skÃpIfpsS hnemkw amdp¶ Xpt]mse joäpIÄ ]p\À\maIcWw sN¿s¸Sp¶nÃ. hÀ¡v_p¡n \n¶v Sheet 2 \o¡w sNbvXm ]ns¶bm _p¡n joäv 2 CÃ. A{XXs¶. hÀ¡v_p¡n ]pXnb joäpIÄ tNÀ¡m³, H¶ntesd joäpIÄ tNÀ¡pIbmsW ¦nÂ, Ah skeIvSv sN¿pI. Insert sa\phn Worksheet skeIvSv sN¿pI. Default Bb Hcp hÀ¡vjoämWnSp¶sX¦n AXn\v hyXymksam¶pw ImWnÃ. AXsæn skeIvSv sNbvX joäv Sm_pIfnsem¶n U_nÄ¢n¡v sNbvXv In«p¶ sa\phn \n¶v Insert FSp¡pI. e`n¡p¶ UbtemKv t_mIvkn GXpXcw hÀ¡vjoämWv CtSWvSXv F¶v Xocpam\n¡mw.
Npcp-¡-¯nÂ... hÀ¡v_p¡v at\mlcam¡m³ Format cells UbtemKv t_mIvkv D]tbmKn¡pI l slUnw KpIÄ s\SpIbpw IpdpsIbpw CSmw l skÃpIÄ¡pw td©pIÄ¡pw t_mÀUdpIÄ \ÂImw l tamSn]nSn¸n¡Â Word-teXn\v kZriw l skÃpIÄ¡v \ndw \ÂImw l ImtWWvSXv IsWvS¯m³ FIvken Find kuIcyw l hÀ¡v_p¡n apgph³ Search \S¯n thWvSXv IWvSp]nSn¡mw l Find sNbvX sSIvÌns\ amän asäm¶hnsS sh¡m³ Replace _«¬ l FIvken\papWvSv kvs]ÃnwKv ]cntim[I³
http://bluemangoa2z.50webs.com/ (26 of 26)3/20/2009 10:24:45 PM
`mKw 4
Fw.F-kv. FIvk þ AXn-hn-]p-e-amb IW-¡p-]p-kvXIw l k¦oÀ®KWnX§Ä sRmSnbnSbn \S¯mw l l hÀ¡v_p¡v, hÀ¡vjoäv, skÃpIÄ l l IWs¡gp¯n\v Ffp¸hgnIÄ l l hÀ¡v_p¡n\v tamSntbImw l http://www.geocities.com/bluemangoaz http://bluemango.50webs.com/
]pXnb t{]m{KmamWv ]Tn¡m³ t]mIp¶Xv F¶Xnsâ {XnÃnembncp¶p cXojpw kp \nXbpw. AXn\m Xs¶ km[mcW ImÀ¯nI hcp¶Xn\v ap¼mbpÅ Iw]yq «À the¯c§Äs¡m¶pw AhÀ apXnÀ¶ncp¶nÃ. ImÀ¯nI hcpt¼mÄ Iw]yq «dpw {] nâdpsams¡ "HmWm'¡n, kvIqÄ hntijhpw ]dªncn¡pIbmbncp¶p Ccphcpw. "F´m, C¶v IgpXbpw hnUvVnbpw CSnbpw sXmgnbpsam¶panÃmsX \à Ip«n Ifmbncn¡p¶Xv?' IS¶]mtS ImÀ¯nI tNmZn¨p. "Hm, H¶panÃ,' kp\nX ]dªp. "R§Ä Asænepw \à Iq«pImctÃ?' "Ipd¨p kwkmcw, IqSpX A²zm\w', cXojv CSbv¡v Ibdn. "C¶v ]pXnb t {]m{KmatÃ?' "h¶ph¶v ]nÅmcnt¸mÄ Iev]n¡m\pw XpS§n,' ImÀ¯nI ]cn`hw t]mse ] dªp. "cmhnse apX sshIpt¶cw hsc Hm^okn t{]m{Kmw FgpXÂ, kÔy Ignªm ho«n t{]m{Kmw ]Tn¸n¡Â. Fsâsbmcp hn[ntb! B KÄ^pImc³ sI«nbh \msW¦n `mcysb¡pdn¨v hnNmchpanÃ.' "\ncmibmtIWvS, tN¨o. Fs¶¡mWp¶Xv Ahs \¡mWp¶Xn\v XpeyatÃ?' cXojv Nncn¨p. "FSm DWvS¡®m, acaWvSm, \o apd¯ot¡dns¡m¯pt¶mSm?' ImÀ¯nI Ahs\
FIvk FIvkÂkv
1 http://www.geocities.com/bluemangoaz http://bluemangoa2z.50webs.com/ (1 of 26)3/20/2009 10:24:45 PM
•••••••••••••• ••••••••••••••••••• •••••••
http://bluemango.50webs.com/
ASn¡m³ sN¶p. AhfpsS ssIbn Ibdn¸nSn¨v kp\nX ]dªp: "tN¨o, Ahs\ hnSv... ] mhw CUnbäv. \ap¡v ]pXnb t{]m{Kmw ]Tn¡mw.' "icn, Hcp§ns¡mÅpI', ImÀ¯nI Iw] yq«dn\v ap¼n h¶ncp¶p. "PmeI¸ cn]mSnbpw Fgp¯pw Aev]kzev]w Nn{X¸ WnIfpsams¡ \½Ä ]Tn¨pIgnªp. C\n \ap¡v Aev]w IW¡p Iq«epw IWs¡gp¯pw A¡uWvSv amt\Pvsaâpw ]Tn¡mw.' "At½m! Zm IW¡v hoWvSpw', Icbp¶Xp t]mse cXojv ]dªp. "kvIqfn Xs¶ B \ocmfn shdpsX hnSp ¶nÃ. Ct¸mÄ ChnsSbpw.' " ` b ¡ m s X S m tamt\. FIvk F¶ IWs¡gp¯pImcsâ coXnIÄ GXp aWvS\pw http://www.geocities.com/bluemangoaz http://bluemango.50webs.com/
Ffp¸w ]nSnIn«p¶XmWv. icn¡pw User-friendly. Asæn ]¯mw¢mÊn X«nap «n IW¡v IS¶ F\n¡v FIvkens\ CjvSs¸Sm³ ]äptam?' "Excel, Office-2000 ]mt¡Pnse Hcp t{]m{KmamsW¶tà tN¨n ]dªXv?' kp\nX tNmZn¨p. "AsX. \ap¡v XpS§mw. XpSt§WvSnS¯v XpS§mhp¶XmWv.' Start sa\phnÂ, Programs- Microsoft Excel FSp¯v Excel Bcw`n¡mw. Hm^okv tjmÀ«vI«v _mdn \n¶pw Excel Xpd¡mw. Excel Xpd¶v hÀ¡v Bcw`n¨pIgnbpt¼mÄ Windows- HmSp¶ GXv \à t{]m{Kmapw t]mse D]tbmKn¡m³ Ffp¸amWnsX¶v a\ÊnemIpw. File->Save tkhv sN¿pw; Edit->Copy ]IÀs¸Sp¡pw; Edit>Paste t]Ìv sN¿pw. A§s\ FÃmw Ffp¸w. Excel ASbv¡m³ File- Exit skeIvSv sN¿pI. Excel hn³tUmbn ssSän _mdnse Close _«¬ ¢nIv sNbvXpw Exit sN¿mw. hÀ¡v _p¡v, hÀ¡vjoäv, sk "Word- \½Ä tUmIypsaâ v, t]Pv Fs¶ms¡bmWv ]dªncp¶Xv,' ImÀ¯nI XpSÀ¶p. "Excel- hm¡pIÄ¡v Aev]w amäapWvSv.' Excel- tUmIypsaânsâ t]cv Workbook F¶mWv. A¡uWvSânsâ tai¸pds ¯ IW¡p]pkvXI§fntÃ? AXpt]mse¯s¶, ] e t]PpIÄ DÅXmImw Hcp hÀ¡v _p¡v. Workbook F¶ IW¡p]pkvXI¯nse Hmtcm t]Pnt\bpw Worksheet F¶mWv ]dbpI. hÀ¡vjoänemWv \mw ]WnsbSp¡pI. Excel hn³tUmbnse ]e L«§fpw aäv t{]m{KmapIfntet¸mse¯s¶bmWv. sa\p_mdn\v Xmsg, Excel tPmen¡mhiyamb _«WpIÄ DÅ cWvSv SqÄ_mdpIÄ ImWmw. Excel-sâ {][m \`mKw, hÀ¡vjoänse hÀ¡v Gcnb tImf§fpw hcnIfpw \nd ªXmWv. tImf§fneqsSbpw hcnIfneqsSbpw \o§m³ cWvSv kvt{ImÄ _mdpIfp WvSv. Excel Workbook-Â, ASnØm\]cambn tPmenIÄ sN¿p¶Xv Worksheet- BsW¶v ] dªtÃm! tImf§fpw hcnIfpw \ndª CXv \m«nse IW¡¸nÅamcpsS A¡uWvSv ] pkvXI¯nse XmfpIÄ t]me¯s¶bmWv. Name box Menu bar Title bar Formula bar Active Cell Cell row Cell column Work sheet
http://www.geocities.com/bluemangoaz http://bluemangoa2z.50webs.com/ (2 of 26)3/20/2009 10:24:45 PM
•••••••••••••• ••••••••••••••••••• •••••••
http://bluemango.50webs.com/
Hcp Excel hÀ¡v_p¡n aq¶v hÀ¡vjoäpIÄ BWv DWvSmIpI. IqSpX hÀ¡vjoäpIÄ Bhiysa¦n tNÀ¡mw. Xpd¶phcp¶ Hmtcm tUmIypsaân\pw, Document 1, Document 2 F¶n§s\ Word t]cv sImSp¯ncp¶Xpt]mse, Default Hcp hÀ¡v _p¡nse hÀ¡vjoäpIÄ¡v Sheet 1, Sheet 2 F¶mWv t]cv. Hmtcm hÀ¡v joänsâbpw t]cv joän\v Xmgs¯ Sm_pIfn ImWmw. Xpd¶ncn¡p¶ joänsâ t]cv sXfnªncn¡pw. Dt±in¡p¶ joäv Xpd¡m³, B joänsâ Sm_n ¢nIv sN¿pI. Sm_pIfpsS CSXp`mK¯v ImWp¶ kvt{ImÄ _mÀ D]tbmKn¨v Sm_pIfneqsS thK¯n \o§mw. Hcp hÀ¡vjoän\v {]kàamsbmcp t]cv \ÂImw. B Sm_n UºnÄ ¢nIv sNbvXv t]cv sImSp¡pI. "hÀ¡v joän \ndsb hcnIfpw tImf§fpamWtÃm!' ImÀ¯nI ]dªp. "Cu hcnIÄ¡v F®w C«n«pWvSv. Hcp hÀ¡v joän BsI F{X hcnIfpsWvS¶ dnbmtam? A´w hnScpXv þ 65,536. km[mcWbmbn CXn 26þ27 F®ta hn³tUmbn  ImWm³ Ignbq. tamWnädnsâ sdkeyqj³ amdp¶X\pkcn¨v CXn amäw hcpw. tImf§Ä¡v A, B, C, D F¶n§s\ A£c§Ä \ÂInbn«pWvSv. F{X tImf§ fmWv Hcp hÀ¡v joänset¶m? 256. Cw¥ojv A£camebn 26 A£c§ftà DÅq. Z F¶ tImfw Ignªm ASp¯hbv¡v AA, AB, AC F¶n§s\bmWv t]cp IÄ.' tImf§fpw hcnIfpw tNÀ¶v joänse hÀ¡v Gcnbbn \nd ª n c n ¡ p ¶ I Å n I Ä ¡ v skÃpIÄ (cells) F¶v ]dbp¶p. A £ c § f p w A ¡ § f p w t^mÀapeIfpw FÃmsagpXp¶Xv Cu skÃpIfnemWv. tImf ¯nsâ t]cpw hcn http://www.geocities.com/bluemangoaz http://bluemango.50webs.com/
bpsS t]cpw tImþHmÀUnt\äpIfmbn FSp¯mWv skÃns\ hnh£n¡pI. B20 F¶m B tImfhpw 20þmw hcnbpw tNÀ¶pWvSmIp¶ skÂ. CXv BZys¯ hÀ¡v joänsâ Imcy¯nÂ. hÀ¡v _p¡nse asämcp hÀ¡v joänse Hcp skÃnsâ A{UÊv Sheet 3! B22 F¶msW¦nÂ, B sk aq¶mas¯ joän B tImfhpw 22þmw hcnbpw tNÀ¶pWvSmIp¶XmWv F¶À°w. asämcp hÀ¡v _p¡nse Hcp sk A{UÊn\v ap¼n B hÀ¡v _p¡nsâ t]cpWvSmIpw. (Test.xls) Sheet 3 C25 F¶ A{UÊnsâbÀ°w Test.xls F¶ hÀ¡v _p¡nse aq¶mw joän C tImfhpw 25þmw hcnbpw tNÀ¶pWvSmIp¶ sk F¶mWv. "CsXms¡ ]pdwImgvNbpsS Imcy§fmWv,' ImÀ¯nI XpSÀ¶p. "Cu skÃp IÄ¡pw hÀ¡vjoäpIÄ¡pw hÀ¡v _p¡pIÄ¡psams¡ ]pdIn Excel-sâ A]mc iànbpÅ IW¡p¡q«Â b{´apWvSv. tai¸pd¯ncn¡p¶ ImÂIpteäÀ FSp ¡m³ \ap¡v thWvSkab¯nepw F{Xtbm Npcp§nb t\cw sImWvSv \½psS Bbnc ¡W¡mb IW¡pIsf Excel Nn«s¸Sp¯pw.' Excel PmeI¯nse ]cyS\w
http://bluemangoa2z.50webs.com/ (3 of 26)3/20/2009 10:24:45 PM
•••••••••••••• ••••••••••••••••••• •••••••
sa\p IamâpIfpw Iot_mÀUv Ipdp¡phgnIfpw, tjmÀ«vI«v sa\pIfpw, t^mÀape _mdpw Ìmäkv _mdpw D]tbmK¨v Excel-ambn \mw Bibhn\nabw \S ¯p¶p. IamâpIÄ {][m \ambpw cWvSv hgnIfneqsSbmWv þ sa\p_mdpw tjmÀ«v I«v sa\phpw. Nne IamâpIÄ¡v Iot_mÀUv tjmÀ«vI«pIfpWvSv. DZm: tkhv sN¿m³, Ctrl+S, tIm¸n sN¿m³ Ctrl+C. tjmÀ«vI«pIÄ sa\phnse IamâpIÄs¡m¸w tcJs ¸Sp¯nbncn¡pw. Hcp skÃntem, NmÀ«ntem, SqÄ_mdntem atäm ssdäv ¢nIv sN¿pt ¼mÄ tjmÀ«vI«v sa\p e`n¡p¶p. http://www.geocities.com/bluemangoaz http://bluemango.50webs.com/
t^mÀape _mÀ hÀ¡vjoänse hÀ¡v Gcnbbv¡v sXm«papIfn SqÄ_mdn\v sXm«v XmsgbmWv t^mÀape _mÀ. Excel-se cWvSv {][m\ [À½§Ä CXv \nÀÆln¡p¶p. 1. IgvkÀ Ccn¡p¶ skÃn Umä tNÀ¡m³ ChnsS ssS¸v sNbvXm aXn. Umä ChnsS Xncp¯m\pw Ignbpw. 2. A¸t¸mÄ tPmen sN¿p¶ skÃn F´msW¶Xv t^mÀape _mdn sXfnbpw. hÀ¡v joäntem, {]nâu«ntem t\m¡n Hcp skÃnse aqey¯n\v ]pdInse t^mÀape Xocpam\n¡m³ IgnbnÃ. AXn\m Excel- tPmen sN¿pt¼mÄ CXv t^mÀape _mdn hyàambncn¡pw. t^mÀape _mdnsâ CSXphi¯mWv Name Box. CXn ]e t]cpIfpw sk A{UÊpIfpw sXfnªphcpw. 1. Igvkdncn¡p¶ skÃnsâ A{UÊv; 2. Hcp \nc skÃpIÄ¡v aosX Drag sN¿pt¼mÄ, hcnIfptSbpw tImf§fptSbpw F®w; 3. skeIvSv sNbvX t{UmbnwKnsâtbm NmÀ«ns âtbm t]cv F¶nhsbms¡ t^mÀape _mdnse Name Box- sXfnªp \n¡pw. skÃpIÄ D]tbmKn¡m³ Excel-se Hcp sk skeIvSv sN¿pt¼mÄ AXv Active BIp¶p. AXn\v Npäpw I«nbpÅ Hcp t_mÀUÀ hcp¶p. skeIvSv sNbvX skÃnsâ hcn\¼dpw tImfwseädpw sXfnªp \n¡pw. skÃn Fs ´¦nepw F³{Sn DsWvS¦n AXv t^mÀape _mdn sXfnbpw. Active Bb skÃnte Umä FgpXm\mIq. Hcp skÃns\ ]e hn[¯n skeIvSv sN¿mw. * skÃn aukv ¢nIv sN¿pI. * Iot_mÀUnse Arrow IoIÄ D]tbmKn¨v skÃn \n¶pw skÃnte¡v \o§pI. * Edit sa\phn Go To FSp¡pI. (F5 Iobpw Ctrl+G-bpw CXn\mbn D]tbmKn¡mw). Go To UbtemKv t_mIvkv e`n¡pw. GXv skÃnte¡mtWm t]mtIWvSXv B skÃnsâ A{UÊv (DZm: P 1000) Reference- ssS¸v sN¿pI. hÀ¡vjoän ZriyaÃm¯ Hcp skÃnte¡v t] mIm³ Cu coXn klmbIcamWv. * H¶ntesd skÃpIÄ (Hcp \nc þ Range) skeIvSv sN¿m³ AhbneqsS aukv {UmKv sN¿pI. Shift AaÀ¯n, Arrow Io D]tbmKn¡pIbpw sN¿mw. * Hcp Range-sâ hnemkw ImWn¡p¶Xv AXnsâ CSXvþapIfnsebpw heXvþIogv`mKt¯bpw skÃpIÄ sh¨mWv (DZm: A1:K10). Hcp Range-sâ ske Ivj³ Hgnhm¡m³, asämcp skÃn ¢nIv sNbvXm am{Xw aXn. Go to special http://www.geocities.com/bluemangoaz http://bluemango.50webs.com/
http://bluemangoa2z.50webs.com/ (4 of 26)3/20/2009 10:24:45 PM
•••••••••••••• ••••••••••••••••••• •••••••
Umäbpw t^mÀapebpw FgpXm³ "AÛpXs¸Smdmbnà Ip«nItf', \mSIob kzc¯n ImÀ¯nI ]dªp. "{Xnà Sn¸n¡p¶ Excel AÛpX§Ä hcm\ncn¡p ¶tXbpÅp. Ct¸mÄ, skÃn Umäbpw t^mÀapebpw FgpXp¶Xv F§s\sb¶p ]dªp Xcmw. "Hcp tImf¯n 65,536 skÃp Ifpw Hcp hcnbn 256 skÃpIfpw DsWvS¶v Rm³ t\cs¯ ] dªtÃm! AXv sh¨v, {XnÃSn¸n¡p¶ Hcp kq{Xw Rm³ Aev]kab ¯n\pÅn ImWn¨pXcmw.' Hcp skÃn F{X IymcIvSdpIÄ Enter sN¿msat¶m? 32000-¯ntesd. Hcp t^mÀapebn F{X IymcIvSdpIÄ hscbm Imsat¶m? 1024 hsc. Hcp skÃn Umä sbgpXn Enter AaÀ¯n¡gnªm UmäbXn Dd¨p Ignªp. Enter AaÀ¯p¶ Xn\p ap¼v, Umä ambv¨p Ifbm³ Esc Io AaÀ¯pI. Hcp tPmen sNbvXv Ignªv, AXv Dt]£n¡m³ Edit- Undo skeIvSv sN¿pI. SqÄ_mdnse Undo _«Wpw D]tbmKn¡mw. Undo-hnse drop-down enÌv D] tbmKn¨v Ahkm\ambn sNbvX 16 {]hÀ¯nIÄ hsc Undo sN¿mw. Undo sNbvX Hcp {]hr¯n hoWvSpw C^IvSohm¡m³ Edit->Repeat FSp¡pI. Umäbpw t^mÀapebpw FgpXp¶ kab¯v skÃnsâ kuµcys¯¡pdn¨v thhem Xns¸tSWvS. t^mÀamänwKv ]ns¶ sN¿mw. "Ct¸mÄ ]cn]mSn ]Tn¨tÃm!', ImÀ¯nI ]dªp. "C\n Excel-sâ ImÂIptej³ ]hÀ {] mtbmKnIambn ]cntim[n¡mw. cXotj, A1 sk skeIvSv sNbvXv AXn 65536 F¶v Enter sN¿v. Enter AaÀ¯n IgvkÀ Xmgs¯ skÃn F¯n¡pI. C\n A2-hn 256. CXv Excel hÀ¡vjoänse hcnIfp tSbpw tImf§fptSbpw F®amWv. Enter Hcn¡Â IqSn AaÀ¯pI. "C\n A3 skÃn =A1*A2 F¶ t^mÀape ssS¸v sN¿pI. Equal (=) ASbmfw CSm³ ad¡cpXv. \£{X NnÓw (*) KpW\{Inbbv¡pÅ {]XoIamWv. Enter AaÀ¯ntb¡v. A3 skÃn Ct¸mÄ F´mWv ImWp¶Xv? 16777216 AtÃ? AXmbXv Hcp hÀ¡v joän 167 e£ ¯ntesd skÃpIÄ DsWvS¶v' "ât½m!' AÛpXkzcw hnZymÀ°nIÄ Ccphcn \n¶pw GIIme¯mWpWvSmbXv. C\n Excel-sâ hÀ¡v ]hÀ A1, A2 http://www.geocities.com/bluemangoaz http://bluemango.50webs.com/
t\m¡m\pÅ asämcp ]co£Ww \S¯mw. sk FUnäv sN¿p¶ hnZybmWnXv. A3 skÃnse t^mÀape amän Hcp hÀ¡v _p¡n F{X sk DsWvS¶v IWvSp]n Sn¡mw. * A3 skÃnÂ, AXnse Umä FUnäv sN¿m\mbn, UºnÄ ¢nIv sN¿pI. * t^mÀapebpsS Ahkm \¯n Insertion Point hcp¯m³ End Io AaÀ¯pI. F¶n«v *3 ssS¸v sN¿pI. * Enter AaÀ¯pI. * A3 skÃnse dnkÄ«v t\m¡pIþ50331648. "Hcp hÀ¡v_p¡nse skÃpIfpsS F®sa{X?' ImÀ¯nI tNmZn¨p. "hfsc Ipdhv, AtÃ? A©v tImSnbne[nIw!' Excel-sâ tijnbpsS cpNnbdnbm³ asämcp ]co£Ww FSp¡mw. A1, A2 skÃp Ifnse kwJyIÄ amän t\m¡pI. A3 skÃnse KpW\^ew amdnbXv {i²n¡m³ t]mepw \ap¡v t\cw In«nÃ. A{X s]s«¶mbncn ¡pw amäw.' Hcp t^mÀapebpambn _Ôs¸Sp¶ Umä a m d p ¶ X \ p k c n ¨ v t^mÀape ]p\ÀKWn ¡m³ Excel-\v Ignbp¶p. CsXmcnS¯Ã, Hcp hÀ¡v_p¡nse Hmtcm t^mÀapebnepw Cu doþIm¡ptej³ \S ¡p¶p. UmäIfpw t^mÀapeIfpw AS §p¶ Bbnc¡W¡n\v skÃpIfn C§s\ IW¡p Iq«Â \S¡p¶ http://bluemangoa2z.50webs.com/ (5 of 26)3/20/2009 10:24:45 PM
•••••••••••••• ••••••••••••••••••• •••••••
Imcyw BtemNn¡pI (skÃnse Unkvt¹, AXnse Umäsb _m[n ¡msX, amäm³ Ignbpw). * A1, A3 skÃpIÄ skeIvSv sN¿pI. A1 cell- \n¶v aukv sImWvSv A3 hsc {UmKv sN¿pI. * skeIvSv sNbvX skÃpIfn FhnsSsb¦nepw ssdäv ¢nIv sN¿pI. tjmÀ«v I«v sa\yphn \n¶v Format Cells FSp¡pI. Format Cells UbtemKv t_mIvkv Xpd¡p¶p. * Number F¶ Sm_v ¢nIv sN¿pI. CXn ske£\pIÄ \S¯pt¼mÄ sample t_mIvkn\I¯v \¼À sXfnbp¶Xv {i²n¡pI. * Category enÌn Number skeIvSv sN¿pI. Undo http://www.geocities.com/bluemangoaz http://bluemango.50webs.com/
* Use 1000 Separator F¶ check box ¢nIv sN¿pI. Decimal place- "]qPyw' CSpI. * OK ¢nIv sN¿pI. * A1, A2, A3 skÃpIfn 1000þ\v taepÅ kwJyIfpsS Unkvt¹ t\m¡pI. 1000þ§sf thÀXncn¡p¶ tIma ImWmw. DZm: 65,536. ]t£, Cu amäw bYmÀ°\¼ dns\ _m[n¡nÃ. Unkvt¹bn am{XamWo amäw. hyàambdnbm³ Hcp skÃn ¢nIv sNbvXv t^mÀape _mdn t\m¡pI. AhnsS sXfnbp¶ kwJybn tIma DWvSmhnÃ. kwJyIÄsImWvSpÅ Cu Ifn¡n Sbn Nne skÃpIfn Nnet¸mÄ # # # F¶ ASbmfta ImWq', ImÀ¯nI ]dªp. "]t£, `bs¸tSWvS. kwJyb{Xbpw ImWn¡m³ skÃn\v hoXnbnÃm¯ XpsImWvSmImanXv. Format amän, skÃnsâ hoXnIq«ntbm sNdnb t^mWvSp]tbmKnt¨m Cu {]iv\w ] cnlcn¡mw.' Hmt«m ImÂIpteäv skeIvSv sNbvXncn¡p¶ skÃpIfnse kwJyIfpsS XpI Unkvt¹ sN¿m\mbn Hcp henb kuIcyw Excel-\pWvSv. CXmWv Auto Calculate. B4 apX B9 hscbpÅ skÃpIÄ skeIvSv sNbvXncn¡pt¼mÄ (B4:B9) B Bdv skÃpIfnse kwJyIfpsS XpI (Sum =) Status bar- {]Xy£s¸Spw. sNt¿WvS tPmenbpsS t^mÀape FgpXmsX¯s¶ XpI ImWm\pÅ Gähpw \à Ffp¸ hgn CXmWv. (Auto Calculate C\nbpw kuIcy§fpWvSv. Auto Calculator Cânt¡ädn ¢nIv sNbvXm In«p¶ tjmÀ«vI«v sa\p D]tbmKn¨v, IW¡pIq«ensâ coXn amämhp¶XmWv.) Excel-se bm{XIÄ Excel hÀ¡vjoäv Hcp ]mcmhmcamsW ¶v a\ÊnembntÃ? ImÀ¯nI ]dªp. AXnsâ Hcp sNdnb `mKw am{XamWv \mw ImWp¶Xv. hÀ¡vjoänsâ asämcp `mKt¯¡v \o§m³ AhnsS Hcp sk skeIvSv sN¿pItb thWvSp. AXn\v autkm Iot_mÀtUm D]tbm Kn¡mw. Asæn AXn\mbn Iamâpap WvSv. Format Cells http://www.geocities.com/bluemangoaz http://bluemango.50webs.com/
skÃneqsS \o§m³ * Hcp Arrow Io AaÀ¯pI * kvt{ImÄ _mdnsâ cWvSä¯pÅ ArrowIfn GsX¦nepsam c®w ¢nIv sNbvXv AXv NqWvSp¶ `mKt ¯¡v Scroll sN¿mw. * Hcp sk skeIvSv s N ¿ p I . Iot_mÀUnse Scroll Lock
http://bluemangoa2z.50webs.com/ (6 of 26)3/20/2009 10:24:45 PM
•••••••••••••• ••••••••••••••••••• •••••••
AaÀ¯pI. ske Ivj³ amdmsX ¯s¶ hÀ¡v joänepsS \o§m³ kvt{ImÄ Arrow IoIÄ D]tbmKn¡mw. * aukn\v kvt{ImÄ ho DsWvS¦n AXp]tbmKn¨v hn³tUmbn kvt{ImÄ sN¿mw. kv{Io\neqsS \o§m³ * Hmtcm kv{Io³ apIfntebvt¡m Xmtgbvt¡m \o§m³ Page Up, Page Down IoIÄ. * Scroll Box _«Wv ]pd¯v kvt{ImÄ _mdn ¢nIv sN¿pI. * Scroll Box {UmKv sN¿pI. Scroll box {UmKv sN¿pt¼mÄ \n§Ä F¯ns¸Sp¶ tImfhpw hcnIfpw sXfnbp¶ Hcp Scroll Tip ImWmw. hÀ¡vjoäpIÄ amäm³ hn³tUmbpsS Iogv`mKs¯ Sm_pIfn ¢nIv sNbvXv BhiyapÅ hÀ¡v joäv FSp¡mw. Ctrl+Page Up, Ctrl+Page Down IoIfpw C¡mcy¯n\mbn D]tbmKn¡mw. IpXn¨pNm«§Ä ]et¸mgpw kv{Io\n ZriyaÃm¯ Hcp skÃntet¡m Range-tebvt¡m \ap¡v NmtSWvSn hcpw. CXn\v Go To UbtemKv t_mIvkv FSp¡mw. (Edit-Go To). UbtemKv t_mIvknse Go To enÌn \n¶v t]mtIWvS Range skeIvSv sN¿pItbm, Reference box- A{UÊv ssS¸v sN¿pItbm sN¿mw. Formula Box-se Name Box D]tbmKn¨pw C¯cw Nm«w \S¯mw. Name box- Hcp hnemktam Range Name-Hm ssS¸v sNbvXv Enter AaÀ¯nbm aXn. CXn\mbn t_mIvknsâ drop-down enÌpw D]tbmKn¡mw. http://www.geocities.com/bluemangoaz http://bluemango.50webs.com/
* Home Io AaÀ¯nbmÂ, tPmen sN¿p¶ hcnbpsS XpS¡¯n F¯mw. * Ctrl+Home D] tbmKn¨v \nehnepÅ hÀ¡v joänsâ A1 skÃnse¯mw. * Ctrl+End AaÀ¯pI. sXm«pap¼v tPmen sNbvX tImf¯nsebpw hcnbnsebpw skÃnse¯mw. End AaÀ¯nb tijw Home AaÀ¯nbmepw CXp Xs¶ ^ew. * End AaÀ¯n Enter sN¿pI. tPmen sNbvXpsImWvSncn¡p¶ hcnbn Ahkm \ambn D]tbmKn¨ skÃnse¯mw. hÀ¡v_p¡v amäm³ "Word- Htc kab¯v ]e tUmIypsaân tPmen sN¿p¶Xpt]mse, Excel Htc kab¯v ]e Workbook-Ifn tPmen sN¿mw', ImÀ¯nI ]dªp. "hn³tUm IÄ amdp¶ ]Wnt]mse Xs¶bmWv hÀ¡v_p¡pIÄ amdp¶Xpw.' * ASp¯ hÀ¡v_p¡v kv{Io \n ImWm\psWvS¦n AXn ¢nIv sN¿pI. * Window sa\phn \n¶v BhiyapÅ hÀ¡v_p¡v skeIvSv sN¿pI. * Ctrl+F6 AaÀ¯p¶Xv ASp¯ hn³tUmbnte¡v t]mIm³ klmbn¡p¶p. "Excel-eqsS bm{X sN¿m\pÅ amÀ¤§Ä CsXms¡bmWv. C\n \ap¡v SqÄ_mdp IÄ D]tbmKn¡p¶Xv F§s\bmsW¶v t\m¡mw þ ]Xnhv Im¸n ¡ptijw.' ImÀ¯nI Im¸nsbSp¡m³ apdnhn«pt] mbn. SqÄ_mÀ D]tbmKn¡p¶Xv I m ¸ n b p a m b n ImÀ¯nI hcpt¼mÄ kp\nXbpw cXojpw Excel-
http://bluemangoa2z.50webs.com/ (7 of 26)3/20/2009 10:24:45 PM
•••••••••••••• ••••••••••••••••••• •••••••
sâ ImÂIptej³ ]hÀ ]cntim[n¨psIm WvSncn¡pIbmbncp¶p. "AXv ]n¶oSmImw. \msf sshIo«v Rm³ hcp¶Xn\p ap¼v CjvSw t]mse kabapWvStÃm! Ct¸mÄ \ap¡v SqÄ_mdp IÄ t\m¡mw,' ImÀ¯nI ]dªp. Excel 2000 shÀjt\msSm¸w h¶ Hcp ]pXnb Hm]vj \mWv Personal SqÄ_mÀ. HcmÄ IqSpXembn D]tbmKn¡p¶ SqÄ_mdpIfpsS ]«nIbmWnXnsâ ASn¯d. Standard SqÄ_mdnsebpw Formatting SqÄ_mdntebpw _«WpIÄ Cu SqÄ_mdn ImWpw. SqÄ_mdn FÃm _«WpIfpw H¶n¨v \nc¯m³ thWvS ØeanÃm¯XpsImWvSv, IqSp Xembn D]tbmKn¡p¶ SqfpIfmbncn¡pw Personal SqÄ_mdn ImWpI. AXn \m¯s¶ Personal Toolbar-se Unkvt¹ sFäwkv hÀ¡\pkcn¨v amdns¡mWvSncn¡pw. http://www. geocities.com/bluemangoaz http://bluemango.50webs.com/
BhiyapÅ _«¬ SqÄ_mdn ImWp¶nsæn More Buttons _«¬ ¢nIv sN¿pI. Standard, Formatting SqÄ_mdpIfn ImWp¶ Personal Toolbar D]tbmKw \nÀºÔanÃ. Standard, Formatting SqÄ_mdpIÄ cWvSv \ncIfnembn¯s¶ display sN¿mhp¶XmWv. Personal Toolbar- FhnsSsb¦nepw ssdäv ¢nIv sN¿pI. Customize UbtemKv t_mIvkv e`n¡p¶p. UbtemKv t_mIvknse Options Sm_v skeIvSv sNbvXv B t]sPSp¡pI. Standard and Formatting Toolbars Share One Row F¶Xnsâ skeIvj³ \o¡w sN¿pI. OK ¢n¡v sN¿pI Standard, Formatting SqÄ_mdpIÄ IqSmsX ]ns¶bpw SqÄ_mdpIÄ DWvSv FIvken Â. ChsbSp¡m³ View sa\phn Toolbars skeIvSv sN¿pI, slÂ]v e`n¡m³ aq¶v hn[¯nepÅ Help, Excel 2000 hmKvZm\w sN¿p¶p. Office Assistant: Word-tet¸mse Hcp "Indp¡³' IYm]m{Xw tNmZy§Ä¡v icnbp ¯cw Xcp¶p. Help Topics: Excel-s \¡pdn¨pÅ hnhc§Ä AS§p¶ AkwJyw t]PpIÄ. DÅS¡hpw kqNnIbpw hgn CXv e`n¡pw. Help Topics e`n¡m³ F1 AaÀ¯pI. "C\n bYmÀ° tPmenbnte¡v', ImÀ¯nI ] dªp. "Excel D]tbmKnt¡WvS hn[w \n§Ä a\Ênem¡n¡gnªp. C\n Umä FâÀ sN¿m \pw FUnäv sN¿m\pw \msf ]Tn¡mw. Cs¶\n¡v Hm^okn \n¶pÅ Aev]w tlmwhÀ¡pWvSv. Good Night' "KpUvss\äv, tN¨o.'
Npcp-¡-¯nÂ... F{X k¦oÀ®amb F¡uWvSpIÄ kq£n¡m\pw MS Excel l Word-s\t¸mse¯s¶.D]tbmKn¡ms\fp¸w Excel l FIvk hÀ¡vjoäv AXnhn]pew l skÃpIÄ¡v A{U ÊpIÄ þ tImfhpw hcnbpw kwKan¡p¶X\pkcn¨v sk A{UÊv l IW¡pIÄ¡v t^mÀape l skÃpIfnse {]hr¯nIÄ A¸t¸mÄ t^mÀape _mdn ImWpI l FIvk IW¡pIq«epIÄ an¶ÂthK¯n \S¡p¶p l skÃpIfpsS Range skeIvSv sN¿mw, AXn tPmensN¿mw
http://www.geocities.com/bluemangoaz http://bluemangoa2z.50webs.com/ (8 of 26)3/20/2009 10:24:45 PM
•••••••••••••• ••••••••••••••••••• •••••••
http://bluemango.50webs.com/
FIvk hÀ¡vjoän IfnIfpw IÅ¡fnIfpambn Ccn¡pIbmbncp¶p kp\n Xbpw cXojpw. i_vZw tI«v hmXn¡te¡v t\m¡nbt¸mÄ AhÀ AÛpXs¸«p. ImÀ¯nIbpsS IqsS asämcmÄ. ImÀ¯nItbmfw Dbcw, GXmWvStX XSn. \oe Po³kv. SIvþC³ sNbvX, tImfdnÃm¯ sadq¬ SojÀ«v. BWp§sft¸mse t{Im¸p sNbvX apSn. tXmf¯v Xq§n¡nS¡p¶ _mKv. Imen kvt]mÀ«vkv jq. hbÊv 15þ\pw 25þ\pw CSbv¡v FhnsSbpamImw. N´apsÅmcp kpµcn. I®SbnÃ. (cXojnsâ a\ Ên Iw]yq«À cwK¯pÅhscÃmw I®S¡mcmWv). ImÀ¯nI ]pXpapJs¯ ]cn Nbs¸Sp¯n. "CXv \oena. thjw IWvSv ]Ibv¡pIsbm¶pw thWvS. X\n aebmfns¸¬sIm Snbm. thjw PmSbmbn Iq«nbm aXn. Fsâ Hm^oknse A¡uWvSvkv tkm^vävshbÀ FIvkvs]À«m. Excel BWnhnsS hnjbw F¶v ]dªt¸mÄ ChÄs¡mcp ]qXn, \n§sf AhÄ¡v ] Tn¸n¡Wsa¶v. C\n Excel Igntª t]mIq.' "lmbv... ' \oena Ip«nIÄ¡cnIn h¶p\n¶v kt´mjt¯msS ]dªp. "Ipg¸amIptam', kp\nX cXojnt\mSv ]ndp]ndp¯p. ]t£, \oenabXv tI«p. "Hcp Ipg¸hpanÃ', AhÄ ]dªp. "ImÀ¯nItb¡mÄ at\mlcambn Rm³ \n§sf ] Tn¸n¡pw.' Xncnªv ImÀ¯nItbmSv "FSo, Cu \mdp¶ thjw amdtWvS? H¶v Ipfn¡Ww, hni¸v amäWw.'
IW-¡nsâ hgn-IÄ
2 http://www.geocities.com/bluemangoaz http://bluemango.50webs.com/
"R§Ä Ipfnbpw Xoäbpw Ignªv hcmw, \n§Ä Ccn¡v' ImÀ¯nI ]dªp. "B, tN¨namÀ t]mbn«phm', sXsÃmcp kwibt¯msS cXojpw ]dªp. Umä tNÀ¡m³ Ipfnbpw Im¸nIpSnbpw Ignªph¶ tN¨namÀ t\sc Ip«nIÄ¡cnInse¯n. ImÀ¯nI F¶t¯bpw t]mse ss\änbnembncp¶p. F¶m \oenabpsS thjw cXojn\v t_m[n¨p. "ssIenbpw jÀ«pw.' B thj¯n AhÄ icn ¡psamcp B¬Ip«nbmsWt ¶ tXm¶q. Ft´m IpkrXn ]dbm\h³ hm Xpd¡pt¼mtg¡pw ImÀ¯nI ]dªp. " I p c p ¯ t ¡ sSm¶pw Fgp¶Ån¡WvS DWvS¡®m. ChÄ Bfev]w ioabm.' "] mhamsW¶tà tN¨n t\ct¯ ]d ªXv? kp\nX tNmZn¨p. "Hm, ]mhw {Iqc!' FÃmhcpw Nncn¨p. ImÀ¯nI Hcp ]pkvXIhpsaSp¯v I«nen Ibdnbncp¶p. "icn, XpS§mw', \oena ]dªp. "\n§Ä _me]mTsams¡ ]Tn¨p IgnªtÃm! http://bluemangoa2z.50webs.com/ (9 of 26)3/20/2009 10:24:45 PM
•••••••••••••• ••••••••••••••••••• •••••••
icn, CUnbäv XpS§v' (cXojv sR«n. Ipäs¸Sp¯pwt]mse ImÀ¯nIsb t\m¡n). "Hcp skÃn Hcp kwJy F³À sN¿v.' cXojv A1 skÃn 999 F¶ kwJy ssS¸v sNbvXp. "t^mÀape _mdn t\m¡v', \oena ]dªp. "999 AhnsS h¶XpItWvSm?' "DÆv, AXphcpsa¶v R§Ä¡v t\ct¯ Adnbmw' sXÃl´tbmsS cXojv ]dªp. "tIt«m ImÀ¯ntI, Cu CUnbän\v Adnh¸w IqSpXem' \oena ]dªp. "F¶m C\n tUm¦ntbmSmImw (C¯hW kp\nX sR«n). "t^mÀape _mdnÂ, kwJy IpSmsX F´pWvSv?' "Hm, AXnt¸mgm {i²n¨Xv', kp\nX ]dªp. "cWvSv _«WpIÄ. Hcp KpW\ NnÓw, ]ns¶sbmcp SnIv amÀIv. AsX´n\m?' "Hm, \n\s¡¦nepsamcp kwibapWvStÃm!' \oena ]dªp. "F¦n B KpW\ NnÓapff _«Wn H¶v ¢n¡v sN¿v' kp\nX KpW\NnÓ _«Wn ¢n¡v sNbvXp. skÃn ssS¸v sNbvX kwJy A{]Xy £ambn. http://www.geocities.com/bluemangoaz http://bluemango.50webs.com/
"Blm! CXmtWm kw`hw? At¸mÄ CXv Cancel Button', kp\nX ]dªp. "AsX. A§s\¯ s¶bmWXnsâ t]cv. Esc Io AaÀ¯nbXn\v Xpeyw. ]t£, kwJysbgpXn Enter sN¿p¶Xn\v ap¼v am{Xta AXp] tbm Kn¡m³ Ignbq', \oena hniZoIcn¨p. "F¦nÂ, SnIv amÀ¡v F´n\msW¶v Rm³ ]dbmw', cXojv CSbv¡p Ibdn. skÃn hoWvSpw ssS¸v sNbvXv Ah³ SnIv amÀ¡v DÅ _« Wn ¢n¡v sNbvXp. "atäXv Cancel _«Wm IgptX (kp\nXtbmSv), C\nbo kwJysbm¶v Im³k sN¿v.' "icnbmWv', \oena CSs]«p. "kwJysbgpXn Enter Io AaÀ¯pItbm, SnIv _«¬ ¢n¡v sN¿pItbm sNbvXmte kwJy hÀ¡vjoänsâ `mKamIq. asämcp Imcyw IqSnbp WvSv. Enter Io AaÀ¯n¡gnbp¶tXmsS \½Ä sXm«pXmgs¯ skÃn F¯n ¡gnªp. Shift AaÀ¯n Enter sN¿pIbmsW¦n IgvkÀ sXm«papIfnes¯ skÃnep sa¯pw.' "CXn§s \¯s¶tb ]äq F¶ptWvSm', kwibw kp\nXbptSXv. "CÃtÃm. AXv amäWsa¶psWvS¦n Tools- Option FSp¡pI. Edit F¶ Sm_v IymcIvSÀ kwJybv¡v ap¼nse + NnÓw E/e ]mc³Xnknkv þ {_m¡äv iXam\NnÓw (%) t^mÀhmÀUv Émjv (/) (lcW NnÓw) hyhIe\ NnÓw (-) kwJy¡v ap¼nse ]qPyw (0) Excel hymJym\w + NnÓs¯ AhKWn¡p¶p NnÓ¯n\v ]pdIn t^mÀape hcps¶¦n AXns\ = B¡n http://bluemangoa2z.50webs.com/ (10 of 26)3/20/2009 10:24:45 PM
•••••••••••••• ••••••••••••••••••• •••••••
amäpw. imkv{Xobambn [cn¡p¶p kwJy¡v Ccp]pd¯pamsW¦n s\Käohv kwJybm¡pw. 100þsâ iXam\ambn ImWpw. kwJyIfpsS IqsSbmsW¦n XobXnbmbn [cn¡p¶p. kwJyIfpsS IqsSbmsW¦n XnbXnbmbn IW¡m¡mw. ]qPys¯ AhKWn¡p¶p. F³{Sn +9,000 +90,$D$6 5.5e7 (600) 10% 9/12/92 6/29 8/02 11-02-97 0789 ^ew 9,000 =90+$D$6 5.5E+7 -600 0.10 12þ Sept-1992 June 29, (\S¸phÀjw) Aug, 2002 2-Nov-1997 789 Tab D]tbmKn¨v skeIvSv sNbvX td©neqsS \o§mw
http://www.geocities.com/bluemangoaz http://bluemango.50webs.com/
Xpd¶m In«p¶ Hm]vj³kv Cu \o¡¯n amä§Ä DWvSm¡m³ D]tbmKn¡mw.' \oena ]dªp. skÃpIfpsS Hcp Range-emWv Umä tNÀ¡p¶sX¦n Hcp Ffp¸hgnbpWvSv. Range skeIvSv sNbvXpIgnªm Tab Io D]tbmKn¨v XpS¡w apX Range-sâ Ahkm \s¯ sk hsc \o§mw. hoWvSpw Tab AaÀ¯nbm Xncn¨v Range-se BZys¯ skÃnse¯pw. UmäbpsS Excel hymJym\w \mw \ÂIp¶ Umäsb Excel kz´ambn hymJym\n¡pw þ H¶pIn kwJybmbn, Asæn sSIvÌv Bbn. sSIvkväv Bbn Excel http://bluemangoa2z.50webs.com/ (11 of 26)3/20/2009 10:24:45 PM
•••••••••••••• ••••••••••••••••••• •••••••
ImWp¶ Umäsb AXv se^vävþAsse³ sN¿pw. kwJybmbn ImWp¶Xns\ ssdävþAsse³ sN¿pw. ]qPyw (0) apX H¼Xv (9) hscbpÅ A¡§fpw +, -, E, e, (, ), $, %, / F¶nhbpw BWv kwJym Umäbmbn Excel ImWpI. _m¡n IymcIvSdpIÄ FÃmw Excel-\v sSIvÌmWv. AXpt]mse lcWNnÓanSpt ¼mgpw kq £n¡Ww. 1/25 F¶v lcW¯n \mbn tNÀ¯m Excel CXv XobXnbmbn sXän²cn¨v P \phcn 25 F¶v hymJym \n¡pw. 0.04 F¶ AÀ°¯nemWv \mw 1/ http://www.geocities.com/bluemangoaz http://bluemango.50webs.com/
25 Fs¶gpXp¶sX¦n AXn\v sNdnsbmcp kq{X{]tbmKw \S¯Ww. kwJybv¡v ap¼n \yq\NnÓw, k¦eNnÓw, ]qPyw(0) F¶nhbn GsX¦nepsam¶v tNÀ¡pI. F¶m kwJy¡v ap¼n ]qPyw (0) tNÀ¡p¶Xns\ Excel Imcyambn KWn¡nÃ. AXmbXv, 0484 Fs¶gpXnbm AXv FdWmIpf¯nsâ sSent^m¬ STD tImUÃ, shdpw 484 BWv. At¸mÄ ]ns¶ F´p hgn? 0484-\v ap¼n Hcp ' tNÀ¡pI ('0484). Format sa \phn Cells Iamân Number Sm_n Text skeIvSv sNbvXpw Cu {]iv\w ]cnlcn¡mw. Umä sSIvÌmbn ]cnKWn¡s¸«p Ignªm AXv se^vävþAsse³Uv Bbn amdpw. Nne IymcIvSdpIÄ thWvShn[w D]tbmKn¨nsænÂ, \mw Dt±in¡p¶ AÀ° ¯nembncn¡nà Excel hymJym\n¡pI. Umä ^n "Nne t\c§fn Htc Umätbm t^mÀapetbm Ht«sd tImf§fnepw hcnIfnepw BhÀ¯nt¡WvSXmbn hcmw', \oena ASp¯ L«¯nte¡v IS¶p. "Hmtcm skÃnepw copypaste {]tbmKn¡pIsb¶m t\cw IfbpI F¶p am{XamWÀ°w. Cu {]iv\w ]cnlcn¡m³ Excel \ÂIp¶ Ffp¸amÀ¤amWv Data Fill. BZy skÃnsâ DÅS¡hpw t^mÀamäpw Umä ^n ]IÀ¯p¶p. Hcp tImf¯neqsS Xmtgm«pw Hcp hcnbneqsS het¯m«pw Data Fill sN¿p¶XmWv km[mcW coXn. F¦nepw apIfnte ¡pw CSt¯m«pw Fill sN¿epw km[n¡pw. "sa\p D]tbmKn¨v ^n sN¿mw. ^n sNt¿WvS Range skeIvSv sN¿pI. Range-se BZy skÃnse DÅS¡ambncn¡pw (Xmtgmt«m heXphit¯t¡m) ^n sN¿s¸SpI. Edit sa\phn Fill FSp¯v GXv Znibnte¡mWv ^n sNt¿WvSsX¶v skeIvSv sN¿pI.' aukp]tbmKn¨pw Umäm ^n sN¿mw. CXn\v Excel-sâ ^n http://www.geocities.com/bluemangoaz http://bluemango.50webs.com/
lm³Un D]tbmKn¡p¶p. tIm¸n sNt¿WvS sk skeÎv sN¿pI. skÃnsâ Xmg¯v he¯v aqebn IgvkÀ (+) ¹kv ASbmf¯nemIpw. CXmWv Fill handle. AXn ¢n¡v sNbvXv {UmKv sN¿pI. Umäm kocnkv kzm`mhnIambn hÀ²n¡p¶ (Progression) http://bluemangoa2z.50webs.com/ (12 of 26)3/20/2009 10:24:45 PM
•••••••••••••• ••••••••••••••••••• •••••••
kwJyIfpsS Hcp t{iWnbmWv Data series. kwJyIÄ X½n GsX ¦nepw \nebv¡v _Ô s¸«ncn¡pw. DZm: 2, 4, 6, 8; 1, 2, 3... Cu cWvSv t{iWnbnÂs¸« kwJy Isfbpw Excel a\Ênem ¡pIbpw hymJym\n¡p Ibpw sN¿pw. am{XaÃ, Umä Enter sN¿p¶ skÃpIfpsS range- Umä \ndbv¡pIbpw sN¿pw. kocnkv CSm\pÅ Range skeIvSv sN¿pI. http://www.geocities.com/bluemangoaz http://bluemango.50webs.com/
Edit sa\phn Fill- Series F¶ Iamâ v skeIvSv sNbvXm Hcp UbtemKv t_mIvkv e`n¡pw. UbtemKv t_mIvkn aq¶v hn`mK§fnembn Hm]vj\pIÄ ImWmw. Series in:- skeIvSv sNbvXncn¡p¶ Range A\pkcn¨v Umä \ndbvt¡WvS Zni Excel \nÀ®bn¡pw. skÃpIfpsS Row (hcn), Columns F¶nhbn H¶v skeIvSv sN¿pI. Type Linear: skÃn \ÂInbn«pÅ kwJysb B[mcam¡n, Step value F¶ t_mIvkn \ÂIp¶ aqeya\pkcn¨v td©nse skÃpIfn Linear Progressiosn A\pkcn¨v Excel Umä \nc¯pw. td©nse BZyskÃn InS¡p¶Xv 10þDw Step value 10-Dw BsW¦n td©nse skÃpIfn 10, 20, 30, 40 F¶n§s\ Umä hogpw. Type-Growth: Step Value t_mIvkn \evInbncn¡p¶ aqeyw sImWvSv BZy skÃnse kwJybpsS km[mcW KpW\^e§Ä ASp¯ skÃpIfn \nc¯m \mWv Cu Hm]vj³. skÃnse aqeyw 1þDw Step value 2-Dw BsW¶ncn¡s«. 1, 1x2, 2x2, 4x2, 8x2 Ft¶m, 1, 2, 4, 8, 16 Ft¶m Excel Umä \ndbv¡pw. Type-Date: BgvNb \pkcnt¨m, amka\pkcnt ¨m, XnbXnIfpsS kocnkv \ndbv¡m\mWv Cu Hm]vj³. DZm: H¶mas ¯ skÃn 8/31/01 F¶v FâÀ sNbvXv Date Hm]vj³ Month FSp¡p IbmsW¦n 8/31/01, 9/ 30/01,10/31/01 F¶n §s\ Excel Umä \ndbv¡pw. Type-Autofill: Iptd skÃpIfn Umä FâÀ sNbvX tijw, Hcp td©nse _m¡n skÃp IÄ \ndbv¡m³ Excels\ A\phZn¡m³ A¡ §Ä X½nepÅ _Ôw hyàam¡p¶ Cu Hm]vj³ D]tbmKn¨m aXn. BZyskÃn 15þDw ASp¯ skÃn 25þDw \mw FâÀ sNbvXv Cu Hm]vj³ FSp¯m ASp¯ skÃpIfn 35, 45, 55 F¶n §s\ Excel kwJy \nc¯pw. Trend: Linear, Growth Hm]vj\pIÄt¡ Cu t_mIvkv e`yamIq. Step Value, Stop Value: kwJyIfptStbm XnbXnIfptStbm hÀ²\ F{]Imcw thWsa¶pw KpW\w F§s\ thWsa¶pw \nÀ®bn¡p¶Xv Step Value BWv. kocnknse Gähpw IqSnb kwJy Stop Value t_mIvkn \nÀt±in¡p¶p. http://www.geocities.com/bluemangoaz http://bluemango.50webs.com/ http://bluemangoa2z.50webs.com/ (13 of 26)3/20/2009 10:24:45 PM
•••••••••••••• ••••••••••••••••••• •••••••
"CXv kwKXn Ffp¸amWtÃm tN¨o', kp\nX ]dªp. "FÃm skÃnepw A¡ §Ä \ndt¡WvS KXntISnÃtÃm!' "AsX', \oena k½Xn¨p. "]t£, sImSp¡p¶ aqey§Ä IrXyambncn¡Wsa ¶pam{Xw.' "Aà tN¨o, CsX´m Ipsd Umä CSXp` mK¯pw thsd Iptdsb ®w heXp`mK¯pw Asse³ sNbvXncn¡p ¶Xv?' cXojv tNmZn¨p. "AXv \n\¡v t\cs¯ ]dªp X¶ XmWv. kwJyIÄ heXp `mK¯pw sSIvÌv CSXp `mK¯pamWv Asse³ sN¿pI', \oena ]dªp. "]t£, \o tNmZn¨sX\n¡v a\Ênembn. ]dbmw. \mw Hcp tS_nÄ DWvSm¡n F¶ncn ¡s«. AXns\¡pdn¨v Hcp Ipdn¸v AXnsâ http://www.geocities.com/bluemangoaz http://bluemango.50webs.com/
sbm¸w tNÀt¡WvSnht¶¡mw. AXv tS_nfnsâ heXp`mK¯v ssS¸v sN¿mw. ]t£, kv{Io \nÂ, Ipdn¸v apgph³ {]Xy£ambnsöv hcmw. At¸mÄ B sk skeIvSv sNbvXv Edit sa \phn Fill- Justify FSp¡pI. CXv ItWvSm? Ipdn¸v B tImf ¯n¯s¶ Xmtgm«v Xmtgm«v hn`Pn¨v \nc¶ntÃ?' "Great!' kp\nX ]dªp. ssdäv ¢n¡v "tIt«m, kp\ntX' cXojv kXoÀ°ysb hnfn¨p. "Excel- ssdäv ¢n¡n\v henb {]m[m\yw Csöm tXm¶p¶Xv.' "t]mSm, DWvS¡®m', D¯cw ]dªXv \oenabmWv. "\obÃtÃm AXv Xocpam\n¡p¶Xv. hntijn ¨v Autofill D]tbmKs ¸Sp¶XmWv ssdäv ¢ n¡v.' ^n sN¿m\pÅ Range sXcsªSp¡m³, ^n lm³Un {UmKv s N ¿ p ¶ X n \ p a p ¼ v heXp _«¬ AaÀ¯pI. td©v sXcs ªSp¯p Ignªm _«¬ hnSpI. Hcp tjmÀ«vI«v sa\p e`n ¡p¶p. Autofill sN¿m \pÅ ]e Hm]vj\pIÄ CXn DWvSv. Copy Cells: Hcp ]pXnb kocnkv krjvSn¡p¶Xn\v ]Icw, sXcsªSp¯ skÃnsâ tIm¸nbmbncn ¡pw Autofill BIpI. Fill Series: Autofill D]tbmKn¨v kocokv \ndbv¡p¶ AtX ^ew e`n¡p¶p. Fill Format: Edit sa\phn Paste Special-se Formats FSp¡p¶Xn\v kZriyam WnXv. tIm¸n sNbvX td©nse t^mÀamänsâ AtX {Ia¯nembncn¡pw tIm¸n sN¿ s¸Sp¶Xpw. Fill Values: skÃpIfnse aqey§Ä tIm¸n sN¿p¶p. ]t£, t^mÀamäpIÄ ] IÀ¯s¸Sp¶nÃ. XobXn ASnØm\s¸Sp¯nbpÅ range BsW¦n Days, Weekdays, Years F¶nh ^n sN¿m\pw, Linear Trend, Growth Trend, Series F¶nhbv¡pw ssdäv ¢n¡vþ {UmKv D]tbmKn¡mw. CXn Series skeIvSv sNbvXm Series UbtemKv t_mIvkv e`n¡pw. http://www.geocities.com/bluemangoaz http://bluemango.50webs.com/
IÌw ^n Hcp td©nse skÃpIfn H¶n\Sp¯ Znhkw ASp¯ skÃn hcpwhn[w BgvNbnse Znhk§sf \nc¯m³ Autofill-\v Ignbpw. DZmlcW¯n\v, BZy skÃn Monday http://bluemangoa2z.50webs.com/ (14 of 26)3/20/2009 10:24:45 PM
•••••••••••••• ••••••••••••••••••• •••••••
F¶v ssS¸v sNbvXv skÃnsâ ^n lm³Un hcnbneqsS IpdpsI {UmKv sNbvXm ASp¯ skÃpIfn ASp¯ Znhk§Ä (Tuesday, Wednesday...) sXfnbpw. BgvNbnse Znhk§Ä, amk§Ä F¶n§s\ Øntcm]tbmKw hcp¶ enÌpIÄ D]tbmKn¡p¶ Imcy¯n CXv hfsc {]tbmP\IcamWv. CXpt]mse aäp ]eImcy§fnepw (DZm: Hcp kq¸ÀamÀ¡änse tkm¸v {_m³UpIfpsS enÌv) C¯cw enÌpIÄ D]tbmKn¡m³ Ignbp¶Xv KpWIcamImw. t]cphnhc§fpsS (GXv sSIvÌnsâbpw) kz´amb Hcp enÌv (Custom List) Excel krjvSn¡m³ Ignbpw. C§s\ krjvSn¨ Hcp enÌv ]n¶oSv Autofill- D] tbmKn¡mw. AXmbXv enÌnse BZys¯ t]cv FâÀ sNbvXv {UmKv sNbvXm _m¡n t]cpIÄ {Ia¯n Autofill Bbns¡mÅpw. IÌw enÌv F§s\ DWvSm¡mw? hÀ¡vjoänse Hcp tImf¯n enÌnemt¡WvS t]cpIÄ ssS¸v sN¿pI. enÌn DÄs¸Spt¯WvS {Ia¯nembncn¡Ww ssS¸v sN¿p¶Xv. t]cpIÄ DÄs¡mÅp¶ Cell range skeIvSv sNbvXv Tools- \n¶v Options UbtemKv t_mIvkv FSp¡pI. AXnse Custom Lists Xpd¡pI. * Lists t_mIvkn New List sslsseäv Bbn«psWvS¶v Dd¸m¡pI. * skeIvSv sNbvX Range, Import List from cells F¶ t_mIvkn sXfnªncn ¡pw. http://www.geocities.com/bluemangoaz http://bluemango.50webs.com/
tNÀ¡s¸Spw. ]pXnb enÌv CSXphis¯ Custom Lists F¶ t_mIvknepw sXfnbpw. * OK sN¿pI. UbtemKv t_mIvkn t\cn«v ]pXnb enÌv FâÀ sN¿mw. Custom List t_mIvkn New List skeIvSv sNbvX tijw List Entries t_mIvkn ]pXnb enÌnse t] cpIÄ {Iaa\pkcn¨v ssS¸v sN¿pI. Hmtcm t]cn\pw tijw Enter AaÀ¯Ww. enÌv ssS¸v sNbvXp Ignªm Add ¢n¡v sN¿pI. CXpt]mse¯s¶ Xncp¯pIÄ¡mbn enkvänse t]cpIÄ FUnäv sN¿pIbpamImw. "CXp t]mse Excel- DÅ asämcp kuIcyamWv Auto complete. Htc Umä ]e skÃpIfn BhÀ¯nt¡WvSn hcpt¼mÄ CXv hfsc {]tbmP\{]ZamWv', \oena ]dªp. Auto complete {]mhÀ¯nIam¡m³ Tools- Options FSp¡pI. AXn Edit Sm_v Xpd¶v Enable Auto Complete for Cell Values F¶Xv skeIvSv sN¿pI. skÃn Umä ssS¸v sNbvXpsImWvSncns ¡, AXv ] qÀ¯nbm ¡m³ Excel {ian¨psIm WvSncn¡pw. ap³]v F³À sNbvX hnhc§fn \n¶pamWv Cu "Dulw' Excel \S¯p¶Xv. "Auto Complete- asämcp kuIcyw IqSnbp WvSv', \oena XpSÀ¶p. ap³]v FâÀ sNbvX UmäIfpsS Hcp dropdown http://bluemangoa2z.50webs.com/ (15 of 26)3/20/2009 10:24:45 PM
•••••••••••••• ••••••••••••••••••• •••••••
enÌn \n¶v ASp¯ skÃnte¡v thWvSXv skeIvSv sN¿mw.' FâÀ sN¿m\pÅ ASp¯ sk skeIvSv sNbvXv ssdäv ¢n¡v sN¿pI. Dropdown enÌn \n¶pw BhiyambXv skeIvSv sN¿pI. Umä Xncp¯m³ "Hcp skÃn F³À sNbvX Umätbm t^mÀapetbm Xncpt¯WvSnhcmw', \oena XpSÀ¶p. "CXn\v BZyw sk skeIvSv sN¿pI. t^mÀape _mdn AXnse DÅS¡w sXfnbpw. skÃnse Umä FUnäv sN¿m³ t^mÀape _mdn ¢n¡v sN¿pItbm F2 Io AaÀ¯pItbm sN¿pI. F´p kw`hn¡psa¶v t\m¡mw.' http://www.geocities.com/bluemangoaz http://bluemango.50webs.com/
\mw Edit tamUnemsW¶v ImWn¡m³ Ìmäkv _mdn Edit F¶v sXfnbpw. t^mÀape _mdn Umä Xncp¯m\pw, AXneqsS \o§m\pambn, Hcp IgvkÀ sXfnbpw. skÃn Xs¶ (In-cell) FUnäv sN¿m\pÅ Hm]vj³ Tools- skeIvSv sNbvXn«psWvS¦n IgvkÀ skÃn ImWmw. atäsXmcp t{]m{Kmantebpw t]mse¯s¶bmWv Excel-epw FUnänwKv. CXv GXv thÀUv t{] mÊdnsebpw t]mse Ffp¸hpamWv. an¡ hn³tUmkv t{]m{KmapIfntebpw t]mse Excel-epw Edit sa\phn Hcp Undo IamâpWvSv. Undo Iamsâ Sp¯m F´mWv kw` hn¡pIsb¶v sa\phn tcJs¸Sp¯nbncn¡pw. ÌmtâÀUv SqÄ_mdnse Undo _«¬ Cu {]hr¯n Xs¶ sN¿p¶p. IqSmsX, sXm«vap¼v sNbvX 16 {]hr¯nIfpsS Hcp enÌv Cu _«Wn \n¶v drop-down Bbn e`n ¡p¶p. CXn \n¶v GXv {]hr¯nbmWv Undo sNt¿WvSsX¶v sXcsªSp¡mw. UmäbpsS Øm\amäw "Cutting, Copying, Pasting F¶o {]hr¯nIÄ Excel- CSbv¡nsS BhÀ¯nt ¡WvSXmbn hcmdpWvSv', \oena ]dªp. "CXn\mbn FIvk ]e amÀ¤§Ä \evIp¶p. ]t £, FhnsSsb¦nepw Umä t]Ìv sN¿p¶psh¦n B skÃn ap¼p WvSmbncp¶ Umä ] ns¶ ImWnsöXv HmÀ½n¡Ww. hen¨p \o¡Â Hcp Øe¯v \n¶pw asämcnSt¯¡v Umä amäm\pÅ Excel-se Ffp¸amÀ ¤w Drag-and-drop BWv. CXn\mbn BZyw Øm\w amtäWvS td©v skeIvSv sN¿pI. td©nsâ t_mÀUdn aukv ]nSn¨v ]pXnb Øet¯¡v {UmKv sN¿pI. C§s\ \o§p¶tXmsSm¸w F¯ns¸Sp¶ skÃpIfpsS Øm\w Excel ImWn¨p Xcpw. Tools- Options FSp¯m In«p¶ UbtemKv t_mIvknsâ Edit Sm_v Xpd¶v AXnse Hm]vj\pIÄ D]tbmKn¨p thWw Drag-and- drop kuIcysaSp¡m³. skeIvSv sNbvX td©n\v Npäpw hoXnIqSnb t_mÀUÀ ImWp¶nsæn Cu UbtemKv t_mIvknse skänwKv amtäWvSnhcpw. http://www.geocities.com/bluemangoaz http://bluemangoa2z.50webs.com/ (16 of 26)3/20/2009 10:24:45 PM
•••••••••••••• ••••••••••••••••••• •••••••
http://bluemango.50webs.com/
CtX coXnbn Umä tIm¸n sN¿mw. Umä {UmKv sNbvXv drop sN¿p¶Xn\v ap¼v Ctrl Io AaÀ¯pI. Umä Cut sN¿pIbÃ, ]IÀ¯pIbmWv F¶v ImWn¡p¶ Hcp sNdnb ¹kv (+) ASbmfw Igvkdn\v apIfnembn sXfnbpw. UmäbpsS Cutting, Copying, Pasting F¶nhbv¡v Io t_mÀUv tjmÀ«v I«pIÄ Word-teXp t]mse¯s¶bmWv. Ctrl+X, Ctrl+C, Ctrl+V F¶n§s\. Edit sa\phnse IamâpIÄ D] tbmKn¨pw Cu {]hr¯nIÄ sN¿mw. SqÄ_mdnse _«WpIfpw CtX tPmenIÄ¡mbn D] tbmKn¡mw. "tN¨o, sk Cut sN¿pIsb¶v ]dªmÂ, FSp¯p amäp¶Xv sk Xs¶ bmtWm?' cXojnsâ kwibw. "\ymbamb tNmZyw', \oena Nncn¨p. "]dªp Xcmw.' Hcp hÀ¡vjoänsâ Hcp `mK¯p\n¶pw thsdmcp `mKt¯t¡m, Hcp hÀ¡vjoän \n¶pw asäm¶ntet¡m, asämcp hÀ¡v_p¡ntet¡m Umä amäm³ (t^mÀamäpw amämw) Cutting-Dw PastingDw D]tbmKn¡mw. Cutting F¶mWv hm¡v F¦nepw skÃnse Umä am{Xta amäs¸Sp¶pÅp. sk ]gb t^mÀam än \ne\n¡p¶p. Hcp hÀ¡vjoänse sk \o¡w sN¿m³ AXns\ delete sN¿Ww. "AsX§s\!', tNmZyw kp\nXbn \n¶v. "AXp ]ns¶ ]dbmw.' Hcp sktÃm tdt©m Cut sN¿pt¼mÄ AXn\vNpäpw Ip¯pIÄs¡mWvSpÅ Hcp sse³ sXfnbpw. Cut sNbvX Umä asämcnS¯v H«n¨p tNÀ¡p¶Xp hsc Excel Umäsb icn¡pw Cut sN¿nÃ. Umä asämcnS¯v t]Ìv sNbvXm Ip¯pIÄ sImWvSpÅ sse³ A{]Xy£amIpw. C u t t i n g -D w Pasting-Dw Ign ªmepw Umä bpsS sk sd^ d³kv ]gbXpXs ¶bmbncn¡pw. DZmlcW¯n\v A8*B8 F¶ t^mÀape Cut sNbvXv H8- Paste sNbvXmepw d^d³kv A8*B8 F¶p Xs¶bmbncn ¡pw. tImf§fpw hcnIfpw Hfn¸n¡mw, sXfnbn¡mw. Hcp tImfw Hfn¸n¡m³ tImfw slUnwKn ssdäv ¢n¡v sNbvXp In«p¶ sa\phn \n¶v Hide skeIvSv sN¿pI. tImfw hoWvSpw sXfnbn¡m³ Hfnªncn¡p¶ tImf ¯nsâ Ccp`mK¯papÅ tImf§Ä skeIvSv sNbvXv Hcp tImf¯n ssdäv ¢n¡v sN¿pI. sa\phnÂ\n¶v Unhide FSp¡pI. http://www.geocities.com/bluemangoaz http://bluemango.50webs.com/
"tN¨o, A§s\bmsW¦n Cutting-Dw Copying-Dw X½n F´mWv hyXymkw?' cXojv tNmZn¨p.
http://bluemangoa2z.50webs.com/ (17 of 26)3/20/2009 10:24:45 PM
•••••••••••••• ••••••••••••••••••• •••••••
"Copying-Dw Cutting-Dw an¡hmdpw kZri amWv', \oena hniZoIcn¨p. "]t£, hyXymk apWvSv. Cut sNbvXpIgnªm Umä AhnsS ]ns¶ ImWnÃ. Copy sN¿pIbmsW ¦n Umä AhnsS¯s¶ \ne\n¡pw. am{XaÃ, Copy sNbvX Umä F{X Øe§ fn thWsa¦nepw Paste sN¿mw.' Hcp sktÃm, tdt©m Copy sN¿pt ¼mÄ, Cut sN¿pt¼mgs¯t¸mse, AXn\v Npäpw Ip¯pIÄs¡mWvSv XoÀ¯ Hcp sse³ {]Xy£s¸Spw. CXv Umä ¢n]v t_mÀUnte ¡v \o§n F¶v kqNn¸n¡p¶p. C\n, FhnsSbmtWm Paste sNt¿WvSXv B td©v skeIvSv sN¿mw. F¶ment¸mÄ, Cut sNbvXv Paste sNbvXt¸mgs¯t¸mse, sse³ A{] Xy£amIp¶nÃ. CXnsâbÀ°w ¢n]v t_mÀUv Ct¸mgpw BIvSohv BsW¶pw C\nbpw t]ÌnwKv \S¯msa¶pamWv. Paste sN¿m\pÅ td©v sXcsªSp¡pt¼mÄ, apgp³ td©pw skeIvSv sN¿p ¶Xn\v ] Icw, td©nsâ CS¯p aqebnse sk am{Xw sXcsªSp¯m aXnbmIpw. tImf§fptSbpw hcnIfptSbpw IrXyamb kwJytbmÀ¯v Xs¶ Excel Paste sN¿pw. "Paste sN¿p¶Xv Word-tet¸mse¯s¶bmtWm tN¨o?' cXojv tNmZn¨p. "AXmWn\n ]dbp¶Xv', Paste Iamâ v \ÂInbmÂ, ¢n]v t_mÀUn InS¡p¶ Umä skeIvSv sNbvX `mK¯v H«n¨p shbv¡pI am{XamWv Excel sN¿p¶Xv. Hcp td©mWv tIm¸n sNbvXsX¦nÂ, Paste sN¿m³ Hcp sk am{Xw ¢n¡v sNbvXmepw, Umäbv¡v Bhiy amb td©v Excel sslsseäv sN¿pw. Copy sNbvX Umäbv¡v A\pkrXamb coXnbneà tImfhpw hcnbpw skeIvSv sNbvXsX¦n Excel Hcp Error Message ImWn¡pw. "Htc tIm¸n Xs¶ ]e Øe¯v Paste sN¿ms\m¡ptam, tN¨o', kp\nX tNmZn¨p. "tNmZn¨Xv \¶mbn', \oena ]dªp. "Excel- C¸Wn ]et¸mgpw Bhiyambn hcp¶XmWv.' Hscmä skÃns\ hyXykvX td©pIfnte¡v tIm¸n sN¿mw. BZyw, ] IÀt¯WvS Umä tIm¸n sN¿pI. AXn\ptijw e£yamb sk skeIvSv sN¿pI. C\n GsXms¡ td©nte¡mtWm ]IÀt¯WvSXv, Ctrl Io AaÀ¯n¸nSn¨v Ah skeIvSv sN¿pI. FÃmw skeIvSv sNbvXv Ignªm km[mcWt]mse¯s¶ Paste sN¿pI. 12 hyXykvX UmäIÄ (hyXykvX Office t{]m{KmapIfn \n¶pamImw) tiJZn cn¨v ¢n]vt_mÀUnen«v Ah Paste sN¿m\pÅ kuIcyhpw Excel Xcp¶pWvSv. Paste Special: hfsc {]tbmP\{]Zamb Nne Pasting kuIcy§Ä Paste Special
http://bluemangoa2z.50webs.com/ (18 of 26)3/20/2009 10:24:45 PM
•••••••••••••• ••••••••••••••••••• •••••••
F¶ UbtemKv t_mIvkv hgn Excel \ÂIp¶p. CXnse Paste hn`mK¯n Cu {]tXyI Hm]vj\pIÄ e`n¡p¶p. Paste All : efnXamb t]ÌnwKv Formulas : sk t^mÀamänwKv FSp¡msX t^mÀape am{Xw Paste sN¿mw. Values : tIm¸n sNbvX t^mÀapebpsS ^ew am {Xw Paste sN¿p¶p. Comments : Ipdn¸pIÄ Hcp skÃn \n¶v asäm¶nte¡v ]IÀ¯p¶p. Validation : \ÂInbn«pÅ {]tXyI aqey\nÀ®b am\ZWvU§Ä ]IÀ¯p¶p. All Except Borders : Umä ]IÀ¯pt¼mÄ ]pXnb td©nsâ t_mÀUdn\v amäap WvSmIp¶nÃ. "Paste Special tIm¸n sN¿m\pÅ Iamân\v am{Xta _m[IamIq. hÀ¡vjo än \n¶pw Cut sNbvX Umä ]IÀ¯m³ CXp]tbmKn¡m\mhnÃ', \oena HmÀ½n ¸n¨p. Paste Special UbtemKv t_mIvknse Operations hn`mKw, Paste sN¿pt¼mÄ \St¯WvS KWnXimkv{X {]{Inbsb´msW¶v \nÀt±in¡m\pÅXmWv. Umä Uneoäv sN¿mw "kp\nXbtà t\ct¯ Data Uneoäv sN¿p¶sX§s\sb¶v tNmZn¨Xv', \oena XpSÀ¶p. "AXv hntijn¨v ]dbms\m¶panÃ. F¦nepw \ap¡v t\m¡mw.' Umä cWvSp hn[¯n Delete sN¿mw. H¶v, skÃnse Umäsb am{Xambn \o¡w sN¿mw. Asæn sk Xs¶bpw Delete sN¿mw. Umä am{Xw \o¡w sN¿m³ ]e hgnIfpWvSv. http://www.geocities.com/bluemangoaz http://bluemango.50webs.com/
* skÃnÂ, FUnäv tamUnÂ, kwJyIÄ \o¡w sN¿pI. (Back space, Delete IoIÄ). * Edit sa\phnse Clear Iamâp]tbmKn¡pI. * skÃn ssdäv ¢n¡v sNbvXv t]m¸v A]v sa\phn Clear contents FSp¡pI. * ^n lm³Un CSXp`mK¯v apIfntem«v {UmKv sNbvXv skÃns\ aqSpI. Ìmäkv _mdn Drag Inside to Clear Cell ktµiw ImWmw. * skÃnse F³{Sn skeIvSv sNbvXv ]pXnb Umä ssS¸v sN¿pI. "CsXms¡ tIma¬ sk³knsâ ImcyamWtÃm!' cXojv \nÊmc`mh¯n ]dªp. "t]ms«, sk F§s \bmWv Delete sN¿p¶Xv?' "AXmtemNn¡m\pÅ tIma¬sk³kv \n\¡nÃ, AtÃ?' \oena Nncn¨p. "Hm, Ahs\mcp ]mhw CUnbätÃ?' kp\nX CSbv¡p Ibdn. "B t]ms«', \oena hne¡n. Umä Uneoäv sN¿p¶Xpt]mse A{X efnXaà skÃpIÄ \o¡w sN¿p¶Xv. ImcWw Hä sktÃm Hcp tdt©m Uneoäv sN¿p¶Xv hÀ¡vjoänsâ LS\sb _m[n¡pw. AXn\m C¸Wn¡v apXncp¶Xn\v ap¼v HcÂ]w Nn´n¡p¶Xv \à XmWv. Hcp sk am {Xambn Uneoäv sN¿p¶Xnepw t`Zw, an¡t¸mgpw, Hcp hcntbm tImftam At¸msS \o¡w sN¿p¶Xmbncn¡pw. ImcWw tS_nfpIfpw sk sd^ d³kpIfpsam¶pw XIcmdnemImXncn¡m³ CXv klmbn¡pw. "AXnsâ kq{X¸Wn Rm³ ImWn¨pXcmw', cXojv ]dªp. "hcnbpsStbm tImf ¯nsâtbm slUnwKn (hcnbpsS \¼À, tImf¯nsâ A£cw) ¢n¡v sN¿pI. C\n Edit sa\phn Delete FSp¡pI. t]mbntÃ? http://bluemangoa2z.50webs.com/ (19 of 26)3/20/2009 10:24:45 PM
•••••••••••••• ••••••••••••••••••• •••••••
http://www.geocities.com/bluemangoaz http://bluemango.50webs.com/
"AsX', \oena hnhcn¨p. "hcntbm tImftam \o¡w sN¿p¶Xnsâsbm¸w, Xmgs¯ hcnIsf apIfnte¡pw heXp`mKs¯ tImf§sf CSXp`mKt¯¡pw Excel sImWvSphcp¶p. H¸w Xs¶ FÃm t^mÀapeIsfbpw delete sNbvXX\pkcn¨v Xncp¯pIbpw sN¿p¶p. cWvSmaXv t^mÀapeIÄ FgpXn XIcmdnemthWvS.' "AsXmcp{K³ ]cn]mSnbmWtÃm!' kp\nX AÛpXw {]ISn¸n¨p. "tIma¬sk³kv thWsaSo, tUm¦o', cXojv Ifnbm¡n. "CUnbänsâ tIma¬sk³kv F\n¡ntÃ', kp\nX ssIaeÀ¯n ImWn¨p. "\nÀ¯v \nÀ¯v', \oena imkn¨p. "C\n Hcp sktÃm, tdt©m Uneoäv sN¿p¶ sX§s \sb¶v t\m¡mw.' hcntbm tImftam Uneoäv sN¿p¶ AtX {]{InbbmWv CXn\pw. ]t£, sNdnsbmcp Ipg¸w. CSbv¡p\ns¶mcp sk t]mIpt¼mÄ _m¡nbpÅ Umäsb F§ s \bmWv kÖoIcnt¡WvSsX¶v Excel-\v ]nSnIn«nÃ. A¡mcyw ]dªpsImSpt¡WvSn hcpw. sktÃm tdt©m skeIvSv sNbvXv Delete Iamâ v \ÂIpI. _m¡n skÃp Isf F§s \ kÖoIcn¡Wsa¶Xn\v Hm]vj\pIÄ \nÀt±in¡p¶ Hcp UbtemKv t_mIvkv e`n¡pw. ChnsSbpw delete sNbvXXpsImWvSpWvSmb {]iv\w XoÀ¡m³ t^mÀapeIÄ kzbw IW¡p Iq«m³ Excel {ian¡pw. F¶m Nne tIkp Ifn ]niIv ImWn¡p¶ #REF skÃn sXfnbpw. ChnsS \mw Xs¶ AXv icnbmt ¡WvSn hcpw. " A s X m c e v ] w {]iv\amWtÃm!' kp\nX ]dªp. "Cu ]Wn Hgnhm ¡m³ {ian¡pIbmWv \ÃXv.' ]ns¶ tN¨o, Umä Uneoäv sN¿msa ¦n C³kÀ«v sN¿m\pw IgnbntÃ?' " I g n b p a t à m ! ' \oena ]dªp. Umä XncpIn¡bämw Uneoäv sN¿p¶ AtX coXn Xs¶bmWv C³kÀ«v sN¿p¶Xn\pw Hcp hcntbm tImftam apgph\pamtbm, Hcp sktÃm, tdt©m am{Xamtbm CSbvs¡hnsSsb ¦nepw C³kÀ«v sN¿mw. UneoänwKn F¶ t]mse¯s¶ Hcp hcntbm tImftam apgph\pambn C³kÀ«v sN¿p¶XmWv Ffp ¸amb GÀ¸mSv. http://www.geocities.com/bluemangoaz http://bluemango.50webs.com/
Npcp-¡-¯nÂ... t^mÀape _mdn Im³kÂ, FâÀ _«WpIÄ l UmäbpsS FIvk hymJym\w hyà ambn a\Ênem¡Ww l ZimwikwJyIÄ \ÂIpt¼mÄ {]tXyI{i² Bhiyw l H¶ntesd tImf§fnepw hcnIfnepw Htc kwJy BhÀ¯n¡m³ Umäm ^n l kzm`mhnI hÀ²\bpWvSmIp¶ (Progression) kwJyIsf Umäm kocokneqsS FâÀ sN¿mw l koco knsâ \nÀ®bw Step value, Stop value F¶nh hgn l BgvNIfpw amk§fpw t]mse XpSÀ¨bmb Imcy§Ä FâÀ sN¿m³ Custom fill l 16 {]hr¯nIÄ hsc Undo sN¿m³ kuIcyw http://bluemangoa2z.50webs.com/ (20 of 26)3/20/2009 10:24:45 PM
•••••••••••••• ••••••••••••••••••• •••••••
Hcp hcntbm tImftam ]qÀ®ambpw C³kÀ«v sN¿m³, AXv skeIvSv sN¿pI. AXn\v Delete- sNbvXXpt]mse¯s¶ hcnbpsS \¼dntem tImf¯nsâ A£ c¯ntem ¢n¡v sN¿pI. hcnbmsW¦n skeIvSv sNbvXXn\v sXm«papIfnepw tImfamsW¦n sXm«v CS¯p`mK¯pw Insertion \S¡p¶p. ]pXnb hcnbpsS (tImf ¯nsâ) NpäpapÅ skÃpIÄ t^mÀamäp sNbvXn«pÅXmsW¦n ]pXnb skÃp IÄ¡pw AtX t^mÀamäv e`n¡pw. ChnsSbpw KWnX¯nsâ ]p\xkÖoIcWw Excel \S¯pw. Hcp sktÃm tdt©m C³kÀ«v sN¿p¶Xnepw, Delete sN¿pt¼mÄ DWvSmb sIm¨p{]iv \apWvSmIpw. sktÃm, tdt©m skeIvSv sN¿pI. Edit sa\phn Insert IamsâSp¡pI. skÃpIÄ het¯mt«m Xmtgmt«m amtäWvSXv F¶v tNmZn¡p¶ UbtemKv t_mIvkv sXfnbpw. Ft¸mgmWv C³kÀj³ Bhiyambn hcp¶Xv? Hcp hÀ¡vjoänsâ Hcp `mK¯v \n¶v thsdmcp `mKt¯t¡m, Hcp hÀ¡vjoän \n¶v thsdmcp hÀ¡vjoäntet¡m, Hcp hÀ¡v_p¡n \n¶v asämcp hÀ¡v _p¡ntet¡m Umä Cut sNbvtXm Copy sNbvtXm amtäWvSn hcpt¼mgmWtÃm Cu Bhiyw hcp¶Xv. CXnsâ thKw Iq«m³ Excel kuIcyapWvSv. skÃpIÄ Cut sN¿pItbm Copy sN¿pItbm sNbvXm Insert sa \phnse Hm]vj³ AX\pkcn¨v Cut cells Asæn Copied cells F¶mbn amdpw. C³kÀ«v sNt¿WvS `mKw skeIvSv sNbvXv Cu Hm]vj³ ¢n¡v sN¿pI. Cu {]hr¯nIÄ¡mbn ssdäv ¢n¡v sN¿pt¼mÄ In«p¶ t]m]v A]v sa\phnse IamâpIfpw D]tbmKn¡mhp¶XmWv. Hcp skÃnse FUnänwKv tPmen IÄ¡mbn tjmÀ«vI«v sa\phn Cut, Copy, Insert, Delete, Clear Contents XpS§nb Hm]vj³kv e`n¡p¶p. "C\n \ap¡v Excel-sâ bYmÀ° iàn ImWmw. C¶Ã, \msf', \oena ]dªp. ]t£, \msf Rm³ DWvSmhnÃ. AXn\m aä¶mÄ. C\n DuWv Ign¨v kpJamsbm ¶pd§mw.' http://www.geocities.com/bluemangoaz http://bluemango.50webs.com/
\oena¡v Hcp \mfs¯ tPmen Ignªt¸mtg¡pw Hch[n e`n¨p. Ip«nIÄ¡pw ImÀ¯nIbv¡pw Ah[n e`n¨nsöv am{XaÃ, B Znhkw ISp¯ ]Wnbmbncp¶p. hn³tUmkvþan apX Excel hsc ]Tn¨ ]mT§f{Xbpw {]mtbmKnIambn Iw]yq« dn Ip«nIÄ ]co£n¨p. ASp¯ Znhkw kÔy¡v ImÀ¯nIbpw \oenabpw Ibdnh¶t¸mÄ kp\n Xbpw cXojpw A £acmbncp¶p. Ft´m IWvSp]nSn¨ `mhambncp¶p CcphcpsSbpw apJ¯v. "Ft´m H¯ a«pWvStÃm!' \oena tNmZn¨p.
http://bluemangoa2z.50webs.com/ (21 of 26)3/20/2009 10:24:45 PM
•••••••••••••• ••••••••••••••••••• •••••••
"Hs¯t¶m?' kp\nXbmWv adp]Sn ]dªXv. "s]s«¶v Ipfn¨v Im¸n IpSn¨v hm. C¶v Excel R§Ä \n§sf ]Tn¸n¡pw.' ImÀ¯nIbpw \oenabpw ]ckv]cw t\m¡n. Xncn¨p h¶t¸mÄ, kv{Io\n Hcp hÀ¡vjoäpambn Ip«nIfncphcpw A£acmbn¯s¶ Ccn¡pIbmWv. "Cu tS_nÄ R§Ä X¿mdm¡nbXmWv,' cXojv ]dªp. "C\nbnXnsâ slUnwKpw tImfw slUnwKpw Hs¡ R§Ä at\mlcam¡m³ t]mIpIbmWv.' Format sa\phn \n¶pah³ Format Cells UbtemKv t_mIvskSp¯p. "skeIvSv sNbvX UmäbpsS Asse³saâ v, Zm, Cu Alignment F¶ Sm_v Xpd¶v AXnepÅ Hm]vj\pIÄ D]tbmKn¨v Nn«s¸Sp¯mw. Horizontal Hm]vj³ IpdpsI
3at\m-l-c-amb IW-¡p-]p-kvXIw http://www.geocities.com/bluemangoaz http://bluemango.50webs.com/
bpÅ hn\ymk¯n\v. CXn Indent \ÂIn skÃn sSIvÌnsâ Øm\w \nÀ® bn¡mw', BËmZt¯msS cXojv ]dªp. "At¸mÄ \n§Ä ]Tn¨p Ignªp', \oena Ahsc {]iwkn¨p. B Vertical- \nÀt±iw \ÂIn, Umäsb tImf¯n ew_am¡mw. tS_nfpIfn A¯cw tImfw slUnwKpIÄ at \mlcam bncn¡pw.' "IgnªnÃ', kp\nX \oenasb XSªp. "Cu Text control Hm]vj³ F {X {]tbmP\IcamsWt ¶m! CXn Wrap Text, Shrink to Fit F¶nh sSIvÌv hn\ymk¯n\v hyXykvX `wKnIÄ \ÂIp¶p.' "Umäsb XncÝo\ ambpw ew_ambpw am{Xa Ã, tImtWmSptIm Wmbpw \ÂImw', \oena ]dªp. "AXn\mWv Cu Orientation Hm]vj³. skÃn\I¯v sSIvÌv http://www.geocities.com/bluemangoaz http://bluemango.50webs.com/
F{X Un{Knbn thWsa ¦nepw CXp]tbmKn¨v Id¡mw.' CXp t]mse skÃp IÄ¡pw sk td©p IÄ¡pw `wKnbpÅ t _ m À U d p I f p w \ÂIm³ Ignbpw. Format Cell UbtemKv t_mIvknse Border Sm_v Xpd¶v B t]sPSp ¡pI. CXnse Line F¶ t_mIvknse Style enÌn \n¶v t_mÀUdn\ v CjvSs¸« ]mtä¬ skeIvSv sN¿pI. AXn\v Xmsg color F¶ drop-down enÌn \n¶v t_mÀUdn\mhiyamb \ndw sXcsªSp¡mw. http://bluemangoa2z.50webs.com/ (22 of 26)3/20/2009 10:24:45 PM
•••••••••••••• ••••••••••••••••••• •••••••
Presets hn`mK¯nse _«WpIfn Outline thtWm, Inside t_mÀUÀ thtWm F¶v Xocpam \n¡pI. t_mÀUÀ H¶pw thsWvS¦n None ¢nIv sN¿pI. "MS hn³tUmkpw, hntijn¨v MS Office-Dw \ÂIp¶ kuµcykwhÀ²t\m] http://www.geocities.com/bluemangoaz http://bluemango.50webs.com/
[nIÄ Word- F¶ t]mse Excel-Dw Hcp tUmIypsaâ v (ChnsSsbmcp Workbook) at \ml cam¡m³ sXsÃm¶pa à klmbn¡p¶Xv', ImÀ¯nI CSs]«p. AXphsc FÃmw IWvSnc n ¡ p I b m b n c p ¶ p ImÀ¯nI. "Hm, \n\¡sænepw apSn Nmbv¨pw sNcn¨pw sI«m\pw kuµcyw Iq«m \patà t\capÅp', \oena Ahsf Ifnbm ¡n. "apSnbnÃm¯hÀ ]ns¶ F§s\ Nmbv¡m³, sNcn¡m³, sI«nshbv¡m³...!' ImÀ¯nIbpw hn«nÃ. "sIm¨phÀ¯am\w \nÀ¯v So¨Àamsc', Kuch¯n kp\nX ]dªp. "kwKXn icnbm. Hmtcm hn`mKw F³{Sn¡pw Hmtcm tjbvUv \ÂIp¶Xv tS_nfn\v Hcp sKä¸v Xs¶bmWv.' skÃpIÄt¡m sk td©pIÄt¡m {]tXyI hÀ®§Ä \ÂImw. CXn\mbn Format Cells UbtemKv t_mIvknse Pattern Sm_v Xpd¡pI. CXn IfÀ t_mIvkn \n¶v Bhiyamb \ndhpw Pattern t_mIvkn \n¶v skÃn\v thWvS ]mtäWpw sXcsª Sp¡mw. Excel-2000, Personal Toolbar Fs¶mcp Hm]vj³ Xcp¶pWvSv. HcmÄ Øncambn D] tbmKn¡p¶ SqÄkv BWv Cu SqÄ_mdn {]Xy£s¸Sp¶Xv. ] pXnsbmcp SqÄ D]tbmKn¡p ¶X\pkcn¨v AXnsâ _«¬ SqÄ_mdn {]Xy £s¸Spw. am {XaÃ, W o r d -s e t ¸ m s e Toolbar-Ifpw sa\pIfpw http://www.geocities.com/ bluemangoaz http://bluemango.50webs.com/
FÃmw Iw]yq«À D]tbmKn¡p¶ BfpsS XmÂ]cya\pkcn¨v Customize sN¿m\pw Excel- kuIcyapWvSv. Tools sa\phnse Customize IamsâSp¯m Hcp UbtemKv t_mIvkv e`n¡p¶p. CXnse Toolbars Sm_v Xpd¶pIn«p¶ t]Pn Toolbars F¶ kvIvtdmÄ t_mIvkn \n¶v BhiyapÅXv sXcsªSp¯v D]tbmKn¡m\mbn \ap¡v hn³tUmbn sImWvSp hcmw. CXpt]mse¯s¶ Hmtcm sa\phnepw Bhiyamb IamâpIfpw Customize sN¿mw. Customize UbtemKv t_mIvknse Commands Xpd¶v In«p¶ t_mIvkp IÄ D] tbmKn¨v s]s«¶pÅ D]tbmK¯n\mbn Iamâ v _«WpIÄ drag-and-drop coXnbn SqÄ_mdn tNÀ¡mw. "BsI¡qSn CsXmcp kpJapÅ GÀ¸mSmWtÃm!' cXojv Iaâ v ]dªp. "AsX.' \oena k½Xn¨p.
http://bluemangoa2z.50webs.com/ (23 of 26)3/20/2009 10:24:45 PM
•••••••••••••• ••••••••••••••••••• •••••••
"Hcp Imcyw', kp\nX ]dªp. "R§Ä DWvSm¡nb sSent^m¬ \¼dpIÄ Hs¡ bptWvSm?' ]cnlmk¨phtbmsS ImÀ¯nI tNmZn¨p. "CtÃ, CÃ', kp\nX k½Xn¨p. "Excel {]hÀ¯\w ]cntim[n¡m\mbn sNbvsXt ¶bpÅp. Umä tN¨nbpsS C³UIvkv _p¡ntebm.' sSent^m¬ C³UIvkv X¿mdm¡nb hÀ¡v_p¡v kp\nX Xpd¶pImWn¨p. t_mÀUdpIfpw \nd§fpw sImWvSv at\mlcam¡n. C³UIvkv IWvSv So¨Àamcncphcpw Ip«nIsf {]iwkn¨p. "sImÅmatÃm', ImÀ¯nI ]dªp. "t]cpIÄ A£camem{Ia¯nÂXs¶. ]mSps] «ncp¶v ssS¸v sNbvXpImWpw?' http://www.geocities.com/bluemangoaz http://bluemango.50webs.com/
"aWvS¯cw ]dbmsXsâ tN¨o', cXojv ]dªp. "Excel- FÃm kq{XhpapWvSv.' "Rm³ ] dbmw,' kp\nX CSs]«p. "tN¨nbpsS C³UIvkv _p¡nsâ XpS¡w apX HSp¡w hsc¯s¶bmWv CXn FâÀ sNbvXXv F¶Xv t\cv. AXpsImWvSv cWvSmas¯bpw aq¶mat¯bpsams¡ A£c§Ä {Ia¯nÂXs¶ hcptam?' "IqSpX _p²nImWn¡WvS', ImÀ¯nIbv¡v CtaPv hosWvSSp¡Wambncp¶p. "AXn\mWv Data sa\phnse Sort UbtemKv t_mIvkv. t_mIvknse Ascending _«¬ skeIvSv sNbvXm A apX Z hscbpÅ {Ia ¯n sSIvÌv kÖoIcn ¡pw Excel. Descending _«¬ skeIvSv sNbvXm Z apX A hscbpw.' "At¸mÄ hnhcap WvSv', Ifnbmbn cXojv ]dªq. "t]mSm DWvS¡®m.' "Cu ImÀ¯nIbpw ]ntÅcpw Hcp t]msebm WtÃm!' \oena ]cmXn ] dªp. "Excel-sâ KpW §Ä C\nbpapWvSv.' Umä F³À sNbvXp Ignªv Insert sa\phnse Function UbtemKv t_mIvkv D]tbmKn¨v Im¡ptejsâ hnhn[ `mK§fnse {]iv \§Ä ]cnlcn¡mw. Financial, Math & Trig. (KWnXhpw {XntImWanXnbpw), Statistical, Logical F¶n§s\ hnhn[ hn`mKw [À½§Ä Function Category-bn DWvSmIpw. CXn \n¶v BhiyapÅXv skeIvSv sNbvXm Function Name t_mIvknÂ, B {]tXyI IymäKdnbpsS {]hr ¯nIÄ sXfnbpw. At¸mÄ e`n¡p¶ UbtemKv t_mIvknepsS {]iv \]cnlmcw £n{]km²yw. FIvkensâ At\zjWw Hcp skÃntem t^mÀapebntem sk sd^d³kntem td©v \ma¯ntem DÅ GsXmcp sSIvÌv `mKhpw At\zjn¨p IsWvS¯mw. IsWvS¯n¡gnªmeXv Hmtcm ¶mtbm, Replace Iamâp]tbmKn¨v HäbSnt¡m amämhp¶XpamWv. Hcp hÀ¡vjoäv apgph\ptam, Hcp hÀ¡v_p¡nse apgph³ joäpIfptam Excels\ s¡mWvSv At\zjn¸n¨v Bhiyamb sSIvÌv `mKw IsWvS¯mw. Hcp hÀ¡v_p¡v apgph³ sXcbm³, BZyw AXnse hÀ¡vjoäpIsf {Kq¸v sN¿Ww. {Kq¸v sN¿m³ BZyhÀ¡vjoäv skeIvSv sNbvXv, Shift Io AaÀ¯n¸nSn¨v Ahkm\ hÀ¡vjoäpw skeIvSv sN¿pI. http://bluemangoa2z.50webs.com/ (24 of 26)3/20/2009 10:24:45 PM
•••••••••••••• ••••••••••••••••••• •••••••
http://www.geocities.com/bluemangoaz http://bluemango.50webs.com/
skÀ¨v \S¯p¶Xv C{]Imcw 1. hÀ¡vjoän apgph³ skÀ¨v \S¯m³ Hscmä sk skeIvSv sN¿pI; Hcp td©v skÀ¨v sN¿m³, B td©v skevIvSv sN¿pI. 2. Edit sa \phn Find FSp¡pI (Ctrl+F IoIfpw D]tbmKn¡mw). Find UbtemKv t_mIvkv e`n¡p¶p 3. Find What F¶ t_mIvkn IsWvS t¯WvS sSIvÌv `mKw ssS¸v sN¿pI. 4. \ncIÄ (Rows) A\pkcn¨pw tImf§Ä A\pkcn¨pw skÀ¨v sN¿m³ Find- Hm]vj \pWvSv. 5. Look in Hm]vj\n F³{Sn \S¯pI. CXn Aev]w {i² \ÃXmWv. t^mÀapeIÄ, aqey§Ä (values), comment F¶nh Look in- \ÂImw. 6. Search-\v IrXy http://www.geocities.com/bluemangoaz http://bluemango.50webs.com/
amb Hcp ^ew (match) Xs¶ thWsa¦n Match Case skeIvSv sN¿pI. ChnsS, \mw At\zjn¡m³ ]dbp¶ sSIvÌnsâ AtX Case (upper/ lower) DÅ am¨pIfm bncn¡pw Find IsWvS¯pI. 7. Hcp skÃnse Umä b{Xbpw IsWvS ¯m³ Find Entire Cells Only sN¡v sN¿pI. 8. At\zjn¡m\mhiy s¸« sSIvÌv IsWvS¯nbmÂ, FIvk AXv sslsseäv sN¿pw. C\n skÃn ¢n¡v sNbvXv, thWsa¦n UmäXncp¯mw. Asæn Replace _«¬ D]tbmKn¨v AXns\ amämw. 9. CtX sSIvÌv C\nbpw FhnsSsb¦nepw DsWvS¦n IsWvS¯m³ Find Next ¢n¡v sN¿pI. 10. At\zjW^ew Xr]vXnIcambn e`n¨m Close. http://www.geocities.com/bluemangoaz http://bluemango.50webs.com/
sSIvÌv amä Find UbtemKv t_mIvkp]tbmKn¨v IsWvS¯nb sSIvÌns\ Replace _«¬ D]tbmKn¨v amämw. CXv Find-eqsSbÃmsXbpw sN¿mw. Edit sa\phnse Replace Iamtâm, Ctrl+H IoItfm D]tbmKn¨pw sSIvÌv amämw. Replace t_mIvkn Find-teXp t] mse Look in Hm]vj³ CÃ. t^mÀapeIfntebpw Øncaqey§fntebpw (Constant values) sSIvÌv `mK§sf IsWvS¯n amäp IbmWv Replace sN¿pI. Hcp IW¡pIq«ensâ ^es¯ IsWvS¯mt\m amämt\m Replace-\v IgnbnÃ. skeIvSv sNbvX HäskÃnse sSIvÌv Replace D]tbmKn¨v amämw. Asæn Replace All _«Wp]tbmKn¨v Hcp hÀ¡vjoänepÅXp apgph³ amämw. amtäWvSXmb sSIvÌv `mKw C\nsbmcnS¯pansöv h¶m Excel A¡mcyw Adnbn¡pw. At¸mÄ Close FSp¯v skÀ¨v Ahkm\n¸n¡mw. FIvskÃnsâ kvs]ÃnwKv amÌÀ thÀUnset¸mse, A£cs¯äpIÄ At\zjn ¨p IWvSp] nSn¡p¶ Hcp Spell Checker FIvkenepw DWvSv. Hcp hmt¡m, Hcp sSIvÌv F³{Sntbm, hÀ¡vjoäv apgph\ptam Bhiym\pkcWw CXv ]cntim[n¡pw. Tools sa\p hgntbm F7 D] tbmKnt¨m Spell
http://bluemangoa2z.50webs.com/ (25 of 26)3/20/2009 10:24:45 PM
•••••••••••••• ••••••••••••••••••• •••••••
Check FSp¡mw. Hscmä sk skeIvSv sNbvXv hÀ¡vjoän apgh³ ]cntim[\ \S¯mw. Hcp td©n am{XamWv ]cntim[\ \St¯WvS sX¦n B td©v am{Xw skeIvSv sN¿pI. Hcp skÃnse am{Xw sSIvÌv F³{Sntbm Hscmä hmt¡m thWsa¦nepw Spell sN¡v sN¿mw. CXn\mbn Edit Mode FSp¡Ww. t^mÀape _mdn ¢n¡v sNbvtXm F2 Io AaÀ¯ntbm Edit tamsUSp¡mw. ]cntim[nt¡WvS hm¡v skeIvSv sNbvXv Tools- Spelling FSp¡pI. FIvkensâ Spelling UbtemKv t_mIvkv Word-tâXn\v kZriamWv. ] cntim [n¡p¶ hm¡v sXfnª t_mIvkn\v Xmsg FIvkensâ \nÀ±njvS]Z§Ä ImWmw. Ignore, Ignore All, Change, Change All, Add, Autocorrect XpS§nb Hm]vj\pIÄ ChnsS bpapWvSv. http://www.geocities.com/bluemangoaz http://bluemango.50webs.com/
hÀ¡vjoäpIÄ \o¡w sN¿pI, tNÀ¡pI Hcp hÀ¡v_p¡n Default Bbn DÅXv aq¶v hÀ¡vjoäpIfmWtÃm! CXn hÀ¡vjoäv C³kÀ«v sNbvXv _p¡nsâ I\wIq«mw. \o¡w sNbvXv I\w Ipd¡mw. hÀ¡v_p¡n \n¶pw joäpIÄ \o¡w sN¿m³ joäpIÄ skeIvSv sN¿pI. BZyw Hcp joäv Sm_n ¢n¡v sNbvXv, Shift Io AaÀ¯n ASp¯ joäv Sm_v ¢ n¡v sN¿pI. Edit sa\phn Delete- Sheet FSp¡pI. Asæn skeIvSv sNbvX Hcp joäv Sm_n ssdäv ¢n¡v sNbvXv In«p¶ sa\phn Delete FSp¡pI. skÃpIÄ \o¡w sN¿pt¼mÄ kw`hn¡p¶Xpt]mse joäpIÄ \o¡w sN¿pt ¼mgpw, ASp¯ joäpIÄ hnShv \nI¯m³ CSt¯m«v \o§p¶p. F¶mÂ, skÃp IÄ Uneoäv sNbvX tijw, CSt¯m«v \o§nhcp¶ skÃpIfpsS hnemkw amdp¶ Xpt]mse joäpIÄ ]p\À\maIcWw sN¿s¸Sp¶nÃ. hÀ¡v_p¡n \n¶v Sheet 2 \o¡w sNbvXm ]ns¶bm _p¡n joäv 2 CÃ. A{XXs¶. hÀ¡v_p¡n ]pXnb joäpIÄ tNÀ¡m³, H¶ntesd joäpIÄ tNÀ¡pIbmsW ¦nÂ, Ah skeIvSv sN¿pI. Insert sa\phn Worksheet skeIvSv sN¿pI. Default Bb Hcp hÀ¡vjoämWnSp¶sX¦n AXn\v hyXymksam¶pw ImWnÃ. AXsæn skeIvSv sNbvX joäv Sm_pIfnsem¶n U_nÄ¢n¡v sNbvXv In«p¶ sa\phn \n¶v Insert FSp¡pI. e`n¡p¶ UbtemKv t_mIvkn GXpXcw hÀ¡vjoämWv CtSWvSXv F¶v Xocpam\n¡mw.
Npcp-¡-¯nÂ... hÀ¡v_p¡v at\mlcam¡m³ Format cells UbtemKv t_mIvkv D]tbmKn¡pI l slUnw KpIÄ s\SpIbpw IpdpsIbpw CSmw l skÃpIÄ¡pw td©pIÄ¡pw t_mÀUdpIÄ \ÂImw l tamSn]nSn¸n¡Â Word-teXn\v kZriw l skÃpIÄ¡v \ndw \ÂImw l ImtWWvSXv IsWvS¯m³ FIvken Find kuIcyw l hÀ¡v_p¡n apgph³ Search \S¯n thWvSXv IWvSp]nSn¡mw l Find sNbvX sSIvÌns\ amän asäm¶hnsS sh¡m³ Replace _«¬ l FIvken\papWvSv kvs]ÃnwKv ]cntim[I³
http://bluemangoa2z.50webs.com/ (26 of 26)3/20/2009 10:24:45 PM
Related Documents
Computer 4
June 2020 9
Chapter 4 Computer Simulation
May 2020 6
Chapter 4 Computer Simulation
May 2020 8
Computer Viruses Form 4
April 2020 12
Akshay's Computer Project (4)
April 2020 5