{"id":1677,"date":"2026-04-14T07:46:03","date_gmt":"2026-04-14T07:46:03","guid":{"rendered":"https:\/\/yuanstore.tw\/e-learning\/?p=1677"},"modified":"2026-06-29T22:52:35","modified_gmt":"2026-06-29T22:52:35","slug":"excel023-%e6%a2%9d%e4%bb%b6%e6%a0%bc%e5%bc%8f","status":"publish","type":"post","link":"https:\/\/yuanstore.tw\/e-learning\/excel023-%e6%a2%9d%e4%bb%b6%e6%a0%bc%e5%bc%8f\/","title":{"rendered":"Excel023 &#8211; \u689d\u4ef6\u683c\u5f0f"},"content":{"rendered":"\n<div class=\"wp-block-uagb-container uagb-block-1e7243d1 alignfull uagb-is-root-container\"><div class=\"uagb-container-inner-blocks-wrap\">\n<div class=\"wp-block-uagb-advanced-heading uagb-block-281a650b\"><div id=\"ez-toc-container\" class=\"ez-toc-v2_0_87_1 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">\u5167\u5bb9\u76ee\u9304<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"\u986f\u793a\/\u96b1\u85cf\u5167\u5bb9\u76ee\u9304\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/yuanstore.tw\/e-learning\/excel023-%e6%a2%9d%e4%bb%b6%e6%a0%bc%e5%bc%8f\/#%F0%9F%8E%AF_%E5%AD%B8%E7%A8%8B%E7%9B%AE%E6%A8%99\" >\ud83c\udfaf \u5b78\u7a0b\u76ee\u6a19<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/yuanstore.tw\/e-learning\/excel023-%e6%a2%9d%e4%bb%b6%e6%a0%bc%e5%bc%8f\/#%E6%A2%9D%E4%BB%B6%E6%A0%BC%E5%BC%8F\" >\u689d\u4ef6\u683c\u5f0f<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/yuanstore.tw\/e-learning\/excel023-%e6%a2%9d%e4%bb%b6%e6%a0%bc%e5%bc%8f\/#%E6%A2%9D%E4%BB%B6%E6%A0%BC%E5%BC%8F%E6%84%8F%E7%BE%A9\" >\u689d\u4ef6\u683c\u5f0f\u610f\u7fa9<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/yuanstore.tw\/e-learning\/excel023-%e6%a2%9d%e4%bb%b6%e6%a0%bc%e5%bc%8f\/#%E6%94%B9%E8%AE%8A%E5%84%B2%E5%AD%98%E5%A4%96%E8%A7%80%E6%A0%BC%E5%BC%8F\" >\u6539\u8b8a\u5132\u5b58\u5916\u89c0\u683c\u5f0f<\/a><ul class='ez-toc-list-level-4' ><li class='ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/yuanstore.tw\/e-learning\/excel023-%e6%a2%9d%e4%bb%b6%e6%a0%bc%e5%bc%8f\/#%E5%9C%96%E7%A4%BA%E9%9B%86\" >\u5716\u793a\u96c6<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/yuanstore.tw\/e-learning\/excel023-%e6%a2%9d%e4%bb%b6%e6%a0%bc%e5%bc%8f\/#%E5%85%AC%E5%BC%8F%E9%82%8F%E8%BC%AF\" >\u516c\u5f0f\u908f\u8f2f<\/a><\/li><\/ul><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h2 class=\"uagb-heading-text\"><span class=\"ez-toc-section\" id=\"%F0%9F%8E%AF_%E5%AD%B8%E7%A8%8B%E7%9B%AE%E6%A8%99\"><\/span>\ud83c\udfaf \u5b78\u7a0b\u76ee\u6a19<span class=\"ez-toc-section-end\"><\/span><\/h2><\/div>\n\n\n\n<ol class=\"wp-block-list has-medium-font-size\">\n<li>\u5716\u793a\u5316\u986f\u793a<\/li>\n\n\n\n<li>\u516c\u5f0f\u8a2d\u5b9a\u7279\u6b8a\u8cc7\u6599\u683c\u5f0f<\/li>\n<\/ol>\n<\/div><\/div>\n\n\n\n<div class=\"wp-block-uagb-container uagb-block-2532d548 alignfull uagb-is-root-container\"><div class=\"uagb-container-inner-blocks-wrap\">\n<div class=\"wp-block-uagb-container uagb-block-238cffc8\">\n<div class=\"wp-block-uagb-container uagb-block-ebdbc3ee\">\n<div class=\"wp-block-uagb-advanced-heading uagb-block-da4efeb2\"><h2 class=\"uagb-heading-text\"><span class=\"ez-toc-section\" id=\"%E6%A2%9D%E4%BB%B6%E6%A0%BC%E5%BC%8F\"><\/span>\u689d\u4ef6\u683c\u5f0f<span class=\"ez-toc-section-end\"><\/span><\/h2><\/div>\n\n\n\n<ul class=\"wp-block-list has-medium-font-size\">\n<li class=\"has-medium-font-size\">\u6839\u64da\u689d\u4ef6\u81ea\u52d5\u6539\u8b8a<strong>\u5132\u5b58\u683c<\/strong>\u5916\u89c0<\/li>\n\n\n\n<li>\u689d\u4ef6\u5f0f\u683c\u5f0f  =  IF \u5224\u65b7 + \u8996\u89ba\u5316  =\u300c\u689d\u4ef6\uff08\u516c\u5f0f\uff09\u300d\uff0b\u300c\u683c\u5f0f\uff08\u984f\u8272\/\u5716\u793a\uff09\u300d<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">\u53c3\u8003\u8b1b\u7fa9\uff1a<a href=\"https:\/\/yuanstore.tw\/e-learning\/wp-content\/uploads\/2026\/04\/\u689d\u4ef6\u5f0f\u683c\u5f0f\u8a2d\u5b9a.pdf\" data-type=\"attachment\" data-id=\"1728\">\u689d\u4ef6\u683c\u5f0f\u8a2d\u5b9a<\/a><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u7bc4\u4f8b\uff1a<a href=\"https:\/\/yuanstore.tw\/e-learning\/wp-content\/uploads\/2026\/04\/\u73ed\u7d1a\u5b78\u751f\u6210\u7e3e\u8868.xlsx\" data-type=\"attachment\" data-id=\"1719\">\u4e0b\u8f09<\/a><\/p>\n<\/div>\n\n\n\n<div class=\"wp-block-uagb-container uagb-block-f18107e3\">\n<div class=\"wp-block-uagb-advanced-heading uagb-block-272a29a2\"><h3 class=\"uagb-heading-text\"><span class=\"ez-toc-section\" id=\"%E6%A2%9D%E4%BB%B6%E6%A0%BC%E5%BC%8F%E6%84%8F%E7%BE%A9\"><\/span>\u689d\u4ef6\u683c\u5f0f\u610f\u7fa9<span class=\"ez-toc-section-end\"><\/span><\/h3><\/div>\n\n\n\n<div class=\"wp-block-uagb-image alignwide uagb-block-74ca1b59 wp-block-uagb-image--layout-default wp-block-uagb-image--effect-static wp-block-uagb-image--align-wide\"><figure class=\"wp-block-uagb-image__figure\"><img decoding=\"async\" src=\"https:\/\/yuanstore.tw\/e-learning\/wp-content\/uploads\/2026\/04\/\u689d\u4ef6\u683c\u5f0f\u8a2d\u5b9a.png\" alt=\"\u689d\u4ef6\u683c\u5f0f\u8a2d\u5b9a\" class=\"uag-image-1729\" width=\"1408\" height=\"768\" title=\"\u689d\u4ef6\u683c\u5f0f\u8a2d\u5b9a\" loading=\"lazy\" role=\"img\" \/><\/figure><\/div>\n<\/div>\n\n\n\n<div class=\"wp-block-uagb-container uagb-block-dfe236a0\">\n<div class=\"wp-block-uagb-advanced-heading uagb-block-313986de\"><h3 class=\"uagb-heading-text\"><span class=\"ez-toc-section\" id=\"%E6%94%B9%E8%AE%8A%E5%84%B2%E5%AD%98%E5%A4%96%E8%A7%80%E6%A0%BC%E5%BC%8F\"><\/span>\u6539\u8b8a\u5132\u5b58\u5916\u89c0\u683c\u5f0f<span class=\"ez-toc-section-end\"><\/span><\/h3><\/div>\n\n\n\n<div class=\"wp-block-uagb-container uagb-block-580ed469\">\n<div class=\"wp-block-uagb-advanced-heading uagb-block-5afdf247\"><h4 class=\"uagb-heading-text\"><span class=\"ez-toc-section\" id=\"%E5%9C%96%E7%A4%BA%E9%9B%86\"><\/span>\u5716\u793a\u96c6<span class=\"ez-toc-section-end\"><\/span><\/h4><\/div>\n\n\n\n<ul class=\"wp-block-list has-medium-font-size\">\n<li>\u5206\u6578 &lt; 60 \u2192 \ud83d\udd34 \u7d05\u8272<\/li>\n\n\n\n<li>\u7bc4\u570d\u5340\u9593\n<ul class=\"wp-block-list\">\n<li><code>&gt;=80<\/code> \u2192 \u7da0\u8272 <\/li>\n\n\n\n<li><code>60~79<\/code> \u2192 \u9ec3\u8272 <\/li>\n\n\n\n<li><code>&lt;60<\/code> \u2192 \u7d05\u8272<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<div class=\"wp-block-uagb-image alignleft uagb-block-b300bb51 wp-block-uagb-image--layout-default wp-block-uagb-image--effect-static wp-block-uagb-image--align-left\"><figure class=\"wp-block-uagb-image__figure\"><img decoding=\"async\" src=\"https:\/\/yuanstore.tw\/e-learning\/wp-content\/uploads\/2026\/04\/\u689d\u4ef6\u683c\u5f0f\u8a2d\u5b9a-\u5716\u793a\u96c6.png\" alt=\"\" width=\"529\" height=\"222\" title=\"\" loading=\"lazy\" role=\"img\" \/><\/figure><\/div>\n<\/div>\n\n\n\n<div class=\"wp-block-uagb-container uagb-block-c72e699e\">\n<div class=\"wp-block-uagb-advanced-heading uagb-block-9ecfb10b\"><h4 class=\"uagb-heading-text\"><span class=\"ez-toc-section\" id=\"%E5%85%AC%E5%BC%8F%E9%82%8F%E8%BC%AF\"><\/span>\u516c\u5f0f\u908f\u8f2f<span class=\"ez-toc-section-end\"><\/span><\/h4><\/div>\n\n\n\n<ul class=\"wp-block-list has-medium-font-size\">\n<li>\u524d3\u540d\u586b\u6eff\u5e95\u8272<\/li>\n<\/ul>\n\n\n\n<div class=\"wp-block-uagb-image alignwide uagb-block-6035d029 wp-block-uagb-image--layout-default wp-block-uagb-image--effect-static wp-block-uagb-image--align-wide\"><figure class=\"wp-block-uagb-image__figure\"><img decoding=\"async\" src=\"https:\/\/yuanstore.tw\/e-learning\/wp-content\/uploads\/2026\/04\/\u4f7f\u7528\u516c\u5f0f\u683c\u5f0f.png\" alt=\"\u4f7f\u7528\u516c\u5f0f\u683c\u5f0f\" class=\"uag-image-1754\" width=\"498\" height=\"213\" title=\"\u4f7f\u7528\u516c\u5f0f\u683c\u5f0f\" loading=\"lazy\" role=\"img\" \/><\/figure><\/div>\n<\/div>\n<\/div>\n<\/div>\n\n\n\n<div class=\"uagb-position__sticky wp-block-uagb-container uagb-block-3c64f7ed\">\n<\/div>\n<\/div><\/div>\n","protected":false},"excerpt":{"rendered":"<p>\u5716\u793a\u5316\u986f\u793a\u3001\u516c\u5f0f\u8a2d\u5b9a\u7279\u6b8a\u8cc7\u6599\u683c\u5f0f<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_uag_custom_page_level_css":"","site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[7],"tags":[],"class_list":["post-1677","post","type-post","status-publish","format-standard","hentry","category-excel"],"uagb_featured_image_src":{"full":false,"thumbnail":false,"medium":false,"medium_large":false,"large":false,"1536x1536":false,"2048x2048":false},"uagb_author_info":{"display_name":"kungba","author_link":"https:\/\/yuanstore.tw\/e-learning\/author\/kungba\/"},"uagb_comment_info":0,"uagb_excerpt":"\u5716\u793a\u5316\u986f\u793a\u3001\u516c\u5f0f\u8a2d\u5b9a\u7279\u6b8a\u8cc7\u6599\u683c\u5f0f","_links":{"self":[{"href":"https:\/\/yuanstore.tw\/e-learning\/wp-json\/wp\/v2\/posts\/1677","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/yuanstore.tw\/e-learning\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/yuanstore.tw\/e-learning\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/yuanstore.tw\/e-learning\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/yuanstore.tw\/e-learning\/wp-json\/wp\/v2\/comments?post=1677"}],"version-history":[{"count":20,"href":"https:\/\/yuanstore.tw\/e-learning\/wp-json\/wp\/v2\/posts\/1677\/revisions"}],"predecessor-version":[{"id":2726,"href":"https:\/\/yuanstore.tw\/e-learning\/wp-json\/wp\/v2\/posts\/1677\/revisions\/2726"}],"wp:attachment":[{"href":"https:\/\/yuanstore.tw\/e-learning\/wp-json\/wp\/v2\/media?parent=1677"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/yuanstore.tw\/e-learning\/wp-json\/wp\/v2\/categories?post=1677"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/yuanstore.tw\/e-learning\/wp-json\/wp\/v2\/tags?post=1677"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}