bai giang ms word - [chuong 05]

Chng 5. Bng biu Bi ging Microsoft Word

Bin son: Nguyn Vn Minh Trang 67

Chng 5. BNG BIU - TABLE Mc ch Sau khi hc xong chng ny sinh vin c th: - Chn v nh dng c cc loi bng biu - Gp v tch , tch bng Yu cu - Nm k cc phng php bi en thao tc nhanh - Vn dng sng to vo cc bi tp thc hnh tng ng. S tit ln lp: 02 Bng phn chia thi lng

STT Ni dung S tit 1 5.1. To bng 0.5 2 5.2. Cc thao tc trn bng

(Chn, chn, gp, tch dng, ct, nh dng vin khung) 0.5

3 5.3. Tnh ton trong bng 0.5 4 5.4. Sp xp d liu trong bng 0.5 5 5.5. To dng tiu lp cho bng 6 5.6. nh dng bng theo mu

Trng tm bi ging - Chn v nh dng bng

5.1. To bng.

5.1.1. Cch to bng

- Cch 1: Nhp biu tng Insert Table trn thanh cng c chun ri r chut chn s ct, s dng th chut.

- Cch 2: Vo Table, chn nhm Insert, chn tip lnh Table m hp

thoi Insert Table.

Nhp biu tng Insert

Table

R chut chn s ct,

s dng



Khai bo s ct ti dng Number of columns

Khai bo s dng ti dng Number of rows

C th chn dng: o Fixed column width: C nh

rng ca cc ct o AutoFit to contens: T ng

iu chnh rng ca cc ct va vi ni dung bn trong ct

o AutoFit to Windows: T ng iu chnh bng va vi kch thc ca kh giy.

Nt AutoFormat chn cch nh dng bng theo mu c sn.

Nu mun c nh cc thng s va thit lp cho mi ln chn thm bng mi th nh du Remember dimension for new table.

Cui cng nhp nt OK chp nhn vic chn bng. - Cch 3: S dng thanh cng c Tables and Borders

Nhp biu tng Tables and Borders trn thanh cng c chun (hoc vo View, chn Toolbars, chn Tables and Borders) bt thanh cng c Tables and Borders.

Mt s biu tng trn thanh cng c Tables and Borders.

Biu tng Tn ting Anh ngha

Draw Table Dng v bng, to dng, ct

Eraser Bt xa dng xa b dng, ct, , bng

Line Style Chn dng vin cho bng

Line Weight Chn dy cho vin ca bng

Border Color Chn mu cho vin

Outside Border Chn dng vin bao quanh vng ang chn

Shading Color Chn mu nn cho bng, cho vng ang chn

Insert Table Chn bng, chn ct, chn dng...



Merger Cells Gp cc ang chn

Split Cells Tch cc ang chn thnh nhiu

Align Chn dng canh l cho , vng ang chn

Distribute Rows Evenly T ng iu chnh rng ca cc dng bng nhau

Distribute Columns Evenly T ng iu chnh rng ca cc ct bng nhau

Table AutoFormat Chn dng nh dng bng t ng theo mu

Change Text Direction Xoay ni dung bn trong

Sort Ascending Sp xp d liu trong bng theo th t tng dn

Sort Descending Sp xp d liu trong bng theo th t gim dn

AutoSum Tnh tng t ng.

Chn dng vin, dy, mu ri nhp nt Draw Table v r chut ln vn bn k bng.

C th s dng cc biu tng trn thanh cng c Tables and Borders nh dng bng (xem bng trn).

Cu hi: 1. C my cch chn bng vo vn bn? 2. C th chn mt bng theo mu nh sn c khng? 3. Thanh cng c Tables and Borders c tc dng g?

5.1.2. Nhp vn bn vo bng - nhp ni dung cho mt trong bng ta t con tr trong cn nhp ri

nhp ni dung - Ni dung trong mt c th nh dng th mt vn bn thng thng. - Mt s phm thng dng khi son tho ni dung trong bng Tab: Chuyn con tr sang k tip Shift-Tab: Chuyn con tr sang pha trc. Cc phm mi tn di chuyn ln, xung, sang tri, sang phi. Alt-Page Up (Page Down): Di chuyn con tr v u hoc cui ca

ct hin hnh. Alt-Home, Alt-End: Di chuyn con tr v u hoc cui ca dng hin

hnh. Cu hi: 1. Lm th no chuyn con tr t ny sang khc?

5.2. Cc thao tc trn bng 5.2.1. Chn cc , dng, ct, bng



- Chn : Tr chut vo bn tri ca s xut hin mt mi tn, nhp chut

chn

C th r chut i chn nhiu dng

- Chn dng: Tr chut vo bn tri ca dng s xut hin mt mi tn, nhp chut

chn. C th r chut i chn nhiu dng

Hoc c th t con tr vo thuc dng cn chn ri vo Table, chn

Select, chn lnh Row Hoc t con tr u (cui) ca dng, gi phm Shift, nhn Alt-End

(Home) v dng cc phm mi tn ln xung chn nhiu dng - Chn ct: Tr chut vo bn trn ca ct s xut hin mt mi tn cha xung,

nhp chut chn. C th r chut i chn nhiu ct

Hoc c th t con tr vo thuc ct cn chn ri vo Table, chn

Select, chn lnh Column Hoc t con tr u (cui) ca ct, gi phm Shift, nhn Alt-

PageDown (PageUp) v dng cc phm mi tn sang tri, sang phi chn nhiu ct



- Chn bng:

Nhp chut ln biu tng gc trn bn tri ca bng chn ton b bng. (C th xem thm hnh v trn)

Hoc c th t con tr vo thuc ct cn chn ri vo Table, chn Select, chn lnh Table

Hoc t con tr u (cui) ca ct, gi phm Shift, nhn Alt-5 (s 5 vng phm s bn phi) v dng cc phm mi tn sang tri, sang phi chn nhiu ct

Cu hi: 1. Lm th no chn nhiu dng/hoc nhiu ct khng lin tip nhau? 2. Vic chn , dng, ct c tc dng g?

5.2.2. Chn thm dng, ct - Chn dng: Bi en s dng cn chn vo bn trn hoc bn di dng ang chn Nhp chut phi, chn Insert Rows (hoc nhp biu tng Insert

Rows ) trn thanh cng c chun thc hin lnh chn dng vo pha trn dng ang chn.

Hoc vo Table, chn Insert, chn lnh Rows above (chn ln bn trn) hoc Rows below (chn xung bn di)

- Chn ct Bi en s ct cn chn vo bn tri hoc bn phi ct ang chn Nhp chut phi, chn Insert Columns (hoc nhp biu tng Insert

Columns ) trn thanh cng c chun thc hin lnh chn ct vo bn tri ang chn.

Hoc vo Table, chn Insert, chn lnh Columns to the left (chn vo bn tri) hoc Columns to right (chn vo bn phi)

5.2.3. Xa dng, xa ct, xa bng - Xa dng: Bi en cc dng cn xa Nhp chut phi, chn Delete Rows Hoc vo Table, chn Delete, chn lnh Rows

- Xa ct: Bi en cc ct cn xa Nhp chut phi, chn Delete Columns



Hoc vo Table, chn Delete, chn lnh Columns - Xa bng: Chn bng cn xa Vo Table, chn Delete, chn lnh Table

5.2.4. Thay i kch thc dng, ct - Cch 1: Tr chut vo cnh phi ca ct mun thay i kch thc (hoc

cnh di ca dng) xut hin mi tn dng (hoc dng ). Nhp v r chut thay i kch thc.

Lu : - C th nhp i thay v r chut MS Word t ng iu chnh rng ca ct (dng) - thay i m khng lm thay i rng ca ct bn phi hoc dng bn di th nhn v gi thm phm Shift. - thay i vi khong cch nh th nhn v gi thm phm Alt

- Cch 2: Bi en cc ct (hoc dng) mun thay i Vo Table, chn Table Properties (hoc c th nhp chut phi, chn

Table Properties) chn th Column (hoc Row) Thay i rng cho ct ti Preferred width (hoc cho dng ti

Speciy Height)

- Cch 3: T ng iu chnh rng cc ct, dng ca bng Chn bng Vo Table, chn AutoFit, chn o AutoFit to Contents: T ng iu chnh rng ca ct, dng va vi

ni dung trong AutoFit to Window: T ng iu chnh rng ca ct, dng va vi

kh giy. Cu hi: 1. Lm th no Word t ng iu chnh rng ca ct? 2. Lm th no thay i rng ca ct m khng lm nh hng n rng

ca ct khc? 3. im ging v khau nhau khi chn AutoFit to Contents v AutoFit to

Windows?



5.2.5. Gp , tch , tch bng - Gp : Bi en cc cn gp Vo Table, chn Merge Cells Hoc nhp chut phi ln vng ang chn, chn Merge Cells

Hoc cng c th nhp biu tng Merge Cells trn thanh Tables and Borders

- Tch : Bi en cn tch (hoc c th chn nhiu ) Vo Table, chn Split Cells (Hoc nhp chut phi ln vng ang chn,

chn Split Cells; Hoc cng c th nhp biu tng Split Cells trn thanh Tables and Borders)

Chn s ct (Number of colulmns), s dng (Number of rows) cn tch OK

Ty chn Merge cells before split c ngha l gp cc trc khi tch - Tch bng: t con tr ngay ti dng mun tch thnh mt bng mi Vo Table, chn Split Table (Hoc nhp chut phi ln vng ang

chn, chn Split Table) Cu hi: 1. Khi no th chn chc nng Merge Cells, v Split Cells 2. C my cch tch ?

5.2.6. Thay i nh dng vin cho bng - Bi en cc (dng, ct) cn thay i dng vin - Vo Format, chn Borders and Shading (hoc nhp chut phi chn

Borders and Shading...) - Chn th Borders Chn dng vin ti Style



Chn mu cho vin ti khung Color Chn dy ti khung Width Nhp chut ln cc biu tng to vin khung Preview

Lu : - Ngoi ra ta cng c th thay i dng vin bng cch s dng cc biu tng ca thanh cng c Tables and Borders

5.2.7. T mu nn cho bng - Bi en cc (dng, ct) cn t mu nn - Vo Format, chn Borders and Shading (hoc nhp chut phi chn

Borders and Shading...) - Chn th Shading - Chn mu ti phn Fill 5.2.8. Canh l d liu trong - Cc biu tng canh l trn thanh cng c nh dng (formatting) ch cho

php thc hin canh l theo chiu ngang. - canh l theo chiu dc ta thc hin nh sau: Bi en cc (dng, ct) cn canh l ni dung Nhp chut phi, chn mc Cell Alignment ri chn dng canh l trong

ca s hin th. (C 9 dng canh l. Ta c th xc nh kiu nh dng qua hnh v ca biu tng)

Hoc nhp v chn dng canh l ti biu tng Align trn thanh Tables and Borders.

5.2.9. Xoay ni dung trong - Bi en cc cha ni dung cn xoay - Vo Format, chn Text Direction chn dng cn xoay OK

- Hoc nhp nt Change Text Direction trn thanh Tables and Borders



Cu hi: 1. C my cch thay i nh dng vin cho bng? 2. C my loi nh dng canh l ni dung trong ? 3. Lm sao c th xoay ni dung trong ? C th xoay theo mt gc ty c

khng?

5.3. Tnh ton trong bng 5.3.1. Khi nim a ch - Mt trong bng ca MS Word c xc nh qua a ch. - Mc d khng ch nh a ch ct, hay a ch dng nh trong Excel nhng

MS Word cng quy nh: ct u tin c a ch l A, ct th 2 c a ch l B, ct th 3 c a ch

l C, ... Dng u tin c a ch l 1, dng th 2 c a ch l 2, dng th 3 c

a ch l 3, .... - a ch c xc nh da vo a ch ct v a ch dng - V d:

5.3.2. Gii thiu mt s hm - Mt s hm thng dng tnh ton trong bng gm:

Tn hm ngha

SUM Tnh tng gi tr

AVERAGE Tnh gi tr trung bnh cng

MAX Tr v gi tr ln nht trong danh sch

MIN Tr v gi tr nh nht trong danh sch

COUNT m s lng gi tr trong danh sch

PRODUCT Nhn

INT Chia ly phn nguyn

MOD Chia ly phn d

IF Nu, dng khi x l iu kin

ny c a ch l C2



AND Ni cc iu kin dng V

NOT Ph nh iu kin

OR Ni cc iu kin dng Hoc

ROUND Lm trn

ABS Ly gi tr tuyt i

- Mt s tham s dng trong vng

Tn tham s ngha

LEFT Tnh tng gi tr

RIGHT Tnh gi tr trung bnh cng

ABOVE Tr v gi tr ln nht trong danh sch

BELOW Tr v gi tr nh nht trong danh sch

5.3.3. Thao tc - Gi s c mt bng sau:

H tn Ton L Ha Tng cng Trung bnh Nguyn Vn Hng 8 6 7 Trn Thanh Dng 5 6 6 Phm Th L 6 4 7 L Vn V 5 5 8

- Cch 1: u tin, t im chn (du nhy vn bn) vo Tng cng, vo

Table, chn Formula, xut hin hp thoi sau:

Ti Formula g: =sum(left) hoc =sum(B2:D2) ri nhn OK. Cc bn di cng lm tng t nhng phi t thay i a ch v

Word khng c chc nng copy cng thc nh Excel. ct Trung bnh, bn lm nh trn, nhng g cng thc sau:

=AVERAGE(B2:D2) nhp OK.



Paste function lit k mt s hm m Word h tr. Dng dn tn hm vo Formula thay v phi g trc tip t bn phm.

- Cch 2: Dng Code, cch ny tuy hi rc ri nhng cng kh hay. t im chn ti Tng cng v bm Ctrl + F9 s hin ra mt cp

du ngoc { } G vo biu thc vo gia { }. V d: {=sum(b2:d2)} Sau nhp phi chut ln biu thc v chn Update field, nu khng,

ta s ch thy ton m l m m thi. Nu mun chnh sa th nhp phi chut v chn Toggle Field Codes. Trung bnh cng tng t, nhng thay Sum bng Average

Cu hi: 1. u tin c a ch l g? 2. cng cc gi tr ca cc bn phi ta lp cng thc nh th no?

5.4. Sp xp d liu trn bng - Cch 1: t con tr trong bng. Vo Table, chn Sort xut hin hp thoi nh hnh v Ti Sort by, chn tn ct cn sp xp d liu v chn cch sp xp l

Ascending (tng dn) hay Descending (gim dn) Ti Then by, chn tn ct sp xp th 2 (v 3) nu mun khi gi tr

trong ct c chn Sort by trng nhau. Nu bn ca bn c cha dng tiu thi chn thm gi tr Header row,

ngc li nu bng khng c dng tiu th phi chn No header row. Cui cng nhp nt OK.



- Cch 2: t con tr ti ct mun sp xp

Nhp biu tng sp xp tng dn ( ) hoc gim dn ( ) ti thanh cng c Tables and Borders

Tuy nhin cch sp xp ny ch tc dng ln mt ct ti v tr con tr v ngm nh MS Word s hiu dng u l dng tiu ca bng.

Cu hi: 1. C th sp xp ni dung theo bao nhiu tiu ch? 2. C my cch sp xp ni dung? 3. Lm sao sp xp cho bng khng c dng tiu

5.5. To dng tiu lp cho bng - Thng thng i vi cc bng c s lng dng ln th hin hin nhiu

trang giy th nhng trang sau khng c dng tiu . - V vy u mi trang ca bng cng xut hin dng tiu d theo

di ngi ta thc hin nh sau: Bi en cc dng l dng tiu ca bng Vo Table, chn Heading rows repeat

- hy b th ch cn vo li Table, chn Heading rows repeat Cu hi: 1. Khi no th s dng chc nng to tiu lp cho bng?

5.6. nh dng bng theo mu



- MS Word cung cp sn mt s biu mu ca bng thng gp. Ta c th chn mt mu bt k p dng cho bng m khng cn phi thc hin li cc thao tc nh dng. Chn bng. Vo Table, chn Table AutoFormat... Ti hp thoi Table AutoFormat, chn dng bng ti khung Table

styles Nu khng mun p dng cho thnh phn no ca bng th b chn mt

s ty chn: Heading rows First column Last row Last column

Cui cng nhp nt OK



BI TP THC HNH CHNG 5 Bi tp 1:

1. Khi ng Word sau thit lp kh giy A4 vi khong cch l trn: 2cm, di: 2.5cm, tri: 3cm, phi: 2,5cm, hng in ngang.

2. Trang tr biu mu sau v lu li vi tn Baitap_51 vo th mc Baitap_Word trong My Documents.

X NGHIP LP RP XE MY BO CO 328 Nguyn Duy Hiu - Nng TNH HNH THC HIN K HOCH

TN N V SN XUT VT

SN PHM THI GIAN THC HIN Rp mi Sa cha Qu 1 Qu 2 Qu 3 Qu 4

Phn xng g B 30 50 70 90 Phn xng hn Chic 50 120 60 180 T lp rp Chic 170 250 239 346 T sa cha Chic 45 39 19 100

Nng, ngy 31 thng 12 nm 2006 NGI LP BO CO (K, ghi r h tn) Bi tp 2:

1. M MS Word, to mt vn bn mi ri thit lp kh giy A4, l trn: 2 cm, l di: 2,5cm, l tri: 2,5cm, l phi: 2cm, hng in dc.

2. Chn bng m Unicode trnh by cc biu mu sau ri lu li vi tn baitap_52.doc vo th mc Baitap_Word ca th mc My Documents

CTY IN T TIN HC ABC CNG HA X HI CH NGHA VIT NAM * 102 Hm Nghi - Nng c lp - T do - Hnh phc (0511.838949 ---o0o--- ---o0o---

Knh gi:

Tn khch hng: .................................................................................................................. a ch: ................................................................................................................................ in thoi: ...........................................................................................................................

Chng ti trn trng gi ti qu khch hng bng bo gi cc linh kin my tnh nh sau:

LOI CHI TIT N GI

CPU Intel Pentium 4 115$ Intel Celeron 77$ AMD Althlon 102$

RAM SDRAM 128MB 11$ DDRAM 256MB 21$ DDRAM 512MB 32$

Ghi ch: Lin h trc tip vi b phn Kinh doanh c c gi u i hn.



Bi tp 3: 1. M MS Word, to mt vn bn mi ri thit lp kh giy A4, l trn: 2,5

cm, l di: 2,5cm, l tri: 3cm, l phi: 2,5cm, hng in dc. 2. S dng bng m VNI trang tr biu mu sau v lu li vi tn

Baitap_53.doc vo th mc Baitap_Word trong My Documents:

TRUNG TM TIN HC NG CNG HA X HI CH NGHA VIT NAM * 53A Hng Vng, Tam K c lp - T do - Hnh phc ( 0510.838836 ---o0o--- ---o0o---

CHUYN NGNH TN LP S THNG NGY KHAI GING

: TIN HC @ Tin hc vn phng 03 Vo lc 17h30

Ngy

05-10-2008

@ K thut vin 07 @ AutoCad 03

& NGOI NG

@ Anh vn A 04 @ Anh vn B 05 @ Anh vn C 05

=>>Mi thng tin chi tit xin vui lng lin h trc tip ti trung tm. Bi tp 4:

1. M MS Word, to mt vn bn mi ri thit lp kh giy A4, l trn: 2 cm, l di: 2cm, l tri: 2,5cm, l phi: 2,5cm, hng in dc.

2. Thit k biu mu sau v lu li vo th mc Baitap_Word ca My Documents vi tn Baitap_54.doc:

CTY XNK MIN TRUNG BO CO 456 Trn Nhn Tng - Nng TNH HNH XUT NHP KHU SN PHM

TN SN PHM

VT

KT QU THC HIN 6 THNG U NM 6 THNG CUI NM

Xut Nhp Xut Nhp Tm hm Tn 150 130 C ng lnh Tn 100 130 Mc ng Tn 170 200 Hi sn ti Tn 90 150 Nguyn liu Tn 50 70

Tng cng 410 150 330 350

Nng, ngy 31 thng 12 nm 2008 NGI LP BO CO (K, ghi r h tn)



Bi tp 5: 1. M MS Word, to mt vn bn mi ri thit lp kh giy A4, l trn: 2 cm,

l di: 2cm, l tri: 3,5cm, l phi: 2cm, hng in ngang. 2. Thit k mu sau v lu li vo th mc Baitap_Word ca My Documents

vi tn l Baitap_55.doc: CTY TNHH BNH DNG CNG HA X HI CH NGHA VIT NAM *311 Hng Vng, Tam K, QN c lp - T do - Hnh phc ( 838567 - Fax: 84-0510-847847 ---o0o---

STT

MANV H V TN CHC V LNG C BN

NGY CNG PCCV

TR KHC THC NHN BHXH

15% Cng on

Tm ng

001 GV01 Trn Thanh Hng Gio vin 1,200,000 26 0 300,000

002 GV02 Phm Phc Tin Gio vin 1,200,000 30 0

003 NV01 L Th Hin Trng phng 1,700,000 30 200,000 540,000

004 NV02 Trn Th Kim Yn K ton 950,000 28 0

005 L01 Phan Anh V Hiu trng 2,150,000 26 1,120,000

Tng cng:


l di: 2cm, l tri: 3,5cm, l phi: 2cm, hng in dc. 2. Thit k mu sau v lu li vo th mc Baitap_Word ca My Documents

vi tn l Baitap_56.doc:

Bi tp 7:



1. M MS Word, to mt vn bn mi ri thit lp kh giy A4, l trn: 2,5 cm, l di: 2,5cm, l tri: 3,5cm, l phi: 2,5cm, hng in dc.

2. Thit k mu sau v lu li vo th mc Baitap_Word ca My Documents vi tn l Baitap_57.doc:

Bi tp 8:

1. M MS Word, to mt vn bn mi ri thit lp kh giy A4, l trn: 2,5 cm, l di: 2,5cm, l tri: 3,5cm, l phi: 2,5cm, hng in dc.

2. Thit k mu sau v lu li vo th mc Baitap_Word ca My Documents vi tn l Baitap_58.doc:



Bi tp 9: 1. M MS Word, to mt vn bn mi ri thit lp kh giy A4, l trn: 2,5

cm, l di: 2,5cm, l tri: 3,5cm, l phi: 2,5cm, hng in dc. 2. Thit k mu sau v lu li vo th mc Baitap_Word ca My Documents





l di: 2cm, l tri: 3,5cm, l phi: 2cm, hng in dc. 2. Thit k mu sau v lu li vo th mc Baitap_Word ca My Documents




CU HI N TP 1. Trnh by cc cch to bng. 2. Tm hiu cc biu tng trn thanh Tables and Borders 3. Nhng phm di chuyn con tr nhanh trong bng gm nhng phm no? 4. C my cch chn dng? My cch chn ct? 5. Cch no thay i rng ca ct (dng) m cch nhanh nht? 6. Merger Cells l g? Split Cells l g? 7. Khi mun thay i ng vin ca bng ta thc hin nh th no? 8. C my dng canh l d liu trong ? 9. Lm th no xoay mt ni dung trong t dng nm ngang sang nm dc... 10. Cch tnh gi tr trong bng nh th no? 11. C th sp xp d liu trong bng c khng? Cch lm th no? 12. Heading row repeat l g? 13. V sao phi nh dng bng theo mu?