Microsoft Excel

  • Uploaded by: myathandaroo
  • 0
  • 0
  • November 2019
  • PDF

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 Microsoft Excel as PDF for free.

More details

  • Words: 25,489
  • Pages: 170
1

Microsoft Excel 2002

Microsoft Excel 2002 Chapter (1) Introduction 1/ Microsoft Excel 2002 onf Microsoft Office XP tkyfpkwGif wpfcktyg t0ifjzpfNyD;? pm&if;Z,m;rsm;a&;qJGjcif;? Data rsm;udk Z,m;wGifjznfhpGufí Chart *&yfykH trsKd;rsKd;zefwD;jcif;? Database management aqmif½u G Ef ikd jf cif;ESihf ocsmF qdik &f mykpmä rsm; wGufcsufEdkifjcif;wdkYudk vG,fulvQifjrefpGm toHk;jyKEdkifygonf/ Microsoft Excel 2002 onf Windows Operating System udk tajccHonfh application wpfcjk zpfNy;D ? pm&if; Z,m;ESi*hf &yfyrkH sm;udk vG,u f v l sijf refpmG vkyu f ikd af qmif½u G Ef ikd af omaMumifh Electronic Spreadsheet application software [kvnf; ac:qdkEdkif ygonf/ Starting Microsoft Excel 2002 ( Microsoft Excel 2002 tm; pwiftoHk;jyKjcif; ) 2/ uGeyf sLwmudk rD;zGiv hf u kd yf gu Windows Operating System udk Memory ay:odYk wifNyD;aemuf Ready tqifo h Ykd a&muf&ydS gonf/ xdt k cg Task bar ay:&Sd Start button udk Click vkyí f ay:vmaom Start menu ay:&Sd Programs udk Point vkyyf g/ ay:vm aom Sub menu ay:&Sd Microsoft Excel udk Click vkyyf g/ Microsoft Excel pmwef; ESifh Splash screen wpfckay:vmrnf/yHk(1-1) wpfcsdefwnf;rSmyif Excel y½dk*&rfrsm;udk Memory ay:odkY wifay;NyD;aemuf Microsoft Excel window yGifhvmNyD;? Title bar wGif Microsoft Excel- Book1 trnfjzihf Workbook window ay:vmrnf/ yH(k 1-2)

yHk(1-1)

uGefysLwmvufpJG

2 Excel windows Cell reference area

0

Workbook windows

Selector

yHk ( 1-2 ) Microsoft Excel Window Microsoft Excel 2002 wGif Workbook Window ESifhtwl Task pane wpfck ,SOfwGJay:vmonfudk awGUEdkifygonf/ b,fbuf Window udk Workbook Window [kac:NyD;? nmbuf½Sd Window tao;udk Task pane window [kac:ygonf/ vuf½Sd taetxm;onf tvkyfvkyf&ef Ready tqihfodkY a&mufaernfjzpfygonf/ Task pane udk rvdt k yfygu Close button udk Click vkyí f ydwx f m;Edik yf gonf/

3/

Microsoft Excel Window wGif Title Bar ? Menu Bar ? Standard Tool Bar ? Formatting Tool bar ? Formula Bar ESifh Status Bar wdy Yk g0ifNy;D ? Workbook Window wGif Column Heading? Row Heading? Vertical Scroll Bar ? Horizontal Scroll Bar ? Tab Scrolling Button ESifh Sheet 1 ? Sheet 2 ? Sheet 3 wdkYudkawGU&ygrnf/ Microsoft Excel Window \ Title Bar wGif Microsoft Excel-Book 1 [k azmfjyaeygrnf/ Book 1 onf Workbook wpfckjzpfNyD;? Sheet 1 onf Active Sheet jzpfaeonfudk

awGU&ygrnf/

3

Microsoft Excel 2002

Understand the Workbooks ( Workbooks udk em;vnfjcif; ) 4/ Workbook onf Worksheets rsm;jzifh zJGUpnf;xm;aom Excel zdkifwpfck jzpfygonf/ Workbook wpfcw k iG f yHrk eS t f m;jzifh Worksheet (3) ck &Syd gonf/ vdt k yfygu Worksheets rsm;udk atmufygtwdkif; xyfrHwdk;ay;Edkifygonf(u) Tools menu udk Click vkyyf gu Pull down menu wpfcu k svmygrnf/ (c ) Options command udk Click vkyyf gu Options dialog box ay:

vmrnf/ (* )

General tab udk Click vkyy f g/ Sheets in new workbook: rS Sheet

ta&twGufudk (1)ck rS (255)ck txd owfrSwfay;Edkifygonf/ NyD;vQif OK udk Click vkyy f g/ 5/ Excel Worksheet wpfckwGif Column rsm;udk A, B, C, ..., Z, AA, AB, ..., IV txd az:jyNyD;? Columns pkpak ygif;(256 )ck&ydS gonf/ Row rsm;udk 1, 2, 3, ... , 65536 txd az:jyNyD; Rows pkpkaygif; (65536)ck&Sdygonf/ pkpkaygif; Cell ta&twGuf (17) oef;eD;yg; toH;k jyKEikd yf gonf/ Cell qdo k nfrmS Column wpfcEk iS hf Row wpfck jzwfaeonfh qHck suaf e&m jzpfygonf/ Oyrm- Cell E10 [kqdkvQif Column E ESihf Row 10 wdkYqHkaom Cell wpfcjk zpfygonf/ Cell wpfckudk Select vkyv f ykd gu xdk Cell onf av;axmifhuGuf rsOf;txl jzpfoGm;ygrnf/ 4if;av;axmifhuGufrsOf;txludk Selector [kac:ygonf/ Selector &Sdaeaom cell udk Active cell [kac:ygonf/ yHk(1-2)wGif Active cell onf E10 jzpfygonf/ xdk Cell \ Position udk Formula bar \b,fbuftpGef&Sd Cellreference area wGifawGUEdkifygonf/ Selecting Cells in a Worksheet ( Worksheet twGif;&Sd Cell rsm;a½G;cs,fjcif; ) 6/ Worksheet wpfck&Sd Data rsm;udk Format (ul;,ljcif;? a½TUajymif;jcif;? zsufjcif;? ..ponf) jyKvkyfEdkif&ef Cell rsm;udk atmufygenf;vrf;wpfckckjzifh a½G;cs,fEdkifygonf(u) Cell wpfckcsif;udk Select vkyfrnfqdkvQif xdk Cell udk Click vkyyf g/ (c ) wpfqufwnf;jzpfaom Adjacent cell (odkYr[kwf) Range wpfckudk Select vkyr f nfqykd gu Upper-left cell rS Lower right cell txd Drag down vkyy f g/ Cell range onf Bu;D aeygu First cell udk Select vkyfNyD;? Shift Key udkESdyfí Last cell &S&d modYk Scroll bar jzifhoGm;NyD; Last cell udk Click vkyy f gu tvd&k &Sd m Cell range tm;vHk;udk Select

jyKvyk o f mG ;ygrnf/

uGefysLwmvufpJG (*)

(C) (i)

4

Row (odkYr[kwf) Column wpfckvHk;udk Select vkyfvdkygu Row (odkYr[kwf) Column wdkY\ Header udk Click vkyyf g/ tvd&k o dS nfh Row (odrYk [kw)f Column wdkYudk Select vkyv f ykd gu Select vkyv f akd om Row (odrYk [kw)f Column udk OD;pGm Select vkyyf g/ Ny;D vQif Ctrl key udEk ydS í f tvdk&dSonfh Row (odkYr[kwf) Column tm; Click (odkYr[kwf) Drag vkyyf g/ tvd&k adS omRow(odrYk [kw)f Column rsm;udk Select jzpfomG ;rnf/ Worksheet wpfckvHk;udk Select vkyfvdkygu Row Heading A \ b,fbufuGufvyftvGwf wpfckjzpfonfh Select all button udk Click vkyyf g/ xdt k cg Worksheet wpfckvHk;udk Select jzpfomG ;ygrnf/ Workbook xJ&Sd Sheets tm;vHk;udk Select vkyfvdkygu atmufajc&dS Sheet1 udk Click vkyfNyD;? Shift key udkESdyfvQuf aemufqHk; Sheet udk Click vkyy f g/

Moving Around in a Worksheet 7/ Excel Worksheet twGif; ae&mtoD;oD;odkY a&GUEdkif&ef atmufygtwdkif;

aqmif½GufEdkifygonf(u) Scroll bar ud k Click vkyfjcif;jzifh Worksheet \ Screen udk txuf?atmuf?b,f?nm a½GUEdkifygonf/ (c) Scroll button udk Drag vkyjf cif;jzifv h nf; Screen udk txuf?atmuf? b,f?nm a½GUEdkifygonf/ (*) Scroll arrow udk Click vkyfjcif;jzifh Column wpfck (odkYr[kwf) Row wpfckudk a½GUay;Edkifygonf/ (C) Worksheet \atmufajcb,fbufjcrf;rS tab rsm;ay:odkY Right Click vkyfjcif;jzifh tvdk&dSonfh Worksheet udk a&G;cs,fEdkifygonf/ Moving Around in a Worksheet with the Keyboard 8/ Excel Worksheet twGif;wGif Keyboard udk toHk;jyKí oGm;vdkaomae&modkY a½GUEdik yf gonf/ Keyboard toHk;jyKyHkrSm atmufygtwdkif;jzpfygonf(u) Arrow key ( Up, Down, Left, Right ) rsm;jzifh Cell wpfck\ txuf?

(c)

atmuf? b,f?nmodkY a½GUEdkifygonf/ PageUp, PageDown Key wdkYjzifh Screen wpfckpm txuf? atmuf a½GUMunfhEdkifygonf/

5 (* )

Microsoft Excel 2002

Home key udk toH;k jyKí Row wpfc\ k b,fbuftpGeq f ;kH odYk a½GUMunfh

Edik yf gonf/ (C) (i ) (p ) (q) (Z) (ps)

Ctrl + Home key udk ESdyfjcif;jzifh Worksheet \tay:qHk; b,fbuf axmifh Cell A1 udk a&mufygrnf/ Ctrl + End key udk ESdyfjcif;jzifh Worksheet wGif Data &Sdaomtydkif;\

atmufqHk; nmbufaxmifhudk a&mufygrnf/ Ctrl + Right arrow key udk ESdyfjcif;jzifh Worksheet \ aemufqHk; Column odYk a&mufygrnf/ Ctrl + Left arrow key udk ESy d jf cif;jzifh Worksheet \ a&SUqHk; Column odYk a&mufygrnf/ Ctrl + Up arrow key udk ESdyfjcif;jzifh Worksheet \f yxrqHk; Row odYk a&mufygrnf/ Ctrl + Down arrow key udk ESdyfjcif;jzifh Worksheet \ aemufqHk; Row odYk a&mufygrnf/

Insert or Delete Worksheets ( Worksheets topfwdk;jcif; (odkYr[kwf) zsufjcif;) 9/ Workbook topfwpfcw k iG f yHrk eS t f m;jzifh Worksheet (3)ckyg&Syd gonf/ vkyif ef; vdt k yfcsuaf y:rlwnfí Worksheet rsm;udk wd;k jcif;? avQmjh cif;(zsujf cif;) jyKvyk Ef ikd yf gonf/ Worksheet wpfckudk xyfwdk;vdkvQif atmufygtwdkif; aqmif½GufEdkifygonf(u) xyfwdk;vdkaom Worksheet udk a½G;cs,yf g/ Insert menu udk Click vkyyf gu Pull down menu usvmrnf/ (c) usvmaom Pull down menu rS Worksheet udk Click vkyfyg/ Worksheet topfwpfck xyfwdk;vmonfudk awGY&rnf/ (* ) wpfenf;tm;jzifh Tab Scrolling Button \nmzuf&dS Sheet wpfcak y:odYk Right Click vkyy f gu Context menu ay:vmrnf/ 4if; menu &dS Insert udk Click vkyy f gu Insert dialog box ay:vmrnf/ 4if;rS Worksheet udak ½G;Ny;D ? OK udk Click vkyy f gu Worksheet topfwpfck

xyfw;kd vmygrnf/ 10/ tu,fí rvdktyfaom Worksheet rsm;udk zsufvdkygu atmufygtwdkif; aqmif½GufEdkifygonf-

uGefysLwmvufpJG (u) (c) ( *)

6

zsufvdkaom Worksheet udk a½G;cs,yf g/ Edit menu udk Click vkyyf gu Pull down menu usvmrnf/ usvmaom Pull down menu rS Delete sheet udk Click vkyyf g/ xdktcg rvdktyfaom Worksheet udk zsuo f mG ;ygrnf/ wpfenf;tm;jzifh Tab Scrolling Button \nmzuf&dS zsuv f akd om Sheet wpfckay:odkY Right Click vkyfyg/ ay:vmaom Context menu rS Delete udk Click vkyy f g/ xdt k cg rvdt k yfaom Worksheet udk zsuo f mG ; ygrnf/

Renaming Worksheets ( Worksheets tm; trnfajymif;jcif; ) 11/ Microsoft Excel wGif Worksheets rsm;udk yHkrSeftm;jzifh Sheet1, Sheet2, Sheet3 ponfjzifh az:jyay;xm;ygonf/ Sheet1, Sheet2, Sheet3 tpm; tjcm; ESpfouf&mtrnfrsm;udk ajymif;vJay;Edkifygonf/ Sheet wpfckudk trnfajymif;vdkvQif

atmufygtwdkif;aqmif½GufEdkifygonf(u) trnfajymif;vdkaom Sheet udk Select vkyyf g/ (c) xdk Sheet ay:wGif Right click vkyfygu Context menu wpfck ay:vmrnf/ 4if; Context menu rS Rename udk Click vkyyf g/ (*) xdt k cg Sheet ay:wGif Cursor ay:vmNyD;? trnfa[mif;udk zsufí ay;vdak omtrnfukd ½du k x f nfyh g/ Ny;D vQifEnter key udEk ydS yf gu trnfopf ajymif;oGm;ygrnf/ Move Sheets ( Worksheets rsm;udk a½GUajymif;jcif;) 12/ Microsoft Excel wGif Worksheets rsm;udk atmufygtwdkif; wpfckESifhwpfck

ae&mjcif; zvS,fEdkifygonf(u) ae&ma½GUvdkaom Sheet udk Select vkyfNyD;? Mouse jzifh Drag vkyyf g/ xdt k cg Mouse pointer ay:wGif pm½Guyf kH Icon wpfck wJaG vmif; ygvm rnf/ yH(k 1-3)

7

Microsoft Excel 2002

yHk (1-3)

(c )

xdk Icon udk rdrdxm;vdkaomae&modkY Drop vkyyf g/ Worksheet ae&m ajymif;oGm;onfudk awGY&ygrnf/

Copy Sheets ( Worksheets rsm;udk ul;,ljcif;) 13/ Worksheet udk atmufygtwdkif; Copy jyKvkyfEdkifygonf(u) ul;,lvdkaom Worksheet udk Select vkyfyg/ 4if;ay:wGif Right click vkyyf gu Context menu ay:vmrnf/yHk(1-4)

yHk(1-4)

uGefysLwmvufpJG (c)

(*)

(C)

8

ay:vmaom Context menu rS Move or Copy udk Click vkyyf g/ (odkYr[kwf) Edit menu rS Move or Copy udk Click vkyyf g/ Move or Copy dialog box ay:vmrnf/ 4if; Dialog box rS To book: acgif;pOfatmufrS List box wGif List f g/ xdt k cg yH(k 1-4)wGiaf zmfjy box drop down arrow tm; Click vkyy xm;onfhtwdkif; (new book) [k awGU&Sd&ygrnf/ 4if; (new book) udk a½G;yg/ Create a copy check box udk Check mark rvkyyf gu Move jzpfomG ;ygrnf/ Copy ul;&ef jzpfaomaMumifh Dialog box ay:&Sd Create a copy check box udk Check vkyfxm;&rnf/ xdkYaemuf OK udk Click vkyfyg/ (new book) udk a½G;cs,fjcif;aMumifh Workbook topf wpfct k jzpf ul;oGm;ygrnf/ To book: acgif;pOfatmufwi G f a½G;cs,x f m;aom zdik t f m; Before sheet: atmuf&dS rdrad ½GUvdak om Sheet (odrYk [kw)f (move to end) udk a½G;cs,yf g/ NyD;vQif OK udk Click vkyfygu a½G;cs,fxm;aom Sheet \ a&SUodkY a½GUoGm;ygrnf/ (odrYk [kw)f (move to end) udak ½G;cJyh gu aemufq;kH Sheet ae&modkY a½GUoGm;ygrnf/ yHk(1-5)

yHk( 1-5 )

9

Microsoft Excel 2002

Chapter (2) Working With Workbook Files Creating a New Workbook ( Workbook topfwnfaqmufjcif; ) 1/ Microsoft Excel onf Software pzGiv hf Qizf iG chf si;f Microsoft-Excel Book1 trnfjzifh Workbook wpfck toifhjyifqifay;xm;ygonf/Microsoft Excel wGif zdkifwpfzdkif (odkYr[kwf) Workbook topfwpfck wnfaqmufrnfqdkygu atmufyg

tpDtpOftwdkif; aqmif½GufEdkifygonf(u) File menu udk Click vkyyf g/ Pull down menu wpfcu k svmrnf/ (c) New command udk Click vkyfyg/ New workbook task pane ay:vmrnf/ 4if;rS New atmuf&Sd Blank workbook udk Click vkyyf g/ Microsoft Excel-Book2 trnfjzifh New workbook wpfck ay:vm ygrnf/ (odrYk [kw)f Standard tools bar ay:&Sd New button udk Click vkyyf g/ Saving a New Workbook ( Workbook topfudk odrf;qnf;jcif; ) 2/ Microsoft Excel wGif zdkifwpfzdkif (odkYr[kwf) Workbook topfwpfck wnfaqmufNyD;ygu Hard disk xJodkY odrf;qnf;vdkvQif atmufygtwdkif; aqmif½Guf

Edik yf gonf(u) (c) (*)

(C)

File menu udk Click vkyy f g/ Pull down menu wpfcu k svmrnf/ Save command udk Click vkyy f g/ Save As dialog box ay:vmrnf/ Dialog box &Sd File name: text box wGif zdkiftrnfay;&eftwGuf trnfwpfckudk ½dkufxnfhyg/ odrf;vdkaom Folder ae&mudk Save in: drop down list box wGif a½G;cs,fyg/ Ny;D ygu Save button udk Click vkyyf g/ xdt k cg Excel onf ay;xm;aom trnfjzifh Excel(*.xls) file wpfckudk odrf;qnf;ay;ygrnf/

uGefysLwmvufpJG

10

Saving a File to a Different File Name ( ½SdNyD; zdkifwpfckudk trnfajymif;í odrf;qnf;jcif; ) 3/ Microsoft Excel wGif Save vkyNf y;D om; zdi k w f pfzikd u f t kd jcm;trnfopfwpfcjk zifh

ajymif;vJodrf;qnf;vdkygu atmufygtpDtpOftwdkif; aqmif½GufEdkifygonf(u) rlvzdik af [mif;udk zGix hf m;yg/ (c) File menu rS Save As command udk Click vkyyf g/ Save As dialog box ay:vmrnf/ yHk(2-1) ( * ) Dialog box &S d File name text box wGif rlvzdkifa[mif;trnf ay:aernf/ xdk File a[mif;udk zsuí f trnfopf wpfcu k kd ½du k x f nfyh g/ odrf;vdkaom Folder udkvnf; Save in drop down list box wGif a½G;cs,fyg/ (C) NyD;ygu Save button udk Click vkyfyg/ xdktcg rlvzdkifa[mif;ESifh wlnDaom trnfopfESifhzdkifwpfck yGm;vmonfudkawGY&ygrnf/ Closing Workbook ( Workbook udk ydwfjcif; ) 4/ Microsoft Excel wGif Save vkyfNyD;onfh Workbook wpfck (odkYr[kwf) zdkif

wpfzdkifudk ydwfvdkygu atmufygtpDtpOftwdkif; aqmif½GufEdkifygonf(u) File menu udk Click vkyyf g/ Pull down menu wpfcu k svmygrnf/ (c) Close command udk Click vkyyf g/ (odrYk [kw)f Work book window &Sd Close button udk Click vkyyf g/ Opening an Existing Workbook ( ½SdNyD; File wpfckudk zGifhjcif; ) 5/ Microsoft Excel wGif ½SNd y;D File wpfcu k kd zGiv hf ykd gu atmufygtwdik ;f aqmif½u G f

Edik yf gonf(u) (c) (*)

File menu udk Click vkyy f g/ Pull down menu wpfcu k svmrnf/ Open command udk Click vkyy f g/ (odrYk [kw)f Standard tools bar ay:rS Open button udk Click vkyyf g/ Open dialog box ay:vmrnf/

yHk(2-2) ay:vmaom Open dialog box wGif zGiv hf akd omzdik u f kd a½G;cs,í f Open button udk Click vkyfyg/ xdktcg zGifhvdkaomzdkif yGifhvmonfudk awGU&Sd& ygrnf/

11

yHk(2-1)

yHk(2-2)

Microsoft Excel 2002

uGefysLwmvufpJG

12

Chapter (3) Entering And Editing Data

1/

Microsoft Excel wGif Text? Number? Date & Time ESifh Formula & d gonf/ Cell rsm;twGi;f wGif txufyg Data rsm;udk Function [laom Data type rsm;&Sy Excel 2002 rS vsifvsifjrefjref xnfhoGif;í&ap&ef aqmif½Gufay;xm;ygonf/ Cell rsm; twGif;ü Data rsm;udk½dkufxnfhNyD;aemuf Enter key ESyd yf g/ (odrYk [kw)f Arrow key udEk ydS yf g/ (odrYk [kw)f Tab key udEk ydS yf g/ (odrYk [kw)f Work area xJ&Sd Cell wpfae&m&mudk Mouse jzifh Click vkyy f g/ txufygtwdik ;f raqmif½u G cf v hJ Qif Data rsm;udk Format

vkyí f &rnfr[kwyf g/ Entering Text ( Text rsm;xnfhoGif;jcif; ) 2/ Microsoft Excel wGif Text rsm;udk ½du k x f nfo h nft h cg yHrk eS t f m;jzifh Left align jzpfonfukd awGU&ygrnf/ Text qdo k nfrmS tu©&mrsm;omru tu©&mESi*hf Pef;wJG rsm;vnf; yg0ifygonf/ Text rsm;udk Cell twGif; atmufygtwdkif; ½dkufxnfhEdkifygonf(u) ½dkufxnfhvdkaom Cell udk a½G;yg/ (c) Text udk ½dkufxnfhyg/ ½dkufxnfhvdkufaom Text onf Formula bar wGif

(*)

vnf; ay:aeygrnf/ 4if;aemuf Formula bar ½Sd Enter button udk Click vkyyf g/ (odrYk [kw)f Enter key ESy d yf g/

Entering Number ( Number rsm;xnfhoGif;jcif; ) 3/ Microsoft Excel wGif Number rsm;udk ½du k x f nfo h nft h cg yHrk eS t f m;jzifh Right align jzpfonfudk awGU&ygrnf/ Number wGif 0, 1, 2, ..., 9 ESifh Special character (+, -, ( ), /, $, % ) ponfwYkd yg0ifygonf/ Number rsm;udk Cell twGif; atmufygtwdkif;

½dkufxnfhEdkifygonf(u) ½dkufxnfhvdkaom Cell udk a½G;yg/ ( c ) Number udk ½du k x f nfyh g/ Number wpfcak ½SUrSm Plus sign (+) xnfv h Qif xl;jcm;rI&rdS nfr[kwyf g/ Period ( . ) wpfckudk xnfhrnfqdkygu 'ór ude;f *Pef;tjzpf owfrw S yf grnf/

13 (* ) (C)

(i )

(p )

Microsoft Excel 2002

Negative number rsm;ud½ k u kd x f nfrh nfqykd gu xd*k Pef;a&SUwGif Minus sign (-) (odkYr[kwf) parentheses ( ) uGif;cwfay;Edkifygonf/ tydkif;*Pef; Fraction udk ½dkufxnfhrnfqdkygu &ufpJGESifhrrSm;ap&ef 0 (zero) udk spacebar wpfcsuc fí H ½du k af y;&ygonf/ Oyrm- 1/2 ½du k v f ykd gu 0 1/2 [k½dkufay;&ygrnf/ Number type data entry onf Cell width xufausmaf eygu number ay:&rnfhtpm; ####### oauFwrsm;ay:aeygrnf/ þodjYk zpfaeygu Column width udk xyfrHcsJUay;jcif;jzifh *Pef;rsm; ay:vmygrnf/ *Pef;rsm;udk Scientific jzifhaz:jyvdkygu az:jyvdkaom Cell range udk Select vkyyf g/ Ny;D aemuf Format menu rS Cells command udk Click vkyy f g/ Format cells dialog box ay:vmrnf/yH(k 3-1) Number tab udk Click vkyfí Category list rS Scientific uda k ½G;yg/ Decimal place box wGif xm;vdkaom Decimal ta&twGufudk a½G;í OK udk Click vkyy f g/

yHk(3-1)

uGefysLwmvufpJG (q)

14

Trailing zero rsm;ygaom *Pef;rsm;udk Cell wGif xnfhvdkvQif Tool menu rS Options command udk Click vkyfNyD; Options dialog box ay:vmrnf/yHk(3-2) 4if;rS Edit tab udka½G;yg/ 4if;rS Fixed decimal f g/ Place box rSm xm;½Sv d akd om*Pef;ta& check box udk Check vkyy twGufudk xnfhoGif;yg/ NyD;aemuff OK udk Click vkyyf g/ *Pef;wpfcu k kd ½dkufxnfhvdkufygu ,if;*Pef;tygt0if Place box wGif xm;cJhaom

*Pef;ta&twGuftwdkif; 'oraemufwGif oknrsm;udk xnfhoGif;ay; ygrnf/ yHk(3-2)

(Z)

Excel wGif*Pef;rsm;udk Thousand separator jyKvkyfay;Edkifygonf/ jyKvkyfyHkrSm yxrOD;qHk; Cell (odkYr[kwf) Cell range udk Select vkyyf g/ Format menu rS Cells udk Click vkyy f g/ Format cells dialog box ay:vmrnf/ Number tab udak ½G;yg/ Category: atmuf&Sd Number udk Click vkyy f g/ 4if;rS Use 1000 Seperator( , ) check box udk check vkyyf g/ Ny;D aemuf OK udk Click vkyyf g/ 3456000 tpm; 3,456,000

[k ay:vmonfudk awGU&ygrnf/

15

Microsoft Excel 2002

Entering Dates & Times ( &ufpJGESifh tcsdefrsm;xnfhoGif;jcif; ) 4/ Microsoft Excel wGif Dates & Times format trsK;d rsK;d &Sy d gonf/ Dates & Times ½dkufxnfhonfhtcg yHkrSeftm;jzifh Right align jzpfonfudk awGU&ygrnf/ Dates & Times format rsm;rSm atmufygtwdi k ;f jzpfygonfMM/DD/YYYY 9/19/2002 or 09/19/2002 MM/DD

9/19

MM/DD/YY

9/19/02

MM/DD/YY

09/19/02

DD-MMM

19-Sep

DD-MMM-YY

19-Sep-02

MMM-YY

Sep-02

M-YY

September-02

MM/DD/YY HH:MM AM/PM

9/19/02 4:20 AM

MM/DD/YY HH:MM

9/19/02 16:50

M

S

M-YY

S-02

DD-MMM-YYYY

19-Sep-2002

Entering Formulas ( Formulas rsm;xnfhoGif;jcif; ) 5/ Microsoft Excel wGif Formulas qdo k nfrmS r&Srd jzpf ta&;ygaom Tool wpfck jzpfygonf/ Formula udk Entry jyKvyk &f mwGif '' = '' Equal sign ESiphf wif&ygrnf/Formula udk atmufygtwdkif; Entry jyKvkyfEdkifygonf(u) Formula jzifhwGufcsuftajzxkwfvdkaom Cell udk Select vkyyf g/ (c ) ' = ' equal sign ½du k x f nfyh g/ ( * ) Formula ½du k x f nfyh g/ Formula onf Formula bar wGifay:aernf/ (C) NyD;aemuf Enter key udkESdyfjcif;jzifh tajz&vmygvdrfhrnf/ Oyrm = (A1+B1) * C1

uGefysLwmvufpJG

16

Entering Functions ( Functions rsm;xnfhoGif;jcif; ) 6/ Microsoft Excel wGif Functions rsm;udk atmufygtwdkif; Entry jyKvkyfEdkif

ygonf(u) (c) (*) (C)

Function jzifh wGufcsuftajzxkwfvdkaom Cell udk Select vkyy f g/ ' = ' equal sign ½du k x f nfyh g/ Function name ½du k x f nfyh g/ Function onf Formula bar wGif ay: aernf/ Oyrm- = SUM ( A1:D1) yHk(3-3) NyD;vQif Enter key udk ESdyfjcif;jzifh tajz&vmygvdrfhrnf/

yHk(3-3)

Entering Functions by Menu ( Menu jzifh Functions rsm;tm;xnfhoGif;jcif; ) 7/ Microsoft Excel wGif Manual jzifh Function rsm;xnfo h iG ;f Edik o f uJo h Ykd Menu udk toHk;jyKívnf; xnfhoGif;Edkifygonf/ Menu toH;k jyKí atmufygtwdik ;f jyifqifEikd f

ygonf(u) (c)

Function toHk;jyKrnfh Cell udk Select vkyy f g/ Insert menu rS Function command udk Click vkyfyg/ Insert function dialog box ay:vmrnf/ Cell twGif;wGifvnf; " = " sign

a&muf&v dS mygrnf/yH(k 3-4) (*)

Search for a function list box wGif toHk;jyKvdkaom Function name udk ½du k x f nfí h Go button udk Click vkyyf g/ xdt k cg Select a function list box wGif oufqdkif&m Function name udk a&G;cs,fay;ygrnf/ xdkYaemuf OK udk Click vkyyf g/ xdt k cg Cell twGif; Function name

17

Microsoft Excel 2002

a&muf&o dS mG ;ygrnf/ wpfNyKd iw f nf;rSm Function Arguments dialog box ay:vmygrnf/yHk(3-5)

yHHk(3-4)

yHk(3-5)

18

uGefysLwmvufpJG (C)

Function Arguments &Sd ñTeMf um;csur f sm;twdik ;f qufvufvyk af qmif yg/ Ny;D aemuf OK button udk Click vkyyf g/ Entering a Series with Autofill ( Data rsm;tm; tvdktavsmufjznfhoGif;jcif; ) 8/ Microsoft Excel wGif wpfckESifhwpfckxdpyfaeaom Cell rsm;wGif Data rsm;udk Data series trsKd;rsKd;jzifh Fill vkyE f ikd yf gonf/f vkyef nf;vky[ f efuv GJ rGJ ½I adS omfvnf; Data

rsm;udk tvdktavsmufjznfhoGif;Edkifaom enf;vrf;rsm;rSm atmufygtwdkif;jzpfygonf(u) Series vkyv f o kd nfh Data wpfcu k kd ½du k x f nfyh g/ Ny;D aemuf Cell udk Select vkyyf g/ Selector \ nmzufaxmifhatmuf&Sd Fill handle udk Mouse kd yf g/ Pointer shape (+) oauFwajymif;oGm;ygvdrrhf nf/ pointer wifvu yH(k 3-6) xdt k cg Mouse jzifh Fill vkyfvdkaom Direction twdkif; Drag vkyyf g/ Fill vkyfvdkaom Cell range &&SdvQif Mouse button udk vTwf vdu k yf g/ Cell range wpfckvHk; Copy yGm;ovdk Data rsm;0ifomG ;ygrnf/

yHk(3-6)

+ (c)

aemufwpfenf;rSm Cell wpfckwGif&Sdaom Number wpfckudk tpDtpOf twdkif; wefzdk;rsm;udk twdk;tavQmhvkyfEdkifygonf/ Number rsm;udk Increment, Decrement jyKvk y f & mwG i f Excel default twd k i f ; aqmif½GufEdkifouJhodkY toHk;jyKol\ pdwfBudKuf Step value rsm;udkvnf; toH;k jyKEikd yf gonf/ Number wpfckudk Cell wpfct k wGi;f ½du k x f nfyh g/ xdk Cell udk Select vkyyf g/ Ctrl key ESdyfxm;NyD; Fill handle udk Drag vkyyf g/ Number rsm;onf wpfckpDwdk;oGm;onfudkawGU&ygrnf/ yHk(3-7)

19

yHk(3-7)

(* )

Microsoft Excel 2002

++

tu,fí Cell A2 rSm 5, Cell A3 rSm 10 udk½dkufNyD;? Cell ESpfckpvHk;udk Select vkyfí Fill handle udk Drag vkyy f g/ Incrementing step onf 5 jzpfoGm;aomaMumifh yHk (3-8) rSmjyxm;onfhtwdkif; 5,10, 15, 20,... tp&Sdonfh Data series udk awGU&ygrnf/

yHk(3-8)

Entering the same data over and over with auto complete ( wlnDaom Data rsm;tm; tvdktavsmufjznfhoGif;jcif; ) 9/ Microsoft Excel wGif wlnDaom Text data rsm;udk xyfrHxnfhoGif;ygu Data

\ yxrpmvHk;udk ½dkufxnfhjcif;jzifh usef&SdaompmvHk;rsm; ½dkufxnfh&efrvdkbJ tvdk tavsmuf ay:vmonfuakd wGUEdik yf gonf/ Microsoft Excel onf Entries rsm;udk List wGif tvdt k avsmuf odr;f qnf;xm;ay;onf/ 4if; List udk Munfv h v kd Qif atmufygtwdik ;f vkyfaqmifEdkifygonf(u) Entry ½du k x f nfx h m;aom aemufq;kH Cell udk Select vkyí f Right click vkyyf g/ Context menu wpfck ay:vmrnf/ (c ) 4if; Context menu &Sd Pick Form List command udk Click vkyyf g/

20

uGefysLwmvufpJG

yHk(3-9) txufrS ½dkufxnfhxm;aom Data rsm;ygonfh List wpfckudk awGU&ygrnf/ 4if;rS tvd&k &dS m Data wpfcu k kd a½G;ay;jcif;jzifh ½du k x f nfph &m rvdkbJ tvdktavsmufxnfhoGif;NyD; jzpfaeygvdrfhrnf/ yHk(3-10)

yHk(3-9)

yHk(3-10) Editing Data Entries ( xnfhoGif;NyD; Data rsm;tm;jyifqifjcif; ) 10/ Microsoft Excel wGif Cell wpfcktwGif;odkY Data rsm;xnfhoGif;NyD;aemuf 4if; Data rsm;udkjyif&ef Cell twGif; (odkYr[kwf) Formula bar ay:wGif atmufygtwdkif;

jyifqifEdkifygonf(u) jyifvdkaom Cell twGi;f odYk Double click vkyyf g/ (odrYk [kw)f Formula f g/ (odrYk [kw)f Keyboard ay:&dS F2 udEk ydS yf g/ bar ay:wGif Click vkyy Inserting point udk Arrow key rsm;jzifh jyifvdkaom Data ½Sd&modkY a½GUoGm;NyD; jyifqifEdkifygonf/

21 (c )

(* )

Microsoft Excel 2002

Cell twGif;&Sd rvdktyfaompmom;rsm;udk zsuf&mwGif Insertion Point \ b,fbuf&Sdpmrsm;udk Backspace key jzifhvnf;aumif;? nmbuf&Sd pmrsm;udk Delete key jzifhvnf;aumif; zsufEdkifygonf/ jyifqifxnfo h iG ;f Ny;D ygu Keyboard ay:&Sd Enter key udk ESyd yf g/ (odrYk [kw)f Formula bar ay:&Sd Enter button udk Click vkyy f g/

Undoing Action ( aqmif½GufrIwpfckudk jyefvnfjyifqifjcif; ) 11/ Microsoft Excel ü Worksheet twGif; rnfonfhaqmif½GufrIwpfckckudkrqdk jyefvnfjyifqifEdkif&ef Undoing action yg&Syd gonf/ Undoing action udkaqmif½Guf&ef

atmufygtwdkif; vkyfaqmifEdkifygonf(u) Edit menu udk Click vkyyf g/ (c ) Undo command udk Click vkyyf g/ (odrYk [kw)f Keyboard rS Ctrl + Z udk ESyd yf g/ yH(k 3-11)

yHk(3-11)

uGefysLwmvufpJG

22

Chapter (4) Formatting

1/ Excel worksheet wpfckü Data rsm;udk xnfhoGif;&mwGif pepfwusMunfh½Ií tqifajyap&ef Format jyKvkyfay;&ygrnf/ Format jyKvkyfjcif;onf worksheet &Sd Data rsm;udk toH;k jyKol ESpo f ufaom Font? Size? style ESifh Alignment tp&So d nfwt Ykd m; rsufpdyom'jzpfatmif ajymif;vJjyifqifay;jcif;jzpfygonf/ Format jyKvkyfjcif;udk Data rsm;rxnfhrD jyKvkyfay;EdkifouJhodkY Data rsm; xnfhoGif;NyD;rSvnf; jyKvkyfEdkifygonf/ Formatting Text ( Text rsm;udk jyefvnfjyifqifjcif; ) 2/ Microsoft Excel wGif Cell wpfckcsif; (odkYr[kwf) Cell range wpfckvHk; (odkYr[kwf) Row wpfckvHk; (odkYr[kwf) Column wpfckvHk; (odkYr[kwf) Worksheet wpfckvHk;udk Format jyKvyk Ef ikd yf gonf/ To change font style ( Bold / Italic / Underline ) ( Font style rsm;tm;ajymif;vJjcif; ) 3/ Worksheet twGif;&Sd Font style rsm;udk atmufygtwdi k ;f ajymif;vJEikd yf gonf(u) Format vkyfvdkaom Cell (odkYr[kwf) Cell range udk Select vkyyf g/ (c) Formatting tools bar rS Bold / Italic / Underline button udk Click

vkyyf g/ Bold style

Italic Underline style style

Using Alignment (Cell twGif;&Sd tcsuftvufrsm;udk ab;? b,fnmn§djcif;) 4/ Worksheet wpfcw k iG f Cell rsm;twGi;f &Sd Text rsm;udk b,fnmñ§v d v kd Qif atmufyg

twdkif;ajymif;vJEdkifygonf(u) Align vkyfvdkaom Cell (odkYr[kwf) Cell range udk Select vkyyf g/ (c) Formatting tools bar rS Align left, Align center, Align right butf g/ ton udk Click vkyy Align Align Align left center right

23

Microsoft Excel 2002

Changing Font & Font Size ( pmvHk;yHkpHESifh t&G,ftpm;udk jyifqifjcif; ) 5/ Worksheet wpfcw k iG f Cell rsm;twGi;f &Sd Text rsm;udk Font and size yHpk t H rsK;d rsK;d odYk

ajymif;vdkvQif atmufygtwdkif;ajymif;vJEdkifygonf(u) Font, Size ajymif;vdkaom Cell (odkYr[kwf) Cell range udk Select vkyfyg/ ( c ) Formatting tools bar rS Font list wGif ESpfouf&m Font udka½G;cs,fí Click vkyy f g/ Size list wGiv f nf; ESpo f uf&m Size udka½G;cs,fí Click vkyfyg/ Using Merge Cell & Centre ( Cells aygif;jcif;ESifh tv,fn§djcif;udk toHk;NyKjcif; ) 6/ Microsoft Excel wGif toHk;0ifaom Button wpfcjk zpfygonf/ xdk Button udk Formatting tools bar ay:wGif awGU½SdEdkifygonf/ tvdk&Sdaom Cell range twGif;&Sd Text rsm;udk tv,foYkd yd& Yk mwGif toH;k jyKygonf/ tv,foYkd ydo Yk nfq&kd mü Align center uJhodkY Cell wpfc\ k tv,foYkd Align jyKvyk jf cif;r[kwb f J Cells rsm;udk aygif;í( Merge cell ) jyKvkyfjcif;jzpfonf/ jyKvkyfyHkrSm atmufygtwdkif;jzpfygonf(u) Cell wpfcktwGif; Text rsm;udk ½du k x f nfyh g/ (c ) xdk Cell rS tvdk&Sd&m Cell range txd Select vkyyf g/ (* ) Merge and Center button udk Click vkyyf g/ Select vkyfxm;aom Cell range &Sd Columns rsm;aygif;pyfoGm;NyD;? First cell wGif½dkufxm; aom Text rsm;onf Cell range \ Center wGiaf &muf&o dS mG ;ygrnf/

yHk(4-1)

yHk(4-1)

Merge & Center button

24

uGefysLwmvufpJG

7/ Merge & Center button udk Z,m;rsm;\ acgif;pOfrsm;udk xdZ k ,m;\tv,fwiG f xm;&SdvdkonfhtcgwGif toHk;jyKygonf/ rlvtaetxm;twdkif; jyefvnfjyKvkyfvdkygu xdk Cell udk select vkyx f m;yg/ Format menu atmuf&Sd Cells command udk Click vkyyf g/yH(k 4-2) Format cells dialog box ay:vmrnf/ 4if;rS Alignment tab udak ½G;yg/ yHk(4-3) Text control atmuf&Sd Merge cell check box rS Check mark udk Click vkyfí OK button udkESdyfyg/ rlvtaetxm;twdkif; jyefvnfa&muf&Sdygonf/

yHk(4-2)

yHk(4-3)

25

Microsoft Excel 2002

Changing Font Colour & Cell Shading ( pmvHk;ta&mifESifh aemufcHyHkpH ajymif;vJjcif; ) 8/ Microsoft Excel wGif Font \ Colour udk ajymif;vJay;Edi k yf gonf/ ajymif;vJykH

tqifhqifhrSm atmufygtwdkif;jzpfygonf(u) ajymif;vdkaom Cell (odkYr[kwf) Cell range udk Select vkyyf g/ (c ) Formatting tools bar ay:&Sd Font colour button udk Click vkyyf g/ (odkYr[kwf) Font colour button ab;&Sd Down arrow udk Click vkyyf g/ Dropdown list wpfca k y:vmrnf/ 4if;rS ESpo f uf&m Colour udk Click vkyyf g/ a½G;cs,x f m;aom Font \ Colour ajymif;vJoGm;onfudk awGU& ygrnf/yHk (4-4)

Font Colour Button

yHk(4-4)

9/ Microsoft Excel wGif Cell \ Background ta&mifudk ajymif;vJay;Edkif ygonf/ ajymif;vJyHktqifhqifhrSm atmufygtwdkif;jzpfygonf(u) ajymif;vdkaom Cell (odkYr[kwf) Cell range udk Select vkyyf g/ ( c ) Formatting tools bar ay:&Sd Fill colour button udk Click vkyyf g/ (odkYr[kwf) Fill colour button ab;&Sd Down arrow udk Click vkyyf g/ Dropdown list wpfca k y:vmrnf/ 4if;rS ESpo f uf&m Colour udk Click vkyfyg/ a½G;cs,fxm;aom Cell \ Background colour ajymif;vJoGm; onfudk awGU&ygrnf/ yHk(4-5)

uGefysLwmvufpJG

26

Fill colour button

yHk(4-5)

Adjusting Column Width and Row Height ( Coulmn tus,fESifh Row tjrifhudk jyifqifjcif; ) 10/ Microsoft Excel wGif Column Width ESifh Row Height wdkYudk ajymif;vJ ay;Edik yf gonf/ Microsoft Excel \ Default Column Width rSm 8.43 jzpfNy;D ? Default h ifrh mS atmufyg Row Height rSm 12.75 jzpfygonf/ Rows Height ajymif;vJykH tqifq

twdkif;jzpfygonf(u) ajymif;vdkaom Cell (odkYr[kwf) Cell range udk Select vkyyf g/ ( c ) Format menu rS Row command udk Point vkyyf g/ (*) Sub menu ay:vmrnf/ Height udk Click vkyyf g/ Row Height dialog box ay:vmrnf/yHk(4-6) ay:vmaom Dialog box rS Row Height text box wGif xm;vdkaom *Pef;wpfckudk ½dkufxnfhyg/ Row Height taejzifh 12.75 xufydkaom*Pef;udk ½dkufxnfhygu Row Height us,fvmrnf/ 12.75 xufavsmhaom*Pef;udk ½dkufxnfhygu Row Height usO;f oGm;ygrnf/ yHk(4-6) (C) OK udk Click vkyyf g/

27 11/

Microsoft Excel 2002

Column Width ajymif;vJyHk tqifhqifhrSm atmufygtwdkif;jzpfygonf(u) ajymif;vdkaom Cell (odkYr[kwf) Cell range udk Select vkyyf g/ ( c ) Format menu rS Column command udk Point vkyyf g/ (* ) Sub menu ay:vmrnf/ Width udk Click vkyyf g/ Column Width dialog box ay:vmrnf/yHk(4-7) ay:vmaom Dialog box rS Column Width text box wGif xm;vda k om *Pef;wpfcu k kd ½du k x f nfyh g/ Column Width taejzifh 8.43 xufydkaom*Pef;udk ½dkufxnfhygu Column Width us,fvmrnf/ 8.43 xufavsmhaom*Pef;udk ½dkufxnfhygu Column Width usO;f oGm;ygrnf/ (C) OK udk Click vkyyf g/

yHk(4-7) Inserting Rows, Columns & Cells ( Rows, Columns & Cells rsm;udk xnfhoGif;jcif; ) 12/ Microsoft Excel wGif Rows (odkYr[kwf) Columns wdkYudk wpfck (odkYr[kwf) wpfckxufydkí Insert jyKvkyfvdkygu atmufygtwdkif;aqmif½Guf&ygrnf(u) Insert jyKvyk v f akd om Row \ atmuf (odrYk [kw)f Column \nmbuf wGif &Sdaom Cell udk Select vkyyf g/ (c) Insert menu rS Row (odkYr[kwf) Column udk Click vkyyf g/ Row (odkYr[kwf) Column wpfck ay:vmonfudkawGY&ygrnf/ (*) Cell wpfck ( odkYr[kwf ) Cell range wpfckudk Select vkyfí Insert menu rS Cell udk Click vkyy f g/ Insert dialog box ay:vmrnf/ 4if;rS Shift cells right (odkYr[kwf) Shift cells down jzifh Cell \ nmbuf (odkYr[kwf) atmufbufodkY Insert vkyEf ikd yf gonf/ yH(k 4-8)

uGefysLwmvufpJG

28

yHk(4-8)

Removing Rows, Columns & Cells ( Rows, Columns & Cells rsm;tm; z,f&Sm;jcif; ) 13/ Microsoft Excel wGif Rows (odkYr[kwf) Columns (odkYr[kwf) Cells wdkYudk

z,f&Sm;vdkygu atmufygtwdkif;aqmif½Guf&ygrnf(u) z,f&Sm;vdkaom Rows (odkYr[kwf) Columns (odkYr[kwf) Cells wdkYudk Select vkyy f g/ (c) Keyboard &Sd Delete key udEk ydS yf g/ (odrYk [kw)f Edit menu &Sd Delete f g/ Delete dialog box ay:vmrnf/ yH(k 4-9) command udk Click vkyy 4if;rS Shift cells left (odkYr[kwf) Shift cells up (odkYr[kwf) Entire row (odkYr[kwf) Entire column option wpfckckudka½G;yg/ (*) OK udk Click vkyyf g/

yHk(4-9)

29

Microsoft Excel 2002

Rotating the Text ( Text rsm;tm; vSnfhjcif; ) 14/ Microsoft Excel wGif Text rsm;udkvdktyfovdk vSnfhEdkifygonf/vkyfaqmifyHk

tqifhqifhrSm atmufygtwdkif;jzpfygonf(u) Rotate vkyfvdkaom Cell (odkYr[kwf) Cell range udk Select vkyyf g/ ( c ) Format menu rS Cells udk Point vkyyf g/ Format cells dialog box ay:vmrnf/ yHk(4-10) (* ) ay:vmaom Dialog box &Sd Alignment tab udk Click vkyyf g/ (C) Horizontal ESifh Vertical alignment wGif vdktyfaom Alignment ajymif;yg/ (i ) Orientation wGif ajymif;vdkaom yHkpH (odkYr[kwf) 'D*&Dudk ajymif;ay;yg/ Oyrm- 90 Degrees udak &G;cs,v f u kd yf g/ Ny;D aemuf OK udk Click vkyyf g/ yHk(4-11) twdkif; 90H Rotate jzpfomG ;ygrnf/

yHk(4-10)

30

uGefysLwmvufpJG

yHk(4-11)

Formatting Values ( wefzdk;rsm; jyifqifjcif; ) 15/ Microsoft Excel wGif Numeric values wdkY\ Numeric format yHpk rH sm;rSm

atmufygtwdkif;jzpfygonfNumber Format Format code 0 0.00 #,##0 #,##0.0

When you type 12345 -12345 12345 12345 12345

Currency Format Format code $#,##0_);($#,##0) $#,##0_);[Red]($#,##0) $#,##0.00_);($#,##0.00) $#,##0.00_);[Red]($#,##0.00)

Percentage Format Format code 0% 0.00%

Display result 12345 -12345 (or) (12345) 12345.00 12,345 12,345.0

When you type 12345 -12345 12345 -12345

When you type 123 123

Display result $12,345 -$12,345 (or) Red ($12,345) $12,345.00 -$12,345.00 (or) Red ($12,345)

Display result 123% 123.00%

31

Microsoft Excel 2002

Fraction Format Format code # ?/? # ??/??

When you type 1/2 22/7

Display result 0.5 3.142857...

Scientific Format Format code 0.00E+00 # # 0.0E+0

When you type 12 12

Display result 1.20E+01 12.0E+0

Special Format Format code 00000 # # #-# # # #

When you type 12 183250

Display result 00012 18-3250

Text Format Format code @

When you type 12TX236

Display result 12TX236

Date Format Format code 3/14/2001

When you type 31/12/2002

Display result 12/31/2002

Time Format Format code mm:ss hh:mm AM/PM

When you type 12:55 12:55

Display result 12:55 12:55 AM

Create a Custom Number Format ( udef;*Pef;yHkpHtopfrsm; wnfaqmufjcif; ) 16/ Microsoft Excel wGif &Sdxm;NyD;aom Built-in format rsm;udk toHk;rjyKyJ Custom numeric format rsm;udk Create vkyNf y;D toH;k jyKEi kd yf gonf/ Create vkyfenf;

rSm atmufygtwdik ;f jzpfygonf-

uGefysLwmvufpJG (u) (c)

(*)

32

Format vkyfvdkaom Cell (odr Yk [kw)f Cell range rsm;udk Select vkyyf g/ Format menu rS Cells udk Click vk y f y g/ (od k Y r [k w f ) Select vkyfxm;onfh Cell ay:wGif Right click vkyNf y;D ay:vmaom Context f g/ Format Cells dialog box menu rS Format Cells udk Click vkyy

ay:vmygrnf/ yHk(4-12) Number tab uda k ½G;yg/ Category list wGif Custom udk Select vkyyf g/ Type: text box rS oifhawmf&m Number format wpfcu k akd ½G;yg/ OyrmDate format rS m/d/yyyy udk a½G;vdu k yf g/ xdk Format udk dd/mm/ yyyy [kjyifyg/ Format topfwpfcjk zpfvmygrnf/ 4if;udk Text box wGif Save jzpfomG ;ygrnf/ Ny;D aemuf OK udk Click vkyyf g/

yHk(4-12)

(C)

aemufwpfBurd f Format menu udk Click vkyí f Cells udka½G;NyD; Format k x f m;aom Date format topfukd a½G;Ny;D cells dialog box rS ,cifjyKvy Cell twGif;wGif Enter vkyy f gu Date format topftwdkif; ay:vm onfudkawGU&ygrnf/

33

Microsoft Excel 2002

17/ Microsoft Excel wGif Digital placeholder twGuf 0(okn) ESifh # wdkYudk toH;k jyKygonf/ 0(okn)udk Custom format ü oknudkaz:jy&eftwGuf oHk;ygonf/ # tm; rvdktyfaom oknudk raz:jyvdkonfhtcgwGif oHk;ygonf/ Oyrm When you type 1234.59 8.9 .631

Display result 1234.6 8.900 0.6

Use this code ####.# # . 000 0.#

18/

Microsoft Excel \ Format wGif *Pef;wGif Comma ( , ) ygaom Thousands separator yHkpHjzifhjyvdkygu atmufyg Format udktoHk;jyKEdkifygonfWhen you type Display result Use this code 1234.569 1,234.6 #, # # # . 0 1234 1,234.0 12345 12 #, 1234 1 12345678 12346 123400000 123 #,, 12340000 12.34 0.00,,

19/

Microsoft Excel wGif Color twGuf square bracket [ ] xJwGif vdktyfaom Color name udk xnfhoGif;Edkifygonf/ Color name rsm;rSm Black, Blue, Green, Magenta, Red, White, Yellow,... ponfwjYkd zpfygonf/

Oyrm When you type 1234.5678 -1234.5678

Display result (1234.57) -(1234.57)

Use this code [Blue] (#, # # # . 00)

20/ Microsoft Excel wGif Underscore( _ ) ESihf Minuus sign ( - ) onf Number rsm;udk Align vkyaf y;Edik yf gonf/ Underscore ( _ ) udk oH;k rnfqv kd Qif Number wpfcpk m Space vkyy f gonf/ Minus sign oHk;vQif tEIwfoauFw xnfhay;ygonf/

uGefysLwmvufpJG

34

Oyrm When you type 1234 1234 12345678 12345678

21/

Display result 12 34 12 3 4 123-456-78 012-345-678

Use this code 0_000 0_00_00 000-000-00 000-000-000

Microsoft Excel wGif Custom Date & Time format rsm;udk vdktyfovdk

Create jyKvkyfay;Edkifygonf/

Oyrm Custom Date & Time format dddd mmmm d, yyyy d mm, yy yy/mm/dd [Cyan] d mmm, yy d mmm, yy

Display result Monday September 30, 2002 30 09, 02 02/09/30 30 Sep, 02 ( in Cyan ) 30 Sep, 02

Removing Format ( yHkpHtopfrsm;udk jyefvnfzsufjcif;) 22/ Microsoft Excel wGif Create vkyfxm;NyD;aom Custom numeric format rsm;udk toH;k rjyKvv kd Qif Remove vkyEf ikd yf gonf/ Remove vkyef nf;rSm atmufygtwdik ;f

jzpfygonf(u) (c)

Remove vkyv f akd om Cell (odrYk [kw)f Cell range rsm;udk Select vkyyf g/ Edit menu rS Clear command udk Point vkyy f g/ Sub menu wpfck ay:vmrnf/yHk(4-13) 4if;rS Format udk Click vkyfyg/ Create vkyfxm;aom Format rsm;ysufoGm;onfudkawGU&ygrnf/

35

Microsoft Excel 2002

yHk(4-13)

Copying Data ( Data rsm;tm; ul;,ljcif; ) 23/ Microsoft Excel wGif Worksheet wpfckwGif Data rsm;udk xnfhNyD;oGm;vQif xdk Data rsm;tm; vdt k yfonfah e&mrsm;odYk ul;,ljcif; jyKvyk Ef ikd yf gonf/ Copy vkyef nf;rsm;

rSm atmufygtwdik ;f jzpfygonf(u) Copy vkyfvdkaom Cell (odkYr[kwf) Cell range rsm;udk Select vkyyf g/ ( c ) Edit menu rS Copy command udk Click vkyyf g/ (odrYk [kw)f Standard tools bar ay:rS Copy button udk Click vkyy f g/ (odrYk [kw)f ul;,l vdkaom Cell or Cell range ay:wGif Right click vkyyf g/ Shortcut menu ay:vmrnf/ 4if;rS Copy udk Click vkyy f g/ (odrYk [kw)f Keyboard rS Ctrl + C udk ESyd yf g/ Marquee box wpfckay:aernf/ (* ) ul;,lvdkaom Cell (odkYr[kwf) Worksheet (odkYr[kwf) Workbook odkY oGm;í Selector csyg/ (C) Edit menu rS Paste command udk Click vkyyf g/ (odrYk [kw)f Standard tools bar ay:rS Paste button udk Click vkyy f g/ (odrYk [kw)f Selecting Cell ay:wGif Right click vkyy f g/ Shortcut menu ay:vmrnf/ 4if;rS

uGefysLwmvufpJG

36

Paste udk Click vkyy f g/ (odrYk [kw)f Keyboard rS Ctrl + V udk ESyd yf g/ ul;,lvdkaom Data rsm; a&muf&v dS mygrnf/ Moving Data ( Data rsm;tm; a½TUajymif;jcif; ) 24/ Microsoft Excel wGif Worksheet wpfcw k iG f Data rsm;udk ½ku d x f nfNh y;D oGm;ygu xdk Data rsm;tm; vdktyfonfhae&mrsm;odkY a½TUajymif;jcif; jyKvkyfEdkifygonf/ Move

vkyfenf;rsm;rSm atmufygtwdkif;jzpfygonf(u) Move vkyfvdkaom Cell (odkYr[kwf) Cell range udk Select vkyyf g/ (c) Edit menu rS Cut command udk Click vkyyf g/ yH(k 4-14)(odrYk [kw)f Standard tools bar ay:rS Cut button udk Click vkyy f g/ (odrYk [kw)f ul;,lvdkaom Cell or Cell range ay:wGif Right click vkyfyg/ Shortcut menu ay:vmrnf/ 4if;rS Cut udk Click vkyy f g/ (odrYk [kw)f Keyboard rS Ctrl + X udk ESy d yf g/ Marquee box wpfckay:aernf/ (*) a½TUvdkaom Cell (odkYr[kwf) Worksheet (odkYr[kwf) Workbook ae&may:wGif Click vkyfí Selector csxm;yg/

yHk(4-14)

37 (C)

Microsoft Excel 2002

Edit menu rS Paste command udk Click vkyy f g/ (odrYk [kw)f Standard tools bar ay:rS Paste button udk Click vkyy f g/ (odrYk [kw)f Selecting Cell ay:wGif Right click vkyy f g/ Shortcut menu ay:vmrnf/ 4if;rS Paste udk Click vkyy f g/ (odrYk [kw)f Keyboard rS Ctrl + V udk ESyd yf g/ a½TUvdkaom Data rsm; 0ifa&muf&v dS mygrnf/

Moving Cell Contents by Drag-and-Drop ( Data rsm;tm; Drag and drop enf;jzifha½TUajymif;jcif; ) 25/ Microsoft Excel wGif Worksheet wpfcrk S Data rsm;udk xdk Worksheet twGi;f rSmyif vdktyfonfhae&mrsm;odkY Drag and Drop enf;jzifh ae&ma½TUajymif;ay;Edik yf gonf/ odkUaomf tjcm; Worksheet ESifh Workbook rsm;oYdk a½TUajymif;jcif; rjyKEdkifyg/ Drag & Drop enf;rSm atmufygtwdkif; jzpfygonf(u) a½TUvdkaom Cell (odkYr[kwf) Cell range udk Select vkyyf g/ (c ) Select vkyfxm;aom Cell (odkYr[kwf) Cell range \ Selection border udk Mouse pointer wifvu kd yf g/ Pointeronf Arrow Shape Icon yHkajymif;oGm;ygu Drag vkyfNyD; xm;vdkonfhae&ma&mufvQif Mouse udk vTwv f u kd yf g/ tu,fí Pointer onf jrm;yHkrajymif;cJhvQif Tools menu udk Click vkyí f Options command udk Click vkyv f u kd yf g/ Options dialog box ay:vmrnf/ yH(k 4-15) Edit tab udk ESdyfNyD;? Setting

yHk(4-15)

uGefysLwmvufpJG

38

atmufu Allow cell drag and drop check box udk Mouse jzifh Click vkyy f gu Check mark ay:vmygrnf/ OK udk Click vkyyf g/ Ny;D aemuf txufygtwdik ;f Drag and drop vkyjf cif;jzifh Cell contents rsm; Move jzpfvmonfudkawGU&ygrnf/ Drag and Insert Cells ( Data rsm;tm; Drag vkyfítpm;oGif;jcif; ) 26/ Microsoft Excel wGif Worksheet wpfckrS Cell range wpfckudk wpfjcm; ae&mwGif Insert jyKvkyfEdkifygonf/ a½SUwGif Command jzifh Insert jyKvkyfenf;udk az:jycJhNyD;jzpfygonf/ ,ckenf;rSm Mouse jzifh Drag and drop vkyfenf;jzpfygonf(u) Insert vkyfvdkaom Cell range udk Select vkyyf g/ (c) Mouse pointer udk Selection border ay:wifvu kd yf g/ Pointer shape onf Arrow yHak jymif;oGm;ygrnf/ xdt k cg Keyboard &Sd Shift key udk ESdyfí Insert vkyfvdkaom Column (odkYr[kwf) Row tMum;odkY Drag vkyv f myg/ Drag vkyí f a½GUvmpOfwiG f I beam t&Snw f pfcak y:aernf/ Insert vkyfvdkonfh Column (odkYr[kwf) Row tMum; I beam a&muf vQif Mouse udv k w T yf g/yH(k 4-16) Shift key ESyd x f m;onfuv kd nf; vTwyf g/ Move jzpfoGm;onfudk awGU&ygrnf/

yHk(4-16)

39

Microsoft Excel 2002

Delete or Clear Cells ( Cells rsm;&Sd Data rsm;ESifh yHkpHrsm;tm; zsufjcif; ) 27/ Microsoft Excel wGif Worksheet wpfckrS Cell rsm;udk Delete command ESizhf suEf ikd yf gonf/ Delete command jzifh zsurf nfqykd gu Delete vkyv f u kd af om ae&modYk 4if;atmufrS (odrYk [kw)f 4if;nmzufrS Cells rsm;tpm;0ifvmygrnf/jyKvyk yf kH tqifq h ifrh mS

atmufygtwdkif;jzpfygonf(u) Delete vkyfvdkaom Cell (odrYk [kw)f Cell range rsm;udk Select vkyyf g/ (c ) Edit menu rS Delete command (odkYr[kwf) Selecting cells ay: Right click vkyfí ay:vmaom Shortcut menu rS Delete udk Click vkyyf g/ (* ) Delete dialog box ay:vmrnf/ 4if;wGif Delete option rsm;jzpfaom Shift cell left, Shift cell up, Entire row ESifh Entire column wdkY awGU&ygrnf/ yHk(4-17) Shift cell right udk Option ay;NyD; OK udk Click vkyfvdkufygu Select vkyfxm;aom Cell rsm;ysufoGm;NyD; ,if;ae&mudk Select vkyx f m;aom Cell \nmzufrS Data rsm; 0ifa&muf vmonfukd awGU&ygrnf/ Shift cell up option udak ½G;ygu atmufzufrS Data rsm; 0ifa&mufvmygrnf/ Entire row udk a½G;ygu atmufzufrS Data wpfwef;vH;k wufvmygrnf/ Entire column udak ½G;ygu nmzufrS Data rsm; a½GU0ifvmonfudk awGY&Sd&ygrnf/

yHk(4-17)

uGefysLwmvufpJG

40

28/ Microsoft Excel wGif Worksheet wpfcrk S Cell rsm;udk Delete key toH;k jyKNy;D zsuEf ikd yf gonf/ Delete key toH;k jyKNy;D zsuyf gu Cell content rsm;omysuo f mG ;Ny;D Cell f J usecf yhJ grnf/ Cell range ae&mvnf; rysufonfudk awGYEdkif ygonf/ format rSm rysuy xdkenf;udk Clearing cells [kac:qdyk gonf/ Edit menu rS Clear command udk Point vkyfNyD; ay:vmaom Submenu rS All udka½G;vQif Cell format yg ysuo f mG ;onfukd awG&Y &dS ygrnf/ Adding Border to Cells ( Cells rsm;tm; abmifcwfjcif; ) 29/ Microsoft Excel wGif Worksheet wpfckudk Create vkyfNyD;ygu pm&if; Z,m;\Z,m;uGufrsm;ay:vGifapa&; Border owfrSwfay;&ef vdktyfrnf jzpfygonf/ ,if;udk Microsoft Excel taejzifh Border rsm;owfrw S af y;onf[k qdyk gonf/ Border

rsm; owfrSwfay;jcif;jzifh pm&if;Z,m;rSm ydkrdkay:vGifNyD; Munfh½Iíaumif;rGefvmygrnf/ Excel wGif Border rsm;udk atmufygtwdkif; owfrSwfay;Edkifygonf(u) Border owfrSwfvdkaom Cell (odkYr[kwf) Cell range rsm;udk Select vkyyf g/

yHk(4-18)

41 (c )

(* )

Microsoft Excel 2002

Format menu rS Cells udk Point vkyy f g/ Format Cells dialog box ay:vmrnf/ ay:vmaom Format Cells dialog box rS Border tab udak ½G;yg/ Border option rsm;ay:vmrnf/ yHk(4-18) Border option rsm;rS presets \atmufwGif None button, Outline button ES i f h Inside button wd k Y u d k a wG Y & ygrnf / None button rS m Selecting cells twGi;f rnfonfh Border rS rwyfvy kd gu toH;k jyKEikd yf g onf/ Outline button onf Selecting cells \ ywfywfvnfudk Border owfrSwfay;ygrnf/ Inside button onf Selecting cells \ twGif;&Sd Gridlines rsm;tm;vH;k udk Border owfrw S af y;rnfjzpfygonf/ Border atmufwi G &f adS om Preview wGiv f nf; owfrw S af y;vdu k af om Border taetxm;rsm;udk jrifEdkifygonf/ xdk Preview xJwGif vdktyf ovdk Border style rsm;udk Mouse pointer ESifh Click vkyfjcif;jzifh jzKwfjcif;? wyfjcif;jyKvkyfay;Edkifygonf/ Line style atmuf&Sd Lines rsm;udk vdktyfovdka&G;cs,fay;jcif;jzifh ajymif;vJay;EdkifNyD; Color box wGiv f nf; ESpo f uf&m Color udak ½G;cs,af y;jcif;jzifh Create vkyx f m;aom

pm&if;Z,m;onf ydkíay:vGifxif&Sm;vmapEdkifygonf/ 30/ Microsoft Excel taejzifh Border rsm;owfrSwfay;&mwGif ydkrdkvG,fulaom enf;vrf;wpfc&k ydS gonf/ Standard tools bar ay:&Sd Border icon udk toH;k jyKaomenf; jzpfygonf/ Microsoft Excel 2002 taejzifh Border icon wGif NyD;cJhaom Version rsm;ESifhrwlonfh opfvGifaom Function wpfckxnfhay;xm;ygonf/ ,if;rSm User udk,fwdkif Border a&;qJGEdkifonfh Function wpfcyk gvmygonf/ Formatting tools bar ay:&Sd Border icon jzifh Border a&;qJGxnfhoGif;enf;rSm atmufygtwdkif; jzpfygonf(u) Border owfrSwfvdkaom Cell (odkYr[kwf) Cell range rsm;udk Select vkyyf g/ (c) Standard tools bar ay:&Sd Border icon udk Click vkyyf g/ xdt k cg Select vkyfxm;aom Cell (odkYr[kwf) Cell range rsm;wGif border xnfhNyD;om; jzpfaeonfudk awGY&ygrnf/ ESpfouf&m Border style udk toHk;jyKvdkvQif Icon ab;&Sd Down arrow udk Click vkyv f u kd yf g/ Style box ay:vmygrnf/ ESpfoufaom Border style udk a½G;í Click vkyfjcif;jzifh Border xnfhoGif;NyD; jzpfaeygrnf/ yHk(4-19)

uGefysLwmvufpJG

42

yHk(4-19)

(*)

Border udk pdwBf uKd ua f &;qGv J ykd gu Style box \atmufqHk; wGif Draw k oH;k jyKEikd yf gonf/ Draw borders command Borders command udt udk Click vkyyf gu Draw borders Tools bar wpfck ay:vmygrnf/

yHk(4-20)

(C)

ay:vmaom Tools bar ay:&Sd cJwHyHk Icon udk Click vkyv f u kd yf gu cJwHyHk Pointer tjzpfajymif;oGm;NyD; User ESpfoufovdk Border rsm; a&;qJEG ikd yf gonf/ Border a&;qJ&G mwGif Line style trsK;d rsK;d udk ajymif;vJ toH;k jyKEikd &f ef Line style box yg&Syd gonf/ Border rsm;udk ta&mifxnfh oGif;Edkifap&ef Color box vnf;yg&Sdygonf/ a&;qJGaeaom Border udk

43

Microsoft Excel 2002

rvdktyfygu zsufEdkif&ef cJzsufwHk; Eraser button udkvnf; toHk;jyKEdkif ygonf/ Copying Format ( Format yHkpHrsm; ul;,ljcif; ) 31/ Microsoft Excel wGif Standard tools bar ay:&Sd Format painter button udk toH;k jyKNy;D Cell wpfc&k dS Format yHpk rH sm;udk ul;,lEikd yf gonf/Format painter udk toH;k jyKí Cell tcsif;csif; Format rsm;udk atmufygtwdkif; vsifjrefpGmul;ajymif;ay;Edkifygrnf(u) ul;vdkaom Cell (odkYr[kwf) Cell range udk Select vkyyf g/ Standard tools bar ay:&Sd Format painter udk Click vkyy f g/ ( c) Select vkyx f m; aom Cell (odrYk [kw)f Cell range ay:wGif Marquee box wpfcak y:vmygrnf/ Pointer shape onfvnf; ajymif;oGm;onfukd awG&Y ygrnf/ yH(k 4-21) xdt k csed w f iG f ul;,lvakd om ae&modo Yk mG ;íClcik vkyyf gu Format yHpk rH sm; a&muf&v dS monfuakd wG&Y rnf/ wpfcx k uf ydí k ul;,lvykd gu Standard tools bar ay:&Sd Format painter udk Double click vkyjf cif;jzifh ul;,lEi kd yf gonf/

yHk(4-21)

Inserting WordArt ( WordArt udk xnfhoGif;jcif; ) 32/ Microsoft Excel wGif Worksheet wpfcrk mS WordArt udk xnfah y;Edik yf gonf/ WordArt qdo k nfrmS pmvH;k rsm;tm; vSyap&ef WordArt style rsm;jzifh aqmif½u G af y;jcif; jzpfygonf/ WordArt style trsKd;rsKd;&SdonfhtxJrS BudKufESpfouf&m Style udk a½G;cs,f ay;Edik yf gonf/ WordArt jzifh pmvH;k yHpk H wpfcu k akd tmufygtwdik ;f aqmif½u G Ef ikd yf gonf-

uGefysLwmvufpJG (u) (c) (*)

yHk(4-22)

44

Insert menu udk Click vkyy f g/ Pull down menu wpfcu k svmrnf/ Picture command udk point vkyy f g/ Sub menu wpfckay:vmrnf/ ay:vmaom Sub menu xJrS WordArt udk Click vkyyf g/ WordArt Gallery dialog box ay:vmrnf/ yHk(4-22)

45 (C) (i)

Microsoft Excel 2002

Select a WordArt style atmufrS WordArt style wpfcu k kd a½G;yg/ NyD;aemuf OK udk Click vkyyf g/ Edit WordArt Text dialog box wpfckay:vmNyD; Text box xJwGif rdr½d u kd v f akd om pmaMumif;ud½k u kd yf g/ Oyrm- COMPUTER ½ku d yf g/Ny;D vQif OK udk Click vkyy f g/ yHk(4-23)

yHk(4-23) (p )

Worksheet ay:wGif WordArt Text a&mufvmonfudkawGY&ygrnf/ WordArt Text udk vdo k vdak ½GUajymif;ay;Edik yf gonf/ t½G,t f pm;udv k nf;

vdktyfovdk tBuD;tao;jyKvkyfay;Edkifygonf/ yHk(4-24)

yHk(4-24)

uGefysLwmvufpJG

46

Using Conditional Formats ( Conditional Formats udk toHk;jyKjcif; ) 33/ Microsoft Excel wGif Data entry jyKvkyfonfhtcgü Data wpfckcsif;\ tajctaeESifh Format rsm;udk owfrw S af z:jyEdik yf gonf/ xdo k jYkd yKvyk o f nft h cgwGiv f nf; Cell content rsm;udk tajccHNy;D ? Format jyKvkyfouJhodkY? Formula udk tajccHNy;D Format

jyKvkyfjcif;rsKd;&Sdygonf/ Oyrm- ausmif;wpfausmif;\ twef;wpfwef;&Sd ausmif;om; ausmif;olrsm;\ pmar;yJt G rSwpf m&if;tm; Munfv h Qif us½;HI onfb h mom &So d uJo h Ykd *kPx f ;l &&So d nfh bmomvnf; &SEd ikd yf gonf/ xdt k cgwGif Conditional Format udk toHk;jyKNyD; us½IH;bmom? atmifjrifbmom? *kPfxl;&bmomrsm;udk xif&Sm;atmif Format wpfck jyKvyk af y;Edik yf gonf/xdo k Ykd Format wpfcjk yKvyk af y;xm;ygu xdt k rSwpf m&if;wGif us½;IH ol? atmifjriforl sm;ESi*hf P k x f ;l &olrsm;\ tajctaeudk ay:vGix f if&mS ;pGm awGjY rifEikd yf grnf/f jyKvkyfyHktqifhqifhudk atmufyg Worksheet wpfcjk zifh &Si;f vif;jyygrnf/ yHk(4-25)

yHk(4-25) 34/ 4if; Worksheet wGif ausmif;om;wpfOD;pD\trSwfpm&if;aygif;udk Cell I2 wGif az:jy&ef Cell udk select vkyfNyD; AutoSum button udk Click vkyyf grnf/ jy;D aemuf Enter key ESy d yf g/ Cell C2:H2 wGif;rS wefzdk;rsm;udk aygif;ay;ygrnf/ NyD;vQif Cell I2 rS I11 txd AutoFill vk y f y gu trS w f a ygif ; ud k & &S d y grnf / bmom&yf t oD ; oD ; \ atmifrw S t f m; 40 owfrw S o f jzifh 40 atmuf&&Sad ombmomudk us½;IH onf[k owfrw S f rnfjzpfNyD;? us½IH;bmomudkvnf; xif&Sm;ap&ef jzpfygonf/ xdkYtwl bmom&yftay:

47

Microsoft Excel 2002

rlwnfí *kPfxl;&bmomrsm;udkvnf; xif&Sm;ap&ef jzpfygonf/ xdktajctaewGif Conditional Format udk toHk;jyKygu txufygowfrSwfxm;onfh tcsuftvufrsm; ajyvnfoGm;rnf jzpfygonf/ 35/

Conditional Format toHk;jyKyHktqifhqifhrSm atmufygtwdkif;jzpfygonf(u) Conditional format toHk;jyKvdkaom Cell range udk Select vkyyf g/ (c ) Format menu rS Conditional Formatting... command udk Click vkyyf g/ Conditional Formatting dialog box ay:vmygrnf/ yH(k 4-26)

yHk(4-26) (*) (C) (i )

(p ) (q)

Condition 1 box wGif Cell Value Is udk a½G;yg/ 'kw, d List box wGif less than udka½G;yg/ nmzuftpGefqHk; Box wGif 40 ud½ k u kd x f nfyh grnf/ NyD;aemuf Format button udk Click vkyyf g/ Format Cell dialog box

ay:vmygrnf/ ay:vmaom Format Cell dialog box rS Pattern tab udak ½G;yg/ Pattern tab ay:vmygrnf/ yHk(4-27) ,if;rS Color atmufwGif Red color udk a½G;yg/ Ny;D u OK udk Click vkyyf g/ Conditional Formatting dialog box odjYk yefa&mufvmygrnf/ ,if;rS OK udk Click vkyy f g/ 40 atmufavsmeh nf;aeaom bmom&yfrsm;&So d nfh Cells rsm;wGif Red color teDa&mifay:vmygrnf/ yHk(4-28) tvm;wl bmom&yftvdkuf *kPx f ;l &rSwrf sm;udv k nf; owfrw S Ef ikd yf gonf/

uGefysLwmvufpJG

48

yHk (4-27)

yHk (4-28)

49

Microsoft Excel 2002

36/ Conditional Format toHk;jyKyHkwGif Formula udk tajccHNyD;? Format jyKvkyfyHk tqifhqifhudk atmufygtwdkif;avhvmMunfhygrnf(u) Conditional Format toHk;jyKvdkaom Cell range udk Select vkyyf g/ (c ) Format menu udk Click vkyyf g/ Pull down menu usvmrnf/ ,if;rS Conditional Formatting... command udk Click vkyy f g/ (* ) Conditional Formatting dialog box ay:vmrnf/yH(k 4-29) Condition 1 atmufwGif&Sd Dropdown list box wGif Formula Is udk a½G;yg/ 'kw, d Text box wGif = C2 < 40 udk ½du k x f nfyh g/C2 onf select vkyx f m;aom Cell range \ tpOD;qHk; Cell jzpfygonf/

(C)

(i)

(p )

yHk(4-29) NyD;aemuf Format button udk Click vkyfNyD; Format Cell dialog box &Sd Font tab udak ½G;yg/ Font style atmufwGif Bold style udk a½G;NyD; Color: drop down list box wGif Red udka½G;yg/ NyD;aemuf OK udk Click vkyy f g/ 'kwd, Condition wpfcktwGuf Add button udk Click vkyfyg/ Condition 2 ay:vmygrnf/ ,if;atmufwGif&Sd Dropdown list box wGif Formula Is udk a½G;yg/ 'kw, d Text box wGif = C2 >= 40 udk ½du k x f nfyh g/ NyD;aemuf Format button udk Click vkyfNyD; Format Cell dialog box &Sd Font tab udak ½G;yg/ Font style atmufwGif Bold style udk a½G;NyD; Color: drop down list box wGif Blue udka½G;yg/ NyD;aemuf OK udk Click vkyy f g/

uGefysLwmvufpJG

50 yHk(4-29)

37/

xdt k cg Conditional Formatting dialog box &Sd Preview wGif tjyma&mif Bold Text Sample udkawGU&ygrnf/ qdkvdkonfrSm Select vkyfxm;aom Cell range twGif;rS Cell value wpfcck o k nf 40 ESiahf usmyf gu tjyma&mif Bold style udk az:jy&ef jzpfygonf/ Ny;D aemuf Conditional Formatting dialog box &Sd OK button udk Click vkyyf gu yH(k 4-30)ygtwdik ;f Worksheet wGif awG&Y ygrnf/

yHk(4-30) 38/ tu,fí Conditional Format rsm;udk toHk;rjyKvdkygu atmufygtwdkif; aqmif½GufEdkifygonf(u) Conditional Format jyKvkyfxm;aom Cells range udk Select vkyyf g/ (c) Format menu udk Click vkyyf g/ Conditional Formatting... command ud k Click vkyfyg/ Conditional Formatting Cell dialog box ay:vmrnf/ xdktcg Delete button udk Click vkyfyg/ Delete Conditional format dialog box ay:vmrnf/ yHk(4-31) Select the condition(s) to delete atmuf&Sd Condition 1, 2, 3... rS Check f g/ xdaYk emuf Conditional box rsm;udk Click vkyfí OK udk Click vkyy k yf g/ Format Cell dialog box &Sd OK udk Click xyfvy

51 ( *)

Microsoft Excel 2002

xdt k cg Conditional Format style rsm;onf Cancel jzpfoGm;NyD;? rlv Worksheet twdi k ;f jyefjzpfomG ;ygrnf/

yHk(4-31) Creating a Custom Fill Series (Custom Fill Series udk wnfaqmufjcif;) 39/ Microsoft Excel wGif ( l, 2, 3, 4, 5, 6 )? ( Mon, Tue, Wed, Thu, ... ) tp&Sdonfh Autofill Entry series yHpk rH sm;udk aqmif½u G Ef ikd yf gonf/ Excel taejzifh toifhpDrHaqmif½Gufxm;jcif;aMumifh jzpfygonf/ Excel wGif ryg&Sdaom Autofill Entry Series rsm;udv k nf; wnfaqmufEikd yf gonf/ Autofill Entry Series wpfckudk atmufyg

twdkif; aqmif½GufEdkifygonf(u) Tools menu udk Click vkyyf g/ Pull down menu wpfcu k svmrnf/ Options command udk Click vkyy f g/ Options dialog box ay:vmrnf/ yHk(4-32) Custom List tab udk Click vkyyf g/ List Entries box wGif Cursor ay:vmrnf/

yHk(4-32)

uGefysLwmvufpJG

(c)

(*)

52

yHk(4.33) 1 QTY, 2 QTY, 3 QTY [lí pmaMumif;rsm;udk comma (,) cHí ½du k x f nfh yg/ yH(k 4-33) xdaYk emuf Add button udk Click vkyyf g/ OK udk Click vkyyf g/ Custom Autofill entry wpfckudk wnfaqmufNyD;jzpfygonf/ Create vkyfNyD;oGm;aom Custom Autofill udk Worksheet twGif; prf;oyfMunfhygu atmufygtwdkif; awGU&Sd&ygrnf/ yHk(4-34)

yHk(4-34)

(C)

Custom Autofill udk roH;k vdí k y,fzsuv f ykd gu Tools menu udk Click vkyfNyD;aemuf Options command udk Click vkyyf g/ Options dialog f g/ zsuv f akd om box ay:vmygrnf/ Custom List tab udk Click vkyy Series udk Select vkyfí Delete button udk Click vkyy f g/ y,fzsuNf y;D

jzpfomG ;ygrnf/

53

Microsoft Excel 2002

More Control with Series ( Series rsm;udk Control jyKvkyfjcif; ) 40/ Microsoft Excel wGif Autofill jyKvyk jf cif;onf vG,u f yl gonf/ odaYk omfvnf; Data Entry rsm;pGmxnf& h rnfh tajctaejzpfaeygu Excel twGuf Series command udk toHk;jyKjcif;onf ydkrdkvG,fulygrnf/ Edit menu atmufrS Series command udk toH;k jyKEikd yf gonf/ Microsoft Excel rS vufcHaom Series av;rsK;d &Syd gonf/ 4if;wdrYk mS

atmufygtwdkif;jzpfygonfLinear

1, 2 100, 99

3, 4, 5, 6 98, 97, 96, 95

Growth

10 ( step 5 ) 10 ( step 10 )

15, 20, 25, 30 20, 30, 40, 50

Date

Mon Feb 1997

Tue, Wed, Thur Mar, Apr, May 1998, 1999, 2000, 2001

AutoFill

Term1 1st Quarter

Term2, Term3, Term4 2nd Quarter, 3rd Quarter

41/ Microsoft Excel wGif Series wpfck wnfaqmufvdkygu atmufygtwdkif; wnfaqmufEdkifygonf(u) Cell A2 rSm *Pef;wpfck Oyrm- 6 udk ½du k yf g/ 4if; 6 onf Series wpfck \ tp (odkYr[kwf) tqHk; jzpfEdkifygonf/ yHk(4-35) xdk *Pef;udk Series jzpfzdkY Cell range wpfckudk Select vkyyf grnf/ Oyrm- A2: F2

yHk(4-35)

uGefysLwmvufpJG (c)

54

Edit menu udk Click vkyfyg/ Pull down menu usvmrnf/ Fill f g/ Sub menu wpfckay:vmrnf/ ay:vm command udk Point vkyy aom Sub menu rS Series udk Click vkyyf g/ Series dialog box wpfck

ay:vmygrnf/ yHk(4-36)

yHk(4-36)

(*)

Series in box wGif Rows option ESifh Type box wGif Linear option udk a½G;yg/ Step value text box wGif 5 ud½k u kd yf g/ xdaYk emuf OK udk Click vkyy f g/

55 (C)

Microsoft Excel 2002

Worksheet wGif Select vkyfxm;onfh 6 &Sdaom Cell udk Autofill vkyyf g/ 6, 11, 16, 21, 26 ponfh Series wpfckay:vmygrnf/yHk(4-37)

yHk(4-37)

xdk Series udk xyfNyD;wdk;csJMunfhvdkygu Cell range udk Select vkyyf g/ Series dialog box &dS Series in: column eJY Type: Linear udk a½G;yg/ Step value: 5 ESifh Stop value udk 60 xm;NyD;? OK udk Click vkyy f g/ yH(k 4-38) rSm jyxm;onft h wdik ;f Incrementing cell range wpfck ay:vm

yHk(4-38)

uGefysLwmvufpJG

(i)

56

D ;kd aeonfukd awGU&ygrnf/ Stop value ygrnf/ Column wdik ;f wGif 6 ckpw udk 60 rSmxm;onft h wGuf Column wdkif;\ Last cell value rsm;onf 60 xuf rausmfvGefonfudk awGU&rnfjzpfygonf/ tu,fí 6, 11, 16, 21, 26 udk Linear Type rvkyfbJ Growth Type jyKvyk yf grnf/ Step value text boxwGif 2 udk ½du k x f nfyh grnf/ xdt k cg Cell range wdkif;wGif ESpfqpD wdk;oGm;onfudk awGU&ygrnf/ yHk(4-39)

yHk(4-39)

57

Microsoft Excel 2002

Chapter (5) Formulas

1/ Microsoft Excel wGif Formula onf tvGeftoHk;0ifaom Excel \ Tools rsm; jzpfygonf/ Formula qdo k nfrmS Excel worksheet data rsm;udk wGufcsufay;&ef twGuf toHk;jyKaom Equations rsm;jzpfygonf/ Formula udk pwif&eftwGuf Equal sign " = " udt k oH;k jyKygonf/ Oyrm=5+2*3 Parts of a Formula ( Formula \tpdwftydkif;rsm; ) 2/ Formula udk Functions ? References (or) Names? Constants ESihf Operators

[laom tpdwftydkif;rsm;jzifh zJGUpnf;wnfaqmufxm;ygonf/ Oyrm -

1

Functions - PI( ) onf Function wpfckjzpfNyD;? 3.142... wefzdk;udk

az:jyygonf/ 2 3 4

References (or) Names - A2 onf Cell reference wpfck jzpf ygonf/ Cell A2 twGif;&Sd wefzdk;udk az:jyygonf/ Constants - Formula twGif;odkY wdkuf½dkufxnfhoGif;ay;aom Numbers ESifh Text rsm;jzpfygonf/ Oyrm 2 Operators - +, -, *, /, ^ ponfh ocsFmoauFwrsm; jzpfygonf/

Display Or Hide Formula ( Formula and Data rsm;tm;0Sufjcif;ESifh jyefvnfaz:jyjcif; ) 3/ Worksheet twGif;&Sd Data rsm;ESifh Formulas rsm;tm; tjcm;olwpfpHkwpfOD; ul;,ljcif;? zsufqD;jcif;? ajymif;vJjcif;rsm; rjyKvkyfEdkifap&ef rdrd Worksheet udk Pass word ay;í 0Sufxm;Edkifygonf/ Display or Hide jyKvkyfyHktqifhqifhrSm atmufyg

twdkif;jzpffygonf(u) Hide vkyfvdkaom Formula (odkYr[kwf) Data rsm;udk Select vkyyf g/ (odkYr[kwf) Worksheet wpfckvHk;udk Select vkyyf g/

uGefysLwmvufpJG (c) (*)

(C)

58

Format menu udk Click vkyfí ay:vmaom Pull down menu rS Cells udk Click vkyy f g/ Format Cells dialog box ay:vmrnf/ ay:vmaom Format Cells dialog box rS Protection tab udk Click vkyfyg/ Protection tab &Sd Hidden check box udk Click vkyfyg/ yHk(5-1) Check mark ay:vmygrnf/ OK udk Click vkyyf g/

yHk(5-1) Tools menu udkxyfí Click vkyy f g/ Pull down menu ay:vmrnf/ 4if;rS Protection command udk Point vkyyf g/ Submenu ay:vm rnf/ ,if;rS Protect Sheet udk Click vkyyf g/yH(k 5-2) Protect sheet dialog box ay:vmrnf/ ,if;rS Protect worksheet and contents of locked cells check box udk a½G;yg/ Password to unprotect k x f nfyh g/ Ny;D aemuf sheet: text box wGif ESpfouf&m Password udk ½du OK udk Click vkyy f g/ Confirm Password dialog box ay:vmyg vdrrhf nf/ Reenter password proceed text box wGif ,cifu ½du k x f nfh vdu k af om Password udk jyef½u kd af y;yg/ Ny;D vQif OK udk Click vkyjf cif;jzifh rdrd Worksheet &S d Formula rsm;onf Formula bar ay:wG i f

59

Microsoft Excel 2002

aysmufomG ;onfukd awGU&ygrnf/ rdrd Data &Sad om Cell twGi;f odYk Cursor csvdkufvQifvnf; Error dialog box ay:vmrnf/

yHk(5-2)

rSwfcsu/f

Formula udk0Sufjcif;? Cells rsm;udk Protect vkyfjcif; vkyif ef;pOfwiG f Worksheet udk Hidden vky½f jkH zifh rnfoYkd rQ xl;jcm;rI&rdS nf r[kwyf g/ Worksheet udk trSew f u,f Protect jzpfap&ef Tools menu atmuf&Sd Protection command rS protect sheet udka½G;cs,fNyD; Protect worksheet and contents of locked cells check box udk Check vkyx f m;rSom Protect jzpfygvdrrhf nf/

uGefysLwmvufpJG

60

4/ Worksheet twGi;f &Sd Data rsm;ESihf Formulas rsm;tm; jyifqifvv kd Qif rdrad y;xm; aom Password udk odxm;&ef ta&;BuD;ygonf/ Data rsm;ESifh Formulas rsm;tm; jyifqifjznfhpGufvdkygu atmufygtwdkif; aqmif½GufEdkifygonf(u) Hide vkyfxm;aom Formula (odkYr[kwf) Data rsm;udk Select vkyyf g/ (odkYr[kwf) Worksheet wpfckvHk;udk Select vkyyf g/ ( c ) Tools menu udk Click vkyfí ay:vmaom Pull down menu rS Protection udk Point vkyy f g/ Submenu ay:vmrnf/ yHk(5-3) ( * ) ay:vmaom Submenu rS Unprotect sheet udk Click vkyfyg/ Unprotect Sheet dialog box ay:vmrnf/ yHk(5-4) 4if;rS Password k u kd yf g/ jy;D aemuf OK udk Click vkyyf g/ list box wGif Password ud½ (C) Data rsm;ESifh Formulas rsm;tm; jyifqifjznfhpGufjcif;udk jyKvkyfyg/ jyifqifjznfhpGufNyD;aemuf Protection jyKvyk v f ykd gu Display Or Hide Formula wGif vkyfaqmifyHktwdkif; aqmif½GufEdkifygonf/

yHk(5-3)

yHk(5-4)

61

Microsoft Excel 2002

Create a Simple Formula ( Formula wpfck wnfaqmufjcif; ) 5/ Formula wpfckudk Worksheet wpfckwGif pwiftoHk;jyKrnfqdkygu Equal sign (=) ESip hf wif&ygrnf/ Equal sign yg&Sjd cif;? ryg&Sjd cif;onf Formula jzpfjcif;? rjzpfjcif;ESihf qdik yf gonf/ Formula wpfckudk Excel worksheet xJwGif ½dkufxnfhvdkufygu oufqdkif aom Cell reference rsm;udk udk,fpm;jyKNyD; tajzudkwGufcsufay;ygrnf/ odkYaomfvnf; xdk Cell twGif;oufqdkif&m Formula udrk jrifawGUEdik b f J Result data omay:aeygrnf/ oufqdkif&m Formula udk Formula bar ay:wGif awGU&SdEdkifrnf jzpfygonf/ Formula ud½k u kd x f nfo h nft h cg Formula bar wGif½dkufxnfhEdkifovdk? oufqdkif&m Cell twGif;ü

vnf; ½du k x f nfEh ikd yf gonf/ Oyrm Excel formula always begins with an equal (=) sign Cell reference Multiplication operator

= A3 + B3 * 3

Numeric constant Addition operator

6/

txufaz:jyyg Formula wGif A3, B3 onf Unknown data rsm;&Sdaom Cell reference rsm;jzpfygonf/ + , * oauFwrsm;udk Mathematical operator rsm;[k ac:ygonf/ 3 onf Numeric constant wpfcjk zpfygonf/ A3 udk Select vkyfNyD; 10 udk ½du k x f nfyh g/ B3 udk Select vkyfNyD; 40 udk ½du k x f nfyh g/ xdt k cg tajz&Srd nfh Cell wGif 130 [kaz:jyay;ygrnf/ tu,fí Cell twGif;wGif Formula ESifh Data wdkYudk wpfvSnfhpD tjyeftvSef jrifawGUvdkygu Tools menu atmuf&Sd Options command udk Click vkyfNyD;? Options dialog ay:vmonfhtcg View tab udk Click vkyyf g/ yHk(5-5) ,if;rS Options window atmuf&Sd Formulas udk Check vkyyf g/ Ny;D aemuf OK udk Click vkyy f g/ xdt k cg Ctrl key udkESdyfí Keyboard \ b,fbuftay:&Sd ( ` ) Grave accent key udk ESy d yf gu Formula view ESifh Result view wdkYonf wpfvSnfhpD azmfjyaeonfudk awGY&ygrnf/

uGefysLwmvufpJG

62

yHk(5-5)

Create a Simple Formula that Contains Names ( Formula wpfckudk trnfrsm;jzifh udk,fpm;jyKwnfaqmufjcif; ) 7/ Formula tm; Cell reference tpm; Name rsm;udt k oH;k jyKNy;D aqmif½u G Ef ikd yf g onf/ 4if;udk Define name jyKvyk o f nf[q k Ekd ikd yf gonf/ Cell reference rsm;tm; Name kd jf cif; jzpfygonf/ Oyrm- ypön;f wpfc\ k wefz;kd udk ta& reference tjzpfoYkd ajymif;vJvu twGufESifhajr§mufygu usoifhaiGwefzdk;udk &&Sdygonf/ Diskette wpfcsyo f nf 200 usyf

63

Microsoft Excel 2002

jzpfaomf Diskette tcsyfta&twGuf 10 csyfqdkygu aiGrnfrQusoifhrnfenf; [laom ar;cGef;ykpämtm; ½dk;½dk; Cell reference ESifhrwGufbJ Define name ajymif;NyD; wGufMunfh Edik yf gonf/ Cell wpfckudk Price ? useo f nfh Cell wpfct k m; Amount [k owfrw S yf grnf/ Cell A2 ESifh Cell A3 wGif Price ESifh Amount rsm;udk ½du k x f nfyh grnf/ Ny;D vQif Cell B2 tm; Select vkyfNyD; Define name udk atmufygtwdkif;owfrSwfygrnf(u) Cell B2 udk Select vkyyf g/ ( c ) Insert menu rS Name udk Point vkyyf g/ ( * ) ay:vmaom Sub menu rS Define udk Click vkyyf g/ Define name dialog box ay:vmrnf/ yH(k 5-6) Price qdkonfh text wpfco k nf Names in workbook: text box wGif ay:aeygrnf/ xdt k rnfonf worksheet u Cell B2 udkudk,fpm;jyKrnf[k qdkvdkygonf/ xdkYaemuf Add button udk Click vkyfyg/ Price qdkonfh Text onf atmuf&Sd Text box tBuD;xJwGif xyfay:vmygrnf/ xdktcgwGif Cell B2 onf Price jzpfvmygrnf/

yHk(5-6) 8/ xdkenf;twdkif;yif Cell B3 udk Amount [kajymif;vJEdkifygonf/ xdkYaemuf Cell B2 wGif 200 ESifh Cell B3 wGif 10 udk½dkufxnfhvdkufyg/ tajztm; Cell B4 wGif az:jyrnfjzpfí Cell B4 tm; Select vkyfNyD; Formula ud½k u kd x f nfyh grnf/ = Price * Amount qdkonfh Formula udk½dkufxnfhNyD;aemuf Enter key ESdyfvdkufygu tajz &&Syd grnf/yH(k 5-7)

64

uGefysLwmvufpJG

yHk(5-7)

Create a Formula that Contains a Function ( Formula wpfckudk Function jzifh udk,fpm;jyKwnfaqmufjcif; ) 9/ Formula udk Cell reference tjyif Function rsm;ESihf wJz G uftoH;k jyKEikd yf gonf/ Function qdo k nfrmS Excel wGif tqifoifhtoHk;jyKEdkifaom Formula rsm;jzpfygonf/ Oyrm- Worksheet xJ&Sd Cell range (B1:B4) rSm 10, 12, 14, 16 qdkonfh Constant d eygonf/ xdk Value rsm;udk aygif;vdkonf jzpfygap/ Simple Formula value rsm;&Sa ESifhaygif;rnfqdkygu " = B1+B2+B3+B4 " [k Formula a&;&ygrnf/ tu,fí Constant value rsm;pGmudk aygif;&rnfh tajctaewGif Formula udk &Snfvsm;pGm a&; &ygrnf/ xdu k o hJ aYkd omtcuftcJukd ajyvnfEikd &f eftwGuf Excel \ tqifoifhtoHk;jyK Edkifaom Function rsm;udk toH;k jyKEikd yf gonf/ txufyg 10, 12, 14, 16 wdkYudk Function toHk;jyKí aygif;rnfqdkvQif " = SUM(B1:B4) " [k a&;rnfqdkygu Formula tm;

&Snfvsm;pGm a&;om;&ef rvdkawmhyg/ Oyrm Function name

= SUM(B1:B4) Cell range

10/ xdk Formula udk B6 wGif ½dkufxnfhNyD; Enter key ESdyfvdkufygu tajz 52 [k az:jyay;ygrnf/ yHk(5-8)

65

Microsoft Excel 2002

yHk(5-8)

Create a Formula with Nested Function ( Formula wpfckudk Functions rsm;jzifhudk,fpm;jyKwnfaqmufjcif; ) 11/ Formula udk Cell reference tjyif Function rsm;ESihf wJzG uftoH;k jyKEikd yf gonf/ Function tm; wpfckxufydkí Formula xJwi G f xnfo h iG ;f toH;k jyKEikd yf gonf/ Function wpfckonf tjcm; Function wpfck\ Argument tjzpf toHk;jyKEdkifyHkudk OyrmwpfckESifh

az:jyygrnf/ ausmif;wpfausmif;wGi&f adS om ausmif;om;^olrsm;\ atmif^½I;H pm&if;udk Excel jzifh wGufcsufrIjyKvkyfEdkifygonf/ wpfbmomvQif tenf;qHk; trSwf 40 &&Sdygu atmifonf[k owfrSwfygonf/ Oyrm = IF ( Countif ( C2:G2, "<40")>=1, "Fail", "Pass")

12/ Excel taejzifh Function ESpcf u k kd Formula wpfaMumif;xJwiG f xnfo h iG ;f toH;k jyK xm;jcif;tm; awGY&SdEdkifygonf/ yxr Function rSm IF( ) jzpfNyD;? 'kwd,onf Countif ( ) jzpfygonf/ Countif( ) onf If ( ) \ Argument tjzpftoHk;jyKxm;jcif;udk awGU&Sd&ygrnf/þuJhodkYaom Function rsm;udk Nested function [kac:ygonf/ yHk(5-9) 13/ tu,fí If Function \ a&;enf;rsm;udk rod&ydS gu aemufwpfenf;udk toH;k jyKEikd f ygonf/ Cell I2 wGif Select vkyfNyD;? Formula bar ay:wGi&f dS Insert Function f x tm; Click vkyy f g/ Insert Function dialog box ay:vmygrnf/ Select a function atmuf&dS

uGefysLwmvufpJG

66

List box wGif If function udk&SmNyD; Select vkyy f g/ Ny;D ygu OK udk Click vkyyf g/ yH(k 5-

10)

yHk(5-9)

yHk(5-10)

14/ Function Arguments dialog box ay:vmygrnf/yHk(5-11),if; Dialog box &Sd If Logical_text box wGif Countif( C2:G2," <40" )>=1 ud k ½ d k u f x nf h N yD ; Value_if_true box wGif "Fail" udk ½du k x f nfyh grnf/ xdaYk emuf Value_if_false box wGif "Pass" udk½dkufxnfhNyD;aemuf OK udk Click vkyfygrnf/ xdktcg Worksheet ay:vmNyD;? tajzudkwGufNyD;jzpfaeonfudkawGU&ygrnf/ Function rsm;udk toHk;jyK&mwGif

67

Microsoft Excel 2002

Keyboard rS ½du k x f nfo h nfjzpfap? Insert function udk toH;k jyKonfjzpfap toH;k jyKrnfh Function \a&;om;enf ; ud k aocsmpG m em;vnf o abmayguf x m;&ef

vdt k yfrnfjzpfygonf/

yHk(5-11)

Worksheet Maths Operator ( Excel worksheet &Sd ocsmF qdik &f m Operator rsm; ) 15/ Microsoft Excel &Sd Worksheet wpfckwGif&Sdaom Calculation wpfcktwGuf Mathematical operators (4) rsKd;teuf wpfrsKd;rsKd;udk tenf;qHk;toHk;jyK&rnf jzpfyg onf/ 4if; Operator (4) rsK;d rSm (1) Arithmetic operators (2) Comparison operators (3) Text operators ESifh (4) Reference operators wdjYk zpfMuygonf/ Operators rsm;rSm

atmufygtwdkif;jzpfygonfArithmetic operators Symbol + ( plus sign ) _ ( minus sign ) * ( asterisk ) / ( slash ) % ( percent sign ) ^ ( caret )

Name plus minus Time Divided by Percent Exponent

Use for Addition Subtraction Multiplication Division Percentage Exponentiation

68

uGefysLwmvufpJG Comparison operators Symbol = ( equal sign ) > ( greater than sign ) < ( less than sign ) >= ( greater than or equal sign ) <= ( less than or equal sign ) <> ( not equal to sign )

Name Equal to Greater than Less than Greater than or equal to Less than or equal to Not equal to

Use for Equal Greater than Less than Greater than or equal Less than or equal Not equal

Text operators Symbol & ( ampersand )

Name Ampersand

Use for Connects, two values to produce continuous text value

Reference operators Symbol Name : ( colon sign ) Colon

, ( comma sign )

Comma

( space )

Space

Use for Range operator which produces one reference to all the cells between two references, including the two references. Union operator which combines multiple references into one reference. Intersection operator, which produces on reference to cells common to the two references.

Move or Copy a Formula ( Formula tm;a½GUajymif;jcif;ESifh ul;,ljcif; ) 16/ Microsoft Excel wGif Formula wpfcktm; wpfae&mrSwpfae&modkY Move vkyfjcif;onf xl;jcm;rIr&Sdaomfvnf; Copy jyKvkyfygu tajymif;tvJrsm;&Sdygonf/ tb,faMumifhajymif;vJ&oenf;qdkygu Absolute cell reference ESifh Relative cell

69

Microsoft Excel 2002

refrence aMumifhjzpfygonf/ þae&mwGif Absolute cell refrence ESifY Relative cell reference udk Oyrmwpfcp k ED iS t hf wl &Si;f jyygrnf/ Cell A1 wGif 10, Cell B1 wGif 12, Cell C1 wGif 14 ESifh Cell D1 wGif 16 ud½ k u kd x f nfyh g/ Ny;D aemuf Cell E1 rSm Formula jzpfaom = SUM ( A1:D1) udk½dkufxnfhNyD; Enter key ESdyfyg/ tajzjzpfaom 52 udkawGU&Sd&ygrnf/ xdk 52 &Sdaom Cell E1 udk Copy vkyfNyD; tjcm;wpfae&mwGif Paste vkyMf unfyh g/ xdt k cg tajz 0 jzpfaeygrnf/ Formula taeESifhvnf; Cell address rsm;ajymif;vJoGm;onfudkawGY&ygrnf/ xdk Cell address udk Relative cell reference [kac:ygonf/ Absolute cell address qdo k nfrmS Cell address rsm;udk wdwdusus

ñTeaf y;vdu k yf gonf/ Oyrm- puf0ikd ;f wpfc\ k {&d,mud&k mS onfyh akH oenf;tm; toH;k jyKNy;D wGufMunfh&eftwGuf/ Cell A1 wGif = PI( ) ud½k u kd x f nfyh g/ PI \ wefz;kd &ygrnf/ xdkYaemuf Cell A2 wGif 9 ud&k u kd x f nfyh g/ B2 wGif 10 ud&k u kd x f nfyh g/ Cell C2 wGif 12 udk &du k x f nfyh g/ Cell A4 wGif = $A$1*A2^2 udk½dkufxnfhNyD; Enter key ESyd yf g/ tajz 254.469 &ygrnf/ Cell A4 udk Select vkyfí nmzufudk Autofill vkyMf unfy h g/ Cell A4 rS Formula rsm;ul;0ifoGm;onfudk awGU&Sd&ygrnf/ Ctrl+ `( grave accent ) udkESdyfí Formula view udMk unfy h g/yH(k 5-12) xdt k cg Formula twGif;&Sd Relative cell refrence rsm;ajymif;vJoGm;NyD; Absolute cell refrence onf Cell address ( $A$1 ) tm; wduspGm ñTefay;xm;onfhtwGuf ajymif;vJjcif; r&Sdonfudk awGU&ygrnf/

yHk(5-12) Creating Names 17/ Name ESiyhf wfoufNy;D a&SUydik ;f wGiaf z:jyNy;D jzpfygonf/ Formula wpfckwGif Cell reference rsm;udk toHk;jyKNyD; wGufcsufrIrsm;onf rSwfom;&ef cufcJygonf/ Formula wGif Cell reference tpm; names ESiw hf u G cf suyf gu rSwo f m;&ef ydrk v kd , G u f yl gonf/ Oyrm- = B7 - E7 [k ay;xm;aom Formula udk = Gross Pay - Deduction [k ay;aomtcg ydkrdkítqifajyygonf/ Names reference rsm;udk Workbook twGif;rS

uGefysLwmvufpJG

70

BudKuf&m Worksheet wpfckckwGif toHk;jyKEdkifygonf/ tu,fí Names reference wpfckudk Worksheet wpfckwGif jyifqifvdkufyguvnf; tjcm; Worksheet rsm;wGif tvdktavQmuf jyifNyD;om; jzpfoGm;ygrnf/ 4if;udk Update vkyjf cif;[k qkEd ikd yf gonf/ xdaYk Mumifh Names reference rsm;onf Cell reference xuf toH;k jyK&ydrk v kd , G u f yl gonf/ 18/

Name wpfcu k kd owfrw S rf nfqykd gu vdu k ef m&eftcsurf sm; &Syd gonf/ 4if;wdrYk mS name wpfck\tp pmvHk;onf Letter (odkYr[kwf) Underscore jzpf&ygrnf/ Name onf ( _ ) Underscore, ( . ) Period udk vufcHaomfvnf; uGufvyfrsm; (Space) rsm;udk vufrcHyg/ Name wpfckudk Character 255 vHk;txd a&;cGifh&Sdygonf/

19/ Name wpfckudk Create jyKvkyfenf;udk Oyrmwpfckjzifh avhvmMunfhygrnf/ aowåmwpfck\ xkxnfudk &Smrnfqdkygu 4if; aowåm\ tvsm;? teH ESifh tjrifh rsm;udk ajrm§ uf&ygrnf/ tvsm;udk Length ? teHudk Width ESifh tjrifhudk Height [kxm;rnf qdkygu yHkaoenf;onf = Length x Width x Height jzpfygrnf/ Worksheet twGif;ü atmufygtwdkif; az:jyygrnf(u) Cell A1 rS B3 txd Select vkyyf g/ ( c ) Insert menu udk Click vkyyf gu Pull down menu usvmrnf/ 4if;rS Name udk Click vkyy f g/ Sub menu wpfckay:vmrnf/ ay:vmaom Sub menu rS Create command udk Click vkyy f g/ Create Names dialog box ay:vmrnf/ yHk(5-13) Create names in atmuf&Sd Left f g/ Check mark ay:vmrnf/ column check box wGif Click vkyy OK udk Click vkyy f g/ qdv k o kd nfrmS b,fzuf Column twGif;&Sd Names rsm;udk Cell reference tpm; Names tjzpfowfrSwfaMunmay;jcif; jzpfygonf/ wpfenf;tm;jzifh Create Name jyKvyk jf cif; jzpfygonf/ (*) Ny;D ygu Formula udk Name rsm;jzifh atmufygtwdkif; az:jywGufcsuf Edik Nf yD jzpfygonf/ yH(k 5-14) Column A &Sd trnfrsm;onf Column B rS Cell rsm;twGuf Name rsm;jzpfomG ;ygonf/ Column B wGif;&Sd Cell B1 tm; Select vkyfrnfqdkygu Cell reference area xJwGif B1 [kazmfjyjcif;rjyKyg/ Length [komaz:jyay;ygrnf/ Cell B1 wGif 10 udk ½du k x f nfah y;ygu Formula bar wGif 10 [kay:aeygrnf/ qdv k o kd nfrmS Length = 10 [k Excel u od&e dS m;vnfomG ;ygrnf/ xdaYk Mumifh Volume = 100 [k Excel u tajzxkwfay;ygonf/

71

yHk(5-13)

yHk(5-14)

Microsoft Excel 2002

72

uGefysLwmvufpJG

Chapter (6) Charts And Drawing

1/ Microsoft Excel wGif pm&if;Z,m;tcsuftvufrsm;udk &Sif;vif;vG,fulpGm od&SdapEdkif&efESifh ydkrdkxda&mufonfh wifjyrIudk&&Sdatmif Chart udk toH;k jyKMu&ygonf/ Excel 2002 wGif Chart trsKd;tpm;aygif;rsm;pGmyg0ifNyD; toHk;rsm;aom Chart type rsm;rSm Column chart, Bar chart, Line chart, Pie chart, Area chart, 3D-Column chart, 3D- Bar chart, 3D-Pie chart ponfwjYkd zpfMuygonf/ Displaying the Chart and Drawing Toolbar ( Chart and Drawing Tool bar rsm;tm;az:jyjcif; ) 2/ Microsoft Excel rSm Chart tool bar wpfc& k ydS gonf/ ,if; Chart tool bar udk

az:jyvdkvQif atmufygtwdkif; aqmif½GufEdkifygonf(u) View menu udk Click vkyyf g/ pull down menu ay:vmrnf/ ( c ) Toolbars udk Point vkyyf g/ Sub menu ay:vmrnf/ ( * ) 4if; Sub menu rS Chart udk Click vkyyf g/ Click vkyNf y;D ygu Chart qdkaom Command \ a&SUwGif Check mark wpfck ay:vmrnf/ yHk(6-1) Chart tool bar onfvnf; Excel window wGifay:aeygrnf/ Chart toolbar udk jyefaysmufapvdkvQif txufygtwdkif; aqmif½Gufí Chart qdkaom Command udk Click vkyy f g/ Check mark jyefaysmuf oGm;ygrnf/ xdktcg Chart tool bar onfvnf; Excel window rS aysmufomG ;ygrnf/

yHk(6-1)

73 3/

Microsoft Excel 2002

Microsoft Excel rSm Drawing tool bar wpfc& k ydS gonf/ ,if; Drawing tool

bar udk az:jyvdkvQif atmufygtwdkif;aqmif½GufEdkifygonf(u) View menu udk Click vkyyf g/ Pull down menu ay:vmrnf/ ( c ) Toolbars udk Point vkyyf g/ Sub menu ay:vmrnf/ ( * ) 4if; Sub menu rS Drawing udk Click vkyfyg/ Click vkyfNyD;ygu Drawing Command \a&SUwGif Check mark wpfckay:vmrnf/ Drawing tool bar onfvnf; Excel window \atmufwGif ay:ae ygrnf/ Chart toolbar udk jyefaysmufapvdkvQif txufyg enf;twdkif; aqmif½Gufí Drawing Command udk Click vkyyf g/ Check mark jyefaysmufomG ;ygrnf/ xdt k cg Drawing tool bar onf Excel window

rS aysmufomG ;ygrnf/ Creating Charts with the Chart Wizard Tool ( Chart Wizard Tool jzifh Chart wpfcktm;wnfaqmufjcif; )

4/

Microsoft Excel wGif Chart wizard tool

wpfck yg&So d nf/ ,if;udk Standard tool bar ay:wGif az:jyxm;ygonf/ Chart wizard udk toH;k jyKí Z,m;wpfck udk atmufygtwdkif; Chart wpfcktjzpf a&;qJGEdkifygonf(u) Chart qJv G akd om Data rsm;udk Select vkyyf g/ Select vky&f mwGif owdjyK &rnfh tcsufrSm Z,m;&Sd Field name rsm;udyk g Select vky&f ygrnf/ yHk(6-2)

Field name

yHk(6-2)

uGefysLwmvufpJG (c)

74

Toolbars ay:&Sd Chart Wizard icon udk Click vkyy f gu Chart Wizard - Step 1 of 4 -Chart type dialog box ay:vmrnf/yHk(6-3) Step 1 of 4 onf Chart type rsm;udk a½G;cs,fay;&efjzpfonf/ 4if;wGif Standard Types tab ESifh Custom Types tab wdy Yk g&Syd gonf/

yHk(6-3)

( *)

(C)

Standard Types tab udk a½G;cs,y f g/ Chart type: list box &Sd Column udk a½G;cs,yf g/ nmzuf Chart sub-type: &Sd Clustered column with a 3-D visual effect udk a½G;cs,y f g/ Press and Hold to View Sample button udk Press vkyx f m;jcif;jzifh Preview MunfEh ikd yf gonf/MuKd uEf pS o f uf rI r&Syd gu Chart sub-type aemufwpfckudk ajymif;vJa½G;cs,fEdkifygonf/ NyD;vQif Next button udk Click vkyyf g/ Chart wizard - Step 2 of 4 - Chart Source Data dialog box ay:vm rnf/ yH(k 6-4) Step 2 of 4 onf Chart Source Data dialog box jzpfygonf/ ,if;wGif Data range tab ESifh Series tab [lí Tab ESpfck yg&Syd gonf/ Data range tab wGif Data range udk tvdkvdk a&G;cs,fay; ygrnf/ Series in: Options wGif Rows (odrYk [kw)f Columns ESpo f uf&m udak &G;cs,yf g/ Columns Options udk a½G;cs,Nf y;D Next udk Click vkyyf g/

75

Microsoft Excel 2002

yHk(6-4)

(i )

Chart Wizard - Step 3 of 4 - Chart Options dialog box ay:vmrnf/ yHk(6-5) Step 3 of 4 onf Chart Options dialog box jzpfygonf/

yHk(6-5)

uGefysLwmvufpJG

(p)

Chart title ? X-axis ESifh Y-axis trnfrsm;udk ½dkufxnfhay;Edkifygonf/ NyD;aemuf Next button udk Click vkyyf g/ Chart Wizard - Step 4 of 4 - Chart Location dialog box ay:vmrnf/ yHk(6-6) Step 4 of 4 onf Chart Location dialog box jzpfygonf/ aemufqHk; Wizard onf Chart udk Z,m;ESifhtwl xm;rnf (odkYr[kwf) tjcm; Sheet wpfckckwGifxm;rnfudk a&G;cs,fay;&ygrnf/ As object f gu Z,m;ESit hf wlay:vmygrnf/ Ny;D aemufFinish in: option udk a½G;cs,y f gu Chart wpfcak y:vmygrnf/ Chart udk vdt k yf button udk Click vkyy ovdk csKUH jcif;? csUJ jcif;jzifh Munfí h aumif;aom Chart wpfcu k &kd &Sv d mygrnf/

yHk(6-7)

yHk(6-6)

yHk(6-7)

76

77

Microsoft Excel 2002

Changing the Chart Type ( Chart type tm; ajymif;vJjcif; ) 5/ Chart wpfcak &;qJNG y;D aomfvnf;aumif;? a&;qJc G ahJ omChart udk rBuKd ucf v hJ Qiaf omf vnf;aumif;? tjcm; Chart type wpfco k Ykd ajymif;vJcsiv f Qiaf omfvnf;aumif;? ajymif;vJ

Edkif&eftwGuf atmufygtwdkif; aqmif½GufEdkifygonf(u) ajymif;vdkaom Chart udk Select vkyyf g/ tu,fí Select rvkyrf yd gu Chart menu ay:aernfr[kwfyg/ ( c ) Chart menu udk Click vkyfyg/ Pull down menu ay:vmrnf/ 4if;rS Chart Type command udk Click vkyyf g/ Chart type dialog box ay:vmrnf/ yH(k 6-8) 4if;rS MuKd uE f pS o f uf&m Chart type ESifh Chart sub-type wdkYudka&G;cs,fay;yg/ NyD;aemuf OK udk Click vkyy f g/

yHk(6-8)

uGefysLwmvufpJG

78

Formatting Chart ( Chart rsm;tm;jyifqifjcif; )

6/ Chart wpfcka&;qJGNyD;aomfvnf; a&;qJGcJhaom Chart wGijf yifqifva kd om tcsuf rsm; yg&SEd ikd yf gonf/ Chart wpfckudk Format jyKvkyfvdkvQif rnfonfhtydkif;udk Format vkyfvdkonfudk od&Sd&ayrnf/ Chart wpfckwGif atmufygwdkYonf Format vkyfEdkifaom tydkif;rsm;jzpfygonf(u) Format Walls - Chart \ aemufcH Background udk jyifqifjcif;/ ( c ) Format Data Series - Chart wpfck\ Data udk udk,fpm;jyKonfh *&yf yHkrsm;/ ( * ) Format Axis - Chart wpfc\ k 0ef½;kd rsm;/ (C) Format Chart Title - Chart wpfck\acgif;pOf/ ( i ) Format Axis Title - Chart wpfck\ 0ef½dk;trnfrsm;/ ( p ) Format Legand - Chart wpfc\ k tñTe;f rsm;/ (q) Format Plot Area - Chart a&;qJGonfh tjyif{&d,m/ (Z) Format Chart Area - Chart a&;qJGonfh twGif;{&d,m/ 7/ Chart wpfckudk Format jyKvkyfvdkvQif Format jyKvkyfvdkaomtydkif;udk Select vkyyf g/ Ny;D aemuf Mouse pointer jzifh Right click vkyyf g/ Shortcut menu ay:vmrnf/ 4if;rS oufqdkif&m Format command udk Click vkyfjcif;jzifh jyifvdkaomt&mrsm;udk jyifqifEikd yf gonf/ yH(k 6-9)

yHk(6-9)

79

Microsoft Excel 2002

Set up a chart for printing ( Printing twGuf Chart wpfckwnfaqmufjcif; )

8/ Chart wpfckudk a&;qJGNydD; pmrsufESmay:odkY½dkufxkwf&eftwGuf Chart \ tae txm;ESifh yHko@mefudk jyifqifay;Edkif&ef jyKvkyf&rnf jzpfygonf/ Page break view udk toHk;jyKíatmufygtwdkif;aqmif½Gufay;Edkifygonf(u) Worksheet twGif; Chart area \tjyifbufudk Click vkyyf g/ ( c ) View menu rS Page Break Preview udk Click vkyyf g/ atmufyg twdik ;f Page Break Preview jrifuiG ;f udk awGUEdik yf gonf/yH(k 6-10)Chart udk vdktyfovdk jyifqifajymif;a½GUí Print jyKvyk Ef ikd yf gonf/

yHk(6-10)

uGefysLwmvufpJG

80

A chart sheet

9/ Chart sheet ay:½dS Chart wpfckudk Printed page ay:odkYwifEdkif&eftwGuf t½G,ftpm;ESifh pau;rsm;udk ajymif;vJjyifqifay;&efvdktyfrnf jzpfygonf/ ajymif;vJyHk tqifhqifhrSm atmufygtwdkif;jzpfygonf(u) Chart yHkudk Click vkyí f a½G;yg/ (c) File Menu rS Page Setup udk Click vkyyf g/ (*) Chart tab udk Click vkyfí Options rsm;udk a½G;yg/ yHk(6-11)

yHk(6-11) rSwfcsu/f

Chart t½G,t f pm;ESiyhf o kH @mefukd jyifqifvykd gu Chart tab ay:&Sd Custom option udka½G;í OK udk Click vkyf NyD;aemuf Chart sheet odYk jyefomG ;Ny;D jyifqifyg/

81

Microsoft Excel 2002

Using Drawing ( Drawing toHk;jyKjcif; ) 10/ Microsoft Excel 2002 wGif Drawing Tool bar yg&Syd gonf/ Drawing Tool bar udkzGifhvdkvQif View menu udk Click vkyy f g/ Pulldown menu ay:vmrnf/ 4if;rS Toolbars udk a&G;cs,y f g/ Sub Menu ay:vmrnf/ 4if;rS Drawing wGif Mouse jzifh Click vkyfí Check mark ay;jcif;jzifh Drawing Tool bar onf Window \ atmufajcwGif ay:vmonfudk awGUEdkifygonf/ (odkYr[kwf) Standard Tool bar ay:&Sd vGwfaeaom ae&mwGif Mouse jzifh Right click vkyyf g/ Context menu ay:vmrnf/ 4if;wGif Drawing udk Mouse jzifh Click vkyjf cif;jzifh Drawing Tool bar onf Window

\ atmufajcwGif ay:vmygrnf/ yHk(6-12)

yHk(6-12) 11/ Drawing Tool bar ay:&Sd Auto Shapes drop down list box wGif Line style rsm;? Connectors rsm;? Basic shapes rsm;? Block arrows rsm;? Flowchart rsm;? Stars and Banners rsm;ESifh Callouts rsm;yg&So d nft h jyif More Autoshapes command wGiv f nf; tqifoift h oH;k jyKEikd af om ½kyyf rkH sm;yg&Syd gonf/ WordArt Gallery &Sd WordArt style rsm;onfvnf; aumif;rGefNyD; toHk;jyK&onfrSm tqifajyygonf/ Diagrams rsm;? Organization chart rsm;udkvnf; vG,fulpGm Insert jyKvkyfay;Edkifygonf/ Clip Art yHkrsm;ESifh Picture File rsm;udkvnf; Insert jyKvyk Ef ikd yf gonf/ Text color rsm;? Line color rsm;ESifh Fill color rsm;vnf;yg&Sy d gonf/ Line a&;qJG&mwGifvnf; Line style trsKd;rsKd;? Line weight trsKd;rsKd;udk toHk;jyKEdkifygonf/ Shadow style ESifh 3-D style trsKd;rsKd;udkvnf; pdwfwdkif;us a½G;cs,ftoHk;jyKEdkif&ef pDpOfay;xm;ygonf/ Microsoft Excel ü Worksheet twGif; Drawing rsm;a&;qJG&mwGif Worksheet cell rsm;ESifh Drawing yHkrsm;onf wpfoD;wpfjcm;jzpfaeonfudk awGU&ygrnf/

uGefysLwmvufpJG

82

Symbols for Drawing Object ( Drawing Object \oauFwrsm; ) 12/ Drawing object wpfck\ Symbols taetxm;udk azmfjy&ef ESifh xdk Object udk udkifwG,fxdef;odrf;Edkif&ef 4if;wdkY\ Symbols rsm;udk atmufygtwdkif;od&Sd&ef

vdktyfrnfjzpfygonf(u) Sizing Handles / Drawing object tcsKdUudk Select vkyyf gu yH(k 6-13) ygtwdik ;f ay:vmygrnf/ ay:vmaom Handles rsm;udk Mouse jzifh Drag vkyyf gu Object \t½G,ftpm;udk csKHU^csJU Edkifonfudk awGU& ygrnf/ yHk(6-13)

( c)

Rotate Handle/ Drawing objecttcsKdUudk Select vkyfygu yHk(6-14) ygtwdkif; tpdrf;a&mif Handle t0dkif;av;wpfck ay:aernfqdkvQif Object tm; xdk Handle rS Drag vkyfjcif;jzifh Rotate jyKvy k Ef ikd yf gonf/

yHk(6-14) ( *)

Adjustment Handle / Drawing object tcsKdUudk Select vkyy f gu yHk(6-15)ygtwdkif; t0ga&mif Adjustment handle wpfckay:aeygrnf/ Object tm; xdk Handle rS Drag vkyy f gu Drag vkyo f nfzh ufoYkd apmif;

oGm;ygrnf/

yHk(6-15)

83 (C)

Microsoft Excel 2002

Vertex / Freeform drawing object jzif h vd k i f ; (od k Y r [k w f ) *&yfwpfckudka&;qJGNyD; Select vkyfygu yHk(6-16)twdkif; teufa&mif av;axmifh Handles rsm;onf vdkif; (odkYr[kwf) *&yf\xdyf Vertex wGif ay:aeygrnf/ xdk Object &Sd Handle rsm;udk Drag vkyyf gu Object

\yHko@mefajymif;oGm;onfudk awGY&ygrnf/ yHk(6-16)

( i)

Hatched border / Text box wpfck\ywfywfvnfwGif rsOf;apmif; rsm;jzifhzJGUpnf;xm;aom Border udk Hatched border [kac:ygonf/ yHk(6-17) wGif Hatched border wpfckudk az:jyxm;ygonf/ Hatched border ay:aevQif Text rsm;udk ½du k x f nfjh cif;? Delete vkyjf cif;? Select vkyfjcif;? twGif;&Sd Text format rsm;udjk yifqifEikd yf gonf/

yHk(6-17)

( p)

Dotted border / Text box wpfck\ywfywfvnfwGif tpufuav; rsm;jzifh zJGUpnf;xm;aom Border udk Dotted border [kac:ygonf/ yHk(6-18) wGif Dotted border wpfckudk az:jyxm;ygonf/ Dotted border ay:aevQif Text box udk Format jyKvy k Ef ikd yf gonf/ Hatched border udk Click vkyy f gu Dotted border jzpfvmygrnf/

yHk(6-18)

84

uGefysLwmvufpJG

Draw a Freeform shape ( Freeform shape udka&;qJGjcif; ) 13/ Microsoft Excel &Sd Drawing Tool bar ay:wGif Freeform shape udk

atmufygtwdkif;a&;qJGEdkifygonf(u) Drawing Tool bar ay:&Sd AutoShapes menu udk Click vkyyf g/ Pull down menu wpfckay:vmrnf/ xdk Menu xJwGif Line command udk Point vkyy f gu Freeform command udak wG&Y ydS grnf/ 4if;udk Click vkyyf g/yH(k 6-19) ( c ) Freeform jzifh Lines rsm;? Graph *&yfrsm;\ Segments udka&;qJG Edkifygonf/ ( * ) Lines (odkYr[kwf) Graph udka&;qJG&ef Mouse jzifh Drag vky&f ygrnf/ a&;qJGNyD;ygu Double click vkyyf g/ Freeform yHw k pfc&k &Syd grnf/ (C) Object \ Shape udk Closed vkyv f ykd gu Starting point \teD;wGif Mouse udk Click vkyy f g/ (i) a&;qJo G nfh Lines (odrYk [kw)f Graph udk Smooth jzpfvykd gu Freeform uJhodkY Scribble command udk toH;k jyKEikd yf gonf/

yHk(6-19)

Draw a Flowchart ( Flowchart udka&;qJGjcif; ) 14/ Microsoft Excel &Sd Drawing Tool bar ay:wGif Flowchart udk atmufyg

twdkif;a&;qJGEdkifygonf(u) Drawing Tool bar ay:&Sd AutoShape menu udk Click vkyyf g/ Pull down menu wpfcak y:vmrnf/ xdk Menu xJwGif Flowchart command

85

Microsoft Excel 2002

udk Point vkyyf gu Flowchart style rsm;udak wG&Y &dS ygrnf/ yH(k 6-20)4if;udk Click vkyfNyD; Worksheet xJwGif Drag vkyfygu a½G;cs,fxm;aom Flowchart ay:vmygrnf/

yHk(6-20)

(c )

(* )

txufygenf;twdkif; Flowchart style rsm;udka½G;cs,fí Worksheet ay:wGif Drag qJGNcif;jzifh vdktyfaom Flowchart design wpfckudk &&Sd ygrnf/ Flowchart wpfckESifh wpfcktMum; Connectors rsm;udk wyfqifay;Edkif ygonf/ yH(k 6-21)

yHk(6-21)

uGefysLwmvufpJG

86

Draw a Curve (Curve a&;qJGjcif;) 15/ Microsoft Excel &Sd Drawing Tool bar ay:wGif Curve udk atmufygtwdkif;

a&;qJGEdkifygonf(u) Drawing Tool bar ay:&Sd AutoShapes menu udk Click vkyyf g/ Pull down menu wpfckay:vmrnf/ xdk Menu ½Sd Line command tm; Point vkyy f gu Curve command udak wG&Y ydS grnf/ 4if;udk Click vkyyf g/ yHk(6-22)

yHk(6-22)

(c)

(*)

Pointer shape onf Plus sign yHjk zpfygonf/ Curve udak &;qJ& G ef Mouse jzifh Drag vky&f ygrnf/ a&;qJNG y;D ygu Double click vkyyf g/ Curve yHk

wpfck &&Syd grnf/ Object \ Shape udk Closed vkyv f ykd gu Starting point \teD;wGif Mouse udk Double Click vkyy f g/

Add a Diagram ( Diagram a&;qJGjcif; ) 16/ Microsoft Excel &Sd Drawing Tool bar ay:wGif Diagram udk atmufyg

twdkif;a&;qJGEdkifygonf(u) Drawing Tool bar ay:&Sd Diagram button udk Click vkyfyg/ Diagram gallery dialog box wpfckay:vmrnf/yHk(6-23) xdk Dialog box xJ&Sd Select a diagram type: atmuf&Sd Venn, Cycle, Pyramid, k u k akd ½G;yg/ Ny;D aemuf OK udk Click vkyyf g/ Target ESifh Radial type wpfcc yHk(6-24)wGif awGY&onfhtwdkif; a½G;cs,fvdkufaom Diagram ay:vm ygrnf/

87

Microsoft Excel 2002

yHk(6-23)

yHk(6-24)

(c )

Diagram &Sd Element wpfckcsif;pDwGif Text rsm;udk ñTef;vdkygu ñTef;vdkaom Element \ Click to add text udk Mouse jzifh Click vkyyf g/ Text box ay:vmygu Text udk ½du k x f nfyh g/ rSwfcsuf/ Cycle ESifh Target diagram rsm;wGif Diagram udk Insert jyKvyk pf Ofuyif Text placeholder rsm;yg&SNd y;D jzpfygonf/

uGefysLwmvufpJG (*)

88

&SdNyD;om; Diagram xJoYdk aemufxyf Element wpfckxyfwdk;vdkvQif Diagram toolbar ay:&Sd Insert shape udk Click vkyfyg/yHk(6-25) avsmhvdkvQif Element udk Select vkyfí Right click vkyyf g/ Context f g/ menu wpfck ay:vmrnf/ 4if;rS Delete shape udk Click vkyy

yHk(6-25) (C)

Diagram \ Style udkajymif;vJvdkvQif Diagram toolbar ay:&S d

udk Click vkyyf g/ Diagram style gallery dialog box ay:vmrnf/yHk(6-26) Select a diagram style atmuf&Sd ESpfouf&m Style wpfckudk a½G;yg/ NyD;aemuf Apply button udk Click vkyyf g/ NyD;vQif Drawing \tjyifzufwGif Click vkyyf g/ Autoformat button

(i)

89

Microsoft Excel 2002

yHk(6-26) Add or remove a Shadow ( Shadow xnfhjcif;(odkYr[kwf) jzKwfjcif; ) 17/ Microsoft Excel &Sd Drawing Tool bar ay:wGif Shadow button wpfck yg&Sdygonf/ Picture rsm;? Autoshape rsm;? WordArt rsm;ESifh Text box rsm;wGif Shadow rsm;udk xnfhEdkifygonf/ Shadow xnfhvdkvQif atmufygtwdkif;aqmif½Guf

Edik yf gonf(u) (c ) (*)

Shadow xnfhvdkaom Object udk Select vkyy f g/ Drawing Tool bar ay:&Sd Shadow button udk Click vkyy f g/ Shadow style rsm;ygaom Sub menu wpfckay:vmrnf/ ESpfouf&m Shadow style wpfcu k akd ½G;yg/

uGefysLwmvufpJG (C)

90

yHk(6-27) ygtwdkif; Shadow style wpfck ay:vmygrnf/

yHk(6-27) (i)

tu,fí Shadow style udk rvdkí jzKwfcsifvQif Shadow button udk Click vkyfí Menu ay:vmaomtcg tay:qHk;&Sd No Shadow command udk Click vkyfygu xnfhoGif;xm;aom Shadow jyefjyKwf oGm;ygrnf/

91

Microsoft Excel 2002

Chapter (7) Using Database Working with database 1/ Microsoft Excel wGif Worksheet rsm;twGi;f ü pm&if;Z,m;tcsut f vufrsm; udk xnfhoGif;wnfaqmufjcif;onf Database wpfckwnfaqmufjcif;jzpfygonf/ Data entry form wpfckwnfaqmufí Data rsm;udk Worksheet twGif;odkY xnhfoGif;Edkifyg onf/ Data rsm;udk Worksheet twGif; xnfhoGif;wnfaqmufNyD;ygu List wpfck &&Sv d mygrnf/ xdk List wGif yg0ifaom Rows rsm;udk Records [k ac:ygonf/ xdk List wGif Row heading label rygaomfvnf; Column heading label yg&Syd grnf/ xdk Column wpfcpk w D iG yf gonfh Information rsm;udk Field [kac:ygonf/ Record qdo k nfrmS Field rsm;ESifY zJGUpnf;xm;NyD;? Field rsm;\xdyfwGif Field Name yg&SdonfhZ,m;wpfckudk

avhvmMunfhygrnf/ yHk(7-1)

yHk(7-1) 2/

yH(k 7-1)ygZ,m;onf Examination Result wpfcjk zpfygonf/ 4if; List wGif Field name 10 ck yg&So d nf/ yxrOD;qH;k Field name rSm Roll No. jzpfNyD;? aemufqHk; Field name rSm Result jzpfygonf/ owdjyK&rnft h csurf mS List xJwiG f Record rsm;udk Row ausmfí rxnfhoGif;&yg/ xdkuJhodkYxnfhoGif;cJhygu Microsoft Excel wGif Data f g/ Record rsm;udk List menu atmuf&Sd Commands rsm;udk toH;k jyKí&rnfr[kwy

uGefysLwmvufpJG

92

wGif jznhfpGufonfhtcgwGif Worksheet xJrmS Data jznfo h uJo h yYkd if jzpfygonf/ wpfenf; tm;jzifh Data jznfph u G &f eftwGuf Data menu atmuf&dS Form command udk toH;k jyKNy;D jznfEh ikd yf gonf/ owdjyK&efrmS Data menu udkrzGifhrD Selector udk Worksheet twGif; &Sd Data xJoUdk ydx Yk m;&ygrnf/Forms qdo k nfrmS Data rsm;udk tvG,w f uljznfí h &&Sad p&ef Excel rSzefw;D ay;xm;aom yHp k jH zpfygonf/yH(k 7-2) 4if;wGif Field name rsm; toifah y: aeygrnf/ New command button rSm Data topfxnfv h ykd gu Click vky&f ygrnf/ Delete rSm vuf&adS y:aeaom Record data rsm;tm; zsuo f nfah e&mwGif toH;k jyKygonf/ Fine Prev rSm vuf&dS Record \ a&SUydkif;&Sd Record data rsm;udk Munfhjcif;jzpfNyD;? Find Next onf vuf&Sd Record \ aemufydkif;&Sd Record data rsm;udk Munfjh cif;jzpfygonf/ Criteria rSm od&Sdvdkaom taMumif;t&mwpfckudk Condition ay;NyD;&Smjcif;jzpfygonf/ Oyrm - Data form xJ&Sd Criteria udk ESdyfNyD; maths: list box wGif " = 100 " udk ½dkufxnfhí Find prev (odkYr[kwf) Find Next button udk ESdyfvdkufygu udkufnDrI&Sdaom Record rsm;udk az:jyay;ygrnf/ Close button rSm Data rsm;udk ½dkufxnfh&efr&Sdygu Form udkjyefydwf&eftwGuf toHk;jyKygonf/

yHk(7-2)

Sorting a list ( Z,m;wpfcktm; pDpOfjcif; ) 3/ Examination result database list udk tpDtpOftrsKd;rsKd;jzifh pDpOfEdkifygonf/ 4if;udk Sort vkyfonf[k ac:ygonf/ Database wpfckwGif Sort vkyv f ykd gu Database xJwGif Selector xm;&ygrnf/ Ny;D aemuf Data menu rS Sort command udk Click

93

Microsoft Excel 2002

vkyyf g/ Sort dialog box ay:vmygrnf/ yHk(7-3) Sort by atmuf&Sd Drop down list wGif Total udk ½du k x f nfyh g/ (odrYk [kw)f Drop down arrow udk Click vkyfNyD; Total udka½G;yg/ xdkYaemuf Descending option udk a½G;cs,fí Click vkyyf g/ My list has atmuf&Sd Header row option udk a½G;í Click vkyyf g/ Ny;D aemuf OK udk Click vkyyf g/ Total marks rsm;udk MuD;pOfi,fvdkuf pDpOfay;vdkufonfudk awGU&ygrnf/

yHk(7-3)

4/ Microsoft Excel \ Sort dialog box onf wpfNydKifwnf; Field name (3)ck udk pDpOfay;Edkifygonf/ Oyrm- Total field name udk Descending ? Name udk Ascending ESifh Roll No. udk Ascending xm;NyD;? OK ay;vdkufygu Total udk yxr OD;pm;ay; pDpOfygrnf/ trSwfwlnDaevQif Name udk 'kwd,OD;pm;ay; pDpOfay;ygrnf/ trSwfESifhtrnf wlnDaevQif Roll No. jzifh wwd,OD;pm;ay; pDpOfay;rnf jzpfygonf/ Using AutoFilter ( tcsuftvufrsm;ppfjcif; ) 5/ Database wpfcw k iG f rdrt d vd&k adS om Data wpfct k m; tvG,w f ula½G;xkwjf cif;udk Filter vkyfonf[k ac:ygonf/ Microsoft Excel wGif Filter (2) rsKd;&Sdygonf/ AutoFilter ESihf Advanced Filter jzpfygonf/ Filter onf List ESir hf wlnyD g/ List onf Database &Sd Record data rsm;udk Ascending or Descending pDpOfay;ygonf/ Filter onf Criteria ESifhrnDñGwfaom Data rsm;udk az:jyay;rnf r[kwfyg/ Criteria ESifh

uGefysLwmvufpJG

94

udkufnDaom Data rsm;udo k m List vkyaf y;rSm jzpfygonf/ Filter jyKvkyfxm;aom Data rsm;udk Format vkyfjcif;? Print vkyjf cif;udv k nf; cGijhf yKxm;ygonf/ Database wpfckrS AutoFilter jyKvkyfyHktqifhqifhudk atmufwGif az:jyxm;ygonf(u) AutoFilter vkyfvdkaom Database twGif;odkY Selector xm;yg/ ( c ) Data menu rS Filter udk Point vkyfyg/ ay:vmaom Submenu rS Autofilter udk Click vkyy f g/ xdt k cg Field name rsm;\ nmzufwGif Down arrow rsm;ay:vmonfudk awGU&ygrnf/ þtaetxm;onf Data rsm;udk ppfxkwf&ef tqifoifhjzpfaeygrnf/ (*) az:jyygyHk(7-4)&dS Database udMk unfyh g/

yHk(7-4)

6/

yHk(7-4)ygZ,m;onf wuúodkvfq&mrsm;\ Database wpfckjzpfygonf/4if; Database rS Sex udk cJjG cm;í ppfxw k Mf unfyh grnf/ a,musmf ;q&mrsm;udo k m ppfxw k v f kd vQif atmufygtwdkif; aqmif½GufEdkifygonf-

95 (u) (c )

Microsoft Excel 2002

Sex field name &Sd Down arrow udk Click vkyy f g/ Drop down list

wpfcx k u G af y:vmygrnf/ 4if;wGif All, Top 10, Custom, F ESifh M yg&Syd gonf/ F( Female) udk a½G;cs,yf g/ xdt k cg a,mufsm;q&mrsm;omygaom ppfxw k Nf y;D Database wpfckudk awGU&Sdygrnf/ yHk(7-5)

yHk(7-5)

(* )

Sex field name &Sd Down arrow onf tjyma&mifodkY ajymif;vJoGm; onfudk awGY&Sd&ygrnf/ rlv Database twdik ;f jyefay:vdv k Qif xdk Down arrow udk Click vkyfyg/ ay:vmaom List rS All udk a½G;cs,v f u kd yf gu rlv Database twdkif;jyefay:vmygrnf/

7/ qufvufí Database rS &efuek w f uúov kd ?f ocsmF XmerS q&mrsm;udo k m ppfxw k f vdkvQif atmufygtwdkif;aqmif½GufEdkifygonf(u) University field name &Sd Down arrow udk Click vkyyf g/ Drop down list wpfcu k svmygrnf/ (c) 4if;xJwiG f (All)? (Top 10)? (Custom) ? Bago? Mandalay? Myintkyina? Pathein? Pyay ESifh Yangon wdy Yk g&Syd gonf/ 4if;rS Yangon udak ½G;cs,yf g/ xdt k cg &efuek &f q dS &mrsm;omygaom Database wpfckudk awGU&Sdygrnf/

uGefysLwmvufpJG (*)

96

wzef ocsFmXme½Sdq&mrsm;udk ppfxkwfEdkif&ef Department field name &Sd Down arrow udk Click vkyyf g/ Drop down list wpfck usvmygrnf/ yHk(7-6)

yHk(7-6)

(C)

4if; list xJwGif(All)? (Top 10)? (Custom) ? Biology? Chemistry? Maths:? Physics wdkY yg&Sdygonf/ Maths: udk a½G;cs,fygu &efukef wuúodkvf? ocsFmXme&Sd q&mrsm;omygaom Database wpfckudk awGU&Sd &ygrnf/

8/ 4if; Database rS wuúodkvfq&mrsm;wGif vpm 7000 txuf&&Sdaomq&mrsm; udkom ppfxkwfvdkvQif atmufygtwdkif;aqmif½GufEdkifygonf(u) Salary field name nmzuf&dS Down arrow udk Click vkyyf g/ Drop k svmygrnf/ down list wpfcu (c) 4if;xJrS (Custom) udk a½G;cs,yf g/ xdt k cg Custom AutoFilter dialog box wpfck ay:vmygrnf/ yHk(7-7)

yHk(7-7)

97 (* )

Microsoft Excel 2002

Dialog box xJ&Sd Salary atmuf&Sd Drop down list wGif is greater than uda k ½G;yg/ nmzuf&dS Drop down list wGif 7000 udak ½G;yg/ Ny;D ygu OK udk Click vkyfyg/ vpm 7000 txuf&&dSaomq&mrsm;ygonfh Database wpfckay:vmonfudk awGU&ygrnf/ yHk(7-8)

yHk(7-8)

(C)

Filter jzifh ppfxw k Nf y;D ygu Data menu rS Filter udk Point vkyyf g/ ay:vm aom Submenu rS AutoFilter udk Click vkyyf g/ AutoFilter ab;&Sd Check mark aysmufoGm;ygu Field name rsm;\ nmzufwGif&Sd Down arrow rsm;yg aysmufoGm;NyD;? rlv Database udk awGU&Sd&ygrnf/

Using Advanced Filter ( tcsuftvufrsm; tqifhjrifhppfjcif; ) 9/ Advanced Filter udk toH;k jyK&mwGif Criteria range twGuf Blank row owfrw S f &ef vdktyfygonf/ Criteria range wGif Column label rsm;udkyg xnfhoGif;ay;&ef vdyk gonf/ tenf;qH;k Blank rows 3 ck&o dS ifyh gonf/ Column label rsm;atmufwGif ppfxw k v f akd om Criteria ud½k u kd x f nfyh g/ Ny;D ygu Data menu udk Click vkyí f ay:vmaom Pull down menu rS Filter udk Point vkyfyg/ ay:vmaom Sub menu rS Advanced Filter udk Click vkyy f g/ Advanced Filter dialog box ay:vmygrnf/ Action button atmuf&Sd Filter the list, in-place udk Click vkyyf g/? List range: box wGif Cell range A6:G24 ESifh Criteria range: box wGif Cell range: A1:G2 odkY a&mufatmif Drag qJGNyD; Select vkyyf g/ xYakd emuf OK udk Click vkyyf g/

uGefysLwmvufpJG

98

10/

Advanced Filter onf Filter condition ESpfckjzpfaom Sex (F) ESifh Salary (>7000) udk toHk;jyKí List udk ppfxkwfay;ygrnf/yHk(7-9) Condition rsm;udk Row wpfckwnf;wGif a&;xm;jcif;jzpfí 4if; Condition ESifhajyvnfaom Data rsm;udo k m a½G;cs,fppfxkwfay;rnf jzpfygonf/ tu,fí Condition udk Row ESpfckwGif cJGjcm; a&;om;xm;rnfqdkygu Condition rsm;xJ&Sd wpfckckESifhajyvnfvQif Filter List wGif xnfo h iG ;f ay;rnfjzpfygonf/ yH(k 7-10)Data rsm;udpk pfxw k af ½G;cs,Nf y;D ygu rlvtaetxm; twdkif; Z,m;udkjyefvnfvdktyfygu Selector udk List twGi;f ydx Yk m;yg/ Data menu rS Filter udk Point vkyfí ay:vmaom Sub menu rS Show all udk Click vkyfjcif;jzifh

rlvZ,m;twdik ;f jyefvnf&&Syd grnf/

yHk(7-9)

yHk(7-10)

99

Microsoft Excel 2002

Chapter (8) AutoSum

1/

Microsoft Excel 2002 wGif Standard Tool bar ay:&Sd AutoSum Button ∑ onf vloHk;trsm;qHk; Tool wpfck jzpfygonf/ AutoSum drop down list rS Sum()? Average()? Count()? Max()? Min() paom Function rsm;udk vG,fulpGm oHk;pGJEdkif&ef

aqmif½Gufay;xm;ygonf/ Using AutoSum ( AutoSum toHk;jyKjcif; ) 2/ AutoSum toHk;jyKyHkudk atmufaz:jyyg Z,m;wGif Oyrmay;xm;ygonf/ Cell range B2:D2 udk aygif;vdkvQif yxrOD;pGm tajzay:vdkaom Cell wGif Selector udk xm;yg/ yH(k 8-1) Ny;D aemuf Standard toolbar ay:&dS AutoSum button ∑ udk Click vkyyf g/ Enter key ESyd yf g/ Cell E2 wGif tajzay:vmygrnf/

yHk(8-1) 3/ xdkYenf;twl Column B, C, D &Sd Data rsm;udk wpfNydKifwnf; aygif;vdkvQif Cell f g/ xdt k cg aygif;xm; range B8:D8 udk Select vkyfí AutoSum button udk Click vkyy onfhtajzudk awGU&Sd&ygrnf/yHk(8-2)

uGefysLwmvufpJG

100

yHk(8-2)

4/ Sum( ) function udktoHk;jyKNyD; Cell range B2:B3, C2:C3 ESifh D2:D3 &Sd wefzdk;rsm;udkaygif;NyD; aygif;v'ftm; Cell F3 wGif az:jyvdkygu Formula bar ay:wGif Sum ( B2:B3, C2:C3, D2:D3 ) udk ½dkufxnfhNyD;? Enter key ESy d yf g/ yH(k 8-3)(odrYk [kw)f

yHk(8-3)

Cell F3 udk Select vkyfNyD; AutoSum button udk Click vkyy f g/ Mouse pointer jzifh Cell range B2:B3 udk Select vkyy f g/ Ctrl key udkESdyfí qufvufNyD; Cell range f g/ xdak emuf Enter key ESyd yf g/ Cell F3 C2:C3 ESifh Cell range D2:D3 udk Select vkyy wGif tajzay:vmygrnf/ yHk(8-4) Oyrm- Sum( ) function \ Syntax a&;om;enf;rSm = SUM ( number1, number2,...) Equal sign Function name

Adds all the numbers in a range of cells.

101

Microsoft Excel 2002

yHk(8-4) 5/

SUMIF ( ) function onf Condition udktajccHí Cells range rsm;wGif;&Sd

Data rsm;udk qJx G w k o f nft h cgrsm;rSm oH;k ygonf/ Oyrm- ukepf q kH ikd w f pfc\ k wpfaeYwm

a&mif;csí&&Sad om ukeyf pön;f rsm;xJrS rsK;d wluek yf pön;f rsm; pkpak ygif;a&mif;&aiGukd &Smvkv d Qif Sumif( ) udk toH;k jyKEi kd yf gonf/ Sumif( ) \a&;om;enf;(Syntax) rSm SUMIF(range, criteria,sum_range) jzpfygonf/ yH(k 8-5)

yHk(8-5)

uGefysLwmvufpJG

102

6/ SUMIF( ) xJ&Sd Range onf wefzdk;wGufcsufvdkonfh Cell range udk udk,fpm;jyK ygonf/ Criteria onf Condition jzpfNyD;? sum_range onf trSefwu,faygif;&ef vdktyfaom value rsm; jzpfygonf/ 7/ Function aemufwpfrsK;d rSm Dsum()function jzpfygonf/ Dsum ( ) udk owfrw S f ay;xm;aom Condations rsm;ESihf udu k n f rD &I o dS nfh Database (odrYk [kw)f List rS Column rsm;wGif *Pef;rsm;aygif;xnfhjcif;rsKd; jyKvkyfygu toHk;jyKonf/ Oyrm- Super one ukefwdkufcJG (1) \ January? February? March wGif a&mif;&aom Hard Disk ta& twGuu f &kd mS &efjzpfygonf/ yHk(8-6)

yHk(8-6)

8/ Dsum ( A1:E19,"March", A21:B22) qdkonfh Dsum function a&;om;enf; udk awGU&ygrnf/ A1:E19 onf Cells range rS Database (or) List udk ud, k pf m;jyKygonf/ "March" onf User odvdkonfhtajctae Condition jzpfygonf/ A21:B22 onf Condition tm; Apply vkyfíwGufcsufrnfhCells rsm; jzpfygonf/

103

Microsoft Excel 2002

Using Average Function ( Average Function toHk;jyKjcif; ) 9/ Worksheet twGif;rS Value rsm;\ Average udkodvdkygu AutoSum wGif yg&Sad om Average( ) function udk toH;k jyKEikd yf gonf/ yH(k 8-7) atmufazmfjyygWorksheet

wGif ausmif;wpfausmif;&Sd ausmif;om;ausmif;olrsm;\ trSwpf m&if;udk az:jyxm;ygonf/ ausmif;om; ausmif;olwpfOD;csif;pD\ Average marks udk&SmvdkvQif atmufygtwdkif; aqmif½GufEdkifygonf-

(u)

(c)

yHk(8-7) Average &Smvdkaom Cell udk Select vkyx f m;yg/ Ny;D aemuf AutoSum Icon &Sd Drop down arrow udk Click vkyfyg/ Drop down menu wpfckxGufay:vmygrnf/ ,if;rS Average udk Click vkyyf g/ Average &Smrnfh Cells range tm; Excel onf tvdktavsmuf Select vkya f y;oGm;ygrnf/ Select jyKvkyf xm;aom Cells range rSe?f rrSepf pfaq;Ny;D jyifqif&efvt kd yfygu jyifay; yg/ rvdt k yfaom Cells rsm;ygrvmapa&;ppfaq;ay;&ef vdt k yfygonf/ yH(k 8-8) Ny;D aemuf Enter key ESyd yf gu tajzxGuv f monfuakd wGU&ygrnf/

uGefysLwmvufpJG

104

yHk(8-8) Using Conditional Sum Wizard ( Conditional Sum Wizard toHk;jyKjcif; ) 10/ Worksheet wpfck&Sd Data rsm;xJrS Multiple Condition udk tajccHNyD;? pkpkaygif; &Smay;aomenf;udk Conditional Sum Wizard enf;[k ac:ygonf/ wuúov kd q f &mrsm;\ Database wpfcr k S vpm 6500 ESihf 8500 twGi;f &&SMd uaom q&mrsm;\ vpmpkpak ygif;udk &SmazGvo kd nft h cgwGif Condition taejzifh 6500 ESihf 8500 twGi;f &&Sad om q&mrsm;\ vpmrsm;om tBuKH ;0ifygonf/ 4if; Condition onf Multiple Condition jzpfygonf/ Multiple Condition Wizard toH;k jyKyt kH qifq h ifu h kd atmufygtwdik ;f az:jyygrnf/ yxr Conditional Sum Command onf Tools menu xJwi G f &S^d r&Sd ppfaq;yg/ ryg0ifygu

atmufygtwdkif;aqmif½Gufyg(u) Tools menu rS Add-Ins command udk Click vkyyf g/ Add-Ins dialog box ay:vmygrnf/ (c) 4if;rS Conditional Sum check box udk Click vkyyf g/ Check mark ay:vmygrnf/yHk(8-9) NyD;vQif OK udk Click vkyyf g/ Tools menu wGif Conditional Sum command ay:vmonfudkawGY&ygrnf/

105

Microsoft Excel 2002

yHk(8-9)

11/

tu,fí Conditional Sum command &SNd y;D jzpfygu Multiple conditional wizard toHk;jyKyHkudk qufvufaz:jyygrnf(u) Worksheet twGif;odkY Selector ydx Yk m;yg/ (c ) Tools menu rS Conditional Sum udk Click vkyyf g/ Conditional Sum Wizard - Step 1 of 4 dialog box ay:vmygrnf/ (* ) Worksheet rS Cell range A1: G19 udk Excel rS Select vkyaf y;ygrnf/ xdkYaMumifh Running marquee box wpfckay:vmygrnf/ xdkYtjyif $A$1:$G$19 udkvnf; dialog box wGit f oifah wGU&S&d rnf jzpfygonf/ yHk(8-10) Next button udk Click vkyyf g/ (C) Conditional Sum Wizard - Step 2 of 4 dialog box ay:vmygrnf/ yH(k 8-11) Column to Sum dialog box &Sd Drop down arrow udk Click vkyyf g/ Salary udak ½G;Ny;D aemuf Column box wGif Salary udk xyfraH ½G;yg/ Is: box wGif > uda k ½G;yg/ This value: box wGif 6500 udk a½G;NyD;vQif Add condition udk Click vkyy f g/ Is: box wGif < udka½G;í This value: box wGif 8500 udka½G;yg/ NyD;vQif Add condition udk Click vkyy f gu atmufzufwGif ay:vmygrnf/ NyD;vQif Next udk Click vkyyf g/

uGefysLwmvufpJG

106

yHk(8-10)

yHk(8-11)

(i)

Conditional Sum Wizard - Step 3 of 4 ay:vmrnf/ ,if; Wizard wGif Next udk Click vkyyf g/

107 (p )

Microsoft Excel 2002

Conditional Sum Wizard - Step 4 of 4 ay:vmrnf/ yHk(8-12) tajz xm;csifaom Cell ae&mudk Selector ydyYk g/ Dialog box wGif Cell address udk ay:vmygrnf/ NyD;aemuf Finish button udk Click vkyy f g/

yHk(8-12)

12/

xdt k cg 6500 < Salary < 8500 condition ESifhudkufnDaom Salary rsm;udk Database xJrSa½G;xkwfNyD; aygif;ay;ygonf/ Cell D21 wGif tajz 43500 jzpfonfh vpmaiGpkpkaygif;udk az:jyay;ygonf/ Formula bar wGif Nested SUM IF udk toHk;jyK xm;ygonf/ yH(k 8-13)

yHk(8-13)

uGefysLwmvufpJG

108

Chapter (9) Array Formula

1/ Microsoft Excel wGif Formula wpfcka&;rnfqdkygu " = " Equal sign ESifh pwif&rnf jzpfygonf/ Oyrm- Cell A1 ESifh Cell B1 rSwefzdk;ESpfckudk aygif;vdkvsif = d &f ygrnf/ Microsoft Excel 2002 wGif Formula A1+ B1 udk Formula bar wGif ½ku udk = SUM(A1:A3+B1:B3) [kxnfo h iG ;f í Ctrl+Shift+Enter key udEk ydS rf nfqykd gu Formula wGif {= SUM(A1:A3+B1:B3)} ay:vmNyD;tajzonf =A1+B1? = A2+B2 ? = A3+B3 wdkYrS &&Sdvmaom tajzrsm;udk aygif;oGm;ygrnf/ 4if; Formula udk Array formula [kac:ygonf/ txufygtwdi k ;f Array formula wpfckudk wnfaqmuf rnfqdkvQif Formula udk Cell twGif;½dkufxnfhyg/ NyD;vQif Ctrl+Shift+Enter key udEk ydS yf g/ Formula udk { } ESifh ydwfay;ygrnf/ Create an Array Formula ( Array Formula wpfckudk wnfaqmufjcif; ) 2/ Array formula wpfcu k kd wnfaqmufEikd &f eftwGuf OyrmwpfcEk iS ahf vhvmMunfh ygrnf/ Aung Electronic qdik w f pfqikd \ f wpfaeYa&mif;&aom ypön;f pm&if;ESihf a&mif;&aiG udk &SmMunfyh grnf/ yH(k 9-1) omreftm;jzifh atmufygZ,m;wGif Grand total ud&k mS vdv k Qif yxrOD;pGm ypönf;wpfckpD\ Price ESifh Amount udkajr§mufygrnf/ NyD;aemuf Total rsm;udk aygif;vQif Grand total ud&k &Srd nfjzpfygonf/

yHk(9-1)

109

Microsoft Excel 2002

3/ txufygZ,m;udk Array Formula toHk;jyKí Grand total wGufcsufenf; tqifhqifhrSm atmufygtwdkif; jzpfygonf(u) Grand total &Smrnfh Cell D14 udk Select vkyyf g/ (c ) = Sum( B3:B12*C3:C12) udk ½dkufxnfhNyD;? Keyboard rS Ctrl + Shift + Enter key udk wpfNydKifwnf; ESdyfyg/ Formula bar wGif {=SUM(B3:B12*C3:C12)} ay:vmNyD;? Select vkyfxm;aom Cell D14 wGif tajz 1119500 udk wGufcsufay;ygrnf/ yHk(9-2) (* ) {=SUM(B3:B12*C3:C12)} \t"dyÜg,frSm B3*C3+B4*C4+ B5*C5+B6*C6+B7*C7+B8*C8+B9*C9+B10*C10+ B11*C11+B12*C12 ESihf twlwjl zpfygonf/ Braces { } \ t"dygÜ ,f rSm Array formula jzpfaMumif; Excel rSaz:jyxm;jcif;jzpfygonf/ { }

udk xnf½h u kd &f ef rvdyk g/

yHk(9-2)

Using the Array Formula ( Array Formula udk toHk;jyKjcif; ) 4/ Array formula udktoHk;jyKNyD;? Matrix ykpämwpfyk'ftm; ajz&Sif;ygrnf/ Matrix wpfck\ Determinate udk &Smvdkygu vG,fulpGm ajz&Sif;ay;Edkifaom Function rSm MDETERM ( ) jzpfygonf/ MDETERM() tm; toHk;jyKí atmufygtwdkif; &SmEdkif

ygonf/ yH(k 9-3)-

110

uGefysLwmvufpJG

yHk(9-3)

(u)

(c) (*)

(C)

Cell A2 wGif 1 ? Cell B2 rSm 3 ESifh Cell A3 wGif 7? Cell B3 wGif 2 udk ½du k yf g/ Matrix rSm 2×2 matrix wpfckjzpfNyD;? Entry rSm 1, 3 ESifh 7, 2 wdjYk zpfygonf/ Determinate &Smvdkaom Cell A5 udk Select vkyy f g/ Formula bar rS = MDETERM(A2:B3) ud½ k u kd x f nfyh g/ (odrYk [kw)f Paste function rS MDETERM( ) udka½G;í Entries tjzpf xnfhoGif; xm;aom 1, 3 ESifh 7, 2 wdkYudk Select vkyyf g/ NyD;vQif Ctrl + Alt + Enter key ESdyfyg/ Determinate wefzdk; -19

&&Sdygrnf/ 5/

Simultaneous Equations wpfckudk ajz&Sif;Munfhygrnf/

OyrmSolve the following equations by the matrix mathod. 8x1 + 2y1 + 3z1 = 30 x2 - 9y2 + 2z2 = 1 2x3 + 3y3 + 6z3 = 31 ykpämwGifay;xm;csufrsm;udk Matrix yHpk aH jymif;ygrnf/ Coefficient matrix A u 8 2 3 A = 1 -9 2 2 3 6

B =

30 1 31

X =

x1 x2 x3

111

Microsoft Excel 2002

ykpmä udk Matrix yHkpHajymif;NyD;yguazmfjyyg Matrix Equation udk toH;k jyKygrnf/ AX =B X = A-1 B udkajymif;vJNyD; tajzudkwGufxkwfygrnf/ Matrix A ud k yxrOD ; pG m Inverse vk y f y grnf / Inverse vkyfí&&SdaomtajzESifh matrix B udkajr§mufygrnf/ xdktcgtajz&ygrnf/ þae&mwGif Excel function rsm;jzpfaom MMULT( ) ESifh MINVESE ( ) rsm;udk toHk;jyKrnfjzpfygonf/ Cell range A1:C3 wGif Matrix A \ Coefficient wef z d k ; ud k ½ d k u f y g/ Cell range E1:E3 wG i f Matrix B \ wefz;kd udx k nfyh g/ Cell A5:A7 rSm X1, X2, X3 udk ½du k yf g/ xdkaemuf Cell range b5:b7 udk Select vkyfxm;yg/ jyKvkyfNyD;ygu Formula bar wGif = MMULT ( MINVERSE (A1:C3), E1:E3) qdkonfh Formula ud½ k u kd x f nfyh g/ xdaYk emuf SHIFT + CTRL + ENTER udEk ydS yf g/ Array Formula jzpfomG ;ygrnf/ xdk Formula wpfaMumif;wnf;ESifh Equation 3ck? Unknown 3 ckudk ajz&Sif;oGm;ygrnf/ Cell range B5:B7 rSm X1 \wefzdk; 2? X2 \wefzdk; 1 ESifh X3 \wefzdk; 4 [k tajztoD;oD; azmfjyaeygrnf/ yHk(9-4)

yHk(9-4)

6/ MMULT ( ) qdo k nfrmS Matrix ESpfckudk ajr§mufay;aom Excel function wpfck jzpfygonf/ rnfonfh Matrix udrk qdk ajrm§ ufEikd yf gonf/ Oyrm- 3 x 3 Matrix ESpfckudk ajrm§ ufMunfEh ikd yf gonf/ Oyrm- ykpmä rSm Solve the following matrices. jzpfNyD;? Matrix ESpfcktm; ajr§mufonfjzpfygapA=

2 1 5

3 0 -2

6 5 3

B=

4 1 4

-3 1 1

7 4 -1

uGefysLwmvufpJG

112

7/

yxrOD;pGm ay;xm;csufrsm;udk Excel rS od&dSap&ef jyKvkyf&ygrnf/ Cell range k yf g/ Cell range E1:G3 wGif Matrix B A1:C3 wGif Matrix A \ Entries rsm;udk ½du \ Entries rsm;udk ½du k x f nfyh g/ Ny;D ygu Cell range A6:C8 udk Select vkyyf grnf/ Formula bar wGif = MMULT ( A1:C3, E1:G3) ud½ k u kd x f nfyh g/ xdaYk emuf SHIFT d yf g/ 3 x 3 matrix wpfckESifh tajzay:vmygrnf/yHk(9-5) + CTRL + ENTER udk ESy

yHk(9-5) Delete an Array Formula ( Array Formula wpfckudkzsufjcif; ) 8/ Array Formula wpfckudk zsufvdkvQif atmufygtwdkif;aqmif½GufEdkifygonf(u) zsufvdkaom Formula udk Select vkyyf g/ ( c ) Keyboard rS Delete key udk ESyd yf g/ Copy an Array Formula ( Array Formula wpfckudkul;,ljcif; ) 9/ Array Formula wpfcu k kd a½GUajymif;jcif;onf Formula twGi;f &Sd Cell reference rsm; ajymif;vJrIr&Sdaomfvnf;? ul;,ljcif;wGifrl ajymif;vJrIrsm; jzpfapygonf/ Formula tm; Copy vkyfNyD;csdefwGif Cell references rsm;udk atmufygtwdkif;ajymif;vJ&rnf(u) Formula yg0ifaom Cell range udk a½G;cs,yf g/ (c) NyD;aemuf Edit menu udk Click vkyyf g/ Copy udk Click vkyyf g/

(*)

ul;vdkaomae&mudk a½G;cs,fyg/

113 (C)

Microsoft Excel 2002

Formula ESifh Format tm;ul;vdkvQif Edit menu rS Paste udk Click

vkyyf g/ (i)

Formula wpfckwnf;om ul;vdkvQif Edit menu rS Paste Special udk Click vkyfí Formulas udka½G;yg/ yHk(9-6) NyD;aemuf OK udE k ydS yf g/

yHk(9-6)

(p )

Formula bar ay:wGif Formula &SdtoHk;jyKxm;aom Cell reference udk tajz&onft h xd csed u f u kd yf g/ tvd&k &dS mReference trsK;d tpm;rsm;udk

ajymif;ay;yg/ yHk(9-7)

uGefysLwmvufpJG

114

yHk(9-7) Edit an Array Formula ( Array Formula wpfckudk jyifqifjcif; )

10/

Array Formula wpfckudk jyifvdkygu atmufygtwdkif;aqmif½GufEdkifygonf(u) jyifvdkaom Array Formula yg&So d nfh Cell udk Select vkyyf g/ (c) Formula bar ay:wGif Array Formula ay:vmrnf/ Cursor udk Formula bar ay:wGif Click vkyy f g/ xdt k csed w f iG f Braces ( { } ) udk

(*) (C)

awGY&awmhrnf r[kwfyg/ Array Formula udk jyifyg/ Ny;D ygu Ctrl + Shift + Enter key udk ESyd yf g/ Array Formula jyifqifNy;D jzpfoGm;ygrnf/

115

Microsoft Excel 2002

Chapter (10) Printing 1/ Microsoft Excel wGif Excel zdi k rf sm;tm; Hard copy tjzpf Printer jzifh pm½Gufay:odkY ½dkufxkwfonfhtydkif;udk rvJGraoG jyKvkyf&rnf jzpfygonf/ 4if;udk Print k f out jyKvkyfonf[k ac:ygonf/ Excel zdkifwpfcktm; rSefrSefuefuefjzifh Print out jyKvy Edkif&eftwGuf a&;om;xm;ygonf/ Printing Worksheets ( Worksheet twGif;&Sd Z,m;rsm;tm; Printer jzifh½dkufxkwfjcif; ) 2/ Microsoft Excel wGif Print out jyKvkyfyHktqifhqifhudk atmufygtwdkif;

vkyfaqmifEdkifygonf(u) Printer jzifh ½dkufxkwfvdkaom Excel zdik w f pfcu k zkd iG yhf g/ 4if;rS tvd&k &dS m Worksheet udk a½G;cs,y f g/ (c) File menu rS Page Setup udk a½G;yg/ Page Setup dialog box ay:vm rnf/ Page tab udk a½G;yg/ yHk(10-1)

yHk(10-1)

uG e f y sLwmvuf p J G (*)

(C)

(i)

116

Orientation atmuf&Sd ½dkufxkwfvdkaom pm½Guf\taetxm;tvdkuf a'gifvdkufxkwfrnfqdkvQif Portrait ud k a ½G ; cs,f N yD ; ? tvsm;vd k u f xkwrf nfqykd gu Landscape option udk a½G;cs,f&ygrnf/ Paper size udkvnf; ½dkufxkwfvdkonfh pm½Guf\t&G,ftpm;twdkif; A4 (odkYr[kwf) Letter (odrYk [kw)f Legal size wdu Yk kd a½G;cs,o f wfrw S Ef ikd &f ef Paper size list box wGif a½G;cs,fay;&ygrnf/ NyD;aemuf Margins tab udka½G;í tvdk&Sd&m Left? Right ? Top? Bottom wdkY\ Margins rsm;udk a½G;cs,fowfrSwfay;&ygrnf/ yHk(10-2)

yHk(10-2) (p)

tu,fí Header ESifh Footer wGif Page number rsm;? tjcm;azmfjyvdk onfph mrsm;&Syd gu Header/Footer Tab udk a½G;cs,yf g/ Header tydik ;f wGif xnfrh nfqykd gu Custom Header udak ½G;yg/ Footer tydik ;f wGif xnfrh nf qdyk gu Custom Footer udak ½G;cs,yf g/yH(k 10-3) Custom Header (or) Footer rsm;wGif Left Section? Center Section ESifh Right Section wdkYyg&Sd&m pmom;xnfhvdkonfh Section udka½G;yg/ Custom Header

117

Microsoft Excel 2002

yHk(10-3)

(odkYr[kwf) Footer box wdkYwGif atmufaz:jyyg Command button rsm;udk awGU&SdEdkifygonf/ yHk(10-4)(1) Font Style udk Mouse jzifh a½G;cs,y f gu Header (odrYk [kw)f Footer wGifa&;om;rnfh Font ? Font Style? Size wdy Yk g0ifonfh Font dialog box ay:vmrnf/ tvdk&Sd&m Font ? Font Style ESifh Size wdkYudkajymif;vJEdkifygonf/

yHk(10-4)

uG e f y sLwmvuf p J G (2)

(3)

(4) (5) (6)

(7) (8) (9)

118 & [Page ] udk Mouse jzifh Click vkyy f gu Cursor csxm; onfh Left? Right ? Center Section ae&mrsm;wGif &[Page]

ay:vmrnf/ 4if;onf tvdktavsmuf pmrsufESm wyfay;jcif; (Automatic Page Numbering) jzpfonf/ & [Pages] udk Mouse jzifh Click vkyy f gu Cursor csxm; onfh Section wGif &[ Pages ] ay:vmrnf/ 4if;onf pmrsuEf mS eHygwfEiS phf mrsuEf mS pkpak ygif;wdu Yk kd wJv G suaf z:jyay;ygonf/ OyrmpmrsuEf mS 10 &Sdaom Document wpfckwGif pmrsufESm 1 udk 1/ 10 [kvnf;aumif;? pmrsuE f mS 5 udk 5/10 [kvnf;aumif; az:jy ay;ygonf/ & [Date] udk Mouse jzifh Click vkyy f gu Cursor csxm; onfh Section wGif & [Date] ay:vmrnf/ 4if;onf System date jzpfí &ufpJGudk az:jyay;vdkygu toHk;jyKEdkifygonf/ & [Time] udk Mouse jzifh Click vkyy f gu Cursor csxm; onfh Section wGif & [Time] ay:vmrnf/ 4if;onf System time jzpfí tcsdefem&Dudk az:jyvdkygu toHk;jyKEdkif ygonf/ &[Path]&[File] udk Mouse jzifh Click vkyy f gu Cursor csxm;onfh Section wGif &[Path]&[File] ay:vmrnf/ 4if;onf File name udk omru 4if;zdik &f adS om vrf;aMumif;udyk g az:jyvdkygu toHk;jyKEdkifygonf/ Oyrm- C:\My Documents\ test.xls & [File] udk Mouse jzifh Click vkyy f gu Cursor csxm; onfh Section wGif & [File] ay:vmrnf/ 4if;onf File name

udk az:jyvdkygu toHk;jyKEdkifygonf/ & [Tab] udk Mouse jzifh Click vkyy f gu Cursor csxm;onfh Section wGif & [Tab] ay:vmrnf/ 4if;onf Work sheet rsm;\trnfukd az:jyvdyk gu toH;k jyKEikd yf gonf/ Oyrm-Sheet1 & [Picture] udk Mouse jzifh Click vkyy f gu Insert picture dialog box ay:vmrnf / xnf h v d k a om Picture yHkrsm;udk a½G;cs,fí Insert vkyyf gu Cursor csxm;onfh Section wGif & [Picture] ay:vmrnf/ 4if;onf Document wGif ½kyy f rkH sm;udk az:jyvdkygu toHk;jyKEdkifygonf/

119 (q)

Microsoft Excel 2002

txufygtwdik ;f Header / Footer tm; rdr\ d pdwBf uKd ujf yifqifNy;D ygu yHk(10-5)twdkif; Sheet tab udk a½G;cs,fEdkifygonf/ Print area: box wGif ½dkufxkwfvdkaom Area udk owfrSwfay;Edkifygonf/ owfrSwfyHkrSm Print area: box twGif;odkY Selector ud k x nf h x m;yg/ NyD ; aemuf Worksheet twGif;&Sd ½dkufxkwfvdkaomtydkif;udk Select vkyfay;yg/ xdt Yk cg Excel \ Cell range rsm; tvdv k 0kd ifvmygrnf/ Print title atmuf&Sd Rows to repeat at top box ESifh Columns to repeat at left: box rsm;onf ½dkufxkwfvdkaomZ,m;rSm wpfrsufESmxuf ydkaevQif pmrsuEf mS wdik ;f ü acgif;pOfxnfo h iG ;f vdyk gu toH;k jyKygonf/ Print title atmuf&Sd Rows to repeat at top box wGif Selector csxm;Ny;D ? Z,m;\ Row acgif;pOfrsm;udk a½G;cs,fay;jcif;jzifh Row acgif;pOfrsm;\ Cells range rsm; tvdv k 0kd if&mufvmygrnf/

yHk(10-5)

(Z )

Page Setup dialog box wGif tvdk&Sd&mowfrSwfNyD;ygu OK udk Click vkyyf g/ 4if; File udk Save vkyyf g/ Printer jzifh ½du k x f w k v f ykd gu yxrOD;pGm Print preview udk t&ifMunfhí ppfaq;oifhygonf/ yHk(10-6) Print preview udk MunfhNyD;? pdwfBudKufjzpfrSom Print xkwo f ifyh gonf/

uG e f y sLwmvuf p J G

120

yHk(10-6)

(ps)

(n)

Print Preview wGif&Sdaom Print tab tm; a½G;ygu yHk(10-7)twdkif; Print dialog box ay:vmrnf/ xdktcg Printer acgif;pOfatmuf&Sd Name List Box wGif toHk;jyKrnfh Printer udk a½G;cs,y f g/ Print range acgif;pOfatmufwGif Option ESpfck&Sd&m All rSm pmrsufESmtm;vHk;udk ½dkufxkwfvdkonfhtcg a½G;Edkifygonf/ Pages rSm pmrsufESmrnfrQrS rnfrQtxd ½dkufxkwfvdkonfhtcg a½G;&efjzpfygonf/ Copies acgif;pOf atmufwGif Number of copies list box ü Copy vkyfvdkonfh

ta&twGufudk ½dkufxnfhay;&ef (odkYr[kwf) a½G;ay;&efjzpfygonf/ Properties command button udk Click vkyy f gu yH(k 10-8)ygtwdik ;f Document Properties dialog box ay:vmygrnf/ ,if;wGif Layout ESifh Paper/Quality tab ESpfckudkawGUEdkifygonf/ Layout tab wGif Orientation acgif;pOfatmufü pmrsufESmtaetxm;rsm;udk a½G;cs,f ay;Edik yf gonf/ Portrait onf a'gifvu kd t f aetxm;jzpfNy;D ? Landscape onf tvsm;vdkuftaetxm;jzpfygonf/a½G;cs,fvdkufonfh Option ay:rlwnfí Preview wGifay:vmonfudk jrifawGU&rnf jzpfygonf/

121

yHk(10-7)

yHk(10-8)

Microsoft Excel 2002

uG e f y sLwmvuf p J G

122

yHk(10-9)

Rotated Landscape rSm Paper Roll rsm;udk toHk;jyKNyD;? pm½dkufxkwfvdk aom tajctaersKd;wGifom toHk;jyKygonf/ Page order rSm ½dkufxkwf vdkaom Document \ a&SUqHk;rS pwifxkwfrnf (odkYr[kwf) aemufqHk;rS pí xkwfrnfqdkonfudk a½G;cs,fedkif&efjzpfygonf/ Paper/Quality tab udk Click vkyyf gu ,if; Tab atmufwGif Tray selection udkawGU&rSm jzpfNyD;? yHkrSeftaejzifh Automatically Select wGif xm;&dS&ygrnf/ atmufzufaxmihf&Sd Advance command button udk Click vkyyf gu yHk(10-9)ygtwdkif; Paper size udk a½G;cs,fay;&ygrnf/ A4 ? Legal ? Letter... ponfjzifh ½dkufxkwfvdkonfhpm½Gufudk a½G;cs,fay;&ygrnf/ Graphic onf ½dkufxkwfvdkufonfh pm\Munfvifjywfom;rI tenf; trsm;udk csed n f ad§ y;aomae&mjzpfygonf/ Print quality (or) Resolution [kvnf;qdEk ikd yf gonf/ Resolution onf dpi ( dots per inch ) jzifh wdkif;wmygonf/ 300 dpi, 600 dpi, 1200 dpi ponfjzifhtrsKd;rsKd;

123

(#)

Microsoft Excel 2002

&SEd ikd yf gonf/ vdt k yfaom Resolution udk ajymif;vJí toH;k jyKEikd yf gonf/ Scale qdo k nfrmS Graphic \ csKHUjcif;? csJUjcif; jyKvkyfay;aom tydkif; jzpfygonf/ 100% xuf ausmfvGefygu xGufay:vmaom Document rSm yHBk u;D csUJ í xGuaf y:vmygrnf/ 100% atmufwiG f yHak o;tjzpf csKUH í xGuv f mygrnf/ a½G;cs,fowfrSwfcsufrsm;udk tm;vHk;jyifqifowfrSwfNyD;ygu OK udk tqifhqifh Click vkyyf g/ Print dialog box ay:vmvQif OK udk Click vkyyf gu Printer rS Print Out jyKvkyfay;ygrnf/

Saving the Excel File ( Excel File tm;odrf;jcif; ) 3/ Microsoft Excel wGif Document rsm;udk jyifqifwnf;jzwfNy;D ygu odr;f qnf;

xm;&ef vdktyfrnfjzpfygonf/ odrf;qnf;yHktqifhqifhrSm atmufygtwdkif; jzpfygonf(u) File menu udk Click vkyyf g/ Pull down menu usvmrnf/ (c ) 4if;rS Save command udk Click vkyyf g/ (* ) Save As dialog box ay:vmrnf/ yHk(10-10)Save in: list box wGif

yHk(10-10)

uG e f y sLwmvuf p J G

124

File odrf;qnf;xm;rnfh Folder tm; a½G;cs,fay;&ygrnf/ File name f g/ box wGif zdkif\trnfudk ½dkufyg/ NyD;aemuf Save udk Click vkyy Closing Current File ( vuf&Sd zGifhxm;aom zdkiftm;ydwfjcif; ) 4/ Microsoft Excel wGif vuf&SdtoHk;jyKaeaom zdkiftm; ydwfvdkvQif atmufyg

twdkif; aqmif½GufEdkifygonf(u) File menu udk Click vkyyf g/ Pull down menu usvmrnf/ (c) Close udk Click vkyfyg/ Excel File ydwfoGm;ygrnf/ (odkYr[kwf) Windows Element wpfckjzpfonfh Close button udk toHk;jyKí vnf; zdik u f kd ydwEf ikd yf gonf/ Opening File ( zdkifzGifhjcif; ) 5/ Microsoft Excel wGif zdi k w f pfct k m; zGiv hf v kd Qif atmufygtwdik ;f aqmif½u G Ef ikd f

ygonf(u) (c)

File menu udk Click vkyy f g/ Pulldown menu usvmrnf/ Open udk Click vkyy f g/ Open dialog box ay:vmrnf/ 4if;rS tvd&k &dS m zdik u f kd a½G;cs,í f Open button udk Click vkyyf g/ (odrYk [kw)f Keyboard rS Ctrl + O udk wJEG ydS yf g/ Open dialog box ay:vmygrnf/ tvd&k &dS m zdik u f kd a½G;cs,í f Mouse jzifh Double-Click vkyyf gu zdik yf iG v hf mygrnf/

Page Setup ( pmrsufESm yHkpHcsjcif; ) 6/ Microsoft Excel wGif zdi k w f pfct k m; wnfaqmufvykd gu pmrsuEf mS yHpk H csxm;& ygrnf/ Page Setup udk atmufygtwdkif; aqmif½GufEdkifygonf(u) File menu udk Click vkyyf g/ Pulldown menu usvmrnf/ (c) Page setup command udk Click vkyyf g/ Page setup dialog box

(*) (C) (i)

ay:vmrnf/ yHk(10-11) ,if;rS Page tab udk Click vkyyf g/ ,if; Tab &Sd Orientation wGif pmrsufESm\ taetxm;jzpfaom a'gifvdkuf (odkUr[kwf) tvQm;vdkufudk a½G;cs,f&ygrnf/ Scaling &Sd Adjust to option wGif omreftm;jzifh 100% jzpfonf/ tBu;D csUJ íjrifvykd gu 100% xufyakd y;&ygrnf/ csKUH vdyk gu 100% xuf avsmhay;&ygrnf/

125 (p )

(q) (Z )

Microsoft Excel 2002

Fit to option onf oufqdkif&m Document &Sd Data rsm;tm; pm&Guf

wpfrsuEf mS twGi;f ü tuke0f ifqefv Y v kd Qit f oH;k jyKygonf/ 0ifqefv Y o kd nfh pmrsufESmta&twGufudkvnf; az:jyay;Edkifygonf/ Paper size list box wGif ½du k x f w k v f o kd nf pm½Gut f rsK;d tpm;udk a½G;cs,f ay;&ygrnf/ Print Quality wGifvnf; Resolution udk vdktyfovdk dpi ( Dots per inch ) trsKd;rsKd;a½G;cs,fay;Edkifygonf/

yHk(10-11) Margins ( Margin owfrSwfjcif; ) 7/ Microsoft Excel wGif zdi k w f pfct k m; wnfaqmufNy;D ygu Hard copy jyKvkyf&ef pmrsuEf mS yHpk H csxm;&ygrnf/ pmrsuEf mS yHpk cH s&mwGif Margin a½G;cs,rf v I nf; yg0ifygonf/ Margins udk atmufygtwdkif; a½G;cs,faqmif½GufEdkifygonf(u) File menu udk Click vkyyf g/ Pull down menu usvmrnf/ (c ) Page setup command udk Click vkyyf g/ Page setup dialog box

ay:vmrnf/ (* )

Margins tab udk a½G;yg/ Left? Right ? Top ESifh Bottom box wdkYwGif xm;&Sdvdkaomtwdkif;twmrsm;udk Arrow button toHk;jyKía½G;yg/

uG e f y sLwmvuf p J G

126

(odrYk [kw)f ½du k x f nfyh g/ Header and Footer box wGifvnf; pdwfBudKuf twdik ;f twmudk a½G;yg (odrYk [kw)f ½du k x f nfyh g/ yHk(10-12)

yHk(10-12) (C)

Center on page onf Document tm; pmrsuE f mS \tv,fwiG f xm;&Sd jcif;jzpfonf/ Horizontal ESifh Vertical ESpo f ufovdk xm;Edik yf gonf/ pmrsuEf mS \ tvsm;vdu k t f v,fxm;vdyk gu Horizontal check box wGif Click vkyfí Check mark ay:atmif Click vkyyf g/ a'gifvu kd f tv,fxm;vdyk gu Vertical check box wGif Check mark ay:atmif Click vkyy f g/

Quiting From Excel 2002 ( Excel 2002 rSxGufjcif; ) 8/ Microsoft Excel rS tNyD;tydkifxGufvdkygu vuf&SdzGifhxm;aom zdkiftm;vHk;udk ydwyf g/ Ny;D rS File menu &Sd Exit command udk Click vkyyf g/ (odrYk [kw)f Excel windows rS Close button udk Click vkyyf g/

127

Microsoft Excel 2002

Chapter (11) Keyboard Shortcuts 1/ Microsoft Excel wGif Commands rsm;udk tvG,w f ul vsijf refpmG toH;k jyKEikd f &eftwGuf Keyboard Shortcuts rsm;yg&Syd gonf/ Keyboard Shortcuts rsm;udk jyKvyk o f nfh vkyfaqmifrIay:rlwnfí trsKd;tpm;tvdkuf cJGjcm;wifjyxm;ygonf/ Office Assistant

2/

Microsoft Excel 2002 &Sd Office Assistant udk zGifhvdkvQif atmufaz:jyyg Keyboard Shortcuts twJu G kd ESyd yf g-

(u)

Alt + H onf Help menu udkzGifh&efjzpfygonf/ NyD;aemuf O udk ESy d yf g/ O onf Show the Office Assistant udk zGifhonfhCommand jzpfygonf/

yHk (11-1-u) (odkYr[kwf) ( c)

F1 ( Function Key ) udk ESy d yf gu Office Assistant Ballon udk awGU& ygrnf/ jyefyw d v f v kd Qif Office Assistant ay:odkY Right Click vkyyf g/ ay:vmaom Context menu rS Hide udk Click vkyyf g/

Ballon

Office Assistant

yHk(11-1-u)

uG e f y sLwmvuf p J G

128

Assistant balloon

3/

Assistant balloon &Sd Shortcuts key rsm;rSm atmufygtwdi k ;f jzpfygonf-

(u)

ALT + number udw k í GJ ESyd yf gu ALT+1 onf yxr topic, ALT+2 onf 'kwd, topic, udk az:jyygonf/ (Numeric key jzifo h ;kH ír&yg/)

( c)

ALT + DOWN ARROW udw k í GJ ESyd yf gu Assistant list wGi&f dS aemufrS Help topic rsm;udk jy&ef jzpfonf/

( *)

ALT+ UP ARROW udw k í GJ ESyd yf gu Assistant list wGif&Sd

a&SUrS Help

topic rsm;udk jyo&efjzpfonf/

(C)

ESC udE k ydS yf gu Assistant message or a tip

udk ydwf&efjzpfonf/

Using Contents, Index and Answer Wizard pane

4/ Contents, Index and Answer Wizard pane &Sd Shortcuts key rsm;rSm atmufygtwdik ;f jzpfygonf/ yHk(11-1-c)(u)

F6 onf Help topic pane ESifh Contents? Index ESifh Answer Wizard pane wdkYtMum; tjyeftvSef ul;ajymif;jcif;/

( c)

ALT + C onf Contents Tab udk oGm;jcif;/

Contents, Index and Answer Wizard pane

yHk(11-1-c)

Help topic pane

129

Microsoft Excel 2002

( *)

ALT + A onf Answer Wizard udo k mG ;jcif;/

(C)

ALT + I onf Index Tab udo k mG ;jcif;/

( i)

Down Arrow onf Book or Help Topic aemufwpfckudka½G;cs,fjcif;/

( p)

Up Arrow onf NyD;cJhaom Book or Help Topic udka½G;cs,fjcif;/

(q)

Shift + F10 onf Shortcut menu udkaz:jyjcif;ponfwdkYjzpfonf/

Use the Help Topic Pane

5/

Help Topic Pane &Sd Shortcuts key rsm;rSm atmufygtwdi k ;f jzpfygonf-

(u)

ALT + Right Arrow onf Help topic aemufwpfckodkY oGm;jcif;/

( c)

ALT + Left Arrow onf Help topic a&SUwpfckodkY oGm;jcif;/

( *)

Tab onf aemuf&dS Topic \xdyr f S Show All (or) Hide All (or) Hidden text (or) Hyperlink rsm;udk a½G;cs,fjcif;/

(C)

SHIFT + Tab onf a½SU&Sd Topic \xdyfrS Show All (or) Hide All (or) Hidden text (or) Hyperlink rsm;udk a½G;cs,fjcif;/

( i)

Enter onf a½G;cs,fxm;aom Show All, Hide All, Hidden text or Hyperlink rsm;udk aqmif½Gufapjcif;/

( p)

Up Arrow or Down Arrow onf Help Topic \ tpESifh tqHk;odkY Scroll vkyE f ikd jf cif;/

(q)

Page Up or Page Down onf Help Topic \ tpESihf tqH;k odYk Screen wpfcpk m Scroll vkyEf ikd jf cif;/

( Z)

Home or End onf Help Topic \ tpESifh tqHk;odkY a&muf&dSapjcif;/

( ps)

CTRL + P onf vuf&Sd Help Topic udk Print out xkwE f ikd jf cif;/

uG e f y sLwmvuf p J G

130

(n)

CTRL + A onf Help Topic wpfckvHk;udk Select All vkyjf cif;/

( #)

CTRL + C onf a½G;cs,fxm;aom Help Topic udk Clipboard odkY

ul;,la½GUajymif;jcif;ponfwdkYjzpfonf/ Windows

6/

Windows rsm;twGuf Shortcuts key rsm;rSm atmufygtwdi k ;f jzpfygonf-

(u)

ALT+TAB onf tjcm;zGix hf m;aom Program wpfco k Ykd oGm;jcif;/

( c)

ALT+SHIFT+TAB onf a&SUrS Program odYk jyefomG ;jcif;/

( *)

CTRL+ESC onf Windows \ Start menu odo Yk mG ;jcif;/

(C)

CTRL+W or CTRL+F4 onf zGix hf m;aom Workbook window udk

ydwjf cif;/ ( i)

CTRL+F5 onf a½G;cs,x f m;aom Workbook window \ t½G,f tpm;udk Restore jyKvyk jf cif;/

( p)

F6 onf Workbook window tm; Split command ay;xm;pOf Pane

wpfcrk S wpfco k Ykd oGm;jcif;/ (q)

SHIFT+F6 onf Workbook window tm; Split command ay;xm;pOf Pane wpfcrk S wpfco k Ykd oGm;jcif;Ny;D aemuf a&SUodjYk yefomG ;jcif;/

( Z)

CTRL+F6 onf Workbook window rsm;tm;wpfNyKd iw f nf; zGix hf m;pOf Window wpfcr k S aemufwpfco k Ykd oGm;vdv k Qif toH;k jyKjcif;/

( ps)

CTRL+SHIFT+F6 onf Workbook window rsm;tm;wpfNyKd iw f nf; zGix hf m;pOf Window wpfcrk S a½SUwpfco k jYkd yefomG ;jcif;/

(n)

CTRL+F7 onf Workbook window \ t½G,t f pm;udk Restore jyKvkyfxm;pOf window tm; a&GUajymif;&ef toH;k jyKygonf/ CTRL + F7 ud k E S d y f N yD ; aemuf Arrow key rsm;jzif h tvd k & S d & mae&mod k Y a½GUajymif;Edik yf gonf/ Ny;D vQif Esc key udk ESyd yf g/

131

Microsoft Excel 2002

( #)

CTRL+F8 onf Workbook window \t½G,ftpm;udk Restore jyKvkyfxm;pOf window tm; csKUH ^csUJ &eftoH;k jyKygonf/ CTRL + F8 udk ESyd Nf y;D aemuf Arrow key rsm;jzifh tvd&k &dS mzufoaYkd ½G;cs,í f Window taetxm;udk csKUH ^csUJ Edik yf gonf/ Ny;D vQif Enter key udk ESyd yf g/

( X)

CTRL+F9 onf Workbook window udk Minimize jyKvk y f & ef

toH;k jyKygonf/ ( !)

CTRL+F10 onf Workbook window udk Maximize/Restore

wpfvn S phf D jyKvyk Ef ikd yf gonf/ ( ¡)

PRTSCR onf Screen ay:&Sd Picture rsm;udk ul;,l&ef Clipboard

ay:odYk yd&Yk mwGif toH;k jyKygonf/ (P)

ALT + PRINT SCREEN onf a½G;cs,fxm;aom Window ay:&Sd Picture rsm;udk ul;,l&ef Clipboard ay:odYk yd& Yk mwGif toH;k jyKygonf/

Menu and Tools bar

7/

Menu and Tools bar twGuf Shortcuts key rsm;rSm atmufygtwdi k ;f jzpfygonf-

(u)

F10 or ALT onf Menu udk a½G;cs,f&ef/

( c)

TAB or SHIFT + TAB onf Menu wpfckrS wpfckodkYa&SU? aemuf a½GUajymif;&ef (odkYr[kwf) Tools bar ay:&Sd Button wpfckrS wpfckodkY

a&SU?aemuf a½GUajymif;&ef/ ( *)

CTRL + TAB or CTRL + SHIFT + TAB onf Tools bar wpfckrS

wpfco k Ykd a½GUajymif;&ef/ (C)

SHIFT+F10 onf a½G;cs,x f m;aom Item \ Shortcut menu udzk iG &hf ef/

( i)

ALT+SPACEBAR onf Excel windows \ Control menu udz k iG &hf ef/

( p)

DOWN ARROW or UP ARROW onf a½G;cs,x f m;aom Menu (odkYr[kwf) Submenu &Sd commands rsm;tm; txuf^atmuf

a½G;cs,&f ef/

uG e f y sLwmvuf p J G (q)

132

LEFT ARROW or RIGHT ARROW onf a½G;cs,x f m;aom Menu \ Submenu zGix hf m;pOf Main menu ESifh Submenu tMum; tjyeftvSef

a½GUajymif;&ef/ ( Z)

HOME or END onf Menu wpfc& k dS yxrqH;k Command rS aemufq;kH Command odYk tjyeftvSef a½GUajymif;&ef/

(ps)

ESC onf zGix hf m;aom Menu (odrYk [kw)f Submenu tm; ydw&f ef/

(n)

CTRL+DOWN ARROW onf Menu ay:&Sd command tm;vHk;udk

az:jyvdv k Qif toH;k jyK&ef/ ( #)

CTRL+7 onf Standard toolbar udk ydw& f ef (odrYk [kw)f zGi&hf ef ponfwYkd

jzpfonf/ Dialoges box

8/

Dialoges box twGuf Shortcuts key rsm;rSm atmufygtwdi k ;f jzpfygonf-

(u)

TAB onf option wpfckrS tjcm; option wpfckodkY a&SU^aemuf

a½GUajymif;jcif;/ ( c)

SHIFT+TAB onf Dialog box &Sd option wpfcr k t S jcm; option wpfco k Ykd

ajymif;a½GUjcif;/ ( *)

CTRL+TAB onf Dialog box &Sd Tab wpfckrStjcm; Tab wpfckodkY

ajymif;a½GUjcif;/ (C)

CTRL + PAGE DOWN Arrow keys onf Drop-down list twGi;f &Sd Option wpfcr k S wpfct k Mum; a½GUajymif;jcif; (odrYk [kw)f Option group twGi;f option wpfcrk w S pfco k Ykd ajymif;a½GUjcif;/

( i)

SPACEBAR onf a½G ; cs,f x m;aom Command button rsm;udk aqmif½u G af pcdik ;f jcif; (odrYk [kw)f Check box rsm;rS Check mark rsm;tm;

jzKwjf cif;ESiw hf yfjcif;/ ( p)

ALT+DOWN ARROW onf a½G;cs,x f m;aom Drop down list wpfck

udk zGijhf cif;/

133 (q)

Microsoft Excel 2002

ENTER onf Dialog box twGif;&Sd Command button udk aqmif½u G f

apjcif;/ ( Z)

ESC onf Command udk Cancel vkyjf cif; (odr Yk [kw)f dialog box

ydwjf cif; ponfwjYkd zpfygonf/ Edit boxes

9/ Dialoges box twGif;&Sd Edit boxes rsm;udk toH;k jyKonfh Shortcut key rsm;rSm atmufygtwdkif; jzpfygonf(u)

HOME onf Entry \tpydi k ;f odYk Selector a½GU&ef/

( c)

END onf Entry \ tqH;k ydi k ;f odYk Selector a½GU&ef/

( *)

LEFT ARROW or RIGHT ARROW onf Character wpf v H k ; \

b,fnmodaYk ½GU&ef/ (C)

CTRL+LEFT ARROW onf Word wpfv;kH \ b,fbufoYkd a½GU&ef/

( i)

CTRL + RIGHT ARROW onf Word wpfv;kH \

nmbufoaYkd ½GU&ef/ ( p)

SHIFT+LEFT ARROW onf b,fbufodkY Character wpfvHk;pm

a½G;&ef/ (q)

SHIFT+RIGHT ARROW onf nmbufoYkd Character wpfvHk;pm

a½G;&ef/ ( Z)

CTRL + SHIFT + LEFT ARROW onf b,fbufoYkd Word wpfv;kH pm

a½G;&ef/ (ps)

CTRL + SHIFT + RIGHT ARROW onf nmbufoYkd Word wpfv;kH

pm a½G;&ef/ (n)

SHIFT+HOME onf Insertion point rS Entry tpodkY a½G;&ef/

( #)

SHIFT+END onf Insertion point rS Entry tqH;k odYk a½G;&efponfwYkd

jzpfygonf/

uG e f y sLwmvuf p J G

134

Open, Save As, and Insert Picture dialog boxes

10/

Open, Save As and Insert Picture dialoges boxs twGuftoHk;jyKonfh Shortcuts key rsm;rSm atmufygtwdi k ;f jzpfygonf-

(u)

ALT+1onf a&SU Folder odYk jyefomG ;&ef/

( c)

ALT+2 onf zGix hf m;aom Folder \ wpfqifhjrifhaom Folder odkY

oGm;&ef/ ( *)

ALT+3 onf Web search page udk oGm;&ef/

(C)

ALT+4 onf a½G;xm;aom Folder (odr Yk [kw)f File udk zsu&f ef/

( i)

ALT+5 onf Folder wpfcktopfaqmuf&ef/

( p)

ALT+6 onf Folders rsm;tMum; jrifui G ;f ajymif;Munf&h ef/

(q)

ALT + 7 or ALT + L onf Tools menu udk zGi& hf ef/

( Z)

SHIFT+F10 onf a½G;cs,x f m;aom Folder (odrYk [kw)f File uhJodkY Item rsm;\ Shortcut udk jy&ef/

(n)

TAB onf Options rsm;tMum; (odr Yk [kw)f dialog box twGi;f a½GU&ef/

( #)

F4 or ALT + I onf Look in list udk zGi& hf ef/

( X)

F5 onf File list udk jrifui G ;f topfjyefp&ef ponfwjYkd zpfygonf/

Workbooks and Worksheets

11/ Workbooks and Worksheets twGuftoHk;jyKonfh Shortcuts key rsm;rSm atmufygtwdkif; jzpfygonf(u)

CTRL+P or CTRL+SHIFT+F12 onf Print dialog box udz k iG jhf cif;/

( c)

Arrow keys onf Print preview wGif Zoomed in (Preview udk tBu;D cJsUxm;ygu)wGif Arrow key rsm;jzifh Page wpfcv k ;kH udk a½GUMunfh

Edik &f ef/

135 ( *)

Microsoft Excel 2002

PAGE UP or PAGE DOWN onf Print preview wGif Zoomed out ( Preview udk csKUH xm;ygu ) wGif Screen wpfrsuE f mS pm txufatmuf

a½GUMunfEh ikd &f ef/ (C)

CTRL + UP ARROW or CTRL + LEFT ARROW onf Print preview wGif Zoomed out(Preview udc k sKUH xm;ygu)wGif yxrpmrsuEf mS

odYk a½GUMunfEh ikd &f ef/ ( i)

CTRL + DOWN ARROW or CTRL + RIGHT ARROW onf Print preview wGif Zoomed out (Preview udk csKHUxm;ygu) wGif

aemufq;kH pmrsuEf mS odYk a½GUMunfEh ikd &f ef ponfwjYkd zpfygonf/ Worksheets

12/ Worksheets twGut f oH;k jyKonfh Shortcuts key rsm;rSm atmufygtwdik ;f jzpfyg onf(u)

SHIFT+F11 or ALT+SHIFT+F1 onf Worksheet topf w pf c k

xyfw;kd &ef/ ( c)

CTRL+PAGE DOWN onf Workbook wpfc& k dS aemuf Sheet odkY

a½GU&ef/ ( *)

CTRL+PAGE UP onf Workbook wpfck&Sd a&SU Sheet odYk a½GU&ef/

(C)

SHIFT+CTRL+PAGE DOWN onf vuf&dS Worksheet ESifh aemuf Sheet wdu Yk kd aygif;í a½G;cs,&f ef/

( i)

SHIFT+CTRL+PAGE UP onf vuf&dS Worksheet ESifh a½SU Sheet

wdu Yk kd aygif;í a½G;cs,&f ef/ ( p)

ALT + O +H + R onf vuf&dS Worksheet tm; trnfajymif;&ef/ (Format menu, Sheet submenu, Rename command).

(q)

ALT+E + M onfvuf&dS Sheet udk Move or Copy jyKvy k &f ef/ (Edit menu, Move or Copy Sheet command).

uG e f y sLwmvuf p J G ( Z)

136

ALT+E + L onf vuf&dS Sheet udk Delete vky& f ef ponfwjYkd zpfygonf/

Move and scroll within Worksheets ( Worksheets twGif; Move and Scroll jyKvkyfjcif; )

13/ Worksheets twGi;f Move and Scroll Shortcuts key rsm;rSm atmufyg twdik ;f jzpfygonf(u)

Arrow keys onf Selector udk txuf? atmuf? ab;? b,fnm a½GU&ef/

( c)

CTRL + arrow key onfvuf&dS Data {&d,m\ axmifp h eG ;f odYk a½GU&ef/

( *)

HOME onf vuf&dS Worksheet \tpydkif; Column oYkd a½GU&ef/

(C)

CTRL + HOME onf vuf&dS Worksheet \a&SUtay:qHk; Cell odkY

a½GU&ef/ ( i)

CTRL+END onf vuf&dS Worksheet \aemufq;kH Cell oYkd a½GU&ef/

( p)

PAGE DOWN = Screen wpfcp k m atmufoaYkd ½GU&ef/

(q)

PAGE UP onf Screen wpfcp k m tay:odYk a½GU&ef/

( Z)

ALT + PAGE DOWNonf Screen wpfckpm nmzufodkY a½GU&ef/

(ps)

ALT + PAGE UP onf Screen wpfcp k m b,fbufoYkd a½GU&ef/

(n)

F6 onf Split command ay;xm;pOf Worksheet twGi;f Pane wpfcr k S Pane wpfco k Ykd oGm;jcif;/

( #)

SHIFT+F6 onf Split command ay;xm;pOf Worksheet twGi;f Pane wpfcrk S Pane wpfco k Ykd aemufjyefomG ;jcif;/

( X)

CTRL+BACKSPACE onf Active cell udk Scroll vkyí f Munf&h ef/

( !)

F5 onf Go to dialog box oYkd oGm;&ef/

( ¡)

SHIFT + F5 onf Find dialog box oYkd oGm;&ef/

137

Microsoft Excel 2002

(P)

SHIFT + F4 onf Find action udk xyfra H qmif½u G &f ef/

(w)

TAB onf Protected worksheet wGif Unlocked cell wpfcr k S wpfcMk um;

oGm;&ef ponfwYkd jzpfygonf/ Move within a Selected range ( Selected range twGif;a½GUjcif; )

14/ Selected range twGif;&Sd Move jyKvkyfrnfh Shortcuts key rsm;rSm atmufyg twdkif; jzpfygonf(u)

ENTER onf Selected range twGi;f tay:rSatmufoYkd a½GU&ef/

( c)

SHIFT + ENTER onf Selected range twGi;f atmufrt S ay:odYk

a½GU&ef/ ( *)

TAB onf Selected range twGi;f b,frn S modYk a½GU&ef/

(C)

SHIFT + TAB onf Selected range twGi;f nmrSb,foYkd a½GU&ef/

( i)

CTRL+PERIOD onf Selected range twGif; axmifhwpfckrSaemuf

wpfco k Ykd em&Dvufwt H wdik ;f a½GU&ef/ ( p)

CTRL+ALT+ RIGHT ARROW onf wpfqufwnf;r[kwfaom

a½G;cs,rf w I iG f a½G;cs,rf rI n S mzufoYkd a½GU&ef/ (q)

CTRL + ALT + LEFT ARROW onf wpfqufwnf;r[kwfaom

a½G;cs,rf w I iG f a½G;cs,rf rI b S ,fzufoYkd a½GU&efponfwjYkd zpfygonf/ rSwcf su/f

Enter or Shift + Enter udk aqmif½u G &f mwGiDirection f of movement uda k jymif;vJay;Edik o f nf/ Tools menu &Sd Option command udk Click vkyí f Edit tab udk a½G;cs,Nf y;D Move seclection after Enter settings udk

ajymif;vJay;&ygrnf/

uG e f y sLwmvuf p J G

138

Move and scroll in End mode ( End mode twGif;a½GUjcif; )

15/ End mode twGif;toHk;jyKonfh Shortcuts key rsm;rSm atmufygtwdkif; jzpfygonf(u)

END udE k ydS yf gu End mode udak &muf&ydS gonf/ Status Bar ay:wGif End [kay:vmygrnf/

( c)

END key onf End mode \ tzGifhtydwf Switch jzpfygonf/

( *)

END + arrow key onf Data block wpfc\ k Row or Cloumn \

ay:qHk;? atmufqHk;ESifh ab;b,fnma&SUaemufodkY oGm;vdkvQif toHk;jyK ygonf/ (C)

END + HOME onf Worksheet wpfc\ k atmufq;kH toH;k jyKxm;aom Row ESihf nmzuftpGeq f ;kH toH;k jyKxm;aom Column odYk a½GU&ef/

( i)

END+ENTER onf vuf&dS Row \ nmzuftpGeq f ;kH Data &Sdonfh Cell udk oGm;&ef ( tu,fí ra½GUygu Tools Menu &Sd Options command udk Click vkyí f Transition tab udak ½G;cs,Nf y;D Transition navigation key &Sd Check mark udjk zKwy f g/) ponfwjYkd zpfygonf/

Scroll Lock

16/

Scroll lock wGit f oH;k jyKonfh Shortcut key rsm;rSm atmufygtwdik ;f jzpfygonf-

(u)

Scroll lock udk ESy d jf cif;jzifh Scroll lock udk zGi^hf ydwrf I jyKvyk Ef ikd yf gonf/ Scroll lock vkyx f m;ygu Selected Cells rsm;onf ajymif;vJrrI &Sb d J Page Up, Page Down jyKvy k Ef ikd yf gonf/

( c)

HOME onf Windows \tay:qH;k b,fzufaxmifu h kd a½GU&ef/

( *)

END onf Windows \atmufq;kH nmzufaxmifu h kd a½GU&ef/

(C)

UP ARROW or DOWN ARROW onf Row wpfckpm tay:

atmufodkY a½GU&ef/

139 ( i)

Microsoft Excel 2002

LEFT ARROW or RIGHT ARROW onf Column wpf c k p m

ab;b,f nmodaYk ½GU&ef ponfwjYkd zpfygonf/ Select cells, rows and columns, and objects ( Cells, rows and columns, and objects wdkYudk a½G;cs,fjcif; )

17/ Select cells, rows and column and cell wGiftoHk;jyKonfh Shortcuts key rsm;rSm atmufygtwdik ;f jzpfygonf(u)

CTRL+SPACEBAR onf Column wpfcv k ;kH udk a½G;&ef/

( c)

SHIFT+SPACEBAR onf Rows wpfcv k ;kH udk a½G;&ef/

( *)

CTRL+A onf Worksheet wpfcv k ;kH udk a½G;&ef/

(C)

SHIFT + BACKSPACE onf Cell range wpfcu k kd a½G;cs,x f m;pOf Active Cell udo k mvQif a½G;&ef/

( i)

CTRL + SHIFT + SPACEBAR onf object rsm;udk a½G;cs,fxm;pOf Active Object udo k mvQif a½G;&ef ponfwjYkd zpfygonf/

Enter Data

18/ Data xnfh&mwGif toHk;jyKonfh Shortcuts key rsm;rSm atmufygtwdkif; jzpf ygonf(u)

ENTER onf Cell twGif; Data entry jyKvk y f N yD ; ygu atmuf

wpfaMumif;udk a½G;vdkvQif ESdyf&ef/ ( c)

ALT + ENTER onf wlnDaom Cell twGi;f Line topfp&ef/

( *)

CTRL + ENTER onf a½G;cs,x f m;aom Cell range twGi;f data

xnf&h ef/ (C)

SHIFT + ENTER onf Cell twGi;f Data entry jyKvy k Nf y;D ygu txuf

wpfaMumif;udak ½G;vdv k Qif ESyd &f ef/

uG e f y sLwmvuf p J G ( i)

140

TAB onf Cell twGi;f Data entry jyKvy k Nf y;D ygu nmzufoYkd a½G;vdv k Qif

ESyd &f ef/ ( p)

SHIFT + TAB onf Cell twGi;f Data entry jyKvkyfNyD;ygu b,fbuf

odYk a½G;vdv k Qif ESyd &f ef/ (q)

ESC onf Cell twGi;f Data entry jyKvy k jf cif;udyk ,fzsu&f ef/

( Z)

Arrow keys onf Character wpfv;kH pm tay:atmuf ab;b,fnm

a½GU&ef/ (ps)

HOME onf Line \tpodYk a½GU&ef/

(n)

F4 or CTRL + Y onf aemufq;kH aqmif½u G cf suu f kd xyfvyk &f ef/

( #)

CTRL + SHIFT + F3 = Row ESifh Column trnf r sm;rS Name

trnfoYkd ajymif;vJ&ef ponfwjYkd zpfygonf/ yHk(11-2)

yHk(11-2) ( X)

CTRL + D onf tay: Data twdi k ;f atmufoYkd Fill vky&f ef/

( !)

CTRL + R onf b,fbuf Data twdi k ;f nmzufoYkd Fill vky&f ef/

( ¡)

CTRL + F3 onf Row (odkYr[kwf) Column \ Cell reference trnfrsm;udk Name tjzpfoYkd ajymif;vJ&ef/ ( Define NAMES )

(P)

CTRL + K onf Hyperlink udk Insert vky& f ef/

141

Microsoft Excel 2002

(w)

CTRL + ; (semicolon) onf Date xnf& h ef/

(x)

CTRL + SHIFT + : (colon) onf Time xnf& h ef/

( ')

ALT + DOWN ARROW onf List wpfct k wGi;f wef;zd;k rsm;udk Drop down list tjzpf az:jy&ef/

( ")

CTRL + Z onf aemufq;kH aqmif½u G af om vkyaf qmifcsuu f kd jyefvnf

jyifqifjcif; ponfwjYkd zpfygonf/ Special Character

19/

Cell wpfcu k kd Edit vkyf&ef F2 udk ESyd yf g/ NUM LOCK udk On xm;Ny;D ? atmufyg Key rsm;udk Numeric Key Pad rS½u kd yf g/ Shortcuts key rsm;rSm atmufygtwdkif; jzpf

ygonf(u)

ALT + 0162 onf

( c)

ALT+ 0163

onf £ pound sterling character ud½k u kd &f ef/

( *)

ALT+ 0165

onf ¥ yen symbol ud½k u kd &f ef/

(C)

ALT+ 0128

onf € euro symbol ud½k u kd &f ef ponfwjYkd zpfygonf/

¢ cent character ud½ k u kd &f ef/

Enter and Calculate Formula

20/

Formula wGit f oH;k jyKonfh Shortcuts key rsm;rSm atmufygtwdik ;f jzpfygonf-

(u)

= (equal sign) onf Formula udp k wif&ef/

( c)

F2 onf Editing vkyf&eftwGuf Cell twGi;f Cursor xnf& h ef/

( *)

BACKSPACE onf Formula Bar wGif b,fbuf&Sd Character

udzk su&f ef/ (C)

ENTER onf Formula Bar ESihf Cell twGi;f Data entry Ny;D jynfp h kH

ygu ESyd &f ef/

uG e f y sLwmvuf p J G

142

( i)

CTRL + SHIFT + ENTER onf Array Formula udk xnf& h ef/

( p)

ESC onf Formula Bar ESihf Cell twGi;f Entry vkyjf cif;rS y,fzsu& f ef/

(q)

SHIFT + F3 onf Formula twGi;f Function udk Insert vky& f ef/

( Z)

CTRL + A onf Formula wpfckwGif Function name \nmzufwi G f Function Arguments dialog ay:vdkvQif oHk;&ef/

(ps)

CTRL + SHIFT + A onf Formula wpfckwGif Function name \nmzufwGif Arguments name ESihf Parentheses ay:vdkvQif oH;k &ef/

(n)

F3 onf Formula twGi;f Defined name udk Paste vky& f ef/

(#)

ALT + = (equal sign) onf Autosum formula udk Insert vky& f ef/

(X)

CTRL + ‘ (single left quotation mark) onf Cell twGif;&Sd wef;zdk; rsm;ESihf Formula tMum; wpfvn S phf jD y&ef ponfwjYkd zpfygonf/

Edit Data

21/ Data rsm;udk Edit vkyf&mwGif toHk;jyKonfh Shortcuts key rsm;rSm atmufyg twdkif; jzpfygonf(u)

CTRL + C onf a½G;cs,x f m;aom Cell tm; ul;,l&ef/

( c)

CTRL + C udk csuc f si;f ESpcf gqufwu kd f ESyd yf gu Microsoft office clipboard ay:vmrnf/ tqufrjywf Copy & Paste vkyv f v kd Qio f ;kH &ef/

( *)

CTRL + X onfa½G;cs,x f m;aom Cell tm; jzwf&ef/

(C)

CTRL + V onf ul;,lxm;aom Cell contents rsm;tm; Paste vky& f ef/

( i)

DELETE onfa½G;cs,x f m;aom Cells contents rsm;tm; zsu&f ef/

( p)

CTRL + HYPHEN onf a½G;cs,x f m;aom Cells rsm;tm; zsu&f ef/

(q)

CTRL+SHIFT+ PLUS SIGN onf Cell tvGwfrsm;tpm;oGif;&ef

ponfwjYkd zpfygonf/

143

Microsoft Excel 2002

Insert, Delete and Copy Cells

22/ Insert, Delete and Copy cells wGif toHk;jyKonfh Shortcuts key rsm;rSm atmufygtwdkif; jzpfygonf(u)

ALT + ’ (apostrophe) onf Style dialog box udk az:jy&ef/

( c)

CTRL + 1 onf Format Cell dialog box udk az:jy&ef/

( *)

CTRL + SHIFT + ~ onf General number format ud k

aqmif½u G &f ef/ (C)

CTRL + SHIFT + $ onf 'or(2)ae&m&S d Currency format

udak qmif½u G &f ef/ ( i)

CTRL + SHIFT + % onf Percentage format uda k qmif½u G &f ef/

( p)

CTRL + SHIFT + ^ onf 'or(2)ae&m&Sd Exponential number format udk aqmif½u G &f ef/

(q)

CTRL + SHIFT + # onf Day, Month ESifh year ygaom Date format udk aqmif½u G &f ef/

( Z)

CTRL + SHIFT + @ onf Hour & Minutes and AM or PM ygaom Time format udak qmif½u G &f ef/

( ps)

CTRL + SHIFT + ! onf 'or(2)ae&m&Sd Thousands separator ESihf Minus sign ygaom Number format udk aqmif½u G &f ef/

(n)

CTRL + B onf Bold format udk wyfqif&ef(odr Yk [kw)f jzKw&f ef/

( #)

CTRL + I

( X)

CTRL + U onf Underline format ud k wyf q if & ef ( od k Y r [k w f )

onf Italic format udk wyfqif&ef(odrYk [kw)f jzKw&f ef/

jzKw&f ef/ ( !)

CTRL + 5

onf Strikethrough udk wyfqif&ef(odrYk [kw)f jzKw&f ef/

uG e f y sLwmvuf p J G

144

( ¡)

CTRL + 9 onf a½G;cs,x f m;aom Row udk azsmuf&ef/

(P)

CTRL + SHIFT + ( (opening parenthesis) onf a½G;cs,x f m;aom Rows rsm;udk azsmuf&ef (odr Yk [kw)f jyefaz:&ef/

(w)

CTRL + 0 (zero) onfa½G;cs,x f m;aom Columns rsm;udk azsmuf&ef/

(x)

CTRL + SHIFT + ) (closing parenthesis) onf a½G;cs,x f m;aom azsmufxm;onfh Columns rsm;udk jyefaz:&ef/

( ')

CTRL + SHIFT + & onf a½G;cs,x f m;aom Cells rsm;tm; Outline border wyfqifjcif;/

( ")

CTRL + SHIFT + _ onf a½G;cs,x f m;aom Cells rsm;tm; Outline f ef ponfwYkd jzpfygonf/ border wyfqifxm;rIrS zsu&

Format Data

23/ Format Cell dialog box tm;zGix hf m;pOf Data rsm;udk Format jyKvkyf&mwGif toHk;jyKonfh Shortcuts key rsm;rSm atmufygtwdik ;f jzpfygonf(u)

CTRL + 1 onf Format Cell dialog box tm;zGijhf cif;/

( c)

ALT + T

onf Top border udw k yfqifjcif;(odrYk [kw)f jzKwjf cif;/

( *)

ALT + B

onf Bottom border udw k yfqifjcif;(odrYk [kw)f jzKwjf cif;/

(C)

ALT + L

onf Left border udw k yfqifjcif;(odrYk [kw)f jzKwjf cif;/

( i)

ALT + R

onf Right border udw k yfqifjcif;(odrYk [kw)f jzKwjf cif;/

( p)

ALT + H

onf Horizontal divider udkwyfqifjcif;(odkYr[kwf)

jzKwjf cif;/ (q)

ALT + V

( Z)

ALT + D

onf Vertical divider udw k yfqifjcif;(odrYk [kw)f jzKwjf cif;/

onf Downward diagonal border rsm;udkwyfqifjcif; (odrYk [kw)f jzKwjf cif;/

145 (ps)

Microsoft Excel 2002

onf Upward diagonal border rsm;udkwyfqifjcif; (odrYk [kw)f jzKwjf cif; ponfwYkd jzpfygonf/

ALT + U

Use Data forms

24/ Database wGif toHk;jyKonfh Data formstwGuf Shortcuts key rsm;rSm atmufygtwdik ;f jzpfygonf/yHk (11-3)-

yHk (11-3)

(u)

DOWN ARROW onf aemuf Record wpfckodkY a½GU&ef/

( c)

UP ARROW onf a&SU Record wpfckodkY a½GU&ef/

( *)

TAB and SHIFT+TAB onf Record wpf c k & S d Field wpf c k r S

wpfco k aYkd ½GU&ef/ (C)

ENTER onf aemuf Record \ yxr Field oda Yk ½GU&ef/

( i)

SHIFT+ENTER onfa&SU Record \ yxr Field oda Yk ½GU&ef/

( p)

PAGE DOWN onfwn l aD om Field wGif Record q,fcpk m aemufoYkd

a½GU&ef/

uG e f y sLwmvuf p J G

146

(q)

CTRL+PAGE DOWN onf Blank record topfukd pwif&ef/

( Z)

PAGE UP onf wlnDaom Field wGif Record q,fcp k ma&SUodYk a½GU&ef/

( ps)

CTRL+PAGE UP onf yxr Record odYk a½GU&ef/

(n)

HOME or END onf Field wpfc\ k tp (odrYk [kw)f tqH;k odYk a½GU&ef/

( #)

LEFT ARROW or RIGHT ARROWonf Field xJwGif Character

wpfv;kH \ a&SU (odrYk [kw)f aemufoaYkd ½GU&ef/ ( X)

SHIFT + LEFT ARROW onf Field xJwi G f b,fbuf&dS Character

udak ½G;&ef/ ( !)

SHIFT + RIGHT ARROW onf Field xJwi G f nmbuf&dS Character

udak ½G;&ef ponfwjYkd zpfygonf/ Filter lists

25/ Filter lists twGuf toHk;jyKonfh Shortcuts key rsm;rSm atmufygtwdkif; jzpfygonf(u)

ALT + DOWN ARROW onf Drop-down arrow ygaom Cell twGi;f wGif Autofilter list udMk unf&h ef/yHk (11-4)

yHk (11-4)

147 ( c)

Microsoft Excel 2002

DOWN ARROW onf AutoFilter list wGif aemuf Item wpfcu k kd

a½G;&ef/ ( *)

UP ARROW onf AutoFilter list wGif a&SU Item wpfcu k kd a½G;&ef/

(C)

ALT + UP ARROW onf vuf&dS Column &Sd AutoFilter list udk

jyefyw d &f ef/ ( i)

HOME onf AutoFilter list xJ&dS yxrqH;k Item (ALL) uda k ½G;&ef/

( p)

END onf AutoFilter list xJ&dS aemufq;kH Item uda k ½G;&ef/

(q)

ENTER onf AutoFilter list xJ&dS a½G;cs,x f m;aom Item \ Filter list udk Munf& h ef ponfwjYkd zpfygonf/

Outline Data

26/ Outline data wGif toHk;jyKonfh Shortcuts key rsm;rSm atmufygtwdkif; jzpfygonf(u)

ALT + SHIFT + RIGHT ARROW onf Rows (odr Yk [kw)f Column udk Group vky&f ef/

( c)

ALT + SHIFT + LEFT ARROW onf Rows (odr Yk [kw)f Column udk Ungroup vky&f ef/yHk (11-5)

yHk (11-5)

uG e f y sLwmvuf p J G ( *)

148

CTRL + 8 onf Outline symbols rsm;udk az:jy&ef (odkYr[kwf)

azsmuf&ef/ (C)

CTRL + 9 onf a½G;cs,x f m;aom Rows udk azsmuf&ef/

( i)

CTRL + SHIFT + ( (opening parenthesis) onf a½G;cs,r f t I wGi;f rnfonfh azsmufxm;aom Rows udrk qdk jyefaz:jy&ef/

( p)

CTRL + 0 (zero) onf a½G;cs,x f m;aom Column udak zsmuf&ef/

(q)

CTRL + SHIFT + ) (closing parenthesis) onf a½G;cs,r f I twGi;f azsmufxm;aomrnfonfh Columns udkrqdk jyefaz:jy&ef ponf

wdjYk zpfygonf/ Charts

27/

Charts wGif toH;k jyKonfh Shortcuts key rsm;rSm atmufygtwdi k ;f jzpfygonf-

(u)

F11 or ALT + F1 onfa½G;cs,x f m;aom Data range twGuf Chart

wpfck wnfaqmuf&ef/ ( c)

CTRL + PAGE DOWN onf Workbook xJwGif Chart Sheet wpfcr k S

aemufwpfco k Ykd a½GU&ef/ ( *)

CTRL + PAGE UP onf Workbook xJwGif Chart Sheet wpfckrS

a½SUwpfco k Ykd a½GU&ef/ (C)

DOWN ARROW onf Chart wpfcw k iG f a½SU Group wpfcu k kd a½G;&ef/

( i)

UP ARROW onf Chart wpfcw k iG f aemuf Group wpfcu k kd a½G;&ef/

( p)

RIGHT ARROW onf Chart group wpfcx k w J iG f aemuf Element

wpfcu k kd a½G;&ef/ (q)

onf Chart group wpfckxJwGif a&SU Element wpfcu k kd jyefa½G;&ef ponfwjYkd zpfygonf/ LEFT ARROW

149

Microsoft Excel 2002

Drawing objects

28/

Screen ay:wGif Drawing Toolbar &Sdaeygu Drawing Toolbar ay:&Sd AutoShapes command odYk oGm;vdv k Qif ALT + U udk ESyd yf g/ yHk (11-6)

yHk (11-6) Select a Drawing object

29/ Drawing object wpfcrk S pmrsm;udk jyifqifvykd gu object udk a½G;cs,yf g/ object wpfcrk w S pfco k Ykd oGm;vdyk gu Tab key udk ESyd yf g/ aemufjyefomG ;vdyk gu Shift + Tab udk ESyd yf g/ Worksheet wpfcw k iG f atmufygtwdik ;f pwifjyKvyk Ef ikd yf gonf(u)

F10 udk ESy d yf g/ Menu bar udk a½G;cs,af y;ygvdrrhf nf/

(c )

Ctrl + Tab udk ESy d yf g/ Drawing Toolbar udk a½G;cs,Ef ikd yf gonf/

(* )

Ny;D aemuf Right Arrow udEk ydS yf g/ Select Objects Button udak ½G;yg/

(C)

Ctrl + Enter udE k ydS yf gu yxrqH;k Drawing object udk a½G;cs,yf gvdrrhf nf/

uG e f y sLwmvuf p J G

150

Tab key udk ESy d yf gu Object wpfcrk w S pfco k Ykd Forward tpDtpOftwdkif; a½G;cs,yf gvdrrhf nf/ Shift + Tab udk ESyd yf gu Reverse tpDtpOftwdkif;

a½G;ygrnf/ (i)

Deselect jyKvy k v f ykd gu Esc key udEk ydS yf g/

AutoShape

30/ AutoShape wGif toHk;jyKonfh Shortcuts key rsm;rSm atmufygtwdik ;f jzpfyg onf(u)

Drawing Toolbar ay:&Sd AutoShapes Menu uda k ½G;vdv k Qif Alt + U

udEk ydS yf g/ (c)

tvd&k &dS m AutoShapes Category udk Arrow key udk toH;k jyKía½GUyg/ Ny;D aemuf Right Arrow udEk ydS yf g/ Arrow key udk toH;k jyKí tvd&k &dS m AutoShape udk a½G;yg/

(*)

Ny;D aemuf Ctrl + Enter udk ESyd yf g/ a½G;cs,x f m;aom AutoShape udk Worksheet wGia f y:vmygrnf/

(C)

AutoShape \Format udk jyifvdkygu Ctrl + 1 udkESdyfyg/ Format AutoShape dialog box ay:vmygrnf/

Text box

31/ Text box twGif;toHk;jyKonfh Shortcuts key rsm;rSm atmufygtwdik ;f jzpfyg onf(u)

F10 udk ESy d yf g/ Menu bar udk a½G;cs,af y;ygvdrrhf nf/

(c)

Ctrl + Tab udk ESy d yf g/ Drawing Toolbar udk a½G;cs,Ef ikd yf gonf/

(*)

Ny;D aemuf Right Arrow udEk ydS yf g/ Select Text Box Button udak ½G;yg/

(C)

Ctrl + Enter udk ESy d yf g/ tvd&k &dS m Text ud½k u kd yf g/

(i)

pmvH;k rsm;udk ½du k Nf y;D ygu Worksheet odYk jyefomG ;vdv k Qif Esc Key udk ESpBf urd Ef ydS yf g/

151 (p )

Microsoft Excel 2002

tu,fí Text box &Sd Format udjk yifvykd gu Esc key udEk ydS Nf y;D Ctrl + 1 udE k ydS yf g/ Format Text dialog box ay:vmrnf/ jyifqifíNy;D ygu Enter Key udkESdyfyg/ Worksheet odkY jyefoGm;vdkygu Esc key udk qufEydS yf g/

WordArt

32/ WordArt twGif;toHk;jyKonfh Shortcuts key rsm;rSm atmufygtwdik ;f jzpfyg onf(u)

Alt + I udk ESy d yf g/ Ny;D aemuf P qufEydS yf g/ Ny;D aemuf W udk qufEydS yf g/ WordArt dialog Box ay:vmygrnf/

(c )

Arrow Key udk toHk;jyKí WordArt Style udk a½G;cs,y f gonf/

(* )

Ny;D aemuf Enter Key udEk ydS yf g/ tvd&k &dS m Text ud½k u kd yf g/ Tab Key udktoHk;jyKí dialog box twGi;f &St d jcm; Option rsm;udak ½G;Edik yf gonf/

(C)

Enter udk ESy d yf g/ WordArt object onf Worksheet twGif; a&muf&Sd

oGm;ygrnf/ (i )

WordArt object udk Format vkyv f ykd gu WordArt Toolbar ay:&Sd Tool rsm;udt k oH;k jyKEikd yf gonf/ (odrYk [kw)f Ctrl + 1 udEk ydS yf g/ Format WordArt dialog box ay:vmrnf/ yHk (11-7)

yHk (11-7)

uG e f y sLwmvuf p J G

152

Rotating Drawing object

33/ Drawing object twGuf Rotating object jyKvkyf&ef Shortcuts key rsm;udk atmufygtwdkif; toHk;jyKEdkifygonf(u) 'D*&DvSnfhvdkaom Drawing object udk a½G;yg/ (c) Ctrl + 1 udk ESyd yf g/ Format Autoshape dialog box ay:vmrnf/ Size d yf g/ tab udka½G;&ef Ctrl + Tab udk ESy (*) Rotation box udk a½G;&ef Alt + T udk ESyd yf g/ Arrow key udk toH;k jyKí vdt k yfonfh 'D*&D udak ½G;yg/ yHk (11-8)

yHk (11-8)

Change the size of a Drawing object 34/ Drawing object twGif;&Sd Size ajymif;vJ&ef toHk;jyKonfh Shortcuts key

rsm;rSm atmufygtwdik ;f jzpfygonf(u) Resize vkyfvdkaom Drawing object udk a½G;yg/ (c) Ctrl + 1 udk ESyd yf g/ Format AutoShape dialog box ay:vmrnf/ Size tab udka½G;&ef Ctrl + Tab udk ESy d yf g/ (*) Size ajymif;vdak om Option udk a½G;yg/

153

Microsoft Excel 2002

Move a Drawing object 35/ Drawing object twGif;&Sd Move a½GUajymif;&eftoHk;jyKonfh Shortcuts key

rsm;rSm atmufygtwdik ;f jzpfygonf(u) a½GUvdkaom Drawing object udak ½G;yg/ (c ) Arrow key udk ESdyfí object udka½GUoGm;yg/ Position wdwdusus a½GUvdkygu CTRL + Arrow key udk toH;k jyKía½GUyg/ Copy Drawing objects and their attributes 36/ Drawing Object wpfcu k kd ul;,lvykd gu object udk a½G;cs,fí CTRL + D udk ESyd yf g/ Copy jyKvyk &f mwGif ,if; Object ütjcm;aom object rS Attributes rsm; OyrmLine Style rsm;? Fill Color rsm;ygvdy k gu atmufygtwdik ;f aqmif½u G yf g/ (u) ul;,lvakd om Drawing Object udak ½G;yg/ (c) Ctrl + Shift + C udk ESyd yf g/ (* ) Tab Key jzifh ajymif;vdak om tjcm; object wpfcu k kd a½G;yg/ (C) Ctrl + Shift + V udk ESyd yf g/ xdt k cg tjcm; object rS Attributes rsm;

a&muf&v dS mygrnf/yHk (11-9)

yHk (11-9)

uG e f y sLwmvuf p J G

154 Chapter (12) Macro

About Macros ( Macros taMumif; )

1/ Microsoft Excel wGif xyfwvJvJ jyKvkyfae&aom vkyfief;wpfckudk tvG,f wul vkyfaqmifEdkif&ef tvdktavsmuf vkyfaqmifay;Edkifaom Macro [kac:aom Command wpfck yg&Sy d gonf/ Macro qdo k nfrmS Microsoft Visual Basic module wGif Excel rSrrd ad qmif½u G v f u kd af om Commands & Functions rsm;udk tpDtpOftvdu k f File wpfcktaejzifh odrf;qnf;ay;xm;ygonf/ xdkzdkifudk Run vdkufygu tpDtpOfvdkuf xnfhoGif;xm;aom Command & Function rsm;u tvkyfvkyfay;ygonf/ xdkUaMumifh xyfwpfvv J aJ qmif½u G &f aom vkyif ef;rsK;d udk Macro file jyKvyk Nf y;D odr;f qnf;xm;jcif;jzifh aemifwiG f xdu k o hJ aYkd om tvkyrf sKk ;d xyfvyk &f ygu Macro file udk Run jcif;jzifh tvG,w f ul vQijf refpmG aqmif½u G Ef ikd rf nf jzpfygonf/ Oyrmtm;jzifh &Snv f Qm;aomText string wpfcu k kd Cell twGif; rMumcP ½dkufxnfhay;&onfqdkygu xdk Text string udk Macro file tjzpfwnfaqmufxm;Edik f ygonf/ 2/ Microsoft Excel wGif vkyfief;wpfckudk xyfwvJvJaqmif½Gufae&onfqdkvQif xdkvkyfief;udk Macro tjzpf Record vkyx f m;&ygrnf/ Macro wpfckudk Record jyKvyk f aomtcg Excel wGif tqifq h ifah qmif½u G o f mG ;aom Commands & Functions rsm;udk odr;f qnf;xm;&ygonf/ odrYk o S m xdk Commans & Functions rsm;udk xyfum wvJvJ jyefvnftvkyfvkyfapjcif;udk Run vkyfonf[kac:ygonf/ wpfenf;tm;jzifh Tape Recorder wpfckrS oDcsif;wpfyk'fudk xyfwvJvJjyefzGifhjcif; Play back jyKvkyfrsKd;ESifh qifwyl gonf/ tu,fí Macro wpfckudk Record vky&f mwGif trSm;jyKvyk rf yd gu xdk Record udkjyefvnfjyifqifay;Edkifygonf/ Visual Basic taejzif h Macro file toD;oD;udk Module topfwpfckpDjzifh Workbook udkjyefvnfqufoG,fay;Edkif&ef odrf;qnf;ay;ygonf/

155

Microsoft Excel 2002

Making a macro easy to run ( Macro wpfckudk tvG,fwpful Run Edkif&efaqmif½Gufjcif; ) 3/ Macro file wpfckudk Micro dialog box &Sd List wGifa½G;cs,fí Run Edi k yf gonf/ Micro file udk Worksheet xJwGif Run Edkif&ef oifhawmfaom Button udk Click vkyfívnf;aumif;? oifhawmfaom Key twJGudk ESdyfíaomfvnf;aumif;? Toolbar ay:wGif (odrYk [kw)f Keyboard shortcut tjzpf (odrYk [kw)f Worksheet ay:wGif graphic object wpfcktjzpf Assign vkyx f m;Edik yf gonf/ Managing macros ( Macro rsm;udk pDrHcefUcJGjcif; ) 4/ Macro wpfckudk Record vkyNf y;D ygu Visual Basic Editor ESifh Macro code rsm;udk trSm;uif;ap&efESifh jyifqifEdkif&ef Munfh½IEdkifygonf/ Visual Basic Editor qdkonfrSm y½dk*&rfwpfckjzpfNyD; Micro code rsm;udk tvG,fwula&;Edkif? jyifEdkifap&ef aqmif½u G af y;xm;ygonf/ 4if;wGif On line help rsm;udv k nf; xnfo h iG ;f ay;xm;ygonf/ Visual Basic Editor wGif Macro rsm;udk jyifEdkifygonf/ Module wpfckrSwpfckodkY ul;,lEikd yf gonf/ Module udkaomfvnf;aumif;? Macro udkaomfvnf;aumif; trnf

ajymif;ay;Edkifygonf/ Macro Security 5/ Security level udk yxrOD;pGm a½G;cs,fay;&ygrnf/ a½G;cs,fyHk tqifhqifhrSm(u) Tools menu udk Click vkyyf g/ Pull down menu usvmrnf/ 4if;rS Options command udk Click vkyy f g/ yH(k 12-1) (c ) Security tab udk a½G;yg/ (* ) Macro Security atmuf&Sd Macro Security udk Click vkyyf g/ (C) Security level tab udk Click vkyyf g/(yHk 12-2) Ny;D aemuf toH;k jyK vdak om Security level option udak ½G;yg/ xdak emuf OK udk Click vkyy f g/ Option Dialog Box ay:vmygu OK udk xyfrH Click vkyy f g/

uG e f y sLwmvuf p J G

156

yHk (12-1)

yHk(12-2)

Record a macro 6/ Macro wpfckudk Record jyKvkyfvdkygu atmufygtwdkif;vkyfaqmifyg(u) Tools menu udk Click vkyyf g/ Pull down menu usvmrnf/ (c) Macro command udk Point vkyyf g/ Sub menu wpfckay:vmrnf/ ( *) ay:vmaom Sub menu rS Record New Macro command udk Click

vkyyf g/

157 (C)

Microsoft Excel 2002

Record Macro dialog box ay:vmrnf/ yHk(12-3) Macro name box wGif Name ud½k u kd x f nfyh g/ rSwcf su/f Macro name \tp pmvHk;onf Letter jzpf&rnf/ tjcm; pmvH;k rsm;onf Letters, Numbers (odkYr[kwf) Underscore character jzpfEi kd yf gonf/ Macro name udk ay;&mwGif Space oH;k jcif;udk vufrcHyg/Underscore character udkvnf; Word wpfcE k iS w hf pfcMk um; Seperate vkyf&mwGif toHk;jyKygonf/ Cell reference rsm;ESifh Error message rsm;ud k Macro name tjzpf

toH;k jyKjcif;tm; cGirhf jyKyg/

yHk(12-3 )

(i )

Macro udk Keyboard shortcut taejzifh Run vdkvQif Shortcut key box wGif Letter wpfcu k kd owfrw S Ef ikd yf gonf/ Letter udk pmvHk;tao; jzifo h m owfrw S o f ifyh gonf/ Letter onf Keyboard ay:rS rnfonfh key rqdkjzpfEdkifaomfvnf; Special character rsm;jzpfonfh @, # wdkYudk

toH;k rjyKEikd yf g/ (p )

(q)

Store macro in box atmufwGif Micro ud k o d r f ; qnf ; xm;rnf h Location udkaz:jyay;&ygrnf/ Excel wGifrnfonfhtcsdefrqdk Micro udk toH;k jyKrnfqykd gu Personal Macro Workbook udk Select vkyyf g/ Micro \ Description udk az:jyvdkvQif Description box wGif

(Z )

az:jyEdkifygonf/ Ny;D aemuf OK udk Click vkyyf g/ Stop recording tools bar ay:vmrnf/

uG e f y sLwmvuf p J G (ps) (n)

158

Record vkyfvdkaom Action rsm;udk aqmif½u G yf g/ NyD;aemuf Stop recording tools bar ay:&Sd Stop button udk Click

vkyyf g/ Create a Macro by using Microsoft Visual Basic 7/ Macro wpfckudk Create jyKvkyfvdkygu atmufygtwdkif;vkyfaqmifyg(u) Tools menu udk Click vkyyf g/ Macro udk Point vkyyf g/ Visual Basic f g/ yHk (12-4 ) Visual Basic Editor ay:vmrnf/ Editor udk Click vkyy

yHk (12-4 )

(c)

Insert menu udk Click vkyy f g/ Pull down menu ay:vmrnf/ Module udk Click vkyyf g/ yHk (12-5) Code window ay:vmrnf/

yHk (12-5)

159 (* ) (C) (i )

Microsoft Excel 2002

ay:vmaom Code window wGif Visual basic code rsm;½du k x f nfyh g/ Module rS Macro udk Run vdkvQif Keyboard rS F5 udk Edy S yf g/ Macro udka&;NyD;ygu File menu ay:&S d Close and Return to Microsoft Excel udk Click vkyy f g/

Delete a Macro 8/ Macro wpfckudk Delete jyKvkyfvdkygu atmufygtwdkif;vkyfaqmifyg(u) zsufvdkaom Macro ygonfh Workbook udzk iG yhf g/ (c ) Tools menu udk Click vkyyf g/ Macro command udk Point vkyyf g/ Macro udk Click vkyy f g/ Micro dialog box ay:vmrnf/ yHk(12-6)

yHk (12-6) (* ) (C)

Macro in: Dropdown list rS This Workbook udk Click vkyy f g/ Macro name box rSzsuv f akd om Macro name udk Click vkyyf g/ Delete button udk Click vkyy f g/

uG e f y sLwmvuf p J G (i)

160

Comfimation dialog box ay:vmrnf/ zsuf&efaocsmygu Yes udk Click vkyy f g/ yHk (12-7)

yHk (12-7)

Run a macro 9/ Macro wpfckudk Run vkyfvdkygu atmufygtwdkif;vkyfaqmifyg(u) Tools rS Options udak &G;cs,yf g/ 4if;rS Security Tab udEk ydS yf g/ xdak emuf Macro Security udk Click vkyfí ay:vmaom Security Dialog f m;yg/ Box rS Security level udk Medium odkYr[kwf Low wGix (c) Macro yg0ifaom Workbook udk zGiyhf g/ Tools menu udk Click vkyyf g/ Pulldown menu ay:vmrnf/ Micro udk point vkyy f g/ Submenu ay:vmrnf/ Macro command udk Click vkyyf g/ (*) Macro dialog box ay:vmrnf/ 4if;rS Macro name box wGif Run vdkaom Macro udk ½du k x f nfyh g/ (C) Run button udk Click vkyyf g/ (odrYk [kw)f Microsoft Visual Basic f g/ Run Sub / User Form Editor udk zGifhí Run menu udk Point vkyy udk Click vkyyf g/

161

Microsoft Excel 2002

Exercises Microsoft Excel 2002 EXERCISE (1) NAME

MYANMAR

ENGLISH

MATHS

Ma Ma

55

65

76

Mg Mg

56

76

66

Aung Aung

70

60

60

Aye Aye

45

55

50

Mya Mya

55

50

50

Mg Kyaw

60

70

70

Mg Myint

70

80

75

Ma Yu

56

67

78

Ma Su

66

17

55

Mg Wa

70

45

50

TOTAL

1. Fill the above data into worksheet. 2. Find the total marks. 3. Insert one column at Column A and fill theRoll No. ( Example, T- 001, T- 002, T- 003, ... ) 4. Insert two rows at Row 1 and 2. 5. At Row 1and 2, type the heading “ Result of the Students ” “Standard 9th Section (A)” 6. Align the heading to the centre of worksheet, make bold type. 7. Save your workbook. ( RNO-999. XLS ) ( Example: RNO-012.XLS ) 8. Close your workbook.

uG e f y sLwmvuf p J G

162 EXERCISE (2)

Area

Budget

Actual

Bagan

1200

1185

Meiktila

3000

2770

Kalaw

600

760

Bago

2400

1800

Pyay

2800

2880

Actual as A% Budget

Total Maximum Average

Fill the data into the worksheet and calculate the required cells. Actual as A% of budget = Actual value devided by Budget. EXERCISE (3) JAN-MAR SALES

APR-JUN

JUL-SEP

OCT-DEC

14000

15000

16000

24000

2000

2300

2000

2300

600

600

1200

1200

RENT

1200

1200

1200

1200

ADVERTISEMENTS

4900

6600

7000

1600

COSTS SALARIES INTERESTS

TOTAL COST PROFITS

1. 2. 3. 4.

Fill the above data into worksheet. Find the total costs and profits, by using function and formula. Insert two rows at Row 1 and 2. Typing the heading at row 1 and 2 “ Income Projection 1999 ” and “ Super One Store ”

163

Microsoft Excel 2002

5. At heading change the font to Arial font, size is 12 point and Bold, Italic style. Align the heading to the centre of worksheet. 6. Change the number format ( #,##0) style. 7. Draw the require border line.

Myanmar

English

Maths

Physics

Chemistry

Biology

EXERCISE (4)

N.0001 Aung Aung N.0002 Mg Mg

50 45

62 66

85 87

44 46

65 75

44 55

N.0003 Kyaw Kyaw N.0004 Ko Ko

55 60

65 88

75 72

46 68

12 46

66 90

N.0005 Ma Hlla N.0006 Ma Win

56 55

42 75

87 90

65 46

82 72

91 68

N.0007 Ma Aye N.0008 Ma Nilar

44 56

55 32

80 95

73 88

41 70

67 60

N.0009 Ma Thida N.0010 Ma Nyo Nyo

66 88

43 75

51 100

62 56

46 75

48 85

Roll No.

1. 2. 3. 4.

Name

Total

Result

Fill the above data into worksheet. Calculate the total At least column, fill the Result field. ( Passed or Fail ) Save your worksheet with new filename. ( Result-000.XLS ) Sort your database record by first key as result and second key as total.

uG e f y sLwmvuf p J G

164 EXERCISE (5)

SRNO. NAME

1. 2,

3.

RANK

SALARY

DEPARTMENT

UNIVERSITY

1 DAW HLA HLA

A.L

1650 MATHS

YANGON

2 U MYA MG

A.L

1625 PHYS

MANDALAY

3 U MYA

A.L

1650 CHEM

MANDALAY

4 DAW SU SU

A.P

1750 MATHS

YANGON

5 DAW HLA

L

1500 CHEM

YANGON

6 DAW YEE YEE

L

1550 MATHS

YANGON

7 U YE AUNG

L

1525 PHYS

MANDALAY

8 U KYAW AYE

TUTOR

1250 PHYS

YANGON

9 DAW AYE

TUTOR

1225 CHEM

YANGON

10 DAW NYO

TUTOR

1275 MATHS

MANDALAY

11 DAW MYA

DEMO

1275 MATHS

YANGON

12 DAW SEIN

DEMO

1150 CHEM

YANGON

13 U AUNG

A.P

1700 CHEM

YANGON

14 U SOE MYINT

DEMO

1200 MATHS

MANDALAY

15 DAW WIN WIN

DEMO

1150 PHYS

YANGON

Fill the data into worksheet. Extract the record which met the following condition. (a) University Yangon. (b) Rank A.L (c) Rank Tutor and Department Chemistry. (d) Rank A.P or L. (e) University Yangon and Department Physics. (f) Rank Lecturer or Salary greater than 1300. (g) First Name start with “U” Save your worksheet. ( STUFR001.XLS )

165

Microsoft Excel 2002

Amount

Quantity

Item Name

Unit Price

EXERCISE (6)

Book

50

20

Pen

200

5

Ruler

25

15

Ink

75

4

Eraser

45

50

Ball Pen

35

20

8

30

125

5

Pencil Soft Pen

Grand Total

1. 2. 3. 4. 5. 6.

7. 8.

Enter the above data in your worksheet. Find the amount by using formula. ( Amount = Unit Price * Quantity ) Find the grand total of amount. Insert one column before the table and type SRNO. ( Example: 1, 2, 3, ... ) Insert two rows above the table. Type the heading at first row Daily Sales Record, make bold type and merge centre alignment. At heading change the font to Time New Roman, size is 14 point. Draw a required border line. Save your worksheet to your folder.

uG e f y sLwmvuf p J G

166 EXERCISE (7)

Personal No:

1. 2. 3.

Rank

Name

Date of Birth

123456 Sgt

Maung Win

10-10-55

123654 Cpl

Aye Tun

12-03-60

225568 Sgt

Tun Tun

15-06-62

256478 Cpl

Aung Aung

01-05-65

233411 Sgt

Myo Aung

12-06-64

Age

Fill the above data into worksheet and calculate the age by using function. ( Show interger value ). Change the Date format is MM/DD/YYYY style. Calculate the Age with function. Hint: now(), int() Save your worksheet in Folder.

EXERCISE (8) Figure (1) Saleperson Buchaanan Buchaanan Buchaanan Buchaanan Buchaanan Buchaanan Davolio Davolio Davolio Davolio Davolio Davolio Suyama Suyama Suyama Suyama Suyama Suyama

Type Beverages Meat Produce Meat Beverages Produce Produce Meat Beverages Produce Meat Beverages Beverages Meat Produce Beverages Produce Meat

Units 4.997 5.889 3.4 5.847 5.87 2.652 7.549 7.832 8.207 9.888 6.74 7.67 6.9 9.435 2.449 2.698 7.44 8.953

Sales $6.560 $4.953 $8.751 $8.179 $3.522 $6.715 $1.500 $1.441 $8.461 $7.047 $6.990 $6.711 $9.862 $6.040 $5.971 $7.538 $2.666 $6.127

167

Microsoft Excel 2002

Figure (1) Saleperson Buchaanan Buchaanan Buchaanan Buchaanan Buchaanan Buchaanan Buchaanan Total Davolio Davolio Davolio Davolio Davolio Davolio Davolio Total Suyama Suyama Suyama Suyama Suyama Suyama Suyama Total Grand Total

1. 2.

Type Beverages Meat Produce Meat Beverages Produce

Units 4.997 5.889 3.4 5.847 5.87 2.652

Sales $6.560 $4.953 $8.751 $8.179 $3.522 $6.715

Produce Meat Beverages Produce Meat Beverages

7.549 7.832 8.207 9.888 6.74 7.67

$1.500 $1.441 $8.461 $7.047 $6.990 $6.711

Beverages Meat Produce Beverages Produce Meat

6.9 9.435 2.449 2.698 7.44 8.953

$9.862 $6.040 $5.971 $7.538 $2.666 $6.127

Figure (1) Z,m;udk Figure (2) Z,m;yHp k o H Ykd ajymif;vJí ½du k yf g/ Figure (2) Z,m;udk xyf½u kd &f ef rvdyk g/ Figure (2) Z,m;udk ½du k Nf y;D ygu Total ESihf Grand Total wdu Yk kd &Smay;yg/

uG e f y sLwmvuf p J G

168

1. 2. 3. 4. 5.

1 2

MI MI AUNG

87 47

35 86

79 80

71 46

68 37

3 4

KO KO ZAW MIN

76 70

75 45

67 46

85 82

94 60

5 6

KYAW HLA HLA

63 37

93 35

86 48

95 36

96 46

7 8

DEVI KO OO

84 51

93 50

76 41

60 63

65 81

9 10

WAR WAR THUZAR

87 51

96 99

95 87

41 80

71 40

11 12

ZIN MIN LIN LIN

40 69

53 72

78 45

52 62

77 89

13 14

YU YA MUYAR

92 73

41 48

83 58

50 77

95 36

15 16

BO BO CHAW SU

56 59

67 78

78 88

67 97

78 66

17 18

KP LATT SOE SOE

97 64

68 41

81 46

74 68

89 71

19 20

EI EI SWE SWE

54 99

79 81

73 82

53 56

79 45

MAXIMIUM

MINIMIUM

RESULT

Fill the above data into worksheet. Calculate the total Calculate the Average, Minimum, Maximum by using function. Find the Result. ( PASS or FAIL ) Hint: =IF(COUNTIF(C2:G2,"<40")>=1,"FAIL","PASS") Save your worksheet with new filename. ( Result-000.XLS ) Sort your database record by first key as result and second key as total. EXERCISE (10)

1. 2.

AVERAGE

TOTAL

BIOLOGY

CHEMISTRY

PHYSICS

NAME

MATHS:

ROLL

MYANMAR

EXERCISE (9)

Create a following table with your worksheet. Save your worksheet in Folder.

169

Microsoft Excel 2002

1. 2.

Create a above table with your worksheet. Save your worksheet in Folder.

uG e f y sLwmvuf p J G 170

Related Documents

Microsoft Excel
December 2019 48
Microsoft Excel
June 2020 11
Microsoft Excel
June 2020 23
Microsoft Excel
June 2020 18
Microsoft Excel
November 2019 44
Microsoft Excel
April 2020 31

More Documents from ""

230 Maung Di
November 2019 38
Microsoft Excel
November 2019 44
For Youths
November 2019 34
Microsoft Word
November 2019 53
002 Mgkhinmin01
November 2019 41