@D$D@D 9kdoAo76lvovtmy[kp2a’-ao MAX 3fpcotoe;jkG ສ.ວ.ສສະຫງວນລິຂະສິດ 2a’-ao MAX ,7u ;k,\\kpd’q dao0kh ,da[2’a -oa MIN c,jo dko7eo;o7jk.spjlf5 F g-yj’ ,[u kfdkh ;.odko7eo;o7kh p7dn oa c]t .s]h v’gIfa 8;q 1jk’.soh da IPog[yj’ c]t mfq ]v’D 3. 76lvovtmy[kpdkod;f7nodjvodkory, (Print preview) -b’j ,u0Ao8vo fa’j oUG 3.1 76lvovtmy[kpdkod;f7nodvj odkory,|hkgvdtlko (Print preview pages) 3fpcotoe;jkG dkod;f7no|hkgvdtlkodvj odkory, c,oj grnvj .shI6[|hkgvdtlkomu9j try,vvd ,koAo ,uI6[Ijk’1jk’.fL 0v[gmy’F 0v[]5,j F 0v[-hkp c]t 0v[0;k,u0t|kfr=fuc]h;[=L dkod;f7nodvj odkory, ,u[kfdhk;faj’]5,j oUG 1. dqf.lj Sheet1 2. .oc4[g7nvj ’,n,kf8t4ko .shdqf.lj Icon Print previewD g[yj’I6[ (D)D 2. dqf.ljx5,j oUgrnjv d;f7no djvodkory, 1.dqfgrnvj g]nvd sheet1 I6[ (D) dkoltcf’7ela’ Print preview xB,76j,n76 ICT ,D$ 95
3. 9kdoAo Excel 9tltcf’ Worksheet .oI6[c[[|hkry,F faj’ltcf’.oI6[ (D_F ma’\\qf,u _ x5,j .oc4[0v’ Print Preview c]t g,njvxkdqf|hk8jk’ Print Preview vvd,kF 76lvovtmy[kpc8j]tx5,j 8kj ’M 3fpdkocxrklkfaj’]5,j oUG c4[8kj ’M 7;k,\\kp Next ltcf’|hkgvdtlko8+wx Previous ltcf’|hkgvdtlkozjko,k Zoom sp=h|hkg0Qk c]t 0tspkp|hkvvd Print gxuf|hk8kj ’8v[38h0v’dkory,gvdtlko Print Setup gxuf|kh 8jk’8v[380v’dko9fa |kh gvdtlko Page Setup Margins ltcf’dkodeoqfg0f0v’|hkgvdtlkoF gIqklk,kf xjPodkodeoqf3fpdko]kd,oa g0kQ c]t vvd8k,7;k, 8hv’dko Page Break Preview g[yj’dko0Ao|hkgvdtlkoF .ooAogIqklk,kfgsao|hkgvdt ສ.ວ.ສສະຫງວນລິຂະສິດ lkoma’\\qfmj4u dn 0oA c]t 9fa ]ef[a |kh gvdtlkom’a |fq .o Worksheet Close da[7nol6j Worksheet Help dkogxufw2] (File) 7ecotoe grnvj -;j pdko.-h;Pd 3.2 76lvovtmy[kpdko9af|hkgvdtlko (Page Setup) 3fpcotoe;kj G dqf.lxj 5,j dko9af|hkgvdtlko (Pag Setup) .lj|hk8kj ’0v’dkod;f7nodvj odko ry, grnvj ltcf’|hk8jk’8v[38h0v’ dko9af|hkgvdtlko (Page Setup)D g[jy’I6[ (D_ s^n vkfg]nvd9kdc4[]kpdko 3fpdqf.lj File Page Setup... 1. 9kdoAodqf.ljc4[0v’ Page c]t lk,kfxPj o[k’vaofa’j oUG g[yj’I6[ (D_D xB,76,j n76 ICT ,D$ 96
I6[ (D_ ltcf’ Tab 0v’ Page .o|hk8jk’8v[38h0v’ Page Setup 76lvovtmy[kp7elaj’mulj e7ao.o|hk8kj ’3fpdkocxrklkfaj’8k8t]k’]5j,ouhG ສ.ວ.ສສະຫງວນລິຂະສິດ I6[c[[ 7;k,\\kp Orientation le]a[];’g9hp0v’|hk.odkory,g-aoj G g]nvd Portrait grnjvry, ];’8A’F g]nvd Landscape grnvj ry,];’ovo Paper Size ltcf’0t|kf0v’g9hp g-yj’lj k,kfg]nvdwfh8k,7;k,8hv’dko 9kd]kpdko0v’ Paper Size Page Numbering le][a dkog]j,y .l|j hkgvdtlkof;h p|kh mujc8d8kj ’dao 3fpg]vn d shv’0v’ First Page Number c];h r,y g]d|kh g0kQ 8k,muj8hv’dko 9kdoAo76lvovtmy[kp tab 0v’ Page Setup g-yj’76lvovtmy[kpg4y’;ymudkoxa[faj’oUG 1. dqf.lj tab Margin c]t x[a 0t|kf0v’g9ph 3fpdkox[a mujsvh ’0v’ TopF grvjn x[a w]pt sjk’0v[gmy’da[|hkgvdtlkoF bottom grnvj xa[w]ptsjk’0v[]5j,F Left grnvj xa[0v[ -hkpD Right grnvj xa[0v[0;kF Header and Footer grnjvxa[sq; c]t mhkp gvdtlkoD 2. dqf.lsj vh ’ Horiczontally 4hk8vh ’dko9af;k’0,=h o6 .s1h 6dj k’|kh g9ph c[[8k,];’ovoD 3. dqf.lsj hv’ Vertically 4hk8hv’dko9af;k’0=h,6o.sh168j k,];’8A’0v’|hkg9hpD xB,76j,n76 ICT ,D$ 97
4. 76lvovtmy[kpdkory,|hkg9hpgvdtlko3fpcotoe;jkG dkory,|hkg9hpgvdtlko0v’ Microsoft Excel oUlk,kfxt8y[afwfhs^kpd=]tou fh;pdaofaj’oUG 4.1 76lvovtmy[kpdkory,g0fmuj4ndg]nvd 3fpcotoe;kj 8hv’g]nvdg0fmuj8hv’dkory, glpdvj os^a’9kdoAoG dfq .lcj 4[]kpdko File Print… grnjvltcf’|hk8jk’8v[38h0v’ PrintD 9kdooA 76 lvovtmy[kpg0f7ela’j 8kj ’M g-oja G .og0f Print What .sgh ]vn dgvkq Selection Xg[yj’I[6 (D!W?D !D g]nvd-ngj 7njv’ry,.oshv’ສ.ວ.ສສະຫງວນລິຂະສິດ @D g]nvdx5j, Selection I6[ (D!W ltcf’dkory,.og0fmujg]nvd g,nvj g]nvdleg]afc]h;dqf.lj Ok grnjvla’j ry,vvdmk’g7nvj ’ry,D 4.2 76lvovtmy[kpdkory,gvdtlko8k,8hv’dko 3fpxt8y[af8k,0Ao8vofa’j oUG 1. dqf.lcj 4[]kpdko File Print… grnjvltcf’ |hk8jk’8v[38h0v’ Print g[yj’I6[ (D!WD 2. .og0f0v’ Print range .shdqf.lxj 5,j Page (S) 3. ry,g]d|hkg]yj,8Qo .oshv’ From c]t g]d|hkl5fmhkp.oshv’ To 4. dqf.lj Ok grnvj laj’ry,vvdmk’g7njv’ry, xB,76j,n76 ICT ,D$ 98
4.3 76lvovtmy[kpdkory,|hkgvdtlkomujde]a’.-h;Pd 3fpxt8y[af8k,0Ao8vofa’j oUG ສ.ວ.ສສະຫງວນລິຂະສິດ 1. dqf.lcj 4[]kpdko File Print… grnvj ltcf’ |hk8kj ’8v[38h0v’ Print 2. .og0f0v’ Print what .shdqf.ljx5,j Active Sheet(S) g[jy’I6[ (D!W 3. dqf.lj Ok grnjvlaj’ry,vvdmk’g7njv’ry, |hkmujde]a’gIaf;Pd16j 4.4 76lvovtmy[kpdkory,\\qf Workbook 3fpxt8y[af8k,0Ao8vofaj’oUG 1. ltcf’ Worksheet .oI6[c[[ Print Outline c]t deoqf|hkmu8j hv’dko 2. dqf.ljc4[]kpdko File Print… grnjvltcf’ |hk8kj ’8v[38h0v’ PrintD 3. .og0f0v’ Print what .shdqf.lxj 5j, Entire Workbook g[yj’I6[ (D!W 4. dqf.lj Ok grnjvla’j ry,\\qf workbook 0Ao8vomu #G X!& okmu? { .shoadIPoxtdv[7egsao8nj,.o[qfIPo3fp768A’7e4k, g-aoj G 1. gxaospa’9b’j 8hv’.-h7elaj’ AutoSum grnvj 7yfw]zj qo[;dL 2. .o Ms Excel ,udko7yfw]j9ad;ymu F c8]j t;ymu,u;ymudkoco;.fL 3. dkod;fgvdtlkodjvodkory,,u7;k,le7aoco;.f c]t ,u;ymudkoco;.fLD 4. dkory,|hkg9hpgvdtlko,u0Ao8voco;.fL { 76lts^5[7no[qfIPomujwfhIPo,k grnvj .shoadIPowfh9qfdjkp7no.oly’j mujgxao95fle7ao c]t m;o7bo[qfIPomuwj fhIPo,k grnjvgIaf.shoadIPog0qhk.9c9h’8n,j D 0Ao8vomu $G X& okmu? { gvqk7e4k,7Qo7;hkmu !W mudj tdP,w;h c[’j .shc8j]td5,j Ia[zyf-v[ 3fpoadIPo c8j]td5,j gvqk7e4k,gs^qkoUwx7qho7;hk9kdxB,c[[IpoF 9kdxB,mujovdg|nv9kd xbh,c[[IPoF vyog8ucof c]tvnjoMD xB,76,j n76 ICT ,D$ 99
7e4k,7Qo7;hk !WG g]nvj ’ dkolhk’czor6, .shoadIPoc8j]t7qo7Qo7;hkdjP;da[ 1. czor6,.-hw;grnjvspa’ c]t ,u;ymudkolhk’co;.fL ……………………………………………………………… ……………………………………………………………… 2. 0Ao8vodkophkp c]t xPj o0t|kfczor6,,u0Ao8vodkoxt8y[afco;.fLD ……………………………………………………………… ……………………………………………………………… [qfmu ) dkolhk’czor6, (Creating a Chart) dyf9tdemu !G dkolhk’czor6, g;]k # -qj;3,’ ສ.ວ.ສສະຫງວນລິຂະສິດ I. 95fxtlq’ z6hIPo,u7;k,I6h c]t lk,kflhk’czor6,.o0AorNo4kofaj’oUG { I6hlhk’czor6,3fpdko.-h Chart Wizard { I6hphkp c]t xa[xPj o0t|kf 0v’czor6, II. goNv.o8Qo8= dkooe.-h MS Excel ly’j |’bj mjule7oa c]t 9egxoa muzj oh6 e.-h8hv’wfIh oh6 e.-h grnvj .sh ;Pd’komgju Iqkxt8[y af1oj6 Aoleg]af1jk’,xu tlfy 8ry k[ ooA d7= gn Ikq 8vh ’Ilh6 kh ’czor,6 3fpdko.-h Chart Wizard c]t 8hv’Iph6 kh p c]t xa[xPj o0t|kf0v’czor,6 vdu D III. lndj koIPo{dkolvo { xB,c[[IPo dkooe.-h g8ad3o3]-u0=h,6o0jk;lko c]t dkolnjlko 0Ao ,D$ { I6[rk[mu,j ugoNv.odPj ;0hv’ { czoj -ufu mu,j ugoNv.odPj ;0hv’ Xvu’8k,g’nvj ow0? { 7v,ry;g8u { g7njv’ltcf’zqo0=h,6o xB,76,j n76 ICT ,D$ 100
IV. ;ymudkofegouodkolvo 0Ao8vomu !G X@W okmu? { 76lvowfhltg|u7no|hk;Pdmucj 8j]td5j,wfhIa[zyf-v[ 3fpdko.shoadIPo8v[ 7e4k,7Qo7;hkmuwj fh9afgxaod5j,w;hc]h;D { 76ltg|u.shoadIPoz6hvnjoxtdv[7e7yf7egsao.lj8nj,4hk,u7egsao8kj ’daoD { 76lvolts^5[7nolyj’mujoadIPowfhltg|u c]t gru,j .olyj’mujpa’0kfg0uo.lj8nj,D 0Ao8vomu @G X_W okmu? { 76lvog]uj,vtmy[kp[qfIPodPj ;da[dyf9tdemu ! c]t xt8y[af8q;9y’wxrhv, grnvj .shoadIPog0Qk.9[qfIPofu0Bo 1. 76lvovtmy[kpdkolhk’ 3fp .-h Chart wizard 3fpcotoe;jkG djvo9tlhk’ czor6,wfhoAo,aoIPdIhv’.shgIqk8hv’,u0=h,6ogxao8q;g]dglpdvj o c]t 0=h,6omujgxao8q;vadlvo vao9t[qj’[vdg4y’7;k,\\kp0v’8q;g]doAoMD 1. dqfg,kq lmklgu vqk g0fgovN muj0,=h o6 m8ju vh ’dkogvkq gxoa 0,h= o6 vkh ’v’u .odkolkh ’czor6, g[yj’I[6 )D! ສ.ວ.ສສະຫງວນລິຂະສິດ I6[ )D! ltcf’dkog]nvd0=h,6o 9kdoAodqf.lxj 5j, mujc4[g7njv’,n s^n dqf.ljc4[]kpdko Insert Chart… d=wfh c]t gIqk9tg0Qkl6j|hk8kj ’I6[c[[ c]t xtgrf0v’czor6,D g,njvxtdqf|hk8jk’ Chart vvd,kF 76lvovtmy[kpdkog]nvd c]t I6[c[[8kj ’M mu,j u.o|hk8kj ’D fa’j I6[ )D@D xB,76,j n76 ICT ,D$ 101
2. 9kdoAodqf.lj Next grnjvg]vn dI[6 c[[ c]t xtgrf0v’czor6, 4kh 8hv’dkog[yj’ ສ.ວ.ສສະຫງວນລິຂະສິດ czor,6 mu9j txkdfq vvd,kooA ;kj ,ao,u I6[c[[co;.f c]t lk,kfdeoqfI6[c[[fh;p 8qogv’.shdfq mujc4[ Custom type. !D g]nvd-toyf c]t -toyfpvj p0v’ dqf.lj Next @D dqfgrbvj d;f7no Chart #D dqf.ljx5j, Next I6[ )D@ ltcf’dkog]nvd-toyf0v’czor6, 3. .o|hk8jk’0v’ Chart Wiziard-Step 2 of 4 16j.oc4[0v’ Series in .shdqf.ljx5j, 0v’ Row s^n x5,j 0v’ Columns grnjvg]nvdmuj8A’0v’0=h,6o8k,7;k,8hv’dko c]t dqf.lj Next X,uI6[.oxB,c[[IPo?D 4. 9kdoAo.sh9afdkogda[czor6,3fpgruj,lyj’8kj ’M .lj Xg-ajoG Titles le]a[ry,sq;0=h Chart, Axes le]a[ 8q;xtlkoF grind lines le]a[.ljglaAoF dko;k’mu8j A’0v’ Legend le]a[deoqf7jk0v’0=h,6o c]t Data table le]a[ltcf’8k8t]k’0=h,6o Ij;,da[czo;kf?D 9kdoAodqf.lj NextD g[yj’I6[ )D#D xB,76j,n76 ICT ,D$ 102
-jv’le]a[ry, sq;0=h.o Chart I6[ )D# ltcf’dkory,sq;0=h.oshv’0v’ Chart title ສ.ວ.ສສະຫງວນລິຂະສິດ 5. 9kdoAodqf.ljx5,j g]nvd As Object in 4hk8hv’dko.shczor6,ovo.o Worksheet fP;da[8k8t]k’ 0=h,6o s^n As new sheet 4hk8hv’dko.shczor6,ovo.o Worksheet .\\jD 9kdoAo.shdqf Finish g[yj’I6[ )D$D dqfmuoj U grnvj lhk’ sheet .\\j dqfmujoU grnvj lhk’ Chart .o sheet I6[ )D$ ltcf’dkodeoqfmu8j A’0v’czor6, l5fmhkp9tltcf’czor6,.o Worksheet .o8k8t]k’0=h,6o c]t 76lvo7;ocotoe 8n,j vud;kj G 4hkxPj o0=h,6o.o SheetF 9t,uzqodtmq[.shczor6,xPj oc[[vaf8t3o,afD xB,76j,n76 ICT ,D$ 103
2. 76lvovtmy[kpdkophkp c]t dkoxPj o0t|kf0v’czor6, (Chart) ສ.ວ.ສສະຫງວນລິຂະສິດ 3fpcotoe;kj G 3fpmqj;wxc]h;dkolhk’czor6,.\\9j t[+wfh,kf8t4ko8k,7;k,8hv’dko ,ao8hv’ wfhg7njvophkpwxw;h[jvomujg\\ktlq, c]t xPj ocx’0t|kf8k,7;k,8hv’dkoF -bj’gIqk,u;ymu dkoxa[xjPofa’j oUG 1. dqf.lj grnvj g]nvd,ao 2. dqfg,qkl7hk’w;hc]h;]kdczor6,fa’j dkj ;wxw;h[vj omu8j hv’dko 3. gIqklk,kfxPj o0t|kf3fpdkodqf.ljczor6, grnvj g]nvd,ao 4. phkpg,qkl -U.lj95f8jk’M g;]koAog,qkl9txPj oI6[gxaosq;]6dlvo c]t .sh]kd g,qkl8k,muj8hv’dkogrnvj xa[0t|kf.spjohvpD 0Ao8vomu #G X!& okmu? { .shoadIPoxtdv[7egsao8nj,.o[qfIPo 3fp768A’7e4k, g-aoj G { czor6,.-hw;hgrnjvspa’ c]t ,u;ymudkolhk’co;.fL { 0Ao8vodkophkp c]t xjPo0t|kfczor6,,u0Ao8vodkoxt8y[afco;.fLD { 76lts^5[7no[qfIPomuj wfhIPo,kgrnvj .shoadIPowfh9qfdjkp7no.oly’j mujgxao95fle 7ao c]t m;o7bo[qfIPomuwj fhIPo,kgIaf.shoadIPog0qhk.9c9h’8n,j D 0Ao8vomu $G X& okmu? { 76lvocotoe.shoadIPowx7Qo7;hk8nj, c]t m;o7no[qfIPomuwj fhIPo,kF 95f.f mupj a’7hk’7k c]h;769t,k8v[7e4k,7no8k,rkps^a’D { 76lvogvqk7e4k,7Qo7;hkma’|qf.shoadIPogrnvj wx7Qo7;hk7noF xB,76,j n76 ICT ,D$ 104
Search
Read the Text Version
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
- 18
- 19
- 20
- 21
- 22
- 23
- 24
- 25
- 26
- 27
- 28
- 29
- 30
- 31
- 32
- 33
- 34
- 35
- 36
- 37
- 38
- 39
- 40
- 41
- 42
- 43
- 44
- 45
- 46
- 47
- 48
- 49
- 50
- 51
- 52
- 53
- 54
- 55
- 56
- 57
- 58
- 59
- 60
- 61
- 62
- 63
- 64
- 65
- 66
- 67
- 68
- 69
- 70
- 71
- 72
- 73
- 74
- 75
- 76
- 77
- 78
- 79
- 80
- 81
- 82
- 83
- 84
- 85
- 86
- 87
- 88
- 89
- 90
- 91
- 92
- 93
- 94
- 95
- 96
- 97
- 98
- 99
- 100
- 101
- 102
- 103
- 104
- 105
- 106
- 107
- 108
- 109
- 110