{"id":10087,"date":"2025-01-08T04:57:47","date_gmt":"2025-01-08T04:57:47","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/08\/huong-dan-su-dung-cac-ham-co-ban-trong-bai-thi-mos-cach-dat-cong-thuc-vao-o-tinh-hieu-qua\/"},"modified":"2025-01-08T04:57:47","modified_gmt":"2025-01-08T04:57:47","slug":"huong-dan-su-dung-cac-ham-co-ban-trong-bai-thi-mos-cach-dat-cong-thuc-vao-o-tinh-hieu-qua","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/08\/huong-dan-su-dung-cac-ham-co-ban-trong-bai-thi-mos-cach-dat-cong-thuc-vao-o-tinh-hieu-qua\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng c\u00e1c h\u00e0m c\u01a1 b\u1ea3n trong b\u00e0i thi MOS; c\u00e1ch \u0111\u1eb7t c\u00f4ng th\u1ee9c v\u00e0o \u00f4 t\u00ednh hi\u1ec7u qu\u1ea3"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Kh\u00f4ng ch\u1ec9 trong b\u00e0i thi MOS m\u00e0 tr\u00ean th\u1ef1c t\u1ebf h\u00e0m l\u00e0 m\u1ed9t ph\u1ea7n quan tr\u1ecdng c\u1ee7a Excel. N\u00f3 gi\u00fap t\u00ednh to\u00e1n, s\u1eafp x\u1ebfp, \u0111\u01b0a ra nh\u1eefng th\u00f4ng tin v\u1ec1 d\u1eef li\u1ec7u m\u1ed9t c\u00e1ch logic. V\u1eady s\u1eed d\u1ee5ng c\u00e1c h\u00e0m c\u01a1 b\u1ea3n trong b\u00e0i thi MOS v\u00e0 \u0111\u1eb7t c\u00f4ng th\u1ee9c sao cho chu\u1ea9n, h\u00e3y c\u00f9ng H\u1ecdc Excel Online t\u00ecm hi\u1ec3u trong b\u00e0i vi\u1ebft d\u01b0\u1edbi<\/p>\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-677e05ca5ba64\" 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\/su-dung-cac-ham-co-ban-trong-bai-thi-mos-dat-cong-thuc-vao-o-tinh.html#Cac_ham_co_ban_trong_bai_thi_MOS\" title=\"C\u00e1c h\u00e0m c\u01a1 b\u1ea3n trong b\u00e0i thi MOS\">C\u00e1c h\u00e0m c\u01a1 b\u1ea3n trong b\u00e0i thi MOS<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/su-dung-cac-ham-co-ban-trong-bai-thi-mos-dat-cong-thuc-vao-o-tinh.html#Dat_cong_thuc_trong_Excel\" title=\"\u0110\u1eb7t c\u00f4ng th\u1ee9c trong Excel\">\u0110\u1eb7t c\u00f4ng th\u1ee9c trong Excel<\/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-3\" href=\"https:\/\/blog.hocexcel.online\/su-dung-cac-ham-co-ban-trong-bai-thi-mos-dat-cong-thuc-vao-o-tinh.html#Cong_thuc\" title=\"C\u00f4ng th\u1ee9c\">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-4\" href=\"https:\/\/blog.hocexcel.online\/su-dung-cac-ham-co-ban-trong-bai-thi-mos-dat-cong-thuc-vao-o-tinh.html#Cac_thanh_phan_cong_thuc\" title=\"C\u00e1c th\u00e0nh ph\u1ea7n c\u00f4ng th\u1ee9c\">C\u00e1c th\u00e0nh ph\u1ea7n 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-5\" href=\"https:\/\/blog.hocexcel.online\/su-dung-cac-ham-co-ban-trong-bai-thi-mos-dat-cong-thuc-vao-o-tinh.html#Cach_dat_cong_thuc_vao_o_tinh\" title=\"C\u00e1ch \u0111\u1eb7t c\u00f4ng th\u1ee9c v\u00e0o \u00f4 t\u00ednh\">C\u00e1ch \u0111\u1eb7t c\u00f4ng th\u1ee9c v\u00e0o \u00f4 t\u00ednh<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"Cac_ham_co_ban_trong_bai_thi_MOS\"><\/span><strong>C\u00e1c h\u00e0m c\u01a1 b\u1ea3n trong b\u00e0i thi MOS<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>B\u00e0i thi MOS (v\u1edbi m\u1ee9c \u0111\u1ed9 <strong>Specialist<\/strong>) y\u00eau c\u1ea7u ng\u01b0\u1eddi s\u1eed d\u1ee5ng c\u00f3 ki\u1ebfn th\u1ee9c v\u1ec1 c\u00e1c h\u00e0m \u0111\u01a1n gi\u1ea3n. \u0110\u1ed1i v\u1edbi m\u1ed7i h\u00e0m, t\u00ean h\u00e0m g\u1eafn li\u1ec1n v\u1edbi thao t\u00e1c m\u00e0 n\u00f3 cung c\u1ea5p. Tham s\u1ed1 l\u00e0 gi\u00e1 tr\u1ecb \u0111\u1ea7u v\u00e0o cung c\u1ea5p d\u1eef li\u1ec7u \u0111\u1ec3 h\u00e0m x\u1eed l\u00ed. V\u00ed d\u1ee5:<\/p>\n<p><strong>=SUM(A1:A4)<\/strong><\/p>\n<figure id=\"attachment_20977\" aria-describedby=\"caption-attachment-20977\" style=\"width: 345px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-20977\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/mos-excel-2010-sum.png\" width=\"345\" height=\"227\" title=\"mos-excel-2010-sum\"><figcaption id=\"caption-attachment-20977\" class=\"wp-caption-text\">V\u00ed d\u1ee5 v\u1ec1 h\u00e0m SUM<\/figcaption><\/figure>\n<p>Trong \u0111\u00f3, SUM l\u00e0 t\u00ean h\u00e0m, d\u1ea3i tham chi\u1ebfu A1:A4 l\u00e0 tham s\u1ed1 \u0111\u1ea7u v\u00e0o c\u1ee7a h\u00e0m. \u00dd ngh\u0129a h\u00e0m l\u00e0 t\u00ednh t\u1ed5ng c\u00e1c gi\u00e1 tr\u1ecb t\u1eeb \u00f4 A1 \u0111\u1ebfn A4.<\/p>\n<p>M\u1ed9t s\u1ed1 h\u00e0m \u0111\u01a1n gi\u1ea3n trong Excel<\/p>\n<p><strong>SUM: <\/strong>T\u00ednh t\u1ed5ng gi\u00e1 tr\u1ecb c\u1ee7a c\u00e1c tham s\u1ed1 \u0111\u1ea7u v\u00e0o.<\/p>\n<p><strong>AVERAGE:<\/strong> T\u00ednh gi\u00e1 tr\u1ecb trung b\u00ecnh c\u1ee7a c\u00e1c tham s\u1ed1.<\/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-131.gif\" title=\"ex101_92019-nho-131\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><strong>MIN<\/strong>: T\u00ecm gi\u00e1 tr\u1ecb nh\u1ecf nh\u1ea5t c\u1ee7a c\u00e1c tham s\u1ed1.<\/p>\n<p><strong>MAX:<\/strong> T\u00ecm gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t c\u1ee7a c\u00e1c tham s\u1ed1.<\/p>\n<p><strong>COUNT: <\/strong>\u0110\u1ebfm c\u00e1c \u00f4 c\u00f3 gi\u00e1 tr\u1ecb d\u1ea1ng s\u1ed1 trong d\u1ea3i tham s\u1ed1.<\/p>\n<p>C\u00e1c h\u00e0m \u0111\u01b0\u1ee3c \u0111\u1eb7t trong th\u1ebb <strong>Formulas<\/strong> t\u1ea1i nh\u00f3m <strong>Function Library.<\/strong><\/p>\n<figure id=\"attachment_20978\" aria-describedby=\"caption-attachment-20978\" style=\"width: 1024px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-large wp-image-20978\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/mos-excel-2010-functions-1024x116-1.png\" width=\"1024\" height=\"116\" title=\"mos-excel-2010-functions-1024x116-1\"><figcaption id=\"caption-attachment-20978\" class=\"wp-caption-text\">B\u1ed9 s\u01b0u t\u1eadp h\u00e0m<\/figcaption><\/figure>\n<p>\u0110\u1ec3 ti\u1ec7n cho ng\u01b0\u1eddi s\u1eed d\u1ee5ng theo d\u00f5i c\u00e1c y\u00eau c\u1ea7u c\u0169ng nh\u01b0 m\u1ee5c \u0111\u00edch s\u1eed d\u1ee5ng h\u00e0m, Excel cung c\u1ea5p ch\u1ee9c n\u0103ng Function Arguments:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-21081\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/mos-excel-y-nghia-ham-1024x576-1.png\" width=\"1024\" height=\"576\" title=\"mos-excel-y-nghia-ham-1024x576-1\"><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Dat_cong_thuc_trong_Excel\"><\/span><strong>\u0110\u1eb7t c\u00f4ng th\u1ee9c trong Excel<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<h4><span class=\"ez-toc-section\" id=\"Cong_thuc\"><\/span><strong>C\u00f4ng th\u1ee9c<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>C\u00f4ng th\u1ee9c l\u00e0 t\u1eadp h\u1ee3p c\u00e1c l\u1ec7nh s\u1eed d\u1ee5ng \u0111\u1ec3 t\u00ednh to\u00e1n d\u1eef li\u1ec7u.<\/p>\n<p>C\u00e1c c\u00f4ng th\u1ee9c b\u1eaft \u0111\u1ea7u v\u1edbi d\u1ea5u \u201c=\u201d, sau \u0111\u00f3 l\u00e0 c\u00e1c th\u00e0nh ph\u1ea7n nh\u01b0 h\u1eb1ng s\u1ed1, h\u00e0m, c\u00e1c tham chi\u1ebfu\u2026 M\u1ed9t c\u00f4ng th\u1ee9c c\u00f3 th\u1ec3 ch\u1ee9a m\u1ed9t ho\u1eb7c \u0111\u1ed3ng th\u1eddi c\u00e1c th\u00e0nh ph\u1ea7n tr\u00ean, v\u00e0 thay \u0111\u1ed5i k\u1ebft qu\u1ea3 t\u1ef1 \u0111\u1ed9ng theo d\u1eef li\u1ec7u.<\/p>\n<figure id=\"attachment_20979\" aria-describedby=\"caption-attachment-20979\" style=\"width: 384px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-20979\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/mos-excel-2010-ham.png\" width=\"384\" height=\"101\" title=\"mos-excel-2010-ham\"><figcaption id=\"caption-attachment-20979\" class=\"wp-caption-text\">C\u00f4ng th\u1ee9c trong Excel<\/figcaption><\/figure>\n<h4><span class=\"ez-toc-section\" id=\"Cac_thanh_phan_cong_thuc\"><\/span><strong>C\u00e1c th\u00e0nh ph\u1ea7n c\u00f4ng th\u1ee9c<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p><strong>References: <\/strong>\u0110\u1ecba ch\u1ec9 tham chi\u1ebfu \u0111\u1ebfn v\u1ecb tr\u00ed c\u00e1c d\u1eef li\u1ec7u c\u1ea7n t\u00ednh to\u00e1n.<\/p>\n<p><strong>Operators: <\/strong>C\u00e1c k\u00fd hi\u1ec7u d\u00f9ng \u0111\u1ec3 th\u1ef1c hi\u1ec7n ph\u00e9p t\u00ednh nh\u01b0 c\u1ed9ng tr\u1eeb nh\u00e2n chia.<\/p>\n<p><strong>Constants: <\/strong>Gi\u00e1 tr\u1ecb h\u1eb1ng s\u1ed1 ho\u1eb7c v\u0103n b\u1ea3n kh\u00f4ng thay \u0111\u1ed5i trong c\u00f4ng th\u1ee9c.<\/p>\n<p><strong>Functions: <\/strong>C\u00e1c h\u00e0m c\u00f3 s\u1eb5n trong Excel.<\/p>\n<h4><span class=\"ez-toc-section\" id=\"Cach_dat_cong_thuc_vao_o_tinh\"><\/span><strong>C\u00e1ch \u0111\u1eb7t c\u00f4ng th\u1ee9c v\u00e0o \u00f4 t\u00ednh<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h4>\n<ol>\n<li>Ch\u1ecdn \u00f4 c\u1ea7n nh\u1eadp c\u00f4ng th\u1ee9c.<\/li>\n<li>G\u00f5 d\u1ea5u \u201c=\u201d \u0111\u1ec3 b\u1eaft \u0111\u1ea7u c\u00f4ng th\u1ee9c, sau \u0111\u00f3 nh\u1eadp c\u00e1c th\u00e0nh ph\u1ea7n trong c\u00f4ng th\u1ee9c.<\/li>\n<li>Nh\u1ea5n Enter sau khi nh\u1eadp.<\/li>\n<\/ol>\n<p>*<strong>L\u01b0u \u00fd: <\/strong>\u0110\u1ec3 \u0111\u1eb7t c\u00f4ng th\u1ee9c hi\u1ec7u qu\u1ea3, n\u00ean \u0111\u1eb7t sao cho tr\u1ef1c quan d\u1ec5 nh\u00ecn, d\u1ec5 ki\u1ec3m tra c\u00e1c d\u1eef li\u1ec7u tham s\u1ed1. \u0110\u1ed1i v\u1edbi c\u00e1c c\u00f4ng th\u1ee9c ph\u1ee9c t\u1ea1p s\u1eed d\u1ee5ng nhi\u1ec1u thao t\u00e1c v\u1edbi nhi\u1ec1u d\u1eef li\u1ec7u nh\u01b0 l\u1ed3ng gh\u00e9p c\u00e1c h\u00e0m, n\u00ean l\u00e0m theo t\u1eebng b\u01b0\u1edbc \u0111\u1ec3 tr\u00e1nh sai s\u00f3t.<\/p>\n<p>Ch\u00fac c\u00e1c b\u1ea1n h\u1ecdc t\u1ed1t c\u00f9ng H\u1ecdc Excel Online. V\u00e0 \u0111\u1eebng qu\u00ean theo d\u00f5i nh\u1eefng b\u00e0i vi\u1ebft ti\u1ebfp theo trong series b\u00e0i vi\u1ebft ch\u1ee7 \u0111\u1ec1 MOS 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-131.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":10088,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-10087","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\/10087","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=10087"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/10087\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/10088"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=10087"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=10087"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=10087"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}