Bin son: ThS.o Anh VEmail: vuda@pnu.edu.vn

Tin hc c bnBi Ging

Mc tiu ca mn hc Mc tiu chungMn hc trang b cho sinh vin nhng kin thc i cng v tin hc. Mc tiu c thCung cp cho sinh vin kin thc i cng v my tnh in t, h iu hnh (MS-DOS, Windows), son tho vn bn (Microsoft Word), bng tnh in t (Microsoft Excel) v mng my tnh. Thi , chuyn cnSinh vin cn tham gia y gi l thuyt v thc hnh, lm cc bi tp theo yu cu ca gio vin.

Yu cu, nh gi ca mn hc Yu cuC mt t nht 80% thi gian ln lpThang im: 10 nh gi kt qu hc tpKim tra, tho lun: 20%Chuyn cn: 10%Thi ht hc phn: 70% Lin h: vuda@pnu.edu.vn

Ti liu hc tp

Tham kho[1] H S m, L Khc Thnh - Gio trnh Tin hc Tp 1 - NXB HQGHN, 2000[2] Bi Th Tm - Gio trnh Tin hc c s - NXB Giao thng vn ti, 2006 Ti liu in t [1] http://www.computerhistory.org [2] http://www.ebook.net.vn

Ging Vin: ThS.o Anh V*Ni dung:Phn I: Tin hc c s Thng tin v x l thng tin Cu trc c bn ca my tnh S dng h iu hnh WindowsPhn II: Tin hc vn phng Thao tc trn MS Word 2010 Thao tc trn MS Excel 2010

Ging Vin: ThS.o Anh V

Chng 1: Thng tin v x l thng tinPhn I: Tin hc c s

Cc khi nim c bn1. Khi nim thng tin:Thng tin l mt khi nim tru tng, tn ti khch quan, th hin di nhiu dng thc khc nhau.Thng tin c th c pht sinh, c lu tr, c truyn, c tm kim, c sao chp, c x l, nhn bn. Thng tin cng c th bin dng, sai lch hoc b ph hy.2. Khi nim tin hc:Tin hc l ngnh khoa hc cng ngh nghin cu cc phng php, cc qu trnh x l thng tin mt cch t ng da trn phng tin k thut l my tnh in t.

Cc khi nim c bn3. My tnh in t (Computer): L mt thit b in t dng lu tr v x l thng tin theo cc chng trnh nh trc do con ngi lp ra.4. Biu din thng tin trong my tnh: Do my tnh c ch to da trn cc thit b in t ch c hai trng thi ng v m, tng ng vi hai s 0 v 1. Nn lu tr thng tin trong my, my tnh dng h m nh phn (Binary) tc l h m c biu din vi hai ch s 0 v 1.

Cc khi nim c bn5. Cc n v lu tr thng tin:

Tn n vVit ttGi trByteB8 bitKilobyteKB1024 bytes = 210 BMegabyteMB1024 KB = 210 KBGigabyteGB1024 MB = 210 MBTetrabyteTB1024 GB = 210 GB

Cc khi nim c bn6. Qu trnh x l thng tin ca my tnh

Cc khi nim c bnMy tnh l cng c x l thng tin. V c bn, qu trnh x l thng tin trn my tnh c 4 giai on:Thit b nhp (input device): thu nhn thng tin t th gii bn ngoi vo my tnh. Thc cht y l qu trnh chuyn i cc thng tin th gii thc sang dng biu din thng tin trong my tnh thng qua cc thit b u vo.Thit b x l (process device): bin i, phn tch, tng hp, tra cu... nhng thng tin ban u c c nhng thng tin mong mun.

Cc khi nim c bnThit b xut (output device): a cc thng tin kt qu ( qua x l) ra tr li th gii bn ngoi. y l qu trnh ngc li vi qu trnh ban u, my tnh s chuyn i cc thng tin trong my tnh sang dng thng tin th gii thc thng qua cc thit b u ra.Thit b lu tr ( store device ): ghi nh li cc thng tin c ghi nhn c th em ra s dng trong nhng ln x l v sau. p ng 4 thao tc th mt my tnh thng thng cng gm bn thnh phn hp thnh, mi thnh phn c mt chc nng ring.

Chng 2: Cu trc c bn ca my tnhPhn I: Tin hc c s

Cu trc c bn ca my tnh- n v x l trung tm (CPU Central Processing Unit).- B nh my tnh (Memory).- Thit b vo ra (Input/Output Device).

Cu trc c bn ca my tnh1. n v x l trung tmCPU c v nh b no ca my tnh. CPU c 2 chc nng chnh: + iu khin. + Tnh ton.CPU c 3 b phn chnh nh sau: + n v tnh ton s hc v logic (ALU: Arithmetic Logic Unit) + n v iu khin (CU: Control Unit) + Cc thanh ghi (Registers)

Cu trc c bn ca my tnhArithmetic Logic Unit: Dng thc hin tnh ton s hc n gin (cng, tr, nhn, chia s nguyn) hay l php tnh suy lun d liu (so snh ln, nh, bng,).Control Unit: C nhim v gii m cc lnh ca chng trnh v to ra tn hiu iu khin cc b phn ca my tnh. iu phi cc hot ng xut nhn d kin v x l d kin, hin th thng tin v lu tr thng tin.Register: l phn t nh tm trong b vi x l dng lu d liu v a ch nh trong my ang thc hin tc v vi chng.

Cu trc c bn ca my tnh2. B nh (Memory): B nh dng lu tr thng tin trong my tnh. B nh trong my tnh c chia lm hai loi.- B nh trong.- B nh ngoi.a. B nh trong B nh trong dng cha chng trnh v d liu, b nh trong chia lm hai loi l b nh RAM v b nh ROM.

Cu trc c bn ca my tnh

RAM (Random Access Memory): l loi b nh c th ghi v c. N dng cha d liu v chng trnh khi my tnh ang hot ng. D liu c th c v ghi d dng trn RAM. Tuy nhin thng tin trn RAM ch tn ti khi my tnh cn ang hot ng.B nh RAM

Cu trc c bn ca my tnhROM (Read Only Memory): l loi b nh ch c. Thng tin trong ROM c cc nh sn xut ghi vo v ngi dng c th c c thng tin t ROM ch khng th thay i hay ghi thng tin vo ROM. D liu trong ROM khng mt khi my tnh ngng hot ng.

B nh ROM

Cu trc c bn ca my tnh b. B nh ngoi B nh ngoi dng lu d liu v chng trnh ca ngi s dng. B nh ngoi c c im l dung lng lu tr ln hn so vi b nh trong. Ngi s dng c th dng b nh ngoi c v ghi d liu v thng tin ca b nh ngoi khng b mt khi my b tt. B nh ngoi c s dng hin nay l a t (a mm, a cng,usb), a quang

Cu trc c bn ca my tnh3. Thit b vo ra (input/ output)Thit b vo ra ca my tnh gip con ngi s dng giao tip vi my tnh. V chc nng, ngi ta chia thit b vo ra lm hai loi nh sau:- Thit b nhp- Thit b xuta. Thit b nhpL thit b c nhim v a thng tin vo my tnh x l. Cc thit b nhp thng dng nh: chut, bn phm, my qut, webcam

Cu trc c bn ca my tnh

b. Thit b xutMy tnh nhn thng tin v x l thng tin. Nh vy, ni nhn d liu xut ra sau khi x l l thit b xut hay b phn xut. Hin nay ngi ta thng s dng hai thit b xut ch yu l mn hnh v my in.Cu trc c bn ca my tnh

Phn I: Tin hc c sChng 3: S dng HH Windows

Chng 3: S dng HH Windows3.1 Khi nim h iu hnh

H IU HNH ( OS)

H iu hnh (Operating system) l mt h thng phn mm bao gm cc chng trnh iu khin lin kt cc thit b phn cng, cc phn mm h thng v cc ng dng thnh mt chnh th hot ng, gip ngi dng khai thc hiu qu cc ti nguyn ca h thng.H iu hnh gm mt s chc nng c bn sau:- iu khin qun l xut nhp d liu- iu khin qun l cc thit b

Khi nim h iu hnh- iu khin vic thc hin chng trnh- Qun l thng tin, b nh trong v b nh ngoi ca my tnh Cc h iu hnh thng dng: MS-DOS, Windows, Unix, Linux, OS/2, Macintosh,

H iu hnh MS-DOS Gii thiu mt s h iu hnh - MS-DOS: MS-DOS (Microsoft Disk Operating System) l h iu hnh ca tp on khng l Microsoft. Phin bn DOS u tin ra i vo thng 8 nm 1981 vi tn chnh thc l PC DOS 1.0.

MS-DOSTn gi MS-DOS ch c bit n k t thng 5 nm 1982 (MS-DOS 1.25). Sau Microsoft ra i cc phin bn tip theo ca MS-DOS song song cng vi PC-DOS. Phin bn cui cng ca MS-DOS l phin bn 8.0 i km vi Windows ME.MS-DOS l h iu hnh n nhim, ti mi thi im ch thc hin mt giao tc duy nht. Ni cch khc, MS-DOS ch cho php chy mt ng dng duy nht ti mi thi im.

MS-DOS

H iu hnh Windows - Windows: H iu hnh Windows l h iu hnh a nhim (multi tasking) c th x l nhiu chng trnh cng mt lc.

a. M t HH Windows Gm cc biu tng (icon). Cc biu tng i din cho mt i tng (object) nh mc h s, nghe nhc,Mt trnh tng hp ca nhng ng dng nh: son tho vn bn, ha, cc chng trnh ng dng, cc ng dng khc nh lch, ng h, bng tnh, tr chi,

WindowsT khi tung ra th trng th Windows c nhiu ngi n nhn, to mt s thnh cng rt ln i vi Microsoft. L do chnh m Microsoft c nhiu ngi la chn l c giao din d s dng, bt mt vi ha cao v v c s dng vi nhiu ngi dng nn cc cng ty phn cng cng nh cc cng ty phn mm to ra nhiu sn phm i cng Windows nh bn phm, chut, USB, cc chng trnh ng dng,

Windowsb. Giao din:

WindowsNn (Desktop), nn ci t cc biu tng. Khi nhp chut ln bt k mt biu tng ny, ngi dng s dng mt ng dng tng ng vi biu tng .Nt khi ng, (Start Button) i vo khi ng cc chng trnh mc nh (i km vi h iu hnh) hoc c ci t thm sau ny. Nhng thnh phn chnh ca nt khi ng l:Settings chnh sa cc thay i ca cc thit b hoc phm mm c ci t vo my.

Windows+ Control panel: chnh sa cc thng s ca chut, bn phm, nh dng mu sc hoc hnh nn, ci hoc g cc chng trnh phn mm.+ Network concection: thit lp h thng mng.+ Devices and Printer: thit lp cu hnh cho thit b phn v my in. + All Programs: bao gm nhng chng trnh ng dng. + Documents: gm cc ngi dng lu tr (hnh nh, nhc, ti liu,). + My Computer: ni cha nhng a khc nhau.

Windowsc. Chc nng h trWindows h tr chc nng- Ci xong dng lin (Plug & Play): nhng phn cng ci vo c th dng ngay do m t ng tm trnh iu khin (driver) ca phn cng v ci t cu hnh cng cch thc hot ng ca phn cng.- Ko v th (Drag & Drop): bt c i tng ca ca s c th dng chut chn v di chuyn n mt ni khc d dng.

Chng 3: S dng HH Windows3.2 Cc i tng do h iu hnh qun la. Tp tin (File)Tp tin l thng tin c lu tr trn a t di dng cc file, c file lu chng trnh, c file lu d liu, c file lu vn bn,Mi file c mt tn ring bit.Tn file gm c hai phn: phn tn (filename) v phn m rng (extension) v c vit cch nhau bi mt du chm (.).

FILE+ Phn tn (filename) - Di khng qu 8 k t (i vi HH MS-DOS) v di khng qu 255 k t (i vi HH Windows).- K t u tin c th l ch hoc s.- Khng s dng cc k t sau t tn file: / \ [ ] : < > = ; ? * v khong trng.+ Phn m rng (extension)- Phn m rng phn bit loi file (file chng trnh hay file d liu).- Phn m rng ti a 3 k t i vi MS-DOS v c th di hn 3 k t i vi Windows.

FILEV d:LAPTRINH.PDFTINHOC.DOC

Ngi ta thng dng ui m rng biu th cc tp tin. Chng hn tp tin vn bn thng c ui m rng nh: .DOC, .PDF, .TXT,Tp tin d liu thng c ui: .DBF, MDB, MDF,Tp tin chng trnh c ui: PGR, EXE,Tp tin hnh nh thng c ui: PNG, JPG, BMP,

Tn FileM rng

Tn FileM rng

Folder, Directory treeb. Th mc (Folder)Th mc l ni lu tr cc tp tin. qun l thng tin mt cch d dng, cc tp tin c mi quan h vi nhau c xp cng chung th mc. y l bin php gip ta qun l c tp tin, d dng tm kim chng khi cn truy xut.c. Cy th mc (Directory tree)L s biu din cc mi quan h th mc trn a. Mi a gi cng c mt th mc c t ng to ra khi a c nh dng gi l th mc gc (Root Directory). Th mc gc khng c tn v c k hiu bng du \.

Cy th mc- T th mc gc chng ta c th to ra cc th mc khc gi l th mc con (sub-directory) v t th mc con ny chng ta c th to ra cc th mc con khc na. Th mc cha th mc con c gi l th mc cha (hay cn gi l th mc m) (parent directory) ca th mc .- Mi th mc con c mt tn ring (quy nh t tn th mc cng ging nh tn file nhng thng khng c phn m rng).- Mi file lu trn a phi thuc v mt th mc hoc th mc gc hoc mt th mc no .

Directory tree- Th mc ang lm vic l th mc hin hnh (current directory).- Th mc rng (empty directory) l th mc m bn trong n khng cha tp tin hay th mc no.- Cc th mc v file trn mt a to thnh mt cy th mc (directory tree).Ch : - Trong mt th mc c nhiu th mc con th tn cc th mc con khng c t trng tn.- Cc file trong cng mt th mc khng c t trng tn.

Directory treeV d:

ng dnd. Dng dn:ng dn l l trnh i t th mc ny n th mc khc nhm xc nh th mc m ta cn truy xut n. C hai loi ng dn: ng dn tng i v ng tuyt i.ng dn tuyt i l ng dn i t th mc gc ca a n th mc cn truy xut.ng dn tng i l ng dn i t th hin hnh n th mc cn truy sut.Trong ng dn, cc th mc trung gian lin k cch nhau bi du \.Tn ng dn (pathname) l dy cc tn ca th mc c vit ngn cch bi du \.

ng dn ch r v tr mt file trn a, ngoi a cn c tn ng dn ca file theo dng sau:\\

Chng 3: S dng HH Windows3.3 Cc thnh c bn v thao tc trn Windowsa. Khi ng Windowsb. Gii thiu mn hnh WindowsMn hnh Windows cn gi l Desktop, y l biu tng cha cc chng trnh ca Windows. Ta c th b sung, xa b hoc sp xp cc biu tng theo ty thch.

Gii thiu mn hnh Windows

c. Ca s trong h iu hnhCc lin kt nhanhVng lm vicThanh trng thi

1. Thanh tiu (Title bar)

2. Thanh menu (Menu bar)Thanh ny nm di thanh tiu , gm nhiu mc chn nm ngang, mi mc chn tng ng vi mt menu dc. N bao gm mt s lnh m ngi dng c th gi khi ang thc thi trnh ng dng.

3. Thanh cng c (Tool bar)Thanh ny nm di thanh Menu, trong Windows c th c nhiu thanh cng c. Thanh cng c hnh trn l thanh cng c chun (Standard buttons), gm c cc nt lnh sau:- Nt Back: tr v trng thi trc- Nt Forword: tr v trng thi sau- Nt Up: tr v mc trn- Nt Search: tm kim ti nguyn trong my- Nt Folder: xut hin cy th mc- Nt View: thay i ch hin th ca file v th mc trong vng lm vic

4. Thanh a ch (Address bar)Hin th ng dn t th mc gc n th mc hin ti.

Nm cui cng ca ca s, cha cc thng tin v ca s hoc i tng ang c chn.5. Thanh trng thi (Status bar)

d. Thot khi Windows- Vo Start chn Turn Off Computer- M hnh xut hin hp thoi sau:

1. DesktopH iu hnh Windows 7 t chc cha mt cy th mc vi th mc gc l Desktop. Ti y ta c th s dng cc ti nguyn trn my tnh nh: Computer, Network, Controls Panel,Internet Explorer,

2. My ComputerBiu tng Computer l ni cha cc ti nguyn ca my tnh ang s dng, gm cc thnh phn c bn sau:

Computer a DVD RW Drive: Dng c v ghi a DVD. Thng thng i km mt s phn mm ghi a (Nero). a C: thng thng mc nh cha h iu hnh v mt s phn mm ng dng khi s dng. a D: Cch lm vic tng t nh biu tng ca a C, nhng ch khc nhau v tn v thng thng c s dng lu tr d liu khng phi h iu hnh hoc phn mm.

3. Menu StartMt menu l mt bng gm nhiu lnh, cc lnh ch cho Windows thc hin mt tc ng no . Khi click chut vo nt Start th menu Start s hin th. Danh sch cc mc chn trong menu ny di ngn ty thuc vo mi ngi dng. Menu Start hin th trn mn hnh nh sau:

Menu Start

4. Recycle BinBiu tng Recycle Bin nm ngay trn Desktop. y l ni cha cc file, cc th mc b xo bng lnh Delete thng thng. Click i vo biu tng ny, ca s xut hin nh sau:Nu mun phc hi mt file hay th mc no c trong Recycle Bin, ta click chn file cn phc hi ri thc hin lnh [menu] File/Restore. Nu mun tht s xo hn, thc hin lnh [menu] File/Delete. Nu mun xa hn ton b ni dung trong thng rc th click vo vng trng ca s ri thc hin lnh [menu] File/Empty Recycle Bin.

5. Networky l ni truy cp ca cc my tnh khc c ni mng vi my tnh ang s dng. Ta c th vo biu tng ny thit lp cc mng ni b.

6. Cc lnh c bn ca Windowsa. To th mc conTi th mc hin hnh, chn biu tng ti thanh cng c ri chn Make folder, vi tn mc nh l New folder, nhp vo tn ri Enter.Hoc: Right Click New Folder tip tc nhp vo tn ri Enter.Hoc: [menu] Newfolderb. Chy mt chng trnh ng dngClick i vo tn file ca chng trnh hoc biu tng chy mt chng trnh ng dng.

Cc lnh c bn ca Windowsc. Chn(nh du) file hoc th mc- Chn mt file: Click vo tn file.- Chn ton b file v th mc con trong th mc hin thi: Thc hin lnh [menu] Edit/Select All hoc nhn t hp phm Ctrl-A.- o ngc cc chn la: Thc hin lnh [menu] Edit/Invert Selection.- Chn nhiu file lin nhau: Click chut vo file u tin ri nhn v gi phm Shift ng thi click chut vo file cui cng.- Chn nhiu file khng lin nhau: Click chut vo file u tin ri nhn v gi phm Ctrl, ng thi click chut vo cc file khc.Ch : Vic chn cc th mc c thc hin tng t nh chn file.

Cc lnh c bn ca Windowsd. Sao chp file hoc th mc- Chn file hay th mc cn sao chp.- Nhn Ctrl-C hoc thc hin lnh [menu] Edit/Copy hoc click vo biu tng sao chp cc file, th mc chn vo b m Clipboard.- Chn th mc ch.- Nhn Ctrl-V hoc thc hin lnh [menu] Edit/Paste hoc click vo biu tng dn phn trong b m vo th mc ch.

Cc lnh c bn ca Windowse. Di chuyn file hoc th mc- Chn file hay th mc cn di chuyn.- Nhn Ctrl-X hoc thc hin lnh [menu] Edit/Cut hoc cilck vo biu tng ct cc file, th mc chn vo b m Clipboard.- Chn th mc ch. - Nhn Ctrl-V hoc thc hin lnh [menu] Edit/Paste hoc click vo biu tng dn phn trong b m vo th mc ch.

Cc lnh c bn ca Windowsf. Xa file hoc th mc- Chn file hay th mc cn xa.- Nhn phm Delete hoc thc hin lnh [menu] File/Delete hoc click vo biu tng .Ch : - C th xa nhanh cc file v th mc bng cch ko r n vo Recycle Bin.- Cc file v th mc trn a cng khi b xa bng cc cch trn s c lu vo Recycle Bin (thng rc) v c th s phc hi tr li (xem phn 8). - Khi xa cc file trn a mm hoc t du nhc ca Dos th cc file ny s khng c a vo Recycle Bin.- Nu mun xo cc file hoc th mc m khng a vo Recycle Bin ( xo hn) bng cch nhn phm Shift + Delete.

Cc lnh c bn ca Windowsg. i tn file hoc th mcCch 1:- Click chn file hay th mc cn i tn.- Thc hin lnh [menu] File/Rename.- G vo tn mi v nhn Enter.Cch 2:- Click chn file hay th mc cn i tn.- Nhn phm F2/Rename.- G vo tn mi v nhn Enter.

Cc lnh c bn ca Windowsh. Xem thuc tnh ca file hoc th mc- Click chn file hay th mc cn xem thuc tnh.- Thc hin lnh [menu] File/Properties hoc click vo biu tng , ca s xem thuc tnh s xut hin nh sau:

Cc lnh c bn ca WindowsXem thuc tnh ca file hoc th mc- y ta c th xem cc thng tin ca file hay th mc nh ng dn, kch thc, thi im khi to, thi im thay i, ngy truy cp, v c th thit lp mt s thuc tnh nh ch c (Read-only), n (Hidden)...Ch : Ta c th sao chp, di chuyn, i tn hay xem thuc tnh ca file, th mc bng cch s dng menu nt phi ca chut.

7. Control panelControl panel l mt phn quan trng ca h iu hnh Windows. Cha h thng qun l chng trnh phn mm ln phn cng ca my tnh. y cng l h thng thit lp cc thng s quan trng cho my tnh. m ca s Control Panel t Desktop ta thc hin lnh [menu] Start/Control Panel. Ca s Control Pannel s xut hin nh sau:

Control panel

Control panelClick i vo biu tng Uninstall a Program mn hnh xut hin nh sau:

8. Thay i mn hnh- Quay li Desktop, click chut phi chn Persionalize nh sau:

Gm 4 mc:a) Desktop Background: Chn kiu giao din s dng cho hnh nn Windows.Thay i mn hnh

b. Windows Color: Thay i mu sc cho thanh Task Bar, Menu, ng vin.

Desktop

Thit lp m thanh cho h thng

c. Sound

Khi thit lp ch bo v mn hnh th Windows s thay i hin th mn hnh sang mt thit k di ng nu khng s dng bn phm hoc chut sau mt khong thi gian nh trc. iu ny che du ni dung m ngi s dng ang lm vic trn mn hnh. Screen Saver: Click chut vo mc ny chn nh ng cho ch bo v.Setting: Nhm thit lp ch cho Screen Saver.Preview: Xem th ch mn hnh sau khi thit lp.

d. Screen Saver

9. Screen Resolution: Ci t phn gii mn hnh - Click i vo biu tng Screen Solution, xut hin hp thoi sau:

9. Thay i hin th dng s- Click i vo biu tng Clock, Language, and Regional xut hin hp thoi sau:

Thay i hin th dng s- Nhn vo hp thoi ta s thy cc v d nh dng ca cc kiu d liu l kiu s, kiu tin t, kiu gi, kiu ngy rt gn, kiu ngy y .- Mun thay i ta nhn vo nt Customize..., hp thoi sau s xut hin nh sau:

Thay i hin th dng s- Hp thoi gm c bn mc Numbers, Currency, Time, Date.Numbers: Thit lp cc thng s lin quan n d liu kiu s. + Decimal symbol: Chn k hiu phn cch gia phn nguyn v phn thp phn (thng dng du .).+ No. of digits after decimal: Nhp s ch s thp phn.+ Digit grouping symbol: Chn k hiu phn cch cc ch s ra thnh tng nhm (thng dng du ').+ Digit grouping: Chn kiu nhm s.+ Negative sign symbol: Chn k hiu s m (thng dng du -).

Thay i hin th dng s+ Negative number format: Chn kiu nh dng s m.+ Display leading zeros: Chn kiu hin th cho cc s thp phn bt u bng s 0.+ List separator: Chn k t phn cch cc s trong mt dy s. Mc ny c dng xc nh du phn cch cc i s ca hm trong Excel (thng dng du ,).

10. Thay i ngy gi h thng- Click i vo biu tng Date and Time xut hin hp thoi nh sau:

11. Mt s chng trnh ng dnga. My tnh b ti: (Calculator)My tnh b ti ny c kh nng thc hin nhng php ton t n gin n phc tp.Chn Start/AllPrograms/Accessories/Calculator,ca s iu khin s xut hin nh sau:

Mt s chng trnh ng dngThao tc: Cch s dng cng hon ton nh cc loi my tnh b ti thng thng. Dng chut click vo cc nt s v cc nt php ton hoc g t bn phm thc hin cc php tnh. Click vo du = hin th ra kt qu cui cng.- thc hin cc loi php tnh phc tp, ta chuyn i loi my tnh bng cch thc hin lnh [menu] View/ Scientific.

b. Chng trnh son tho vn bn Notepad - y l chng trnh son tho vn bn n gin ca Windows. N thng c s dng khi mun lu nhng dng vn bn n gin, khng cn nh dng cu k.- khi ng click chn Start/All Programs/Accessories/Notepad- thot ta thc hin lnh [menu] File/Exit hoc nhn t hp phm Alt-F4 Mt s chng trnh ng dng

Chng trnh son tho vn bn NotepadLm bi tp ng dng cng c notepad

c. Chng trnh v hnh bng Paint - y l chng trnh dng v hoc tin hnh cc thao tc x l n gin trn hnh nh.- Chn Start/All Programs/Accessories/Paint, ca s chng trnh s xut hin nh sau:Lm bi tp ng dng cng c Paint

Q&A

Phn II: Tin hc vn phngChng 1: MS Word 2010

Microsoft Word 2010 l mt chng trnh son tho vn bn a nng cung cp cho ngi dng mt lng ln cc tnh nng c o v a dng.Cc cng vic m bn c th lm trong phm vi ca Word bao gm t vic cc ti liu n gin nh th t n vic to ra cc n phm chuyn nghip nh sch, bo, tp ch, tiu thuyt, hi k,Bn c th dng Word to ra cc trang Web sinh ng v ni bt cho Word Wide Web hay Intranet cc b.1.Tng quan v Word

C th khi ng bng mt trong cc cch sau y:Cch 1: D_Click biu tng ca Word trn mn hnh Cch 2: Start/All Programs/Microsoft Office1.1 Khi ng Microsoft Word

1.2 Mn hnh lm vic ca M.WordSau khi khi ng Word, ta s thy c mn hnh lm vic ca Word nh sau:

1.3 Cc ch hin th mn hnh WordWord cho php nhiu ch hin th mn hnh rt phong ph v a dng phc v cho nhng cng vic khc nhau ca vic son tho vn bn. Thng thng khi son tho mt vn bn Word cung cp cc ch hin th nh sau:- Normal: Ch thng thng ca mn hnh son tho Word. Ch ny khng hin th cc l, cc tiu u trang hay cui trang.- Web Layout: Ch hin th vn bn cho cc trang Web hay cho vic c trc tuyn cc ti liu Word thng thng. Vn bn hin th khng c ngt trang.

Cc ch hin th mn hnh Word- Print Layout: ch hin th vn bn v ha mt cch chnh xc nh khi chng ta thy trn trang in, ch ra tt c cc l, cc tiu u, cui trang.- Print Preview: Xem ton b trang trc khi in ra, chng ta c th phng ta hoc thu nh theo mun chnh sa trc tip.- Outline: Ch ny ch ra cu trc ti liu, cho php chng ta xem nhiu mc chi tit v sp xp li vn bn ca ti liu mt cch nhanh chng.

- Dng vn bn (line): l tp hp cc t trn mt dng mn hnh. Dng ph thuc rt nhiu yu t nh kh giy, l vn bn,- on vn bn (Paragraph): l tp hp bao gm mt hoc nhiu dng c nh du kt thc bi phm Enter- Khi vn bn: L mt vng vn bn lin tc c nh du trn mn hnh. 1.4 Cc khi nim c bn

a. To mi mt vn bn to mi mt vn bn, ta c th s dng mt trong nhng cch sau y:- Thc hin lnh: [menu] File/New- S dng t hp phm Ctrl + N- Click chut vo biu tng trn thanh cng c 2. Cc thao tc c bn trong Word

b. Lu vn bn lu vn bn hin thi vo a t, ta c th s dng mt trong cc cch sau y:- Thc hin lnh: [menu] File/Save- S dng t hp phm Ctrl + S- Click chut vo biu tng trn thanh cng cKhi ta thc hin thao tc lu vn bn, nu l ln lu vn bn u tin, Word s hin th hp thoi Save yu cu ta t tn file cho vn bn. Cc thao tc c bn trong Word

Trong hp thoi ny, ta a vo tn file ti mc File name. Tip click chut vo nt Save lu vn bn.Lu vn bn

cc ln lu vn bn sau , Word ch tin hnh lu m khng yu cu t li tn cho vn bn. Trong qu trnh son tho vn bn, ta nn thng xuyn thc hin thao tc lu vn bn phng mt d liu khi c s c xy ra. Nn t tn file sao cho gi nh n ni dung ca file. Nu mun lu vn bn vi tn file khc vi tn file hin thi, bn s dng lnh [Menu] File Save As hoc nhn phm F12.

Lu vn bn

m mt vn bn c trn a, ta c th s dng mt trong cc cch sau:- Thc hin lnh: [menu] File/Open- Nhn t hp phm: Ctrl + O- Click chut vo biu tng trn thanh cng cKhi Word s hin th hp thoi Open. Trong hp thoi ny, ta c th g trc tip tn file vo hp thoi FileName hoc chn trc tip t danh sch cc file c hin th, sau nhn Open.

2.3 M vn bn

M vn bn

2.4 nh du khi vn bnTrong Word, khi tin hnh nh mt thao tc no trn vn bn, ta phi tin hnh thao tc la chn vng vn bn cn thao tc, c gi l nh du khi vn bn. nh du khi vn bn, ta c th s dng mt trong cc cc sau y:+ a con tr (chut) v u khi vn bn cn nh du, gi phm tri chut v r chut n cui khi vn bn.+ a con tr son tho v u khi vn bn cn nh du, gi phm v dng cc phm iu khin di chuyn con tr n cui khi.+ t con tr son tho u khi cn nh du, gi phm v click chut ti v tr cui khi.

2.5 Ct, dn, sao chp vn bnTrong Word ni ring v trong cc ng dng khc trn Windows ni chung, thao tc ct (cut) v dn (paste) c s dng khi ta mun di chuyn mt khi vn bn t v tr ny sang v tr khc, cn sao chp (copy) v dn (paste) c s dng khi ta mun sao chp mt khi vn bn t v tr ny sang v tr khc. di chuyn mt khi vn bn, ta thc hin cc bc nh sau:Chn khi vn bn cn di chuyn.Thc hin thao tc cut bng cch thc hin lnh [Menu] Home/Cut hoc click vo biu tng trn thanh cng c chun.

Ct, dn, sao chp vn bnt con tr son tho ti v tr cn di chuyn n.Thc hin thao tc paste bng cch thc hin lnh [Menu] Home/Paste hoc click vo biu tng trn thanh cng c chun. sao chp mt khi vn bn, ta cng tin hnh thao tc tng t trn nhng bc th 2, thay v s dng thao tc cut, ta s dng thao tc copy bng cch thc hin lnh [Menu] Home/Copy hoc click vo biu tng trn thanh cng c chun. Thay v phi thc hin cc thao tc cut, copy v paste thng qua menu, ta c th s dng cc t hp phm nh sau:

Ct, dn, sao chp vn bn

T hp phmChc nngCtrl + XCutCtrl + CCopyCtrl + VPaste

2.6 Tm kim thay th vn bna) Tm kim tm kim mt chui k t no trong vn bn, Chng ta thc hin cc thao tc nh sau:Thc hin lnh [Menu] Home/Find (hoc s dng t hp phm Ctrl + F).

Tm kim thay th vn bnTrong hp thoi Find and Replace:Chng ta g vo chui k t cn tm ti hp Find What. Sau click chut vo nt Find Next bt u tm. Chui k t tm c (nu c) s c nh du. Nu mun kt thc tm kim, Chng ta click chut vo nt Cancel.

Tm kim thay th vn bnb) Thay thThc hin lnh [Menu] Home/Replace (hoc s dng t hp phm Ctrl + H). Khi , hp thoi sau s xut hin:

Tm kim thay th vn bnTi hp Find What Chng ta g vo cm t cn tm, cn trong hp Replace with Chng ta g vo cm t c s dng thay th. Sau click chut vo cc nt Find Next, Replace hoc Replace All tu vo mc ch. Nhng nt ny c chc nng nh sau:- Find Next: Tip tc tm m khng thay th cm t tm c.- Replace: Thay th cm t tm c v tip tc tm.- Replace All: Thay th ton b mt cch t ng.

Tm kim thay th vn bnc) i n (Go to):Thc hin lnh s dng t hp phm Ctrl + G. Khi , hp thoi s xut hin nh sau:

Ti tab Go to c chia ra lm nhiu phn mc nh.V d: i vi mc i n a ch s trang, ta chn phn mc Page, sau nh s trang, nhn Next.

2.7 Chuyn i qua li gia cc vn bnTi mi mt thi im, Word cho php ta m nhiu vn bn cng mt lc. chuyn i qua li gia cc vn bn ny, ta chn View/Switch Windows cng c, mc chn vn bn ny tng ng (cc vn bn ny c nh s t 1,2,..)

2.8 ng vn bn ng vn bn hin thi ang son tho, ta c th thc hin mt trong s cc cch sau:- Thc hin lnh [Menu] File/Close- Nhn t hp phm Ctrl + F4 thot khi Microsoft Word, ta c th s dng mt trong s cc cch sau:- Thc hin lnh [Menu] File/Exit- Nhn t hp phm Alt +F4

2.9 Cc phm thng s dng khi son tho vn bn

Tn phmChc nngSang tri mt k tSang phi mt k tLn trn mt dngXung di mt dngHomea con tr v u dng hin thi.Enda con tr v cui dng hin thiPage UpDi chuyn ln trn mt trang mn hnhPage DownDi chuyn xung di mt trang mn hnhCtrl + HomeV u vn bnCtrl + EndV cui vn bnCtrl + Qua phi mt tCtrl + Qua tri mt tCtrl + Ln trn mt on.Ctrl + Xung di mt on.

Cc phm thng s dng khi son tho vn bna) Cc phm xa

PhmChc nngDeleteXo k t bn phi con trBackspaceXo k t bn tri con trCtrl + DeleteXo t bn phi con trCtrl + BackspaceXo t bn tri con tr.

Cc phm thng s dng khi son tho vn bnb) Cc phm thng dng khc

PhmChc nngF5Tm kim v thay thCtrl + ZPhc hi trng thi trc Ctrl + AChn ton b vn bnCtrl + GNhy n trang vn bn no Ctrl + YLp li thao tc trc

3. Mi trng son tho ting Vit3.1 Gii thiu phn mm son tho ting vit Vietkey Mt trong nhng vn ta gp phi ngay trong ln son tho mt vn bn u tin trong word l lm th no c th g c ting vit trong khi bn phm ch ton l cc ch ci khng du. Mt trong cc b g ph bin nht hin nay l Vietkey. Vietkey c cc phin bn khc nhau ph hp vi cc h iu hnh khc nhau.

3.2 Hng dn s dng Vietkey

a) Khi ng VietkeySau khi ci t Vietkey 2007, ta c th khi ng Vietkey theo hai cch sau:- Chy chng trnh Vietkey 2007 bng cch chn Start/All Programs/Vietkey 2007/Vietkey 2007.- Click vo biu tng ca Vietkey trn mn hnh Desktop

Hng dn s dng Vietkey

b) Cc ch hin th- TaskBar: thit lp ch ny click nt TaskBar trn mn hnh hin th ca Vietkey 2007. - Biu tng ch V ch g ting Vit- Biu tng ch E ch g ting Anh- Ontop: thit lp ch ny click nt Ontop trn mn hnh hin th ca Vietkey 2007.

Hng dn s dng Vietkey

c) Kiu g (input methods)- Vietkey 2007 h tr rt nhiu kiu g khc nhau. la chn kiu g, chy chng trnh Vietkey 2007, chn Tab Input Methods, lp ny gm mt s thnh phn nh sau:- i vi mc g ting Vit ta c th chn nhanh kiu g Telex hoc Vni bng cch click chn vo hp la chn tng ng. Ngoi ra, cn c th chn cc kiu g khc trong danh sch cc kiu g bn cnh.

Hng dn s dng Vietkey

- Hp kim tra B du kiu c (Old Style) cho php nh du cc nguyn m trong mt t theo phong cch ting Vit c : a, e, khi n c chn.- Hp kim tra B du sau nguyn m (Tone mark right after vowels) cho php nh du sau cc nguyn m khi n c chn.- Hp kim tra nh du t do (Free style)cho php nh du cho cc nguyn m mt cch t do.- Trong phn G bn phm (Active keyboard) v Bn phm cn g (Keyboards enabled) cho php chn v g theo ngn ng c chn.- i vi mc g ting Anh: g bnh thng

Bng m (char sets)Ch : Phi chn bng m ph hp vi font ch m ta ang dng th mi hin th ng ting Vit. d) Chn bng m

Bng mFont TCVN3-ABC Bt u bng .Vn (V d: .VnTime,.....) VNI-Win VNI-Times VietWare_X VnTimes new roman Unicode Times new roman

Vietkey 2007

e) Kiu g ting Vit C 2 kiu g ph bin l Telex v VNI. G ting vit theo kiu Telex: G ting vit theo kiu VNI:

f= huyns= scr= hix= ng j= nngaa= aw= oo= ow= uw= ee=dd=

s 1= du scs 2= du huyn s 3= du hi s 4= du ng s 5= du nng s 6= du m (, )s 7= du ru (, )s 8= du trng ()s 9= du ngang ()

4. nh dng vn bn4.1 nh dng trang giynh dng trang giy l thao tc nh dng thng c tin hnh u tin khi son tho vn bn (c bit l i vi cc vn bn ln v phc tp). tin hnh thao tc ny, Chng ta thc hin lnh: [Menu] Page Layout

nh dng trang giy

nh dng trang giyTrong hp thoi ny bao gm 3 Tab. Cc chc nng c th ca chng nh sau:Tab Margins: Trang Tab ny cho php Chng ta tin hnh cc thao tc nh dng lin quan n l ca trang giy nh sau:TopL trn ca trang giyBottomL di ca trang giyLeftL tri ca trang giyRightL phi ca trang giyGutterKhong cch dng lm gyGutter PositionV tr t gy

nh dng trang giyOrientation:Cho php Chng ta chn kiu giy l ng (Portrait) hay ngang Landscape).Apply to: Ch nh phm vi tc ng ca thao tc nh dng bao gm:Whole document: Ton b vn bn.This point Forward: T v tr con tr tr i.Selected Text/Section: vn bn/Section c chn.This Section: Section hin thi

nh dng trang giyTab Paper: Trang Tab ny cho php Chng ta tin hnh cc thao tc nh dng lin quan n trang giy

nh dng trang giyPager size: Chng ta dng nh dng trang giy. Nu Chng ta munn ln sau khng chnh na th sau khi Chng ta chn A4 xong Chng ta nhn vo nt gc tri pha di.Width: iu chnh b rng ca trang giy.Height: iu chn chiu cao ca trang giy(Hai tham s ny thng c thay i khi Chng ta thay i Pager size, nn Chng ta c mc nh cc tham s , ch thay i khi cn thit).

nh dng trang giyTab Layout: Trang Tab ny cho php Chng ta tin hnh cc thao tc nh dng lin quan n phn trn v di ca trang giy.

4. nh dng vn bn4.2 nh dng Font chKhi tin hnh thao tc nh dng font ch, nu ta chn khi trc khi tin hnh th thao tc nh dng c hiu l s tc ng ln khi vn bn c chn, nu khng thao tc nh dng s c tc dng ngay ti v tr hin thi ca con tr son tho.

nh dng Font cha) nh dng Font ch qua thanh cng c nh dng font ch, ta c th thc hin cc lnh ngay trn thanh cng c nh dng. Nu khng quan st c thanh cng c ny, ta hy thc hin lnh:[Menu] Home/Formatting

a) nh dng Font ch qua thanh cng c

Chn font ch cn nh dng t hp danh schHp danh sch cho php nh dng click c ca ch Click vo y chuyn i qua li gia ch ch m.Click vo y chuyn i qua li gia ch ch nghingClick vo y chuyn i qua li gia ch ch gch chnChn mu cho ch

nh dng Font chb) nh dng Font ch qua hp thoi fontChng ta c th tin hnh nh dng font ch thng qua hp thoi font vi nhng tnh nng phong ph hn bng cch thc hin lnh: [Menu] Home/Font

b) nh dng Font ch qua hp thoi fontTab Font bao gm cc thnh phn sau: Font: Ta chn font ch cn nh dng t hp danh sch ny. Font Style: Chn kiu ch. Style: Click c ch Font color: Mu ch.Underline style: None: Khng gch chn Single: Gch chn bng nt n Word Only: Gch chn tng t Double: Gch chn bng nt i Dotted: Gch chn bng nt ri

b) nh dng Font ch qua hp thoi font

nh dng Font chc) Thay i kiu ch Thao tc ny cho php chng ta thay i kiu ch t ch thng sang ch hoa, ch hoa sang ch thng,...Cch tin hnh nh sau (trc khi thc hin, chng ta nh bi chn vng vn bn mun thay i): Chn khi cc ch cn thay i. Thc hin lnh [Menu] Home/Change CaseXut hin hp thoi:

c) Thay i kiu ch

Trong hp thoi hin, bao gm cc mc sau:Sentence case: i cc k t u tin ca vng c chn thnh ch hoa cn cc k t khc thnh ch thng.lowercase: i tt c cc k t c chn thnh ch thng.UPPERCASE: i tt c k t c chn thnh ch hoaTitle Case: i cc k t u mi t thnh ch hoa v cc k t khc thnh ch thng.tOGGLE cASE: i nhng ch thng thnh ch hoa v nhng ch hoa thnh ch thngChng ta chn mc tng ng trong s cc mc chn trn v nhn thc hin chuyn i kiu.

nh dng Font chd) Cc phm tt s dng trong nh dng ch Tn phmChc nngCtrl + BChuyn i qua li gia ch ch mCtrl + IChuyn i qua li gia ch in nghingCtrl + UChuyn i qua li gia ch gch chnCtrl + Chuyn i qua li gia ch Subscript (v d: H20)Ctrl + Shift + =Chuyn i qua li gia ch Superscript (v d: x2)Ctrl + ]Tng c ch ln mt n vCtrl + [Gim c ch i mt n v

d) Cc phm tt s dng trong nh dng ch thc hin th Chng ta nhn v gi cc phm trn theo th t ( v d lm x2: Chng ta lm nh sau. Chng ta g ch x sau Chng ta v gi phm Ctrl tip theo gi thm phm Shift tip theo gi phm =. Nh l phi gi ng thi 2 phm u ri nhn phm th 3 xong th ra, Nu Chng ta mun tt ch th Chng ta lm li cc thao tc trn 1 ln na).

nh dng Font che) Chn cc k t t bit Trong trng hp Chng ta cn chn nhng k hiu c bit vo vn bn nh (, , , , ,...), Chng ta tin hnh nh sau: t con tr son tho ti v tr cn chn. Thc hin lnh [Menu] Insert /SymbolTrong hp thoi Symbol xut hin, Chng ta chn k hiu cn chn sau nhn chut vo nt chn vo vn bn.

Chn cc k t t bitTrong trng hp phi chn lp i lp li nhiu ln mt k kiu, Chng ta c th nh ngha t hp phm tt (Shortcut Key) cho k hiu bng cch click chut vo nt . Khi xut hin hp thoi nh sau: Click vo y chn nhm biu tng( Cc biu tng hay dng thng nm trong nhm Wingdings)

Chn cc k t t bitTrong hp thoi ny, ta nhn t hp phm cn nh ngha tip n nhn nt ri nt kt thc. Khi nh ngha t hp phm cho ring, Chng ta khng nn t trng vi nhng t hp phm c nh ngha sn ca Word.

4.3 nh dng on vn bn (Paragraph) nh dng vn bn c p mt v r rng, Chng ta phi nh r khong cch gia cc dng, cc on, cch thc cn l vn bn, khong cch vn bn,... Thao tc nh dng Paragraph cho php Chng ta lm c nhng iu ny. Trc ht, Chng ta phi t con tr son tho vo trong vn bn cn nh dng (hoc tin hnh thao tc chn khi nu mun nh dng cho nhiu on vn bn), sau s dng cc phng php nh dng sau:

4.3 nh dng on vn bn (Paragraph) nh dng on vn bn thng qua thanh cng cTrn thanh cng c thng c nhng nt lnh cho php tin hnh thao tc nh dng on vn bn nh sau:

Cn l bn triCn l giaCn l bn phiCn l hai bna l tri ra ngoia l tri tht vo

Cn l bn triCn l giaCn l bn phiCn l hai bna l tri ra ngoia l tri tht vo

4.3 nh dng on vn bn (Paragraph) b) nh dng on vn bn thng qua thcChng ta c th tin hnh mt s thao tc nh dng v l vn bn thng qua thc nm ngang bng cch s dng chut di chuyn cc nt trn thc.

4.3 nh dng on vn bn (Paragraph) c) nh dng on vn bn thng qua hp thoi Paragraph tin hnh nh dng on vn bn thng qua hp thoi Paragraph, Chng ta vo [Menu] Home/Paragraph (hoc Click right chut chn Paragraph). Hp thoi Paragraph xut hin nh sau:

c) nh dng on vn bn thng qua hp thoi Paragrap

c) nh dng on vn bn thng qua hp thoi Paragrap Trong Tab Indents and Spacing bao gm cc mc sau:AlignmentJustified: Cn u hai bnLeft: Cn l bn triRight: Cn l bn phiCenter: Cn l giaIndentation: Qui nh l cho on vn bnLeft : Khong cch l bn triRight: Khong cch l bn phi

c) nh dng on vn bn thng qua hp thoi Paragrap Special: Dng qui nh cch thc xut hin ca dng u tin trong on.None: Dng u tin tng t nh cc dng khcFirst line: Dng u tin tht vo so vi cc dng khc mt khong c qui nh hp By bn cnh.Hanging: Dng u tin dch ra ngoi so vi cc dng cn li (l treo).Spacing: Cho php ta ch nh khong cch trc v sau cc on theo munBefore: khong cch n on trc .After: khong cch n on sau.Line spacing: Dng qui nh khong cch gia cc dng trong on (mc nh l single).

4.3 nh dng on vn bn (Paragraph) d) Cc phm tt s dng trong nh dng vn bnTn phmChc nngCtrl + LCn l triCtrl + RCn l phiCtrl + ECn l giaCtrl + JCn u hai bn

4.3 nh dng on vn bn (Paragraph) e) Thit lp TabThng thng trong qua trnh son tho, nu Chng ta nhn phm , con tr son tho s nhy mt khong so vi v tr hin hnh (thng thng l 1.27cm). Tuy nhin, c nhng trng hp chng ta cn phi t li v tr ca cc im dng khi nhn theo mun ca mnh. lm iu ny, Chng ta s dng phng php t cc im Tab.im dng Tab (Tab Stop Position) l v tr dng ca con tr son tho khi Chng ta nhn phm . t cc im dng Tab, Chng ta c th s dng cc phng php sau.

e) Thit lp TabThit lp Tab thng qua thc Ruler pha bn tri ca thc nm ngang , Chng ta quan st c cc kiu im Tab khc nhau nh:

chuyn i gia cc kiu im Tab, ta ch cn click chut vo biu tng Tab ngay trn thc

Left TabTab triCenter TabTab giaRight TabTab phiDecimal TabTab thp phn

e) Thit lp TabThit lp Tab thng qua thc Ruler

t mt im Tab ti v tr no , Chng ta ch cn chn kiu im Tab sau click chut ti v tr tng ng trn thc nm ngang

g b cc im Tab, ta ch cn s dng chut ko r chng ra khi thc

e) Thit lp TabThit lp Tab thng qua hp thoiChng ta c th thit lp Tab bng cch thc hin nh sau: [Menu] Home/Paragraph/Tab Nhp gi tr m ti tab s c t trong hp thoi Tab stop position. Chn kiu Tab trn mc Alignment (Left:tri; Center:Gia; Right:Phi) Chn kiu vch tng ng gia cc Tab trn mc Leader. Click chut vo Set thit lp Tab (nu c nhiu tab th Chng ta lm theo th t trn cho tng tab)

e) Thit lp TabThit lp Tab thng qua hp thoi

Ch :- Nt Clear dng xo im Tab hin thi ang c chn v nt- Nt Clear All dng xo tt cc cc im thit lp Tab.

e) Thit lp TabThit lp Tab thng qua hp thoiV d:t Tab STTH tn ging vinTn hc phnVHT1Phan B TrCSDL nng cao42Hong Vnh HnhVisual Foxpro43on Thin HngVi x l 23- Sau khi thit lp Tab cho kt quSTTH tn ging vinTn hc phnVHT 1..Phan B Tr.CSDL nng cao...4 2..Hong Vnh Hnh...Visual Foxpro..4 3..on Thin Hng...Vi x l 2...3

f) Thit lp Bullets v NumberingThit lp Bullets v Numbering thng qua biu tngf.1 Bullets- Trn Toolbar click biu tng lnh Bullets - u mi Paragraph s c chn mt k t c bit. f.2 Numbering- nh du on vn bn.- Trn Toolbar click biu tng lnh Numbering - u mi Paragraph s c chn thm s th t.

f) Thit lp Bullets v NumberingThit lp Bullets v Numbering thng qua thanh cng c FormatingChng ta c th thit lp Bullets v Numbering theo cc bc sau: nh du on vn bn [Menu] Home/Bullets and Numbering Chn tab Bullets nu Chng ta mun chn k t c bit; Chn tab Numbering nu Chng ta mun chn s th t. Chn kiu k t v kiu nh s th t m Chng ta mun chn. Click OK.

f) Thit lp Bullets v NumberingThit lp Bullets v Numbering thng qua thanh cng c Formating

BulletsNumbering

Thit lp Bullets v Numbering thng qua thanh cng c Formating

Chng ta c th nh dng cc k t ca Bullet theo cc k t bt k theo cc bc nh sau:Chn Customize trn hp thoi Bullets and Numbering.Hp thoi Customize Bulleted List xut hin nh sau:

Thit lp Bullets v Numbering thng qua thanh cng c Formating

Phn Bullet character: Chng ta chn vo 1 trong cc biu tng c sn, nhng nu Chng ta mun thay i (chn cc biu tng khc) th chn bo nt , xut hin 1 hp thoi sau, chn vo biu tng mun chn, nhn OK.

Thit lp Bullets v Numbering thng qua thanh cng c Formating

Bullet position: iu chnh khong cch gia biu tng vi k t u tin ca on text. Mc nh ca n l 1.9 cm, nu Chng ta thy n rng qu th Chng ta c th tng hoc gim bng cch hiu chnh li gi tr 1.9 cm .Text position: Khi Chng ta thay i gi tr trong 2 Tab space after v Indent at th Chng ta s thy s thay i khung Preview.

to vn bn dng ct Chng ta thc hin ln lt cc bc sau: - Chn khi vn bn cn chia ct. - Thc hin lnh: [Menu] Page Layout/ColumnsHp thoi Columns xut hin nh sau: 4.4 To vn bn dng ct

Trong hp thoi ny, Chng ta c th tin hnh chn kiu chia ct c sn thng qua nhm Presets bao gm:- One, Two, Three: To vn bn dng mt, hai hoc ba ct bng nhau.- Left : To vn bn dng hai ct trong ct tri bng 1/2 ct phi.- Right: To vn bn dng hai ct trong ct phi bng 1/2 ct tri.Ngoi ra, trong hp thoi ny cn c cc thnh phn sau: To vn bn dng ct

To vn bn dng ct

Number of ColumnsNu khng mun s dng nhng kiu chia ct c trong nhm Presets hoc nu chia 4 ct tr ln, Chng ta s dng mc ny ch nh s ct cn chia theo mnh.Width and SpacingChng ta c th s dng phn ny iu chnh rng v khong cch gia cc ct.Apply toCh nh phm vi tc ng ca vic chia ct bao gm: + Whole Document: p dng cho c vn bn. + Selected Text: p dng cho phn vn bn c chn Line BetweenNu Chng ta nh du chn mc ny th gia cc ct s c ng k phn cchEqual Column WidthNu Chng ta nh du chn mc ny th cc ct c rng bng nhau.

To vn bn dng ctChng ta c th thc hin bng cch nh sau: - Chn khi vn bn cn chia ct - Click vo biu tng trn thanh cng c, sau dreg chut chn s ct cn chia. Ko chut y canh chnh li rng ca ct

Drop Cap l kh nng to hiu ng c bit cho ch ci u tin ca on vn bn nhm mc ch trang tr cho on vn bn. lm iu ny, Chng ta thc hin cc bc sau:- t con tr son tho bn trong on cn nh dng Drop Cap.- Thc hin lnh [Menu] Insert/Drop Cap.Chn kiu Drop Cap trong nhm Position. Ngoi ra, ta cn c th thit lp mt s thng s tu cn sau:+ Font: font ch ca k t c Drop Cap.+ Line to Drop: S dng dnh cho Drop Cap.+ Distance from text: khong cch t Drop Cap n cc t trong on 4.5 Drop cap

V d: Di y l mt on vn bn c nh dng Drop Cap vi Position l Dropped, Font l Times New Roman, Line to Drop l 3 v Distance from text l 0.3: Drop cap

Khi to bng biu to mt bng biu, chng ta thc hin ln lt bng cc cch sau:Cch 1:- con tr son tho ti v tr cn chn bng.- Thc hin lnh [Menu] Insert/Table. 4.6 To bng biu

Khi to bng biuNu ta tick chn vo nt Remember dimensions for new tables th sau khi nhn Ok th nhng g c thay i s p dng cho nhng ln to bng sau.V d: Mc nh ca h thng l Columns = 5, v Rows = 2, nhng nu ta thay i Columns = 7 v Rows = 5 th gi tr ny s c dng cho ln chn bng sau.

Nu Chng ta mun to bng theo nhng kiu c sn th click chn vo nt xut hin hp thoi: 4.6 To bng biu

Khi to bng biu

Cch 2:- t con tr text v tr thch hp, trn thanh cng c Tables and Borders click chn biu tng Insert Table, mt bng mu hin ra.- t con tr chut u tin, ko chut xung di chn s hng, ko chut sang phi chn s ct. Khi nh chut, mt bng biu c chn vo vn bn c s hng v ct chn, cc ct c rng bng nhau v rng ca mi ct bng chiu rng trang in chia cho s ct chn. V d sau y to bng biu 3x4 (3 hng, 4 ct). Khi to bng biu

Khi to bng biu

b) Nhp ni dung bng biuMi trong bng biu c th cha ch, ch s hoc hnh v. Click chut vo mt , con tr text hin ra cho cho php nhp ni dung cho .Khi nhp xong ni dung cho mt , g phm Tab di chuyn con tr text sang k tip bn tay phi, g Shift + Tab di chuyn con tr text sang k tip bn tay tri. G cc phm mi tn di chuyn con tr text i theo hng mi tn. 4.6 To bng biu

V d: Nhp ni dung bng biuCh : Khi con tr text nm trong cui cng ca bng biu th phm Tab s c tc dng thm mt hng mi vo cui bng biu v tip tc nhp ni dung trong hng mi. Gi s nu con tr text ang (3,4) th khi g Tab s c hng mi thm vo.

STTH V TNIMXP LOI1Trn Th Anh10Xut sc2Nguyn Hng 10Xut sc

c) Cc thao tc chnh trn bng biu4.6 To bng biu

c.1 Chn khi cc trong bngCc thao tc chnh trn bng biu

c.2 iu chnh rng ca ct v chiu cao ca dngCc thao tc chnh trn bng biu

c.3 Chn thm hng, ct hoc vo bngCc thao tc chnh trn bng biu

c.4 Xa (dng/ ct/ bng) xo mt hoc nhiu (dng/ct) ta lm nh sau:- Chn (dng/ct) cn xo. Thc hin lnh: [Menu] Layout/Delete Cc thao tc chnh trn bng biu

c.5 Tch tch mt thnh nhiu , ta lm nh sau:- Chn cn tch.Thc hin lnh [Menu] Layout/Split Cell

Trong hp thoi xut hin, ta ch nh s ct (Number of columns) v s dng (Number of rows) cn tch v nhn .Cc thao tc chnh trn bng biu

Cc thao tc chnh trn bng biuc.5 Tch V d:Chng hn bng di y bao gm hai hng v hai ct: Sau khi tch u tin thnh 3 ct v 2 dng s l:

c.6 Gp

gp nhiu li vi nhau, ta lm nh sau:- Chn cc cn gp.- Thc hin lnh [Menu] Layout/Merge Cells Cc thao tc chnh trn bng biu

d) Trnh by v trang tr bng biud.1 Trnh by bng biuNi dung trong cc c th c trnh by bng cc biu tng lnh ca Font, Paragraph, Bullets and Numbering...Ngoi ra, trong bng biu cn c nhng lnh ring trnh by cho cc bng cch dng cc biu tng lnh trn thanh Table and Borders. 4.6 To bng biu

Sau khi to bng biu, ta thng phi thc hin thao tc nh dng vin v nn cho bng biu. lm iu ny, ta thc hin cc thao tc sau:- Chn cc cn nh dng.- Thc hin lnh [Menu] Page Layout/Page Borders nh dng vin, ta chn trang Tab Borders trong hp thoi xut hin.d.2 To khung vin v nn cho bng biu

To khung vin v nn cho bng biu

Trong :Style: Chn kiu ng k vin.Color: Chn mu ng vinWidth: Chn rng (dy) ca ng kPreview: Cho php quan st tc dng ca kiu ng vin c nh dng. Ngoi ra, ta c th click chut vo cc nt tng ng thit lp hoc loi b ng vin tng ng: d.2 To khung vin v nn cho bng biu

Trong mt bng biu phc tp, i khi chng ta cn c nhng ng k v nhng khong trng tht thng, vic s dng cng c Draw Table s gip chng ta v bng biu, b sung cc ng k vo mt bng biu. Thc hin theo cc bc:Trn thanh Tables and Borders, chn kiu ng k, rng v mu sc ca ng k.d.3 S dng cng c Draw Table

Chn cng c Draw Table, con tr c dng cy bt ch, ko chut t cnh ny sang cnh khc v ra mt bng biu (ch c mt )t con tr chut vo trong bng biu v, ko chut t cnh ny sang cnh khc v cc ng k trong bng biu. Cch lm ny c tc dng tng t nh lnh Split Cells.Sau khi v xong bng biu, click biu tng Draw Table 1 ln na tt tnh nng v bng. S dng cng c Draw Table

Dng cng c Eraser xo cc ng k trong bng biu, y cng chnh l lnh Merge Cells. Click chn cng c Eraser, con tr chut c dng cc ty.t con tr ti ng cn xo, ko chut nh du ng cn xo (mu xm), nh chut, ng k b xo.Click nt Eraser ln na tt lnh ny d.4 S dng Eraser

trang tr bng biu nhanh, c th dng Table Autoformat.Khi bng biu c to ra, nh du chn ton b bng biu, click biu tng lnh Table Autoformat.Chn mt mu bng biu v chn cc lnh thch hp, click nt . d.4 S dng Table Autoformat

AutoText l kh nng t ng chn vo vn bn cc on vn bn hoc ho thng xuyn c s dng trong vn bn. Chng c nh ngha v lu tr trong vn bn hoc trong cc Template tng ng. Mi mt AutoText c xc nh thng qua mt tn ring bit. S dng AutoText s gip ta tit kim thi gian trong son tho vn bn. 4.7 Auto Text

a) To mi Auto Text Entry to mi mt AutoText Entry, ta lm nh sau:- Chn on vn bn cn lu tr trong AutoText Entry.- Thc hin lnh [Menu] Insert/Quick Part/AutoText- Trong hp thoi xut hin, ta g tn ca AutoText Entry vo mc Enter AutoText entries here. Sau click chut vo nt . Auto Text

Auto Text

b) Chn Auto Text Entry vo vn bn chn mt AutoText Entry vo vn bn, ta c th lm theo 1 trong 2 cch nh sau:Cch 1: - t con tr son tho ti v tr cn chn. - G tn ca AutoText Entry - Nhn phm EnterCch 2: - t con tr son tho ti v tr cn chn - Thc hin lnh [Menu] Insert/Quick Parts/AutoText - Chn AutoText Entry trong danh sch cc AutoText Entry hin c. - Nhn nt Auto Text

Style l mt tp hp cc nh dng ta c th gn cho cc ch trong vn bn. Mi mt Style bao gm cc thuc tnh nh font, c ch, kiu ch, khong cch, cn l,Cc style cho php ta nh dng vn bn mt cch nhanh chng, chnh xc v m bo tnh thng nht trong vn bn. Ngoi nhng style do Word cung cp sn, ta cn c th t nh ngha thm cc style mi theo cch ca mnh. 4.8 Style

Trong Word c hai loi Style sau:- Paragraph Syle: Style p dng cho mt hoc nhiu on vn bn.- Character Style: Style p dng cho chui k t c chn. to mi hay chnh sa Style, ta thc hin lnh [Menu] Format/Styles and Formatting hoc click vo biu tng trn thanh Formatting m hp thoi Style bn phi mn hnh nh sau: Style

Style

Tiu trang l dng ch nm trn cng hoc di cng ca mi trang vn bn. Tiu trang bao gm tiu trn (Header) v tiu di (Footer). to tiu trang, ta thc hin lnh [Menu] Insert/Header and Footer. Khi , mn hnh s xut hin khung hnh ch nht c tn l Header ta g ni dung ca tiu trn. Ti y ta c th thc hin thao tc nh dng nh ngoi vn bn.4.9 To tiu trang

Trong cc ti liu, ta thng s dng cc li ch thch cui trang hay cui ti liu. Khi , ta thc hin cc bc sau:- t con tr ti v tr cn chn ch thch (Footnote)- Thc hin lnh [Menu] Reference/Insert Footnote4.10 To ch thch cho ti liu

To ch thch cho ti liu

To mi mc lcBc 1: nh dng Style cho cc mc cn a vo mc lcCn lu cc im sau khi ch nh Style:- Cc mc cng cp vi nhau c cng Style.- Cc mc cp khc nhau nn c Style khc nhau.Ch : bc ny cn phi tin hnh tht chnh xc Bc 2: a mc lc vo vn bnSau khi hon tt bc 1, a mc lc vo vn bn ta lm nh sau:- t con tr son tho ti v tr cn chn mc lc.- Thc hin lnh [Menu] Reference/Table of Contents. 4.11 To mc lc cho vn bn

To mc lc cho vn bn

To mc lc cho vn bn- Click chut vo nt . Hp thoi Table of Contents Options xut hin nh sau: Trong hp thoi ny ta ch nh th t cc Style c a vo mc lc bng cch nh s th t 1, 2, 3,... trong cc tng ng vi Style v click chut vo nt tr v hp thoi trc. Trong hp thoi Index and Tables, ta click chn kt thc.

b) Cp nht mc lc cp nht li ni dung hoc s trang ca mc lc, ta lm nh sau:- Click phi chut trn mc lc v chn Update Field trong menu xut hin.4.11 To mc lc cho vn bnTrong hp thoi xut hin, ta chn Update page numbers only nu ch mun cp nht li s trang v chn Update entire table nu mun cp nht li ton b ni dung ca mc lc (c mc v s trang). Sau nhn kt thc.

To mi WordArtBc 1: Khi ng chng trnh WordArt theo cch sau:[Menu] Insert/WordArt4.12 Microsoft WordArt

Bc 2: Click i chn mt mu trong WordArt Gallery, click nt m hp thoi Edit Word Art Text.Bc 3: Chn font ch, chn click thc, chn kiu ch.Bc 4: Xo Your Text Here, g ni dung cn trnh by.Bc 5: Click nt OK, hnh WordArt hin ra trong vn bn. To mi WordArt

b) Hiu chnh WordArtNhn vo i tng cn chnh sa thanh cng c WordArt s xut hin nh sau: 4.12 Microsoft WordArt

Shape Style Hiu chnh WordArt

Format Text EffectsHiu chnh WordArt

Xoay hnh WordArt xoay hnh WordArt, trc ht chn WordArt cn xoay, sau chn [Menu] Format/RotateHiu chnh WordArtt chut mt chm trn, con tr chut c dng mi tn cong, ko chut xoay hnh WordArt. Sau khi xoay hnh xong, cn phi click biu tng ny mt ln na lnh mt tc dng.

Hiu chnh chi tit cho ch trong hnh WortArt hiu chnh cch trnh by ch trong hnh WordArt cn phi click cc biu tng lnh sau: Hiu chnh WordArt

WordArt Same Letter HeightsCh in v ch thng c cng chiu caoWordArt Vertical TextXoay ni dung trong hnh WordArt t chiu ngang sang chiu dcWordArt AlignmentCn l ni dung trong WordArtWordArt Charater SpacingThay i khong cch gia cc k t trong hnh WordArt

Word cung cp thanh cng c Drawing gip chng ta s dng cc i tng ho nh ng thng (Line), mi tn (Arrow), hnh ch nht (Rectangle), hnh ellipse (Elipse), Text Box v cc i tng 3D.Thc hin lnh: [Menu] Insert/Shaps.4.13 V hnh, to i tng

V cc i tng trn thanh cng c Drawing Line: v on thng.- Ko chut v on thng.- Gi phm shift ko chut: v on thng c gc l bi s ca 15 .- Gi phm Ctrl ko chut: v on thng ly im t ca chut lm tm. Arrow: v mi tn.- Cch v tng t nh v on thng. Rectangle: v hnh ch nht.- Ko chut v hnh ch nht.- Gi Shift ko chut: v hnh vung.- Gi Ctrl ko chut: v hnh ch nht ly im t lm tm. V hnh, to i tng

V cc i tng trn thanh cng c DrawingOval: v hnh ellipse.- Ko chut v hnh ellipse.- Gi Shift ko chut: v hnh trn.- Gi Ctrl ko chut: v hnh ellipse ly im t lm tm.- Gi Ctrl Shift ko chut: v hnh trn ly im t lm tm. Text box: l mt i tng c s dng ph bin t vn bn ti v tr bt k trong trang giy. V hnh, to i tng

b) Hiu chnh i tng Chn i tng - Di chuyn chut ti gn mt i tng, con tr chut c dng mi tn 4 u - Click chut xung quanh i tng c chn s hin ra cc handle ( vung nh). - Click chut chn c i tng. Nhm cc i tng- Nhn phm Shift v click chut ln cc i tng ta mun nhm.- Th phm Shift sau khi chn ht cc i tng cn nhm.- Click phi chut chn Grouping.- Chn mc GroupV hnh, to i tng

Chn hnh v t ClipArt chn nh t th vin Clip Gallery ta thc hin theo cc bc nh sau:- t con tr text trong vn bn, thc hin lnh [Menu]/Insert/ Picture/ClipArt, hp thoi ClipArt xut hin bn phi mn hnh lm vic, sau click vo nt th nh xut hin nh hnh sau: 4.14 Cc i tng ClipArt

Cc i tng ClipArt- nh c lu trong Categories, ta chn Category m ta mun tm- Click ln nh cn chn- Click vo nh hoc click vo nt (c khoanh trn bn di) ri sau chn vo Insert chn hnh nh.

b) Chn hnh v t fileChng ta c th chn hnh v t file theo cc bc sau:- [Menu] Insert/Picture m hp thoi Insert Picture.- Look in tm chn ng dn qua a, th mc cha, th mc con.- Chn tn file cn chn vo.- Click nt lnh Insert chn hnh v vo vn bn. Cc i tng ClipArt

Cc i tng ClipArt

Trong trn vn bn, ta phn bit hai loi vn bn nh sau:- Main document (vn bn chnh): l vn bn cn to - Data file (file d liu): l file vn bn cha d liu cn trn vo vn bn chnh. Ni dung ca file d liu l mt bng bao gm cc dng v cc ct. Cc ct c gi l cc trng (Field) v c tn c ch nh bi dng u tin ca bng, cc dng t dng th hai tr i c gi l cc bn ghi (record).4.15 Trn vn bn Data file (file d liu)

H TNNAMENGY SINHNI SINHTRNH T LOIo Th LiuDao Thi Lieu02/02/1994Qung BnhCGiiHong Th Thy DungHoang Thi Thuy Dung09/08/1993Qung TrBGiiNguyn Mng MNguyen Mong Mo04/09/1994Qung NinhAKhNguyn Thnh tNguyen Thanh Dat11/02/1993Ngh AnCKhTrn Vn AnTran Van An11/12/1991Tha Thin HuBKh

Trn vn bnMain document (vn bn chnh)

Trn vn bnCc bc trn vn bnGi s c 2 file DATA v Main Document:Bc 1: S dng thanh cng c Maillings- Di chuyn chut ln pha cc thanh cng c, click phi chut chn vo Mail Merge:

Bc 2: Chn chc nng Step by Step Mail Merge Winzard

Trn vn bnHin th thng qua hnh sau:

Trn vn bnBc 3: Thc hin 6 bc theo hng dn ca thanh cng c Mail Merge ca Bc 2:1. Chn kiu ti liu mun trn vn bn (Trn th)2. Xc thc chn kiu thc thi trn vn bn3. Chn d liu cn trn (File DATA)4. Chn cc trng trong file d liu, chn vo cc v tr cn hin th thng tin.5. Xem ni dung va trn theo tng Record6. Hon tt vic trn th, xut ton b ni dung va trn.

Kt qu

Trc khi tin hnh in n vn bn, ta nn xem ton b vn bn kim tra v chnh sa. Ta c th lm vic ny bng mt trong hai cch sau:- Cch 1: Thc hin lnh [Menu] File/ Print Preview- Cch 2: Click chut vo nt trn thanh cng c Khi , mn hnh lm vic ca Word s chuyn sang ch d Preview nh sau: 4.16 In n vn bn

In n vn bn

Phn II: Tin hc vn phngChng 2: MS Excel 2010

Chng 2: S dng MS Excel 2010 2.1 Gii thiu v Excel2.2 Cc thao tc c bn trn Excel2.3 Cc khi nim lin quan2.4 Thao tc vo ra WorkBook2.5 Cc thao tc c bn vi WorkBook2.6 Tnh ton trong Excel2.7 nh dang bng tnh2.8 C s d liu trong Excel2.9 Chn cc i tng v biu 2.10 nh dng trang giy v in n

2.1 Gii thiu v Excel - Microsoft Excel l l phn mm x l bng tnh chy trn h iu hnh Windows. Excel chuyn dng cho cng tc k ton, vn phng trong vic thit k cc bng tnh nh bng lng, bng thng k, bng d ton,... Hin nay phin bn Excel ang s dng rng ri l Excel 2003, 2007, 2010.

Workbook: 1 tap tin Excel goi la 1 WordBook Tren 1 Word Book co toi a 256 WorkSheet (Sheet)- WorkSheet (Sheet) : La 1 bang tnh gom : + Nhieu cot (Column) k hieu:A,B . . . Toi a 256 + Nhieu dong(Row) k hieu : 1,2,3 . . .Toi a 16384 + Giao gia dong va cot goi la o (Cell) + Moi o co 1 a ch (VD: C7 O tai Cot C Dong 6)

2.2 Cc thao tc c bn trn Excela) Khi ng ExcelCch 1: Dng Shortcut Menu ca Microsoft Office- Nhn chut ti biu tng ca Excel trn mn hnh Destop hoc trn thanh Taskbar (nu c).Cch 2: Chn Start/All Program/Microsoft Excel

Cc thao tc c bn trn Excelb) Mn hnh giao tip ca Excel

Mn hnh giao tip ca ExcelTrn mn hnh Excel 2010, ngoi nhng thnh phn nh thanh tiu , cc nt iu chnh kch thc,...ta cn thy ca s Excel cn c cc thnh phn nh sau: Thanh thc n (menu bar): Cha ton b cc lnh thao tc trong Excel, c t chc theo tng nhm. m mt menu c th thc hin mt trong hai cch sau:Cch 1: Click chut vo menu .Cch 2: Nhn t hp phm Alt + Ch ci c gch chn menu .

Mn hnh giao tip ca ExcelThanh cng c (Toolbars): l ni cha cc nt lnh. Mi nt lnh tng ng vi mt thao tc. Thng thng xut hin hai thanh cng c l thanh cng c chun (Standard) v thanh nh dng (Formatting). Ta c th tt/m hai thanh cng c ny cng nh mt s thanh cng c khc bng lnh View/Toolbars.

Thanh cng thc (Formula bar): l ni cha a ch v gi tr c nhp vo ca hin thi .

Vng lm vic (Work Space): l ni cha ni dung ca bng tnh, gm c 256 ct c nh th t theo cc ch ci v 65536 dng c nh theo s th t. Ni giao nhau ca cc dng v ct hnh thnh nn cc (cell). Mi c xc nh bi a ch ca n gm hai phn: ch s u l tn ct, ch s sau l tn dng.

V d: C7 l nm v tr ct C v dng 7.

2.3 Cc khi nim lin quana. WorkBookMt File d liu do Excel to ra tng ng vi mt WorkBook. Mt WorkBook gm t 1 n 255 bng tnh (WorkSheet) .Thng thng Excel s m sn 3 WorkSheet v c t tn l Sheet1,Sheet2,Sheet3. Ta c th i tn li cc WorkSheet, b sung hoc xa b cc WorkSheet trong qu trnh lm vic.Tn WorkBook c t theo quy c t tn ca H iu hnh vi phn m rng nh sn l .XLSX.

Cc khi nim lin quanb. a ch Ta c th ly gi tr ca cc trong bng tnh tnh ton trong cng thc bng cch tham chiu a ch - a ch tng i: l a ch c dng v d B9, C5. Khi sao chp n vng ch th a ch tham chiu vng ch s thay i tnh tin theo.- a ch tuyt i: l a ch c dng v d $B$9, $C$5. Khi sao chp n vng ch th vn gi nguyn a ch ban u.- a ch hn hp: l a ch c dng hoc v d $B5, B$5. Khi sao chp n vng ch th a ch tham chiu vng ch s thay i nhng thnh phn khng c $.

Cc khi nim lin quanc.Cc kiu d liu trong ExcelExcel phn bit hai loi d liu c bn: Hng (Constant value) v Cng thc (Formula value):- Hng bao gm kiu k t hoc s. + Nu trong d liu c mt k t no khng phi l s th Excel hiu l kiu k t. Kiu k t Excel mc nhin canh u bn tri ca .+ Nu trong d liu ton l s th Excel hiu l kiu s. D liu kiu s Excel mc nhin canh u bn phi ca .- Kiu cng thc bao gm biu thc trong cha a ch hoc tn ca mt s hoc vng khc ca bng tnh. g cng thc phi bt u bng du "=" hoc du "+".

Cc khi kiu d liu trong Excel- Ngoi hai kiu d liu c bn trn, cn c kiu Logic bao gm cc gi tr TRUE v FALSE hoc cc hm s mang gi tr logic.- Excel cn c kiu ngy thng, kiu thi gian ( lu gi). Hai kiu d liu ny Excel mc nhin canh u bn phi ca .Ch : Mi ch c th cha mt loi kiu d liu.

2.4 Thao tc vo ra Workbooka.To file mi:- To mt Workbook mi bng lnh [menu] File/New hoc nhn Ctrl-N hoc click vo biu tng trn thanh cng c chun mn hnh hin th hp hi thoi hoc t ng to ra 1 file mi:

2.4 Thao tc vo ra Workbookb.M file c:Thc hin lnh [menu] File/Open hoc nhn Ctrl-O hoc click vo biu tng trn thanh cng c chun m mt Workbook c sn trn a xut hin hp thoi sau:

- Chn tn file cn m bng cch click chn ng dn trong Look in.- Nhn hoc kt thc.

2.4 Thao tc vo ra Workbookc.Lu file- Lnh ny rt hu hiu phng khi mt in, hay treo my th d liu ta thay i vn c ghi li y .- Thc hin lnh [menu] File/Save hoc hoc nhn Ctrl-S hoc click vo biu tng trn thanh cng c chun ghi cc thay i ca d liu trong file ang lm vo a. Khi thc hin lnh lu file ln u tin th chng trnh s xut hin hp hi thoi sau:

Lu file

- Chn th mc cn lu file trong hp thoi Save As .- G tn file cn lu trong mc File name- Kt thc cng vic bng nt hoc nhn phm .- Trong cc ln lu k tip chng trnh s t ng cp nht cc ni dung mi vo file c ch nh m khng hi li tn file.- Lnh [menu] File/Save as cho php ghi file ang lm vic vo a bng tn mi. Cc thao tc thc hin cng tng t nh khi lu file.

2.4 Thao tc vo ra Workbookd.ng file ng file ang c m, thc hin lnh [menu] File/Close hoc click vo nt trn thanh tiu .Ch : Nu file cha lu vo a th mn hnh xut hin thng bo nhc nh:

Chn lu file, chn nu khng mun lu file, chn quay tr v file hin ti.

2.5 Cc thao tc c bn vi Workbooka.Di chuyn trong bng tnh- S dng cc phm mi tn (, , , ) di chuyn hin hnh theo hng cc mi tn, mi ln 1 .- Phm Page Up, Page Down di chuyn hin hnh ln hay xung mt trang mn hnh.- Ctrl kt hp vi phm: Page Up hay Page Down di chuyn bng tnh hin hnh sang tri hay phi mt bng tnh.- Ctrl - Home: Di chuyn hin hnh v A1.- Ctrl - End: Di chuyn hin hnh v cui cng ca vng d liu trong sheet.

2.5 Cc thao tc c bn vi Workbookb.Nhp d liu vo bng tnh nhp d liu vo bng tnh ta c nhiu cch: - G cc gi tr t bn phm vo nh son tho thng thng.- Tr chut n cn nhp ri a con tr ln thanh cng thc, g d liu bnh thng t bn phm.

2.5 Cc thao tc c bn vi Workbookc.Sa gi tr trong Excel cho php sa d liu trong tng cng bng 2 cch.- Click i chut vo cha gi tr cn sa ri mi tin hnh sa.- Tr chut n cn sa gi tr ri nhn phm F2. Lc ny con tr bin thnh ( | ) nm trong dng d liu, ta dng phm mi tn di chuyn con tr sa gi tr. Kt thc sa bng cch nhn phm Enter.

2.5 Cc thao tc c bn vi Workbookd.Chn khi d liu- tin hnh nh du mt khi c cc cch sau: + Nu s dng bn phm, hy a hp iu khin ti l gc ca khi. Gi v nhn phm Shift ng thi s dng cc phm mi tn (, , , ) di chuyn ti gc i din ca khi cn nh du.+ Nu s dng chut, hy nhn v gi nt tri chut ng thi r chut ti v tr gc i din ca khi.+ a chut tr ti gc tri trn ca khi. Gi phm Shift ng thi click chut ti i din ca khi.- Cc phng php c bit nh du khi :+ nh du c mt dng: Click tri chut ti tn ca hng .+ nh du c mt ct: Click chut ti tn ca ct .

2.5 Cc thao tc c bn vi Workbooke.Xa d liu- nh du khi cn xo.Cch 1: Thc hin lnh [menu] Home/Clear, Excel s cho chn tip mt trong cc thng s sau:+ All: Chn lnh ny nu mun xo c d liu v kiu nh dng d liu.+ Formats: Lnh ny cho php ch xo kiu nh dng d liu m khng xo gi tr d liu.+ Contents: Ngc li vi lnh trn, lnh ny ch xo d liu cn gi li kiu trnh by cho d liu nhp vo sau .+ Comments: Lnh ny xo i cc comments (ghi ch) trong khi c chn.+ Hyperlinks: Xa b lin kt ti cc a ch WebCch 2: Nhn phm Delete tng ng vi lnh ch xo d liu.

Xa d liuXa d liu s dng thanh cng c ClearCch 3: Xa d liu s dng thanh cng c Delete

2.5 Cc thao tc c bn vi Workbookf.Sao chp d liuVic thc hin cc thao tc sao chp, ct dn d liu l hon ton tng t nh trong Word.Cch 1:- nh du khi mun sao chp vo [Menu] Home/Copy hoc nhn ng thi phm Ctrl-C hoc click vo biu tng trn thanh cng c chun.- Di chuyn con tr n cn sao chp ti vo [Menu] Home/Paste hoc nhn ng thi Ctrl-V hoc click vo biu tng .

Sao chp d liuCch 2:+ nh du khi , ri a con tr chut n bin ca khi c nh du (Lc con tr xut hin thm du + gc trn bn phi). + Gi phm Ctrl ng thi bm gi tri chut v r ti v tr cn c sao chp ti v th tay (th chut trc th phm sau).

2.5 Cc thao tc c bn vi Workbookg.Di chuyn d liuCch 1:- nh du khi mun sao chp vo [Menu] Home/Cut hoc nhn ng thi phm Ctrl-X hoc click vo biu tng trn thanh cng c chun.Di chuyn con tr n cn sao chp ti vo [Menu] Home/Paste hoc nhn ng thi Ctrl-V hoc click vo biu tng .Cch 2:- nh du khi.- a con tr ti bin ca khi (lc con tr c dng ) bm gi nt tri chut v r ti v tr ch ri th tay.

2.5 Cc thao tc c bn vi Workbookh.Dn c bit[menu] Home/Paste Special, Excel s hin th hp thoi chn lnh thc thi.- nh du khi trn bng tnh, sau thc hin thao tc copy. - Thc hin lnh: Home/Paste Special, mn hnh hin th hp hi thoi:

Dn c bit

Mt s ty chn cn thit:- All: Dn ton b c gi tr v kiu nh dng.- Formulas: Dn cng thc tnh ton.- Values: Ch dn gi tr d liu, cn khng dn cng thc v kiu nh dng.- Formats: Dn kiu nh dng d liu.- Comments: Ch dn cc ghi ch.Nhn chut vo nt kt thc.

2.5 Cc thao tc c bn vi Workbooki.Di chuyn trong bng tnhCch 1: S dng cc phm mi tn (, , , ) di chuyn con tr n cn lm vic.Cch 2: S dng chut di chuyn n cn lm vic v click nt tri chut.Cch 3: di chuyn nhanh n mt bt k, ta ch vic bm phm F5, Excel hin hp thoi g vo a ch cn chuyn ti v nhn Enter.Cch 4: S dng cc phm PgUp, PgDn di chuyn ln, xung mt trang mn hnh.

2.5 Cc thao tc c bn vi Workbookk.i tn bng tnh- i tn bng tnh hin thi ta thc hin lnh [menu] Home/Format/ Rename Sheet hoc click phi chut sheet mun i tn sau chn Rename.

- Lc ch Sheet c bi en v con tr c dng (|) ta g tn mi vo. - Nhn Enter kt thc.

2.5 Cc thao tc c bn vi Workbookl.Chn bng tnh mi- Thc hin lnh [menu] Home/Insert/Insert Sheet hoc a chut n v tr cc sheet sau click phi chut chn Insert.

- Excel s chn thm mt bng tnh ngay cnh bng tnh hin thi. C th m ti a 255 bng tnh nh vy.

2.5 Cc thao tc c bn vi Workbookm.Xa bng tnh- Thc hin lnh [menu] Home/Delete Sheet hoc click phi chut trn sheet tng ng chn Delete (nh hnh sau).

- Nu chc chn mun xo, click vo nt .Ch : Ta c th click chut phi ti tn ca bng tnh (Sheet1, Sheet2,...) ti dng gn cui mn hnh, mn hnh hin th mt danh sch cc lnh tng t vi cc chc nng nu trn.

Hng v ct trong bng tnha.Chn hng, ctThc hin lnh [menu] Home/Insert, xut hin hp hi thoi sau:

- Shift cells right: Chn cc trng vo cc c nh du v dch chuyn d liu sang phi.- Shift cells down: Chn cc trng vo cc c nh du v dch chuyn d liu xung di.- Entire Row: Chn cc dng trng vo cc c nh du v dch chuyn cc dng xung di.- Entire Column: Chn cc ct trng vo cc c nh du v dch chuyn cc ct sang bn phi.- Click chut vo nt kt thc.

Hng v ct trong bng tnhb.Xa hng, ctLnh xo ct hay hng c thc hin t lnh [Menu] Home/Delete, Excel hin hp hi thoi gm cc lnh ta chn la tng t hp thoi chn hng ct xut hin hp thoi sau:

- Shift Cells Left: Xo cc c nh du v dch chuyn vo d liu t cc bn phi.- Shift Cells Up: Xo cc c nh du v dch chuyn vo d liu t cc bn di.- Entire Row: Xo cc dng cha cc c nh du v dch chuyn cc dng bn di ln.- Entire Column: Xo cc ct c nh du v dch chuyn cc ct bn phi sang.- Click chut vo nt kt thc.

Hng v ct trong bng tnhc.iu chnh rng ca ctC hai cch iu chnh rng ct, l:- Dng chut: Ko r chut ti cc ng ngn cch tng ng trn ct tiu ca bng tnh.- Dng phm: [Menu] Home/Format/Column Width, ri chn tip cc lnh sau y:+ Width: Nhp chnh xc rng ct theo mong mun. + Auto Fit Column Width: Excel s t ng iu chnh rng ct va kht vi ni dung trong ct.- Nhn kt thc.

Hng v ct trong bng tnhd.iu chnh cao ca dngC hai cch iu chnh cao hng:- Dng chut: Click v r chut ti cc ng ngn tng ng trn hng tiu ca bng tnh.- Dng phm: [menu] Home/Format/Row Height, ri chn tip cc lnh sau y:Height: Nhp chnh xc cao hng theo mong mun. Auto Fit Row Height: Excel s t ng iu chnh cao hng va kht vi ni dung trong hng.Nhn OK kt thc.

2.5 Cc thao tc c bn vi Workbookn.Hy b thao tc va tin hnhThc hin: [Menu] Home/Undo hoc nhn t hp phm Ctrl + Z hoc nhn nt trn thanh cng c chun.

2.5 Cc thao tc c bn vi Workbooko.Thot khi Excel- Thc hin: [menu] Fle/Exit hoc nhn t hp phm Alt-F4 hoc click vo biu tng trn thanh tiu .- Nu bng tnh cha lu vo a th mn hnh hin th thng bo:

- Yes hoc nhn Enter lu tr nhng thay i trong file bng tnh.- Donts Save nu khng mun lu bng tnh, thot khi Excel.- Cancel hy b lnh, tr li ca s bng tnh tip tc lm vic.

2.6 Tnh ton trong Excel2.6.1.Cc ton ta) Cc ton t i vi d liu dng sb) Cng thc trong Excelc) S dng cc hm trong Excel

Cc ton t a) Cc ton t i vi d liu dng s Ton t s hc

Ton tMc ch+Cng-Tr*Nhn/Chia%Ly phn trm^Lu tha

Cc ton t i vi d liu dng s u tin ca cc ton t c thc hin theo mc sau:

Ch :- Cc ton t trong mt biu thc c cng u tin th th t thc hin l t tri sang phi.- C th thay i th t u tin bng cch thm du ngoc trong cc thnh phn to nn cng thc.

Ton tMc ch^Lu tha*, /Nhn, chia+, -Cng, tr

Cc ton t i vi d liu dng sV d: Vi cng thc =(2+15)*4 Excel s thc hin cng thc nh sau:- u tin tnh: 2+15 = 17.- Sau : 17*4 = 68, 68 l kt qu cui cng.

Cc ton t a) Cc ton t i vi d liu dng s Ton t logicNOT: Ton t ph nhAND : Ton t vOR : Ton t hocBiu thc logic ch c hai gi tr TRUE v FALSE

Cc ton t a) Cc ton t i vi d liu dng s Ton t quan h so snh cc kt qu ta c th lp cc cng thc vi cc ton t so snh. Chng s cho gi tr TRUE hoc FALSE tu thuc vo cch xem xt cc iu kin.

TON TMC CH=Bng nhauLn hn=Ln hn hoc bngKhng bng nhau

Cc ton t b) Cc ton t i vi kiu k tCc ton t quan h: = , ,=, Ton t ni chui : &V d: ="Khoa " & "Cng Ngh" cho kt qu l "Khoa Cng Ngh"Ch : Chui phi c t trong cp du nhy kp ("...").

Cc ton t c) Cc ton t vi kiu d liu ngy thngTa c th s dng cc php ton cng, tr s hc v cc php ton quan h khi s dng d liu kiu ngy thng.

2.6.2 Cng thc trong Excela) Bin i cng thc thnh gi trb) Sao chp cng thcc) iu chnh cc li ca cng thc

Cng thc trong Excela) Bin i cng thc thnh gi trTrong nhiu trng hp sau khi to cng thc ta ch cn kt qu ca n hn l cng thc v thc s khng mun thay i gi tr na. Trong trng hp nh th ta c th bin i cng thc ra gi tr thc ca n. Th t thc hin nh sau:- Chn cha cng thc mun bin i.- Nhn phm F2 hoc click i chut.- Nhn phm F9, Excel s thay cng thc bng gi tr ca n.

Cng thc trong Excelb) Sao chp cng thc tin hnh sao chp hng lot ta c th thc hin mt trong hai cch nh sau:Cch 1: - Click chut vo cha cng thc cn sao chp.- Nhn Ctrl-C hoc click vo biu tng hoc vo [Menu] Home/Copy- Bi en cc cn tin hnh sao chp.- Nhn Ctrl-V hoc click vo biu tng hoc vo [Menu] Home/Paste.Cch 2:- Click chut vo cha cng thc cn sao chp.

Sao chp cng thca chut n nt Fill handle (gc di bn phi ca thanh tr), lc ny con chut bin thnh hnh du +, th thc hin r chut n cc cn sao chp.Ch : Ta cng c th in nhanh s th t bng cc bc sau:- Nhp s th t u tin, click chut vo va nhp.- a chut n nt Fill handle ca va nhp, lc ny chut s c dng du +- Nhn v gi phm Ctrl, ri ko r chut xung cc cn in s th t.- Th nt tri chut trc, th phm Ctrl sau, s th t s c t ng in vo ng ca n.

Cng thc trong Excelc) iu chnh cc li ca cng thcKhi to cc cng thc trong Excel, mt s sai st c th xy ra. y lit k mt s li thng gp m Excel thng bo cho ta bit nh sau:

LI NGHA# DIV/OCng thc gp trng hp chia cho s khng#N/AXy ra khi gi tr khng dng c# NAME?Cng thc c dng tn m Excel khng nhn ra c.# NUM!Cng thc dng mt s khng ng.#VALUECng thc dng mt i s hoc ton t sai kiu

2.6 Tnh ton trong Excelc) S dng cc hm trong Excel- Mt hm l mt biu thc tnh ton c nh ngha trc thc hin cc tnh ton phc tp thay cch vit cng thc cho cc .- C php chung ca hm nh sau: = ( )- Tn hm c th vit bng ch hoa hay ch thng.- Cc i s thng cch nhau bng du "," hoc du ; tu theo thit lp trong my. Chng c th l cc hng s, a ch khi, tn khi hoc mt hm khc...

S dng hm trong Excel- Nu i s l mt vng a ch th cn ghi theo dng a ch gc tri pha trn:a ch gc phi pha di.V d: A1:B2 l bao gm cc A1, A2, B1, B2.Ch : Khi s dng du ( ) th m bao nhiu du "(" phi c by nhiu du ng ")".V d: Ta g hm tnh tng nh sau: =Sum(A4:A8). Lc Excel s tnh tng gi tr cc t A4 n A8.

S dng hm trong Excela)Nhm hm x l ton hcb)Nhm hm thng kc)Nhm hm x l k td)Nhm hm ngy thng nme)Nhm hm logicf)Nhm hm tm kim

S dng hm trong Excela)Nhm hm x l ton hc a1) Hm ABS C php: ABS(x) Chc nng: Tr v gi tr tuyt i ca s x.V d: ABS(-2) bng 2. ABS(2) bng 2.

Nhm hm x l ton hca2) Hm SQRTC php: SQRT(x)Chc nng: Tr v cn bc hai ca s khng m x.V d: SQRT(9) bng 3. SQRT(-9) s tr v li #NUM!.

Nhm hm x l ton hca3) Hm MODC php: MOD(n,t)Chc nng: Tr v s d ca php chia nguyn n/t.V d: MOD(12,5) bng 2.

Nhm hm x l ton hca4) Hm INTC php: INT(number)Chc nng: Tr v phn nguyn ca s number. Hm s tr v gi tr theo xu hng ly s nguyn nh hn.V d: INT(3.5) bng 3. INT(-3.5) bng -4.

Nhm hm x l ton hca5) Hm ROUNDC php: ROUND(x,n)Chc nng: Tr v s x sau khi lm trn vi chnh xc n n s thp phn (n>0). n=0 lm trn hng n v.n=-1 lm trn hng chc...V d: ROUND(3.547,2) bng 3.55. ROUND(14624.47,-2) bng 14600 (lm trn hng trm).

S dng hm trong Excelb)Nhm hm thng k b1) Hm AVERAGEC php: AVERAGE(number1,number2,...)Chc nng: Tnh trung bnh cng ca number1, number2,...Ch : Nu a ch nm trong i s cha kiu k t, gi tr logic hoc l cc trng th cc gi tr ny c b qua. Tuy nhin cc cha gi tr bng 0 u c tnh.V d: Nu A1:A4 cha cc s 1,3,5,7 th AVERAGE(A1:A4) bng 4.

Nhm hm thng kb2) Hm COUNTC php: COUNT(value1, value2,...)Chc nng: Tr v s lng cc c kiu s trong cc i s.V d: Nu A1:A4 cha cc d liu l 1, "test", 5, 7 th COUNT(A1:A4) bng 3.

Nhm hm thng kb3) Hm COUNTIFC php: COUNTIF(vng a ch, iu kin)Chc nng: Tr v s lng cc trong vng a ch tha mn iu kin.Ch : iu kin phi t trong cp du nhy kp "..."V d: Nu A1:A4 cha cc d liu l 1, 3, 5, 7 th COUNTIF(A1:A4,">4") bng 2.

Nhm hm thng kb4) Hm SUMC php: SUM(n1,n2,...)Chc nng: Tr v tng ca cc i s n1, n2...Ta cng c th a vo y a ch ca vng d liu cn tnh tng.V d: SUM(3,5) bng 8. SUM(A1:A5) s tr v tng gi tr ca cc t A1 n A5.

Nhm hm thng kb5) Hm SUMIFC php: SUMIF(vng a ch 1,iu kin,vng a ch 2)Chc nng: Tr v tng ca cc s tha mn iu kin.Nu cc trong vng a ch 1 tho mn iu kin, hm s tr v tng cc tng ng trong vng a ch 2.Ch : iu kin phi t trong cp du nhy kp "...".V d: Gi s c cc d liu a ch sau:

Hm SUMIFSUMIF(A1:A3,">=6",B1:B3) bng 8.

AB193244375

Nhm hm thng kb6) Hm MAXC php: MAX(number1, number2,...)Chc nng: Tr v s ln nht trong cc i s.V d: Nu A1:A4 cha cc d liu l 1,9,5,7 th MAX(A1:A4) bng 9.

Nhm hm thng kb7) Hm MINC php: MIN(number1, number2,...)Chc nng: Tr v s nh nht trong cc i s.V d: Nu A1:A4 cha cc d liu l 9,1,5,7 th MIN(A1:A4) bng 1.

Nhm hm thng kb8) Hm RANKC php: RANK(s, dy s, loi th t)Chc nng: Hm s tr v th t ca s trong dy s, dy s y c th l vng gi tr hoc a ch ca vng dy s cn xp th t.Nu loi th t l 0 hoc b qua th Excel s xp th bc theo th t gim dn ca dy s. Nu loi th t l mt gi tr bt k khc 0 th Excel s xp th bc theo th t tng dn ca dy s.

Hm RANKV d: Nu A1:A4 cha cc d liu l 3,1,5,7 th RANK(A1,$A$1:$A$4,0) bng 3, trong khi RANK(A1,$A$1:$A$4,1) bng 2.Ch : a ch i s th hai thng s dng a ch tuyt i khi tin hnh sao chp th khng b thay i.

S dng hm trong Excelc)Nhm hm x l k t c1) Hm LEFTC php: LEFT(text,number)Chc nng: Ly number k t bn tri ca text.V d: LEFT("Khoa Cng Ngh",4) bng "Khoa".

Nhm hm x l k tc2) Hm RIGHTC php: RIGHT(text,number)Chc nng: Ly number k t bn phi ca text.V d:RIGHT("Trng Ph Xun",4) bng "Xun".

Nhm hm x l k tc3) Hm LENC php: LEN(text)Chc nng: Tr v di ca chui k t textV d: LEN("Tin hc") bng 7.

Nhm hm x l k tc4) Hm LOWERC php: LOWER(text)Chc nng: Chuyn text thnh ch in thng V d: LOWER("Hc V Hnh") bng "hc v hnh".

Nhm hm x l k tc5) Hm UPPERC php: UPPER(text)Chc nng: Chuyn text ch thng thnh ch in hoa.V d: UPPER("Hc V Hnh") bng "HC V HNH".

Nhm hm x l k tc6) Hm PROPERC php: PROPER(text)Chc nng: Chuyn cc ch ci u t ca text thnh ch hoa v cc ch cn li thnh ch thng.V d: PROPER("trUng tM") bng "Trung Tm".

Nhm hm x l k tc7) Hm MIDC php: MID(text,m,n)Chc nng: Cho kt qu l chui con trch ra t chui text t v tr m v gm n k t.V d: MID("Hong Th Vui",4,5) bng "ng Th".

Nhm hm x l k tc8) Hm TRIMC php:TRIM(text)Chc nng: Ct b cc k t trng hai pha ca text.V d:TRIM(" Hiu trng ") bng "Hiu trng".

S dng hm trong Exceld)Nhm hm ngy thng nm d1) Hm DATEC php: DATE(year, month, day)Chc nng: Cho gi tr l mt d liu kiu ngy ng vi cc i s c a vo.V d: DATE(90,10,6) s tr v 10/6/90 (nh dng theo thng/ngy/ nm).

Nhm hm ngy thng nmd2) Hm DAYC php: DAY(date)Chc nng: Tr v gi tr ngy trong thng ca bin ngy thng date.V d: Day(11/07/2005) bng 7 (nh dng theo kiu thng/ngy/nm)

Nhm hm ngy thng nmd3) Hm MONTHC php: MONTH(date)Chc nng: Tr v gi tr thng trong nm ca bin ngy thng date.V d: MONTH(11/07/2005) bng 11(nh dng theo thng/ngy/ nm).

Nhm hm ngy thng nmd4) Hm YEARC php: YEAR(date)Chc nng: Tr v gi tr nm ca bin ngy thng date.V d:YEAR(11/07/2005) bng 2005 (nh dng theo thng/ngy/ nm).

S dng hm trong Excele)Nhm hm logic e1) Hm ANDC php: AND(logical1,logical2, ...)Trong logical1, logical2, ... l cc i s nhn mt trong hai gi tr logic TRUE hoc FALSE. Nu i s khng nhn gi tr logic, hm AND tr v gi tr li #VALUE!Chc nng: Hm s tr v gi tr TRUE (NG) nu tt c cc i s nhn gi tr TRUE; tr v gi tr FALSE (SAI) nu c t nht mt i s nhn gi tr FALSE. V d: AND(2+2=4, 2+3=5) bng TRUE.AND(3>4, 2+3=5) bng FALSE.

Nhm hm logice2) Hm ORC php: OR(logical1, logical2...)Trong logical1, logical2,... l cc i s nhn mt trong hai gi tr logic TRUE hoc FALSE. Nu i s khng nhn gi tr logic, hm OR tr v gi tr li #VALUE!Chc nng:Tr v gi tr ng nu c t nht mt i s nhn gi tr ng, cho gi tr sai nu tt c i s u nhn gi tr sai.V d: OR(2+2=4, 2+3>5) bng TRUE. OR(3>4, 2+3

Nhm hm logice3) Hm IFC php: IF(biu thc logic, gi tr ng, gi tr sai)Chc nng: Hm tr v gi tr ng nu biu thc logic ng, ngc li cho gi tr l gi tr sai.V d: IF(3>2,"ng","sai") bng ng.- Mt bng im c lu trong bng tnh nh sau: D2 cha im trung bnh, E2 cha Xp loi. Xp loi da vo im trung bnh theo ba mc:TB >=8: Xp loi Gii8 > TB >=7: Xp loi Kh7 > TB: Xp loi Trung bnh xc nh Xp loi ta c th dng cng thc E2 nh sau: =If(D2>=8,Gii,If(D2>=7,Kh,Trung bnh)) Minh hoa

Nhm hm tm kimf1) Hm VLOOKUPC php: VLOOKUP(Tr d, Bng tham chiu, Ct tham chiu, Cch d)Chc nng: Hm thc hin vic tm kim Tr d trn ct u tin ca Bng tham chiu, khi tm thy th lch qua bn phi n Ct tham chiu ly tr trong tng ng vi v tr tm thy ca Tr d.Bng tham chiu: Gm mt khi cc , thng gm nhiu hng v nhiu ct. Ct u tin lun lun cha cc tr d tm, cc ct khc cha cc tr tng ng tham chiu.Ct tham chiu: Th t ca ct tnh t tri qua phi trong bng tham chiu, ct u tin c nh s l 1.

Hm VLOOKUPCch d: C hai gi tr: - Nu l s 0 (hoc FALSE, cn gi l d tm chnh xc): Danh sch cc tr ca ct 1 khng cn sp xp theo th t tng dn. Nu khng tm thy tr d Bng tham chiu, hm s tr v li #N/A. - Nu l s 1 (hoc TRUE, cn gi l d tm ln cn hay d tm xp x): Danh sch cc tr ca ct 1 phi c sp xp theo th t tng dn. Nu khng tm thy tr d chnh xc n s ly gi tr nh hn v gn bng vi tr d. Nu tr d nh hn tr u tin ca ct 1 th hm s tr v li #N/A. Mc nh cch d l 1.

Hm VLOOKUPV d: Cho d liu nh sau:

BCDETTH tnKhu vcim chun1Hong Phi22Nguyn Th Nh33Trn c1

Khu vcim chun124223322

Hm VLOOKUP ly im chun da vo ct Khu vc ca cc th sinh, ta c th s dng hm VLOOKUP E3 nh sau:=VLOOKUP(D3,$D$8:$E$10,2,0), lc n s tr v gi tr l 23.Ch : Trong cng thc ny i s th hai phi c s dng a ch tuyt i khi tin hnh sao chp cng thc th a ch ca Bng tham chiu khng b thay i.

Nhm hm tm kimf2) Hm HLOOKUPC php:HLOOKUP(Tr d, Bng tham chiu, Hng tham chiu, Cch d)Chc nng: Hm thc hin vic tm kim Tr d trn hng u tin ca Bng tham chiu, khi tm thy th lch qua bn phi n Hng tham chiu ly tr trong tng ng vi v tr tm thy ca Tr d.Bng tham chiu: Gm mt khi cc , thng gm nhiu hng v nhiu ct. Hng u tin lun lun cha cc tr d tm, cc hng khc cha cc tr tng ng tham chiu.Hng tham chiu: Th t ca hng tnh t trn xung di trong bng tham chiu, hng u tin c nh s l 1.

Hm HLOOKUPCch d: C hai gi tr: - Nu l s 0 (hoc FALSE, cn gi d tm chnh xc): Danh sch cc tr ca ct 1 khng cn sp xp theo th t tng dn. Nu khng tm thy tr d Bng, hm s tr v li #N/A. - Nu l s 1 (hoc TRUE, cn gi l d tm ln cn hay d tm xp x): Danh sch cc tr ca hng 1 phi c sp xp theo th t tng dn. Nu khng tm thy tr d chnh xc n s ly gi tr nh hn v gn bng vi tr d. Nu tr d nh hn tr u tin ca hng 1 th hm s tr v li #N/A.Mc nh cch d l 1.

Hm HLOOKUPV d: Cho d liu nh sau:

BCDE2TTH tnKhu vcim chun31Hong Phi242Nguyn Th Nh353Trn c167Khu vc 1238im chun242322910

Hm HLOOKUP- ly im chun da vo ct Khu vc ca cc th sinh, ta c th s dng hm HLOOKUP E3 nh sau: =HLOOKUP(D3,$C$7:$E$8,2,0), lc n s tr v gi tr l 24.Ch : Trong cng thc ny i s th hai phi c s dng a ch tuyt i khi tin hnh sao chp cng thc th a ch ca Bng tham chiu khng b thay i.

2.7 nh dng bng tnha) Bng lnh trc tipb) Bng style

nh dng bng tnha) Bng lnh trc tipSau khi nh du khi bng tnh cn nh dng, ta thc hin lnh [Menu] Home/Format/Format Cells (hoc t hp phm Ctrl -1) to nh dng tng th. Excel xut hin hp hi thoi bao gm cc th nh dng ring bit:

nh dng bng tnh

nh dng bng tnha1) nh dng cho s (Number)Trong hp Category chn kiu d liu cn trnh by v chn tip cc thng s tng ng vi kiu d liu chn. Ta c th quan st mc Sample xem mu nh dng. C th:- General: nh dng chung. Vi kiu nh dng ny, d liu kiu k t g vo s c canh hng bn tri v d liu kiu s sau khi g vo bng tnh s c canh hng bn phi .- Number: dng nh dng cc s thng thng. Chn tip cc thng s sau:

nh dng cho s- Decimal places: khai bo s ch s sau du chm thp phn.- Use 1000 Separators(,): click chn khi mun dng du phy phn cch hng nghn- Negative numbers: chn cch nh dng s m.- Currency: Chn cch hin k hiu tin t.- Date: Chn cch hin gi tr ngy thng. Percentage: Chn cch hin k hiu phn trm.- Fraction: Chn cch hin gi tr phn s.- Scientific: Chn cch hin s di dng khoa hc.

nh dng cho s- Text: nh dng s theo kiu k t.- Special: nh dng theo m vng v s in thoi- Custom: tu bin theo khun dng c g trong hp Type. Nt Delete c dng xo khun dng khng cn dng n.Chn kt thc.

nh dng bng tnha2) nh dng ngy thngExcel cho php ta hin th ngy thng theo nhiu kiu nh dng khc nhau. Ta c th s dng nhng mu nh dng c sn hoc c th t nh ngha nhng kiu nh dng mi theo thch.- S dng nhng mu nh dng c sn: khung Category chn mc Date, v chn kiu hin th bn khung Type. Excel thng hin th ngy thng theo dng tng qut m/d/yy (thng/ngy/nm) - S dng nhng nh dng t nh ngha: Nu khng va vi cc dng c sn, ta c th to ra mt dng hin th ring bng cch sau:Chn mc Start/Control Panel xut hin hp thoi Control Panel chn vo biu tng xut hin hp thoi sau:

nh dng ngy thng

nh dng ngy thngChn vo nt Additional settings xut hin hp thoi tip theo chn vo tab Date th hp thoi c dng sau:

nh dng ngy thngTrong khung Short date (nh ngha kiu th hin kiu ngy rt gn)Short date sample: v d v cch th hin nh dng ngy c nh ngha.Short date format: kiu ngy ang c nh ngha, ta c th click chn vo y chn kiu nh ngha mi hoc c th g trc tip vo khung ny.Date separator: Du phn cch gia ngy, thng v nm (du hoc /)V d: Mun ngy thng hin th theo nh dng ngy/thng/nm chng hn nh 25/10/2005, ta nhp dd/mm/yyyy (2 s cho ngy/2 s cho thng/4 s cho nm) .

nh dng ngy thngTrong khung Long date (nh ngha kiu th hin kiu ngy chi tit)Long date sample: v d v cch th hin nh dng ngy c nh ngha.Long date format: kiu ngy ang c nh ngha, ta c th click chn vo y chn kiu nh ngha mi hoc c th g trc tip vo khung ny.- Nhn nt p dng kiu nh dng mi sau nhn kt thc.

nh dng bng tnha3)Canh hng d liu (Alignment)Chn th Alignment, hp thoi xut hin nh sau:

Canh hng d liuMc Horizontal: Dng canh chnh theo chiu ngangGeneral: Tr v cch sp xp ngm nh (d liu kiu k t c canh tri, d liu kiu s c canh phi, cc gi tr logic v li c canh gia).Left: Canh tri cc .Center: Canh gia cc .Right: Canh phi cc .Justify: Canh u hai bn cc . Mc Vertical: Dng canh chnh theo chiu dcTop: K t hin st nh Center: K t hin gia .Bottom: K t hin y .

Canh hng d liu Mc Text control: dng iu kin d liu trong khi c chnWrap text: Khi click chn th rng ct s c nh, d liu nhp vo t ng xung hng.Shrink to fit: khi click chn vo mc ny th d liu trng s co li va bng kch thc ca .Merge cells: Khi click chn th Excel s st nhp cc chn li thnh mt . Hp Orientation: Dng chnh nghing ca d liu trong da theo cc la chn v cch sp xp ca t Text. Ta c th nhn vo gi chut iu chnh hoc c th nhp gi tr vo Degrees.Kt thc ta nhn nt OK.

Canh hng d liu Ch : Ta c th s dng cc nt lnh trn thanh nh dang Formatting trnh by khi .Nt : Canh tri cc trong khi chn.Nt : Canh gia cc trong khi chn.Nt : Canh phi cc trong khi chn.Nt : St nhp cc chn li thnh mt .

2.8 C s d liu trong Excela)Khi nim CSDL trong Excelb)Sp xp CSDLc)Lc d liud)Cc hm trong CSDLe)Tng hp s liu theo nhm

C s d liu trong Excela)Khi nim CSDL trong Excel- CSDL trong Excel thng c t chc di dng bng gm c cc dng v cc ct.- Cc ct gm cc cha d liu cng kiu gi l cc trng (Field) v cc dng, k t dng th hai tr i cha y thng tin ca cc trng.- Dng u ca bng cha cc tiu ct gi l tn trng (Field name). Dng th hai tr i cha thng tin ca cc trng gi l bn ghi (Record).- Excel nhn bit CSDL mt cch d dng th vng CSDL phi tch bit hn vi cc phn khc ca bng tnh bi cc dng trng v ct trng.- Gia dng cc tn trng v bn ghi u tin khng c c dng trng.

C s d liu trong ExcelV d:

Record (Bn ghi)Record (Bn ghi)Record (Bn ghi)

STTH v tnLp im trung bnh1V Th Hng TyCNTT17.52on Vit Thnh CNTT27.33Trn Quang NhuCNTT38.24Hong Th MinhCNTT48.5

C s d liu trong Excelb)Sp xp CSDLb1) Sp xp nhanh:- Click chut vo bt k trong trng mun sp xp.- Click vo nt Sort Ascending sp xp tng dn.- Click vo nt Sort Descending sp xp gim dn.

C s d liu trong Excelb2) Sp xp d liu theo ni dung ca nhiu ct:- Click chut vo bt k trong bng CSDL hoc bi en cc dng cn sp xp.- Thc hin lnh [Menu] Data/Sort..., hp thoi sau xut hin:

C s d liu trong Excel- Sort by: Click chn tn trng cn sp xp. - Sort on: Click chn gi tr ca trng cn sp xp.- Order: Th t u tin ca cc trng.- Nhn bt u sp xp.

C s d liu trong Excel- Trong trng hp c ch ra hnh trn, Excel s sp xp CSDL theo ct H v tn vi hng tng dn, nu tn ti cc bn ghi c H v tn ging nhau th Excel s sp xp theo ct Lp vi hng gim dn, nu n lc ny vn tn ti cc bn ghi c Lp ging nhau th Excel s sp xp cc bn ghi theo ct im trung bnh vi hng tng dn.

C s d liu trong Excelc)Lc d liuc1) Cc yu t c bn lc d liu trn bng tnh thc hin lc d liu phi xc nh cc yu t c bn trn bng tnh:1.Vng d liu: Cha ton b d liu cn x l k c dng tiu .2.Vng tiu chun: Cha cc tiu chun (l cc iu kin m cc bn ghi phi tho mn).Vng tiu chun gm ti thiu 2 hng. Hng u cha tiu ca vng tiu chun. Cc tiu ca tiu chun hoc l tn trng hoc l tn bt k ph thuc vo phng php thit lp tiu chun l gin tip hay trc tip. Cc hng th 2 tr i l tiu chun ca CSDL.

C s d liu trong Excel Vng tiu chun so snh trc tip: Cho php a vo cc tiu chun so snh s liu trong mt trng ca CSDL vi mt d liu no . c to theo nguyn tc nh sau:- Phi c t nht 2 hng, hng u ghi tn trng ca CSDL cn lm iu kin lc, nn sao chp tn trng t vng CSDL.- Hng th hai tr i ghi cc tiu chun so snh (iu kin lc). Cch xy dng cc tiu chun l g gi tr cn so snh, trc cc gi tr c th thm cc ton t so snh nh >, >=,

C s d liu trong ExcelV d:

Lc ra nhng ngi c H v tn l "Nguyn Thanh Lm". Lc ra nhng ngi c H v tn bt u bng ch V v im trung bnh >8Lc ra nhng ngi c im trung bnh =7.5 hoc hc lp CNTT1

H v tnNguyn Thanh Lm

im trung bnhH v tn>8 V*

im trung bnhLp7.5CNTT1

C s d liu trong Excel Vng tiu chun so snh gin tip: Cho php a vo cc tiu chun so snh s liu hoc mt phn s liu trong mt trng ca CSDL vi mt gi tr c th. c to theo nguyn tc nh sau:Vng ny phi c t nht 2 hng, trong hng u ghi tiu ca cc tiu chun. Tiu ny c th t tn bt k nhng khng nn trng vi cc tn trng tn ti trong CSDL. Cc tiu chun tm kim c ghi vo hng th 2 tr i.Nguyn tc xy dng tiu chun so snh gin tip l: dng cng thc xc nh thnh phn cn so snh ca bn ghi u tin, sau thm vo cc ton t so snh v gi tr so snh. Kt qu l va nhp s xut hin TRUE hoc FALSE tu theo gi tr ca bn ghi u tin.

C s d liu trong ExcelV d:

STTH tnNgy sinhTonLHo1Nguyn Thnh Nhn11/10/19837682Trn Hoi21/11/198110793Hunh Th Thanh21/03/1983896

C s d liu trong Excelc2) Lc t ng- a chut tr n mt bt k trong vng CSDL hoc nh du vng CSDL d liu nh lc.- Thc hin lnh [Menu] Data/Filter/Auto Filter, Excel s t ng chn nhng nt mi tn vo bn phi ca cc tn trng trong CSDL.

C s d liu trong Excelc3) Lc nng caoLc nng cao l phng php dng lc ra cc bn ghi vi cc iu kin lc phc tp hn. s dng lc nng cao bt buc phi dng vng tiu chun lc d liu.Cc bc tin hnh :- To vng tiu chun.- nh du vng CSDL (Chn khi cha CSDL)- Thc hin lnh [Menu] Data/Advanced Filter.

Lc nng caoc3) Lc nng caoMc Action bao gm :Filter the list, in-place: Click chn nu mun kt qu lc danh sch hin th ti chnh v tr ca CSDL.Copy to another location: Click chn nu mun kt qu lc hin th vng khc ca bng tnh.List range: a ch vng cha CSDL.Criteria Range: a ch vng tiu chun.Copy to: a ch vng cha bng d liu kt qu lc.Ta c th t g a ch vo cc mc trn hoc a chut tr vo cn ly a ch ri dng chut ko r vng a ch cn in ngoi bng tnh.Unique Records Only: Click chn nu mun ch hin mt bn ghi trong s cc bn ghi trng nhau. - Nhn chut vo nt , Excel thc hin lc v hin th kt qu ti a ch c ch ra.

Lc nng caoV d:

Cc hm trong c s d liu Excela) DSUMb) DAVERAGEc) DCOUNTd) DMAXe) DMIN