Tài liệu học và ôn MOS Excel 2010

["Microsoft\u00ae Core Skills Excel 2010 Nhi\u1ec7m v\u1ee5 th\u1ef1c h\u00e0nh 3.5 \u2022 C\u00e1c t\u1eadp tin th\u1ef1c h\u00e0nh cho c\u00e1c nhi\u1ec7m v\u1ee5 \u0111\u01b0\u1ee3c \u0111\u1eb7t trong th\u01b0 m\u1ee5c Excel \\\\ Objective3. N\u1ebfu b\u1ea1n mu\u1ed1n l\u01b0u c\u00e1c k\u1ebft qu\u1ea3 c\u1ee7a nhi\u1ec7m v\u1ee5, l\u01b0u ch\u00fang trong c\u00f9ng th\u01b0 m\u1ee5c v\u1edbi b\u1eb1ng c\u00e1ch th\u00eam t\u1eeb My tr\u01b0\u1edbc t\u00ean t\u1eadp tin \u0111\u1ec3 b\u1ea1n kh\u00f4ng ghi \u0111\u00e8 l\u00ean t\u1eadp tin th\u1ef1c h\u00e0nh ban \u0111\u1ea7u. \u2013 Trong workbook Layout, hi\u1ec3n th\u1ecb worksheet JanFeb. \u0110\u1ea3m b\u1ea3o r\u1eb1ng t\u1ea5t c\u1ea3 c\u00e1c n\u1ed9i dung s\u1ebd in theo chi\u1ec1u ngang tr\u00ean hai trang c\u1ee1 gi\u1ea5y letter. \u2013 Trong workbook Layout, \u0111\u1ea3m b\u1ea3o r\u1eb1ng t\u1ea5t c\u1ea3 c\u00e1c n\u1ed9i dung c\u1ee7a worksheet JanFeb s\u1ebd in tr\u00ean hai mi\u1ebfng kh\u1ed5 gi\u1ea5y A5. \u2013 Trong workbook Layout, \u0111\u1ea3m b\u1ea3o r\u1eb1ng c\u00e1c n\u1ed9i dung c\u1ee7a worksheet JanFeb s\u1ebd in \u1edf m\u1ee9c 50% k\u00edch th\u01b0\u1edbc th\u1ef1c t\u1ebf c\u1ee7a ch\u00fang. \u00a9 IIG Vietnam. 22","Microsoft\u00ae Core Skills Excel 2010 Nhi\u1ec7m v\u1ee5 th\u1ef1c h\u00e0nh 3.6 \u2022 C\u00e1c t\u1eadp tin th\u1ef1c h\u00e0nh cho c\u00e1c nhi\u1ec7m v\u1ee5 \u0111\u01b0\u1ee3c \u0111\u1eb7t trong th\u01b0 m\u1ee5c Excel \\\\ Objective3. N\u1ebfu b\u1ea1n mu\u1ed1n l\u01b0u c\u00e1c k\u1ebft qu\u1ea3 c\u1ee7a nhi\u1ec7m v\u1ee5, l\u01b0u ch\u00fang trong c\u00f9ng th\u01b0 m\u1ee5c v\u1edbi b\u1eb1ng c\u00e1ch th\u00eam t\u1eeb My tr\u01b0\u1edbc t\u00ean t\u1eadp tin \u0111\u1ec3 b\u1ea1n kh\u00f4ng ghi \u0111\u00e8 l\u00ean t\u1eadp tin th\u1ef1c h\u00e0nh ban \u0111\u1ea7u. \u2013 Tr\u00ean worksheet t\u00ednh Expense Statement c\u1ee7a workbook FormatCells, ch\u1ecdn c\u00e1c \u00f4 A9:K9, v\u00e0 \u00e1p d\u1ee5ng cell style 20% - Accent2. Sau \u0111\u00f3, thay \u0111\u1ed5i ki\u1ec3u font ch\u1eef v\u00e0 m\u00e0u n\u1ec1n c\u1ee7a c\u00e1c \u00f4 A9:K9, v\u00e0 l\u01b0u s\u1ef1 k\u1ebft h\u1ee3p \u0111\u1ecbnh d\u1ea1ng nh\u01b0 l\u00e0 m\u1ed9t cell style m\u1edbi. \u00a9 IIG Vietnam. 23","Microsoft\u00ae Core Skills Excel 2010 4. Qu\u1ea3n l\u00fd Worksheets v\u00e0 Workbooks \u2022 4.1 T\u1ea1o v\u00e0 \u0111\u1ecbnh d\u1ea1ng Worksheets \u2022 4.2 Thao t\u00e1c Window Views \u2022 4.3 Thao t\u00e1c Workbook Views \u00a9 IIG Vietnam. 24","Microsoft\u00ae Core Skills Excel 2010 Nhi\u1ec7m v\u1ee5 th\u1ef1c h\u00e0nh 4.1 \u2022 C\u00e1c t\u1eadp tin th\u1ef1c h\u00e0nh cho c\u00e1c nhi\u1ec7m v\u1ee5 \u0111\u01b0\u1ee3c \u0111\u1eb7t trong th\u01b0 m\u1ee5c Excel \\\\ Objective4. N\u1ebfu b\u1ea1n mu\u1ed1n l\u01b0u c\u00e1c k\u1ebft qu\u1ea3 c\u1ee7a nhi\u1ec7m v\u1ee5, l\u01b0u ch\u00fang trong c\u00f9ng th\u01b0 m\u1ee5c v\u1edbi b\u1eb1ng c\u00e1ch th\u00eam t\u1eeb My tr\u01b0\u1edbc t\u00ean t\u1eadp tin \u0111\u1ec3 b\u1ea1n kh\u00f4ng ghi \u0111\u00e8 l\u00ean t\u1eadp tin th\u1ef1c h\u00e0nh ban \u0111\u1ea7u. \u2013 Trong workbook SalesReport, v\u00e0 t\u1ea1o m\u1ed9t b\u1ea3n sao c\u1ee7a worksheet By Product. \u0110\u1ed5i t\u00ean b\u1ea3n sao ch\u00e9p th\u00e0nh Sales By Product. \u2013 Nh\u00f3m c\u00e1c worksheet By Product v\u00e0 By Sales, v\u00e0 sau \u0111\u00f3 \u00e1p d\u1ee5ng ch\u1ee7 \u0111\u1ec1 Austin cho nh\u00f3m worksheet. \u2013 L\u00e0m cho worksheet Source Data \u1edf v\u1ecb tr\u00ed worksheet cu\u1ed1i c\u00f9ng trong workbook. \u2013 \u1ea8n worksheet By Product - Customer Filtered. \u2013 Thay \u0111\u1ed5i \u0111\u1ec3 c\u00f3 th\u1ec3 nh\u00ecn th\u1ea5y c\u1ee7a m\u1ed7i tab worksheet c\u00f3 m\u1ed9t m\u00e0u s\u1eafc kh\u00e1c nhau. \u00a9 IIG Vietnam. 25","Microsoft\u00ae Core Skills Excel 2010 Nhi\u1ec7m v\u1ee5 th\u1ef1c h\u00e0nh 4.2 \u2022 C\u00e1c t\u1eadp tin th\u1ef1c h\u00e0nh cho c\u00e1c nhi\u1ec7m v\u1ee5 \u0111\u01b0\u1ee3c \u0111\u1eb7t trong th\u01b0 m\u1ee5c Excel \\\\ Objective4. N\u1ebfu b\u1ea1n mu\u1ed1n l\u01b0u c\u00e1c k\u1ebft qu\u1ea3 c\u1ee7a nhi\u1ec7m v\u1ee5, l\u01b0u ch\u00fang trong c\u00f9ng th\u01b0 m\u1ee5c v\u1edbi b\u1eb1ng c\u00e1ch th\u00eam t\u1eeb My tr\u01b0\u1edbc t\u00ean t\u1eadp tin \u0111\u1ec3 b\u1ea1n kh\u00f4ng ghi \u0111\u00e8 l\u00ean t\u1eadp tin th\u1ef1c h\u00e0nh ban \u0111\u1ea7u. \u2013 M\u1edf worksheet Budget c\u1ee7a workbook PersonalMonthlyBudget, \u0111\u00f3ng b\u0103ng d\u00f2ng t\u1eeb 1 \u0111\u1ebfn 9 \u0111\u1ec3 khi b\u1ea1n di chuy\u1ec3n ph\u1ea7n c\u00f2n l\u1ea1i c\u1ee7a b\u1ea3ng t\u00ednh, nh\u1eefng h\u00e0ng n\u00e0y lu\u00f4n lu\u00f4n \u0111\u01b0\u1ee3c nh\u00ecn th\u1ea5y. Sau \u0111\u00f3, m\u1edf ph\u00e1 b\u0103ng c\u00e1c h\u00e0ng. \u00a9 IIG Vietnam. 26","Microsoft\u00ae Core Skills Excel 2010 Nhi\u1ec7m v\u1ee5 th\u1ef1c h\u00e0nh 4.2 (tt) \u2013 Chia worksheet Budget c\u1ee7a workbook PersonalMonthlyBudget \u0111\u1ec3 b\u1ea1n c\u00f3 th\u1ec3 hi\u1ec3n th\u1ecb d\u00f2ng t\u1eeb 1 \u0111\u1ebfn 9 trong m\u1ed9t c\u1eeda s\u1ed5 v\u00e0 di chuy\u1ec3n c\u00e1c d\u1eef li\u1ec7u ng\u00e2n s\u00e1ch m\u1ed9t c\u1eeda s\u1ed5 kh\u00e1c. \u2013 Ti\u1ebfp t\u1ee5c t\u1eeb nhi\u1ec7m v\u1ee5 tr\u01b0\u1edbc \u0111\u00f3, m\u1edf c\u00e1c workbook AirQualityData v\u00e0 PopulationData. S\u1eed d\u1ee5ng c\u00e1c l\u1ec7nh trong Window nh\u00f3m tr\u00ean Menu, l\u00e1t ng\u00f3i (tile) ba c\u1eeda s\u1ed5, v\u00e0 sau \u0111\u00f3 s\u1eafp x\u1ebfp ch\u00fang \u0111\u1ec3 ch\u00fang ch\u1ed3ng ch\u00e9o l\u00ean nhau. \u2013 Ti\u1ebfp t\u1ee5c t\u1eeb nhi\u1ec7m v\u1ee5 tr\u01b0\u1edbc, s\u1eed d\u1ee5ng l\u1ec7nh New Window \u0111\u1ec3 m\u1edf m\u1ed9t th\u1ec3 hi\u1ec7n th\u1ee9 hai c\u1ee7a m\u1ed9t trong c\u00e1c workbook. Sau \u0111\u00f3 s\u1eafp x\u1ebfp ch\u1ec9 c\u00f3 hai c\u1eeda s\u1ed5 workbook ho\u1ea1t \u0111\u1ed9ng theo chi\u1ec1u ngang. \u00a9 IIG Vietnam. 27","Microsoft\u00ae Core Skills Excel 2010 Nhi\u1ec7m v\u1ee5 th\u1ef1c h\u00e0nh 4.3 \u2022 C\u00e1c t\u1eadp tin th\u1ef1c h\u00e0nh cho c\u00e1c nhi\u1ec7m v\u1ee5 \u0111\u01b0\u1ee3c \u0111\u1eb7t trong th\u01b0 m\u1ee5c Excel \\\\ Objective4. N\u1ebfu b\u1ea1n mu\u1ed1n l\u01b0u c\u00e1c k\u1ebft qu\u1ea3 c\u1ee7a nhi\u1ec7m v\u1ee5, l\u01b0u ch\u00fang trong c\u00f9ng th\u01b0 m\u1ee5c v\u1edbi b\u1eb1ng c\u00e1ch th\u00eam t\u1eeb My tr\u01b0\u1edbc t\u00ean t\u1eadp tin \u0111\u1ec3 b\u1ea1n kh\u00f4ng ghi \u0111\u00e8 l\u00ean t\u1eadp tin th\u1ef1c h\u00e0nh ban \u0111\u1ea7u. \u2013 M\u1edf workbook PersonalMonthlyBudget. Hi\u1ec3n th\u1ecb worksheet Budget \u1edf ch\u1ebf \u0111\u1ed9 xem Page Layout, v\u00e0 sau \u0111\u00f3 thu nh\u1ecf \u0111\u1ec3 b\u1ea1n c\u00f3 th\u1ec3 nh\u00ecn th\u1ea5y to\u00e0n b\u1ed9 trang \u0111\u1ea7u ti\u00ean. \u2013 Ch\u1ecdn ph\u1ea7n Projected Monthly Income c\u1ee7a worksheet Budget, v\u00e0 ph\u00f3ng to \u0111\u1ec3 ch\u1ec9 hi\u1ec3n th\u1ecb c\u00e1c \u00f4 \u0111\u01b0\u1ee3c l\u1ef1a ch\u1ecdn. \u00a9 IIG Vietnam. 28","Microsoft\u00ae Core Skills Excel 2010 5. \u00c1p d\u1ee5ng c\u00f4ng th\u1ee9c v\u00e0 h\u00e0m \u2022 5.1 T\u1ea1o c\u00f4ng th\u1ee9c \u2022 5.2 Th\u1ef1c thi quy\u1ec1n \u01b0u ti\u00ean \u2022 5.3 \u00c1p d\u1ee5ng Cell References trong c\u00f4ng th\u1ee9c \u2022 5.4 \u00c1p d\u1ee5ng Conditional Logic trong c\u00f4ng th\u1ee9c \u2022 5.5 \u00c1p d\u1ee5ng Nameed Ranges trong c\u00f4ng th\u1ee9c \u2022 5.6 \u00c1p d\u1ee5ng Cell Ranges trong c\u00f4ng th\u1ee9c \u00a9 IIG Vietnam. 29","Microsoft\u00ae Core Skills Excel 2010 Nhi\u1ec7m v\u1ee5 th\u1ef1c h\u00e0nh 5.1 \u2022 C\u00e1c t\u1eadp tin th\u1ef1c h\u00e0nh cho c\u00e1c nhi\u1ec7m v\u1ee5 \u0111\u01b0\u1ee3c \u0111\u1eb7t trong th\u01b0 m\u1ee5c Excel \\\\ Objective5. N\u1ebfu b\u1ea1n mu\u1ed1n l\u01b0u c\u00e1c k\u1ebft qu\u1ea3 c\u1ee7a nhi\u1ec7m v\u1ee5, l\u01b0u ch\u00fang trong c\u00f9ng th\u01b0 m\u1ee5c v\u1edbi b\u1eb1ng c\u00e1ch th\u00eam t\u1eeb My tr\u01b0\u1edbc t\u00ean t\u1eadp tin \u0111\u1ec3 b\u1ea1n kh\u00f4ng ghi \u0111\u00e8 l\u00ean t\u1eadp tin th\u1ef1c h\u00e0nh ban \u0111\u1ea7u. \u2013 Tr\u00ean worksheet Sales By Region c\u1ee7a workbook Sales, l\u00e0m nh\u01b0 sau: \u2022 T\u1ea1o c\u00e1c subtotal s\u1ed1 ti\u1ec1n b\u00e1n h\u00e0ng \u0111\u1ea7u ti\u00ean theo Period v\u00e0 sau \u0111\u00f3 theo Region. \u2022 T\u00ecm doanh s\u1ed1 b\u00e1n h\u00e0ng trung b\u00ecnh theo Period v\u00e0 sau \u0111\u00f3 theo Region. \u2022 T\u00ecm c\u00e1c gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t v\u00e0 nh\u1ecf nh\u1ea5t theo Period v\u00e0 sau \u0111\u00f3 theo Region.\u00a9 IIG Vietnam. 30","Microsoft\u00ae Core Skills Excel 2010 Nhi\u1ec7m v\u1ee5 th\u1ef1c h\u00e0nh 5.1 (tt) \u2013Tr\u00ean worksheet Summary c\u1ee7a workbook SummaryFormula, l\u00e0m nh\u01b0 sau: \u2022 Trong \u00f4 B18, t\u1ea1o ra m\u1ed9t c\u00f4ng th\u1ee9c tr\u1ea3 v\u1ec1 s\u1ed1 l\u01b0\u1ee3ng c\u00e1c \u00f4 trong ph\u1ea1m vi Period kh\u00e1c r\u1ed7ng. Sau \u0111\u00f3, trong \u00f4 B19, t\u1ea1o ra m\u1ed9t c\u00f4ng th\u1ee9c tr\u1ea3 v\u1ec1 s\u1ed1 l\u01b0\u1ee3ng c\u00e1c \u00f4 tr\u1ed1ng trong c\u00f9ng m\u1ed9t ph\u1ea1m vi. \u2022 Trong \u00f4 C18, t\u1ea1o ra m\u1ed9t c\u00f4ng th\u1ee9c tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb trung b\u00ecnh trong ph\u1ea1m vi Sales. \u2022 Trong \u00f4 D5, t\u1ea1o ra m\u1ed9t c\u00f4ng th\u1ee9c tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb Sales th\u1ea5p nh\u1ea5t cho kho\u1ea3ng period Fall \u00a9 IIG Vietnam. 31","Microsoft\u00ae Core Skills Excel 2010 Nhi\u1ec7m v\u1ee5 th\u1ef1c h\u00e0nh 5.2 \u2022 Kh\u00f4ng c\u00f3 t\u1eadp tin th\u1ef1c h\u00e0nh cho nh\u1eefng c\u00f4ng vi\u1ec7c n\u00e0y. \u0110\u01a1n gi\u1ea3n ch\u1ec9 c\u1ea7n m\u1edf m\u1ed9t workbook tr\u1ed1ng. \u2013 \u25cf Trong \u00f4 A1 c\u1ee7a m\u1ed9t b\u1ea3ng t\u00ednh, nh\u1eadp c\u00f4ng th\u1ee9c sau: = 5x2+7-12 \u2013 \u25cf Sao ch\u00e9p c\u00f4ng th\u1ee9c t\u1eeb \u00f4 A1 \u0111\u1ebfn \u00f4 A2:A5. Ch\u1ec9nh s\u1eeda t\u1eebng c\u00f4ng th\u1ee9c sao ch\u00e9p, \u0111\u1eb7t d\u1ea5u ngo\u1eb7c xung quanh c\u00e1c nh\u00f3m kh\u00e1c nhau \u0111\u1ec3 xem hi\u1ec7u qu\u1ea3. \u00a9 IIG Vietnam. 32","Microsoft\u00ae Core Skills Excel 2010 Nhi\u1ec7m v\u1ee5 th\u1ef1c h\u00e0nh 5.3 \u2022 C\u00e1c t\u1eadp tin th\u1ef1c h\u00e0nh cho c\u00e1c nhi\u1ec7m v\u1ee5 \u0111\u01b0\u1ee3c \u0111\u1eb7t trong th\u01b0 m\u1ee5c Excel \\\\ Objective5. N\u1ebfu b\u1ea1n mu\u1ed1n l\u01b0u c\u00e1c k\u1ebft qu\u1ea3 c\u1ee7a nhi\u1ec7m v\u1ee5, l\u01b0u ch\u00fang trong c\u00f9ng th\u01b0 m\u1ee5c v\u1edbi b\u1eb1ng c\u00e1ch th\u00eam t\u1eeb My tr\u01b0\u1edbc t\u00ean t\u1eadp tin \u0111\u1ec3 b\u1ea1n kh\u00f4ng ghi \u0111\u00e8 l\u00ean t\u1eadp tin th\u1ef1c h\u00e0nh ban \u0111\u1ea7u. \u2013 Trong workbook MultiplicationTable, tr\u00ean worksheet Practice, t\u1ea1o ra m\u1ed9t c\u00f4ng th\u1ee9c trong c\u00e1c \u00f4 B2:T20 \u0111\u1ec3 ho\u00e0n th\u00e0nh b\u1ea3ng nh\u00e2n c\u00e1c s\u1ed1 t\u1eeb 1 \u0111\u1ebfn 20. (Th\u1eed th\u00e1ch: T\u1ea1o b\u1ea3ng trong s\u00e1u b\u01b0\u1edbc ho\u1eb7c \u00edt h\u01a1n) So s\u00e1nh c\u00f4ng th\u1ee9c trong b\u1ea3ng nh\u00e2n c\u1ee7a b\u1ea1n v\u1edbi nh\u1eefng c\u00e1i tr\u00ean worksheet Results. \u2013 Trong workbook SalesBySeason, tr\u00ean worksheet Summary, hi\u1ec3n th\u1ecb t\u1ed5ng doanh s\u1ed1 cho t\u1eebng giai \u0111o\u1ea1n trong c\u00e1c \u00f4 B2:B5 b\u1eb1ng c\u00e1ch tham chi\u1ebfu c\u00e1c worksheet t\u01b0\u01a1ng \u1ee9ng. \u00a9 IIG Vietnam. 33","Microsoft\u00ae Core Skills Excel 2010 Nhi\u1ec7m v\u1ee5 th\u1ef1c h\u00e0nh 5.4 \u2022 C\u00e1c t\u1eadp tin th\u1ef1c h\u00e0nh cho c\u00e1c nhi\u1ec7m v\u1ee5 \u0111\u01b0\u1ee3c \u0111\u1eb7t trong th\u01b0 m\u1ee5c Excel \\\\ Objective5. N\u1ebfu b\u1ea1n mu\u1ed1n l\u01b0u c\u00e1c k\u1ebft qu\u1ea3 c\u1ee7a nhi\u1ec7m v\u1ee5, l\u01b0u ch\u00fang trong c\u00f9ng th\u01b0 m\u1ee5c v\u1edbi b\u1eb1ng c\u00e1ch th\u00eam t\u1eeb My tr\u01b0\u1edbc t\u00ean t\u1eadp tin \u0111\u1ec3 b\u1ea1n kh\u00f4ng ghi \u0111\u00e8 l\u00ean t\u1eadp tin th\u1ef1c h\u00e0nh ban \u0111\u1ea7u. \u2013 Tr\u00ean worksheet Expense Statement c\u1ee7a workbook ConditionalFormula, l\u00e0m nh\u01b0 sau: \u2022 Trong \u00f4 C25, s\u1eed d\u1ee5ng h\u00e0m AND() \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh xem s\u1ed1 t\u1ed5ng Entertainment l\u00e0 \u00edt h\u01a1n $ 200,00 v\u00e0 s\u1ed1 t\u1ed5ng Misc. l\u00e0 \u00edt h\u01a1n $ 100,00. \u00a9 IIG Vietnam. 34","Microsoft\u00ae Core Skills Excel 2010 Nhi\u1ec7m v\u1ee5 th\u1ef1c h\u00e0nh 5.4 (tt) \u2022 Trong \u00f4 C26, s\u1eed d\u1ee5ng h\u00e0m OR() \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh xem s\u1ed1 t\u1ed5ng Entertainment l\u00e0 nhi\u1ec1u h\u01a1n $ 200,00 ho\u1eb7c s\u1ed1 t\u1ed5ng Misc. l\u00e0 nhi\u1ec1u h\u01a1n $ 100,00. \u2022 Trong \u00f4 C27, s\u1eed d\u1ee5ng h\u00e0m IF() \u0111\u1ec3 hi\u1ec3n th\u1ecb v\u0103n b\u1ea3n \\\"Expenses are okay\u201c n\u1ebfu h\u00e0m trong C25 \u0111\u00e1nh gi\u00e1 TRUE v\u00e0 \\\"Expenses are too high\\\" n\u1ebfu n\u00f3 \u0111\u00e1nh gi\u00e1 FALSE. \u2022 Trong \u00f4 C28, s\u1eed d\u1ee5ng h\u00e0m IF() \u0111\u1ec3 hi\u1ec3n th\u1ecb v\u0103n b\u1ea3n \\\"Expenses are okay\\\" n\u1ebfu h\u00e0m trong C26 \u0111\u00e1nh gi\u00e1 NOT TRUE v\u00e0 \\\"Expenses are too high\u201c n\u1ebfu n\u00f3 \u0111\u00e1nh gi\u00e1 NOT FALSE. \u2022 Th\u00eam 60,00 v\u00e0o c\u1ed9t Entertainment ho\u1eb7c c\u1ed9t Misc. \u0111\u1ec3 ki\u1ec3m tra k\u1ebft qu\u1ea3. \u00a9 IIG Vietnam. 35","Microsoft\u00ae Core Skills Excel 2010 Nhi\u1ec7m v\u1ee5 th\u1ef1c h\u00e0nh 5.5 \u2022 C\u00e1c t\u1eadp tin th\u1ef1c h\u00e0nh cho c\u00e1c nhi\u1ec7m v\u1ee5 \u0111\u01b0\u1ee3c \u0111\u1eb7t trong th\u01b0 m\u1ee5c Excel \\\\ Objective5. N\u1ebfu b\u1ea1n mu\u1ed1n l\u01b0u c\u00e1c k\u1ebft qu\u1ea3 c\u1ee7a nhi\u1ec7m v\u1ee5, l\u01b0u ch\u00fang trong c\u00f9ng th\u01b0 m\u1ee5c v\u1edbi b\u1eb1ng c\u00e1ch th\u00eam t\u1eeb My tr\u01b0\u1edbc t\u00ean t\u1eadp tin \u0111\u1ec3 b\u1ea1n kh\u00f4ng ghi \u0111\u00e8 l\u00ean t\u1eadp tin th\u1ef1c h\u00e0nh ban \u0111\u1ea7u. \u2013 Trong workbook MultiplicationTable, tr\u00ean worksheet Results, x\u00e1c \u0111\u1ecbnh c\u00e1c \u00f4 A1:T1 nh\u01b0 m\u1ed9t ph\u1ea1m vi \u0111\u01b0\u1ee3c \u0111\u1eb7t t\u00ean FirstRow, v\u00e0 c\u00e1c \u00f4 A1:A20 l\u00e0 m\u1ed9t ph\u1ea1m vi \u0111\u01b0\u1ee3c \u0111\u1eb7t t\u00ean ColumnA. Sau \u0111\u00f3, thay \u0111\u1ed5i c\u00f4ng th\u1ee9c trong c\u00e1c \u00f4 B2:T20 \u0111\u1ec3 tham chi\u1ebfu c\u00e1c ph\u1ea1m vi \u0111\u01b0\u1ee3c \u0111\u1eb7t t\u00ean. \u00a9 IIG Vietnam. 36","Microsoft\u00ae Core Skills Excel 2010 Nhi\u1ec7m v\u1ee5 th\u1ef1c h\u00e0nh 5.6 \u2022 C\u00e1c t\u1eadp tin th\u1ef1c h\u00e0nh cho c\u00e1c nhi\u1ec7m v\u1ee5 \u0111\u01b0\u1ee3c \u0111\u1eb7t trong th\u01b0 m\u1ee5c Excel \\\\ Objective5. N\u1ebfu b\u1ea1n mu\u1ed1n l\u01b0u c\u00e1c k\u1ebft qu\u1ea3 c\u1ee7a nhi\u1ec7m v\u1ee5, l\u01b0u ch\u00fang trong c\u00f9ng th\u01b0 m\u1ee5c v\u1edbi b\u1eb1ng c\u00e1ch th\u00eam t\u1eeb My tr\u01b0\u1edbc t\u00ean t\u1eadp tin \u0111\u1ec3 b\u1ea1n kh\u00f4ng ghi \u0111\u00e8 l\u00ean t\u1eadp tin th\u1ef1c h\u00e0nh ban \u0111\u1ea7u. \u2013 Tr\u00ean worksheet Product Sales c\u1ee7a workbook CellRange, trong c\u00e1c \u00f4 C95, C101 v\u00e0 C104, t\u00ednh to\u00e1n t\u1ed5ng doanh thu cho m\u1ed7i th\u1ec3 lo\u1ea1i b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng ph\u1ea1m vi tham chi\u1ebfu \u00f4 t\u01b0\u01a1ng \u0111\u1ed1i (relative cell range reference). \u2013 \u25cf Trong \u00f4 C86 c\u1ee7a worksheet Product Sales, t\u00ednh to\u00e1n t\u1ed5ng doanh s\u1ed1 Cacti b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng m\u1ed9t ph\u1ea1m vi tham chi\u1ebfu \u00f4 tuy\u1ec7t \u0111\u1ed1i (absolute cell range reference). \u00a9 IIG Vietnam. 37","Microsoft\u00ae Core Skills Excel 2010 6. Tr\u00ecnh b\u00e0y d\u1eef li\u1ec7u tr\u1ef1c quan \u20226.1 T\u1ea1o Charts d\u1ef1a tr\u00ean d\u1eef li\u1ec7u Worksheet \u20226.2 \u00c1p d\u1ee5ng v\u00e0 thao t\u00e1c v\u1edbi Illustrations \u20226.3 T\u1ea1o v\u00e0 hi\u1ec7u ch\u1ec9nh h\u00ecnh \u1ea3nh \u20226.4 \u00c1p d\u1ee5ng Sparklines \u00a9 IIG Vietnam. 38","Microsoft\u00ae Core Skills Excel 2010 Nhi\u1ec7m v\u1ee5 th\u1ef1c h\u00e0nh 6.1 \u2022 C\u00e1c t\u1eadp tin th\u1ef1c h\u00e0nh cho c\u00e1c nhi\u1ec7m v\u1ee5 \u0111\u01b0\u1ee3c \u0111\u1eb7t trong th\u01b0 m\u1ee5c Excel \\\\ Objective6. N\u1ebfu b\u1ea1n mu\u1ed1n l\u01b0u c\u00e1c k\u1ebft qu\u1ea3 c\u1ee7a nhi\u1ec7m v\u1ee5, l\u01b0u ch\u00fang trong c\u00f9ng th\u01b0 m\u1ee5c v\u1edbi b\u1eb1ng c\u00e1ch th\u00eam t\u1eeb My tr\u01b0\u1edbc t\u00ean t\u1eadp tin \u0111\u1ec3 b\u1ea1n kh\u00f4ng ghi \u0111\u00e8 l\u00ean t\u1eadp tin th\u1ef1c h\u00e0nh ban \u0111\u1ea7u. \u2013 Trong workbook DataSource, s\u1eed d\u1ee5ng d\u1eef li\u1ec7u tr\u00ean worksheet Seattle \u0111\u1ec3 v\u1ebd m\u1ed9t pie chart \u0111\u01a1n gi\u1ea3n. \u2013 Trong workbook Plotting, tr\u00ean worksheet Sales, s\u1eed d\u1ee5ng d\u1eef li\u1ec7u \u0111\u1ec3 v\u1ebd m\u1ed9t 2-D column chart \u0111\u01a1n gi\u1ea3n. Sau \u0111\u00f3 chuy\u1ec3n \u0111\u1ed5i gi\u1eefa c\u00e1c h\u00e0ng v\u00e0 c\u00e1c c\u1ed9t. \u2013 Trong workbook Plotting, tr\u00ean worksheet Sales, thay \u0111\u1ed5i chart th\u00e0nh m\u1ed9t 3-D Clustered Column chart. Sau \u0111\u00f3 \u00e1p d\u1ee5ng Layout 1, Style 34, v\u00e0 Subtle Effect \u2013 Accent 3 shape style. \u00a9 IIG Vietnam. 39","Microsoft\u00ae Core Skills Excel 2010 Nhi\u1ec7m v\u1ee5 th\u1ef1c h\u00e0nh 6.1 (tt) \u2013 Trong workbook SizingMoving, tr\u00ean worksheet Sales, t\u0103ng k\u00edch th\u01b0\u1edbc c\u1ee7a chart cho \u0111\u1ebfn khi n\u00f3 chi\u1ebfm c\u00e1c \u00f4 A1:L23. Sau \u0111\u00f3 di chuy\u1ec3n n\u00f3 \u0111\u1ebfn m\u1ed9t chart sheet \u0111\u01b0\u1ee3c \u0111\u1eb7t t\u00ean l\u00e0 Sales Chart. \u2013 Trong workbook Editing, tr\u00ean worksheet Sales, thay \u0111\u1ed5i doanh s\u1ed1 October c\u1ee7a lo\u1ea1i Flowers th\u00e0nh 888.25. Sau \u0111\u00f3 th\u00eam c\u00e1c chu\u1ed7i d\u1eef li\u1ec7u (data series) November v\u00e0o chart, v\u00e0 thay \u0111\u1ed5i c\u00e1ch d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng v\u1ebd \u0111\u1ec3 b\u1ea1n c\u00f3 th\u1ec3 so s\u00e1nh doanh s\u1ed1 c\u1ee7a hai th\u00e1ng. \u2013 Trong workbook ChartElements, tr\u00ean worksheet Seattle, th\u00eam t\u1ef1a \u0111\u1ec1 Air Quality Index Report cho chart. Sau \u0111\u00f3 th\u00eam data labels \u0111\u1ec3 th\u1ec3 hi\u1ec7n m\u1ed1i quan h\u1ec7 ph\u1ea7n tr\u0103m c\u1ee7a m\u1ed7i d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c \u0111\u00e1nh d\u1ea5u v\u1edbi t\u1ed5ng th\u1ec3, kh\u00f4ng c\u00f3 d\u1ea5u th\u1eadp ph\u00e2n. \u00a9 IIG Vietnam. 40","Microsoft\u00ae Core Skills Excel 2010 Nhi\u1ec7m v\u1ee5 th\u1ef1c h\u00e0nh 6.2 \u2022 C\u00e1c t\u1eadp tin th\u1ef1c h\u00e0nh cho c\u00e1c nhi\u1ec7m v\u1ee5 \u0111\u01b0\u1ee3c \u0111\u1eb7t trong th\u01b0 m\u1ee5c Excel \\\\ Objective6. N\u1ebfu b\u1ea1n mu\u1ed1n l\u01b0u c\u00e1c k\u1ebft qu\u1ea3 c\u1ee7a nhi\u1ec7m v\u1ee5, l\u01b0u ch\u00fang trong c\u00f9ng th\u01b0 m\u1ee5c v\u1edbi b\u1eb1ng c\u00e1ch th\u00eam t\u1eeb My tr\u01b0\u1edbc t\u00ean t\u1eadp tin \u0111\u1ec3 b\u1ea1n kh\u00f4ng ghi \u0111\u00e8 l\u00ean t\u1eadp tin th\u1ef1c h\u00e0nh ban \u0111\u1ea7u. \u2013 M\u1edf worksheet Budget c\u1ee7a workbook PersonalMonthlyBudget, ch\u00e8n m\u1ed9t Clip Art c\u00e1ch \u0111i\u1ec7u ng\u00e2n s\u00e1ch d\u1ea1ng \u1ea3nh sau t\u1ef1a \u0111\u1ec1 Monthly Budget, v\u00e0 thay \u0111\u1ed5i k\u00edch c\u1ee1 c\u1ee7a n\u00f3 \u0111\u1ebfn chi\u1ec1u cao 0,6 inch. \u00a9 IIG Vietnam. 41","Microsoft\u00ae Core Skills Excel 2010 Nhi\u1ec7m v\u1ee5 th\u1ef1c h\u00e0nh 6.2 (tt) \u2013 Trong workbook SmartArt v\u00e0o worksheet Diagram, ch\u00e8n m\u1ed9t Basic Bending Process diagram. Th\u00eam c\u00e1c v\u0103n b\u1ea3n sau v\u00e0o c\u00e1c shape: Take order, Create invoice, Fulfill order, Ship order, Order receive. Sau \u0111\u00f3, \u00e1p d\u1ee5ng style Powdered v\u00e0 m\u1ed9t trong nh\u1eefng Colorful color schemes. \u2013 Trong workbook Shapes, worksheet Sales By Category, v\u1ebd m\u1ed9t m\u0169i t\u00ean tr\u1ecf tr\u00e1i l\u1edbn, m\u00e0u \u0111\u1ecf, c\u00f3 ch\u1ee9a Successful weekend sale b\u00ean ph\u1ea3i c\u1ee7a Tools Total amount. \u2013 Trong workbook DataSource, tr\u00ean worksheet Seattle, ch\u00e8n m\u1ed9t m\u00e0n h\u00ecnh c\u1eaft x\u00e9n c\u1ee7a slide 5 t\u1eeb c\u00e1c b\u00e0i tr\u00ecnh b\u00e0y Pollution b\u00ean d\u01b0\u1edbi d\u1eef li\u1ec7u. \u00a9 IIG Vietnam. 42","Microsoft\u00ae Core Skills Excel 2010 Nhi\u1ec7m v\u1ee5 th\u1ef1c h\u00e0nh 6.3 \u2022 C\u00e1c t\u1eadp tin th\u1ef1c h\u00e0nh cho c\u00e1c nhi\u1ec7m v\u1ee5 \u0111\u01b0\u1ee3c \u0111\u1eb7t trong th\u01b0 m\u1ee5c Excel \\\\ Objective6. N\u1ebfu b\u1ea1n mu\u1ed1n l\u01b0u c\u00e1c k\u1ebft qu\u1ea3 c\u1ee7a nhi\u1ec7m v\u1ee5, l\u01b0u ch\u00fang trong c\u00f9ng th\u01b0 m\u1ee5c v\u1edbi b\u1eb1ng c\u00e1ch th\u00eam t\u1eeb My tr\u01b0\u1edbc t\u00ean t\u1eadp tin \u0111\u1ec3 b\u1ea1n kh\u00f4ng ghi \u0111\u00e8 l\u00ean t\u1eadp tin th\u1ef1c h\u00e0nh ban \u0111\u1ea7u. \u2013 M\u1edf workbook Picture, v\u00e0 ch\u00e8n v\u00e0o h\u00ecnh Logo2 v\u00e0o g\u00f3c tr\u00ean b\u00ean tr\u00e1i c\u1ee7a ti\u00eau \u0111\u1ec1 worksheet Employees. Thay \u0111\u1ed5i quy m\u00f4 c\u1ee7a logo \u0111\u1ec3 n\u00f3 kh\u00f4ng che khu\u1ea5t \u00f4 A1 c\u1ee7a worksheet. \u2013 M\u1edf worksheet Sales c\u1ee7a workbook ClipArt, thay th\u1ebf h\u00ecnh \u1ea3nh c\u1ecf v\u1edbi h\u00ecnh \u1ea3nh VariegatedGrass, v\u00e0 sau \u0111\u00f3 \u00e1p d\u1ee5ng Paint Strokes artistic effect. Sau \u0111\u00f3 \u00e1p d\u1ee5ng m\u1ed9t c\u1ea1nh m\u1ec1m 5 pt cho t\u1ea5t c\u1ea3 c\u00e1c h\u00ecnh \u1ea3nh \u00a9 IIG Vietnam. 43","Microsoft\u00ae Core Skills Excel 2010 Nhi\u1ec7m v\u1ee5 th\u1ef1c h\u00e0nh 6.4 \u2022 C\u00e1c t\u1eadp tin th\u1ef1c h\u00e0nh cho c\u00e1c nhi\u1ec7m v\u1ee5 \u0111\u01b0\u1ee3c \u0111\u1eb7t trong th\u01b0 m\u1ee5c Excel \\\\ Objective6. N\u1ebfu b\u1ea1n mu\u1ed1n l\u01b0u c\u00e1c k\u1ebft qu\u1ea3 c\u1ee7a nhi\u1ec7m v\u1ee5, l\u01b0u ch\u00fang trong c\u00f9ng th\u01b0 m\u1ee5c v\u1edbi b\u1eb1ng c\u00e1ch th\u00eam t\u1eeb My tr\u01b0\u1edbc t\u00ean t\u1eadp tin \u0111\u1ec3 b\u1ea1n kh\u00f4ng ghi \u0111\u00e8 l\u00ean t\u1eadp tin th\u1ef1c h\u00e0nh ban \u0111\u1ea7u. \u2013 Trong workbook Sparklines, tr\u00ean worksheet January, t\u00f3m t\u1eaft c\u00e1c d\u1eef li\u1ec7u cho m\u1ed7i ng\u00e0y b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng m\u1ed9t Line sparkline. \u00c1p d\u1ee5ng Sparkline Style Accent 6, Darker 25% style, v\u00e0 sau \u0111\u00f3 hi\u1ec3n th\u1ecb t\u1ea5t c\u1ea3 c\u00e1c data marker m\u00e0 kh\u00f4ng \u0111\u1eb7t nh\u1ea5n m\u1ea1nh v\u00e0o b\u1ea5t k\u1ef3 lo\u1ea1i h\u00ecnh c\u1ee5 th\u1ec3 c\u1ee7a data marker. \u2013 Trong workbook Sparklines, tr\u00ean worksheet February, t\u00f3m t\u1eaft c\u00e1c d\u1eef li\u1ec7u cho m\u1ed7i gi\u1edd b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng m\u1ed9t Column sparkline. \u00c1p d\u1ee5ng Sparkline Style Colorful #4 style, v\u00e0 sau \u0111\u00f3 nh\u1ea5n m\u1ea1nh First Point v\u00e0 \u0111\u00e1nh d\u1ea5u Last Point data markers. \u00a9 IIG Vietnam. 44","Microsoft\u00ae Core Skills Excel 2010 7. Chia s\u1ebb d\u1eef li\u1ec7u Worksheet v\u1edbi ng\u01b0\u1eddi d\u00f9ng kh\u00e1c \u20227.1 Chia s\u1ebb b\u1ea3ng t\u00ednh (Spreadsheets) \u20227.2 Qu\u1ea3n l\u00fd b\u00ecnh lu\u1eadn (Comments) \u00a9 IIG Vietnam. 45","Microsoft\u00ae Core Skills Excel 2010 Nhi\u1ec7m v\u1ee5 th\u1ef1c h\u00e0nh 7.1 \u2022 C\u00e1c t\u1eadp tin th\u1ef1c h\u00e0nh cho c\u00e1c nhi\u1ec7m v\u1ee5 \u0111\u01b0\u1ee3c \u0111\u1eb7t trong th\u01b0 m\u1ee5c Excel \\\\ Objective7. N\u1ebfu b\u1ea1n mu\u1ed1n l\u01b0u c\u00e1c k\u1ebft qu\u1ea3 c\u1ee7a nhi\u1ec7m v\u1ee5, l\u01b0u ch\u00fang trong c\u00f9ng th\u01b0 m\u1ee5c v\u1edbi b\u1eb1ng c\u00e1ch th\u00eam t\u1eeb My tr\u01b0\u1edbc t\u00ean t\u1eadp tin \u0111\u1ec3 b\u1ea1n kh\u00f4ng ghi \u0111\u00e8 l\u00ean t\u1eadp tin th\u1ef1c h\u00e0nh ban \u0111\u1ea7u. \u2013 M\u1edf workbook Saving, v\u00e0 l\u01b0u l\u1ea1i v\u1edbi t\u00ean MOS- Compatible \u0111\u1ec3 c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c xem v\u00e0 l\u00e0m vi\u1ec7c b\u1edfi m\u1ed9t \u0111\u1ed3ng nghi\u1ec7p \u0111ang s\u1eed d\u1ee5ng Excel 2003. \u00a9 IIG Vietnam. 46","Microsoft\u00ae Core Skills Excel 2010 Nhi\u1ec7m v\u1ee5 th\u1ef1c h\u00e0nh 7.1 (tt) \u2013 L\u01b0u workbook MOS-Compatible v\u1edbi t\u00ean MOS-Template \u0111\u1ec3 n\u00f3 c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng nh\u01b0 l\u00e0 c\u01a1 s\u1edf cho c\u00e1c workbook kh\u00e1c t\u01b0\u01a1ng t\u1ef1 trong t\u01b0\u01a1ng lai. \u2013 L\u01b0u workbook MOS-Template v\u1edbi t\u00ean MOS-Macro \u0111\u1ec3 ng\u01b0\u1eddi d\u00f9ng s\u1ebd c\u00f3 th\u1ec3 ch\u1ea1y c\u00e1c macro \u0111\u00ednh k\u00e8m. \u2013 T\u1eeb Backstage xem workbook MOS-Macro, g\u1eedi c\u00e1c macroenabled workbook cho ch\u00ednh m\u00ecnh nh\u01b0 l\u00e0 m\u1ed9t t\u1eadp tin \u0111\u00ednh k\u00e8m tin nh\u1eafn email. \u2013 T\u1eeb Backstage xem workbook MOS-Macro, ch\u1ec9 g\u1eedi worksheet Sales - Revenue cho m\u00ecnh nh\u01b0 m\u1ed9t t\u1eadp tin PDF \u0111\u01b0\u1ee3c \u0111\u00ednh v\u00e0o m\u1ed9t email. \u00a9 IIG Vietnam. 47","Microsoft\u00ae Core Skills Excel 2010 Nhi\u1ec7m v\u1ee5 th\u1ef1c h\u00e0nh 7.2 \u2022C\u00e1c t\u1eadp tin th\u1ef1c h\u00e0nh cho c\u00e1c nhi\u1ec7m v\u1ee5 \u0111\u01b0\u1ee3c \u0111\u1eb7t trong th\u01b0 m\u1ee5c Excel \\\\ Objective7. N\u1ebfu b\u1ea1n mu\u1ed1n l\u01b0u c\u00e1c k\u1ebft qu\u1ea3 c\u1ee7a nhi\u1ec7m v\u1ee5, l\u01b0u ch\u00fang trong c\u00f9ng th\u01b0 m\u1ee5c v\u1edbi b\u1eb1ng c\u00e1ch th\u00eam t\u1eeb My tr\u01b0\u1edbc t\u00ean t\u1eadp tin \u0111\u1ec3 b\u1ea1n kh\u00f4ng ghi \u0111\u00e8 l\u00ean t\u1eadp tin th\u1ef1c h\u00e0nh ban \u0111\u1ea7u. \u2013M\u1edf workbook Comments v\u00e0 hi\u1ec3n th\u1ecb t\u1ea5t c\u1ea3 c\u00e1c comment. \u00a9 IIG Vietnam. 48","Microsoft\u00ae Core Skills Excel 2010 Nhi\u1ec7m v\u1ee5 th\u1ef1c h\u00e0nh 7.2 (tt) \u2013 M\u1edf worksheet Products c\u1ee7a workbook Comments, trong \u00f4 A59, th\u00eam v\u00e0o comment \u201cWhat happened to the common name?\u201d Sau \u0111\u00f3 x\u00f3a comment \u0111\u01b0\u1ee3c \u0111\u00ednh k\u00e8m \u1edf \u00f4 E108. \u2013 Tr\u00ean worksheet Products c\u1ee7a workbook Comments, th\u00eam \u201cThese must be special-ordered\u201d v\u00e0o cu\u1ed1i comment \u0111\u01b0\u1ee3c \u0111\u00ednh k\u00e8m v\u00e0o \u00f4 A103. Thay \u0111\u1ed5i k\u00edch th\u01b0\u1edbc comment box \u0111\u1ec3 t\u1ea5t c\u1ea3 c\u00e1c v\u0103n b\u1ea3n c\u1ee7a c\u00e1c comment c\u00f3 th\u1ec3 nh\u00ecn th\u1ea5y, v\u00e0 di chuy\u1ec3n comment box \u0111\u1ebfn m\u1ed9t v\u00f9ng tr\u1ed1ng c\u1ee7a worksheet. \u2013 Trong workbook Comments, \u1ea9n t\u1ea5t c\u1ea3 c\u00e1c comment. \u00a9 IIG Vietnam. 49","Microsoft\u00ae Core Skills Excel 2010 8. Ph\u00e2n t\u00edch v\u00e0 t\u1ed5 ch\u1ee9c d\u1eef li\u1ec7u \u20228.1 L\u1ecdc d\u1eef li\u1ec7u (Filter Data) \u20228.2 S\u1eafp x\u1ebfp d\u1eef li\u1ec7u (Sort Data) \u20228.3 \u00c1p d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n (Conditional Formatting) \u00a9 IIG Vietnam. 50","Microsoft\u00ae Core Skills Excel 2010 Nhi\u1ec7m v\u1ee5 th\u1ef1c h\u00e0nh 8.1 \u2022 C\u00e1c t\u1eadp tin th\u1ef1c h\u00e0nh cho c\u00e1c nhi\u1ec7m v\u1ee5 \u0111\u01b0\u1ee3c \u0111\u1eb7t trong th\u01b0 m\u1ee5c Excel \\\\ Objective8. N\u1ebfu b\u1ea1n mu\u1ed1n l\u01b0u c\u00e1c k\u1ebft qu\u1ea3 c\u1ee7a nhi\u1ec7m v\u1ee5, l\u01b0u ch\u00fang trong c\u00f9ng th\u01b0 m\u1ee5c v\u1edbi b\u1eb1ng c\u00e1ch th\u00eam t\u1eeb My tr\u01b0\u1edbc t\u00ean t\u1eadp tin \u0111\u1ec3 b\u1ea1n kh\u00f4ng ghi \u0111\u00e8 l\u00ean t\u1eadp tin th\u1ef1c h\u00e0nh ban \u0111\u1ea7u. \u2013 M\u1edf workbook Filtering. Tr\u00ean worksheet OrdersJan, ch\u1ec9 hi\u1ec3n th\u1ecb nh\u1eefng h\u00e0ng ch\u1ee9a WA (ti\u1ec3u bang Washington) trong c\u1ed9t ShipRegion. Sau \u0111\u00f3 hi\u1ec3n th\u1ecb l\u1ea1i t\u1ea5t c\u1ea3 c\u00e1c h\u00e0ng. \u00a9 IIG Vietnam. 51","Microsoft\u00ae Core Skills Excel 2010 Nhi\u1ec7m v\u1ee5 th\u1ef1c h\u00e0nh 8.1 (tt) \u2013 Tr\u00ean worksheet OrdersJan c\u1ee7a workbook Filtering, hi\u1ec3n th\u1ecb c\u00e1c \u0111\u01a1n \u0111\u1eb7t h\u00e0ng v\u1eadn chuy\u1ec3n v\u00e0o ng\u00e0y 23 , 24, v\u00e0 25 th\u00e1ng 1. Sau \u0111\u00f3, ch\u1ec9 hi\u1ec3n th\u1ecb c\u00e1c \u0111\u01a1n \u0111\u1eb7t h\u00e0ng \u0111\u00e3 \u0111\u01b0\u1ee3c v\u1eadn chuy\u1ec3n \u0111\u1ebfn c\u00e1c ti\u1ec3u bang kh\u00e1c so v\u1edbi Washington (WA) trong th\u1eddi gian \u0111\u00f3. \u2013 Tr\u00ean worksheet OrdersFeb c\u1ee7a workbook Filtering, ch\u1ec9 hi\u1ec3n th\u1ecb c\u00e1c h\u00e0ng m\u00e0 c\u00e1c \u00f4 trong c\u1ed9t Freight \u0111\u01b0\u1ee3c t\u00f4 m\u00e0u. Sau \u0111\u00f3 hi\u1ec3n th\u1ecb ch\u1ec9 c\u00f3 c\u00e1c h\u00e0ng m\u00e0 c\u00e1c \u00f4 trong c\u1ed9t Freight kh\u00f4ng c\u00f3 t\u00f4 m\u00e0u. Cu\u1ed1i c\u00f9ng, hi\u1ec3n th\u1ecb l\u1ea1i t\u1ea5t c\u1ea3 c\u00e1c h\u00e0ng. \u00a9 IIG Vietnam. 52","Microsoft\u00ae Core Skills Excel 2010 Nhi\u1ec7m v\u1ee5 th\u1ef1c h\u00e0nh 8.2 \u2022 C\u00e1c t\u1eadp tin th\u1ef1c h\u00e0nh cho c\u00e1c nhi\u1ec7m v\u1ee5 \u0111\u01b0\u1ee3c \u0111\u1eb7t trong th\u01b0 m\u1ee5c Excel \\\\ Objective8. N\u1ebfu b\u1ea1n mu\u1ed1n l\u01b0u c\u00e1c k\u1ebft qu\u1ea3 c\u1ee7a nhi\u1ec7m v\u1ee5, l\u01b0u ch\u00fang trong c\u00f9ng th\u01b0 m\u1ee5c v\u1edbi b\u1eb1ng c\u00e1ch th\u00eam t\u1eeb My tr\u01b0\u1edbc t\u00ean t\u1eadp tin \u0111\u1ec3 b\u1ea1n kh\u00f4ng ghi \u0111\u00e8 l\u00ean t\u1eadp tin th\u1ef1c h\u00e0nh ban \u0111\u1ea7u. \u2013 Trong workbook Sorting, s\u1eafp x\u1ebfp v\u00f9ng d\u1eef li\u1ec7u (data range) tr\u00ean worksheet SalesByCategory theo Category. \u2013 S\u1eafp x\u1ebfp v\u00f9ng d\u1eef li\u1ec7u tr\u00ean worksheet SalesByCategory theo Category v\u00e0 sau \u0111\u00f3 theo Price. \u00a9 IIG Vietnam. 53","Microsoft\u00ae Core Skills Excel 2010 Nhi\u1ec7m v\u1ee5 th\u1ef1c h\u00e0nh 8.3 \u2022 C\u00e1c t\u1eadp tin th\u1ef1c h\u00e0nh cho c\u00e1c nhi\u1ec7m v\u1ee5 \u0111\u01b0\u1ee3c \u0111\u1eb7t trong th\u01b0 m\u1ee5c Excel \\\\ Objective8. N\u1ebfu b\u1ea1n mu\u1ed1n l\u01b0u c\u00e1c k\u1ebft qu\u1ea3 c\u1ee7a nhi\u1ec7m v\u1ee5, l\u01b0u ch\u00fang trong c\u00f9ng th\u01b0 m\u1ee5c v\u1edbi b\u1eb1ng c\u00e1ch th\u00eam t\u1eeb My tr\u01b0\u1edbc t\u00ean t\u1eadp tin \u0111\u1ec3 b\u1ea1n kh\u00f4ng ghi \u0111\u00e8 l\u00ean t\u1eadp tin th\u1ef1c h\u00e0nh ban \u0111\u1ea7u. \u2013 Trong workbook ConditionalFormatting, worksheet Orders, \u0111\u1ecbnh d\u1ea1ng t\u00ean Seattle trong c\u1ed9t City v\u1edbi v\u0103n b\u1ea3n m\u00e0u \u0111\u1ecf. \u00a9 IIG Vietnam. 54","Microsoft\u00ae Core Skills Excel 2010 Nhi\u1ec7m v\u1ee5 th\u1ef1c h\u00e0nh 8.3 (tt) \u2013 M\u1edf worksheet Details c\u1ee7a workbook ConditionalFormatting, hi\u1ec3n th\u1ecb icon Three Arrows (Colored) \u0111\u1ec3 \u0111\u1eb7t bi\u1ec3u t\u01b0\u1ee3ng cho t\u1ea5t c\u1ea3 c\u00e1c gi\u00e1 tr\u1ecb trong Extended Price c\u1ed9t. Sau \u0111\u00f3 hi\u1ec3n th\u1ecb c\u00e1c thanh d\u1eef li\u1ec7u m\u00e0u xanh cho c\u00e1c gi\u00e1 tr\u1ecb t\u01b0\u01a1ng t\u1ef1. Cu\u1ed1i c\u00f9ng, trong c\u00f9ng m\u1ed9t c\u1ed9t, \u0111i\u1ec1n v\u00e0o t\u1ea5t c\u1ea3 c\u00e1c \u00f4 ch\u1ee9a c\u00e1c gi\u00e1 tr\u1ecb tr\u00ean $ 100 v\u1edbi m\u00e0u v\u00e0ng s\u00e1ng. \u2013 M\u1edf worksheet Details c\u1ee7a workbook ConditionalFormatting, c\u1ea5u h\u00ecnh Excel ph\u1ea3i \u0111\u1ea7u ti\u00ean x\u1eed l\u00fd c\u00e1c quy t\u1eafc l\u00e0m cho c\u00e1c \u00f4 \u0111i\u1ec1n v\u00e0o v\u1edbi m\u00e0u v\u00e0ng, v\u00e0 kh\u00f4ng x\u1eed l\u00fd th\u00eam b\u1ea5t k\u1ef3 quy t\u1eafc n\u00e0o cho c\u00e1c \u00f4 \u0111\u00e1p \u1ee9ng \u0111i\u1ec1u ki\u1ec7n \u0111\u1ea7u ti\u00ean. \u00a9 IIG Vietnam. 55"]