Tài liệu dạy học môn Tin học trong chương trình đào tạo trình độ cao đẳng_1364841

["\uf0b7 \u0110\u0103ng nh\u1eadp th\u00e0nh c\u00f4ng, ch\u1ecdn v\u00e0o OneDrive \u2013 Personal, ch\u1ecdn th\u01b0 m\u1ee5c OneDrive \u2013 Personal. H\u00ecnh 3.166. \u0110\u0103ng nh\u1eadp v\u00e0o OneDrive \uf0b7 Xu\u1ea5t hi\u1ec7n h\u1ed9p tho\u1ea1i Save As, ch\u1ecdn th\u01b0 m\u1ee5c l\u01b0u tr\u1eef (Documents), nh\u1eadp v\u00e0o t\u00ean file (File Name), ch\u1ecdn Save. H\u00ecnh 3.167. H\u1ed9p tho\u1ea1i l\u01b0u tr\u1eef file l\u00ean OneDrive 3.2.6. So\u1ea1n th\u00f4ng b\u00e1o, th\u01b0 m\u1eddi Khi ng\u01b0\u1eddi d\u00f9ng mu\u1ed1n g\u1eedi th\u01b0 tri \u00e2n kh\u00e1ch h\u00e0ng, hay mu\u1ed1n so\u1ea1n th\u01b0 m\u1eddi d\u1ef1 h\u1ed9i th\u1ea3o\u2026Thay v\u00ec ph\u1ea3i in ra nhi\u1ec1u th\u01b0 (\u0111\u1ec3 tr\u1ed1ng nh\u1eefng n\u1ed9i dung nh\u01b0 H\u1ecd t\u00ean, c\u00f4ng ty, \u0111\u1ecba ch\u1ec9\u2026) v\u00e0 s\u1ebd vi\u1ebft tay v\u00e0o nh\u1eefng th\u00f4ng tin \u0111\u00f3. Vi\u1ec7c \u0111\u00f3 s\u1ebd ti\u00eau t\u1ed1n r\u1ea5t nhi\u1ec1u th\u1eddi gian v\u00e0 c\u00f4ng s\u1ee9c. S\u1eed d\u1ee5ng c\u00f4ng c\u1ee5 Mail Merge \u0111\u1ec3 t\u1ea1o th\u01b0 h\u00e0ng lo\u1ea1t c\u00f3 n\u1ed9i dung gi\u1ed1ng nhau, nh\u01b0ng kh\u00e1c nhau m\u1ed9t s\u1ed1 th\u00f4ng tin, ng\u01b0\u1eddi d\u00f9ng c\u00f3 th\u1ec3 t\u1ea1o ra h\u00e0ng ng\u00e0n b\u1ee9c th\u01b0, b\u1ea5m in v\u00e0 g\u1eedi ch\u00fang \u0111i. C\u00e1c b\u01b0\u1edbc th\u1ef1c hi\u1ec7n nh\u01b0 sau: 142","B\u01b0\u1edbc 1: T\u1ea1o 1 danh s\u00e1ch kh\u00e1ch m\u1eddi tr\u00ean Microsoft Excel c\u00f3 t\u00ean \u201cdanhsach.xlsx\u201d STT H\u1ecd t\u00ean Ch\u1ee9c v\u1ee5 \u0110\u01a1n v\u1ecb 1 Nguy\u1ec5n V\u0103n A Gi\u00e1m \u0111\u1ed1c C\u00f4ng ty TNHH A 2 Tr\u1ea7n Th\u1ecb B Gi\u00e1m \u0111\u1ed1c C\u00f4ng ty C\u1ed5 ph\u1ea7n B 3 Phan V\u0103n C Gi\u00e1m \u0111\u1ed1c C\u00f4ng ty C 4 L\u00fd Th\u1ecb D Gi\u00e1m \u0111\u1ed1c C\u00f4ng ty D 5 L\u00ea V\u0103n E Tr\u01b0\u1edfng Ph\u00f2ng C\u00f4ng ty C\u1ed5 ph\u1ea7n E 6 V\u00f5 V\u0103n F Gi\u00e1m \u0111\u1ed1c C\u00f4ng ty TNHH F B\u1ea3ng 3.1. Danh s\u00e1ch kh\u00e1ch m\u1eddi B\u01b0\u1edbc 2: So\u1ea1n file th\u01b0 m\u1eddi \u201cThu moi.docx\u201d. - M\u1edf file th\u01b0 m\u1eddi H\u00ecnh 3.169. M\u1eabu th\u01b0 m\u1eddi 143","- Ch\u1ecdn tab Mailings \uf0ae nh\u00f3m Start Mail Merge \uf0ae ch\u1ecdn bi\u1ec3u t\u01b0\u1ee3ng Select Recipients \uf0ae ch\u1ecdn Use an Existing List\u2026 - Xu\u1ea5t hi\u1ec7n h\u1ed9p tho\u1ea1i Select Data Source, ch\u1ecdn \u0111\u01b0\u1eddng d\u1eabn ch\u1ee9a file danhsach.xlsx (file \u0111\u00e3 t\u1ea1o \u1edf B\u01b0\u1edbc 1). Ch\u1ecdn file danhsach.xlsx, Nh\u1ea5p chu\u1ed9t v\u00e0o n\u00fat Open. H\u00ecnh 3.170. Ch\u1ecdn \u0111\u01b0\u1eddng d\u1eabn ch\u1ee9a file danh s\u00e1ch - Ch\u1ecdn sheet ch\u1ee9a th\u00f4ng tin c\u1ea7n ch\u00e8n v\u00e0o th\u01b0 m\u1eddi. Ch\u1ecdn OK. H\u00ecnh 3.171. Ch\u1ecdn Sheet ch\u1ee9a th\u00f4ng tin c\u1ea7n ch\u00e8n v\u00e0o th\u01b0 m\u1eddi 144","- \u0110\u1eb7t con tr\u1ecf t\u1ea1i v\u1ecb tr\u00ed c\u1ea7n ch\u00e8n c\u00e1c th\u00f4ng tin t\u1eeb file danh s\u00e1ch.xlsx. H\u00ecnh 3.172. Ch\u1ecdn v\u1ecb tr\u00ed c\u1ea7n ch\u00e8n - Ch\u1ecdn tab Mailings \uf0ae ch\u1ecdn bi\u1ec3u t\u01b0\u1ee3ng Insert Merge Field, s\u1ebd xu\u1ea5t hi\u1ec7n t\u1ea5t c\u1ea3 c\u00e1c t\u00ean c\u1ed9t n\u1eb1m trong file danhsach.xlsx. L\u1ea7n l\u01b0\u1ee3t ch\u1ecdn t\u1eebng v\u1ecb tr\u00ed c\u1ea7n ch\u00e8n, ch\u1ecdn fields c\u1ea7n ch\u00e8n trong h\u1ed9p tho\u1ea1i, nh\u1ea5n Insert H\u00ecnh 3.173. H\u1ed9p tho\u1ea1i Insert Merge Field 145","- Sau khi ch\u00e8n xong c\u00e1c field, file thu moi.docx c\u00f3 d\u1ea1ng nh\u01b0 sau. H\u00ecnh 3.174. \u0110\u00e3 ch\u00e8n \u0111\u1ea7y \u0111\u1ee7 th\u00f4ng tin c\u1ea7n v\u00e0o th\u01b0 m\u1eddi - Sau \u0111\u00f3 Nh\u1ea5p chu\u1ed9t bi\u1ec3u t\u01b0\u1ee3ng Finish & Merge \uf0ae ch\u1ecdn bi\u1ec3u t\u01b0\u1ee3ng \u0111\u1ec3 th\u1ef1c hi\u1ec7n vi\u1ec7c tr\u1ed9n th\u01b0 v\u00e0 xem k\u1ebft qu\u1ea3. 146","3.2.7. So\u1ea1n v\u00e0 x\u1eed l\u00fd v\u0103n b\u1ea3n h\u00e0nh ch\u00ednh m\u1eabu Sau \u0111\u00e2y l\u00e0 h\u01b0\u1edbng d\u1eabn th\u1ef1c hi\u1ec7n c\u00e1ch th\u1ee9c so\u1ea1n th\u1ea3o v\u00e0 \u0111\u1ecbnh d\u1ea1ng m\u1ed9t v\u0103n b\u1ea3n h\u00e0nh ch\u00ednh theo m\u1eabu So\u1ea1n v\u0103n b\u1ea3n sau: V\u0102N PH\u00d2NG CH\u00cdNH PH\u1ee6 C\u1ed8NG H\u00d2A X\u00c3 H\u1ed8I CH\u1ee6 NGH\u0128A VI\u1ec6T NAM \u0110\u1ed9c l\u1eadp \u2013 T\u1ef1 do \u2013 H\u1ea1nh ph\u00fac S\u1ed1: 9034\/VPCP-KGVX V\/v v\u01b0\u1edbng m\u1eafc trong th\u1ef1c hi\u1ec7n ch\u00ednh s\u00e1ch mi\u1ec5n h\u1ecdc ph\u00ed theo quy \u0111\u1ecbnh c\u1ee7a Lu\u1eadt gi\u00e1o d\u1ee5c ngh\u1ec1 nghi\u1ec7p. H\u00e0 N\u1ed9i, ng\u00e0y 20 th\u00e1ng 09 n\u0103m 2018 K\u00ednh g\u1eedi: B\u1ed9 T\u00e0i Ch\u00ednh; B\u1ed9 Lao \u0111\u1ed9ng \u2013 Th\u01b0\u01a1ng binh v\u00e0 X\u00e3 h\u1ed9i. X\u00e9t b\u00e1o c\u00e1o c\u1ee7a B\u1ed9 T\u00e0i ch\u00ednh t\u1ea1i v\u0103n b\u1ea3n s\u1ed1 10292\/BCT-HCSN ng\u00e0y 23 th\u00e1ng 8 n\u0103m 2018 v\u1ec1 v\u01b0\u1edbng m\u1eafc trong th\u1ef1c hi\u1ec7n ch\u00ednh s\u00e1ch mi\u1ec5n h\u1ecdc ph\u00ed theo quy \u0111\u1ecbnh c\u1ee7a Lu\u1eadt gi\u00e1o d\u1ee5c ngh\u1ec1 nghi\u1ec7p v\u00e0 \u0111\u1ec1 xu\u1ea5t, ki\u1ebfn ngh\u1ecb, Ph\u00f3 Th\u1ee7 t\u01b0\u1edbng V\u00f5 \u0110\u1ee9c \u0110am c\u00f3 \u00fd ki\u1ebfn sau: Giao B\u1ed9 Lao \u0111\u1ed9ng \u2013 Th\u01b0\u01a1ng binh v\u00e0 X\u00e3 h\u1ed9i theo th\u1ea9m quy\u1ec1n ch\u1ee7 tr\u00ec, ph\u1ed1i h\u1ee3p v\u1edbi c\u00e1c B\u1ed9, ng\u00e0nh li\u00ean quan h\u01b0\u1edbng d\u1eabn chi ti\u1ebft vi\u1ec7c t\u1ed5 ch\u1ee9c th\u1ef1c hi\u1ec7n kho\u1ea3n 13 \u0111i\u1ec1u 7 c\u1ee7a Ngh\u1ecb quy\u1ebft s\u1ed1 86\/2015\/N\u0110-CP ng\u00e0y 02 th\u00e1ng 10 n\u0103m 2015 c\u1ee7a Ch\u00ednh ph\u1ee7 quy \u0111\u1ecbnh v\u1ec1 c\u01a1 ch\u1ebf thu, qu\u1ea3n l\u00fd h\u1ecdc ph\u00ed \u0111\u1ed1i v\u1edbi c\u01a1 s\u1edf gi\u00e1o d\u1ee5c thu\u1ed9c h\u1ec7 th\u1ed1ng gi\u00e1o d\u1ee5c qu\u1ed1c d\u00e2n v\u00e0 ch\u00ednh s\u00e1ch mi\u1ec5n, gi\u1ea3m h\u1ecdc ph\u00ed, h\u1ed7 tr\u1ee3 chi ph\u00ed h\u1ecdc t\u1eadp t\u1eeb n\u0103m h\u1ecdc 2015 \u2013 2016 \u0111\u1ebfn n\u0103m h\u1ecdc 2020 \u2013 2021. V\u0103n ph\u00f2ng Ch\u00ednh ph\u1ee7 th\u00f4ng b\u00e1o \u0111\u1ec3 B\u1ed9 Lao \u0111\u1ed9ng \u2013 Th\u01b0\u01a1ng binh v\u00e0 X\u00e3 h\u1ed9i, B\u1ed9 T\u00e0i ch\u00ednh v\u00e0 c\u00e1c B\u1ed9, c\u01a1 quan li\u00ean ng\u00e0nh bi\u1ebft, th\u1ef1c hi\u1ec7n.\/. N\u01a1i nh\u1eadn: Nh\u01b0 tr\u00ean; Th\u1ee7 t\u01b0\u1edbng Ch\u00ednh ph\u1ee7 (\u0111\u1ec3 b\/c); C\u00e1c Ph\u00f3 Th\u1ee7 t\u01b0\u1edbng: V\u01b0\u01a1ng \u0110\u00ecnh Hu\u1ec7, V\u0169 \u0110\u1ee9c \u0110am (\u0111\u1ec3 b\/c); C\u00e1c B\u1ed9: GD\u0110T, TP; VPCP: BTCN, c\u00e1c PCN: Nguy\u1ec5n V\u0103n T\u00f9ng, Nguy\u1ec5n S\u1ef9 Hi\u1ec7p, Tr\u1ee3 l\u00fd TTg, TG\u0110 C\u1ed5ng TT\u0110T, c\u00e1c V\u1ee5: KTTH, QH\u0110P; L\u01b0u: VT, KGVX (2).S\u01a1n 11 KT, B\u1ed8 TR\u01af\u1edeNG, CH\u1ee6 NHI\u1ec6M PH\u00d3 CH\u1ee6 NHI\u1ec6M (\u0110\u00e3 k\u00fd) Nguy\u1ec5n V\u0103n T\u00f9ng V\u0103n b\u1ea3n th\u00f4 tr\u00edch theo ngu\u1ed3n v\u0103n b\u1ea3n: http:\/\/vanban.chinhphu.vn\/portal\/page\/portal\/chinhphu\/hethongvanban?class_id=2&_page= 1&mode=detail&document_id=194831) 147","- Th\u1ef1c hi\u1ec7n \u0111\u1ecbnh d\u1ea1ng v\u0103n b\u1ea3n theo m\u1eabu sau: V\u0103n b\u1ea3n theo m\u1eabu: http:\/\/vanban.chinhphu.vn\/portal\/page\/portal\/chinhphu\/hethongvanban?class_id=2&_page= 1&mode=detail&document_id=194831) - \u0110\u1ec3 th\u1ef1c hi\u1ec7n \u0111\u1ecbnh d\u1ea1ng, ch\u00fang ta c\u00f3 th\u1ec3 chia l\u00e0m 4 ph\u1ea7n nh\u01b0 sau 148","1 2 3 4 H\u00ecnh 3.175. Ph\u00e2n chia l\u00e0m 4 ph\u1ea7n B\u01b0\u1edbc 1: Thi\u1ebft l\u1eadp trang. - Thay \u0111\u1ed5i \u0111\u01a1n v\u1ecb s\u1eed d\u1ee5ng tr\u00ean v\u0103n b\u1ea3n: \u0110\u01a1n v\u1ecb m\u1eb7c \u0111\u1ecbnh trong Microsoft Word 2019 l\u00e0 inches. Tuy nhi\u00ean t\u00e0i li\u1ec7u n\u00e0y s\u1eed d\u1ee5ng \u0111\u01a1n v\u1ecb l\u00e0 cm \u0111\u1ec3 thi\u1ebft l\u1eadp cho c\u00e1c l\u1ec1 c\u1ee7a v\u0103n b\u1ea3n. V\u00ec v\u1eady, ch\u00fang ta c\u1ea7n thay \u0111\u1ed5i \u0111\u01a1n v\u1ecb t\u1eeb inches sang cm, th\u1ef1c hi\u1ec7n nh\u01b0 sau: \uf0b7 Ch\u1ecdn tab File \u2192 ch\u1ecdn Options, xu\u1ea5t hi\u1ec7n h\u1ed9p tho\u1ea1i Word Options, ch\u1ecdn Advanced, t\u00ecm \u0111\u1ebfn m\u1ee5c \u201cShow measurements in units of\u201d, ch\u1ecdn \u0111\u01a1n v\u1ecb l\u00e0 cm. 149","H\u00ecnh 3.176. Thay \u0111\u1ed5i \u0111\u01a1n v\u1ecb t\u1eeb Inches sang Centimeters - Ch\u1ecdn kh\u1ed5 gi\u1ea5y: A4 \uf0b7 Tab Layout \u2192 nh\u00f3m Page Setup, ch\u1ecdn v\u00e0o bi\u1ec3u t\u01b0\u1ee3ng m\u1edf r\u1ed9ng tab Page Setup (h\u00ecnh m\u0169i t\u00ean \u1edf g\u00f3c d\u01b0\u1edbi b\u00ean ph\u1ea3i) H\u00ecnh 3.177. M\u1edf r\u1ed9ng t\u00ednh n\u0103ng Page Setup \uf0b7 Xu\u1ea5t hi\u1ec7n h\u1ed9p tho\u1ea1i, ch\u1ecdn Paper \u2192 Paper size: A4 150","H\u00ecnh 3.178. Thi\u1ebft l\u1eadp kh\u1ed5 gi\u1ea5y A4 - L\u1ec1 v\u0103n b\u1ea3n: \uf0b7 C\u00e1ch 1: Top (tr\u00ean): 2 - 2.5cm, Bottom (d\u01b0\u1edbi): 2 - 2.5cm, Left (tr\u00e1i): 3 - 3.5cm, Right (ph\u1ea3i): 1.5 - 2cm \uf0b7 C\u00e1ch 2: Top (tr\u00ean): 2cm, Bottom (d\u01b0\u1edbi): 2cm, Left (tr\u00e1i): 3cm, Right (ph\u1ea3i): 2cm (v\u0103n b\u1ea3n in) \uf0b7 C\u00e1ch 3: Top (tr\u00ean): 2cm, Bottom (d\u01b0\u1edbi): 2cm, Left (tr\u00e1i): 3.5cm, Right (ph\u1ea3i): 1.5cm (\u0111\u00f3ng g\u00e1y l\u00f2 xo\/ \u0111\u00f3ng cu\u1ed1n) 151","H\u00ecnh 3.179. Thi\u1ebft l\u1eadp l\u1ec1 gi\u1ea5y B\u01b0\u1edbc 2: \u0110\u1ecbnh d\u1ea1ng ph\u1ea7n (1) - M\u1edf v\u0103n b\u1ea3n c\u1ea7n \u0111\u1ecbnh d\u1ea1ng, thi\u1ebft l\u1eadp font ch\u1eef cho to\u00e0n b\u1ed9 v\u0103n b\u1ea3n l\u00e0 Times New Roman. - C\u00f3 nhi\u1ec1u c\u00e1ch \u0111\u1ec3 th\u1ef1c hi\u1ec7n nh\u01b0 s\u1eed d\u1ee5ng Tab, s\u1eed d\u1ee5ng Table. \u1ede \u0111\u00e2y, ch\u00fang ta s\u1ebd ch\u1ecdn c\u00e1ch s\u1eed d\u1ee5ng Table \u0111\u1ec3 th\u1ef1c hi\u1ec7n - Ch\u00e8n Table (b\u1ea3ng), \u0111\u1eb7t con tr\u1ecf chu\u1ed9t t\u1ea1i \u0111i\u1ec3m c\u1ea7n ch\u00e8n b\u1ea3ng 152","H\u00ecnh 3.180. \u0110\u1eb7t con tr\u1ecf chu\u1ed9t t\u1ea1i v\u1ecb tr\u00ed c\u1ea7n ch\u00e8n b\u1ea3ng \uf0b7 Ch\u1ecdn tab Insert \u2192 nh\u00f3m Tables \u2192 ch\u1ecdn Table \u2192 ch\u1ecdn Insert Table, xu\u1ea5t hi\u1ec7n h\u1ed9p tho\u1ea1i, nh\u1eadp v\u00e0o \u00f4 gi\u00e1 tr\u1ecb Number of columns: 2, Number of rows: 2 H\u00ecnh 3.181. Ch\u00e8n b\u1ea3ng (Table) \uf0b7 Xu\u1ea5t hi\u1ec7n b\u1ea3ng sau khi ch\u00e8n 153","H\u00ecnh 3.182. Ch\u00e8n b\u1ea3ng 2 c\u1ed9t 2 d\u00f2ng \uf0b7 Ti\u1ebfp theo, di chuy\u1ec3n c\u00e1c n\u1ed9i dung \u0111\u00e3 c\u00f3 b\u00ean d\u01b0\u1edbi v\u00e0o b\u00ean trong b\u1ea3ng. Di chuy\u1ec3n b\u1eb1ng c\u00e1ch, t\u00f4 \u0111en n\u1ed9i dung c\u1ea7n di chuy\u1ec3n, di chuy\u1ec3n chu\u1ed9t v\u00e0o v\u00f9ng \u0111\u00e3 t\u00f4 \u0111en, nh\u1ea5n gi\u1eef chu\u1ed9t tr\u00e1i v\u00e0 di chuy\u1ec3n v\u00e0o v\u1ecb tr\u00ed \u0111\u00edch. H\u00ecnh 3.183. \u0110\u01b0a n\u1ed9i dung ph\u1ea7n 1 v\u00e0o b\u1ea3ng \uf0b7 Tr\u00ecnh b\u00e0y, \u0111\u1ecbnh d\u1ea1ng c\u1ed9t 1, 2 nh\u01b0 h\u00ecnh b\u00ean d\u01b0\u1edbi, canh gi\u1eefa (center) c\u1ed9t 1, 2 Fo\uf0a7nt size: 12 Font size: 12, Bold Font size: 12, Bold Font size: 13, Bold Font size: 13, Italic Font size: 13 Font size: 13, Italic Ch\u1ecdn th\u1ebb Insert \u2192 nh\u00f3m Illustrations \u2192 ch\u1ecdn Shapes \u2192 ch\u1ecdn Line (gi\u1eef shift v\u1ebd \u0111\u1ec3 t\u1ea1o \u0111\u01b0\u1eddng th\u1eb3ng) 154","H\u00ecnh 3.184. H\u01b0\u1edbng d\u1eabn \u0111\u1ecbnh d\u1ea1ng ph\u1ea7n 1 \uf0b7 Ch\u1ecdn v\u00e0o bi\u1ec3u t\u01b0\u1ee3ng ch\u1ecdn to\u00e0n b\u1ed9 b\u1ea3ng H\u00ecnh 3.185. Ch\u1ecdn b\u1ea3ng \uf0b7 C\u00e1c d\u00f2ng ch\u1eef tr\u00ean \u0111\u01b0\u1ee3c tr\u00ecnh b\u00e0y c\u00e1ch nhau d\u00f2ng \u0111\u01a1n: Ch\u1ecdn tab Home \u2192 nh\u00f3m Paragraph \u2192 ch\u1ecdn bi\u1ec3u t\u01b0\u1ee3ng (Line and Paragraph Spacing), ch\u1ecdn 1.0 H\u00ecnh 3.186. Ch\u1ecdn d\u00f2ng \u0111\u01a1n (Single) \uf0b7 B\u1ecf c\u00e1c \u0111\u01b0\u1eddng vi\u1ec1n c\u1ee7a b\u1ea3ng: Ch\u1ecdn tab Home \u2192 nh\u00f3m Paragraph \u2192 ch\u1ecdn Borders \u2192 No Border H\u00ecnh 3.187. B\u1ecf \u0111\u01b0\u1eddng vi\u1ec1n b\u1ea3ng 155","\uf0b7 K\u1ebft qu\u1ea3 H\u00ecnh 3.188. Ho\u00e0n ch\u1ec9nh \u0111\u1ecbnh d\u1ea1ng ph\u1ea7n 1 B\u01b0\u1edbc 3: \u0110\u1ecbnh d\u1ea1ng ph\u1ea7n (2) - Ch\u00e8n th\u00eam b\u1ea3ng (2 c\u1ed9t x 2 d\u00f2ng), \u0111\u01b0a n\u1ed9i dung v\u00e0o b\u1ea3ng H\u00ecnh 3.189. \u0110\u01b0a n\u1ed9i dung ph\u1ea7n 2 v\u00e0o b\u1ea3ng - Canh ph\u1ea3i K\u00ednh g\u1eedi, th\u00eam v\u00e0 canh ph\u1ea7n 2 v\u00e0o b\u1ea3ng orders \u2192 No Border\u01a1n: Ch\u1ecdn Di chuy\u1ec3n b\u1eb1ng c\u00e1ch, t\u00f4 \u0111en n\u1ed9i dung c\u1ea7n di chuy\u1ec3n, di chuy\u1ec3n H\u00ecnh 3.190. H\u01b0\u1edbng d\u1eabn \u0111\u1ecbnh d\u1ea1ng ph\u1ea7n 2 - B\u1ecf c\u00e1c \u0111\u01b0\u1eddng vi\u1ec1n c\u1ee7a b\u1ea3ng. H\u00ecnh 3.191. Ho\u00e0n chng vi\u1ec1n c\u1ee7a b\u1ea3ng. 2ng B\u01b0\u1edbc 4: \u0110\u1ecbnh d\u1ea1ng ph\u1ea7n (3) 1 - T\u00f4 ch\u1ecdn n\u1ed9i dung c\u1ea7n \u0111\u1ecbnh d\u1ea1ng 1 [1] Ph\u1ea7n n\u1ed9i dung (b\u1ea3n v\u0103n) \u0111\u01b0\u1ee3c tr\u00ecnh b\u00e0y b\u1eb1ng ch\u1eef in th\u01b0\u1eddng (\u0111\u01b0\u1ee3c d\u00e0n \u0111\u1ec1u c\u1ea3 hai l\u1ec1), ki\u1ec3u ch\u1eef \u0111\u1ee9ng; c\u1ee1 ch\u1eef t\u1eeb 13 \u0111\u1ebfn 14 (ph\u1ea7n l\u1eddi v\u0103n trong m\u1ed9t v\u0103n b\u1ea3n ph\u1ea3i d\u00f9ng c\u00f9ng m\u1ed9t c\u1ee1 ch\u1eef); khi xu\u1ed1ng d\u00f2ng, ch\u1eef \u0111\u1ea7u d\u00f2ng ph\u1ea3i ph\u1ea3i l\u00f9i v\u00e0o t\u1eeb 1cm \u0111\u1ebfn 1,27cm (1 default tab); kho\u1ea3ng c\u00e1ch gi\u1eefa c\u00e1c \u0111o\u1ea1n v\u0103n (paragraph) \u0111\u1eb7t t\u1ed1i thi\u1ec3u l\u00e0 6pt; kho\u1ea3ng c\u00e1ch gi\u1eefa c\u00e1c d\u00f2ng hay c\u00e1ch d\u00f2ng (line spacing) ch\u1ecdn t\u1ed1i thi\u1ec3u t\u1eeb c\u00e1ch d\u00f2ng \u0111\u01a1n (single line spacing) ho\u1eb7c t\u1eeb 15pt (exactly line spacing) tr\u1edf l\u00ean; kho\u1ea3ng c\u00e1ch t\u1ed1i \u0111a gi\u1eefa c\u00e1c d\u00f2ng l\u00e0 1,5 d\u00f2ng (1,5 lines). 156","H\u00ecnh 3.192. Ch\u1ecdn v\u00f9ng v\u0103n b\u1ea3n ph\u1ea7n (3) - Ch\u1ecdn tab Home \u2192 nh\u00f3m Paragraph \u2192 ch\u1ecdn bi\u1ec3u t\u01b0\u1ee3ng m\u1edf r\u1ed9ng Paragraph \u2192 Special: First line (by: 1cm); Spacing \u2192 Before: 6pt. H\u00ecnh 3.193. Ch\u1ecdn Paragraph \u2192 ch\u1ecdn bi\u1ec3u t\u01b0\u1ee3ng m\u1edf r\u1ed9ng - Ch\u1ecdn Justify (canh \u0111\u1ec1u) 157","H\u00ecnh 3.194. Canh \u0111\u1ec1u v\u0103n b\u1ea3n B\u01b0\u1edbc 5: \u0110\u1ecbnh d\u1ea1ng ph\u1ea7n (4) - Ch\u00e8n Table (b\u1ea3ng), \u0111\u1eb7t con tr\u1ecf chu\u1ed9t t\u1ea1i \u0111i\u1ec3m c\u1ea7n ch\u00e8n b\u1ea3ng H\u00ecnh 3.195. \u0110\u1eb7t con tr\u1ecf t\u1ea1i v\u1ecb tr\u00ed c\u1ea7n ch\u00e8n b\u1ea3ng - Ch\u00e8n th\u00eam b\u1ea3ng (2 c\u1ed9t x 1 d\u00f2ng), \u0111\u01b0a n\u1ed9i dung v\u00e0o b\u1ea3ng H\u00ecnh 3.196. \u0110\u01b0a n\u1ed9i dung ph\u1ea7n (4) v\u00e0o b\u1ea3ng - Th\u1ef1c hi\u1ec7n c\u1ed9t 1, c\u1ed9t 2, theo h\u01b0\u1edbng d\u1eabn c\u1ee7a ph\u1ee5 l\u1ee5c 4 trong [1] sau \u0111\u00f3 b\u1ecf vi\u1ec1n c\u1ee7a b\u1ea3ng. 158","Bold, Italic, font size: 12 Bold, font size: 13, center Th\u00eam g\u1ea1ch (-) \u0111\u1ea7u t\u1eebng d\u00f2ng, font size: 11 Bold, font size: 13, center H\u00ecnh 3.197. H\u01b0\u1edbng d\u1eabn \u0111\u1ecbnh d\u1ea1ng ph\u1ea7n (4) 159","C\u00c1C \u0110I\u1ec2M CH\u00cdNH - \u0110\u1ecbnh d\u1ea1ng v\u0103n b\u1ea3n: Text, Paragraph, Bullets, Numbering, Tab, Borders and Shading, Style. - Ch\u00e8n c\u00e1c \u0111\u1ed1i t\u01b0\u1ee3ng v\u00e0o v\u0103n b\u1ea3n: Table, Picture, WordArt, Symbol, Shapes. - T\u1ea1o Header & Footer, tham chi\u1ebfu, textbox. - In \u1ea5n v\u00e0 ph\u00e2n ph\u1ed1i v\u0103n b\u1ea3n. - So\u1ea1n th\u00f4ng b\u00e1o v\u00e0 x\u1eed l\u00fd v\u0103n b\u1ea3n h\u00e0nh ch\u00ednh theo m\u1eabu. C\u00c2U H\u1eceI \u00d4N T\u1eacP C\u00e2u 1: Trong Microsoft Word 2019, s\u1eed d\u1ee5ng t\u1ed5 h\u1ee3p ph\u00edm n\u00e0o \u0111\u1ec3 \u0111\u00f3ng m\u1ed9t t\u1eadp tin \u0111ang m\u1edf? A. Ctrl + F4 B. Shift + F4 C. Alt + F4 D. Ctrl + Shift + F4 C\u00e2u 2: Trong Microsoft Word 2019, s\u1eed d\u1ee5ng t\u1ed5 h\u1ee3p ph\u00edm n\u00e0o \u0111\u1ec3 tho\u00e1t kh\u1ecfi ch\u01b0\u01a1ng tr\u00ecnh? A. Ctrl + F4 B. Shift + F4 C. Alt + F4 D. Ctrl + Shift + F4 C\u00e2u 3: T\u1eadp tin n\u00e0o d\u01b0\u1edbi \u0111\u00e2y \u0111\u01b0\u1ee3c t\u1ea1o ra t\u1eeb Microsoft Word 2019? A. Quyetdinh.doc B. Quyetdinh.docx C. Quyetdinh.XLS D. C\u1ea3 A v\u00e0 B \u0111\u1ec1u \u0111\u00fang C\u00e2u 4: Trong Microsoft Word 2019, s\u1eed d\u1ee5ng t\u1ed5 h\u1ee3p ph\u00edm n\u00e0o \u0111\u1ec3 l\u01b0u t\u1eadp tin? A. Ctrl + O B. Ctrl + A 160","C. Shift + S D. Ctrl + S C\u00e2u 5: Trong Microsoft Word 2019, s\u1eed d\u1ee5ng ph\u00edm n\u00e0o \u0111\u1ec3 l\u01b0u t\u1eadp tin v\u1edbi t\u00ean kh\u00e1c? A. F2 B. F5 C. F10 D. F12 C\u00e2u 6: Trong Microsoft Word 2019, s\u1eed d\u1ee5ng t\u1ed5 h\u1ee3p ph\u00edm n\u00e0o \u0111\u1ec3 m\u1edf t\u1eadp tin \u0111\u00e3 c\u00f3 trong m\u00e1y? A. Ctrl + O B. Ctrl + A C. Shift + S D. Ctrl + S C\u00e2u 7: Trong Microsoft Word 2019, s\u1eed d\u1ee5ng t\u1ed5 h\u1ee3p ph\u00edm n\u00e0o \u0111\u1ec3 t\u1ea1o m\u1ed9t t\u1eadp tin m\u1edbi? A. Ctrl + O B. Ctrl + A C. Ctrl + N D. Ctrl + S C\u00e2u 8: Trong Microsoft Word 2019, \u0111\u1ec3 l\u01b0u t\u1eadp tin vanban1.docx \u0111ang m\u1edf th\u00e0nh t\u1eadp tin vanban2.docx, th\u1ef1c hi\u1ec7n nh\u01b0 th\u1ebf n\u00e0o? A. V\u00e0o File\\\\Save B. \u00e0o File \\\\Save As C. Nh\u1ea5p chu\u1ed9t v\u00e0o bi\u1ec3u t\u01b0\u1ee3ng Save (\u0111\u0129a) tr\u00ean thanh Quick Access Toolbar (Thanh truy c\u1eadp nhanh) D. B\u1ea5m t\u1ed5 h\u1ee3p ph\u00edm Ctrl + S C\u00e2u 9: Trong Microsoft Word 2019, \u0111\u1ec3 sao ch\u00e9p \u0111\u1ecbnh d\u1ea1ng v\u0103n b\u1ea3n, th\u1ef1c hi\u1ec7n nh\u01b0 th\u1ebf n\u00e0o? A. B\u1ea5m v\u00e0o bi\u1ec3u t\u01b0\u1ee3ng Copy tr\u00ean thanh c\u00f4ng c\u1ee5 Home B. B\u1ea5m v\u00e0o bi\u1ec3u t\u01b0\u1ee3ng Format Painter tr\u00ean thanh c\u00f4ng c\u1ee5 Home C. V\u00e0o Edit\\\\Copy 161","D. B\u1ea5m t\u1ed5 h\u1ee3p ph\u00edm Ctrl + C C\u00e2u 10: Trong Microsoft Word 2019, s\u1eed d\u1ee5ng t\u1ed5 h\u1ee3p ph\u00edm n\u00e0o \u0111\u1ec3 canh \u0111o\u1ea1n v\u0103n b\u1ea3n v\u00e0o gi\u1eefa d\u00f2ng? A. Ctrl + Shift + L B. Ctrl + R C. Ctrl + Alt + J D. Ctrl + E C\u00e2u 11: Trong Microsoft Word 2019, s\u1eed d\u1ee5ng t\u1ed5 h\u1ee3p ph\u00edm n\u00e0o \u0111\u1ec3 canh \u0111o\u1ea1n v\u0103n b\u1ea3n th\u1eb3ng l\u1ec1 tr\u00e1i? A. Ctrl + L B. Ctrl + R C. Ctrl +Alt + J D. Ctrl + E C\u00e2u 12: Trong Microsoft Word 2019, s\u1eed d\u1ee5ng t\u1ed5 h\u1ee3p ph\u00edm n\u00e0o \u0111\u1ec3 canh \u0111o\u1ea1n v\u0103n b\u1ea3n th\u1eb3ng \u0111\u1ec1u hai b\u00ean l\u1ec1? A. Ctrl + Shift + L B. Ctrl + R C. Ctrl + J D. Ctrl + E C\u00e2u 13: Khi so\u1ea1n th\u1ea3o b\u1eb1ng Microsoft Word 2019, s\u1eed d\u1ee5ng t\u1ed5 h\u1ee3p ph\u00edm n\u00e0o \u0111\u1ec3 canh \u0111o\u1ea1n v\u0103n b\u1ea3n th\u1eb3ng l\u1ec1 ph\u1ea3i? A. Ctrl + Shift + L B. Ctrl + R C. Ctrl +Alt + J D. Ctrl + E C\u00e2u 14: Trong Microsoft Word 2019, s\u1eed d\u1ee5ng t\u1ed5 h\u1ee3p ph\u00edm n\u00e0o \u0111\u1ec3 ch\u00e8n ng\u00e0y th\u00e1ng hi\u1ec7n t\u1ea1i v\u00e0o v\u0103n b\u1ea3n? A. Ctrl + Shift + T B. Alt + Shift + D C. Ctrl + Shift + D D. Ctrl + Alt + N 162","C\u00e2u 15: Trong Microsoft Word 2019, s\u1eed d\u1ee5ng t\u1ed5 h\u1ee3p ph\u00edm n\u00e0o \u0111\u1ec3 ch\u00e8n th\u1eddi gian hi\u1ec7n t\u1ea1i v\u00e0o v\u0103n b\u1ea3n? A. Ctrl + Shift + T B. Alt + Shift + T C. Ctrl + Shift + D D. Ctrl + Alt + G C\u00e2u 16: Trong Microsoft Word 2019, \u0111\u1ec3 ch\u00e8n ti\u00eau \u0111\u1ec1 v\u00e0o \u0111\u1ea7u trang v\u0103n b\u1ea3n, th\u1ef1c hi\u1ec7n nh\u01b0 th\u1ebf n\u00e0o? A. Home\\\\Header B. Insert\\\\Header C. Home\\\\Footer D. Insert\\\\Footer C\u00e2u 17: Trong Microsoft Word 2019, \u0111\u1ec3 ch\u00e8n ti\u00eau \u0111\u1ec1 v\u00e0o cu\u1ed1i trang v\u0103n b\u1ea3n, th\u1ef1c hi\u1ec7n nh\u01b0 th\u1ebf n\u00e0o? A. Home\\\\Header B. Insert\\\\Header C. Home\\\\Footer D. Insert\\\\Footer C\u00e2u 18: Trong Microsoft Word 2019, \u0111\u1ec3 ch\u00e8n m\u1ed9t ch\u00fa th\u00edch v\u00e0o ch\u00e2n trang v\u0103n b\u1ea3n, th\u1ef1c hi\u1ec7n nh\u01b0 th\u1ebf n\u00e0o? A. Home\\\\Insert Footnote B. Insert\\\\Insert Footnote C. Review\\\\Insert Footnote D. References\\\\Insert Footnote C\u00e2u 19: Trong Microsoft Word 2019, \u0111\u1ec3 ch\u00e8n m\u1ed9t b\u1ee9c tranh l\u01b0u tr\u00ean m\u00e1y t\u00ednh v\u00e0o v\u0103n b\u1ea3n, th\u1ef1c hi\u1ec7n nh\u01b0 th\u1ebf n\u00e0o? A. Home\\\\Pictures B. Insert\\\\Pictures C. Review\\\\Pictures D. View\\\\Pictures 163","C\u00e2u 20: Trong Microsoft Word 2019, \u0111\u1ec3 ch\u00e8n m\u1ed9t h\u1ed9p v\u0103n b\u1ea3n, th\u1ef1c hi\u1ec7n nh\u01b0 th\u1ebf n\u00e0o? A. Home\\\\Text Box B. Insert\\\\Text Box C. Review\\\\Text Box D. View\\\\Text Box \u0110\u00e1p \u00e1n: C\u00e2u 1: A C\u00e2u 6: A C\u00e2u 11: A C\u00e2u 16: B C\u00e2u 2: C C\u00e2u 7: C C\u00e2u 12: C C\u00e2u 17: D C\u00e2u 3: D C\u00e2u 8: B C\u00e2u 13: B C\u00e2u 18: D C\u00e2u 4: D C\u00e2u 9: B C\u00e2u 14: B C\u00e2u 19: B C\u00e2u 5: D C\u00e2u 10: D C\u00e2u 15: B C\u00e2u 20: B B\u00c0I T\u1eacP B\u00e0i 1: Nh\u1eadp li\u1ec7u v\u00e0 th\u1ef1c hi\u1ec7n \u0111\u1ecbnh d\u1ea1ng v\u0103n b\u1ea3n \u0110\u1ecaNH D\u1ea0NG V\u0102N B\u1ea2N 164","B\u00e0i 2: S\u1eed d\u1ee5ng Tab, Bullets th\u1ef1c hi\u1ec7n y\u00eau c\u1ea7u (Ngu\u1ed3n: S\u01b0u t\u1ea7m Internet) \uf04a My Love Westlife \uf04a My Heart Will Go on Celine Dion \uf04a Beautiful in White Shane Filan \uf04a Because You Love Me Celine Dion \uf04a As Long As You Love Me Backstreet Boys \uf04a Tonight I Celebrate My Love For You Peabo Bryson & Roberta Flack B\u00e0i 3: S\u1eed d\u1ee5ng Font, Tab, Symbol th\u1ef1c hi\u1ec7n y\u00eau c\u1ea7u Cty TNHH ABC C\u1ed8NG H\u00d2A X\u00c3 H\u1ed8I CH\u1ee6 NGH\u0128A VI\u1ec6T NAM 777 Nguy\u1ec5n Tr\u1ea7n Nguy\u00ean - Q.1 \u0110\u1ed9c l\u1eadp - T\u1ef1 do - H\u1ea1nh ph\u00fac \uf09c\uf0b6\uf09d .................., ng\u00e0y ...... th\u00e1ng ...... n\u0103m 20... TH\u01af M\u1edcI K\u00ednh g\u1eedi: \u00d4ng (B\u00e0): ...................................................................................................... \u0110\u00fang v\u00e0o l\u00fac: \u2026\u2026gi\u1edd \u2026\u2026 ph\u00fat, ng\u00e0y \u2026 th\u00e1ng \u2026 n\u0103m 20\u2026 \u0110\u1ebfn t\u1ea1i .......................................................................................................................... \u0110\u1ec3: ................................................................................................................................ R\u1ea5t mong \u00d4ng (b\u00e0) \u0111\u1ebfn \u0111\u00fang gi\u1edd \u0111\u1ec3 bu\u1ed5i .................................. \u0111\u1ea1t k\u1ebft qu\u1ea3 t\u1ed1t \u0111\u1eb9p.\/. GI\u00c1M \u0110\u1ed0C Ghi ch\u00fa: ................................................... 165","B\u00e0i 4: S\u1eed d\u1ee5ng Borders and Shading, Column th\u1ef1c hi\u1ec7n y\u00eau c\u1ea7u M\u00c1Y BAY H\u1ea0 C\u00c1NH V\u00cc... CHU\u1ed8T \u0110\u00e2y kh\u00f4ng ph\u1ea3i l\u00e0 b\u1ed9 m\u1ed9t con chu\u1ed9t \u0111\u1ed3ng l\u00ean m\u00e1y bay nh\u01b0ng \u0111\u1ec3 l\u1ea1c m\u1ea5t con phim \\\"Snakes on a v\u1eadt g\u1eb7m nh\u1ea5m n\u00e0y. Plane\\\" nh\u01b0ng m\u1ed9t chi\u1ebfc Chuy\u1ebfn bay t\u1eeb Palma de Mallorca, T\u00e2y Ban Nha, \u0111\u1ebfn m\u00e1y bay c\u1ee7a Australian th\u00e0nh ph\u1ed1 Graz, mi\u1ec1n nam n\u01b0\u1edbc \u00c1o, \u0111\u00e3 b\u1ecb gi\u00e1n \u0111o\u1ea1n \u0111\u1ec3 Airlines \u0111\u00e3 ph\u1ea3i h\u1ea1 c\u00e1nh c\u00e1c nh\u00e2n vi\u00ean h\u00e0ng kh\u00f4ng truy l\u00f9ng con chu\u1ed9t v\u00e0 \u0111\u1ea3m ngo\u00e0i d\u1ef1 ki\u1ebfn h\u00f4m th\u1ee9 b\u1ea3o r\u1eb1ng n\u00f3 kh\u00f4ng c\u1eafn \u0111\u1ee9t b\u1ea5t k\u1ef3 \u0111o\u1ea1n d\u00e2y \u0111i\u1ec7n n\u00e0o. s\u00e1u v\u00ec m\u1ed9t con chu\u1ed9t H\u00e0nh kh\u00e1ch \u0111\u00e3 \u0111\u01b0\u1ee3c y\u00eau c\u1ea7u ra kh\u1ecfi m\u00e1y bay v\u00e0 m\u1ed9t s\u1ed1 \u0111\u1ed3ng tr\u00ean khoang. ng\u01b0\u1eddi \u0111i xe bu\u00fdt t\u1edbi Graz. Phi h\u00e0nh \u0111o\u00e0n quy\u1ebft \u0110\u1ebfn bu\u1ed5i chi\u1ec1u c\u00f9ng ng\u00e0y, c\u00e1c nh\u00e2n vi\u00ean h\u00e0ng kh\u00f4ng \u0111\u1ecbnh chuy\u1ec3n h\u01b0\u1edbng v\u00e0 h\u1ea1 xu\u1ed1ng Innsbruck sau v\u1eabn kh\u00f4ng l\u1ea7n ra d\u1ea5u v\u1ebft c\u1ee7a con chu\u1ed9t. Austrian khi m\u1ed9t h\u00e0nh kh\u00e1ch cho bi\u1ebft anh ta mang theo Airlines cho bi\u1ebft chi\u1ebfc m\u00e1y bay s\u1ebd kh\u00f4ng th\u1ec3 c\u1ea5t c\u00e1nh cho \u0111\u1ebfn khi h\u1ecd t\u00ecm ra con chu\u1ed9t \u0111\u00f3 b\u1edfi l\u00fd do an to\u00e0n. (Ngu\u1ed3n: VnExpress) B\u00e0i 5: S\u1eed d\u1ee5ng Tab, Borders and Shading, Column, Drop Cap th\u1ef1c hi\u1ec7n y\u00eau c\u1ea7u T\u00c1C D\u1ee4NG C\u1ee6A M\u1eacT ONG \u0110\u01b0\u1ee3c chi\u1ebft xu\u1ea5t ch\u1ec9 N\u00f3 bao g\u1ed3m nh\u1eefng vitamin kh\u1ecfe m\u1ea1nh nh\u01b0 v\u1edbi nh\u1eefng th\u00e0nh vitamin B v\u00e0 C, kho\u00e1ng ch\u1ea5t v\u00e0 amino acid. ph\u1ea7n t\u1ef1 nhi\u00ean, m\u1eadt ong Nh\u1eefng nguy\u00ean li\u1ec7u n\u00e0y \u0111\u01b0\u1ee3c bi\u1ebft \u0111\u1ebfn do l\u1ee3i \u00edch r\u1ea5t gi\u00e0u c\u00e1c d\u01b0\u1ee1ng ch\u1ea5t trong vi\u1ec7c nu\u00f4i d\u01b0\u1ee1ng l\u00e0n da kh\u1ecfe m\u1ea1nh. Ch\u1ea5t ch\u1ed1ng \u0111\u1eb7c bi\u1ec7t t\u1ed1t cho da c\u0169ng oxi ho\u00e1 t\u00ecm th\u1ea5y trong m\u1eadt ong th\u00ec c\u00f3 th\u1ec3 t\u1ed1t cho da v\u00e0 nh\u01b0 s\u1ee9c kh\u1ecfe. l\u00e0m suy gi\u1ea3m \u1ea3nh h\u01b0\u1edfng l\u00e3o ho\u00e1 l\u00ean da. (Ngu\u1ed3n: dep.com.vn) B\u00e0i 6: S\u1eed d\u1ee5ng Borders and Shading, Table, Symbol th\u1ef1c hi\u1ec7n y\u00eau c\u1ea7u PC WORD VI\u1ec6T PHI\u1ebeU \u0110\u1eb6T T\u1ea0P CH\u00cd N\u0102M 2016 NAM \uf040 H\u1ecd v\u00e0 t\u00ean: ........................................................................................... \uf040 \u0110\u1ecba ch\u1ec9 nh\u1eadn t\u1ea1p ch\u00ed: ................................................................ H\u00c3Y \u0110\u00c1NH D\u1ea4U V\u00c0O TH\u00c1NG MU\u1ed0N \u0110\u1eb6T 1 2 3 4 5 6 7 8 9 10 11 12 \uf071\uf071\uf071\uf071\uf071\uf071\uf071\uf071\uf071\uf071\uf071\uf071 166","B\u00e0i 7: S\u1eed d\u1ee5ng tham chi\u1ebfu (Reference) th\u1ef1c hi\u1ec7n y\u00eau c\u1ea7u T\u00c1C H\u1ea0I C\u1ee6A BIA R\u01af\u1ee2U V\u1edaI S\u1ee8C KH\u1eceE Th\u1ee9c u\u1ed1ng ch\u1ee9a c\u1ed3n r\u1ea5t \u0111\u1ed9c h\u1ea1i cho c\u01a1 th\u1ec3 v\u00ec \u1ea3nh h\u01b0\u1edfng \u0111\u1ebfn th\u1ec3 l\u1ef1c, t\u01b0 duy, tr\u00ed tu\u1ec7, kh\u1ea3 n\u0103ng lao \u0111\u1ed9ng. Hi\u1ec7n nay c\u0169ng c\u00f3 m\u1ed9t s\u1ed1 \u00fd ki\u1ebfn cho r\u1eb1ng n\u1ebfu u\u1ed1ng bia th\u00ec \u00edt g\u00e2y h\u1ea1i cho s\u1ee9c kh\u1ecfe h\u01a1n so v\u1edbi u\u1ed1ng r\u01b0\u1ee3u. \u0110\u00e2y l\u00e0 quan ni\u1ec7m kh\u00f4ng \u0111\u00fang b\u1edfi v\u00ec t\u00e1c h\u1ea1i ch\u1ee7 y\u1ebfu l\u00e0 do ch\u1ea5t c\u1ed3n[2] trong \u0111\u1ed3 u\u1ed1ng g\u00e2y ra. V\u00ec v\u1eady t\u00e1c h\u1ea1i do r\u01b0\u1ee3u, bia kh\u00f4ng ph\u1ee5 thu\u1ed9c v\u00e0o lo\u1ea1i \u0111\u1ed3 u\u1ed1ng (l\u00e0 bia hay r\u01b0\u1ee3u) m\u00e0 ph\u1ee5 thu\u1ed9c v\u00e0o l\u01b0\u1ee3ng u\u1ed1ng (ti\u00eau th\u1ee5 bao nhi\u00eau gam c\u1ed3n) v\u00e0 c\u00e1ch th\u1ee9c u\u1ed1ng (t\u1ea7n su\u1ea5t s\u1eed d\u1ee5ng). Thi\u1ebfu m\u00e1u: U\u1ed1ng nhi\u1ec1u r\u01b0\u1ee3u c\u00f3 th\u1ec3 l\u00e0m gi\u1ea3m \u0111\u1ed9t ng\u1ed9t s\u1ed1 l\u01b0\u1ee3ng h\u1ed3ng c\u1ea7u[3] trong m\u00e1u gi\u00fap v\u1eadn chuy\u1ec3n oxy \u0111\u1ec3 nu\u00f4i c\u01a1 th\u1ec3, g\u00e2y ra thi\u1ebfu m\u00e1u. Nh\u1eefng ng\u01b0\u1eddi thi\u1ebfu m\u00e1u th\u01b0\u1eddng b\u1ecb c\u00e1c tri\u1ec7u ch\u1ee9ng nh\u01b0 m\u1ec7t m\u1ecfi, kh\u00f3 th\u1edf, ch\u00f3ng m\u1eb7t v\u00e0 k\u00e9m minh m\u1eabn\u2026 Ung th\u01b0: B\u1ec7nh ung th\u01b0 \u1edf ng\u01b0\u1eddi s\u1eed d\u1ee5ng r\u01b0\u1ee3u th\u01b0\u1eddng li\u00ean quan \u0111\u1ebfn mi\u1ec7ng, h\u1ecdng, thanh qu\u1ea3n, th\u1ef1c qu\u1ea3n, gan, v\u00fa v\u00e0 v\u00f9ng tr\u1ef1c tr\u00e0ng. Nguy c\u01a1 ung th\u01b0 c\u00e0ng t\u0103ng \u1edf nh\u1eefng ng\u01b0\u1eddi u\u1ed1ng r\u01b0\u1ee3u k\u00e8m h\u00fat thu\u1ed1c l\u00e1. B\u1ec7nh tim m\u1ea1ch: U\u1ed1ng nhi\u1ec1u r\u01b0\u1ee3u, nh\u1ea5t l\u00e0 nghi\u1ec7n r\u01b0\u1ee3u, s\u1ebd l\u00e0m cho c\u00e1c ti\u1ec3u c\u1ea7u[4] trong m\u00e1u c\u00f3 khuynh h\u01b0\u1edbng t\u1ea1o th\u00e0nh c\u1ee5c m\u00e1u \u0111\u00f4ng, nguy\u00ean nh\u00e2n d\u1eabn \u0111\u1ebfn \u0111au tim ho\u1eb7c \u0111\u1ed9t qu\u1ef5. R\u01b0\u1ee3u c\u0169ng c\u00f3 th\u1ec3 g\u00e2y ra b\u1ec7nh c\u01a1 tim, l\u00e0m cho c\u01a1 tim suy y\u1ebfu, \u0111\u1ed3ng th\u1eddi l\u00e0m lo\u1ea1n nh\u1ecbp tim. X\u01a1 gan: R\u01b0\u1ee3u l\u00e0 ch\u1ea5t \u0111\u1ed9c c\u1ee7a c\u00e1c t\u1ebf b\u00e0o gan, nh\u1eefng ng\u01b0\u1eddi nghi\u1ec7n r\u01b0\u1ee3u l\u00e2u n\u0103m d\u1ec5 b\u1ecb x\u01a1 gan do m\u00f4 gan bi\u1ebfn th\u00e0nh s\u1eb9o v\u00e0 m\u1ea5t ch\u1ee9c n\u0103ng ho\u1ea1t \u0111\u1ed9ng. M\u1ea5t tr\u00ed nh\u1edb: \u1ede ng\u01b0\u1eddi gi\u00e0, b\u1ed9 n\u00e3o teo l\u1ea1i, trung b\u00ecnh 1,9% m\u1ed7i th\u1eadp k\u1ef7. Tuy nhi\u00ean, khi u\u1ed1ng r\u01b0\u1ee3u, t\u1ed1c \u0111\u1ed9 teo l\u1ea1i c\u1ee7a m\u1ed9t s\u1ed1 v\u00f9ng tr\u1ecdng \u0111i\u1ec3m trong n\u00e3o t\u0103ng nhanh h\u01a1n, d\u1eabn \u0111\u1ebfn m\u1ea5t tr\u00ed nh\u1edb v\u00e0 m\u1ed9t s\u1ed1 tri\u1ec7u ch\u1ee9ng kh\u00e1c nh\u01b0 suy gi\u1ea3m kh\u1ea3 n\u0103ng t\u00ednh to\u00e1n, ph\u00e1n x\u00e9t v\u00e0 kh\u1ea3 n\u0103ng gi\u1ea3i quy\u1ebft v\u1ea5n \u0111\u1ec1. Ngo\u00e0i ra, nghi\u1ec7n r\u01b0\u1ee3u bia c\u00f2n g\u00e2y \u1ea3nh h\u01b0\u1edfng r\u1ea5t l\u1edbn \u0111\u1ebfn \u0111\u1eddi s\u1ed1ng v\u00e0 t\u00ecnh h\u00ecnh an ninh tr\u1eadt t\u1ef1 x\u00e3 h\u1ed9i nh\u01b0 b\u1ea1o h\u00e0nh gia \u0111\u00ecnh v\u00e0 g\u00e2y r\u1ed1i tr\u1eadt t\u1ef1 x\u00e3 h\u1ed9i. Tai n\u1ea1n giao th\u00f4ng t\u0103ng v\u1ecdt v\u00e0 th\u01b0\u01a1ng t\u00e2m c\u00f3 li\u00ean quan r\u1ea5t nhi\u1ec1u \u0111\u1ebfn r\u01b0\u1ee3u bia[5]. Nh\u01b0 v\u1eady, ch\u00fang ta \u0111\u00e3 bi\u1ebft t\u00e1c h\u1ea1i c\u1ee7a r\u01b0\u1ee3u bia kh\u00f4ng nh\u1eefng \u1ea3nh h\u01b0\u1edfng \u0111\u1ebfn s\u1ee9c kh\u1ecfe (c\u1ea3 v\u1ec1 th\u1ec3 ch\u1ea5t l\u1eabn tinh th\u1ea7n) m\u00e0 c\u00f2n \u1ea3nh h\u01b0\u1edfng r\u1ea5t nhi\u1ec1u \u0111\u1ebfn \u0111\u1eddi s\u1ed1ng x\u00e3 h\u1ed9i n\u00f3i chung, v\u00ec v\u1eady ch\u00fang ta c\u1ea7n ki\u1ec3m so\u00e1t l\u01b0\u1ee3ng r\u01b0\u1ee3u bia u\u1ed1ng v\u00e0o \u0111\u1ec3 tr\u00e1nh nh\u1eefng sai l\u1ea7m \u0111\u00e1ng ti\u1ebfc cho gia \u0111\u00ecnh v\u00e0 x\u00e3 h\u1ed9i. 2 Hay c\u00f2n g\u1ecdi l\u00e0 ethanol 3 H\u1ed3ng c\u1ea7u l\u00e0 lo\u1ea1i t\u1ebf b\u00e0o m\u00e1u chuy\u00ean ch\u1edf hemoglobin, qua \u0111\u00f3 \u0111\u01b0a O2 t\u1eeb ph\u1ed5i \u0111\u1ebfn c\u00e1c m\u00f4. 4 L\u00e0 m\u1ed9t lo\u1ea1i t\u1ebf b\u00e0o m\u00e1u c\u00f3 ch\u1ee9c n\u0103ng c\u1ea7m m\u00e1u b\u1eb1ng c\u00e1ch l\u00e0m m\u00e1u v\u00f3n c\u1ee5c v\u00e0 \u0111\u00f4ng l\u1ea1i khi m\u1ea1ch m\u00e1u b\u1ecb th\u01b0\u01a1ng. 5 L\u00e0 m\u1ed9t lo\u1ea1i \u0111\u1ed3 u\u1ed1ng ch\u1ee9a c\u1ed3n \u0111\u01b0\u1ee3c s\u1ea3n xu\u1ea5t b\u1eb1ng qu\u00e1 tr\u00ecnh l\u00ean men \u0111\u01b0\u1eddng l\u01a1 l\u1eedng trong m\u00f4i tr\u01b0\u1eddng l\u1ecfng v\u00e0 n\u00f3 kh\u00f4ng \u0111\u01b0\u1ee3c ch\u01b0ng c\u1ea5t sau khi l\u00ean men. 168","(Ngu\u1ed3n: tuoitre.vn) B\u00e0i 8: S\u1eed d\u1ee5ng Shapes, WordArt, Column, Picture th\u1ef1c hi\u1ec7n y\u00eau c\u1ea7u Th\u1eed h\u1ecfi tr\u00ean th\u1ebf gian n\u00e0y ai y\u00eau th\u01b0\u01a1ng th\u01b0\u01a1ng, v\u1eadt ch\u1ea5t khi\u1ebfn cu\u1ed9c s\u1ed1ng ng\u1eadp b\u1ea1n v\u00f4 \u0111i\u1ec1u ki\u1ec7n? tr\u00e0n nh\u1eefng s\u1eafc m\u00e0u t\u01b0\u01a1i \u0111\u1eb9p. Ai nu\u00f4i n\u1ea5ng, ch\u0103m s\u00f3c, d\u1ed7 d\u00e0nh b\u1ea1n m\u00e0 D\u1eabu bi\u1ebft l\u00e0 c\u00f3 con s\u1ebd v\u1ea5t v\u1ea3 h\u01a1n, hy sinh kh\u00f4ng \u0111\u00f2i h\u1ecfi tr\u1ea3 \u01a1n hay tr\u1ea3 c\u00f4ng? nhi\u1ec1u h\u01a1n nh\u01b0ng h\u1ec5 sinh ra m\u1ed9t \u0111\u1ee9a tr\u1ebb N\u1ebfu c\u00f3 ai \u0111\u00f3 l\u00e0m b\u1ea1n t\u1ed5n th\u01b0\u01a1ng, m\u00ecnh l\u1eadp t\u1ee9c t\u00ecnh y\u00eau b\u1ed1 \u0111au m\u1ed9t th\u00ec ai \u0111au m\u01b0\u1eddi? Ch\u1ec9 c\u00f3 th\u1ec3 m\u1eb9 d\u00e0nh cho l\u00e0 b\u1ed1 m\u1eb9 y\u00eau qu\u00fd con b\u1eaft \u0111\u1ea7u c\u1ee7a ch\u00fang ta m\u00e0 h\u00ecnh th\u00e0nh v\u00e0 th\u00f4i. \u0111\u1eadm \u0111\u00e0 theo B\u1edfi v\u00ec con c\u00e1i l\u00e0 k\u1ebft tinh t\u00ecnh y\u00eau c\u1ee7a b\u1ed1 n\u0103m th\u00e1ng. m\u1eb9, l\u00e0 m\u00f3n qu\u00e0 c\u1ee7a M\u1ed7i \u00f4ng b\u1ed1 th\u01b0\u1ee3ng \u0111\u1ebf gi\u00fap ba m\u1eb9 b\u00e0 m\u1eb9 s\u1ebd y\u00eau c\u00f3 \u0111\u1ea7y ni\u1ec1m vui v\u00e0 con m\u00ecnh h\u1ea1nh ph\u00fac v\u00f4 bi\u00ean. L\u00e0 b\u1edfi v\u00ec hai ng\u01b0\u1eddi l\u1edbn s\u1ebd c\u00f3 th\u00eam theo nh\u1eefng nh\u1eefng ng\u01b0\u1eddi b\u1ea1n nh\u1ecf \u0111\u1ec3 chia s\u1ebb t\u00ecnh y\u00eau c\u00e1ch kh\u00e1c nhau v\u00e0 m\u1ed9t v\u00e0i c\u00e1ch trong s\u1ed1 \u0111\u00f3 l\u00e0 nh\u1eefng c\u00e2u chuy\u1ec7n c\u1ea3m \u0111\u1ed9ng nh\u1ea5t\u2026 (Ngu\u1ed3n v\u00e0 \u1ea3nh: S\u01b0u t\u1ea7m t\u1eeb Internet) B\u00e0i 9: S\u1eed d\u1ee5ng Styles th\u1ef1c hi\u1ec7n y\u00eau c\u1ea7u 169","169","B\u00e0i 10: Th\u1ef1c hi\u1ec7n t\u1ea1o trang b\u00eca theo m\u1eabu sau 170","B\u00e0i 10 (tt): Th\u1ef1c hi\u1ec7n t\u1ea1o trang m\u1ee5c l\u1ee5c theo m\u1eabu sau 171","B\u00e0i 10 (tt): Th\u1ef1c hi\u1ec7n t\u1ea1o Header & Footer theo m\u1eabu sau 172","B\u00e0i 10 (tt): Th\u1ef1c hi\u1ec7n t\u1ea1o Header & Footer theo m\u1eabu sau 173","B\u00e0i 10 (tt): Th\u1ef1c hi\u1ec7n t\u1ea1o Header & Footer theo m\u1eabu sau 174","B\u00e0i 10 (tt): Th\u1ef1c hi\u1ec7n t\u1ea1o Header & Footer theo m\u1eabu sau 175","B\u00e0i 11: Th\u1ef1c hi\u1ec7n \u0111\u1ecbnh d\u1ea1ng v\u0103n b\u1ea3n theo m\u1eabu sau 176","B\u00e0i 12: (1) Th\u1ef1c hi\u1ec7n so\u1ea1n th\u1ea3o th\u01b0 m\u1eddi theo m\u1eabu sau (2) Th\u1ef1c hi\u1ec7n so\u1ea1n th\u1ea3o danh s\u00e1ch v\u00e0 th\u1ef1c hi\u1ec7n tr\u1ed9n th\u01b0 m\u1eddi H\u1ecd t\u00ean Ch\u1ee9c v\u1ee5 \u0110\u01a1n v\u1ecb T\u1ec9nh A Nguy\u1ec5n Th\u1ecb A Ch\u1ee7 t\u1ecbch T\u1ec9nh B T\u1ec9nh C Tr\u1ea7n V\u0103n B P. Ch\u1ee7 t\u1ecbch T\u1ec9nh D T\u1ec9nh E L\u00ea Th\u1ecb C C\u00e1n b\u1ed9 c\u00f4ng \u0111o\u00e0n chuy\u00ean tr\u00e1ch L\u00fd V\u0103n D P. Ch\u1ee7 t\u1ecbch Hu\u1ef3nh V\u0103n E C\u00e1n b\u1ed9 c\u00f4ng \u0111o\u00e0n chuy\u00ean tr\u00e1ch 177","CH\u01af\u01a0NG IV. S\u1eec D\u1ee4NG B\u1ea2NG T\u00cdNH C\u01a0 B\u1ea2N M\u1ee4C TI\u00caU H\u1ecdc xong ch\u01b0\u01a1ng n\u00e0y, ng\u01b0\u1eddi h\u1ecdc c\u00f3 kh\u1ea3 n\u0103ng: - Tr\u00ecnh b\u00e0y \u0111\u01b0\u1ee3c m\u1ed9t s\u1ed1 ki\u1ebfn th\u1ee9c c\u01a1 b\u1ea3n v\u1ec1 b\u1ea3ng t\u00ednh, trang t\u00ednh; v\u1ec1 s\u1eed d\u1ee5ng ph\u1ea7n m\u1ec1m Microsoft Excel 2019; - S\u1eed d\u1ee5ng \u0111\u01b0\u1ee3c ph\u1ea7n m\u1ec1m x\u1eed l\u00fd b\u1ea3ng t\u00ednh Microsoft Excel 2019 \u0111\u1ec3 t\u1ea1o b\u1ea3ng t\u00ednh, trang t\u00ednh; nh\u1eadp v\u00e0 \u0111\u1ecbnh d\u1ea1ng d\u1eef li\u1ec7u; s\u1eed d\u1ee5ng c\u00e1c bi\u1ec3u th\u1ee9c to\u00e1n h\u1ecdc, c\u00e1c h\u00e0m c\u01a1 b\u1ea3n \u0111\u1ec3 t\u00ednh to\u00e1n c\u00e1c b\u00e0i to\u00e1n th\u1ef1c t\u1ebf. 4.1. Ki\u1ebfn th\u1ee9c c\u01a1 b\u1ea3n v\u1ec1 b\u1ea3ng t\u00ednh (Workbook) 4.1.1. Kh\u00e1i ni\u1ec7m b\u1ea3ng t\u00ednh B\u1ea3ng t\u00ednh (Workbook) l\u00e0 t\u1eadp tin c\u1ee7a Microsoft Excel c\u00f3 ph\u1ea7n m\u1edf r\u1ed9ng l\u00e0 *.XLSX. M\u1ed7i Workbook c\u00f3 th\u1ec3 t\u1ea1o nhi\u1ec1u trang t\u00ednh (Worksheet), m\u1ed7i trang t\u00ednh c\u00f3 t\u00ean ph\u00e2n bi\u1ec7t. B\u1ea3ng t\u00ednh c\u00f3 t\u1ed1i \u0111a 255 trang t\u00ednh (sheet) Trang t\u00ednh \u2013 Worksheet (sheet) - Sheet \u0111\u01b0\u1ee3c t\u1ea1o b\u1edfi c\u00e1c d\u00f2ng (row) v\u00e0 c\u00e1c c\u1ed9t (column). - Ph\u1ea7n giao nhau c\u1ee7a c\u00e1c d\u00f2ng v\u00e0 c\u1ed9t l\u00e0 c\u00e1c \u00f4 (cell). - M\u1ed9t sheet c\u00f3: + 16384 c\u1ed9t \u0111\u01b0\u1ee3c \u0111\u00e1nh A, B, C, ..., AA, BB, ..., XFD + 1048576 d\u00f2ng \u0111\u01b0\u1ee3c \u0111\u00e1nh s\u1ed1 1, 2, ..., 1048576 - \u0110\u1ecba ch\u1ec9 t\u01b0\u01a1ng \u0111\u1ed1i: C\u00e1c d\u00f2ng v\u00e0 c\u1ed9t tham chi\u1ebfu s\u1ebd thay \u0111\u1ed5i khi ch\u00fang ta sao ch\u00e9p ho\u1eb7c di d\u1eddi c\u00f4ng th\u1ee9c \u0111\u1ebfn v\u1ecb tr\u00ed kh\u00e1c. V\u00ed d\u1ee5: A2:C7, D4 . - \u0110\u1ecba ch\u1ec9 tuy\u1ec7t \u0111\u1ed1i: C\u00e1c d\u00f2ng v\u00e0 c\u1ed9t tham chi\u1ebfu kh\u00f4ng thay \u0111\u1ed5i khi ta di d\u1eddi hay sao ch\u00e9p c\u00f4ng th\u1ee9c. V\u00ed d\u1ee5 $A$2:$C$7, $D$4 4.2.2. C\u00e1c b\u01b0\u1edbc x\u00e2y d\u1ef1ng b\u1ea3ng t\u00ednh th\u00f4ng th\u01b0\u1eddng B\u01b0\u1edbc 1: Nh\u1eadp v\u00e0 \u0111\u1ecbnh d\u1ea1ng d\u1eef li\u1ec7u v\u00e0o b\u1ea3ng t\u00ednh; B\u01b0\u1edbc 2: T\u00ednh to\u00e1n tr\u00ean d\u1eef li\u1ec7u b\u1eb1ng c\u00e1ch \u00e1p d\u1ee5ng c\u00e1c ph\u00e9p t\u00ednh, bi\u1ec3u th\u1ee9c, h\u00e0m; B\u01b0\u1edbc 3: In b\u1ea3ng t\u00ednh. 178","4.2. S\u1eed d\u1ee5ng Microsoft Excel 4.2.1. L\u00e0m vi\u1ec7c v\u1edbi ph\u1ea7n m\u1ec1m Microsoft Excel 4.2.1.1. M\u1edf, \u0111\u00f3ng ph\u1ea7n m\u1ec1m - Kh\u1edfi \u0111\u1ed9ng \uf0b7 C\u00e1ch 1: Nh\u1ea5p chu\u1ed9t v\u00e0o bi\u1ec3u t\u01b0\u1ee3ng tr\u00ean desktop \uf0b7 C\u00e1ch 2: Ch\u1ecdn Start \uf0e0 Micrsoft Office \uf0e0 Excel 2019 - Tho\u00e1t kh\u1ecfi ch\u01b0\u01a1ng tr\u00ecnh \uf0b7 Nh\u1ea5p chu\u1ed9t v\u00e0o n\u00fat \u1edf g\u00f3c tr\u00ean c\u00f9ng b\u00ean ph\u1ea3i \u0111\u1ec3 tho\u00e1t kh\u1ecfi Excel. 4.2.1.2. Giao di\u1ec7n Microsoft Excel Tab Bar (Thanh tab) Title Bar (Thanh Ribbon (Thanh ti\u00eau \u0111\u1ec1) ch\u1ee9a c\u00e1c Group Formula bar (Thanh c\u00f4ng th\u1ee9c) c\u00f4ng c\u1ee5) Sheet Tab (Ch\u1ee9a c\u00e1c V\u00f9ng l\u00e0m vi\u1ec7c sheet trong workbook) H\u00ecnh 4.1. Giao di\u1ec7n Microsoft Excel 2019 tr\u00ean 4.2.2. Thao t\u00e1c tr\u00ean t\u1eadp tin b\u1ea3ng t\u00ednh 4.2.2.1. M\u1edf t\u1eadp tin b\u1ea3ng t\u00ednh T\u1eeb tab File \uf0e0 Open (ho\u1eb7c Ctrl + O). Ho\u1eb7c Nh\u1ea5p chu\u1ed9t v\u00e0o bi\u1ec3u t\u01b0\u1ee3ng thanh Customize Quick Access Toolbar xu\u1ea5t hi\u1ec7n h\u1ed9p tho\u1ea1i 179","Ch\u1ecdn folder G\u00f5 t\u00ean t\u1eadp tin Ch\u1ecdn Open H\u00ecnh 4.2. H\u1ed9p tho\u1ea1i m\u1edf t\u1eadp tin tr\u00ean 4.2.2.2. L\u01b0u b\u1ea3ng t\u00ednh T\u1eeb tab File \uf0e0 Save (ho\u1eb7c Ctrl + S). Ho\u1eb7c Nh\u1ea5p chu\u1ed9t v\u00e0o bi\u1ec3u t\u01b0\u1ee3ng thanh Customize Quick Access Toolbar xu\u1ea5t hi\u1ec7n h\u1ed9p tho\u1ea1i Ch\u1ecdn folder G\u00f5 t\u00ean t\u1eadp tin H\u00ecnh 4.3. H\u1ed9p tho\u1ea1i l\u01b0u b\u1ea3ng t\u00ednh 180","4.2.2.3. \u0110\u00f3ng b\u1ea3ng t\u00ednh T\u1eeb tab File \uf0e0 Close ( Ctrl + F4) 4.3. Thao t\u00e1c v\u1edbi \u00f4 4.3.1. C\u00e1c ki\u1ec3u d\u1eef li\u1ec7u 4.3.1.1. Ki\u1ec3u d\u1eef li\u1ec7u s\u1ed1 (Number) Bao g\u1ed3m c\u00e1c k\u00fd s\u1ed1 t\u1eeb 0 - 9, d\u1ea5u (), $, %, ... Khi \u0111\u01b0\u1ee3c nh\u1eadp v\u00e0o h\u1ee3p l\u1ec7, s\u1ed1 s\u1ebd m\u1eb7c nhi\u00ean canh ph\u1ea3i trong \u00f4. N\u1ebfu chi\u1ec1u r\u1ed9ng c\u1ed9t kh\u00f4ng \u0111\u1ee7 \u0111\u1ec3 hi\u1ec3n th\u1ecb h\u1ebft con s\u1ed1 th\u00ec Excel s\u1ebd hi\u1ec3n th\u1ecb s\u1ed1 theo d\u1ea1ng khoa h\u1ecdc (V\u00ed d\u1ee5: 1.259E+08) ho\u1eb7c hi\u1ec3n th\u1ecb c\u00e1c d\u1ea5u \u201c#\u201d, trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y ta ph\u1ea3i m\u1edf r\u1ed9ng c\u1ed9t cho \u0111\u1ebfn khi s\u1ed1 hi\u1ec3n th\u1ecb \u0111\u1ea7y \u0111\u1ee7. Ch\u00fa \u00fd: Khi nh\u1eadp m\u1ed9t d\u1eef li\u1ec7u ki\u1ec3u s\u1ed1 ta kh\u00f4ng c\u1ea7n ph\u1ea3i nh\u1eadp d\u1ea5u ph\u00e2n c\u00e1ch h\u00e0ng ng\u00e0n nh\u01b0ng ph\u1ea3i nh\u1eadp d\u1ea5u ph\u00e2n c\u00e1ch th\u1eadp ph\u00e2n. V\u00ed d\u1ee5: ta ch\u1ec9 c\u1ea7n nh\u1eadp 37923.87 sau khi \u0111\u1ecbnh d\u1ea1ng s\u1ed1 s\u1ebd t\u1ef1 \u0111\u1ed9ng \u0111\u1ed5i th\u00e0nh 37,923.87. 4.3.1.2. D\u1eef li\u1ec7u ki\u1ec3u ng\u00e0y, gi\u1edd ( Date\/Time) Th\u1ef1c ch\u1ea5t l\u00e0 ki\u1ec3u s\u1ed1 ch\u1ec9 s\u1ed1 th\u1ee9 t\u1ef1 t\u1eeb ng\u00e0y 01\/01\/1900 tr\u1edf \u0111i. Ph\u1ea3i nh\u1eadp ng\u00e0y v\u00e0 gi\u1edd theo \u0111\u00fang d\u1ea1ng \u0111\u00e3 ch\u1ecdn trong Control Panel c\u1ee7a Windows. 4.3.1.3. D\u1eef li\u1ec7u ki\u1ec3u Logic G\u1ed3m c\u00e1c gi\u00e1 tr\u1ecb: TRUE, FALSE. D\u1eef li\u1ec7u ki\u1ec3u chu\u1ed7i (Text) Bao g\u1ed3m c\u00e1c k\u00fd t\u1ef1 t\u1eeb: A - Z, a - z, 0 - 9, kho\u1ea3ng tr\u1eafng v\u00e0 m\u1ed9t s\u1ed1 k\u00fd hi\u1ec7u kh\u00e1c. N\u1ebfu d\u1eef li\u1ec7u nh\u1eadp v\u00e0o c\u00f3 s\u1ed1 v\u00e0 ch\u1eef l\u1eabn l\u1ed9n th\u00ec Excel hi\u1ec3u ng\u1ea7m l\u00e0 ki\u1ec3u chu\u1ed7i. Khi nh\u1eadp v\u00e0o, d\u1eef li\u1ec7u ki\u1ec3u chu\u1ed7i s\u1ebd m\u1eb7c nhi\u00ean \u0111\u01b0\u1ee3c canh tr\u00e1i. N\u1ebfu m\u1ed9t chu\u1ed7i c\u1ee5 th\u1ec3 n\u00e0o \u0111\u00f3 \u0111\u01b0\u1ee3c d\u00f9ng trong c\u00f4ng th\u1ee9c th\u00ec ph\u1ea3i \u0111\u1eb7t ch\u00fang trong c\u1eb7p d\u1ea5u ngo\u1eb7c k\u00e9p. V\u00ed d\u1ee5: \u201cl\u1edbp 11B8\u201d. 4.3.2. C\u00e1ch nh\u1eadp d\u1eef li\u1ec7u - B\u01b0\u1edbc 1: Ch\u1ecdn \u00f4 c\u1ea7n nh\u1eadp li\u1ec7u. - B\u01b0\u1edbc 2: Nh\u1eadp n\u1ed9i dung. - B\u01b0\u1edbc 3: Nh\u1ea5n Enter ho\u1eb7c c\u00e1c ph\u00edm di chuy\u1ec3n trong \u00f4. 4.3.3. Ch\u1ec9nh s\u1eeda d\u1eef li\u1ec7u 4.3.3.1. Xo\u00e1 d\u1eef li\u1ec7u - B\u01b0\u1edbc 1: Ch\u1ecdn \u00f4, v\u00f9ng c\u1ea7n xo\u00e1 n\u1ed9i dung. - B\u01b0\u1edbc 2: Nh\u1ea5n ph\u00edm Delete. Ngo\u00e0i ra, c\u00f2n c\u00f3 c\u00e1c l\u1ec7nh xo\u00e1 kh\u00e1c: - Tab Home \uf0e0 Clear \uf0e0 All: xo\u00e1 t\u1ea5t c\u1ea3 - Tab Home \uf0e0 Clear \uf0e0 Formats: ch\u1ec9 xo\u00e1 \u0111\u1ecbnh d\u1ea1ng 181","- Tab Home \uf0e0 Clear \uf0e0 Contents: ch\u1ec9 xo\u00e1 n\u1ed9i dung - Tab Home \uf0e0 Clear \uf0e0 Comments: ch\u1ec9 xo\u00e1 ghi ch\u00fa 4.3.3.2. Kh\u00f4i ph\u1ee5c d\u1eef li\u1ec7u - H\u1ee7y l\u1ec7nh (Undo), ph\u1ee5c h\u1ed3i l\u1ec7nh (Redo), l\u1eb7p l\u1ea1i l\u1ec7nh sau c\u00f9ng Hu\u1ef7 l\u1ec7nh Ph\u1ee5c h\u1ed3i l\u1ec7nh - \u0110\u1ec3 h\u1ee7y m\u1ed9t l\u1ec7nh v\u1eeba th\u1ef1c hi\u1ec7n ta nh\u1ea5p chu\u1ed9t l\u00ean n\u00fat ho\u1eb7c d\u00f9ng ph\u00edm <Ctrl+Z>. - \u0110\u1ec3 ph\u1ee5c h\u1ed3i l\u1ec7nh v\u1eeba h\u1ee7y th\u00ec nh\u1ea5n n\u00fat ho\u1eb7c d\u00f9ng ph\u00edm <Ctrl+Y>. - \u0110\u1ec3 th\u1ef1c hi\u1ec7n l\u1ea1i l\u1ec7nh sau c\u00f9ng nh\u1ea5n <Ctrl+Y>. 4.4. L\u00e0m vi\u1ec7c v\u1edbi trang t\u00ednh (Worksheet) 4.4.1. D\u00f2ng v\u00e0 c\u1ed9t 4.4.1.1. Th\u00eam d\u00f2ng v\u00e0 c\u1ed9t 4.4.1.1.1. Th\u00eam d\u00f2ng - B\u01b0\u1edbc 1: Ch\u1ecdn m\u1ed9t ho\u1eb7c nhi\u1ec1u d\u00f2ng t\u1ea1i v\u1ecb tr\u00ed mu\u1ed1n ch\u00e8n - B\u01b0\u1edbc 2: Ch\u1ecdn tab Home\uf0e0 ch\u1ecdn nh\u00f3m Cells\uf0e0Insert\uf0e0Insert Sheet Rows ho\u1eb7c Nh\u1ea5p chu\u1ed9t ph\u1ea3i, ch\u1ecdn Insert. 4.4.1.1.2. Th\u00eam c\u1ed9t - B\u01b0\u1edbc 1: Ch\u1ecdn m\u1ed9t ho\u1eb7c nhi\u1ec1u c\u1ed9t li\u00ean t\u1ee5c ho\u1eb7c c\u00e1ch kho\u1ea3ng m\u00e0 ta mu\u1ed1n ch\u00e8n s\u1ed1 c\u1ed9t t\u01b0\u01a1ng \u1ee9ng ph\u00eda b\u00ean tr\u00e1i c\u00e1c c\u1ed9t n\u00e0y. - B\u01b0\u1edbc 2: Ch\u1ecdn tab Home \uf0e0 ch\u1ecdn nh\u00f3m Cells\uf0e0Insert\uf0e0Insert Sheet Columns ho\u1eb7c Nh\u1ea5p chu\u1ed9t ph\u1ea3i, ch\u1ecdn Insert. 182","4.4.1.2. Xo\u00e1 d\u00f2ng v\u00e0 c\u1ed9t - B\u01b0\u1edbc 1: Ch\u1ecdn c\u00e1c d\u00f2ng ho\u1eb7c c\u00e1c c\u1ed9t c\u1ea7n x\u00f3a - B\u01b0\u1edbc 2: Ch\u1ecdn tab Home\uf0e0nh\u00f3m Cells\uf0e0Delete\uf0e0ch\u1ecdn ki\u1ec3u x\u00f3a ph\u00f9 h\u1ee3p. Ho\u1eb7c Nh\u1ea5p chu\u1ed9t ph\u1ea3i ch\u1ecdn Delete. 4.4.1.3. Hi\u1ec7u ch\u1ec9nh k\u00edch th\u01b0\u1edbc d\u00f2ng, c\u1ed9t - C\u00f3 th\u1ec3 thay \u0111\u1ed5i \u0111\u1ed9 r\u1ed9ng c\u1ee7a c\u1ed9t ho\u1eb7c chi\u1ec1u cao c\u1ee7a d\u00f2ng b\u1eb1ng c\u00e1ch \u0111\u01b0a chu\u1ed9t \u0111\u1ebfn bi\u00ean gi\u1eefa t\u00ean c\u1ed9t\/d\u00f2ng sau \u0111\u00f3 drag chu\u1ed9t \u0111\u1ec3 thay \u0111\u1ed5i k\u00edch th\u01b0\u1edbc. \uf0b7 V\u00e0o tab Home \uf0e0 nh\u00f3m Cells \uf0e0 Format. \uf0b7 Ch\u1ecdn Row Height: thay \u0111\u1ed5i chi\u1ec1u cao c\u1ee7a d\u00f2ng ( ho\u1eb7c ch\u1ecdn Column Width \u0111\u1ec3 thay \u0111\u1ed5i \u0111\u1ed9 r\u1ed9ng c\u1ee7a c\u1ed9t) \uf0b7 Ch\u1ecdn AutoFit Row Height\/AutoFit Column Width: t\u1ef1 \u0111\u1ed9ng \u0111i\u1ec1u ch\u1ec9nh k\u00edch th\u01b0\u1edbc v\u1eeba v\u1edbi d\u1eef li\u1ec7u. 4.4.1.4. \u1ea8n\/hi\u1ec7n, c\u1ed1 \u0111\u1ecbnh (freeze)\/th\u00f4i c\u1ed1 \u0111\u1ecbnh (unfreeze) ti\u00eau \u0111\u1ec1 d\u00f2ng, c\u1ed9t - C\u1ed1 \u0111\u1ecbnh ti\u00eau \u0111\u1ec1 d\u00f2ng, c\u1ed9t: V\u00e0o tab View -> Freeze Panes trong nh\u00f3m Window 183","C\u1ed1 \u0111\u1ecbnh nhi\u1ec1u d\u00f2ng C\u1ed1 \u0111\u1ecbnh d\u00f2ng C\u1ed1 \u0111\u1ecbnh c\u1ed9t 4.4.2. Trang t\u00ednh 4.4.2.1. T\u1ea1o, xo\u00e1, di chuy\u1ec3n, sao ch\u00e9p c\u00e1c trang t\u00ednh 4.4.2.1.1. T\u1ea1o WorkSheet - B\u01b0\u1edbc 1: Nh\u1ea5p chu\u1ed9t ph\u1ea3i t\u1ea1i Sheet b\u1ea5t k\u1ef3 - B\u01b0\u1edbc 2: Ch\u1ecdn Insert t\u1eeb tab ng\u1eef c\u1ea3nh. - B\u01b0\u1edbc 3: Ch\u1ecdn bi\u1ec3u t\u01b0\u1ee3ng Worksheet 184","4.4.2.1.2. Xo\u00e1 Worksheet - B\u01b0\u1edbc 1: Nh\u1ea5p chu\u1ed9t ph\u1ea3i chu\u1ed9t t\u1ea1i worksheet mu\u1ed1n xo\u00e1 - B\u01b0\u1edbc 2: Ch\u1ecdn Delete t\u1eeb tab ng\u1eef c\u1ea3nh 185","4.4.2.1.3. Di chuy\u1ec3n v\u00e0 sao ch\u00e9p worksheet - D\u00f9ng l\u1ec7nh \uf0b7 B\u01b0\u1edbc 1: Nh\u1ea5p chu\u1ed9t ph\u1ea3i t\u1ea1i worksheet mu\u1ed1n di chuy\u1ec3n ho\u1eb7c sao ch\u00e9p. \uf0b7 B\u01b0\u1edbc 2: Ch\u1ecdn Move or Copy t\u1eeb menu ng\u1eef c\u1ea3nh T\u1ea1i Worksheet Danh Di chuy\u1ec3n s\u00e1ch sv (2) l\u00e0 b\u1ea3n sao Worksheet Danh c\u1ee7a Worksheet Danh s\u00e1ch sv \u0111\u1ebfn tr\u01b0\u1edbc S\u00e1ch SV tr\u01b0\u1edbc Worksheet \u0110i\u1ec3m Worksheet \u0110i\u1ec3m HK1 186","- D\u00f9ng chu\u1ed9t: \uf0b7 Di chuy\u1ec3n Worksheet: K\u00e9o th\u1ea3 worksheet Tab \u0111\u1ebfn v\u1ecb tr\u00ed m\u1edbi. \uf0b7 Sao ch\u00e9p Worksheet: Nh\u1ea5n gi\u1eef ph\u00edm Ctrl v\u00e0 k\u00e9o th\u1ea3 Worksheet tr\u00ean Sheet Tab \u0111\u1ebfn v\u1ecb tr\u00ed m\u1edbi. 4.4.2.2. Thay \u0111\u1ed5i t\u00ean trang t\u00ednh - B\u01b0\u1edbc 1: Nh\u1ea5p chu\u1ed9t ph\u1ea3i t\u1ea1i Worksheet mu\u1ed1n \u0111\u1ed5i t\u00ean - B\u01b0\u1edbc 2: Ch\u1ecdn Rename t\u1eeb menu ng\u1eef c\u1ea3nh 4.4.2.3. M\u1edf nhi\u1ec1u trang t\u00ednh - B\u01b0\u1edbc 1: M\u1edf nhi\u1ec1u trang t\u00ednh c\u00f9ng l\u00fac - B\u01b0\u1edbc 2: Tab View \uf0e0 View Side by Side \u1edf m\u1ee5c Window 187","\u0110\u1ec3 thay \u0111\u1ed5i c\u00e1ch xem, Nh\u1ea5p chu\u1ed9t v\u00e0o \u201cArrange All\u201d trong m\u1ee5c \u201cWindow\u201d c\u1ee7a tab \u201cView\u201d. H\u1ed9p tho\u1ea1i \u201cArrange Windows\u201d xu\u1ea5t hi\u1ec7n. Trong \u0111\u00f3 c\u00f3 c\u00e1c l\u1ef1a ch\u1ecdn: - Vertical: c\u00e1c c\u1eeda s\u1ed5 s\u1ebd \u0111\u01b0\u1ee3c \u0111\u1eb7t c\u1ea1nh nhau, gi\u1ed1ng nh\u01b0 khi ta canh ch\u00fang v\u1ec1 ph\u00eda b\u00ean tr\u00e1i v\u00e0 b\u00ean ph\u1ea3i m\u00e0n h\u00ecnh. - Horizontal: c\u00e1c c\u1eeda s\u1ed5 b\u1ea3ng t\u00ednh \u0111\u01b0\u1ee3c \u0111\u1eb7t theo chi\u1ec1u ngang (m\u1ed9t c\u1eeda s\u1ed5 n\u1eb1m tr\u00ean, m\u1ed9t c\u1eeda s\u1ed5 n\u1eb1m d\u01b0\u1edbi). - Tiled: Trong tr\u01b0\u1eddng h\u1ee3p ta m\u1edf 2 b\u1ea3ng t\u00ednh, Tiled s\u1ebd ho\u1ea1t \u0111\u1ed9ng gi\u1ed1ng Vertical, \u0111\u1eb7t 2 b\u1ea3ng t\u00ednh v\u1ec1 2 b\u00ean tr\u00e1i, ph\u1ea3i c\u1ee7a m\u00e0n h\u00ecnh. - Cascade: C\u00e1c c\u1eeda s\u1ed5 b\u1ea3ng t\u00ednh \u0111\u01b0\u1ee3c x\u1ebfp theo d\u1ea1ng b\u1eadc. 4.4.2.4. T\u00ednh to\u00e1n tr\u00ean nhi\u1ec1u trang t\u00ednh Ch\u00fang ta c\u00f3 th\u1ec3 mu\u1ed1n s\u1eed d\u1ee5ng gi\u00e1 tr\u1ecb t\u1eeb m\u1ed9t \u00f4 trong nhi\u1ec1u worksheet kh\u00e1c trong c\u00f9ng workbook trong m\u1ed9t c\u00f4ng th\u1ee9c. V\u00ed d\u1ee5, gi\u00e1 tr\u1ecb c\u1ee7a \u00f4 A1 trong worksheet hi\u1ec7n th\u1eddi v\u00e0 \u00f4 A2 trong worksheet th\u1ee9 2 c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng th\u00eam \u0111\u1ecbnh d\u1ea1ng \u201csheetname!celladdress\u201d. C\u00f4ng th\u1ee9c cho v\u00ed d\u1ee5 n\u00e0y s\u1ebd l\u00e0 \u201c=A1+Sheet2!A2\u201d n\u01a1i gi\u00e1 tr\u1ecb c\u1ee7a \u00f4 A1 trong worksheet hi\u1ec7n th\u1eddi \u0111\u01b0\u1ee3c th\u00eam v\u00e0o gi\u00e1 tr\u1ecb c\u1ee7a \u00f4 A2 trong worksheet c\u00f3 t\u00ean \u201cSheet2\u201d. 188","4.5. \u0110\u1ecbnh d\u1ea1ng \u00f4, d\u00e3y \u00f4 4.5.1. \u0110\u1ecbnh d\u1ea1ng ki\u1ec3u s\u1ed1, ng\u00e0y, ti\u1ec1n t\u1ec7 - B\u01b0\u1edbc 1: Ch\u1ecdn v\u00f9ng d\u1eef li\u1ec7u c\u1ea7n \u0111\u1ecbnh d\u1ea1ng - B\u01b0\u1edbc 2: Ch\u1ecdn tab Home \uf0e0 nh\u00f3m Cells \uf0e0 Format \uf0e0 Format Cells, Ch\u1ecdn th\u1ebb Number. H\u00ecnh 4.4. H\u1ed9p tho\u1ea1i Format Cells 4.5.2. \u0110\u1ecbnh d\u1ea1ng v\u0103n b\u1ea3n - Ch\u1ecdn tab Home \uf0e0 nh\u00f3m Cells \uf0e0 Format \uf0e0 Format Cells \uf0e0 Font: Ch\u1ecdn ki\u1ec3u \u0111\u1ecbnh d\u1ea1ng - C\u00f3 th\u1ec3 \u0111\u1ecbnh d\u1ea1ng b\u1eb1ng c\u00f4ng c\u1ee5 \u1edf Group Font. H\u00ecnh 4.5. H\u1ed9p tho\u1ea1i \u0111\u1ecbnh d\u1ea1ng 189","4.5.3. C\u0103n ch\u1ec9nh, hi\u1ec7u \u1ee9ng vi\u1ec1n 4.5.3.1.C\u0103n l\u1ec1 d\u1eef li\u1ec7u trong \u00f4 Ch\u1ecdn tab Home \uf0e0 nh\u00f3m Cells \uf0e0 Format \uf0e0 Format Cells \uf0e0 Alignment This image cannot currently be displayed. H\u00ecnh 4.6. H\u1ed9p tho\u1ea1i Format Cells - Text Alignment: Canh l\u1ec1 cho d\u1eef li\u1ec7u trong \u00f4 - Horizontal: Canh l\u1ec1 theo chi\u1ec1u ngang (Left\/ Right\/ Center\/ Justified\/ Center Across Selection\/ Distributed\/ Fill). - Vertical: Canh l\u1ec1 theo chi\u1ec1u \u0111\u1ee9ng (Top\/ Center\/ Bottom\/ Justify\/ Distributed) - Orientation: Ch\u1ecdn h\u01b0\u1edbng cho d\u1eef li\u1ec7u (nh\u1eadp s\u1ed1 \u0111o g\u00f3c quay trong \u00f4 Degrees). - Text Control: \u0110i\u1ec1u ch\u1ec9nh d\u1eef li\u1ec7u - Wrap text: D\u1eef li\u1ec7u t\u1ef1 \u0111\u1ed9ng xu\u1ed1ng d\u00f2ng khi g\u1eb7p l\u1ec1 ph\u1ea3i c\u1ee7a \u00f4. - Shrink to fit: D\u1eef li\u1ec7u t\u1ef1 \u0111\u1ed9ng thu nh\u1ecf k\u00edch th\u01b0\u1edbc cho v\u1eeba v\u1edbi \u00f4. - Merge cells: K\u1ebft h\u1ee3p c\u00e1c \u00f4 th\u00e0nh 1 \u00f4. 190","4.5.3.2. K\u1ebb khung cho b\u1ea3ng t\u00ednh Ch\u1ecdn tab Home \uf0e0 nh\u00f3m Cells \uf0e0 Fomat \uf0e0 Format Cells \uf0e0 Ch\u1ecdn th\u1ebb Border. H\u00ecnh 4.7. H\u1ed9p tho\u1ea1i k\u1ebb khung - Presets: Ch\u1ecdn ki\u1ec3u k\u1ebb khung \uf0b7 None: B\u1ecf k\u1ebb khung \uf0b7 Inside: K\u1ebb c\u00e1c \u0111\u01b0\u1eddng trong. \uf0b7 Outside: K\u1ebb \u0111\u01b0\u1eddng vi\u1ec1n xung quanh - Border: Cho ph\u00e9p ch\u1ecdn \u0111\u01b0\u1eddng k\u1ebb tr\u1ef1c quan theo y\u00eau c\u1ea7u. - Line: \uf0b7 Style: Ch\u1ecdn ki\u1ec3u c\u1ee7a \u0111\u01b0\u1eddng k\u1ebb. \uf0b7 Color: M\u00e0u c\u1ee7a \u0111\u01b0\u1eddng k\u1ebb - T\u00f4 n\u1ec1n cho b\u1ea3ng t\u00ednh Ch\u1ecdn Home \uf0e0 nh\u00f3m Cells \uf0e0 Fomat \uf0e0 Format Cells \uf0e0 Ch\u1ecdn th\u1ebb Fill. \uf0b7 Pattern Color: Ch\u1ecdn m\u00e0u n\u1ec1n \uf0b7 Pattern Style: Ch\u1ecdn c\u00e1c m\u1eabu n\u1ec1n 191"]