{"id":9425,"date":"2025-01-02T05:56:01","date_gmt":"2025-01-02T05:56:01","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-4\/"},"modified":"2025-01-02T05:56:01","modified_gmt":"2025-01-02T05:56:01","slug":"tong-hop-nhanh-nhung-ki-nang-can-thiet-cho-bai-thi-mos-excel-phan-4","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-4\/","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 4"},"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<\/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-67762a7058765\" 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-4.html#Ki_nang_can_thiet_cho_bai_thi_MOS_Excel_2013_%E2%80%93_phan_4\" title=\"K\u0129 n\u0103ng c\u1ea7n thi\u1ebft cho b\u00e0i thi MOS Excel 2013 \u2013 ph\u1ea7n 4\">K\u0129 n\u0103ng c\u1ea7n thi\u1ebft cho b\u00e0i thi MOS Excel 2013 \u2013 ph\u1ea7n 4<\/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-4.html#Su_dung_vung_tinh_va_tham_chieu_trong_cong_thuc\" title=\"S\u1eed d\u1ee5ng v\u00f9ng t\u00ednh v\u00e0 tham chi\u1ebfu trong c\u00f4ng th\u1ee9c\">S\u1eed d\u1ee5ng v\u00f9ng t\u00ednh v\u00e0 tham chi\u1ebfu trong c\u00f4ng th\u1ee9c<\/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-4.html#Tong_hop_du_lieu_bang_ham\" title=\"T\u1ed5ng h\u1ee3p d\u1eef li\u1ec7u b\u1eb1ng h\u00e0m\">T\u1ed5ng h\u1ee3p d\u1eef li\u1ec7u b\u1eb1ng h\u00e0m<\/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-4.html#Su_dung_cac_phep_logic_trong_tinh_toan\" title=\"S\u1eed d\u1ee5ng c\u00e1c ph\u00e9p logic trong t\u00ednh to\u00e1n\">S\u1eed d\u1ee5ng c\u00e1c ph\u00e9p logic trong t\u00ednh to\u00e1n<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/nhung-ki-nang-can-thiet-cho-bai-thi-mos-excel-4.html#Cac_ham_thao_tac_voi_ki_tu_Text\" title=\"C\u00e1c h\u00e0m thao t\u00e1c v\u1edbi k\u00ed t\u1ef1 (Text)\">C\u00e1c h\u00e0m thao t\u00e1c v\u1edbi k\u00ed t\u1ef1 (Text)<\/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_4\"><\/span>K\u0129 n\u0103ng c\u1ea7n thi\u1ebft cho b\u00e0i thi MOS Excel 2013 \u2013 ph\u1ea7n 4<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0110\u1ed1i v\u1edbi ph\u1ea7n n\u00e0y, Microsoft y\u00eau c\u1ea7u ng\u01b0\u1eddi s\u1eed d\u1ee5ng c\u00f3 nh\u1eefng hi\u1ec3u bi\u1ebft li\u00ean quan t\u1edbi\u00a0<strong>h\u00e0m v\u00e0 c\u00f4ng th\u1ee9c.<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-24416\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/tong-hop-mos-4-1.png\" width=\"816\" height=\"308\" title=\"tong-hop-mos-4-1\"><\/p>\n<p>C\u1ee5 th\u1ec3:<\/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-51.gif\" title=\"ex101_92019-nho-51\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<h4><span class=\"ez-toc-section\" id=\"Su_dung_vung_tinh_va_tham_chieu_trong_cong_thuc\"><\/span>S\u1eed d\u1ee5ng v\u00f9ng t\u00ednh v\u00e0 tham chi\u1ebfu trong c\u00f4ng th\u1ee9c<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>\u0110\u1ea7u ti\u00ean, b\u1ea1n c\u1ea7n bi\u1ebft c\u00e1ch:<\/p>\n<ul>\n<li>S\u1eed d\u1ee5ng tham chi\u1ebfu t\u01b0\u01a1ng \u0111\u1ed1i, tham chi\u1ebfu tuy\u1ec7t \u0111\u1ed1i<\/li>\n<li>V\u1eadn d\u1ee5ng quy lu\u1eadt s\u1eafp x\u1ebfp th\u1ee9 t\u1ef1 tr\u01b0\u1edbc sau c\u1ee7a c\u00e1c to\u00e1n t\u1eed<\/li>\n<li>V\u1eadn d\u1ee5ng c\u00e1c \u00f4, v\u00f9ng tham chi\u1ebfu t\u1edbi c\u00f4ng th\u1ee9c<\/li>\n<\/ul>\n<p>\u0110\u1ec3 tham kh\u1ea3o, b\u1ea1n c\u00f3 th\u1ec3 \u0111\u1ecdc 2 b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n<ol>\n<li><a href=\"http:\/\/blog.ezworkapp.com\/tai-sao-phai-su-dung-ky-hieu-dollar-trong-cong-thuc-excel-cac-tham-chieu-o-tuyet-doi-va-tuong-doi.html\">Tham chi\u1ebfu t\u01b0\u01a1ng \u0111\u1ed1i v\u00e0 tham chi\u1ebfu tuy\u1ec7t \u0111\u1ed1i<\/a><\/li>\n<li><a href=\"http:\/\/blog.ezworkapp.com\/tao-tham-chieu-ngoai-trong-excel-de-dan-toi-trang-tinhbang-tinh-khac.html\">T\u1ea1o tham chi\u1ebfu t\u1edbi trang t\u00ednh\/b\u1ea3ng t\u00ednh kh\u00e1c<\/a><\/li>\n<\/ol>\n<h4><span class=\"ez-toc-section\" id=\"Tong_hop_du_lieu_bang_ham\"><\/span>T\u1ed5ng h\u1ee3p d\u1eef li\u1ec7u b\u1eb1ng h\u00e0m<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<ul>\n<li>C\u00f3 th\u1ec3 k\u1ec3 \u0111\u1ebfn c\u00e1c h\u00e0m c\u01a1 b\u1ea3n bao g\u1ed3m: SUM, AVERAGE, COUNT, MIN, MAX l\u00e0 c\u00e1c h\u00e0m b\u1ea1n ph\u1ea3i n\u1eafm \u0111\u01b0\u1ee3c.<\/li>\n<\/ul>\n<h4><span class=\"ez-toc-section\" id=\"Su_dung_cac_phep_logic_trong_tinh_toan\"><\/span>S\u1eed d\u1ee5ng c\u00e1c ph\u00e9p logic trong t\u00ednh to\u00e1n<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<ul>\n<li>\u0110\u1ed1i v\u1edbi y\u00eau c\u1ea7u n\u00e0y, b\u1ea1n ph\u1ea3i hi\u1ec3u c\u00e1ch s\u1eed d\u1ee5ng c\u00e1c h\u00e0m t\u00ednh c\u00f3 \u0111i\u1ec1u ki\u1ec7n c\u01a1 b\u1ea3n g\u1ed3m: SUMIF, COUNTIF, AVERAGEIF\u2026<\/li>\n<\/ul>\n<h4><span class=\"ez-toc-section\" id=\"Cac_ham_thao_tac_voi_ki_tu_Text\"><\/span>C\u00e1c h\u00e0m thao t\u00e1c v\u1edbi k\u00ed t\u1ef1 (Text)<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<ul>\n<li>Ngo\u00e0i \u0111\u1ed1i t\u01b0\u1ee3ng l\u00e0 Number, Text c\u0169ng l\u00e0 \u0111\u1ed1i t\u01b0\u1ee3ng \u0111\u01b0\u1ee3c ch\u00fa \u00fd. C\u00e1c h\u00e0m \u1edf \u0111\u00e2y bao g\u1ed3m h\u00e0m l\u1ea5y k\u00ed t\u1ef1 (LEFT, RIGHT, MID), h\u00e0m b\u1ecf kho\u1ea3ng c\u00e1ch th\u1eeba TRIM, h\u00e0m thay \u0111\u1ed5i ki\u1ec3u ch\u1eef UPPER &amp; LOWER, h\u00e0m CONCATENATE n\u1ed1i chu\u1ed7i.<\/li>\n<\/ul>\n<p>\u0110\u1ec3 hi\u1ec3u r\u00f5, b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o\u00a0<strong><a href=\"http:\/\/blog.ezworkapp.com\/38-%E2%97%8F-cac-ham-xu-ly-chuoi-ki-tu-trong-excel.html\">b\u00e0i vi\u1ebft n\u00e0y<\/a>.<\/strong><\/p>\n<p>Ch\u00fac c\u00e1c b\u1ea1n h\u1ecdc t\u1ed1t v\u00e0 \u0111\u1eebng qu\u00ean theo d\u00f5i nh\u1eefng b\u00e0i vi\u1ebft ti\u1ebfp theo trong series t\u1ed5ng h\u1ee3p ki\u1ebfn th\u1ee9c MOS c\u1ee7a H\u1ecdc Excel Online nh\u00e9.<\/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-51.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":9426,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-9425","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\/9425","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=9425"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/9425\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/9426"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=9425"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=9425"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=9425"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}