{"id":10015,"date":"2025-01-07T05:02:26","date_gmt":"2025-01-07T05:02:26","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/07\/cach-su-dung-co-ban-chuc-nang-sort-trong-bai-thi-mos\/"},"modified":"2025-01-07T05:02:26","modified_gmt":"2025-01-07T05:02:26","slug":"cach-su-dung-co-ban-chuc-nang-sort-trong-bai-thi-mos","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/07\/cach-su-dung-co-ban-chuc-nang-sort-trong-bai-thi-mos\/","title":{"rendered":"C\u00e1ch s\u1eed d\u1ee5ng c\u01a1 b\u1ea3n ch\u1ee9c n\u0103ng Sort trong b\u00e0i thi MOS"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Ngo\u00e0i ch\u1ee9c n\u0103ng <a href=\"http:\/\/blog.ezworkapp.com\/su-dung-filter-loc-du-lieu-mos-excel.html\"><strong>Filter<\/strong><\/a> \u0111\u00e3 n\u00f3i \u1edf b\u00e0i tr\u01b0\u1edbc, Excel cung c\u1ea5p ch\u1ee9c n\u0103ng <strong>Sort<\/strong> (s\u1eafp x\u1ebfp) gi\u00fap ng\u01b0\u1eddi s\u1eed d\u1ee5ng c\u00f3 th\u1ec3 s\u1eafp x\u1ebfp c\u00e1c gi\u00e1 tr\u1ecb trong m\u1ed9t ho\u1eb7c nhi\u1ec1u c\u1ed9t c\u1ee7a trang t\u00ednh theo th\u1ee9 t\u1ef1 \u0111\u1ecbnh tr\u01b0\u1edbc. H\u00e3y xem chi ti\u1ebft trong b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y:<\/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-677cb56182730\" 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\/chuc-nang-sort-trong-bai-thi-mos.html#Su_dung_chuc_nang_Sort_trong_bang_tinh\" title=\"S\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng Sort trong b\u1ea3ng t\u00ednh\">S\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng Sort trong b\u1ea3ng t\u00ednh<\/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\/chuc-nang-sort-trong-bai-thi-mos.html#Cac_thao_tac_va_chuc_nang_Sort\" title=\"C\u00e1c thao t\u00e1c v\u00e0 ch\u1ee9c n\u0103ng Sort.\">C\u00e1c thao t\u00e1c v\u00e0 ch\u1ee9c n\u0103ng Sort.<\/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\/chuc-nang-sort-trong-bai-thi-mos.html#Cac_chuc_nang_chinh\" title=\"C\u00e1c ch\u1ee9c n\u0103ng ch\u00ednh\">C\u00e1c ch\u1ee9c n\u0103ng ch\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\/chuc-nang-sort-trong-bai-thi-mos.html#Cac_thao_tac_sort\" title=\"C\u00e1c thao t\u00e1c sort\">C\u00e1c thao t\u00e1c sort<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"Su_dung_chuc_nang_Sort_trong_bang_tinh\"><\/span><strong>S\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng Sort trong b\u1ea3ng t\u00ednh<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0110\u1ec3 s\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng Sort ta l\u00e0m nh\u01b0 sau:<\/p>\n<ol>\n<li>Ch\u1ecdn v\u00f9ng d\u1eef li\u1ec7u c\u1ea7n s\u1eafp x\u1ebfp<\/li>\n<li>T\u1ea1i th\u1ebb <strong>Home<\/strong>, nh\u00f3m <strong>Editing<\/strong>, trong ph\u1ea7n <strong>Sort &amp; Filter<\/strong> ch\u1ecdn <strong>Sort; <\/strong>ho\u1eb7c trong th\u1ebb <strong>Data<\/strong>, nh\u00f3m <strong>Sort &amp; Filter <\/strong>ch\u1ecdn <strong>Sort<\/strong>.<\/li>\n<\/ol>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-21419\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/mos-excel-2010-vi-tri-sort.png\" width=\"625\" height=\"525\" title=\"mos-excel-2010-vi-tri-sort\"><\/p>\n<p>L\u01b0u \u00fd: Khi ch\u1ecdn m\u1ed9t c\u1ed9t trong b\u1ea3ng d\u1eef li\u1ec7u, m\u1ed9t h\u1ed9p tho\u1ea1i nh\u01b0 h\u00ecnh s\u1ebd xu\u1ea5t hi\u1ec7n:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-21420\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/mos-excel-2010-expand.png\" width=\"833\" height=\"287\" title=\"mos-excel-2010-expand\"><\/p>\n<ul>\n<li>V\u1edbi l\u1ef1a ch\u1ecdn <strong>Expand the selection<\/strong>, Excel s\u1ebd t\u1ef1 \u0111\u1ed9ng ch\u1ecdn to\u00e0n b\u1ed9 v\u00f9ng d\u1eef li\u1ec7u c\u00f2n l\u1ea1i trong b\u1ea3ng.<\/li>\n<li>V\u1edbi l\u1ef1a ch\u1ecdn <strong>Continue with the current selection<\/strong>, b\u1ea1n s\u1ebd ch\u1ec9 thao t\u00e1c s\u1eafp x\u1ebfp v\u1edbi v\u00f9ng \u0111\u00e3 ch\u1ecdn m\u00e0 kh\u00f4ng \u1ea3nh h\u01b0\u1edfng g\u00ec t\u1edbi v\u00f9ng c\u00f2n l\u1ea1i.<\/li>\n<\/ul>\n<p>Sau khi l\u1ef1a ch\u1ecdn xong, h\u1ed9p tho\u1ea1i <strong>Sort<\/strong> s\u1ebd hi\u1ec7n ra v\u00e0 b\u1ea1n c\u00f3 th\u1ec3 thao t\u00e1c v\u1edbi c\u00e1c ch\u1ee9c n\u0103ng trong \u0111\u00f3.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Cac_thao_tac_va_chuc_nang_Sort\"><\/span><strong>C\u00e1c thao t\u00e1c v\u00e0 ch\u1ee9c n\u0103ng Sort.<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<h4><span class=\"ez-toc-section\" id=\"Cac_chuc_nang_chinh\"><\/span><strong>C\u00e1c ch\u1ee9c n\u0103ng ch\u00ednh<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p><strong>Add Level:<\/strong> Th\u00eam c\u00e1c c\u1ea5p \u0111\u1ed9 Sort. Sau khi s\u1eafp x\u1ebfp c\u00e1c gi\u00e1 tr\u1ecb c\u1ee7a c\u1ed9t c\u1ee7a m\u1ee5c <strong>Sort by<\/strong> s\u1ebd ti\u1ebfn h\u00e0nh so s\u00e1nh t\u1ea1i c\u1ed9t thu\u1ed9c m\u1ee5c <strong>Then by<\/strong>.<\/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-123.gif\" title=\"ex101_92019-nho-123\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><strong>Delete Level:<\/strong> X\u00f3a c\u1ea5p \u0111\u1ed9 Sort.<\/p>\n<p><strong>Copy Level: <\/strong>Copy m\u1ed9t c\u1ea5p \u0111\u1ed9 Sort v\u00e0 th\u00eam v\u00e0o b\u00ean d\u01b0\u1edbi.<\/p>\n<p><strong>Options\u2026:<\/strong> H\u1ed9p tho\u1ea1i m\u1edf ra khi s\u1eed d\u1ee5ng bao g\u1ed3m c\u00e1c ch\u1ee9c n\u0103ng:<\/p>\n<ul>\n<li><em>Case Sensitive: <\/em>Ph\u00e2n bi\u1ec7t ch\u1eef hoa v\u00e0 ch\u1eef th\u01b0\u1eddng.<\/li>\n<li><em>Orientation:<\/em> Thay \u0111\u1ed5i Sort. Bao g\u1ed3m Sort c\u1ed9t (<strong>Top to bottom)<\/strong> sang h\u00e0ng (<strong>Left to right)<\/strong>.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-21421\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/mos-excel-2010-sort-dialog-box.png\" width=\"600\" height=\"275\" title=\"mos-excel-2010-sort-dialog-box\"><\/p>\n<h4><span class=\"ez-toc-section\" id=\"Cac_thao_tac_sort\"><\/span><strong>C\u00e1c thao t\u00e1c sort<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>Trong b\u1ea3ng Sort ta c\u00f3 c\u00e1c thao t\u00e1c sau:<\/p>\n<p><strong>Sort by &amp; Then by: <\/strong>Ch\u1ecdn c\u1ed9t\/h\u00e0ng mu\u1ed1n s\u1eafp x\u1ebfp. Th\u1ee9 t\u1ef1 \u01b0u ti\u00ean: Sort by &gt; Then by, t\u1eeb tr\u00ean xu\u1ed1ng d\u01b0\u1edbi.<\/p>\n<p><strong>Sort On: <\/strong>Ki\u1ec3u s\u1eafp x\u1ebfp. Bao g\u1ed3m <strong>Values (gi\u00e1 tr\u1ecb), Cell Color (m\u00e0u \u00f4), Font Color (m\u00e0u ch\u1eef), Cell Icon (Icon c\u1ee7a \u00f4).<\/strong><\/p>\n<p><strong>Order:<\/strong> Th\u1ee9 t\u1ef1 s\u1eafp x\u1ebfp. G\u1ed3m c\u00f3 t\u1eeb A-Z, nh\u1ecf nh\u1ea5t \u0111\u1ebfn l\u1edbn nh\u1ea5t, theo danh s\u00e1ch t\u00f9y ch\u1ecdn (<strong>Custom list\u2026) <\/strong>v\u00e0 ng\u01b0\u1ee3c l\u1ea1i.<\/p>\n<p>Sau khi ch\u1ecdn ph\u01b0\u01a1ng ph\u00e1p Sort, \u1ea5n <strong>OK <\/strong>\u0111\u1ec3 b\u1eaft \u0111\u1ea7u vi\u1ec7c s\u1eafp x\u1ebfp.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-21422\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/mos-excel-2010-sort-thao-tac.png\" width=\"600\" height=\"275\" title=\"mos-excel-2010-sort-thao-tac\"><\/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 <a href=\"http:\/\/blog.ezworkapp.com\/tag\/mos-excel\">MOS <\/a>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-123.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":10016,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-10015","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\/10015","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=10015"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/10015\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/10016"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=10015"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=10015"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=10015"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}