{"id":9460,"date":"2025-01-02T07:06:59","date_gmt":"2025-01-02T07:06:59","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/02\/tong-hop-nhanh-nhung-ki-nang-can-thiet-cho-bai-thi-mos-excel-phan-2\/"},"modified":"2025-01-02T07:06:59","modified_gmt":"2025-01-02T07:06:59","slug":"tong-hop-nhanh-nhung-ki-nang-can-thiet-cho-bai-thi-mos-excel-phan-2","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/02\/tong-hop-nhanh-nhung-ki-nang-can-thiet-cho-bai-thi-mos-excel-phan-2\/","title":{"rendered":"T\u1ed5ng h\u1ee3p nhanh nh\u1eefng k\u0129 n\u0103ng c\u1ea7n thi\u1ebft cho b\u00e0i thi MOS Excel \u2013 Ph\u1ea7n 2"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Trong b\u00e0i vi\u1ebft n\u00e0y, H\u1ecdc Excel Online s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n nh\u1eefng k\u0129 n\u0103ng c\u1ea7n thi\u1ebft\u00a0cho b\u00e0i thi MOS Excel m\u1ed9t c\u00e1ch t\u1ed1t nh\u1ea5t. Nh\u1eefng k\u0129 n\u0103ng n\u00e0y s\u1ebd d\u1ef1a tr\u00ean y\u00eau c\u1ea7u c\u1ee7a Microsoft \u0111\u1ed1i v\u1edbi phi\u00ean b\u1ea3n\u00a0<strong>Specialist\u00a02013<\/strong>\u00a0, tuy nhi\u00ean b\u1ea1n c\u0169ng c\u00f3 th\u1ec3 \u00e1p d\u1ee5ng t\u01b0\u01a1ng t\u1ef1 \u0111\u1ed1i v\u1edbi c\u00e1c phi\u00ean b\u1ea3n kh\u00e1c.<\/p>\n<p>\u0110\u1ec3 xem c\u00e1c y\u00eau c\u1ea7u c\u1ee7a Microsoft b\u1ea1n tham kh\u1ea3o link sau:<\/p>\n<p><a href=\"https:\/\/www.microsoft.com\/en-us\/learning\/exam-77-420.aspx\">Y\u00eau c\u1ea7u v\u1ec1 k\u0129 n\u0103ng b\u00e0i thi MOS Specialist 2013\u00a0<\/a><\/p>\n<p>Danh s\u00e1ch b\u00e0i vi\u1ebft tr\u01b0\u1edbc:<\/p>\n<ul>\n<li><a href=\"http:\/\/blog.ezworkapp.com\/nhung-ki-nang-can-thiet-cho-bai-thi-mos-excel-1.html\">Ph\u1ea7n 1<\/a><\/li>\n<\/ul>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_61 counter-hierarchy ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<p class=\"ez-toc-title\">Xem nhanh<\/p>\n<p><label for=\"ez-toc-cssicon-toggle-item-67763b1272a76\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><\/span><\/span><\/label><\/p>\n<nav>\n<ul class=\"ez-toc-list ez-toc-list-level-1 \">\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/nhung-ki-nang-can-thiet-cho-bai-thi-mos-excel-2.html#Ki_nang_can_thiet_cho_bai_thi_MOS_Excel_%E2%80%93_phan_2\" title=\"K\u0129 n\u0103ng c\u1ea7n thi\u1ebft cho b\u00e0i thi MOS Excel \u2013 ph\u1ea7n 2\">K\u0129 n\u0103ng c\u1ea7n thi\u1ebft cho b\u00e0i thi MOS Excel \u2013 ph\u1ea7n 2<\/a>\n<ul class=\"ez-toc-list-level-4\">\n<li class=\"ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/nhung-ki-nang-can-thiet-cho-bai-thi-mos-excel-2.html#Nhap_du_lieu_vao_o_tinh_va_vung_tinh\" title=\"Nh\u1eadp d\u1eef li\u1ec7u v\u00e0o \u00f4 t\u00ednh v\u00e0 v\u00f9ng t\u00ednh\">Nh\u1eadp d\u1eef li\u1ec7u v\u00e0o \u00f4 t\u00ednh v\u00e0 v\u00f9ng t\u00ednh<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/nhung-ki-nang-can-thiet-cho-bai-thi-mos-excel-2.html#Dinh_dang_o_tinh_vung_tinh\" title=\"\u0110\u1ecbnh d\u1ea1ng \u00f4 t\u00ednh, v\u00f9ng t\u00ednh\">\u0110\u1ecbnh d\u1ea1ng \u00f4 t\u00ednh, v\u00f9ng t\u00ednh<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/nhung-ki-nang-can-thiet-cho-bai-thi-mos-excel-2.html#To_chuc_cac_o_tinh_va_vung_tinh\" title=\"T\u1ed5 ch\u1ee9c c\u00e1c \u00f4 t\u00ednh v\u00e0 v\u00f9ng t\u00ednh\">T\u1ed5 ch\u1ee9c c\u00e1c \u00f4 t\u00ednh v\u00e0 v\u00f9ng t\u00ednh<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"Ki_nang_can_thiet_cho_bai_thi_MOS_Excel_%E2%80%93_phan_2\"><\/span>K\u0129 n\u0103ng c\u1ea7n thi\u1ebft cho b\u00e0i thi MOS Excel \u2013 ph\u1ea7n 2<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Trong ph\u1ea7n 2, y\u00eau c\u1ea7u ta c\u1ea7n \u0111\u1ea1t \u0111\u01b0\u1ee3c \u0111\u00f3 l\u00e0\u00a0<strong>t\u1ea1o l\u1eadp, qu\u1ea3n l\u00fd \u00f4 t\u00ednh v\u00e0 v\u00f9ng t\u00ednh.\u00a0<\/strong>Nh\u1eefng k\u0129 n\u0103ng c\u1ea7n c\u00f3 c\u1ee5 th\u1ec3 nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-24269\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/tong-hop-mos-2-1.png\" width=\"817\" height=\"296\" title=\"tong-hop-mos-2-1\"><\/p>\n<h4><span class=\"ez-toc-section\" id=\"Nhap_du_lieu_vao_o_tinh_va_vung_tinh\"><\/span>Nh\u1eadp d\u1eef li\u1ec7u v\u00e0o \u00f4 t\u00ednh v\u00e0 v\u00f9ng t\u00ednh<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>B\u1ea1n c\u1ea7n bi\u1ebft c\u00e1ch:<\/p>\n<div class=\"code-block code-block-1\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ex101_92019-nho-57.gif\" title=\"ex101_92019-nho-57\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<ul>\n<li>\u0110\u01b0a d\u1eef li\u1ec7u v\u00e0o \u00f4 t\u00ednh (nh\u1eadp tay).<\/li>\n<li>T\u00ecm ki\u1ebfm\/thay th\u1ebf d\u1eef li\u1ec7u v\u1edbi ch\u1ee9c n\u0103ng\u00a0<strong><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-bo-dau-cham-trong-day-dien-thoai-tren-excel.html\">Find &amp; Replace<\/a>.\u00a0<\/strong><\/li>\n<li>Copy v\u00e0 paste d\u1eef li\u1ec7u, ch\u1ee9c n\u0103ng\u00a0<strong><a href=\"http:\/\/blog.ezworkapp.com\/su-dung-paste-special-trong-bai-thi-mos-excel-hieu-qua-nhat.html\">Paste Special<\/a>.<\/strong><\/li>\n<li>S\u1eed d\u1ee5ng\u00a0<strong><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-su-dung-autofill-trong-excel-2010-2013-2016.html\">AutoFill<\/a>.<\/strong><\/li>\n<li>M\u1edf r\u1ed9ng d\u1eef li\u1ec7u.<\/li>\n<li>Th\u00eam, x\u00f3a \u00f4 t\u00ednh.<\/li>\n<\/ul>\n<h4><span class=\"ez-toc-section\" id=\"Dinh_dang_o_tinh_vung_tinh\"><\/span>\u0110\u1ecbnh d\u1ea1ng \u00f4 t\u00ednh, v\u00f9ng t\u00ednh<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>\u0110\u1ed1i v\u1edbi \u0111\u1ecbnh d\u1ea1ng \u00f4 t\u00ednh hay v\u00f9ng t\u00ednh c\u00e1c k\u0129 n\u0103ng y\u00eau c\u1ea7u bao g\u1ed3m:<\/p>\n<ul>\n<li>G\u1ed9p \u00f4 (<a href=\"http:\/\/blog.ezworkapp.com\/su-dung-merge-cells-bai-thi-mos-excel.html\">Merge Cell<\/a>)<\/li>\n<li>\u0110i\u1ec1u ch\u1ec9nh h\u01b0\u1edbng v\u00e0 c\u0103n l\u1ec1 s\u1eed d\u1ee5ng\u00a0<strong><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-viet-chu-cheo-trong-excel.html\">Alignment v\u00e0 Indent<\/a><\/strong><\/li>\n<li>S\u1eed d\u1ee5ng c\u00e1c <a href=\"http:\/\/blog.ezworkapp.com\/dinh-dang-mos-excel-voi-format-cells.html\"><strong>\u0111\u1ecbnh d\u1ea1ng \u00f4, cell style, wordart\u2026<\/strong><\/a><\/li>\n<\/ul>\n<h4><span class=\"ez-toc-section\" id=\"To_chuc_cac_o_tinh_va_vung_tinh\"><\/span>T\u1ed5 ch\u1ee9c c\u00e1c \u00f4 t\u00ednh v\u00e0 v\u00f9ng t\u00ednh<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>Cu\u1ed1i c\u00f9ng, trong ph\u1ea7n 2 n\u00e0y, nh\u1eefng k\u0129 n\u0103ng b\u1ea1n ph\u1ea3i c\u00f3 s\u1ebd l\u00e0:<\/p>\n<ul>\n<li>\u00c1p d\u1ee5ng\u00a0<strong><a href=\"http:\/\/blog.ezworkapp.com\/ap-dung-conditional-formatting-trong-mos.html\">Conditional formatting<\/a><\/strong><\/li>\n<li>Th\u00eam \u0111\u01b0\u1eddng\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/thiet-lap-sparkline-excel.html\"><strong>sparklines<\/strong><\/a><\/li>\n<li>Thay \u0111\u1ed5i chi\u1ec1u h\u00e0ng v\u00e0 c\u1ed9t b\u1eb1ng\u00a0<strong>Transpose (<a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-su-dung-ham-transpose-chuyen-doi-hang-thanh-cot-cot-thanh-hang-trong-excel.html\">h\u00e0m <\/a><\/strong>ho\u1eb7c ch\u1ee9c n\u0103ng trong<strong><a href=\"http:\/\/blog.ezworkapp.com\/lam-nao-de-chuyen-du-lieu-trong-excel-chuyen-doi-hang-sang-cot-va-nguoc-lai.html\"> Paste Special<\/a>)<\/strong><\/li>\n<li>Thi\u1ebft l\u1eadp\u00a0<strong><a href=\"http:\/\/blog.ezworkapp.com\/thiet-lap-va-ap-dung-named-ranges-mos.html\">Name Range<\/a><\/strong><\/li>\n<li>T\u1ea1o<a href=\"http:\/\/blog.ezworkapp.com\/cach-va-gop-cot-trong-excel-2010-2013-2016.html\"><strong> Outline (group)<\/strong><\/a><\/li>\n<li>Hi\u1ec3u v\u1ec1 t\u00ednh n\u0103ng\u00a0<strong><a href=\"http:\/\/blog.ezworkapp.com\/44-%E2%97%8F-su-dung-cong-cu-subtotal-trong-excel.html\">Subtotals<\/a><\/strong><\/li>\n<\/ul>\n<p>\u00a0<\/p>\n<p>N\u1ebfu b\u1ea1n v\u1eabn ch\u01b0a bi\u1ebft ph\u1ea3i l\u00e0m nh\u01b0 n\u00e0o, h\u00e3y b\u1ea5m v\u00e0o nh\u1eefng ph\u1ea7n \u0111\u01b0\u1ee3c in \u0111\u1eadm b\u00f4i \u0111\u1ecf. \u0110\u00f3 l\u00e0 \u0111\u01b0\u1eddng link t\u1edbi nh\u1eefng b\u00e0i vi\u1ebft m\u00e0 H\u1ecdc Excel Online \u0111\u00e3 chu\u1ea9n b\u1ecb s\u1eb5n \u0111\u1ec3 tr\u00ecnh b\u00e0y m\u1ed9t c\u00e1ch chi ti\u1ebft nh\u1ea5t c\u00e1ch \u0111\u1ec3 x\u1eed l\u00ed c\u0169ng nh\u01b0 l\u00e0m ch\u1ee7 \u0111\u01b0\u1ee3c k\u0129 n\u0103ng trong danh s\u00e1ch y\u00eau c\u1ea7u.<\/p>\n<p>H\u00e3y d\u00e0nh th\u1eddi gian t\u00ecm hi\u1ec3u, \u0111\u1ecdc l\u1ea1i c\u1ea3 ph\u1ea7n th\u1ee9 nh\u1ea5t, v\u00e0 \u0111\u00f3n ch\u1edd nh\u1eefng ph\u1ea7n ti\u1ebfp theo nh\u00e9 c\u00e1c b\u1ea1n!<\/p>\n<\/div>\n<div class=\"uk-panel uk-margin uk-width-xlarge\">\n<p>Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc\" target=\"_blank\" rel=\"noopener\">T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0<span>\ud83d\udcd6<\/span><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-kich-hoat-khoa-hoc-tai-hoc-excel-online.html\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n<p>HKD H\u1ecdc Excel Online<br \/>S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n<div class=\"uk-panel uk-text-small uk-margin uk-margin-remove-bottom uk-text-center\">\n<p>\u00a9  document.currentScript.insertAdjacentHTML(&#8216;afterend&#8217;, &#8221; + new Intl.DateTimeFormat(document.documentElement.lang, {year: &#8216;numeric&#8217;}).format() + &#8221;);  H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ex101_92019-nho-57.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":9461,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-9460","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-co-ban"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/9460","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/comments?post=9460"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/9460\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/9461"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=9460"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=9460"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=9460"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}