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

["C\u00f3 th\u1ec3 t\u00f4 nhanh b\u1eb1ng c\u00e1c Nh\u1ea5p chu\u1ed9t n\u00fat Fill Color \u1edf Group Font. L\u01b0u \u00fd: C\u00f3 th\u1ec3 m\u1edf h\u1ed9p tho\u1ea1i Format Cells b\u1eb1ng c\u00e1ch ch\u1ecdn v\u00f9ng d\u1eef li\u1ec7u, Nh\u1ea5p chu\u1ed9t ph\u1ea3i ch\u1ecdn Format Cells trong Shortcut menu. 4.6. Bi\u1ec3u th\u1ee9c v\u00e0 h\u00e0m 4.6.1. Bi\u1ec3u th\u1ee9c s\u1ed1 h\u1ecdc 4.6.1.1. Kh\u00e1i ni\u1ec7m bi\u1ec3u th\u1ee9c s\u1ed1 h\u1ecdc Bi\u1ec3u th\u1ee9c l\u1eadp n\u00ean t\u1eeb c\u00e1c to\u00e1n h\u1ea1ng v\u00e0 c\u00e1c ph\u00e9p t\u00ednh \u0111\u1ec3 t\u1ea1o n\u00ean nh\u1eefng gi\u00e1 tr\u1ecb m\u1edbi. Bi\u1ec3u th\u1ee9c d\u00f9ng \u0111\u1ec3 di\u1ec5n \u0111\u1ea1t m\u1ed9t c\u00f4ng th\u1ee9c, m\u1ed9t quy tr\u00ecnh t\u00ednh to\u00e1n, l\u00e0 s\u1ef1 k\u1ebft h\u1ee3p gi\u1eefa c\u00e1c ph\u00e9p to\u00e1n v\u00e0 c\u00e1c to\u00e1n h\u1ea1ng \u0111\u1ec3 di\u1ec5n \u0111\u1ea1t m\u1ed9t c\u00f4ng th\u1ee9c to\u00e1n h\u1ecdc n\u00e0o \u0111\u00f3. 4.6.1.2. T\u1ea1o bi\u1ec3u th\u1ee9c s\u1ed1 h\u1ecdc \u0111\u01a1n gi\u1ea3n Bi\u1ec3u th\u1ee9c ph\u1ea3i b\u1eaft \u0111\u1ea7u b\u1edfi d\u1ea5u '='. Khi c\u1ea7n l\u1ea5y s\u1ed1 li\u1ec7u \u1edf \u00f4 n\u00e0o, nh\u1ea5p chu\u1ed9t v\u00e0o \u00f4 \u0111\u00f3 ho\u1eb7c g\u00f5 \u0111\u1ecba ch\u1ec9 \u00f4 \u0111\u00f3 v\u00e0o c\u00f4ng th\u1ee9c. V\u00ed d\u1ee5: T\u00ednh l\u01b0\u01a1ng v\u00e0 t\u1ef7 l\u1ec7 theo c\u00f4ng th\u1ee9c: L\u01b0\u01a1ng = S\u1ed1 ng\u00e0y c\u00f4ng * L\u01b0\u01a1ng ng\u00e0y T\u1ef7 l\u1ec7 = L\u01b0\u01a1ng \/ T\u1ed5ng c\u1ed9ng L\u01b0\u01a1ng H\u00ecnh 4.8. T\u1ea1o bi\u1ec3u th\u1ee9c C\u00e1ch th\u1ef1c hi\u1ec7n nh\u01b0 sau: T\u00ednh l\u01b0\u01a1ng cho nh\u00e2n vi\u00ean \u0111\u1ea7u ti\u00ean ta l\u00e0m nh\u01b0 sau: - \u0110\u01b0a con tr\u1ecf v\u1ec1 \u00f4 E2 - G\u00f5 d\u1ea5u \u2018=\u2019 - Nh\u1ea5p chu\u1ed9t v\u00e0o \u00f4 C2 (ho\u1eb7c g\u00f5 C2) - G\u00f5 d\u1ea5u \u2018*\u2019 - Nh\u1ea5p chu\u1ed9t v\u00e0o \u00f4 D2 (ho\u1eb7c g\u00f5 D2) - Nh\u1ea5n Enter - \u0110\u1ec3 t\u00ednh l\u01b0\u01a1ng cho nh\u1eefng nh\u00e2n vi\u00ean c\u00f2n l\u1ea1i, \u0111\u01b0a con tr\u1ecf v\u1ec1 \u00f4 E2, sao ch\u00e9p c\u00f4ng th\u1ee9c cho t\u1edbi \u00f4 E7. 192","- T\u01b0\u01a1ng t\u1ef1 t\u00ednh t\u1ef7 l\u1ec7: c\u00e1ch l\u00e0m t\u01b0\u01a1ng t\u1ef1 nh\u01b0 tr\u00ean. 4.6.1.3. C\u00e1c l\u1ed7i th\u01b0\u1eddng g\u1eb7p Bi\u1ec3u th\u1ee9c b\u1eaft \u0111\u1ea7u b\u1edfi d\u1ea5u b\u1eb1ng (=). Sau khi nh\u1ea5n ph\u00edm Enter c\u00f4ng th\u1ee9c nh\u1eadp v\u00e0o ch\u1ec9 th\u1ec3 hi\u1ec7n tr\u00ean thanh c\u00f4ng th\u1ee9c c\u00f2n k\u1ebft qu\u1ea3 \u0111\u01b0\u1ee3c th\u1ec3 hi\u1ec7n trong \u00f4. M\u1ed9t s\u1ed1 th\u00f4ng b\u00e1o l\u1ed7i th\u01b0\u1eddng g\u1eb7p khi s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c: - ####: C\u1ed9t qu\u00e1 h\u1eb9p - Err: 503 Chia cho 0, sai v\u1ec1 ki\u1ec3u c\u1ee7a to\u00e1n h\u1ea1ng - #NAME? Th\u1ef1c hi\u1ec7n ph\u00e9p t\u00ednh v\u1edbi m\u1ed9t bi\u1ebfn kh\u00f4ng x\u00e1c \u0111\u1ecbnh (t\u00ean kh\u00f4ng g\u1eafn v\u1edbi m\u1ed9t \u00f4 hay v\u00f9ng n\u00e0o c\u1ea3) - #N\/A Tham chi\u1ebfu \u0111\u1ebfn \u00f4 r\u1ed7ng ho\u1eb7c kh\u00f4ng c\u00f3 trong danh s\u00e1ch 4.6.2. H\u00e0m 4.6.2.1. Kh\u00e1i ni\u1ec7m h\u00e0m, c\u00fa ph\u00e1p, c\u00e1ch nh\u1eadp h\u00e0m Kh\u00e1i ni\u1ec7m h\u00e0m: H\u00e0m d\u00f9ng \u0111\u1ec3 t\u00ednh to\u00e1n v\u00e0 tr\u1ea3 v\u1ec1 m\u1ed9t gi\u00e1 tr\u1ecb, trong \u00f4 ch\u1ee9a h\u00e0m s\u1ebd tr\u1ea3 v\u1ec1 m\u1ed9t gi\u00e1 tr\u1ecb, m\u1ed9t chu\u1ed7i k\u00fd t\u1ef1 ho\u1eb7c m\u1ed9t th\u00f4ng b\u00e1o l\u1ed7i, \u2026 Excel c\u00f3 m\u1ed9t t\u1eadp h\u1ee3p c\u00e1c h\u00e0m r\u1ea5t phong ph\u00fa v\u00e0 \u0111\u01b0\u1ee3c ph\u00e2n lo\u1ea1i theo t\u1eebng nh\u00f3m ph\u1ee5c v\u1ee5 cho vi\u1ec7c t\u00ednh to\u00e1n tr\u00ean nhi\u1ec1u ki\u1ec3u d\u1eef li\u1ec7u v\u00e0 nhi\u1ec1u m\u1ee5c \u0111\u00edch kh\u00e1c nhau. C\u00fa ph\u00e1p: = T\u00caN H\u00c0M ([Danh s\u00e1ch \u0111\u1ed1i s\u1ed1]) \u0110a s\u1ed1 c\u00e1c h\u00e0m c\u1ee7a Excel \u0111\u1ec1u c\u00f3 \u0111\u1ed1i s\u1ed1 nh\u01b0ng c\u0169ng c\u00f3 nh\u1eefng h\u00e0m kh\u00f4ng c\u00f3 \u0111\u1ed1i s\u1ed1. N\u1ebfu h\u00e0m c\u00f3 nhi\u1ec1u \u0111\u1ed1i s\u1ed1 th\u00ec gi\u1eefa c\u00e1c \u0111\u1ed1i s\u1ed1 ph\u1ea3i \u0111\u01b0\u1ee3c ph\u00e2n c\u00e1ch b\u1eb1ng k\u00fd hi\u1ec7u ph\u00e2n c\u00e1ch, c\u00e1c k\u00fd hi\u1ec7u ph\u00e2n c\u00e1ch \u0111\u01b0\u1ee3c quy \u0111\u1ecbnh trong Control Panel\u2026 v\u1edbi m\u1eb7c \u0111\u1ecbnh l\u00e0 d\u1ea5u ph\u1ea9y. C\u00e1ch nh\u1eadp h\u00e0m - C\u00e1ch 1: Nh\u1eadp tr\u1ef1c ti\u1ebfp t\u1eeb b\u00e0n ph\u00edm \uf0b7 \u0110\u1eb7t tr\u1ecf chu\u1ed9t t\u1ea1i \u00f4 mu\u1ed1n nh\u1eadp h\u00e0m. \uf0b7 Nh\u1eadp d\u1ea5u = (ho\u1eb7c d\u1ea5u @, ho\u1eb7c d\u1ea5u +). \uf0b7 Nh\u1eadp t\u00ean h\u00e0m c\u00f9ng c\u00e1c \u0111\u1ed1i s\u1ed1 theo \u0111\u00fang c\u00fa ph\u00e1p. \uf0b7 Nh\u1ea5n Enter \u0111\u1ec3 k\u1ebft th\u00fac. - C\u00e1ch 2: Th\u00f4ng qua h\u1ed9p tho\u1ea1i Insert Function \uf0b7 \u0110\u1eb7t tr\u1ecf t\u1ea1i \u00f4 mu\u1ed1n nh\u1eadp h\u00e0m. \uf0b7 Nh\u1ea5p chu\u1ed9t ch\u1ecdn Insert Function ho\u1eb7c Shift+F3 193","H\u00ecnh 4.9. H\u1ed9p tho\u1ea1i Insert Function \uf0b7 Ch\u1ecdn Group h\u00e0m trong danh s\u00e1ch Function category. \uf0b7 Ch\u1ecdn h\u00e0m c\u1ea7n s\u1eed d\u1ee5ng trong danh s\u00e1ch Function name. \uf0b7 Nh\u1ea5p ch\u1ecdn OK \u0111\u1ec3 ch\u1ecdn h\u00e0m. \uf0b7 T\u00f9y theo h\u00e0m \u0111\u01b0\u1ee3c ch\u1ecdn, Excel s\u1ebd m\u1edf h\u1ed9p tho\u1ea1i k\u1ebf ti\u1ebfp cho ph\u00e9p nh\u1eadp c\u00e1c \u0111\u1ed1i s\u1ed1 (nh\u1eadp ho\u1eb7c qu\u00e9t ch\u1ecdn). Ti\u1ebfn h\u00e0nh nh\u1eadp c\u00e1c \u0111\u1ed1i s\u1ed1. V\u00ed d\u1ee5 danh s\u00e1ch c\u00e1c \u0111\u1ed1i s\u1ed1 c\u1ea7n nh\u1eadp c\u1ee7a h\u00e0m IF: 194","4.6.2.2. To\u00e1n t\u1eed so s\u00e1nh =, < , > \u0110i\u1ec1u ki\u1ec7n To\u00e1n t\u1eed C\u00f4ng th\u1ee9c M\u00f4 t\u1ea3 B\u1eb1ng = =A1=B1 Tr\u1ea3 v\u1ec1 True n\u1ebfu gi\u00e1 tr\u1ecb \u00f4 A1 b\u1eb1ng v\u1edbi gi\u00e1 tr\u1ecb \u00f4 B1, ng\u01b0\u1ee3c l\u1ea1i tr\u1ea3 v\u1ec1 false Kh\u00f4ng < > =A1< > B1 Tr\u1ea3 v\u1ec1 True n\u1ebfu gi\u00e1 tr\u1ecb \u00f4 A1 kh\u00e1c v\u1edbi gi\u00e1 tr\u1ecb b\u1eb1ng \u00f4 B1, ng\u01b0\u1ee3c l\u1ea1i tr\u1ea3 v\u1ec1 false. To\u00e1n t\u1eed n\u00e0y ng\u01b0\u1ee3c l\u1ea1i v\u1edbi to\u00e1n t\u1eed \u201c=\u201d L\u1edbn h\u01a1n > =A1 > B1 Tr\u1ea3 v\u1ec1 True n\u1ebfu gi\u00e1 tr\u1ecb \u00f4 A1 l\u1edbn h\u01a1n gi\u00e1 tr\u1ecb \u00f4 B1, ng\u01b0\u1ee3c l\u1ea1i tr\u1ea3 v\u1ec1 false Nh\u1ecf h\u01a1n <= =A1 <= B1 Tr\u1ea3 v\u1ec1 True n\u1ebfu gi\u00e1 tr\u1ecb \u00f4 A1 nh\u1ecf h\u01a1n ho\u1eb7c ho\u1eb7c b\u1eb1ng b\u1eb1ng gi\u00e1 tr\u1ecb \u00f4 B1, ng\u01b0\u1ee3c l\u1ea1i tr\u1ea3 v\u1ec1 false. To\u00e1n t\u1eed n\u00e0y ng\u01b0\u1ee3c v\u1edbi to\u00e1n t\u1eed \u201c>\u201d Nh\u1ecf h\u01a1n < =A1 < B1 Tr\u1ea3 v\u1ec1 True n\u1ebfu gi\u00e1 tr\u1ecb \u00f4 A1 nh\u1ecf h\u01a1n gi\u00e1 tr\u1ecb \u00f4 B1, ng\u01b0\u1ee3c l\u1ea1i tr\u1ea3 v\u1ec1 false L\u1edbn h\u01a1n >= =A1 >= B1 Tr\u1ea3 v\u1ec1 True n\u1ebfu gi\u00e1 tr\u1ecb \u00f4 A1 l\u1edbn h\u01a1n ho\u1eb7c ho\u1eb7c b\u1eb1ng b\u1eb1ng gi\u00e1 tr\u1ecb \u00f4 B1, ng\u01b0\u1ee3c l\u1ea1i tr\u1ea3 v\u1ec1 false. To\u00e1n t\u1eed n\u00e0y ng\u01b0\u1ee3c v\u1edbi to\u00e1n t\u1eed \u201c<\u201d V\u00ed d\u1ee5 d\u01b0\u1edbi \u0111\u00e2y minh ho\u1ea1 c\u00e1c tr\u01b0\u1eddng h\u1ee3p so s\u00e1nh theo t\u1eebng c\u1eb7p \u0111i\u1ec1u ki\u1ec7n 4.6.2.3. C\u00e1c h\u00e0m c\u01a1 b\u1ea3n 4.6.2.3.1. H\u00e0m SUM - C\u00fa ph\u00e1p: =SUM(number1, number2, \u2026) - C\u00f4ng d\u1ee5ng: T\u00ednh t\u1ed5ng c\u00e1c gi\u00e1 tr\u1ecb ch\u1ec9 \u0111\u1ecbnh. (number1, number2, \u2026 c\u00f3 th\u1ec3 l\u00e0 c\u00e1c h\u1eb1ng s\u1ed1, bi\u1ec3u th\u1ee9c, \u0111\u1ecba ch\u1ec9 \u00f4, \u0111\u1ecba ch\u1ec9 v\u00f9ng, \u2026) 195","V\u00ed d\u1ee5: 4.6.2.3.2. H\u00e0m AVERAGE - C\u00fa ph\u00e1p: =AVERAGE(number1, number2,\u2026) - C\u00f4ng d\u1ee5ng: l\u1ea5y gi\u00e1 tr\u1ecb trung b\u00ecnh c\u1ed9ng c\u1ee7a c\u00e1c s\u1ed1 ch\u1ec9 \u0111\u1ecbnh. (number1, number2,\u2026 c\u00f3 th\u1ec3 l\u00e0 c\u00e1c h\u1eb1ng s\u1ed1, bi\u1ec3u th\u1ee9c, \u0111\u1ecba ch\u1ec9 \u00f4, \u0111\u1ecba ch\u1ec9 v\u00f9ng,\u2026) V\u00ed d\u1ee5: 4.6.2.3.3. H\u00e0m MIN - C\u00fa ph\u00e1p: =MIN(number1, number2,\u2026) - C\u00f4ng d\u1ee5ng: l\u1ea5y gi\u00e1 tr\u1ecb nh\u1ecf nh\u1ea5t c\u1ee7a c\u00e1c s\u1ed1 ch\u1ec9 \u0111\u1ecbnh. (number1, number2, \u2026 c\u00f3 th\u1ec3 l\u00e0 c\u00e1c h\u1eb1ng s\u1ed1, bi\u1ec3u th\u1ee9c, \u0111\u1ecba ch\u1ec9 \u00f4, \u0111\u1ecba ch\u1ec9 v\u00f9ng,\u2026) V\u00ed d\u1ee5: 4.6.2.3.4. H\u00e0m MAX - C\u00fa ph\u00e1p: =MAX(number1, number2,\u2026) - C\u00f4ng d\u1ee5ng: l\u1ea5y gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t c\u1ee7a c\u00e1c s\u1ed1 ch\u1ec9 \u0111\u1ecbnh. (number1, number2, \u2026 c\u00f3 th\u1ec3 l\u00e0 c\u00e1c h\u1eb1ng s\u1ed1, bi\u1ec3u th\u1ee9c, \u0111\u1ecba ch\u1ec9 \u00f4, \u0111\u1ecba ch\u1ec9 v\u00f9ng,\u2026) 196","V\u00ed d\u1ee5: 4.6.2.3.5. H\u00e0m COUNT - C\u00fa ph\u00e1p: =COUNT(value1, value2,\u2026) - C\u00f4ng d\u1ee5ng: \u0110\u1ebfm c\u00e1c gi\u00e1 tr\u1ecb s\u1ed1 trong v\u00f9ng ch\u1ec9 \u0111\u1ecbnh. (value1, value2, \u2026 c\u00f3 th\u1ec3 l\u00e0 c\u00e1c h\u1eb1ng s\u1ed1, bi\u1ec3u th\u1ee9c, \u0111\u1ecba ch\u1ec9 \u00f4, \u0111\u1ecba ch\u1ec9 v\u00f9ng, \u2026) V\u00ed d\u1ee5: 4.6.2.3.6. H\u00e0m COUNTA - C\u00fa ph\u00e1p: =COUNTA(value1, value2, \u2026) - C\u00f4ng d\u1ee5ng: \u0110\u1ebfm c\u00e1c \u00f4 c\u00f3 d\u1eef li\u1ec7u trong v\u00f9ng ch\u1ec9 \u0111\u1ecbnh (value1, value2, \u2026 c\u00f3 th\u1ec3 l\u00e0 c\u00e1c h\u1eb1ng s\u1ed1, bi\u1ec3u th\u1ee9c, \u0111\u1ecba ch\u1ec9 \u00f4, \u0111\u1ecba ch\u1ec9 v\u00f9ng, \u2026) V\u00ed d\u1ee5: 197","4.6.2.3.7. H\u00e0m ROUND - C\u00fa ph\u00e1p: =ROUND(number, num_digits) - C\u00f4ng d\u1ee5ng: \uf0b7 L\u00e0m tr\u00f2n s\u1ed1 number t\u1ea1i v\u1ecb tr\u00ed num-digits. \uf0b7 V\u1ecb tr\u00ed l\u00e0m tr\u00f2n num_disgits t\u01b0\u01a1ng t\u1ef1 tr\u1ee5c s\u1ed1 \uf0b7 Nguy\u00ean t\u1eafc l\u00e0m tr\u00f2n: N\u1ebfu k\u00fd s\u1ed1 b\u00ean ph\u1ea3i v\u1ecb tr\u00ed l\u00e0m tr\u00f2n num_digits \u2265 5 th\u00ec l\u1ea5y s\u1ed1 t\u1ea1i v\u1ecb tr\u00ed num_digits s\u1ebd c\u1ed9ng th\u00eam 1. Ng\u01b0\u1ee3c l\u1ea1i, n\u1ebfu < 5 s\u1ebd b\u1ecb c\u1eaft b\u1ecf (\u0111\u1ed1i v\u1edbi ph\u1ea7n th\u1eadp ph\u00e2n) ho\u1eb7c l\u00e0m tr\u00f2n v\u1ec1 0 (\u0111\u1ed1i v\u1edbi ph\u1ea7n nguy\u00ean) V\u00ed d\u1ee5: =ROUND(15271.382, -2) \uf0e0 15300 =ROUND(15271.382, 0) \uf0e0 15271 =ROUND(15271.385, 2) \uf0e0 15271.39 4.6.2.3.8. H\u00e0m INT - C\u00fa ph\u00e1p: =INT(number) - C\u00f4ng d\u1ee5ng: L\u00e0m tr\u00f2n number xu\u1ed1ng \u0111\u1ebfn s\u1ed1 nguy\u00ean g\u1ea7n nh\u1ea5t V\u00ed d\u1ee5: =INT(123.654) \uf0e0 123 =INT(-123.654) \uf0e0 -124 4.6.2.3.9. H\u00e0m MOD - C\u00fa ph\u00e1p: =MOD(number, divisor) - C\u00f4ng d\u1ee5ng: L\u1ea5y s\u1ed1 d\u01b0 c\u1ee7a ph\u00e9p chia s\u1ed1 number cho divisor. V\u00ed d\u1ee5: =MOD(7,2) \uf0e0 1 =MOD(9,3) \uf0e0 0 198","4.6.2.3.10. H\u00e0m RANK - C\u00fa ph\u00e1p: =RANK(number, ref, order): - C\u00f4ng d\u1ee5ng: X\u00e1c \u0111\u1ecbnh v\u00e0 tr\u1ea3 v\u1ec1 th\u1ee9 h\u1ea1ng c\u1ee7a gi\u00e1 tr\u1ecb number trong v\u00f9ng d\u1eef li\u1ec7u ref theo ph\u01b0\u01a1ng th\u1ee9c x\u1ebfp h\u1ea1ng order. Trong \u0111\u00f3: \uf0b7 V\u00f9ng d\u1eef li\u1ec7u ref ph\u1ea3i d\u00f9ng \u0111\u1ecba ch\u1ec9 tuy\u1ec7t \u0111\u1ed1i. \uf0b7 order = 0: gi\u00e1 tr\u1ecb number l\u1edbn nh\u1ea5t x\u1ebfp h\u1ea1ng 1. \uf0b7 order = 1: gi\u00e1 tr\u1ecb number nh\u1ecf nh\u1ea5t x\u1ebfp h\u1ea1ng 1. V\u00ed d\u1ee5: 4.6.2.4. H\u00e0m \u0111i\u1ec1u ki\u1ec7n IF - C\u00fa ph\u00e1p: =IF(logical_test, value if true, value if false) - C\u00f4ng d\u1ee5ng: Ki\u1ec3m tra bi\u1ec3u th\u1ee9c \u0111i\u1ec1u ki\u1ec7n logical_test: \uf0b7 N\u1ebfu l\u00e0 TRUE: tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb value if true. \uf0b7 N\u1ebfu l\u00e0 FALSE: tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb value if false. V\u00ed d\u1ee5: H\u00e0m IF \u0111\u01a1n 199","H\u00e0m IF l\u1ed3ng 4.6.2.5. C\u00e1c h\u00e0m logic (AND, OR) 4.6.2.5.1. H\u00e0m AND - C\u00fa ph\u00e1p: =AND(logical1, logical2,\u2026) - C\u00f4ng d\u1ee5ng: Ki\u1ec3m tra c\u00e1c bi\u1ec3u th\u1ee9c \u0111i\u1ec1u ki\u1ec7n logical1, 2, \u2026 v\u00e0 tr\u1ea3 v\u1ec1 True n\u1ebfu t\u1ea5t c\u1ea3 c\u00e1c bi\u1ec3u th\u1ee9c \u0111i\u1ec1u ki\u1ec7n c\u00f3 k\u1ebft qu\u1ea3 True, ng\u01b0\u1ee3c l\u1ea1i tr\u1ea3 v\u1ec1 False. V\u00ed d\u1ee5: =AND(3>2,5<8,6>5) \uf0e0 TRUE =AND(2>3,5<8,6>5) \uf0e0FALSE 4.6.2.5.2. H\u00e0m OR - C\u00fa ph\u00e1p: =OR(logical1, logical2,\u2026) - C\u00f4ng d\u1ee5ng: Ki\u1ec3m tra c\u00e1c bi\u1ec3u th\u1ee9c \u0111i\u1ec1u ki\u1ec7n logical1, 2, \u2026 v\u00e0 tr\u1ea3 v\u1ec1 True n\u1ebfu c\u00f3 \u00edt nh\u1ea5t m\u1ed9t bi\u1ec3u th\u1ee9c \u0111i\u1ec1u ki\u1ec7n c\u00f3 k\u1ebft qu\u1ea3 True, ng\u01b0\u1ee3c l\u1ea1i tr\u1ea3 v\u1ec1 False. V\u00ed d\u1ee5: =OR(3<2, 5<8,6<5) \uf0e0 TRUE =OR(3<2,8<5,6<5) \uf0e0 FALSE 4.6.2.6. C\u00e1c h\u00e0m ng\u00e0y (DAY, MONTH, YEAR, NOW) 4.6.2.6.1. H\u00e0m DAY - C\u00fa ph\u00e1p: =DAY(serial_number) - C\u00f4ng d\u1ee5ng: Tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb ng\u00e0y c\u1ee7a ng\u00e0y serial_number V\u00ed d\u1ee5: =DAY(A1) \uf0e0 13 200","4.6.2.6.2. H\u00e0m MONTH - C\u00fa ph\u00e1p: =MONTH(serial_number) - C\u00f4ng d\u1ee5ng: Tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb th\u00e1ng c\u1ee7a ng\u00e0y serial_number V\u00ed d\u1ee5: =MONTH(A1) \uf0e0 12 4.6.2.6.3. H\u00e0m YEAR: - C\u00fa ph\u00e1p: =YEAR(serial_number) - C\u00f4ng d\u1ee5ng: Tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb n\u0103m c\u1ee7a ng\u00e0y serial_number V\u00ed d\u1ee5: =YEAR(A1) \uf0e0 2018 4.6.2.6.4. H\u00e0m NOW - C\u00fa ph\u00e1p: =NOW( ) - C\u00f4ng d\u1ee5ng: Tr\u1ea3 v\u1ec1 ng\u00e0y gi\u1edd hi\u1ec7n t\u1ea1i c\u1ee7a h\u1ec7 th\u1ed1ng V\u00ed d\u1ee5: =NOW( ) \uf0e0 4.6.2.7. C\u00e1c h\u00e0m chu\u1ed7i (LEFT, RIGHT, MID, LEN, UPPER, PROPER, LOWER, VALUE) 4.6.2.7.1. H\u00e0m LEFT - C\u00fa ph\u00e1p: =LEFT(text, num_chars) - C\u00f4ng d\u1ee5ng: Tr\u00edch num_chars k\u00fd t\u1ef1 b\u00ean tr\u00e1i chu\u1ed7i text V\u00ed d\u1ee5: =LEFT(\u201cABCDE\u201d,3) \uf0e0 \u201cABC\u201d 4.6.2.7.2. H\u00e0m RIGHT - C\u00fa ph\u00e1p: =RIGHT(text, num_chars) - C\u00f4ng d\u1ee5ng: Tr\u00edch num_chars k\u00fd t\u1ef1 b\u00ean ph\u1ea3i c\u1ee7a chu\u1ed7i text V\u00ed d\u1ee5: =RIGHT(\u201cABCDE\u201d,3) \uf0e0 \u201cCDE\u201d 201","4.6.2.7.3. H\u00e0m MID - C\u00fa ph\u00e1p: =MID(text, start_num, num_chars) - C\u00f4ng d\u1ee5ng: Tr\u00edch num_chars k\u00fd t\u1ef1 b\u1eaft \u0111\u1ea7u t\u1eeb v\u1ecb tr\u00ed start_num trong chu\u1ed7i text. V\u00ed d\u1ee5: =MID(\u201cABCDE\u201d,2,3) \uf0e0 \u201cBCD\u201d 4.6.2.7.4. H\u00e0m LEN - C\u00fa ph\u00e1p: =LEN(text) - C\u00f4ng d\u1ee5ng: \u0110\u1ebfm s\u1ed1 l\u01b0\u1ee3ng k\u00fd t\u1ef1 trong chu\u1ed7i text V\u00ed d\u1ee5: =LEN(\u201cABCDE\u201d) \uf0e0 5 4.6.2.7.5. H\u00e0m UPPER - C\u00fa ph\u00e1p: =UPPER(text) - C\u00f4ng d\u1ee5ng: Chuy\u1ec3n t\u1ea5t c\u1ea3 c\u00e1c k\u00fd t\u1ef1 trong chu\u1ed7i textt th\u00e0nh ch\u1eef IN HOA. V\u00ed d\u1ee5: =UPPER(\u201cabCdE\u201d) \uf0e0 \u201cABCDE\u201d 4.6.2.7.6. H\u00e0m PROPER - C\u00fa ph\u00e1p: =PROPER(text) - C\u00f4ng d\u1ee5ng: Chuy\u1ec3n t\u1ea5t c\u1ea3 c\u00e1c k\u00fd t\u1ef1 \u0111\u1ea7u ti\u00ean c\u1ee7a m\u1ed7i t\u1eeb trong chu\u1ed7i text th\u00e0nh ch\u1eef IN HOA. V\u00ed d\u1ee5: = PROPER(\u201ckhoa c\u00f4ng ngh\u1ec7 th\u00f4ng tin\u201d) \uf0e0 \u201cKhoa C\u00f4ng Ngh\u1ec7 Th\u00f4ng Tin\u201d 4.6.2.7.7. H\u00e0m LOWER - C\u00fa ph\u00e1p: =LOWER(text) - C\u00f4ng d\u1ee5ng: Chuy\u1ec3n t\u1ea5t c\u1ea3 c\u00e1c k\u00fd t\u1ef1 trong chu\u1ed7i text th\u00e0nh ch\u1eef th\u01b0\u1eddng. V\u00ed d\u1ee5: = LOWER(\u201cabCdE\u201d) \uf0e0 \u201cabcde\u201d 4.6.2.7.8. H\u00e0m VALUE - C\u00fa ph\u00e1p: =VALUE(text) ho\u1eb7c text*1 - C\u00f4ng d\u1ee5ng: Chuy\u1ec3n d\u1eef li\u1ec7u ki\u1ec3u chu\u1ed7i text c\u00f3 d\u1ea1ng s\u1ed1 th\u00e0nh d\u1eef li\u1ec7u ki\u1ec3u s\u1ed1. V\u00ed d\u1ee5: 202","4.6.2.8. C\u00e1c h\u00e0m t\u00ecm ki\u1ebfm (VLOOKUP, HLOOKUP) 4.6.2.8.1. H\u00e0m VLOOKUP - C\u00fa ph\u00e1p: =VLOOKUP(lookup_value, table_array, column_index_num, range_lookup) - C\u00f4ng d\u1ee5ng: D\u00f2 t\u00ecm gi\u00e1 tr\u1ecb lookup_value trong s\u1ed1 c\u00e1c gi\u00e1 tr\u1ecb \u1edf c\u1ed9t \u0111\u1ea7u ti\u00ean trong b\u1ea3ng d\u00f2 table_array. N\u1ebfu t\u00ecm th\u1ea5y, tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb c\u1ed9t column_index_num v\u00e0 c\u00f9ng d\u00f2ng v\u1edbi v\u1ecb tr\u00ed t\u00ecm th\u1ea5y N\u1ebfu kh\u00f4ng t\u00ecm th\u1ea5y, tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb #N\/A - Trong \u0111\u00f3: \uf0b7 lookup_value: gi\u00e1 tr\u1ecb d\u00f2 t\u00ecm. \uf0b7 table_array: b\u1ea3ng d\u00f2 l\u00e0 v\u00f9ng c\u00f3 \u0111\u1ecba ch\u1ec9 tuy\u1ec7t \u0111\u1ed1i. C\u1ed9t \u0111\u1ea7u ti\u00ean b\u00ean tr\u00e1i ch\u1ee9a danh s\u00e1ch c\u00e1c gi\u00e1 tr\u1ecb d\u00f2 t\u00ecm. C\u00e1c c\u1ed9t c\u00f2n l\u1ea1i ch\u1ee9a gi\u00e1 tr\u1ecb t\u01b0\u01a1ng \u1ee9ng \u0111\u1ec3 tham chi\u1ebfu. \uf0b7 column_index_num: ch\u1ec9 s\u1ed1 c\u1ee7a c\u1ed9t mu\u1ed1n l\u1ea5y gi\u00e1 tr\u1ecb tr\u1ea3 v\u1ec1 trong b\u1ea3ng d\u00f2 ( c\u1ed9t \u0111\u1ea7u ti\u00ean l\u00e0 1, c\u1ed9t k\u1ebf ti\u1ebfp l\u00e0 2,\u2026 t\u00ednh t\u1eeb b\u00ean tr\u00e1i qua). \uf0b7 column_index_num >1. \uf0b7 range_lookup: gi\u00e1 tr\u1ecb ki\u1ec3u s\u1ed1 ch\u1ec9 \u0111\u1ecbnh c\u00e1ch th\u1ee9c d\u00f2 t\u00ecm: 0 (FALSE): d\u00f2 t\u00ecm gi\u00e1 tr\u1ecb \u0111\u1ea7u ti\u00ean \u0111\u00fang b\u1eb1ng lookup_value. Table_array kh\u00f4ng c\u1ea7n s\u1eafp x\u1ebfp. 1 (TRUE): t\u00ecm gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t \u2264 lookup_value. C\u1ed9t \u0111\u1ea7u ti\u00ean c\u1ee7a table_array ph\u1ea3i \u0111\u01b0\u1ee3c s\u1eafp th\u1ee9 t\u1ef1 t\u0103ng d\u1ea7n. V\u00ed d\u1ee5: 203","4.6.2.8.2. H\u00e0m HLOOKUP - C\u00fa ph\u00e1p: =HLOOKUP(lookup_value, table_array, row_index_num,range_lookup) - C\u00f4ng d\u1ee5ng: D\u00f2 t\u00ecm gi\u00e1 tr\u1ecb lookup_value trong s\u1ed1 c\u00e1c gi\u00e1 tr\u1ecb \u1edf d\u00f2ng \u0111\u1ea7u ti\u00ean trong b\u1ea3ng d\u00f2 table_array N\u1ebfu t\u00ecm th\u1ea5y, tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb d\u00f2ng row_index_num v\u00e0 c\u00f9ng c\u1ed9t v\u1edbi v\u1ecb tr\u00ed t\u00ecm th\u1ea5y. N\u1ebfu kh\u00f4ng t\u00ecm th\u1ea5y, tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb #N\/A - Trong \u0111\u00f3: \uf0b7 lookup_value: gi\u00e1 tr\u1ecb d\u00f2 t\u00ecm \uf0b7 table_array: b\u1ea3ng d\u00f2 l\u00e0 v\u00f9ng c\u00f3 \u0111\u1ecba ch\u1ec9 tuy\u1ec7t \u0111\u1ed1i. D\u00f2ng \u0111\u1ea7u ti\u00ean tr\u00ean c\u00f9ng ch\u1ee9a danh s\u00e1ch c\u00e1c gi\u00e1 tr\u1ecb d\u00f2 t\u00ecm. C\u00e1c d\u00f2ng c\u00f2n l\u1ea1i ch\u1ee9a c\u00e1c gi\u00e1 tr\u1ecb t\u01b0\u01a1ng \u1ee9ng \u0111\u1ec3 tham chi\u1ebfu. \uf0b7 row_index_num: ch\u1ec9 s\u1ed1 c\u1ee7a d\u00f2ng mu\u1ed1n l\u1ea5y gi\u00e1 tr\u1ecb tr\u1ea3 v\u1ec1 trong b\u1ea3ng d\u00f2 ( d\u00f2ng \u0111\u1ea7u ti\u00ean l\u00e0 1, d\u00f2ng k\u1ebf ti\u1ebfp l\u00e0 2,\u2026 t\u00ednh t\u1eeb tr\u00ean xu\u1ed1ng d\u01b0\u1edbi) \uf0b7 row_index_num > 1. \uf0b7 range_lookup: gi\u00e1 tr\u1ecb ki\u1ec3u s\u1ed1 ch\u1ec9 \u0111\u1ecbnh c\u00e1ch th\u1ee9c d\u00f2 t\u00ecm. 0 (FALSE): d\u00f2 t\u00ecm gi\u00e1 tr\u1ecb \u0111\u1ea7u ti\u00ean \u0111\u00fang b\u1eb1ng lookup_value. Table_array kh\u00f4ng c\u1ea7n s\u1eafp x\u1ebfp. 1 (TRUE): t\u00ecm gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t \u2264 lookup_value. D\u00f2ng \u0111\u1ea7u ti\u00ean c\u1ee7a table_array ph\u1ea3i \u0111\u01b0\u1ee3c s\u1eafp th\u1ee9 t\u1ef1 t\u0103ng d\u1ea7n. V\u00ed d\u1ee5: 204","4.6.2.9. C\u00e1c h\u00e0m c\u00f3 \u0111i\u1ec1u ki\u1ec7n (COUNTIF, SUMIF) 4.6.2.9.1. H\u00e0m COUNTIF - C\u00fa ph\u00e1p: =COUNTIF(range, criteria) - C\u00f4ng d\u1ee5ng: \u0110\u1ebfm s\u1ed1 \u00f4 c\u00f3 d\u1eef li\u1ec7u kh\u00e1c r\u1ed7ng trong v\u00f9ng range tho\u1ea3 m\u00e3n \u0111i\u1ec1u ki\u1ec7n criteria. - \u0110i\u1ec1u ki\u1ec7n criteria ph\u1ea3i \u0111\u1eb7t trong c\u1eb7p d\u1ea5u nh\u00e1y k\u00e9p \u201c\u201d v\u00e0 c\u00f3 th\u1ec3 l\u00e0: \uf0b7 Gi\u00e1 tr\u1ecb ch\u00ednh x\u00e1c, c\u1ee5 th\u1ec3 (V\u00ed d\u1ee5: \u201cA\u201d, \u201c5\u201d,\u2026) \uf0b7 Gi\u00e1 tr\u1ecb t\u01b0\u01a1ng \u0111\u1ed1i \uf0e0 d\u00f9ng c\u00e1c k\u00fd t\u1ef1 \u0111\u1ea1i di\u1ec7n ?: \u0111\u1ea1i di\u1ec7n cho 1 k\u00fd t\u1ef1. (V\u00ed d\u1ee5: \u201c?A??\u201d, \u201c?05\u201d,\u2026) *: \u0111\u1ea1i di\u1ec7n cho 1 chu\u1ed7i k\u00fd t\u1ef1 (V\u00ed d\u1ee5: \u201cA*\u201d, \u201c*05?\u201d) \uf0b7 Bi\u1ec3u th\u1ee9c so s\u00e1nh \uf0e0 d\u00f9ng c\u00e1c to\u00e1n t\u1eed so s\u00e1nh = (b\u1eb1ng), < > (kh\u00e1c), < (nh\u1ecf h\u01a1n), <= (nh\u1ecf h\u01a1n ho\u1eb7c b\u1eb1ng), > (l\u1edbn h\u01a1n), >= (l\u1edbn h\u01a1n ho\u1eb7c b\u1eb1ng) ( V\u00ed d\u1ee5: \u201c< >A\u201d, \u201c>5\u201d,\u2026) V\u00ed d\u1ee5 1: V\u00ed d\u1ee5 2: 205","V\u00ed d\u1ee5 3: 4.6.2.9.2. H\u00e0m SUMIF - C\u00fa ph\u00e1p: =SUMIF(range, criteria, sum_range) - C\u00f4ng d\u1ee5ng: C\u1ed9ng d\u1ed3n c\u00e1c \u00f4 trong v\u00f9ng sum_range m\u00e0 d\u00f2ng \u0111\u00f3 tho\u1ea3 m\u00e3n \u0111i\u1ec1u ki\u1ec7n criteria trong v\u00f9ng \u0111i\u1ec1u ki\u1ec7n range. - \u0110i\u1ec1u ki\u1ec7n criteria ph\u1ea3i \u0111\u1eb7t trong c\u1eb7p d\u1ea5u nh\u00e1y k\u00e9p \u201c\u201d v\u00e0 c\u00f3 th\u1ec3 l\u00e0: \uf0b7 Gi\u00e1 tr\u1ecb ch\u00ednh x\u00e1c, c\u1ee5 th\u1ec3 (V\u00ed d\u1ee5: \u201cA\u201d, \u201c5\u201d, \u2026) \uf0b7 Gi\u00e1 tr\u1ecb t\u01b0\u01a1ng \u0111\u1ed1i \uf0e0 d\u00f9ng c\u00e1c k\u00fd t\u1ef1 \u0111\u1ea1i di\u1ec7n + ?: \u0111\u1ea1i di\u1ec7n cho 1 k\u00fd t\u1ef1. (V\u00ed d\u1ee5: \u201c?A??\u201d, \u201c?05\u201d,\u2026) + *: \u0111\u1ea1i di\u1ec7n cho 1 chu\u1ed7i k\u00fd t\u1ef1 (V\u00ed d\u1ee5: \u201cA*\u201d, \u201c*05?\u201d) \uf0b7 Bi\u1ec3u th\u1ee9c so s\u00e1nh \uf0e0 d\u00f9ng c\u00e1c to\u00e1n t\u1eed so s\u00e1nh = (b\u1eb1ng), < > (kh\u00e1c), < (nh\u1ecf h\u01a1n), <= (nh\u1ecf h\u01a1n ho\u1eb7c b\u1eb1ng), > (l\u1edbn h\u01a1n), >= (l\u1edbn h\u01a1n ho\u1eb7c b\u1eb1ng) (V\u00ed d\u1ee5: \u201c< >A\u201d, \u201c>5\u201d,\u2026) V\u00ed d\u1ee5 1: 206","V\u00ed d\u1ee5 2: 4.7. Bi\u1ec3u \u0111\u1ed3 4.7.1. T\u1ea1o bi\u1ec3u \u0111\u1ed3 - B\u01b0\u1edbc 1. Ch\u1ecdn v\u00f9ng d\u1eef li\u1ec7u, ch\u1ecdn lu\u00f4n c\u00e1c nh\u00e3n c\u1ee7a c\u00e1c c\u1ed9t. - B\u01b0\u1edbc 2. Ch\u1ecdn ki\u1ec3u \u0111\u1ed3 th\u1ecb t\u1eeb tab Insert\/ nh\u00f3m Charts\/ ch\u1ecdn nh\u00f3m \u0111\u00f2 th\u1ecb kh\u00e1c nhau H\u00ecnh 4.9. Minh ho\u1ea1 thao t\u00e1c ch\u00e8n \u0111\u1ed3 th\u1ecb Tr\u00ean m\u00e0n h\u00ecnh xu\u1ea5t hi\u1ec7n \u0111\u1ed3 th\u1ecb t\u01b0\u01a1ng \u1ee9ng, ch\u1ecdn \u0111\u1ed3 th\u1ecb, tr\u00ean thanh Chart Tools th\u1ef1c hi\u1ec7n c\u00e1c hi\u1ec7u ch\u1ec9nh cho \u0111\u1ed3 th\u1ecb. V\u00ed d\u1ee5: Cho b\u1ea3ng d\u1eef li\u1ec7u nh\u01b0 sau: 207","4.7.2. Ch\u1ec9nh s\u1eeda, c\u1eaft d\u00e1n, di chuy\u1ec3n, x\u00f3a ti\u00eau \u0111\u1ec1 bi\u1ec3u \u0111\u1ed3 Hi\u1ec7u ch\u1ec9nh bi\u1ec3u \u0111\u1ed3 Sau khi t\u1ea1o xong bi\u1ec3u \u0111\u1ed3, ta c\u00f3 th\u1ec3 hi\u1ec7u ch\u1ec9nh bi\u1ec3u \u0111\u1ed3 nh\u01b0 thay \u0111\u1ed5i lo\u1ea1i bi\u1ec3u \u0111\u1ed3, v\u00f9ng d\u1eef li\u1ec7u, hi\u1ec7u ch\u1ec9nh c\u00e1c ti\u00eau \u0111\u1ec1, \u2026b\u1eb1ng c\u00e1ch: Nh\u1ea5p chu\u1ed9t l\u00ean bi\u1ec3u \u0111\u1ed3, ch\u1ecdn Tab Chart Tools. Design Group Chart Styles cho ph\u00e9p ch\u1ecdn Style cho bi\u1ec3u \u0111\u1ed3. Phi\u00ean b\u1ea3n Excel 2019 cung c\u1ea5p h\u1ec7 th\u1ed1ng Style cho bi\u1ec3u \u0111\u1ed3 r\u1ea5t phong ph\u00fa v\u00e0 \u0111\u1eb9p m\u1eaft. Di chuy\u1ec3n ti\u00eau \u0111\u1ec1 trong bi\u1ec3u \u0111\u1ed3 N\u1ebfu ch\u00fang ta mu\u1ed1n di chuy\u1ec3n ti\u00eau \u0111\u1ec1 sang m\u1ed9t v\u1ecb tr\u00ed kh\u00e1c trong bi\u1ec3u \u0111\u1ed3, ch\u1ecdn ti\u00eau \u0111\u1ec1 v\u00e0 k\u00e9o th\u1ea3: 208","Xo\u00e1 ti\u00eau \u0111\u1ec1 bi\u1ec3u \u0111\u1ed3 N\u1ebfu ch\u00fang ta kh\u00f4ng mu\u1ed1n b\u1ea5t k\u1ef3 ti\u00eau \u0111\u1ec1 n\u00e0o trong bi\u1ec3u \u0111\u1ed3 Excel c\u1ee7a m\u00ecnh, ch\u00fang ta c\u00f3 th\u1ec3 xo\u00e1 b\u1eb1ng 2 c\u00e1ch: - C\u00e1ch 1: Tr\u00ean tab Design, b\u1ea5m v\u00e0o Add Chart Element \uf0e0 Chart Title \uf0e0 None - C\u00e1ch 2: Tr\u00ean bi\u1ec3u \u0111\u1ed3, Nh\u1ea5p chu\u1ed9t ph\u1ea3i v\u00e0o ti\u00eau \u0111\u1ec1 bi\u1ec3u \u0111\u1ed3, v\u00e0 ch\u1ecdn Delete trong tr\u00ecnh \u0111\u01a1n ng\u1eef c\u1ea3nh. 209","4.8. K\u1ebft xu\u1ea5t v\u00e0 ph\u00e2n ph\u1ed1i trang t\u00ednh, b\u1ea3ng t\u00ednh 4.8.1. Tr\u00ecnh b\u00e0y trang t\u00ednh \u0111\u1ec1 in V\u00e0o tab Page Layout \uf0e0 nh\u00f3m Page Setup Ch\u1ecdn h\u01b0\u1edbng gi\u1ea5y in d\u1ecdc\/ ngang T\u1ec9 l\u1ec7 in Ch\u1ecdn kh\u1ed5 gi\u1ea5y Ch\u1ea5t l\u01b0\u1ee3ng in 210","Ch\u1ecdn Ch\u1ecdn Header c\u00f3 s\u1eb5n Ch\u1ecdn Footer Header Ch\u1ecdn Footer c\u00f3 s\u1eb5n tu\u1ef3 \u00fd tu\u1ef3 \u00fd 211","\u0110\u1ecba ch\u1ec9 v\u00f9ng in \u0110\u1ecba ch\u1ec9 d\u00f2ng l\u1eb7p l\u1ea1i \u1edf \u0111\u1ea7u t\u1ea5t c\u1ea3 c\u00e1c trang \u0110\u1ecba ch\u1ec9 c\u1ed9t l\u1eb7p l\u1ea1i \u1edf b\u00ean tr\u00e1i t\u1ea5t c\u1ea3 c\u00e1c trang 4.8.2. Ki\u1ec3m tra v\u00e0 in Print Preview and Print tr\u00ean Nh\u1ea5p chu\u1ed9t t\u1ea1i bi\u1ec3u t\u01b0\u1ee3ng - Print: nh\u1ea5p v\u00e0o s\u1ebd in ra m\u00e1y in 212","- Copies: S\u1ed1 b\u1ea3n in - Printer: ch\u1ecdn lo\u1ea1i m\u00e1y in t\u1eeb danh s\u00e1ch li\u1ec7t k\u00ea - Settings: g\u1ed3m c\u00f3 c\u00e1c ch\u1ecdn l\u1ef1a sau - Print Active Sheets: in b\u1ea3ng t\u00ednh hi\u1ec7n h\u00e0nh, ho\u1eb7c ch\u1ecdn \uf0b7 Print Selection: In v\u00f9ng \u0111\u01b0\u1ee3c ch\u1ecdn \uf0b7 Print Entire workbook: In to\u00e0n b\u1ed9 Workbook \uf0b7 Print Active Sheet: In Sheet hi\u1ec7n h\u00e0nh - Page \u0111\u1ec3 in m\u1ed9t s\u1ed1 trang From < s\u1ed1> t\u1eeb trang s\u1ed1 To < s\u1ed1> \u0111\u1ebfn trang s\u1ed1 - Collated: ch\u1ecdn in xong c\u00e1c trang c\u1ee7a m\u1ed9t b\u1ea3n in r\u1ed3i m\u1edbi in ti\u1ebfp b\u1ea3n k\u1ebf, ho\u1eb7c ch\u1ecdn in t\u1eebng trang cho c\u00e1c b\u1ea3n in r\u1ed3i in trang k\u1ebf cho c\u00e1c b\u1ea3n \u2026 - Portrait Orientation: ch\u1ecdn in \u0111\u1ee9ng theo kh\u1ed5 gi\u1ea5y hay in ngang Landscape - Normal Margins: ch\u1ecdn canh l\u1ec1 cho trang in - No Scaling: ch\u1ecdn in nh\u01b0 b\u1ea3ng t\u00ednh th\u1ef1c t\u1ea1i hay ch\u1ecdn \uf0b7 Fit Sheet on One Page: ch\u1ec9nh in b\u1ea3ng t\u00ednh v\u00e0o m\u1ed9t trang \uf0b7 Fit All Columns on One Page: ch\u1ec9nh in t\u1ea5t c\u1ea3 c\u00e1c c\u1ed9t v\u00e0o m\u1ed9t trang \uf0b7 Fit All Rows on One Page: ch\u1ec9nh in t\u1ea5t c\u1ea3 c\u00e1c d\u00f2ng v\u00e0o m\u1ed9t trang 4.8.3. Ph\u00e2n ph\u1ed1i trang in 4.8.3.1. L\u01b0u trang t\u00ednh, b\u1ea3ng t\u00ednh d\u01b0\u1edbi c\u00e1c ki\u1ec3u t\u1eadp tin kh\u00e1c nhau 4.8.3.1.1. C\u00e1ch l\u01b0u m\u1ed9t b\u1ea3ng t\u00ednh d\u01b0\u1edbi d\u1ea1ng t\u1eadp tin PDF - B\u01b0\u1edbc 1: Nh\u1ea5p chu\u1ed9t v\u00e0o tab File \u0111\u1ec3 truy c\u1eadp v\u00e0 Backstage view - B\u01b0\u1edbc 2: Nh\u1ea5p chu\u1ed9t v\u00e0o Export, sau \u0111\u00f3 ch\u1ecdn Create PDF\/XPS 213","- B\u01b0\u1edbc 3: H\u1ed9p tho\u1ea1i Save As s\u1ebd xu\u1ea5t hi\u1ec7n. Ch\u1ecdn v\u1ecb tr\u00ed mu\u1ed1n l\u01b0u b\u1ea3ng t\u00ednh, nh\u1eadp t\u00ean t\u1eadp tin, sau \u0111\u00f3 Nh\u1ea5p chu\u1ed9t v\u00e0o Publish Theo m\u1eb7c \u0111\u1ecbnh, Excel s\u1ebd ch\u1ec9 xu\u1ea5t b\u1ea3ng t\u00ednh \u0111ang l\u00e0m vi\u1ec7c. N\u1ebfu ch\u00fang ta c\u00f3 nhi\u1ec1u b\u1ea3ng t\u00ednh v\u00e0 mu\u1ed1n l\u01b0u t\u1ea5t c\u1ea3 ch\u00fang trong c\u00f9ng m\u1ed9t t\u1eadp tin PDF, h\u00e3y Nh\u1ea5p chu\u1ed9t v\u00e0o Options. T\u00f9y ch\u1ecdn trong h\u1ed9p tho\u1ea1i Save As. H\u1ed9p tho\u1ea1i Options s\u1ebd xu\u1ea5t hi\u1ec7n. Ch\u1ecdn Entire workbook(to\u00e0n b\u1ed9 b\u1ea3ng t\u00ednh), sau \u0111\u00f3 nh\u1ea5n OK. 214","4.8.3.1.2. C\u00e1ch l\u01b0u m\u1ed9t b\u1ea3ng t\u00ednh d\u01b0\u1edbi d\u1ea1ng t\u1eadp tin kh\u00e1c - B\u01b0\u1edbc 1: Nh\u1ea5p chu\u1ed9t v\u00e0o tab File \u0111\u1ec3 truy c\u1eadp v\u00e0o Backstage view - B\u01b0\u1edbc 2: Nh\u1ea5p chu\u1ed9t v\u00e0o Export, sau \u0111\u00f3 ch\u1ecdn Change File Type - B\u01b0\u1edbc 3: Ch\u1ecdn m\u1ed9t lo\u1ea1i t\u1eadp tin ph\u1ed5 bi\u1ebfn, sau \u0111\u00f3 Nh\u1ea5p chu\u1ed9t v\u00e0o Save As. 215","- B\u01b0\u1edbc 4: H\u1ed9p tho\u1ea1i Save As s\u1ebd xu\u1ea5t hi\u1ec7n. Ch\u1ecdn v\u1ecb tr\u00ed mu\u1ed1n l\u01b0u b\u1ea3ng t\u00ednh, nh\u1eadp t\u00ean t\u1eadp tin, sau \u0111\u00f3 Nh\u1ea5p chu\u1ed9t v\u00e0o Save. Ch\u00fang ta c\u0169ng c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng tr\u00ecnh \u0111\u01a1n th\u1ea3 xu\u1ed1ng Save As Type: trong h\u1ed9p tho\u1ea1i Save As \u0111\u1ec3 l\u01b0u c\u00e1c b\u1ea3ng t\u00ednh trong nhi\u1ec1u lo\u1ea1i t\u1eadp tin. 216","4.8.3.2. B\u1ea3o m\u1eadt t\u1eadp tin, \u0111\u1eb7t m\u1eadt kh\u1ea9u b\u1ea3o v\u1ec7 t\u1eadp tin - B\u01b0\u1edbc 1: \u0110\u1ea7u ti\u00ean m\u1edf t\u1eadp tin c\u1ea7n b\u1ea3o m\u1eadt - B\u01b0\u1edbc 2: Ch\u1ecdn tab File \uf0e0 Info \uf0e0 Protect Workbook \uf0e0 Encrypt with Password - B\u01b0\u1edbc 3: T\u1ea1i \u0111\u00e2y nh\u1eadp m\u1eadt kh\u1ea9u \u0111\u1ec3 b\u1ea3o v\u1ec7 cho t\u1eadp tin Ti\u1ebfp \u0111\u1ebfn nh\u1eadp th\u00eam l\u1ea7n n\u1eefa \u0111\u1ec3 x\u00e1c nh\u1eadn m\u1eadt kh\u1ea9u 217","- B\u01b0\u1edbc 4: Sau c\u00e1c b\u01b0\u1edbc tr\u00ean ch\u00fang ta ho\u00e0n t\u1ea5t vi\u1ec7c b\u1ea3o m\u1eadt cho t\u1eadp tin. Khi m\u1edf t\u1eadp tin, ch\u00fang ta s\u1ebd ph\u1ea3i nh\u1eadp m\u1eadt kh\u1ea9u m\u1edbi c\u00f3 th\u1ec3 truy xu\u1ea5t \u0111\u01b0\u1ee3c 4.8.3.3. \u0110\u00ednh k\u00e8m trang t\u00ednh theo th\u01b0 \u0111i\u1ec7n t\u1eed - - B\u01b0\u1edbc 1: Nh\u1ea5p chu\u1ed9t v\u00e0o tab File \u0111\u1ec3 truy c\u1eadp v\u00e0o Backstage view, sau \u0111\u00f3 Nh\u1ea5p chu\u1ed9t v\u00e0o Share - B\u01b0\u1edbc 2: C\u1eeda s\u1ed5 Share xu\u1ea5t hi\u1ec7n. N\u1ebfu ch\u00fang ta ch\u01b0a ho\u00e0n th\u00e0nh b\u1ea3ng t\u00ednh, ch\u00fang ta s\u1ebd \u0111\u01b0\u1ee3c nh\u1eafc l\u01b0u t\u00e0i li\u1ec7u c\u1ee7a m\u00ecnh v\u00e0o OneDrive 218","\uf0b7 L\u01b0u \u00fd r\u1eb1ng ch\u00fang ta c\u00f3 th\u1ec3 c\u1ea7n ph\u1ea3i \u0111i\u1ec1u h\u01b0\u1edbng tr\u1edf l\u1ea1i c\u1eeda s\u1ed5 Share sau khi l\u01b0u - B\u01b0\u1edbc 3: Tr\u00ean c\u1eeda s\u1ed5 Share, n\u1ebfu t\u00e0i li\u1ec7u c\u1ee7a \u0111\u01b0\u1ee3c l\u01b0u v\u00e0o OneDrive, h\u00e3y Nh\u1ea5p chu\u1ed9t v\u00e0o n\u00fat Share with People (Chia s\u1ebb v\u1edbi m\u1ecdi ng\u01b0\u1eddi). - B\u01b0\u1edbc 4: Excel s\u1ebd tr\u1edf l\u1ea1i ch\u1ebf \u0111\u1ed9 xem b\u00ecnh th\u01b0\u1eddng v\u00e0 m\u1edf c\u1eeda s\u1ed5 Share \u1edf ph\u00eda b\u00ean ph\u1ea3i c\u1eeda s\u1ed5. T\u1ea1i \u0111\u00e2y, ch\u00fang ta c\u00f3 th\u1ec3 m\u1eddi m\u1ecdi ng\u01b0\u1eddi chia s\u1ebb t\u00e0i li\u1ec7u c\u1ee7a m\u00ecnh, xem danh s\u00e1ch nh\u1eefng ng\u01b0\u1eddi c\u00f3 quy\u1ec3n truy c\u1eadp v\u00e0o t\u00e0i li\u1ec7u v\u00e0 \u0111\u1eb7t xem h\u1ecd c\u00f3 th\u1ec3 ch\u1ec9nh s\u1eeda hay ch\u1ec9 xem t\u00e0i li\u1ec7u. 219","4.8.3.4. L\u01b0u trang t\u00ednh tr\u00ean m\u1ea1ng - B\u01b0\u1edbc 1: c\u1eadp theo \u0111\u01b0\u1eddng link b\u00ean d\u01b0\u1edbi \u0111\u1ec3 \u0111\u0103ng nh\u1eadp v\u00e0o Google Drive th\u00f4ng qua t\u00e0i kho\u1ea3n Google. (https:\/\/www.google.com\/drive\/) - B\u01b0\u1edbc 2: \u0110\u0103ng nh\u1eadp t\u00e0i kho\u1ea3n Google c\u1ee7a m\u00ecnh. Nh\u1ea5p chu\u1ed9t \u0110\u0103ng nh\u1eadp 220","- B\u01b0\u1edbc 3: Giao di\u1ec7n Google Drive xu\u1ea5t hi\u1ec7n. \u0110\u1ec3 t\u00e0i th\u01b0 m\u1ee5c l\u00ean, ch\u00fang ta Nh\u1ea5p chu\u1ed9t v\u00e0o ph\u1ea7n Drive c\u1ee7a t\u00f4i. T\u1ea1i \u0111\u00e2y s\u1ebd c\u00f3 nhi\u1ec1u l\u1ef1a ch\u1ecdn: \uf0b7 Th\u01b0 m\u1ee5c m\u1edbi: t\u1ea1o th\u01b0 m\u1ee5c m\u1edbi trong Drive. \uf0b7 T\u1ea3i l\u00ean t\u1ec7p: t\u1ea3i t\u1eadp tin t\u1eeb m\u00e1y t\u00ednh \uf0b7 T\u1ea3i l\u00ean th\u01b0 m\u1ee5c: t\u1ea3i th\u01b0 m\u1ee5c c\u00f3 trong m\u00e1y t\u00ednh - B\u01b0\u1edbc 4: Ngay khi ch\u00fang ta ch\u1ecdn lo\u1ea1i file, Google s\u1ebd ti\u1ebfn h\u00e0nh t\u1ea3i file. Khi xu\u1ea5t hi\u1ec7n d\u1ea5u t\u00edch \u1edf m\u1ed7i file, ngh\u0129a l\u00e0 qu\u00e1 tr\u00ecnh t\u1ea3i file l\u00ean Google Drive \u0111\u00e3 ho\u00e0n th\u00e0nh xong 221","C\u00c1C \u0110I\u1ec2M CH\u00cdNH - \u0110\u1ecbnh d\u1ea1ng b\u1ea3ng t\u00ednh. - Nh\u00f3m h\u00e0m v\u1ec1 ng\u00e0y. - Nh\u00f3m h\u00e0m v\u1ec1 th\u1ed1ng k\u00ea. - Nh\u00f3m h\u00e0m v\u1ec1 chu\u1ed7i. - H\u00e0m IF(), OR(), AND(). - Nh\u00f3m h\u00e0m d\u00f2 t\u00ecm. - T\u1ea1o bi\u1ec3u \u0111\u1ed3 . C\u00c2U H\u1eceI \u00d4N T\u1eacP C\u00e2u 1: Trong b\u1ea3ng t\u00ednh Excel, t\u1ea1i \u00f4 A2 c\u00f3 s\u1eb5n gi\u00e1 tr\u1ecb chu\u1ed7i \\\"Tin hoc\\\"; \u00f4 B2 c\u00f3 gi\u00e1 tr\u1ecb s\u1ed1 2008. T\u1ea1i \u00f4 C2 g\u00f5 v\u00e0o c\u00f4ng th\u1ee9c =A2+B2 th\u00ec nh\u1eadn \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3: A. #VALUE! B. Tin hoc C. 2008 D. Tin hoc2008 C\u00e2u 2: Khi \u0111ang l\u00e0m vi\u1ec7c v\u1edbi Excel, t\u1ed5 h\u1ee3p ph\u00edm n\u00e0o cho ph\u00e9p ngay l\u1eadp t\u1ee9c \u0111\u01b0a con tr\u1ecf v\u1ec1 \u00f4 \u0111\u1ea7u ti\u00ean (\u00f4 A1) c\u1ee7a b\u1ea3ng t\u00ednh ? A. Shift+Home B. Alt+Home C. Ctrl+Home D. Shift+Ctrl+Home C\u00e2u 3: Trong khi l\u00e0m vi\u1ec7c v\u1edbi Excel, \u0111\u1ec3 nh\u1eadp v\u00e0o c\u00f4ng th\u1ee9c t\u00ednh to\u00e1n cho m\u1ed9t \u00f4, tr\u01b0\u1edbc h\u1ebft ta ph\u1ea3i g\u00f5: A. D\u1ea5u ch\u1ea5m h\u1ecfi (?) B. D\u1ea5u b\u1eb1ng (=) C. D\u1ea5u hai ch\u1ea5m (:) D. D\u1ea5u \u0111\u00f4 la ($) 222","C\u00e2u 4: Ph\u00e1t bi\u1ec3u n\u00e0o sau \u0111\u00e2y \u0111\u00fang? A. Bi\u1ec3u \u0111\u1ed3 c\u1ed9t r\u1ea5t th\u00edch h\u1ee3p \u0111\u1ec3 so s\u00e1nh d\u1eef li\u1ec7u c\u00f3 trong nhi\u1ec1u c\u1ed9t B. Bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n r\u1ea5t th\u00edch h\u1ee3p \u0111\u1ec3 m\u00f4 t\u1ea3 t\u1ec9 l\u1ec7 c\u1ee7a gi\u00e1 tr\u1ecb d\u1eef li\u1ec7u so v\u1edbi t\u1ed5ng th\u1ec3 C. Bi\u1ec3u \u0111\u1ed3 \u0111\u01b0\u1eddng g\u1ea5p kh\u00fac d\u00f9ng so s\u00e1nh d\u1eef li\u1ec7u v\u00e0 d\u1ef1 \u0111o\u00e1n xu th\u1ebf t\u0103ng hay gi\u1ea3m c\u1ee7a d\u1eef li\u1ec7u D. C\u1ea3 3 c\u00e2u \u0111\u1ec1u \u0111\u00fang C\u00e2u 5: Trong Excel, t\u1ea1i \u00f4 A2 c\u00f3 gi\u00e1 tr\u1ecb l\u00e0 chu\u1ed7i TINHOC. T\u1ea1i \u00f4 B2 g\u00f5 c\u00f4ng th\u1ee9c =RIGHT(A2,3) th\u00ec nh\u1eadn \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 ? A. 3 B. HOC C. TIN D. Tinhoc C\u00e2u 6: Trong khi l\u00e0m vi\u1ec7c v\u1edbi Excel, mu\u1ed1n l\u01b0u b\u1ea3ng t\u00ednh hi\u1ec7n th\u1eddi v\u00e0o \u0111\u0129a, ta th\u1ef1c hi\u1ec7n? A. tab Home \u2013 Save B. tab View \u2013 Save C. tab Review \u2013 Save D. tab File \u2013 Save C\u00e2u 7: C\u00e2u n\u00e0o sau \u0111\u00e2y sai? Khi nh\u1eadp d\u1eef li\u1ec7u v\u00e0o b\u1ea3ng t\u00ednh Excel th\u00ec: A. D\u1eef li\u1ec7u ki\u1ec3u s\u1ed1 s\u1ebd m\u1eb7c nhi\u00ean c\u0103n th\u1eb3ng l\u1ec1 tr\u00e1i B. D\u1eef li\u1ec7u ki\u1ec3u k\u00fd t\u1ef1 s\u1ebd m\u1eb7c nhi\u00ean c\u0103n th\u1eb3ng l\u1ec1 tr\u00e1i C. D\u1eef li\u1ec7u ki\u1ec3u th\u1eddi gian s\u1ebd m\u1eb7c nhi\u00ean c\u0103n th\u1eb3ng l\u1ec1 ph\u1ea3i D. D\u1eef li\u1ec7u ki\u1ec3u ng\u00e0y th\u00e1ng s\u1ebd m\u1eb7c nhi\u00ean c\u0103n th\u1eb3ng l\u1ec1 ph\u1ea3i C\u00e2u 8: Trong b\u1ea3ng t\u00ednh Excel, t\u1ea1i \u00f4 A2 c\u00f3 s\u1eb5n gi\u00e1 tr\u1ecb s\u1ed1 kh\u00f4ng (0); T\u1ea1i \u00f4 B2 g\u00f5 v\u00e0o c\u00f4ng th\u1ee9c =5\/A2 th\u00ec nh\u1eadn \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3: A. 0 B. 5 C. #VALUE! D. #DIV\/0! C\u00e2u 9: Trong c\u00e1c d\u1ea1ng \u0111\u1ecba ch\u1ec9 sau \u0111\u00e2y, \u0111\u1ecba ch\u1ec9 n\u00e0o l\u00e0 \u0111\u1ecba ch\u1ec9 tuy\u1ec7t \u0111\u1ed1i? A. B$1:D$10 B. $B1:$D10 223","C. B$1$:D$10$ D. $B$1:$D$10 C\u00e2u 10: Trong b\u1ea3ng t\u00ednh Excel, \u0111i\u1ec1u ki\u1ec7n trong h\u00e0m IF \u0111\u01b0\u1ee3c ph\u00e1t bi\u1ec3u d\u01b0\u1edbi d\u1ea1ng m\u1ed9t ph\u00e9p so s\u00e1nh. Khi c\u1ea7n so s\u00e1nh kh\u00e1c nhau th\u00ec s\u1eed d\u1ee5ng k\u00fd hi\u1ec7u n\u00e0o? A. # B. <> C. >< D. & C\u00e2u 11: Trong b\u1ea3ng t\u00ednh Excel, t\u1ea1i \u00f4 A2 g\u00f5 v\u00e0o c\u00f4ng th\u1ee9c =IF(3>5,100,IF(5<6,200,300)) th\u00ec k\u1ebft qu\u1ea3 nh\u1eadn \u0111\u01b0\u1ee3c t\u1ea1i \u00f4 A2 l\u00e0: A. 200 B. 100 C. 300 D. False C\u00e2u 12: Trong Excel, t\u1ea1i \u00f4 A2 c\u00f3 gi\u00e1 tr\u1ecb l\u00e0 chu\u1ed7i TINHOC. T\u1ea1i \u00f4 B2 g\u00f5 c\u00f4ng th\u1ee9c =LEFT(A2,3) th\u00ec nh\u1eadn \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 ? A. Tinhoc B. 3 C. HOC D. TIN C\u00e2u 13: \u0110\u1ec3 chu\u1ea9n b\u1ecb in m\u1ed9t b\u1ea3ng t\u00ednh Excel ra gi\u1ea5y ? A. Excel b\u1eaft bu\u1ed9c ph\u1ea3i \u0111\u00e1nh s\u1ed1 trang \u1edf v\u1ecb tr\u00ed b\u00ean ph\u1ea3i \u0111\u1ea7u m\u1ed7i trang B. C\u00f3 th\u1ec3 khai b\u00e1o \u0111\u00e1nh s\u1ed1 trang in ho\u1eb7c kh\u00f4ng C. Ch\u1ec9 \u0111\u00e1nh s\u1ed1 trang in n\u1ebfu b\u1ea3ng t\u00ednh g\u1ed3m nhi\u1ec1u trang D. V\u1ecb tr\u00ed c\u1ee7a s\u1ed1 trang lu\u00f4n lu\u00f4n \u1edf g\u00f3c d\u01b0\u1edbi b\u00ean ph\u1ea3i C\u00e2u 14: Trong b\u1ea3ng t\u00ednh Excel, giao c\u1ee7a m\u1ed9t h\u00e0ng v\u00e0 m\u1ed9t c\u1ed9t \u0111\u01b0\u1ee3c g\u1ecdi l\u00e0? A. D\u1eef li\u1ec7u B. \u00d4 C. Tr\u01b0\u1eddng D. C\u00f4ng th\u1ee9c 224","C\u00e2u 15: Trong Excel, t\u1ea1i \u00f4 A2 c\u00f3 gi\u00e1 tr\u1ecb l\u00e0 s\u1ed1 10 ; \u00f4 B2 c\u00f3 gi\u00e1 tr\u1ecb l\u00e0 s\u1ed1 3. T\u1ea1i \u00f4 C2 g\u00f5 c\u00f4ng th\u1ee9c =MOD(A2,B2) th\u00ec nh\u1eadn \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3: A. 10 B. 3 C. #Value D. 1 C\u00e2u 16: Trong b\u1ea3ng t\u00ednh Excel, t\u1ea1i \u00f4 D2 c\u00f3 c\u00f4ng th\u1ee9c =B2*C2\/100. N\u1ebfu sao ch\u00e9p c\u00f4ng th\u1ee9c \u0111\u1ebfn \u00f4 G6 th\u00ec s\u1ebd c\u00f3 c\u00f4ng th\u1ee9c l\u00e0: A. E7*F7\/100 B. B6*C6\/100 C. E6*F6\/100 D. E2*C2\/100 C\u00e2u 17: Trong b\u1ea3ng t\u00ednh Excel, \u0111\u1ec3 s\u1eeda d\u1eef li\u1ec7u trong m\u1ed9t \u00f4 t\u00ednh m\u00e0 kh\u00f4ng c\u1ea7n nh\u1eadp l\u1ea1i, ta th\u1ef1c hi\u1ec7n: A. Nh\u00e1y chu\u1ed9t ch\u1ecdn \u00f4 t\u00ednh c\u1ea7n s\u1eeda, r\u1ed3i b\u1ea5m ph\u00edm F2 B. Nh\u00e1y chu\u1ed9t ch\u1ecdn \u00f4 t\u00ednh c\u1ea7n s\u1eeda, r\u1ed3i b\u1ea5m ph\u00edm F4 C. Nh\u00e1y chu\u1ed9t ch\u1ecdn \u00f4 t\u00ednh c\u1ea7n s\u1eeda, r\u1ed3i b\u1ea5m ph\u00edm F10 D. Nh\u00e1y chu\u1ed9t ch\u1ecdn \u00f4 t\u00ednh c\u1ea7n s\u1eeda, r\u1ed3i b\u1ea5m ph\u00edm F12 C\u00e2u 18: C\u00e1c ki\u1ec3u d\u1eef li\u1ec7u th\u00f4ng d\u1ee5ng c\u1ee7a Excel l\u00e0: A. Ki\u1ec3u chu\u1ed7i, ki\u1ec3u v\u0103n b\u1ea3n, ki\u1ec3u ng\u00e0y th\u00e1ng B. Ki\u1ec3u chu\u1ed7i, ki\u1ec3u s\u1ed1, ki\u1ec3u logic, ki\u1ec3u ng\u00e0y th\u00e1ng, ki\u1ec3u c\u00f4ng th\u1ee9c C. Ki\u1ec3u s\u1ed1, ki\u1ec3u logic, ki\u1ec3u ng\u00e0y th\u00e1ng D. Ki\u1ec3u c\u00f4ng th\u1ee9c, ki\u1ec3u h\u00e0m, ki\u1ec3u s\u1ed1, ki\u1ec3u ng\u00e0y th\u00e1ng C\u00e2u 19: Trong b\u1ea3ng t\u00ednh Excel, mu\u1ed1n x\u00f3a h\u1eb3n m\u1ed9t h\u00e0ng ra kh\u1ecfi trang t\u00ednh, ta \u0111\u00e1nh d\u1ea5u kh\u1ed1i ch\u1ecdn h\u00e0ng n\u00e0y v\u00e0 th\u1ef1c hi\u1ec7n: A. Home \u2013 Delete \u2013 Delete Sheet Rows B. Nh\u1ea5n ph\u00edm Delete C. View - Delete D. Insert \u2013 Delete C\u00e2u 20: Trong Excel, khi vi\u1ebft sai t\u00ean h\u00e0m trong t\u00ednh to\u00e1n, ch\u01b0\u01a1ng tr\u00ecnh th\u00f4ng b\u00e1o l\u1ed7i? A. #NAME! 225","B. #VALUE! C\u00e2u 6: D C\u00e2u 11: A C\u00e2u 16: C C. #N\/A! C\u00e2u 7: A C\u00e2u 12: D C\u00e2u 17: A D. #DIV\/0! C\u00e2u 8: D C\u00e2u 13: B C\u00e2u 18: B \u0110\u00e1p \u00e1n: C\u00e2u 9: D C\u00e2u 14: B C\u00e2u 19: A C\u00e2u 10: B C\u00e2u 15: D C\u00e2u 20: A C\u00e2u 1: A C\u00e2u 2: C C\u00e2u 3: B C\u00e2u 4: D C\u00e2u 5: B B\u00c0I T\u1eacP B\u00e0i 1: Nh\u1eadp v\u00e0 \u0111\u1ecbnh d\u1ea1ng b\u1ea3ng t\u00ednh Y\u00eau c\u1ea7u: 1. T\u00ednh t\u1ed5ng \u0111i\u1ec3m = TO\u00c1N + L\u00dd + HO\u00c1 (C\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m SUM) 2. \u0110i\u1ec3m trung b\u00ecnh = (TO\u00c1N + L\u00dd + HO\u00c1)\/3 3. L\u00e0m tr\u00f2n \u0110I\u1ec2M TRUNG B\u00ccNH l\u1ea5y 2 s\u1ed1 l\u1ebb 226","B\u00e0i 2: Nh\u1eadp v\u00e0 \u0111\u1ecbnh d\u1ea1ng b\u1ea3ng t\u00ednh Y\u00eau c\u1ea7u: 1. Th\u00e0nh ti\u1ec1n = S\u1ed0 L\u01af\u1ee2NG* \u0110\u01a0N GI\u00c1 2. T\u1ed5ng c\u1ed9ng = TH\u00c0NH TI\u1ec0N- PH\u00cd CHUY\u00caN CH\u1ede 3. \u0110\u1ecbnh d\u1ea1ng c\u1ed9t T\u1ed5ng c\u1ed9ng c\u00f3 \u0111\u01a1n v\u1ecb VN\u0110 B\u00e0i 3: Nh\u1eadp v\u00e0 \u0111\u1ecbnh d\u1ea1ng b\u1ea3ng t\u00ednh Y\u00eau c\u1ea7u: 1. \u0110i\u1ec1u ch\u1ec9nh trong m\u00f4i tr\u01b0\u1eddng Windows \u0111\u1ec3 nh\u1eadp ng\u00e0y ki\u1ec3u dd\/mm\/yy 2. L\u1ec7 ph\u00ed = S\u1ed0 NG\u00c0Y L\u01afU KHO * GI\u00c1 L\u01afU KHO (s\u1eed d\u1ee5ng \u0111\u1ecba ch\u1ec9 c\u1ed1 \u0111\u1ecbnh) 3. \u0110\u1ecbnh d\u1ea1ng c\u1ed9t l\u1ec7 ph\u00ed c\u00f3 d\u1ea5u ph\u00e2n c\u00e1ch h\u00e0ng ngh\u00ecn v\u00e0 \u0111\u01a1n v\u1ecb ti\u1ec1n t\u1ec7 VN\u0110 \u0111\u1eb7t sau s\u1ed1 ti\u1ec1n B\u00e0i 4: Nh\u1eadp v\u00e0 \u0111\u1ecbnh d\u1ea1ng b\u1ea3ng t\u00ednh 227","Y\u00eau c\u1ea7u: 1. T\u00ednh Th\u1eddi gian thu\u00ea b\u1eb1ng Gi\u1edd tr\u1ea3 tr\u1eeb Gi\u1edd thu\u00ea 2. T\u00ednh Th\u00e0nh ti\u1ec1n B\u00e0i 5: Nh\u1eadp v\u00e0 \u0111\u1ecbnh d\u1ea1ng b\u1ea3ng t\u00ednh Y\u00eau c\u1ea7u: 1. Th\u00e0nh ti\u1ec1n c\u1ee7a (m\u1ed7i \u0111\u01a1n v\u1ecb) = S\u1ed1 l\u01b0\u1ee3ng (c\u1ee7a m\u1ed7i \u0111\u01a1n v\u1ecb)*\u0110\u01a1n gi\u00e1 2. T\u1ed5ng ti\u1ec1n c\u1ee7a t\u1eebng m\u1eb7t h\u00e0ng (a) = T\u1ed5ng TTI\u1ec0N c\u1ee7a 3 \u0111\u01a1n v\u1ecb 3. C\u1ed9ng TTI\u1ec0N c\u1ee7a m\u1ed7i \u0111\u01a1n v\u1ecb (b) = T\u1ed5ng TTI\u1ec0N c\u1ee7a 3 m\u1eb7t h\u00e0ng 4. T\u00ednh t\u1ed5ng tr\u1ecb gi\u00e1 c\u1ee7a 3 m\u1eb7t h\u00e0ng v\u00e0 c\u1ee7a 3 \u0111\u01a1n v\u1ecb t\u1ea1i \u00f4 (c) 5. T\u1ec9 l\u1ec7 = T\u1ed5ng ti\u1ec1n c\u1ee7a t\u1eebng m\u1eb7t h\u00e0ng(a) \/t\u1ed5ng tr\u1ecb gi\u00e1 c\u1ee7a 3 m\u1eb7t h\u00e0ng (c) . \u0110\u1ecbnh d\u1ea1ng c\u1ed9t t\u1ec9 l\u1ec7 ki\u1ec3u ph\u1ea7n tr\u0103m v\u00e0 2 s\u1ed1 l\u1ebb B\u00e0i 6: Nh\u1eadp v\u00e0 \u0111\u1ecbnh d\u1ea1ng b\u1ea3ng t\u00ednh 228","B\u00e0i 7: L\u1eadp v\u00e0 \u0111\u1ecbnh d\u1ea1ng b\u1ea3ng t\u00ednh B\u00e0i 8: T\u1ea1o v\u00e0 \u0111\u1ecbnh d\u1ea1ng b\u1ea3ng t\u00ednh \u00dd ngh\u0129a MSNV - 2 K\u00fd t\u1ef1 \u0111\u1ea7u: S\u1ed1 TT - K\u00fd t\u1ef1 th\u1ee9 3: M\u00e3 s\u1ed1 ch\u1ee9c v\u1ee5 ( A: Gi\u00e1m \u0111\u1ed1c, B: Ph\u00f3 G\u0110, C: Tr\u01b0\u1edfng Ph\u00f2ng, D: Nh\u00e2n vi\u00ean) 229","Y\u00eau c\u1ea7u: 1. T\u00ednh c\u1ed9t ch\u1ee9c v\u1ee5 v\u00e0 ph\u00f2ng ban 2. T\u00ednh c\u1ed9t L\u01b0\u01a1ng CB, bi\u1ebft r\u1eb1ng L\u01b0\u01a1ng CB c\u1ee7a: Gi\u00e1m \u0111\u1ed1c = 500000, Ph\u00f3 G\u0110 = 450000, Tr\u01b0\u1edfng ph\u00f2ng = 400000, Nh\u00e2n vi\u00ean = 300000 3. T\u00ednh l\u01b0\u01a1ng ch\u00ednh, bi\u1ebft r\u1eb1ng L\u01b0\u01a1ng ch\u00ednh = L\u01b0\u01a1ng CB * H\u1ec7 s\u1ed1 4. T\u00ednh ph\u1ee5 c\u1ea5p ch\u1ee9c v\u1ee5 ( PCCV). Bi\u1ebft r\u1eb1ng PCCV c\u1ee7a: Gi\u00e1m \u0111\u1ed1c l\u00e0 200000, Ph\u00f3 G\u0110 l\u00e0 150000, Tr\u01b0\u1edfng ph\u00f2ng l\u00e0 100000, Nh\u00e2n vi\u00ean kh\u00f4ng c\u00f3 ph\u1ee5 c\u1ea5p 5. T\u00ednh c\u1ed9t Th\u1ef1c l\u00e3nh, bi\u1ebft r\u1eb1ng Th\u1ef1c l\u00e3nh = L\u01b0\u01a1ng Ch\u00ednh + PCCV 6. T\u00ednh c\u00e1c \u00f4 t\u1ed5ng h\u1ee3p B\u00e0i 9: L\u1eadp v\u00e0 \u0111\u1ecbnh d\u1ea1ng b\u1ea3ng t\u00ednh Y\u00eau c\u1ea7u: 1. Ch\u00e8n th\u00eam c\u1ed9t Gi\u1edbi T\u00ednh \u1edf b\u00ean tr\u00e1i c\u1ed9t Win, bi\u1ebft Ph\u00e1i =1 l\u00e0 \u201cNam\u201d, ng\u01b0\u1ee3c l\u1ea1i l\u00e0 \u201cN\u1eef\u201d 2. \u0110TB = (win + word + Excel ) \/3, l\u00e0m tr\u00f2n 1 s\u1ed1 l\u1ebb 3. \u0110i\u1ec3m T\u1ed5ng C\u1ed9ng \u0111\u01b0\u1ee3c t\u00ednh nh\u01b0 sau: - N\u1ebfu l\u00e0 \u201cN\u1eef\u201d v\u00e0 \u0110TB<5 th\u00ec C\u1ed8NG = \u0110TB +0.5 nh\u01b0ng kh\u00f4ng \u0111\u01b0\u1ee3c >5 - Ng\u01b0\u1ee3c l\u1ea1i th\u00ec C\u1ed9ng = \u0110TB 4. X\u1ebfp lo\u1ea1i \u0111\u01b0\u1ee3c t\u00ednh nh\u01b0 sau: - T\u1ed5ng c\u1ed9ng <5: K\u00e9m 230","- 5<=T\u1ed5ng C\u1ed9ng <6.5: Trung b\u00ecnh - 6.5<=T\u1ed5ng c\u1ed9ng<8.5: kh\u00e1 - 8.5<T\u1ed5ng c\u1ed9ng<9.5: Gi\u1ecfi - C\u00f2n l\u1ea1i l\u00e0 Xu\u1ea5t s\u1eafc 5. Ghi ch\u00fa: \u201c\u0110\u1eadu\u201d n\u1ebfu t\u1ed5ng c\u1ed9ng>5, ng\u01b0\u1ee3c l\u1ea1i \u201cR\u1edbt\u201d 6. Th\u00eam c\u1ed9t H\u1ea1ng sau c\u1ed9t Ghi ch\u00fa v\u00e0 t\u00ednh th\u1ee9 h\u1ea1ng trong danh s\u00e1ch d\u1ef1 v\u00e0o c\u1ed9t T\u1ed5ng c\u1ed9ng B\u00e0i 10: L\u1eadp v\u00e0 \u0111\u1ecbnh d\u1ea1ng b\u1ea3ng t\u00ednh \u00dd ngh\u0129a MSNS (t\u1eeb tr\u00e1i sang ph\u1ea3i): 2 k\u00fd t\u1ef1 \u0111\u1ea7u: STT, k\u00fd t\u1ef1 th\u1ee9 3: MS ch\u1ee9c v\u1ee5, 2 k\u00fd t\u1ef1 cu\u1ed1i: MS \u0111\u01a1n v\u1ecb 231","Y\u00eau c\u1ea7u: 1. D\u00f9ng h\u00e0m Hlookup() hay Vlookup() \u0111\u1ec3 t\u00ednh n\u1ed9i dung cho c\u1ed9t ch\u1ee9c v\u1ee5 v\u00e0 \u0111\u01a1n v\u1ecb 2. T\u00ednh c\u1ed9t PCCV 3. T\u00ednh c\u1ed9t PC th\u00e2m ni\u00ean, bi\u1ebft r\u1eb1ng c\u00f4ng th\u1ee9c t\u00ednh th\u00e2m ni\u00ean nh\u01b0 sau: N\u0103m th\u00e2m ni\u00ean = (Ng\u00e0y l\u1eadp b\u1ea3ng \u2013 ng\u00e0y nh\u1eadn vi\u1ec7c)\/365 4. T\u00ednh c\u1ed9t Th\u1ef1c l\u00e3nh, bi\u1ebft r\u1eb1ng: Th\u1ef1c l\u00e3nh = L\u01b0\u01a1ng ch\u00ednh + PCCV + PCTN Trong \u0111\u00f3: L\u01b0\u01a1ng ch\u00ednh = L\u01b0\u01a1ng CB * H\u1ec7 s\u1ed1 * Ng\u00e0y c\u00f4ng\/Ng\u00e0y c\u00f4ng ch\u1ebf \u0111\u1ed9. B\u00e0i 11: L\u1eadp v\u00e0 \u0111\u1ecbnh d\u1ea1ng b\u1ea3ng t\u00ednh Y\u00eau c\u1ea7u: 1. D\u1ef1a v\u00e0o B\u1ea3ng \u0111\u01a1n gi\u00e1 v\u00e0 b\u1ea3ng ph\u00ed v\u1eadn chuy\u1ec3n. L\u1eadp c\u00f4ng th\u1ee9c \u0111i\u1ec1n v\u00e0o T\u00ean h\u00e0ng; \u0111\u01a1n gi\u00e1 s\u1ec9; \u0111\u01a1n gi\u00e1 l\u1ebb; ph\u00ed v\u1eadn chuy\u1ec3n 2. T\u00ednh s\u1ed1 th\u00f9ng, s\u1ed1 h\u1ed9p l\u1ebb. Bi\u1ebft r\u1eb1ng 1 th\u00f9ng c\u00f3 24 h\u1ed9p 3. Th\u00e0nh ti\u1ec1n = \u0111\u01a1n gi\u00e1 s\u1ec9 * s\u1ed1 th\u00f9ng + \u0111\u01a1n gi\u00e1 l\u1ebb * s\u1ed1 h\u1ed9p l\u1ebb 4. V\u1eadn chuy\u1ec3n = ph\u00ed v\u1eadn chuy\u1ec3n * th\u00e0nh ti\u1ec1n, n\u1ebfu s\u1ed1 th\u00f9ng>=10 th\u00ec v\u1eadn chuy\u1ec3n gi\u1ea3m gi\u1ea3m 10%, ng\u01b0\u1ee3c l\u1ea1i kh\u00f4ng gi\u1ea3m 5. T\u1ed5ng c\u1ed9ng = th\u00e0nh ti\u1ec1n + v\u1eadn chuy\u1ec3n 232","B\u00e0i 12: L\u1eadp v\u00e0 \u0111\u1ecbnh d\u1ea1ng b\u1ea3ng t\u00ednh Gi\u1ea3i th\u00edch: M\u00e3 s\u1ed1 h\u00e0ng bao g\u1ed3m 5 k\u00fd t\u1ef1, k\u00fd t\u1ef1 \u0111\u1ea7u ti\u00ean ch\u1ec9 T\u00ean h\u00e0ng, 4 k\u00fd t\u1ef1 k\u1ebf ch\u1ec9 s\u1ed1 l\u01b0\u1ee3ng h\u00e0ng mua. V\u00ed d\u1ee5: X1220 c\u00f3 ngh\u0129a l\u00e0 mua Xi m\u0103ng v\u00e0 s\u1ed1 l\u01b0\u1ee3ng mua l\u00e0 1220 bao Y\u00eau c\u1ea7u: 1. T\u00ednh % chi\u1ebft kh\u1ea5u: D\u1ef1a v\u00e0o b\u1ea3ng chi\u1ebft kh\u1ea5u v\u00e0 k\u00fd t\u1ef1 cu\u1ed1i c\u1ee7a MSKH 2. D\u1ef1a v\u00e0o b\u1ea3ng \u0111\u01a1n gi\u00e1 v\u00e0 c\u1ed9t m\u00e3 s\u1ed1 h\u00e0ng \u0111\u1ec3 t\u00ednh c\u1ed9t th\u00e0nh ti\u1ec1n, bi\u1ebft r\u1eb1ng: Th\u00e0nh ti\u1ec1n = s\u1ed1 l\u01b0\u1ee3ng mua *(1-% chi\u1ebft kh\u1ea5u) * \u0111\u01a1n gi\u00e1 lo\u1ea1i h\u00e0ng t\u01b0\u01a1ng \u1ee9ng 3. X\u1ebfp lo\u1ea1i KH: n\u1ebfu kh\u00e1ch h\u00e0ng mua tr\u00ean 50 tri\u1ec7u, x\u1ebfp lo\u1ea1i K, mua tr\u00ean 15 tri\u1ec7u x\u1ebfp lo\u1ea1i J, c\u00f2n l\u1ea1i x\u1ebfp lo\u1ea1i I 4. T\u00ednh b\u1ea3ng t\u1ed5ng k\u1ebft doanh thu 5. Tr\u00edch nh\u1eefng kh\u00e1ch h\u00e0ng: C\u00f3 lo\u1ea1i chi\u1ebft kh\u1ea5u l\u00e0 1 ho\u1eb7c 2 v\u00e0 c\u00f3 t\u1ed5ng gi\u00e1 tr\u1ecb mua h\u00e0ng tr\u00ean 25 tri\u1ec7u 6. D\u1ef1a v\u00e0o b\u1ea3ng t\u1ed5ng k\u1ebft doanh thu v\u1ebd \u0111\u1ed3 th\u1ecb 233","B\u00e0i 13: L\u1eadp v\u00e0 \u0111\u1ecbnh d\u1ea1ng b\u1ea3ng t\u00ednh Y\u00eau c\u1ea7u: 1. L\u1eadp c\u00f4ng th\u1ee9c t\u00ednh s\u1ed1 li\u1ec7u cho c\u00e1c c\u1ed9t: - Ti\u1ec1n \u0103n. Bi\u1ebft r\u1eb1ng Ti\u1ec1n \u0103n = (s\u1ed1 ng\u00e0y \u1edf) * \u0111\u01a1n gi\u00e1 kh\u1ea9u ph\u1ea7n \u0103n - (\u0111\u01a1n gi\u00e1 kh\u1ea9u ph\u1ea7n \u0103n \u0111\u01b0\u1ee3c d\u00f2 t\u00ecm v\u00e0 l\u1ea5y ra \u1edf b\u1ea3ng bi\u1ec3u gi\u00e1 kh\u1ea9u ph\u1ea7n \u0103n m\u1ed9t ng\u00e0y d\u1ef1a v\u00e0o 2 k\u00fd t\u1ef1 cu\u1ed1i c\u1ee7a m\u00e3 s\u1ed1) - Tu\u1ea7n v\u00e0 \u0110GT. (\u0110GT l\u00e0 \u0111\u01a1n gi\u00e1 m\u01b0\u1edbn ph\u00f2ng 1 tu\u1ea7n) - Ng\u00e0y v\u00e0 \u0110GN (\u0110GN l\u00e0 \u0111\u01a1n gi\u00e1 m\u01b0\u1edbn ph\u00f2ng 1 ng\u00e0y, ng\u00e0y l\u00e0 s\u1ed1 ng\u00e0y l\u1ebb) - (\u0110GT v\u00e0 \u0110GN \u0111\u01b0\u1ee3c d\u00f2 t\u00ecm v\u00e0 l\u1ea5y ra t\u1eeb Bi\u1ec3u gi\u00e1 ph\u00f2ng d\u1ef1a v\u00e0o 3 k\u00fd t\u1ef1 \u0111\u1ea7u c\u1ee7a m\u00e3 s\u1ed1) - T\u1ed5ng c\u1ed9ng. Bi\u1ebft r\u1eb1ng T\u1ed5ng c\u1ed9ng = ti\u1ec1n \u0103n + ti\u1ec1n thu\u00ea ph\u00f2ng t\u00ednh theo tu\u1ea7n + s\u1ed1 nh\u1ecf h\u01a1n gi\u1eefa ti\u1ec1n thu\u00ea ph\u00f2ng cho c\u00e1c ng\u00e0y l\u1ebb v\u00e0 ti\u1ec1n thu\u00ea ph\u00f2ng tr\u1ecdn tu\u1ea7n. 2. L\u00e0m l\u1ea1i c\u1ed9t ti\u1ec1n \u0103n theo y\u00eau c\u1ea7u sau: Ti\u1ec1n \u0103n = s\u1ed1 ng\u00e0y \u1edf * \u0111\u01a1n gi\u00e1 kh\u1ea9u ph\u1ea7n, n\u1ebfu kh\u00e1ch \u1edf tr\u00ean 1 tu\u1ea7n th\u00ec s\u1ed1 ng\u00e0y>7 \u0111\u00f3 s\u1ebd gi\u1ea3m gi\u00e1 ti\u1ec1n \u0103n 15% 3. L\u1eadp b\u1ea3ng th\u1ed1ng k\u00ea cho s\u1ed1 l\u01b0\u1ee3ng t\u1eebng lo\u1ea1i ph\u00f2ng 4. D\u1ef1a v\u00e0o b\u1ea3ng th\u1ed1ng k\u00ea v\u1ebd \u0111\u1ed3 th\u1ecb 234","Ch\u01b0\u01a1ng V. S\u1eec D\u1ee4NG TR\u00ccNH CHI\u1ebeU 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 s\u1eed d\u1ee5ng m\u00e1y t\u00ednh v\u00e0 s\u1eed d\u1ee5ng ph\u1ea7n m\u1ec1m Microsoft PowerPoint 2019 trong vi\u1ec7c thi\u1ebft k\u1ebf v\u00e0 tr\u00ecnh chi\u1ebfu th\u00f4ng tin. - S\u1eed d\u1ee5ng \u0111\u01b0\u1ee3c ph\u1ea7n m\u1ec1m tr\u00ecnh chi\u1ebfu Microsoft PowerPoint 2019 \u0111\u1ec3 so\u1ea1n th\u1ea3o n\u1ed9i dung, thi\u1ebft k\u1ebf v\u00e0 tr\u00ecnh chi\u1ebfu c\u00e1c n\u1ed9i dung c\u1ea7n thi\u1ebft cho m\u1ed9t b\u00e0i thuy\u1ebft tr\u00ecnh th\u00f4ng th\u01b0\u1eddng. 5.1. Ki\u1ebfn th\u1ee9c c\u01a1 b\u1ea3n v\u1ec1 b\u00e0i thuy\u1ebft tr\u00ecnh 5.1.1. Kh\u00e1i ni\u1ec7m b\u00e0i thuy\u1ebft tr\u00ecnh 5.1.1.1. Kh\u00e1i ni\u1ec7m Thuy\u1ebft tr\u00ecnh l\u00e0 s\u1ef1 tr\u00ecnh b\u00e0y nh\u1eefng nh\u1eadn \u0111\u1ecbnh, quan \u0111i\u1ec3m, chi\u1ebfn l\u01b0\u1ee3c, ki\u1ebfn th\u1ee9c chuy\u00ean m\u00f4n...nh\u1eb1m thuy\u1ebft ph\u1ee5c kh\u00e1n gi\u1ea3 ch\u1ea5p thu\u1eadn, \u0111\u1ed3ng t\u00ecnh v\u1edbi nh\u1eefng ch\u1ee7 \u0111\u1ec1 v\u00e0 th\u00f4ng tin \u0111\u01b0\u1ee3c nghe. Nh\u01b0 v\u1eady, thuy\u1ebft tr\u00ecnh l\u00e0 qu\u00e1 tr\u00ecnh truy\u1ec1n \u0111\u1ea1t th\u00f4ng tin nh\u1eb1m \u0111\u1ea1t \u0111\u01b0\u1ee3c c\u00e1c m\u1ee5c ti\u00eau c\u1ee5 th\u1ec3: hi\u1ec3u, t\u1ea1o d\u1ef1ng quan h\u1ec7 v\u00e0 th\u1ef1c hi\u1ec7n. 5.1.1.2. C\u00e1c y\u1ebfu t\u1ed1 \u1ea3nh h\u01b0\u1edfng \u0111\u1ebfn ch\u1ea5t l\u01b0\u1ee3ng thuy\u1ebft tr\u00ecnh Chu\u1ea9n b\u1ecb kh\u00f4ng chu \u0111\u00e1o: S\u1ef1 chu\u1ea9n b\u1ecb kh\u00f4ng ch\u1ec9 l\u00e0 v\u1ec1 n\u1ed9i dung m\u00e0 c\u00f2n ph\u1ea3i c\u00f3 s\u1ef1 chu\u1ea9n b\u1ecb v\u1ec1 t\u00e2m l\u00fd. \u0110\u1ec3 tr\u00e1nh \u0111\u01b0\u1ee3c t\u00ecnh tr\u1ea1ng n\u00e0y, kh\u00f4ng n\u00ean ch\u1ee7 quan m\u00e0 c\u1ea7n ph\u1ea3i c\u00f3 s\u1ef1 chu\u1ea9n b\u1ecb tr\u01b0\u1edbc c\u00e0ng chu \u0111\u00e1o c\u00e0ng t\u1ed1t. Chu\u1ea9n b\u1ecb c\u00e0ng k\u1ef9 th\u00ec t\u1ec9 l\u1ec7 th\u00e0nh c\u00f4ng c\u1ee7a bu\u1ed5i thuy\u1ebft tr\u00ecnh c\u00e0ng cao. Kh\u00f4ng \u0111\u00e1nh gi\u00e1 \u0111\u00fang kh\u00e1n gi\u1ea3: Kh\u00e1n gi\u1ea3 l\u00e0 y\u1ebfu t\u1ed1 quan tr\u1ecdng \u1ea3nh h\u01b0\u1edfng \u0111\u1ebfn s\u1ef1 th\u00e0nh c\u00f4ng c\u1ee7a b\u00e0i thuy\u1ebft tr\u00ecnh. N\u1ebfu ng\u01b0\u1eddi thuy\u1ebft tr\u00ecnh kh\u00f4ng t\u00ecm hi\u1ec3u th\u00f4ng tin, \u0111\u1eb7c \u0111i\u1ec3m c\u1ee7a kh\u00e1n gi\u1ea3 nh\u01b0: gi\u1edbi t\u00ednh, t\u1ea7ng l\u1edbp, tr\u00ecnh \u0111\u1ed9, ngh\u1ec1 nghi\u1ec7p,\u2026th\u00ec s\u1ebd kh\u00f4ng x\u00e1c \u0111\u1ecbnh \u0111\u01b0\u1ee3c ph\u01b0\u01a1ng ph\u00e1p t\u00e1c \u0111\u1ed9ng ph\u00f9 h\u1ee3p. Thi\u1ebfu t\u1ef1 tin: Th\u00f4ng th\u01b0\u1eddng, \u0111a s\u1ed1 ch\u00fang ta \u0111\u1ec1u c\u1ea3m th\u1ea5y b\u1ed1i r\u1ed1i, c\u0103ng th\u1eb3ng tr\u01b0\u1edbc khi thuy\u1ebft tr\u00ecnh. \u0110\u00e2y ch\u00ednh l\u00e0 c\u01a1 ch\u1ebf t\u1ef1 v\u1ec7 c\u1ee7a c\u01a1 th\u1ec3 n\u00ean ch\u00fang ta kh\u00f4ng c\u1ea7n qu\u00e1 lo l\u1eafng. C\u00f3 khi, ch\u00ednh s\u1ef1 c\u0103ng th\u1eb3ng n\u00e0y l\u1ea1i gi\u00fap cho ch\u00fang ta n\u1ed7 l\u1ef1c nhi\u1ec1u h\u01a1n khi thuy\u1ebft tr\u00ecnh v\u00e0 g\u00f3p ph\u1ea7n n\u00e2ng cao hi\u1ec7u qu\u1ea3 c\u1ee7a b\u00e0i thuy\u1ebft tr\u00ecnh. Tuy nhi\u00ean, n\u1ebfu kh\u00f4ng bi\u1ebft ki\u1ec3m so\u00e1t, ch\u1ebf ng\u1ef1 s\u1ef1 lo l\u1eafng th\u00ec n\u00f3 c\u00f3 th\u1ec3 t\u00e1c \u0111\u1ed9ng ti\u00eau c\u1ef1c \u0111\u1ebfn b\u00e0i thuy\u1ebft tr\u00ecnh. 235","5.1.1.3. M\u1ed9t s\u1ed1 ch\u1ec9 d\u1eabn \u0111\u1ec3 t\u1ea1o n\u00ean m\u1ed9t b\u00e0i thuy\u1ebft tr\u00ecnh t\u1ed1t B\u00e0i thuy\u1ebft tr\u00ecnh t\u1ed1t c\u1ea7n c\u00f3: N\u1ed9i dung, c\u1ea5u tr\u00fac, t\u1ed5ng th\u1ec3 v\u00e0 y\u1ebfu t\u1ed1 con ng\u01b0\u1eddi. Chu\u1ea9n b\u1ecb cho b\u00e0i thuy\u1ebft tr\u00ecnh N\u1ed9i dung: C\u1ea7n nhi\u1ec1u th\u1eddi gian \u0111\u1ec3 nghi\u00ean c\u1ee9u k\u1ef9 v\u1ec1 ch\u1ee7 \u0111\u1ec1, \u0111\u1ec1 t\u00e0i v\u00e0 ph\u00e1t tri\u1ec3n th\u00e0nh c\u00e1c \u00fd t\u01b0\u1edfng. C\u00e1ch t\u1ed5 ch\u1ee9c: S\u1eafp x\u1ebfp c\u00e1c \u00fd t\u01b0\u1edfng v\u00e0o c\u00e1c ph\u1ea7n m\u1edf b\u00e0i, th\u00e2n b\u00e0i, k\u1ebft lu\u1eadn m\u1ed9t c\u00e1ch logic. Tab ghi ch\u00fa: L\u00e0m c\u00e1c t\u1ea5m card ghi ch\u00fa nh\u1eefng \u00fd ch\u00ednh s\u1ebd n\u00f3i trong b\u00e0i di\u1ec5n v\u0103n. Ch\u00fang s\u1ebd gi\u00fap b\u1ea1n nh\u1edb l\u1ea1i nhanh ch\u00f3ng c\u00e1c \u00fd ch\u00ednh m\u00e0 kh\u00f4ng c\u1ea7n ph\u1ea3i \u0111\u1ecdc nhi\u1ec1u. Th\u1ef1c h\u00e0nh: C\u1ea7n ph\u1ea3i th\u1ef1c t\u1eadp nhi\u1ec1u l\u1ea7n tr\u01b0\u1edbc ng\u00e0y thuy\u1ebft tr\u00ecnh \u0111\u1ec3 b\u00e0i thuy\u1ebft tr\u00ecnh th\u00e0nh c\u00f4ng v\u00e0 hi\u1ec7u qu\u1ea3. 5.1.2. C\u00e1c b\u01b0\u1edbc c\u01a1 b\u1ea3n \u0111\u1ec3 t\u1ea1o m\u1ed9t b\u00e0i thuy\u1ebft tr\u00ecnh - X\u00e1c \u0111\u1ecbnh m\u1ee5c ti\u00eau thuy\u1ebft tr\u00ecnh. - Thi\u1ebft k\u1ebf, bi\u00ean t\u1eadp n\u1ed9i dung c\u00e1c trang c\u1ee7a b\u00e0i thuy\u1ebft tr\u00ecnh. - L\u01b0u v\u00e0 xu\u1ea5t b\u1ea3n (publish) n\u1ed9i dung b\u00e0i thuy\u1ebft tr\u00ecnh. - Th\u1ef1c hi\u1ec7n vi\u1ec7c thuy\u1ebft tr\u00ecnh b\u1eb1ng m\u1ed9t c\u00f4ng c\u1ee5 tr\u00ecnh chi\u1ebfu. 5.2. S\u1eed d\u1ee5ng ph\u1ea7n m\u1ec1m Microsoft PowerPoint 5.2.1. C\u00e1c thao t\u00e1c t\u1ea1o tr\u00ecnh chi\u1ebfu c\u01a1 b\u1ea3n 5.2.1.1. Gi\u1edbi thi\u1ec7u Microsoft PowerPoint Microsoft Powerpoint 2019 h\u1ed7 tr\u1ee3 ng\u01b0\u1eddi d\u00f9ng t\u1ea1o n\u00ean c\u00e1c b\u00e0i thuy\u1ebft tr\u00ecnh sinh \u0111\u1ed9ng v\u00e0 l\u00f4i cu\u1ed1n. Giao di\u1ec7n Powerpoint 2019 \u0111\u01b0\u1ee3c ph\u00e1t tri\u1ec3n t\u1eeb phi\u00ean b\u1ea3n 2007 v\u1edbi c\u00e1c Ribbon s\u1ebd mang l\u1ea1i nhi\u1ec1u ti\u1ec7n l\u1ee3i v\u00e0 v\u1edbi nhi\u1ec1u t\u00ednh n\u0103ng m\u1edbi gi\u00fap t\u1ea1o n\u00ean b\u00e0i thuy\u1ebft tr\u00ecnh sinh \u0111\u1ed9ng, h\u1ea5p d\u1eabn v\u00e0 tr\u1ef1c quan m\u1ed9t c\u00e1ch nhanh ch\u00f3ng. 5.2.1.2. T\u1ea1o m\u1ed9t b\u00e0i thuy\u1ebft tr\u00ecnh c\u01a1 b\u1ea3n T\u1ea1o m\u1ed9t b\u00e0i thuy\u1ebft tr\u00ecnh r\u1ed7ng: V\u00e0o tab File \uf0e0 New \uf0e0 Blank presentation 236","H\u00ecnh 5.1. M\u1ed9t s\u1ed1 Sample templates T\u1ea1o b\u00e0i thuy\u1ebft tr\u00ecnh t\u1eeb m\u1eabu c\u00f3 s\u1eb5n: v\u00e0o tab File \uf0e0 New \uf0e0 Ch\u1ecdn m\u1ed9t m\u1eabu thi\u1ebft k\u1ebf t\u1eeb danh s\u00e1ch b\u00ean d\u01b0\u1edbi v\u00e0 xem h\u00ecnh minh h\u1ecda ph\u00eda b\u00ean ph\u1ea3i c\u1eeda s\u1ed5. H\u00ecnh 5.2. M\u1ed9t s\u1ed1 Sample templates 5.2.1.3. C\u00e1c thao t\u00e1c tr\u00ean slide Khi t\u1ea1o m\u1edbi b\u00e0i thuy\u1ebft tr\u00ecnh, PowerPoint ch\u00e8n s\u1eb5n slide t\u1ef1a \u0111\u1ec1 v\u1edbi hai h\u1ed9p v\u0103n b\u1ea3n tr\u1ed1ng g\u1ecdi l\u00e0 c\u00e1c placeholder. \u0110\u00e2y l\u00e0 c\u00e1c placeholder d\u00f9ng \u0111\u1ec3 nh\u1eadp v\u0103n b\u1ea3n. Ngo\u00e0i ra, PowerPoint c\u00f2n c\u00f3 nhi\u1ec1u lo\u1ea1i placeholder kh\u00e1c \u0111\u1ec3 ch\u00e8n h\u00ecnh \u1ea3nh, SmartArt, b\u1ea3ng bi\u1ec3u, \u0111\u1ed3 th\u1ecb,\u2026 237","Ng\u0103n Slides C\u00e1c placeholder H\u00ecnh 5.3. Slide t\u1ef1a \u0111\u1ec1 b\u00e0i thuy\u1ebft tr\u00ecnh v\u1edbi hai placeholder C\u00f3 nhi\u1ec1u ki\u1ec3u b\u1ed1 tr\u00ed c\u00e1c placeholder tr\u00ean slide m\u00e0 PowerPoint x\u00e2y d\u1ef1ng s\u1eb5n \u0111\u01b0\u1ee3c g\u1ecdi l\u00e0 c\u00e1c Layout. T\u00f9y theo n\u1ed9i dung c\u1ea7n x\u00e2y d\u1ef1ng cho slide m\u00e0 b\u1ea1nch\u1ecdn ki\u1ec3u Layout ph\u00f9 h\u1ee3p. H\u00ecnh 5.4. C\u00e1c ki\u1ec3u layout c\u1ee7a slide Ch\u00e8n slide m\u1edbi: 238","- Ch\u1ecdn tab Slides trong ch\u1ebf \u0111\u1ed9 Normal View v\u00e0 nh\u1ea5p chu\u1ed9t v\u00e0o d\u01b0\u1edbi slide \u0111\u1ea7u ti\u00ean do PowerPoint t\u1ef1 t\u1ea1o ra khi ch\u00fang ta t\u1ea1o b\u00e0i thuy\u1ebft tr\u00ecnh m\u1edbi. Khi \u0111\u00f3, ch\u00fang ta s\u1ebd th\u1ea5y m\u1ed9t \u0111\u01b0\u1eddng n\u1eb1m ngang nh\u1ea5p nh\u00e1y cho bi\u1ebft \u0111\u00f3 l\u00e0 v\u1ecb tr\u00ed m\u00e0 slide m\u1edbi s\u1ebd \u0111\u01b0\u1ee3c ch\u00e8n v\u00e0o. - V\u00e0o tab Home ch\u1ecdn nh\u00f3m Slides - Ch\u1ecdn n\u00fat New Slide, h\u1ed9p ch\u1ee9a c\u00e1c ki\u1ec3u layout xu\u1ea5t hi\u1ec7n - Ch\u1ecdn m\u1ed9t ki\u1ec3u layout, slide m\u1edbi s\u1ebd \u0111\u01b0\u1ee3c ch\u00e8n v\u00e0o b\u00e0i thuy\u1ebft tr\u00ecnh theo ki\u1ec3u layout v\u1eeba ch\u1ecdn. H\u00ecnh 5.5. Ch\u00e8n slide Sao ch\u00e9p slide (nh\u00e2n b\u1ea3n) - Trong ch\u1ebf \u0111\u1ed9 Normal View, ch\u1ecdn c\u00e1c slide trong tab Slides mu\u1ed1n sao ch\u00e9p - Nh\u1ea5p ph\u1ea3i chu\u1ed9t l\u00ean m\u1ed9t trong s\u1ed1 c\u00e1c slide \u0111ang ch\u1ecdn \u0111\u1ec3 m\u1edf th\u1ef1c \u0111\u01a1n ng\u1eef c\u1ea3nh - Ch\u1ecdn Duplicate Slide t\u1eeb danh s\u00e1ch l\u1ec7nh 239","H\u00ecnh 5.6. Sao ch\u00e9p slide Thay \u0111\u1ed5i layout cho slide: - Trong ch\u1ebf \u0111\u1ed9 Normal View, ch\u1ecdn c\u00e1c slide trong tab Slides mu\u1ed1n sao ch\u00e9p - Ch\u1ecdn slide c\u1ea7n thay \u0111\u1ed5i layout - V\u00e0o tab Home | nh\u00f3m Slides | ch\u1ecdn n\u00fat Layout - Ch\u1ecdn ki\u1ec3u layout m\u1edbi cho slide H\u00ecnh 5.7. Thay \u0111\u1ed5i layout cho slide 240","Thay \u0111\u1ed5i v\u1ecb tr\u00ed c\u00e1c slide - Trong ch\u1ebf \u0111\u1ed9 Normal View, ch\u1ecdn slide trong tab Slides mu\u1ed1n s\u1eafp x\u1ebfp - D\u00f9ng chu\u1ed9t k\u00e9o slide \u0111\u1ebfn v\u1ecb tr\u00ed m\u1edbi trong tab Slides v\u00e0 th\u1ea3 chu\u1ed9t - Slide s\u1ebd xu\u1ea5t hi\u1ec7n \u1edf v\u1ecb tr\u00ed m\u1edbi. H\u00ecnh 5.8. S\u1eafp x\u1ebfp slide X\u00f3a slide - Trong ch\u1ebf \u0111\u1ed9 Normal View, ch\u1ecdn slide trong tab Slides mu\u1ed1n x\u00f3a - Ch\u1ecdn ph\u00edm Delete tr\u00ean b\u00e0n ph\u00edm \u0111\u1ec3 x\u00f3a slide ho\u1eb7c nh\u1ea5p ph\u1ea3i chu\u1ed9t l\u00ean slide v\u00e0 ch\u1ecdn Delete Slide H\u00ecnh 5.9. X\u00f3a slide 241"]