{"id":10168,"date":"2025-01-09T20:13:41","date_gmt":"2025-01-09T20:13:41","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/09\/huong-dan-thao-tac-voi-trang-tinh-trong-bai-thi-mos-excel\/"},"modified":"2025-01-09T20:13:41","modified_gmt":"2025-01-09T20:13:41","slug":"huong-dan-thao-tac-voi-trang-tinh-trong-bai-thi-mos-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/09\/huong-dan-thao-tac-voi-trang-tinh-trong-bai-thi-mos-excel\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn thao t\u00e1c v\u1edbi trang t\u00ednh trong b\u00e0i thi MOS Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>M\u1ed9t s\u1ed5 t\u00ednh Excel bao g\u1ed3m nh\u1eefng trang t\u00ednh ph\u1ee5c v\u1ee5 cho c\u00e1c m\u1ee5c \u0111\u00edch kh\u00e1c nhau. Vi\u1ec7c thao t\u00e1c v\u1edbi trang t\u00ednh n\u00e0y s\u1ebd gi\u00fap tr\u00ecnh b\u00e0y c\u00f4ng vi\u1ec7c khoa h\u1ecdc h\u01a1n \u2013 ch\u1ec9 b\u1eb1ng v\u00e0i thao t\u00e1c \u0111\u01a1n gi\u1ea3n. H\u00e3y c\u00f9ng H\u1ecdc Excel Online t\u00ecm hi\u1ec3u nh\u00e9!<\/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-67802df5115f4\" 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\/thao-tac-voi-trang-tinh-mos-excel.html#Doi_ten_trang_tinh\" title=\"\u0110\u1ed5i t\u00ean trang t\u00ednh\">\u0110\u1ed5i t\u00ean trang 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\/thao-tac-voi-trang-tinh-mos-excel.html#Thembot_trang_tinh\" title=\"Th\u00eam\/b\u1edbt trang t\u00ednh\">Th\u00eam\/b\u1edbt trang t\u00ednh<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/thao-tac-voi-trang-tinh-mos-excel.html#Doi_mau_cho_trang_tinh\" title=\"\u0110\u1ed5i m\u00e0u cho trang t\u00ednh\">\u0110\u1ed5i m\u00e0u cho trang t\u00ednh<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/thao-tac-voi-trang-tinh-mos-excel.html#Nhom_cac_trang_tinh\" title=\"Nh\u00f3m c\u00e1c trang t\u00ednh\">Nh\u00f3m c\u00e1c trang t\u00ednh<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/thao-tac-voi-trang-tinh-mos-excel.html#Anhien_trang_tinh\" title=\"\u1ea8n\/hi\u1ec7n trang t\u00ednh\">\u1ea8n\/hi\u1ec7n trang t\u00ednh<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/blog.hocexcel.online\/thao-tac-voi-trang-tinh-mos-excel.html#Di_chuyen_va_Copy_trang_tinh\" title=\"Di chuy\u1ec3n v\u00e0 Copy trang t\u00ednh\">Di chuy\u1ec3n v\u00e0 Copy trang t\u00ednh<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"Doi_ten_trang_tinh\"><\/span><strong>\u0110\u1ed5i t\u00ean trang t\u00ednh<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0110\u1ec3 \u0111\u1ed5i t\u00ean trang t\u00ednh, b\u1ea1n click chu\u1ed9t ph\u1ea3i v\u00e0o v\u00e0 ch\u1ecdn <strong>Rename. <\/strong>Ho\u1eb7c c\u00f3 th\u1ec3 thay b\u1eb1ng Click \u0111\u00fap chu\u1ed9t tr\u00e1i.<\/p>\n<figure id=\"attachment_20608\" aria-describedby=\"caption-attachment-20608\" style=\"width: 274px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-20608\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/mos-excel-2010-rename.png\" width=\"274\" height=\"264\" title=\"mos-excel-2010-rename\"><figcaption id=\"caption-attachment-20608\" class=\"wp-caption-text\">Click chuojt ph\u1ea3i v\u00e0 ch\u1ecdn Rename<\/figcaption><\/figure>\n<p>T\u00ean trang t\u00ednh ph\u1ea3i th\u1ecfa m\u00e3n:<\/p>\n<ol>\n<li>Kh\u00f4ng tr\u00f9ng v\u1edbi nh\u1eefng t\u00ean kh\u00e1c.<\/li>\n<li>Kh\u00f4ng \u0111\u01b0\u1ee3c \u0111\u1ec3 tr\u1ed1ng.<\/li>\n<\/ol>\n<h3><span class=\"ez-toc-section\" id=\"Thembot_trang_tinh\"><\/span><strong>Th\u00eam\/b\u1edbt trang t\u00ednh<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0110\u1ec3 th\u00eam ho\u1eb7c b\u1edbt trang t\u00ednh, b\u1ea1n click chu\u1ed9t ph\u1ea3i v\u00e0 ch\u1ecdn <strong>Insert. <\/strong>T\u01b0\u01a1ng t\u1ef1 nh\u01b0 b\u00e0i vi\u1ebft tr\u01b0\u1edbc v\u1ec1 <a href=\"http:\/\/blog.ezworkapp.com\/thao-tac-voi-hang-va-cot-mos-excel.html\">th\u00eam b\u1edbt h\u00e0ng\/c\u1ed9t<\/a> \u0111\u00e3 gi\u1edbi thi\u1ec7u, b\u1ea1n c\u00f3 th\u1ec3 ch\u1ecdn ch\u1ee9c n\u0103ng Insert trong th\u1ebb <strong>Cells,<\/strong> sau \u0111\u00f3 ch\u1ecdn <strong>Insert Sheet.<\/strong><\/p>\n<figure id=\"attachment_20609\" aria-describedby=\"caption-attachment-20609\" style=\"width: 179px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-20609\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/mos-excel-2010-insert-1.png\" width=\"179\" height=\"181\" title=\"mos-excel-2010-insert-1\"><figcaption id=\"caption-attachment-20609\" class=\"wp-caption-text\">Th\u00eam sheet b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng Insert<\/figcaption><\/figure>\n<p>Th\u1ef1c hi\u1ec7n t\u01b0\u01a1ng t\u1ef1 v\u1edbi Delete \u0111\u1ec3 x\u00f3a b\u1edbt trang t\u00ednh.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Doi_mau_cho_trang_tinh\"><\/span><strong>\u0110\u1ed5i m\u00e0u cho trang t\u00ednh<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Nh\u1eb1m t\u1ea1o s\u1ef1 kh\u00e1c bi\u1ec7t gi\u1eefa c\u00e1c trang t\u00ednh, Excel cho ph\u00e9p ng\u01b0\u1eddi s\u1eed d\u1ee5ng \u0111\u1ed5i m\u00e0u trang t\u00ednh. \u0110\u1ec3 \u0111\u1ed5i m\u00e0u, b\u1ea1n click chu\u1ed9t ph\u1ea3i v\u00e0o trang t\u00ednh, sau \u0111\u00f3 ch\u1ecdn <strong>Tab Color.<\/strong><\/p>\n<figure id=\"attachment_20610\" aria-describedby=\"caption-attachment-20610\" style=\"width: 408px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-20610\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/mos-excel-2010-tab-color.png\" width=\"408\" height=\"295\" title=\"mos-excel-2010-tab-color\"><figcaption id=\"caption-attachment-20610\" class=\"wp-caption-text\">Hi\u1ec3n th\u1ecb khoa h\u1ecdc h\u01a1n v\u1edbi tab color<\/figcaption><\/figure>\n<h3><span class=\"ez-toc-section\" id=\"Nhom_cac_trang_tinh\"><\/span><strong>Nh\u00f3m c\u00e1c trang t\u00ednh<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0110\u1ec3 nh\u00f3m c\u00e1c trang t\u00ednh li\u1ec1n nhau, gi\u1eef <strong>Shift<\/strong> t\u1ea1i trang t\u00ednh \u0111\u1ea7u, sau \u0111\u00f3 ch\u1ecdn trang t\u00ednh cu\u1ed1i.<\/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-139.gif\" title=\"ex101_92019-nho-139\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>\u0110\u1ec3 nh\u00f3m c\u00e1c trang t\u00ednh kh\u00f4ng li\u1ec1n nhau, gi\u1eef <strong>Ctrl <\/strong>t\u1ea1i trang t\u00ednh \u0111\u1ea7u, sau \u0111\u00f3 ch\u1ecdn nh\u1eefng trang t\u00ednh mu\u1ed1n nh\u00f3m.<\/p>\n<figure id=\"attachment_20611\" aria-describedby=\"caption-attachment-20611\" style=\"width: 495px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-20611\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/mos-excel-2010-group-sheet.png\" width=\"495\" height=\"131\" title=\"mos-excel-2010-group-sheet\"><figcaption id=\"caption-attachment-20611\" class=\"wp-caption-text\">C\u00e1c trang t\u00ednh \u0111\u01b0\u1ee3c nh\u00f3m v\u1edbi nhau (g\u1ea1ch ch\u00e2n b\u00ean d\u01b0\u1edbi)<\/figcaption><\/figure>\n<h3><span class=\"ez-toc-section\" id=\"Anhien_trang_tinh\"><\/span><strong>\u1ea8n\/hi\u1ec7n trang t\u00ednh<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>C\u00e1ch 1: Click chu\u1ed9t ph\u1ea3i v\u00e0o trang t\u00ednh, ch\u1ecdn Hide\/Unhide\u2026 t\u01b0\u01a1ng \u1ee9ng<\/p>\n<p>C\u00e1ch 2: T\u1ea1i th\u1ebb <strong>Home<\/strong>, m\u1ee5c <strong>Format <\/strong>trong nh\u00f3m <strong>Cells<\/strong>, \u1ea5n v\u00e0o <strong>Hide &amp; Unhide <\/strong>v\u00e0 ch\u1ecdn <strong>Hide\/Unhide sheet.<\/strong><\/p>\n<figure id=\"attachment_20612\" aria-describedby=\"caption-attachment-20612\" style=\"width: 241px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-20612\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/mos-excel-2010-hide-unhide.png\" width=\"241\" height=\"266\" title=\"mos-excel-2010-hide-unhide\"><figcaption id=\"caption-attachment-20612\" class=\"wp-caption-text\">\u1ea8n hi\u1ec7n Sheet<\/figcaption><\/figure>\n<h3><span class=\"ez-toc-section\" id=\"Di_chuyen_va_Copy_trang_tinh\"><\/span><strong>Di chuy\u1ec3n v\u00e0 Copy trang t\u00ednh<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<ol>\n<li>Ch\u1ecdn trang t\u00ednh mu\u1ed1n copy ho\u1eb7c di chuy\u1ec3n.<\/li>\n<li>Click chu\u1ed9t ph\u1ea3i, ch\u1ecdn <strong>Move or Copy\u2026<\/strong><\/li>\n<li>T\u1ea1i h\u1ed9p tho\u1ea1i <strong>Move or Copy<\/strong>, m\u1ee5c <strong>To book: <\/strong>hi\u1ec3n th\u1ecb v\u1ecb tr\u00ed \u0111\u00edch c\u1ee7a sheet \u2013 c\u00f3 th\u1ec3 di chuy\u1ec3n sheet sang s\u1ed5 t\u00ednh kh\u00e1c. M\u1ee5c <strong>Before sheet<\/strong> hi\u1ec3n th\u1ecb v\u1ecb tr\u00ed c\u1ee7a sheet trong workbook \u0111\u1eb7t \u1edf tr\u01b0\u1edbc sheet n\u00e0o.<\/li>\n<li>T\u00edch v\u00e0o \u00f4 <strong>Create a copy<\/strong> n\u1ebfu mu\u1ed1n t\u1ea1o m\u1ed9t b\u1ea3n copy cho sheet.<\/li>\n<li>\u1ea4n OK \u0111\u1ec3 l\u01b0u v\u00e0 thay \u0111\u1ed5i thi\u1ebft l\u1eadp.<\/li>\n<\/ol>\n<figure id=\"attachment_20613\" aria-describedby=\"caption-attachment-20613\" style=\"width: 302px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-20613\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/mos-excel-2010-move-or-copy.png\" width=\"302\" height=\"289\" title=\"mos-excel-2010-move-or-copy\"><figcaption id=\"caption-attachment-20613\" class=\"wp-caption-text\">Di chuy\u1ec3n ho\u1eb7c copy trang t\u00ednh<\/figcaption><\/figure>\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 b\u00e0i vi\u1ebft ti\u1ebfp theo trong series MOS Excel: B\u1ea3o v\u1ec7 trang t\u00ednh b\u1eb1ng ch\u1ee9c n\u0103ng Protect Sheet.<\/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-139.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":10169,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-10168","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\/10168","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=10168"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/10168\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/10169"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=10168"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=10168"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=10168"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}