{"id":9391,"date":"2025-01-02T03:09:35","date_gmt":"2025-01-02T03:09:35","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-5\/"},"modified":"2025-01-02T03:09:35","modified_gmt":"2025-01-02T03:09:35","slug":"tong-hop-nhanh-nhung-ki-nang-can-thiet-cho-bai-thi-mos-excel-phan-5","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-5\/","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 5"},"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 cho b\u00e0i thi MOS Excel hi\u1ec7u qu\u1ea3 v\u00e0 c\u00e1ch \u1ee9ng d\u1ee5ng th\u1eadt t\u1ed1t. 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<li><a href=\"http:\/\/blog.ezworkapp.com\/nhung-ki-nang-can-thiet-cho-bai-thi-mos-excel-2.html\">Ph\u1ea7n 2<\/a><\/li>\n<li><a href=\"http:\/\/blog.ezworkapp.com\/nhung-ki-nang-can-thiet-cho-bai-thi-mos-excel-3.html\">Ph\u1ea7n 3<\/a><\/li>\n<li><a href=\"http:\/\/blog.ezworkapp.com\/nhung-ki-nang-can-thiet-cho-bai-thi-mos-excel-4.html\">Ph\u1ea7n 4<\/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-6776036ee9bfd\" 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\/tong-hop-nhanh-nhung-ki-nang-can-thiet-cho-bai-thi-mos-excel-phan-5.html#Ki_nang_can_thiet_cho_bai_thi_MOS_Excel_2013_%E2%80%93_phan_5\" title=\"K\u0129 n\u0103ng c\u1ea7n thi\u1ebft cho b\u00e0i thi MOS Excel 2013 \u2013 ph\u1ea7n 5\">K\u0129 n\u0103ng c\u1ea7n thi\u1ebft cho b\u00e0i thi MOS Excel 2013 \u2013 ph\u1ea7n 5<\/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\/tong-hop-nhanh-nhung-ki-nang-can-thiet-cho-bai-thi-mos-excel-phan-5.html#Tao_lap_bieu_do\" title=\"T\u1ea1o l\u1eadp bi\u1ec3u \u0111\u1ed3\">T\u1ea1o l\u1eadp bi\u1ec3u \u0111\u1ed3<\/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\/tong-hop-nhanh-nhung-ki-nang-can-thiet-cho-bai-thi-mos-excel-phan-5.html#Dinh_dang_bieu_do\" title=\"\u0110\u1ecbnh d\u1ea1ng bi\u1ec3u \u0111\u1ed3\">\u0110\u1ecbnh d\u1ea1ng bi\u1ec3u \u0111\u1ed3<\/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\/tong-hop-nhanh-nhung-ki-nang-can-thiet-cho-bai-thi-mos-excel-phan-5.html#Chen_va_dinh_dang_cac_doi_tuong_khac\" title=\"Ch\u00e8n v\u00e0 \u0111\u1ecbnh d\u1ea1ng c\u00e1c \u0111\u1ed1i t\u01b0\u1ee3ng kh\u00e1c\">Ch\u00e8n v\u00e0 \u0111\u1ecbnh d\u1ea1ng c\u00e1c \u0111\u1ed1i t\u01b0\u1ee3ng kh\u00e1c<\/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_2013_%E2%80%93_phan_5\"><\/span>K\u0129 n\u0103ng c\u1ea7n thi\u1ebft cho b\u00e0i thi MOS Excel 2013 \u2013 ph\u1ea7n 5<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Ph\u1ea7n 5 l\u00e0 tuy\u1ec3n t\u1eadp nh\u1eefng y\u00eau c\u1ea7u k\u0129 n\u0103ng c\u1ee7a ng\u01b0\u1eddi s\u1eed d\u1ee5ng v\u1ec1\u00a0<strong>bi\u1ec3u \u0111\u1ed3 v\u00e0 c\u00e1c \u0111\u1ed1i t\u01b0\u1ee3ng kh\u00e1c nh\u01b0 c\u00e1c kh\u1ed1i (Shape), SmartArt, h\u00ecnh \u1ea3nh,\u2026<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-24432\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/tong-hop-mos-5-1.png\" width=\"832\" height=\"269\" title=\"tong-hop-mos-5-1\"><\/p>\n<p>Trong \u0111\u00f3 c\u00f3:<\/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-47.gif\" title=\"ex101_92019-nho-47\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<h4><span class=\"ez-toc-section\" id=\"Tao_lap_bieu_do\"><\/span>T\u1ea1o l\u1eadp bi\u1ec3u \u0111\u1ed3<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>B\u1ea1n c\u1ea7n hi\u1ec3u c\u00e1ch:<\/p>\n<ul>\n<li>T\u1ea1o l\u1eadp m\u1ed9t bi\u1ec3u \u0111\u1ed3 kh\u1ed1i<\/li>\n<li>Th\u00eam d\u1eef li\u1ec7u v\u00e0o bi\u1ec3u \u0111\u1ed3<\/li>\n<li>Thay \u0111\u1ed5i v\u1ecb tr\u00ed h\u00e0ng\/c\u1ed9t trong bi\u1ec3u \u0111\u1ed3<\/li>\n<li>S\u1eed d\u1ee5ng Quick Analysis<\/li>\n<\/ul>\n<h4><span class=\"ez-toc-section\" id=\"Dinh_dang_bieu_do\"><\/span>\u0110\u1ecbnh d\u1ea1ng bi\u1ec3u \u0111\u1ed3<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>Trong \u0111\u1ecbnh d\u1ea1ng bi\u1ec3u \u0111\u1ed3, gi\u1ed1ng nh\u01b0 c\u00e1c \u0111\u1ed1i t\u01b0\u1ee3ng kh\u00e1c, c\u00e1c b\u1ea1n c\u1ea7n hi\u1ec3u \u0111\u01b0\u1ee3c nh\u1eefng \u0111\u1ecbnh d\u1ea1ng c\u01a1 b\u1ea3n nh\u01b0:<\/p>\n<ul>\n<li>Th\u00eam \u0111\u01a1n v\u1ecb, ch\u00fa th\u00edch \u0111\u1ed1i t\u01b0\u1ee3ng<\/li>\n<li>\u0110i\u1ec1u ch\u1ec9nh k\u00edch c\u1ee1 bi\u1ec3u \u0111\u1ed3<\/li>\n<li>\u0110i\u1ec1u ch\u1ec9nh c\u00e1c bi\u1ebfn bi\u1ec3u \u0111\u1ed5<\/li>\n<li>Thay \u0111\u1ed5i c\u00e1c layout v\u00e0 style cho bi\u1ec3u \u0111\u1ed3<\/li>\n<li>\u0110i\u1ec1u ch\u1ec9nh v\u1ecb tr\u00ed bi\u1ec3u \u0111\u1ed3<\/li>\n<\/ul>\n<p>C\u1ee5 th\u1ec3, c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o t\u1ea1i\u00a0<strong><a href=\"http:\/\/blog.ezworkapp.com\/tao-lap-va-dinh-dang-doi-tuong-hinh-anh.html\">\u0111\u00e2y<\/a><\/strong><\/p>\n<h4><span class=\"ez-toc-section\" id=\"Chen_va_dinh_dang_cac_doi_tuong_khac\"><\/span>Ch\u00e8n v\u00e0 \u0111\u1ecbnh d\u1ea1ng c\u00e1c \u0111\u1ed1i t\u01b0\u1ee3ng kh\u00e1c<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>C\u00e1c \u0111\u1ed1i t\u01b0\u1ee3ng v\u00e0 thao t\u00e1c \u1edf \u0111\u00e2y bao g\u1ed3m:<\/p>\n<ul>\n<li>Text Box<\/li>\n<li>SmartArt<\/li>\n<li>H\u00ecnh \u1ea3nh<\/li>\n<li>Th\u00eam vi\u1ec1n cho c\u00e1c \u0111\u1ed1i t\u01b0\u1ee3ng<\/li>\n<li>\u0110\u01b0a style v\u00e0 effect v\u00e0o \u0111\u1ed1i t\u01b0\u1ee3ng<\/li>\n<li>\u0110\u1ed5i m\u00e0u \u0111\u1ed1i t\u01b0\u1ee3ng<\/li>\n<li>Thay \u0111\u1ed5i th\u00f4ng tin \u0111\u1ed1i t\u01b0\u1ee3ng<\/li>\n<li>\u0110i\u1ec1u ch\u1ec9nh v\u1ecb tr\u00ed \u0111\u1ed1i t\u01b0\u1ee3ng<\/li>\n<\/ul>\n<p>C\u00e1c b\u00e0i tham kh\u1ea3o:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/tao-lap-va-dinh-dang-doi-tuong-hinh-anh.html\">T\u1ea1o l\u1eadp v\u00e0 \u0111\u1ecbnh d\u1ea1ng \u0111\u1ed1i t\u01b0\u1ee3ng h\u00ecnh \u1ea3nh<\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/thao-tac-voi-cac-doi-tuong-hoa.html\">T\u1ea1o l\u1eadp, \u0111\u1ecbnh d\u1ea1ng c\u00e1c kh\u1ed1i, smartart\u2026<\/a><\/p>\n<p>V\u1eady l\u00e0 qua 5 b\u00e0i vi\u1ebft, H\u1ecdc Excel Online \u0111\u00e3 \u0111\u01b0a nh\u1eefng ki\u1ebfn th\u1ee9c t\u1ed5ng qu\u00e1t b\u1ea1n c\u1ea7n trong b\u00e0i thi MOS Excel 2013 Specialist ra r\u1ed3i. Hy v\u1ecdng c\u00e1c b\u1ea1n s\u1ebd c\u00f3 nh\u1eefng chu\u1ea9n b\u1ecb th\u1eadt t\u1ed1t \u0111\u1ec3 \u0111\u1ea1t k\u1ebft qu\u1ea3 cao. V\u00e0 \u0111\u1eebng qu\u00ean theo d\u00f5i nh\u1eefng b\u00e0i vi\u1ebft ti\u1ebfp theo trong series MOS c\u1ee7a H\u1ecdc Excel Online nh\u00e9,\u00a0c\u00f2n r\u1ea5t nhi\u1ec1u b\u00e0i vi\u1ebft \u0111ang ch\u1edd b\u1ea1n kh\u00e1m ph\u00e1 \u0111\u00f3.<\/p>\n<p>Ch\u00fac c\u00e1c b\u1ea1n h\u1ecdc t\u1ed1t.<\/p>\n<p>\u00a0<\/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-47.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":9392,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-9391","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\/9391","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=9391"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/9391\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/9392"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=9391"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=9391"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=9391"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}