{"id":10000,"date":"2025-01-07T01:42:55","date_gmt":"2025-01-07T01:42:55","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/07\/huong-dan-cac-bai-tap-thuong-gap-dieu-huong-trang-tinh-trong-bai-thi-mos-excel-2010\/"},"modified":"2025-01-07T01:42:55","modified_gmt":"2025-01-07T01:42:55","slug":"huong-dan-cac-bai-tap-thuong-gap-dieu-huong-trang-tinh-trong-bai-thi-mos-excel-2010","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/07\/huong-dan-cac-bai-tap-thuong-gap-dieu-huong-trang-tinh-trong-bai-thi-mos-excel-2010\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn c\u00e1c b\u00e0i t\u1eadp th\u01b0\u1eddng g\u1eb7p: \u0110i\u1ec1u h\u01b0\u1edbng trang t\u00ednh trong b\u00e0i thi MOS Excel 2010"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>B\u00e0i thi MOS Excel v\u1edbi thang \u0111i\u1ec3m 1000 \u0111\u01b0\u1ee3c chia ra th\u00e0nh nhi\u1ec1u m\u1ee5c l\u1edbn, trong \u0111\u00f3 bao g\u1ed3m c\u00e1c nh\u00f3m thao t\u00e1c nh\u1ecf h\u01a1n nh\u1eb1m ki\u1ec3m tra ki\u1ebfn th\u1ee9c n\u1ec1n t\u1ea3ng c\u1ee7a ng\u01b0\u1eddi s\u1eed d\u1ee5ng. D\u01b0\u1edbi \u0111\u00e2y l\u00e0 nh\u1eefng y\u00eau c\u1ea7u th\u01b0\u1eddng g\u1eb7p trong n\u1ed9i dung \u0111i\u1ec1u h\u01b0\u1edbng trang t\u00ednh:<\/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-677c869e30ebf\" 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\/bai-tap-thuong-gap-dieu-huong-trang-tinh-mos-excel-2010.html#Dieu_huong_trang_tinh\" title=\"\u0110i\u1ec1u h\u01b0\u1edbng trang t\u00ednh\">\u0110i\u1ec1u h\u01b0\u1edbng trang t\u00ednh<\/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\/bai-tap-thuong-gap-dieu-huong-trang-tinh-mos-excel-2010.html#Su_dung_thanh_thuc_cac_phim_tat\" title=\"S\u1eed d\u1ee5ng th\u00e0nh th\u1ee5c c\u00e1c ph\u00edm t\u1eaft\">S\u1eed d\u1ee5ng th\u00e0nh th\u1ee5c c\u00e1c ph\u00edm t\u1eaft<\/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\/bai-tap-thuong-gap-dieu-huong-trang-tinh-mos-excel-2010.html#Dinh_vi_trong_trang_tinh\" title=\"\u0110\u1ecbnh v\u1ecb trong trang t\u00ednh\">\u0110\u1ecbnh v\u1ecb trong trang 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\/bai-tap-thuong-gap-dieu-huong-trang-tinh-mos-excel-2010.html#Su_dung_Namebox\" title=\"S\u1eed d\u1ee5ng Namebox\">S\u1eed d\u1ee5ng Namebox<\/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\/bai-tap-thuong-gap-dieu-huong-trang-tinh-mos-excel-2010.html#Vi_du\" title=\"V\u00ed d\u1ee5\">V\u00ed d\u1ee5<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"Dieu_huong_trang_tinh\"><\/span><strong>\u0110i\u1ec1u h\u01b0\u1edbng trang t\u00ednh<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0110i\u1ec1u h\u01b0\u1edbng trang t\u00ednh l\u00e0 nh\u00f3m y\u00eau c\u1ea7u \u0111\u1ea7u ti\u00ean c\u1ee7a n\u1ed9i dung l\u1edbn h\u01a1n l\u00e0 qu\u1ea3n l\u00fd trang t\u00ednh, bao g\u1ed3m:<\/p>\n<h4><span class=\"ez-toc-section\" id=\"Su_dung_thanh_thuc_cac_phim_tat\"><\/span><strong>S\u1eed d\u1ee5ng th\u00e0nh th\u1ee5c c\u00e1c ph\u00edm t\u1eaft<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>Trong y\u00eau c\u1ea7u n\u00e0y, ng\u01b0\u1eddi s\u1eed d\u1ee5ng c\u1ea7n n\u1eafm \u0111\u01b0\u1ee3c c\u00e1c ph\u00edm t\u1eaft c\u01a1 b\u1ea3n. Tr\u00ean th\u1ef1c t\u1ebf, thay v\u00ec s\u1eed d\u1ee5ng b\u00e0n ph\u00edm, ta ho\u00e0n to\u00e0n c\u00f3 th\u1ec3 d\u00f9ng chu\u1ed9t \u0111\u1ec3 t\u00ecm \u0111\u1ebfn c\u00e1c ch\u1ee9c n\u0103ng trong Excel. Tuy nhi\u00ean, vi\u1ec7c \u201cm\u00faa ph\u00edm\u201d v\u1eeba nhanh v\u1eeba ti\u1ec7n s\u1ebd t\u1ed1t h\u01a1n ph\u1ea3i kh\u00f4ng n\u00e0o?<\/p>\n<h4><span class=\"ez-toc-section\" id=\"Dinh_vi_trong_trang_tinh\"><\/span><strong>\u0110\u1ecbnh v\u1ecb trong trang t\u00ednh<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>Ng\u01b0\u1eddi d\u00f9ng c\u1ea7n bi\u1ebft c\u00e1ch di chuy\u1ec3n t\u1edbi c\u00e1c \u0111\u1ed1i t\u01b0\u1ee3ng nh\u01b0 \u00f4 tr\u1ed1ng, \u00f4 \u0111\u1ea7u ti\u00ean, v\u00f9ng d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c quy \u0111\u1ecbnh s\u1eb5n b\u1eb1ng t\u00ean, nh\u1eefng \u00f4 \u0111\u1eb7c bi\u1ec7t\u2026 m\u00e0 c\u00f4ng c\u1ee5 c\u1ea7m n\u1eafm v\u1eefng \u1edf \u0111\u00e2y l\u00e0 <strong>Go To\u2026 <\/strong>v\u00e0 <strong>Go To Special.<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-21654\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/mos-excel-2010-go-to.png\" width=\"281\" height=\"344\" title=\"mos-excel-2010-go-to\"><\/p>\n<h4><span class=\"ez-toc-section\" id=\"Su_dung_Namebox\"><\/span><strong>S\u1eed d\u1ee5ng Namebox<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>Namebox n\u1eb1m c\u1ea1nh thanh c\u00f4ng th\u1ee9c, b\u00ean tr\u00e1i ph\u00eda tr\u00ean trang t\u00ednh. T\u1ea1i \u0111\u00e2y hi\u1ec3n th\u1ecb v\u1ecb tr\u00ed \u00f4 \u0111ang \u0111\u01b0\u1ee3c tr\u1ecf \u0111\u1ebfn, ho\u1eb7c bi\u1ec3u th\u1ecb t\u00ean ri\u00eang c\u1ee7a v\u00f9ng d\u1eef li\u1ec7u. S\u1eed d\u1ee5ng namebox l\u00e0 c\u00e1ch ta di chuy\u1ec3n nhanh t\u1edbi v\u00f9ng d\u1eef li\u1ec7u m\u00e0 kh\u00f4ng c\u1ea7n l\u1ea1m d\u1ee5ng con tr\u1ecf chu\u1ed9t.<\/p>\n<p><strong>Xem th\u00eam<\/strong>:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/mos-2010-di-chuyen-dinh-vi-trong-trang-tinh.html\">C\u00e1ch di chuy\u1ec3n v\u00e0 \u0111\u1ecbnh v\u1ecb trong m\u1ed9t trang t\u00ednh Excel<\/a><\/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-121.gif\" title=\"ex101_92019-nho-121\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<h4><span class=\"ez-toc-section\" id=\"Vi_du\"><\/span><strong>V\u00ed d\u1ee5<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-21669\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/mos-excel-2010-bang-du-lieu-2-1-1024x494-1.png\" width=\"1024\" height=\"494\" title=\"mos-excel-2010-bang-du-lieu-2-1-1024x494-1\"><\/p>\n<blockquote>\n<p><em>Copy cell <strong>B7<\/strong><strong>:B61<\/strong>\u00a0and paste to <strong>C7<\/strong><strong>:C61<\/strong>, then locate to the <strong>last cell.<\/strong><\/em><\/p>\n<\/blockquote>\n<p>Trong v\u00ed d\u1ee5 n\u00e0y, c\u00f3 nhi\u1ec1u h\u01a1n m\u1ed9t c\u00e1ch. V\u1edbi vi\u1ec7c \u00e1p d\u1ee5ng nh\u1eefng ki\u1ebfn th\u1ee9c \u1edf tr\u00ean s\u1ebd nh\u01b0 th\u1ebf n\u00e0o? D\u01b0\u1edbi \u0111\u00e2y l\u00e0 c\u00e1c b\u01b0\u1edbc:<\/p>\n<ol>\n<li><em>V\u00e0o Namebox g\u00f5 \u201cB7:B61<strong>\u201d.<\/strong><\/em><\/li>\n<li><em>S\u1eed d\u1ee5ng t\u1ed5 h\u1ee3p ph\u00edm t\u1eaft Ctrl + C \u0111\u1ec3 copy v\u00f9ng d\u1eef li\u1ec7u.<\/em><\/li>\n<li><em>V\u00e0o Namebox g\u00f5 \u201cC7:C61\u201d.<\/em><\/li>\n<li><em>S\u1eed d\u1ee5ng t\u1ed5 h\u1ee3p ph\u00edm t\u1eaft Ctrl + V \u0111\u1ec3 paste v\u00f9ng d\u1eef li\u1ec7u.<\/em><\/li>\n<li><em>Trong th\u1ebb <strong>Home<\/strong>, nh\u00f3m <strong>Editing<\/strong> ch\u1ecdn <strong>Find &amp; Select <\/strong>sau \u0111\u00f3 ch\u1ecdn <strong>Go To Special. <\/strong>Ti\u1ebfp \u0111\u1ebfn ch\u1ecdn <strong>Last cell <\/strong>v\u00e0 \u1ea5n\u00a0<strong>OK.<\/strong><\/em><\/li>\n<\/ol>\n<ul>\n<li><em>Ho\u1eb7c s<\/em><em>\u1eed d\u1ee5ng t\u1ed5 h\u1ee3p ph\u00edm t\u1eaft Ctrl + G \u0111\u1ec3 m\u1edf ch\u1ee9c n\u0103ng <strong>Go To\u2026<\/strong> sau \u0111\u00f3 ch\u1ecdn <strong>Special\u2026<\/strong> v\u00e0 ch\u1ecdn <strong>Last Cell.<\/strong><\/em><\/li>\n<\/ul>\n<blockquote>\n<p><em>Find all blanks cell, then fill it with\u00a0<strong>Red<\/strong><strong>, Accent 2.<\/strong><\/em><\/p>\n<\/blockquote>\n<p>\u0110\u00e2y l\u00e0 m\u1ed9t v\u00ed d\u1ee5 n\u1eefa v\u1ec1 vi\u1ec7c \u0111\u1ecbnh v\u1ecb trong trang t\u00ednh k\u1ebft h\u1ee3p v\u1edbi t\u00f4 m\u00e0u m\u1ed9t nh\u00f3m \u00f4. Ta l\u00e0m nh\u01b0 sau:<\/p>\n<ol>\n<li><em>V\u00e0o <strong>Go To Special<\/strong> sau \u0111\u00f3 ch\u1ecdn <strong>Blanks <\/strong>v\u00e0 \u1ea5n\u00a0<strong>OK<\/strong>.<\/em><\/li>\n<li><em>Trong th\u1ebb <strong>Home<\/strong>, nh\u00f3m <strong>Font <\/strong>ch\u1ecdn <strong>Fill Color<\/strong>, t\u00ecm \u0111\u1ebfn m\u00e0u <strong>Red<\/strong><strong>, Accent 2.<\/strong><\/em><\/li>\n<\/ol>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-21672\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/mos-excel-2010-bang-du-lieu-2-1-ket-qua-1024x494-1.png\" width=\"1024\" height=\"494\" title=\"mos-excel-2010-bang-du-lieu-2-1-ket-qua-1024x494-1\"><\/p>\n<p>\u2014\u2014<\/p>\n<p>Kh\u00e1 l\u00e0 \u0111\u01a1n gi\u1ea3n, nh\u01b0ng c\u0169ng c\u00f3 nh\u1eefng \u0111i\u1ec1u m\u1edbi m\u1ebb \u0111\u00e1ng suy ngh\u0129 ph\u1ea3i kh\u00f4ng? V\u00e0 \u0111\u00f3 m\u1edbi ch\u1ec9 l\u00e0 m\u1ed9t ph\u1ea7n nh\u1ecf th\u00f4i, n\u00ean l\u00e0 \u0111\u1eebng qu\u00ean theo d\u00f5i nh\u1eefng b\u00e0i vi\u1ebft ti\u1ebfp theo c\u1ee7a H\u1ecdc Excel Online trong series MOS Excel c\u00e1c b\u1ea1n nh\u00e9!<\/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-121.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":10001,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-10000","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\/10000","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=10000"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/10000\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/10001"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=10000"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=10000"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=10000"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}