{"id":36523,"date":"2025-11-29T00:56:11","date_gmt":"2025-11-29T00:56:11","guid":{"rendered":"https:\/\/onlineexammaker.com\/kb\/?p=36523"},"modified":"2025-12-09T18:38:13","modified_gmt":"2025-12-09T18:38:13","slug":"15-excel-quiz-questions-and-answers-12","status":"publish","type":"post","link":"https:\/\/onlineexammaker.com\/kb\/vi\/15-excel-quiz-questions-and-answers-12\/","title":{"rendered":"2026 | 15 c\u00e2u h\u1ecfi v\u00e0 \u0111\u00e1p \u00e1n tr\u1eafc nghi\u1ec7m Excel"},"content":{"rendered":"<p>Microsoft Excel l\u00e0 m\u1ed9t \u1ee9ng d\u1ee5ng b\u1ea3ng t\u00ednh ph\u1ed5 bi\u1ebfn \u0111\u01b0\u1ee3c ph\u00e1t tri\u1ec3n b\u1edfi Microsoft. N\u00f3 l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 m\u1ea1nh m\u1ebd cho vi\u1ec7c t\u1ed5 ch\u1ee9c, ph\u00e2n t\u00edch v\u00e0 hi\u1ec3n th\u1ecb d\u1eef li\u1ec7u d\u01b0\u1edbi d\u1ea1ng b\u1ea3ng t\u00ednh. D\u01b0\u1edbi \u0111\u00e2y l\u00e0 m\u1ed9t s\u1ed1 \u0111i\u1ec3m quan tr\u1ecdng v\u1ec1 Microsoft Excel:<\/p>\n<p>I. C\u00e1c t\u00ednh n\u0103ng ch\u00ednh c\u1ee7a Excel:<\/p>\n<p>B\u1ea3ng t\u00ednh: Excel cung c\u1ea5p m\u1ed9t giao di\u1ec7n l\u00e0m vi\u1ec7c d\u1ec5 s\u1eed d\u1ee5ng cho vi\u1ec7c t\u1ea1o, s\u1eeda \u0111\u1ed5i v\u00e0 t\u1ed5 ch\u1ee9c d\u1eef li\u1ec7u trong c\u00e1c b\u1ea3ng t\u00ednh.<br \/>\nC\u00f4ng th\u1ee9c v\u00e0 h\u00e0m: Excel cung c\u1ea5p m\u1ed9t lo\u1ea1t c\u00e1c c\u00f4ng th\u1ee9c v\u00e0 h\u00e0m t\u00edch h\u1ee3p \u0111\u1ec3 th\u1ef1c hi\u1ec7n c\u00e1c ph\u00e9p t\u00ednh v\u00e0 t\u00ednh to\u00e1n ph\u1ee9c t\u1ea1p tr\u00ean d\u1eef li\u1ec7u.<br \/>\n\u0110\u1ecbnh d\u1ea1ng: Excel cho ph\u00e9p ng\u01b0\u1eddi d\u00f9ng t\u00f9y ch\u1ec9nh \u0111\u1ecbnh d\u1ea1ng c\u1ee7a d\u1eef li\u1ec7u v\u00e0 b\u1ea3ng t\u00ednh, bao g\u1ed3m font ch\u1eef, m\u00e0u s\u1eafc, s\u1ed1, v\u00e0 ng\u00e0y th\u00e1ng.<br \/>\nT\u1ea1o \u0111\u1ed3 th\u1ecb v\u00e0 bi\u1ec3u \u0111\u1ed3: Excel cho ph\u00e9p ng\u01b0\u1eddi d\u00f9ng t\u1ea1o v\u00e0 t\u00f9y ch\u1ec9nh c\u00e1c lo\u1ea1i \u0111\u1ed3 th\u1ecb v\u00e0 bi\u1ec3u \u0111\u1ed3 \u0111\u1ec3 hi\u1ec3n th\u1ecb d\u1eef li\u1ec7u m\u1ed9t c\u00e1ch tr\u1ef1c quan.<br \/>\nT\u00edch h\u1ee3p: Excel c\u00f3 th\u1ec3 t\u00edch h\u1ee3p v\u1edbi c\u00e1c \u1ee9ng d\u1ee5ng kh\u00e1c trong b\u1ed9 Office c\u1ee7a Microsoft, nh\u01b0 Word v\u00e0 PowerPoint, \u0111\u1ec3 chia s\u1ebb d\u1eef li\u1ec7u v\u00e0 t\u00e0i li\u1ec7u m\u1ed9t c\u00e1ch d\u1ec5 d\u00e0ng.<\/p>\n<p>II. \u1ee8ng d\u1ee5ng c\u1ee7a Excel:<\/p>\n<p>Qu\u1ea3n l\u00fd d\u1eef li\u1ec7u: Excel th\u00edch h\u1ee3p cho vi\u1ec7c t\u1ed5 ch\u1ee9c v\u00e0 qu\u1ea3n l\u00fd d\u1eef li\u1ec7u, bao g\u1ed3m danh s\u00e1ch, b\u1ea3ng \u0111i\u1ec3m, v\u00e0 th\u00f4ng tin c\u00e1 nh\u00e2n.<br \/>\nPh\u00e2n t\u00edch d\u1eef li\u1ec7u: Excel cung c\u1ea5p c\u00e1c c\u00f4ng c\u1ee5 ph\u00e2n t\u00edch m\u1ea1nh m\u1ebd \u0111\u1ec3 t\u00ecm hi\u1ec3u v\u00e0 r\u00fat ra th\u00f4ng tin t\u1eeb d\u1eef li\u1ec7u, bao g\u1ed3m c\u00e1c b\u00e1o c\u00e1o v\u00e0 bi\u1ec3u \u0111\u1ed3.<br \/>\nQu\u1ea3n l\u00fd t\u00e0i ch\u00ednh: Excel \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng r\u1ed9ng r\u00e3i cho vi\u1ec7c qu\u1ea3n l\u00fd t\u00e0i ch\u00ednh c\u00e1 nh\u00e2n v\u00e0 doanh nghi\u1ec7p, bao g\u1ed3m theo d\u00f5i ng\u00e2n s\u00e1ch, t\u00e0i kho\u1ea3n, v\u00e0 d\u1ef1 \u00e1n.<br \/>\nL\u1eadp k\u1ebf ho\u1ea1ch v\u00e0 theo d\u00f5i: Excel l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 h\u1eefu \u00edch cho vi\u1ec7c l\u1eadp k\u1ebf ho\u1ea1ch v\u00e0 theo d\u00f5i c\u00e1c ho\u1ea1t \u0111\u1ed9ng, d\u1ef1 \u00e1n, v\u00e0 l\u1ecbch tr\u00ecnh c\u00f4ng vi\u1ec7c.<\/p>\n<p>III. H\u1ecdc c\u00e1ch s\u1eed d\u1ee5ng Excel:<\/p>\n<p>T\u00e0i li\u1ec7u h\u1ecdc t\u1eadp: C\u00f3 nhi\u1ec1u t\u00e0i li\u1ec7u h\u1ecdc t\u1eadp v\u00e0 h\u01b0\u1edbng d\u1eabn tr\u1ef1c tuy\u1ebfn mi\u1ec5n ph\u00ed \u0111\u1ec3 h\u1ecdc c\u00e1ch s\u1eed d\u1ee5ng Excel t\u1eeb c\u01a1 b\u1ea3n \u0111\u1ebfn n\u00e2ng cao.<br \/>\nKh\u00f3a h\u1ecdc tr\u1ef1c tuy\u1ebfn: C\u00f3 c\u00e1c kh\u00f3a h\u1ecdc tr\u1ef1c tuy\u1ebfn v\u00e0 offline \u0111\u01b0\u1ee3c cung c\u1ea5p b\u1edfi c\u00e1c t\u1ed5 ch\u1ee9c v\u00e0 tr\u01b0\u1eddng h\u1ecdc \u0111\u1ec3 cung c\u1ea5p ki\u1ebfn th\u1ee9c chuy\u00ean s\u00e2u v\u1ec1 Excel.<br \/>\nTh\u1ef1c h\u00e0nh: Vi\u1ec7c th\u1ef1c h\u00e0nh l\u00e0 c\u00e1ch t\u1ed1t nh\u1ea5t \u0111\u1ec3 n\u1eafm v\u1eefng k\u1ef9 n\u0103ng s\u1eed d\u1ee5ng Excel. T\u1ea1o c\u00e1c b\u1ea3ng t\u00ednh v\u00e0 th\u1ef1c hi\u1ec7n c\u00e1c ph\u00e9p t\u00ednh kh\u00e1c nhau \u0111\u1ec3 l\u00e0m quen v\u1edbi c\u00e1c t\u00ednh n\u0103ng c\u1ee7a n\u00f3.<\/p>\n<p>Excel l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 quan tr\u1ecdng v\u00e0 linh ho\u1ea1t trong nhi\u1ec1u l\u0129nh v\u1ef1c, t\u1eeb kinh doanh \u0111\u1ebfn gi\u00e1o d\u1ee5c v\u00e0 nghi\u00ean c\u1ee9u. Vi\u1ec7c n\u1eafm v\u1eefng k\u1ef9 n\u0103ng s\u1eed d\u1ee5ng Excel c\u00f3 th\u1ec3 gi\u00fap b\u1ea1n t\u0103ng c\u01b0\u1eddng hi\u1ec7u su\u1ea5t v\u00e0 hi\u1ec7u qu\u1ea3 trong c\u00f4ng vi\u1ec7c h\u00e0ng ng\u00e0y.<\/p>\n<div class=\"refer_box\">\n<p class=\"refer_box_title\"> M\u1eb9o chuy\u00ean nghi\u1ec7p<\/p>\n<p class=\"refer_box_text\"> B\u1ea1n mu\u1ed1n \u0111\u00e1nh gi\u00e1 ng\u01b0\u1eddi h\u1ecdc tr\u1ef1c tuy\u1ebfn? <a href=\"https:\/\/onlineexammaker.com?refer=blog_refer\">T\u1ea1o m\u1ed9t b\u00e0i ki\u1ec3m tra tr\u1ef1c tuy\u1ebfn mi\u1ec5n ph\u00ed<\/a> !<\/p>\n<\/div>\n<h3> T\u1ed5ng quan b\u00e0i vi\u1ebft<\/h3>\n<ul class=\"article_list\">\n<li><a href=\"#a\">Ph\u1ea7n 1: OnlineExmaker &#8211; T\u1ea1o v\u00e0 chia s\u1ebb b\u00e0i ki\u1ec3m tra Excel v\u1edbi AI t\u1ef1 \u0111\u1ed9ng <\/a><\/li>\n<li><a href=\"#1\">Ph\u1ea7n 2: 15 c\u00e2u h\u1ecfi tr\u1eafc nghi\u1ec7m Microsoft Excel v\u00e0 \u0111\u00e1p \u00e1n<\/a><\/li>\n<li> <a href=\"#2\">Ph\u1ea7n 3: Tr\u00ecnh t\u1ea1o c\u00e2u h\u1ecfi AI c\u1ee7a OnlineExamMaker: T\u1ea1o c\u00e2u h\u1ecfi cho b\u1ea5t k\u1ef3 ch\u1ee7 \u0111\u1ec1 n\u00e0o<\/a><\/li>\n<\/ul>\n<p><img decoding=\"async\" src=\"https:\/\/onlineexammaker.com\/kb\/wp-content\/uploads\/2023\/08\/excel-quiz.webp\" alt=\"\" \/><\/p>\n<h3 id=\"a\">Ph\u1ea7n 1: OnlineExmaker &#8211; T\u1ea1o v\u00e0 chia s\u1ebb b\u00e0i ki\u1ec3m tra Excel v\u1edbi AI t\u1ef1 \u0111\u1ed9ng <\/h3>\n<p>OnlineExammaker l\u00e0 m\u1ed9t n\u1ec1n t\u1ea3ng \u0111\u00e1nh gi\u00e1 h\u1ed7 tr\u1ee3 AI m\u1ea1nh m\u1ebd \u0111\u1ec3 t\u1ea1o ra c\u00e1c \u0111\u00e1nh gi\u00e1 k\u1ef9 n\u0103ng Excel t\u1ef1 \u0111\u1ed9ng. N\u00f3 \u0111\u01b0\u1ee3c thi\u1ebft k\u1ebf cho c\u00e1c nh\u00e0 gi\u00e1o d\u1ee5c, gi\u1ea3ng vi\u00ean, doanh nghi\u1ec7p v\u00e0 b\u1ea5t c\u1ee9 ai mu\u1ed1n t\u1ea1o ra c\u00e1c c\u00e2u \u0111\u1ed1 h\u1ea5p d\u1eabn m\u00e0 kh\u00f4ng d\u00e0nh h\u00e0ng gi\u1edd \u0111\u1ec3 ch\u1ebf t\u1ea1o c\u00e1c c\u00e2u h\u1ecfi theo c\u00e1ch th\u1ee7 c\u00f4ng. T\u00ednh n\u0103ng Tr\u00ecnh t\u1ea1o c\u00e2u h\u1ecfi AI cho ph\u00e9p b\u1ea1n nh\u1eadp m\u1ed9t ch\u1ee7 \u0111\u1ec1 ho\u1eb7c chi ti\u1ebft c\u1ee5 th\u1ec3 v\u00e0 n\u00f3 t\u1ef1 \u0111\u1ed9ng t\u1ea1o ra nhi\u1ec1u lo\u1ea1i c\u00e2u h\u1ecfi.<\/p>\n<p><strong> C\u00e1c t\u00ednh n\u0103ng h\u00e0ng \u0111\u1ea7u \u0111\u1ec3 t\u1ed5 ch\u1ee9c \u0111\u00e1nh gi\u00e1: <\/strong><br \/>\n\u25cf Ng\u0103n ch\u1eb7n gian l\u1eadn b\u1eb1ng c\u00e1ch ch\u1ecdn ng\u1eabu nhi\u00ean c\u00e1c c\u00e2u h\u1ecfi ho\u1eb7c thay \u0111\u1ed5i th\u1ee9 t\u1ef1 c\u00e2u h\u1ecfi, v\u00ec v\u1eady ng\u01b0\u1eddi h\u1ecdc kh\u00f4ng nh\u1eadn \u0111\u01b0\u1ee3c c\u00f9ng m\u1ed9t b\u1ed9 c\u00e2u h\u1ecfi m\u1ed7i l\u1ea7n.<br \/>\n\u25cf H\u1ecdc sinh l\u1edbp AI \u0111\u1ec3 ph\u00e2n lo\u1ea1i hi\u1ec7u qu\u1ea3 c\u00e1c c\u00e2u \u0111\u1ed1 v\u00e0 b\u00e0i t\u1eadp, cung c\u1ea5p nh\u1eadn x\u00e9t n\u1ed9i tuy\u1ebfn, ghi \u0111i\u1ec3m t\u1ef1 \u0111\u1ed9ng v\u00e0 &#8220;\u0111i\u1ec3m fudge&#8221; \u0111\u1ec3 \u0111i\u1ec1u ch\u1ec9nh th\u1ee7 c\u00f4ng.<br \/>\n\u25cf Nh\u00fang c\u00e1c c\u00e2u h\u1ecfi tr\u00ean c\u00e1c trang web, blog ho\u1eb7c chia s\u1ebb qua email, ph\u01b0\u01a1ng ti\u1ec7n truy\u1ec1n th\u00f4ng x\u00e3 h\u1ed9i (Facebook, Twitter) ho\u1eb7c li\u00ean k\u1ebft tr\u1ef1c ti\u1ebfp.<br \/>\n\u25cf X\u1eed l\u00fd th\u1eed nghi\u1ec7m quy m\u00f4 l\u1edbn (h\u00e0ng ng\u00e0n b\u00e0i ki\u1ec3m tra\/h\u1ecdc k\u1ef3) m\u00e0 kh\u00f4ng c\u1ea7n ph\u1ee5 thu\u1ed9c Internet, \u0111\u01b0\u1ee3c h\u1ed7 tr\u1ee3 b\u1edfi c\u01a1 s\u1edf h\u1ea1 t\u1ea7ng \u0111\u00e1m m\u00e2y.<\/p>\n<div class=\"embed_video_blog\">\n<div class=\"embed-responsive embed-responsive-16by9\" style=\"margin-bottom:16px;\">\n <iframe class=\"embed-responsive-item\" src=\"https:\/\/www.youtube.com\/embed\/bv7AAAyFOo4\"><\/iframe>\n<\/div>\n<\/div>\n<div class=\"getstarted-container\">\n<p style=\"margin-bottom: 13px;\">T\u1ea1o b\u00e0i ki\u1ec3m tra\/b\u00e0i ki\u1ec3m tra ti\u1ebfp theo c\u1ee7a b\u1ea1n v\u1edbi OnlineExamMaker<\/p>\n<div class=\"blog_double_btn clearfix\">\n<div class=\"col-sm-6  col-xs-12\">\n<div class=\"p-style-a\"><a class=\"get_started_btn\" href=\"https:\/\/onlineexammaker.com\/sign-up.html?refer=blog_btn\"> B\u1eaft \u0111\u1ea7u mi\u1ec5n ph\u00ed<\/a><\/div>\n<div class=\"p-style-b\">SAAS, mi\u1ec5n ph\u00ed m\u00e3i m\u00e3i<\/div>\n<\/div>\n<div class=\"col-sm-6  col-xs-12\">\n<div class=\"p-style-a\"><a class=\"get_started_btn\" href=\"https:\/\/onlineexammaker.com\/lan.html?refer=blog_btn\">On-Premise: T\u1ea3i xu\u1ed1ng<\/a><\/div>\n<div class=\"p-style-b\">Quy\u1ec1n s\u1edf h\u1eefu d\u1eef li\u1ec7u 100%<\/div>\n<\/div>\n<\/div>\n<\/div>\n<h3 id=\"1\"> Ph\u1ea7n 2: 15 c\u00e2u h\u1ecfi tr\u1eafc nghi\u1ec7m Microsoft Excel v\u00e0 \u0111\u00e1p \u00e1n<\/h3>\n<p><button type=\"button\" id=\"copyquestionsBtn\" onClick=\"myFunction()\">Sao ch\u00e9p c\u00e2u h\u1ecfi \u0111\u1ed1<\/button><\/p>\n<div id=\"copy_questions\">\n<p>1. C\u00e2u h\u1ecfi: Excel l\u00e0 g\u00ec?<br \/>\n   A. M\u1ed9t tr\u00ecnh so\u1ea1n th\u1ea3o v\u0103n b\u1ea3n<br \/>\n   B. M\u1ed9t \u1ee9ng d\u1ee5ng ch\u1ec9nh s\u1eeda h\u00ecnh \u1ea3nh<br \/>\n   C. M\u1ed9t \u1ee9ng d\u1ee5ng b\u1ea3ng t\u00ednh<br \/>\n   D. M\u1ed9t tr\u00ecnh duy\u1ec7t web<br \/>\n   \u0110\u00e1p \u00e1n: C. M\u1ed9t \u1ee9ng d\u1ee5ng b\u1ea3ng t\u00ednh<\/p>\n<p>2. C\u00e2u h\u1ecfi: C\u00f4ng c\u1ee5 n\u00e0o \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 t\u00ednh t\u1ed5ng c\u1ee7a m\u1ed9t lo\u1ea1t c\u00e1c \u00f4 trong Excel?<br \/>\n   A. SUM<br \/>\n   B. COUNT<br \/>\n   C. MAX<br \/>\n   D. AVG<br \/>\n   \u0110\u00e1p \u00e1n: A. SUM<\/p>\n<p>3. C\u00e2u h\u1ecfi: C\u00f4ng th\u1ee9c n\u00e0o \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 t\u00ednh trung b\u00ecnh c\u1ee7a m\u1ed9t lo\u1ea1t c\u00e1c \u00f4 trong Excel?<br \/>\n   A. AVG<br \/>\n   B. SUM<br \/>\n   C. COUNT<br \/>\n   D. MIN<br \/>\n   \u0110\u00e1p \u00e1n: A. AVG<\/p>\n<p>4. C\u00e2u h\u1ecfi: C\u00f4ng th\u1ee9c n\u00e0o \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 \u0111\u1ebfm s\u1ed1 l\u01b0\u1ee3ng c\u00e1c \u00f4 c\u00f3 gi\u00e1 tr\u1ecb trong Excel?<br \/>\n   A. MAX<br \/>\n   B. COUNT<br \/>\n   C. SUM<br \/>\n   D. AVERAGE<br \/>\n   \u0110\u00e1p \u00e1n: B. COUNT<\/p>\n<p>5. C\u00e2u h\u1ecfi: C\u00f4ng c\u1ee5 n\u00e0o \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 t\u1ea1o bi\u1ec3u \u0111\u1ed3 trong Excel?<br \/>\n   A. Chart Wizard<br \/>\n   B. Graph Maker<br \/>\n   C. Diagram Creator<br \/>\n   D. Chart Tool<br \/>\n   \u0110\u00e1p \u00e1n: A. Chart Wizard<\/p>\n<p>6. C\u00e2u h\u1ecfi: C\u00f4ng th\u1ee9c n\u00e0o \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 t\u00ecm gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t trong m\u1ed9t lo\u1ea1t c\u00e1c \u00f4 trong Excel?<br \/>\n   A. MAX<br \/>\n   B. MIN<br \/>\n   C. SUM<br \/>\n   D. COUNT<br \/>\n   \u0110\u00e1p \u00e1n: A. MAX<\/p>\n<p>7. C\u00e2u h\u1ecfi: \u0110\u1ec3 chia m\u1ed9t \u00f4 Excel th\u00e0nh hai \u00f4, b\u1ea1n s\u1eed d\u1ee5ng c\u00f4ng c\u1ee5 n\u00e0o?<br \/>\n   A. Divide<br \/>\n   B. Split<br \/>\n   C. Cut<br \/>\n   D. Merge<br \/>\n   \u0110\u00e1p \u00e1n: D. Merge<\/p>\n<p>8. C\u00e2u h\u1ecfi: C\u00f4ng c\u1ee5 n\u00e0o \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 s\u1eafp x\u1ebfp d\u1eef li\u1ec7u trong Excel theo th\u1ee9 t\u1ef1 t\u0103ng d\u1ea7n ho\u1eb7c gi\u1ea3m d\u1ea7n?<br \/>\n   A. Sort Tool<br \/>\n   B. Arrange Data<br \/>\n   C. Filter<br \/>\n   D. Table Order<br \/>\n   \u0110\u00e1p \u00e1n: A. Sort Tool<\/p>\n<p>9. C\u00e2u h\u1ecfi: \u0110\u1ec3 ch\u1ecdn t\u1ea5t c\u1ea3 c\u00e1c \u00f4 trong m\u1ed9t b\u1ea3ng t\u00ednh Excel, b\u1ea1n s\u1eed d\u1ee5ng ph\u00edm t\u1eaft n\u00e0o?<br \/>\n   A. Ctrl + A<br \/>\n   B. Alt + A<br \/>\n   C. Shift + A<br \/>\n   D. Ctrl + S<br \/>\n   \u0110\u00e1p \u00e1n: A. Ctrl + A<\/p>\n<p>10. C\u00e2u h\u1ecfi: C\u00f4ng c\u1ee5 n\u00e0o \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 t\u1ea1o m\u1ed9t b\u1ea3ng Pivot trong Excel?<br \/>\n    A. Pivot Table Wizard<br \/>\n    B. Pivot Maker<br \/>\n    C. Table Pivot Tool<br \/>\n    D. Pivot Tool<br \/>\n    \u0110\u00e1p \u00e1n: A. Pivot Table Wizard<\/p>\n<p>11. C\u00e2u h\u1ecfi: C\u00f4ng th\u1ee9c n\u00e0o \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 t\u00ednh ph\u1ea7n tr\u0103m t\u0103ng tr\u01b0\u1edfng trong Excel?<br \/>\n    A. GROWTH<br \/>\n    B. PERCENT<br \/>\n    C. INCREASE<br \/>\n    D. Percentage Growth<br \/>\n    \u0110\u00e1p \u00e1n: B. PERCENT<\/p>\n<p>12. C\u00e2u h\u1ecfi: \u0110\u1ec3 t\u1ea1o m\u1ed9t bi\u1ec3u \u0111\u1ed3 d\u00f2ng trong Excel, b\u1ea1n s\u1eed d\u1ee5ng lo\u1ea1i bi\u1ec3u \u0111\u1ed3 n\u00e0o?<br \/>\n    A. Line Chart<br \/>\n    B. Pie Chart<br \/>\n    C. Bar Chart<br \/>\n    D. Scatter Plot<br \/>\n    \u0110\u00e1p \u00e1n: A. Line Chart<\/p>\n<p>13. C\u00e2u h\u1ecfi: C\u00f4ng c\u1ee5 n\u00e0o \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 chia c\u1eaft d\u1eef li\u1ec7u d\u1ecdc theo h\u00e0ng v\u00e0 c\u1ed9t trong Excel?<br \/>\n    A. Split Data<br \/>\n    B. Divide Data<br \/>\n    C. Freeze Panes<br \/>\n    D. Cut Data<br \/>\n    \u0110\u00e1p \u00e1n: C. Freeze Panes<\/p>\n<p>14. C\u00e2u h\u1ecfi: \u0110\u1ec3 t\u1ea1o m\u1ed9t b\u1ea3ng d\u1eef li\u1ec7u t\u1ef1 \u0111\u1ed9ng m\u1edf r\u1ed9ng trong Excel, b\u1ea1n s\u1eed d\u1ee5ng t\u00ednh n\u0103ng n\u00e0o?<br \/>\n    A. Dynamic Table<br \/>\n    B. AutoFill<br \/>\n    C. Data Table<br \/>\n    D. Table Expansion<br \/>\n    \u0110\u00e1p \u00e1n: B. AutoFill<\/p>\n<p>15. C\u00e2u h\u1ecfi: C\u00f4ng th\u1ee9c n\u00e0o \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 l\u1ea5y gi\u00e1 tr\u1ecb c\u1ee7a \u00f4 trong m\u1ed9t b\u1ea3ng t\u00ednh Excel?<br \/>\n    A. VALUE<br \/>\n    B. GET<br \/>\n    C. CELL<br \/>\n    D. VLOOKUP<br \/>\n    \u0110\u00e1p \u00e1n: D. VLOOKUP<\/p>\n<\/div>\n<p><button type=\"button\" id=\"copyquestionsBtn\" onClick=\"myFunction()\">Sao ch\u00e9p c\u00e2u h\u1ecfi \u0111\u1ed1<\/button><\/p>\n<h3 id=\"2\">Ph\u1ea7n 3: Tr\u00ecnh t\u1ea1o c\u00e2u h\u1ecfi AI c\u1ee7a OnlineExamMaker: T\u1ea1o c\u00e2u h\u1ecfi cho b\u1ea5t k\u1ef3 ch\u1ee7 \u0111\u1ec1 n\u00e0o<\/h3>\n<div class=\"embed_video_blog\">\n<div class=\"embed-responsive embed-responsive-16by9\" style=\"margin-bottom:16px;\">\n <iframe class=\"embed-responsive-item\" src=\"https:\/\/www.youtube.com\/embed\/zlqho9igH2Y\"><\/iframe>\n<\/div>\n<\/div>\n<div class=\"getstarted-container\">\n<p style=\"margin-bottom: 13px;\">T\u1ef1 \u0111\u1ed9ng t\u1ea1o c\u00e2u h\u1ecfi b\u1eb1ng AI<\/p>\n<div class=\"blog_double_btn clearfix\">\n<div class=\"col-sm-6  col-xs-12\">\n<div class=\"p-style-a\"><a class=\"get_started_btn\" href=\"https:\/\/onlineexammaker.com\/features\/ai-question-generator.html?refer=download_questions\" target=\"_blank\" rel=\"noopener\">Tr\u00ecnh t\u1ea1o c\u00e2u h\u1ecfi AI<\/a><\/div>\n<div class=\"p-style-b\">T\u1ea1o c\u00e2u h\u1ecfi cho b\u1ea5t k\u1ef3 ch\u1ee7 \u0111\u1ec1 n\u00e0o<\/div>\n<\/div>\n<div class=\"col-sm-6  col-xs-12\">\n<div class=\"p-style-a\"><a class=\"get_started_btn\" href=\"https:\/\/onlineexammaker.com\/sign-up.html?refer=blog_btn\"> T\u1ea1o m\u1ed9t c\u00e2u \u0111\u1ed1<\/a><\/div>\n<div class=\"p-style-b\">Mi\u1ec5n ph\u00ed 100% m\u00e3i m\u00e3i<\/div>\n<\/div>\n<\/div>\n<\/div>\n<p><script src=\"https:\/\/unpkg.com\/@popperjs\/core@2\"><\/script><br \/>\n<script src=\"https:\/\/unpkg.com\/tippy.js@6\"><\/script><\/p>\n<p><script type=\"text\/javascript\">\nfunction myFunction() {\nvar copyText = document.getElementById(\"copy_questions\");\n\/\/ Copy the text inside the text field\nconsole.log(copyText.innerText)\nnavigator.clipboard.writeText(copyText.innerText);\n}\nvar copy1, copy2;\n        tippy('#copyquestionsBtn', {\n        'content': \"Copy questions to clipboard\",\n       trigger: 'mouseenter',\n       'onCreate':function(instance){\n              copy1 = instance;\n       },\n       'onTrigger' : function(instance, event) {\n              copy2.hide();\n       }\n       });\n       tippy('#copyquestionsBtn', {\n       'content': \"Copied successfully\",\n       trigger: 'click',\n       'onCreate':function(instance){\n              copy2 = instance;\n       },\n       'onTrigger' : function(instance, event) {\n              copy1.hide();\n       }\n       });\n<\/script><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Microsoft Excel l\u00e0 m\u1ed9t \u1ee9ng d\u1ee5ng b\u1ea3ng t\u00ednh ph\u1ed5 bi\u1ebfn \u0111\u01b0\u1ee3c ph\u00e1t tri\u1ec3n b\u1edfi Microsoft. N\u00f3 l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 m\u1ea1nh m\u1ebd cho vi\u1ec7c t\u1ed5 ch\u1ee9c, ph\u00e2n t\u00edch v\u00e0 hi\u1ec3n th\u1ecb d\u1eef li\u1ec7u d\u01b0\u1edbi d\u1ea1ng b\u1ea3ng t\u00ednh. D\u01b0\u1edbi \u0111\u00e2y l\u00e0 m\u1ed9t s\u1ed1 \u0111i\u1ec3m quan tr\u1ecdng v\u1ec1 Microsoft Excel: I. C\u00e1c t\u00ednh n\u0103ng ch\u00ednh c\u1ee7a Excel: [&hellip;]<\/p>\n","protected":false},"author":7,"featured_media":14015,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6049],"tags":[],"class_list":["post-36523","post","type-post","status-publish","format-standard","hentry","category-questions-answers-vi"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v20.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>2026 | 15 c\u00e2u h\u1ecfi v\u00e0 \u0111\u00e1p \u00e1n tr\u1eafc nghi\u1ec7m Excel - OnlineExamMaker Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/onlineexammaker.com\/kb\/vi\/15-excel-quiz-questions-and-answers-12\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"2026 | 15 c\u00e2u h\u1ecfi v\u00e0 \u0111\u00e1p \u00e1n tr\u1eafc nghi\u1ec7m Excel - OnlineExamMaker Blog\" \/>\n<meta property=\"og:description\" content=\"Microsoft Excel l\u00e0 m\u1ed9t \u1ee9ng d\u1ee5ng b\u1ea3ng t\u00ednh ph\u1ed5 bi\u1ebfn \u0111\u01b0\u1ee3c ph\u00e1t tri\u1ec3n b\u1edfi Microsoft. N\u00f3 l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 m\u1ea1nh m\u1ebd cho vi\u1ec7c t\u1ed5 ch\u1ee9c, ph\u00e2n t\u00edch v\u00e0 hi\u1ec3n th\u1ecb d\u1eef li\u1ec7u d\u01b0\u1edbi d\u1ea1ng b\u1ea3ng t\u00ednh. D\u01b0\u1edbi \u0111\u00e2y l\u00e0 m\u1ed9t s\u1ed1 \u0111i\u1ec3m quan tr\u1ecdng v\u1ec1 Microsoft Excel: I. C\u00e1c t\u00ednh n\u0103ng ch\u00ednh c\u1ee7a Excel: [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/onlineexammaker.com\/kb\/vi\/15-excel-quiz-questions-and-answers-12\/\" \/>\n<meta property=\"og:site_name\" content=\"OnlineExamMaker Blog\" \/>\n<meta property=\"article:published_time\" content=\"2025-11-29T00:56:11+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-12-09T18:38:13+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/onlineexammaker.com\/kb\/wp-content\/uploads\/2023\/08\/excel-quiz.webp\" \/>\n\t<meta property=\"og:image:width\" content=\"850\" \/>\n\t<meta property=\"og:image:height\" content=\"541\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/webp\" \/>\n<meta name=\"author\" content=\"Willson Black\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Willson Black\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/onlineexammaker.com\/kb\/vi\/15-excel-quiz-questions-and-answers-12\/\",\"url\":\"https:\/\/onlineexammaker.com\/kb\/vi\/15-excel-quiz-questions-and-answers-12\/\",\"name\":\"2026 | 15 c\u00e2u h\u1ecfi v\u00e0 \u0111\u00e1p \u00e1n tr\u1eafc nghi\u1ec7m Excel - OnlineExamMaker Blog\",\"isPartOf\":{\"@id\":\"https:\/\/onlineexammaker.com\/kb\/#website\"},\"datePublished\":\"2025-11-29T00:56:11+00:00\",\"dateModified\":\"2025-12-09T18:38:13+00:00\",\"author\":{\"@id\":\"https:\/\/onlineexammaker.com\/kb\/#\/schema\/person\/395b2b5bfc990b8d494fc7b498db795b\"},\"breadcrumb\":{\"@id\":\"https:\/\/onlineexammaker.com\/kb\/vi\/15-excel-quiz-questions-and-answers-12\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/onlineexammaker.com\/kb\/vi\/15-excel-quiz-questions-and-answers-12\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/onlineexammaker.com\/kb\/vi\/15-excel-quiz-questions-and-answers-12\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/onlineexammaker.com\/kb\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"2026 | 15 c\u00e2u h\u1ecfi v\u00e0 \u0111\u00e1p \u00e1n tr\u1eafc nghi\u1ec7m Excel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/onlineexammaker.com\/kb\/#website\",\"url\":\"https:\/\/onlineexammaker.com\/kb\/\",\"name\":\"OnlineExamMaker Blog\",\"description\":\"OnlineExamMaker\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/onlineexammaker.com\/kb\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/onlineexammaker.com\/kb\/#\/schema\/person\/395b2b5bfc990b8d494fc7b498db795b\",\"name\":\"Willson Black\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/onlineexammaker.com\/kb\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/cdcb7df856a2cdfc9affd6f71823f077?s=96&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/cdcb7df856a2cdfc9affd6f71823f077?s=96&r=g\",\"caption\":\"Willson Black\"},\"url\":\"https:\/\/onlineexammaker.com\/kb\/author\/willblog\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"2026 | 15 c\u00e2u h\u1ecfi v\u00e0 \u0111\u00e1p \u00e1n tr\u1eafc nghi\u1ec7m Excel - OnlineExamMaker Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/onlineexammaker.com\/kb\/vi\/15-excel-quiz-questions-and-answers-12\/","og_locale":"en_US","og_type":"article","og_title":"2026 | 15 c\u00e2u h\u1ecfi v\u00e0 \u0111\u00e1p \u00e1n tr\u1eafc nghi\u1ec7m Excel - OnlineExamMaker Blog","og_description":"Microsoft Excel l\u00e0 m\u1ed9t \u1ee9ng d\u1ee5ng b\u1ea3ng t\u00ednh ph\u1ed5 bi\u1ebfn \u0111\u01b0\u1ee3c ph\u00e1t tri\u1ec3n b\u1edfi Microsoft. N\u00f3 l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 m\u1ea1nh m\u1ebd cho vi\u1ec7c t\u1ed5 ch\u1ee9c, ph\u00e2n t\u00edch v\u00e0 hi\u1ec3n th\u1ecb d\u1eef li\u1ec7u d\u01b0\u1edbi d\u1ea1ng b\u1ea3ng t\u00ednh. D\u01b0\u1edbi \u0111\u00e2y l\u00e0 m\u1ed9t s\u1ed1 \u0111i\u1ec3m quan tr\u1ecdng v\u1ec1 Microsoft Excel: I. C\u00e1c t\u00ednh n\u0103ng ch\u00ednh c\u1ee7a Excel: [&hellip;]","og_url":"https:\/\/onlineexammaker.com\/kb\/vi\/15-excel-quiz-questions-and-answers-12\/","og_site_name":"OnlineExamMaker Blog","article_published_time":"2025-11-29T00:56:11+00:00","article_modified_time":"2025-12-09T18:38:13+00:00","og_image":[{"width":850,"height":541,"url":"https:\/\/onlineexammaker.com\/kb\/wp-content\/uploads\/2023\/08\/excel-quiz.webp","type":"image\/webp"}],"author":"Willson Black","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Willson Black","Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/onlineexammaker.com\/kb\/vi\/15-excel-quiz-questions-and-answers-12\/","url":"https:\/\/onlineexammaker.com\/kb\/vi\/15-excel-quiz-questions-and-answers-12\/","name":"2026 | 15 c\u00e2u h\u1ecfi v\u00e0 \u0111\u00e1p \u00e1n tr\u1eafc nghi\u1ec7m Excel - OnlineExamMaker Blog","isPartOf":{"@id":"https:\/\/onlineexammaker.com\/kb\/#website"},"datePublished":"2025-11-29T00:56:11+00:00","dateModified":"2025-12-09T18:38:13+00:00","author":{"@id":"https:\/\/onlineexammaker.com\/kb\/#\/schema\/person\/395b2b5bfc990b8d494fc7b498db795b"},"breadcrumb":{"@id":"https:\/\/onlineexammaker.com\/kb\/vi\/15-excel-quiz-questions-and-answers-12\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/onlineexammaker.com\/kb\/vi\/15-excel-quiz-questions-and-answers-12\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/onlineexammaker.com\/kb\/vi\/15-excel-quiz-questions-and-answers-12\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/onlineexammaker.com\/kb\/"},{"@type":"ListItem","position":2,"name":"2026 | 15 c\u00e2u h\u1ecfi v\u00e0 \u0111\u00e1p \u00e1n tr\u1eafc nghi\u1ec7m Excel"}]},{"@type":"WebSite","@id":"https:\/\/onlineexammaker.com\/kb\/#website","url":"https:\/\/onlineexammaker.com\/kb\/","name":"OnlineExamMaker Blog","description":"OnlineExamMaker","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/onlineexammaker.com\/kb\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/onlineexammaker.com\/kb\/#\/schema\/person\/395b2b5bfc990b8d494fc7b498db795b","name":"Willson Black","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/onlineexammaker.com\/kb\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/cdcb7df856a2cdfc9affd6f71823f077?s=96&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/cdcb7df856a2cdfc9affd6f71823f077?s=96&r=g","caption":"Willson Black"},"url":"https:\/\/onlineexammaker.com\/kb\/author\/willblog\/"}]}},"_links":{"self":[{"href":"https:\/\/onlineexammaker.com\/kb\/wp-json\/wp\/v2\/posts\/36523"}],"collection":[{"href":"https:\/\/onlineexammaker.com\/kb\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/onlineexammaker.com\/kb\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/onlineexammaker.com\/kb\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/onlineexammaker.com\/kb\/wp-json\/wp\/v2\/comments?post=36523"}],"version-history":[{"count":4,"href":"https:\/\/onlineexammaker.com\/kb\/wp-json\/wp\/v2\/posts\/36523\/revisions"}],"predecessor-version":[{"id":77407,"href":"https:\/\/onlineexammaker.com\/kb\/wp-json\/wp\/v2\/posts\/36523\/revisions\/77407"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/onlineexammaker.com\/kb\/wp-json\/wp\/v2\/media\/14015"}],"wp:attachment":[{"href":"https:\/\/onlineexammaker.com\/kb\/wp-json\/wp\/v2\/media?parent=36523"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/onlineexammaker.com\/kb\/wp-json\/wp\/v2\/categories?post=36523"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/onlineexammaker.com\/kb\/wp-json\/wp\/v2\/tags?post=36523"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}