{"id":4403,"date":"2023-09-04T21:45:15","date_gmt":"2023-09-04T13:45:15","guid":{"rendered":"https:\/\/tinapoint.com\/?p=4403"},"modified":"2023-09-05T15:21:01","modified_gmt":"2023-09-05T07:21:01","slug":"excel","status":"publish","type":"post","link":"https:\/\/tinapoint.com\/excel\/","title":{"rendered":"\u3010\u5de5\u5177\u3011Excel\u597d\u7528\u529f\u80fd\u6574\u7406\uff1a\u9019\u4e9b\u8a9e\u6cd5\u4f60\u90fd\u77e5\u9053\u55ce\uff1f\u5916\u52a06\u7a2e\u5716\u8868\u89e3\u6790"},"content":{"rendered":"\n<p>\u5728\u91ab\u9662\u5de5\u4f5c\uff0c\u8d85\u7d1a\u591a\u6587\u66f8\u8655\u7406\u5de5\u4f5c\uff0cexcel \u662f\u6bcf\u5929\u90fd\u8981\u7528\u7684\u5de5\u5177\uff0c\u6240\u4ee5\u6700\u8fd1\u4e0a\u4e86 excel \u5165\u9580\u8207\u5716\u8868\u7e6a\u88fd\u8ab2\uff0c\u89ba\u5f97\u771f\u7684\u592a\u5be6\u7528\u4e86\uff01\u60f3\u628a\u5e38\u7528\u7684\u8a9e\u6cd5\u529f\u80fd\u597d\u597d\u6574\u7406\uff0c\u4ee5\u5f8c\u5c31\u4e0d\u7528 google\uff0c\u4f86\u9019\u7bc7\u6587\u7ae0\u627e\u5c31\u597d\u5566\uff01<\/p>\n\n\n\n<!--more-->\n\n\n\n<div style=\"height:100px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<style type=\"text\/css\">@import url(\"https:\/\/assets.mlcdn.com\/fonts.css?version=1684996\");<\/style>\n    <style type=\"text\/css\">\n    \/* LOADER *\/\n    .ml-form-embedSubmitLoad {\n      display: inline-block;\n      width: 20px;\n      height: 20px;\n    }\n\n    .g-recaptcha {\n    transform: scale(1);\n    -webkit-transform: scale(1);\n    transform-origin: 0 0;\n    -webkit-transform-origin: 0 0;\n    height: ;\n    }\n\n    .sr-only {\n      position: absolute;\n      width: 1px;\n      height: 1px;\n      padding: 0;\n      margin: -1px;\n      overflow: hidden;\n      clip: rect(0,0,0,0);\n      border: 0;\n    }\n\n    .ml-form-embedSubmitLoad:after {\n      content: \" \";\n      display: block;\n      width: 11px;\n      height: 11px;\n      margin: 1px;\n      border-radius: 50%;\n      border: 4px solid #fff;\n    border-color: #ffffff #ffffff #ffffff transparent;\n    animation: ml-form-embedSubmitLoad 1.2s linear infinite;\n    }\n    @keyframes ml-form-embedSubmitLoad {\n      0% {\n      transform: rotate(0deg);\n      }\n      100% {\n      transform: rotate(360deg);\n      }\n    }\n      #mlb2-5354301.ml-form-embedContainer {\n        box-sizing: border-box;\n        display: table;\n        margin: 0 auto;\n        position: static;\n        width: 100% !important;\n      }\n      #mlb2-5354301.ml-form-embedContainer h4,\n      #mlb2-5354301.ml-form-embedContainer p,\n      #mlb2-5354301.ml-form-embedContainer span,\n      #mlb2-5354301.ml-form-embedContainer button {\n        text-transform: none !important;\n        letter-spacing: normal !important;\n      }\n      #mlb2-5354301.ml-form-embedContainer .ml-form-embedWrapper {\n        background-color: #fff6de;\n        \n        border-width: 0px;\n        border-color: transparent;\n        border-radius: 4px;\n        border-style: solid;\n        box-sizing: border-box;\n        display: inline-block !important;\n        margin: 0;\n        padding: 0;\n        position: relative;\n              }\n      #mlb2-5354301.ml-form-embedContainer .ml-form-embedWrapper.embedPopup,\n      #mlb2-5354301.ml-form-embedContainer .ml-form-embedWrapper.embedDefault { width: 700px; }\n      #mlb2-5354301.ml-form-embedContainer .ml-form-embedWrapper.embedForm { max-width: 700px; width: 100%; }\n      #mlb2-5354301.ml-form-embedContainer .ml-form-align-left { text-align: left; }\n      #mlb2-5354301.ml-form-embedContainer .ml-form-align-center { text-align: center; }\n      #mlb2-5354301.ml-form-embedContainer .ml-form-align-default { display: table-cell !important; vertical-align: middle !important; text-align: center !important; }\n      #mlb2-5354301.ml-form-embedContainer .ml-form-align-right { text-align: right; }\n      #mlb2-5354301.ml-form-embedContainer .ml-form-embedWrapper .ml-form-embedHeader img {\n        border-top-left-radius: 4px;\n        border-top-right-radius: 4px;\n        height: auto;\n        margin: 0 auto !important;\n        max-width: 100%;\n        width: undefinedpx;\n      }\n      #mlb2-5354301.ml-form-embedContainer .ml-form-embedWrapper .ml-form-embedBody,\n      #mlb2-5354301.ml-form-embedContainer .ml-form-embedWrapper .ml-form-successBody {\n        padding: 20px 20px 0 20px;\n      }\n      #mlb2-5354301.ml-form-embedContainer .ml-form-embedWrapper .ml-form-embedBody.ml-form-embedBodyHorizontal {\n        padding-bottom: 0;\n      }\n      #mlb2-5354301.ml-form-embedContainer .ml-form-embedWrapper .ml-form-embedBody .ml-form-embedContent,\n      #mlb2-5354301.ml-form-embedContainer .ml-form-embedWrapper .ml-form-successBody .ml-form-successContent {\n        text-align: left;\n        margin: 0 0 20px 0;\n      }\n      #mlb2-5354301.ml-form-embedContainer .ml-form-embedWrapper .ml-form-embedBody .ml-form-embedContent h4,\n      #mlb2-5354301.ml-form-embedContainer .ml-form-embedWrapper .ml-form-successBody .ml-form-successContent h4 {\n        color: #171717;\n        font-family: 'Open Sans', Arial, Helvetica, sans-serif;\n        font-size: 28px;\n        font-weight: 700;\n        margin: 0 0 10px 0;\n        text-align: center;\n        word-break: break-word;\n      }\n      #mlb2-5354301.ml-form-embedContainer .ml-form-embedWrapper .ml-form-embedBody .ml-form-embedContent p,\n      #mlb2-5354301.ml-form-embedContainer .ml-form-embedWrapper .ml-form-successBody .ml-form-successContent p {\n        color: #b0a4a4;\n        font-family: 'Open Sans', Arial, Helvetica, sans-serif;\n        font-size: 14px;\n        font-weight: 400;\n        line-height: 20px;\n        margin: 0 0 10px 0;\n        text-align: center;\n      }\n      #mlb2-5354301.ml-form-embedContainer .ml-form-embedWrapper .ml-form-embedBody .ml-form-embedContent ul,\n      #mlb2-5354301.ml-form-embedContainer .ml-form-embedWrapper .ml-form-embedBody .ml-form-embedContent ol,\n      #mlb2-5354301.ml-form-embedContainer .ml-form-embedWrapper .ml-form-successBody .ml-form-successContent ul,\n      #mlb2-5354301.ml-form-embedContainer .ml-form-embedWrapper .ml-form-successBody .ml-form-successContent ol {\n        color: #b0a4a4;\n        font-family: 'Open Sans', Arial, Helvetica, sans-serif;\n        font-size: 14px;\n      }\n      #mlb2-5354301.ml-form-embedContainer .ml-form-embedWrapper .ml-form-embedBody .ml-form-embedContent ol ol,\n      #mlb2-5354301.ml-form-embedContainer .ml-form-embedWrapper .ml-form-successBody .ml-form-successContent ol ol {\n        list-style-type: lower-alpha;\n      }\n      #mlb2-5354301.ml-form-embedContainer .ml-form-embedWrapper .ml-form-embedBody .ml-form-embedContent ol ol ol,\n      #mlb2-5354301.ml-form-embedContainer .ml-form-embedWrapper .ml-form-successBody .ml-form-successContent ol ol ol {\n        list-style-type: lower-roman;\n      }\n      #mlb2-5354301.ml-form-embedContainer .ml-form-embedWrapper .ml-form-embedBody .ml-form-embedContent p a,\n      #mlb2-5354301.ml-form-embedContainer .ml-form-embedWrapper .ml-form-successBody .ml-form-successContent p a {\n        color: #000000;\n        text-decoration: underline;\n      }\n\n      #mlb2-5354301.ml-form-embedContainer .ml-form-embedWrapper .ml-block-form .ml-field-group {\n        text-align: left!important;\n      }\n\n      #mlb2-5354301.ml-form-embedContainer .ml-form-embedWrapper .ml-block-form .ml-field-group label {\n        margin-bottom: 5px;\n        color: #333333;\n        font-size: 14px;\n        font-family: 'Open Sans', Arial, Helvetica, sans-serif;\n        font-weight: bold; font-style: normal; text-decoration: none;;\n        display: inline-block;\n        line-height: 20px;\n      }\n      #mlb2-5354301.ml-form-embedContainer .ml-form-embedWrapper .ml-form-embedBody .ml-form-embedContent p:last-child,\n      #mlb2-5354301.ml-form-embedContainer .ml-form-embedWrapper .ml-form-successBody .ml-form-successContent p:last-child {\n        margin: 0;\n      }\n      #mlb2-5354301.ml-form-embedContainer .ml-form-embedWrapper .ml-form-embedBody form {\n        margin: 0;\n        width: 100%;\n      }\n      #mlb2-5354301.ml-form-embedContainer .ml-form-embedWrapper .ml-form-embedBody .ml-form-formContent,\n      #mlb2-5354301.ml-form-embedContainer .ml-form-embedWrapper .ml-form-embedBody .ml-form-checkboxRow {\n        margin: 0 0 20px 0;\n        width: 100%;\n      }\n      #mlb2-5354301.ml-form-embedContainer .ml-form-embedWrapper .ml-form-embedBody .ml-form-checkboxRow {\n        float: left;\n      }\n      #mlb2-5354301.ml-form-embedContainer .ml-form-embedWrapper .ml-form-embedBody .ml-form-formContent.horozintalForm {\n        margin: 0;\n        padding: 0 0 20px 0;\n        width: 100%;\n        height: auto;\n        float: left;\n      }\n      #mlb2-5354301.ml-form-embedContainer .ml-form-embedWrapper .ml-form-embedBody .ml-form-fieldRow {\n        margin: 0 0 10px 0;\n        width: 100%;\n      }\n      #mlb2-5354301.ml-form-embedContainer .ml-form-embedWrapper .ml-form-embedBody .ml-form-fieldRow.ml-last-item {\n        margin: 0;\n      }\n      #mlb2-5354301.ml-form-embedContainer .ml-form-embedWrapper .ml-form-embedBody .ml-form-fieldRow.ml-formfieldHorizintal {\n        margin: 0;\n      }\n      #mlb2-5354301.ml-form-embedContainer .ml-form-embedWrapper .ml-form-embedBody .ml-form-fieldRow input {\n        background-color: #ffffff !important;\n        color: #333333 !important;\n        border-color: #cccccc;\n        border-radius: 4px !important;\n        border-style: solid !important;\n        border-width: 1px !important;\n        font-family: 'Open Sans', Arial, Helvetica, sans-serif;\n        font-size: 14px !important;\n        height: auto;\n        line-height: 21px !important;\n        margin-bottom: 0;\n        margin-top: 0;\n        margin-left: 0;\n        margin-right: 0;\n        padding: 10px 10px !important;\n        width: 100% !important;\n        box-sizing: border-box !important;\n        max-width: 100% !important;\n      }\n      #mlb2-5354301.ml-form-embedContainer .ml-form-embedWrapper .ml-form-embedBody .ml-form-fieldRow input::-webkit-input-placeholder,\n      #mlb2-5354301.ml-form-embedContainer .ml-form-embedWrapper .ml-form-embedBody .ml-form-horizontalRow input::-webkit-input-placeholder { color: #333333; }\n\n      #mlb2-5354301.ml-form-embedContainer .ml-form-embedWrapper .ml-form-embedBody .ml-form-fieldRow input::-moz-placeholder,\n      #mlb2-5354301.ml-form-embedContainer .ml-form-embedWrapper .ml-form-embedBody .ml-form-horizontalRow input::-moz-placeholder { color: #333333; }\n\n      #mlb2-5354301.ml-form-embedContainer .ml-form-embedWrapper .ml-form-embedBody .ml-form-fieldRow input:-ms-input-placeholder,\n      #mlb2-5354301.ml-form-embedContainer .ml-form-embedWrapper .ml-form-embedBody .ml-form-horizontalRow input:-ms-input-placeholder { color: #333333; }\n\n      #mlb2-5354301.ml-form-embedContainer .ml-form-embedWrapper .ml-form-embedBody .ml-form-fieldRow input:-moz-placeholder,\n      #mlb2-5354301.ml-form-embedContainer .ml-form-embedWrapper .ml-form-embedBody .ml-form-horizontalRow input:-moz-placeholder { color: #333333; }\n\n      #mlb2-5354301.ml-form-embedContainer .ml-form-embedWrapper .ml-form-embedBody .ml-form-fieldRow textarea, #mlb2-5354301.ml-form-embedContainer .ml-form-embedWrapper .ml-form-embedBody .ml-form-horizontalRow textarea {\n        background-color: #ffffff !important;\n        color: #333333 !important;\n        border-color: #cccccc;\n        border-radius: 4px !important;\n        border-style: solid !important;\n        border-width: 1px !important;\n        font-family: 'Open Sans', Arial, Helvetica, sans-serif;\n        font-size: 14px !important;\n        height: auto;\n        line-height: 21px !important;\n        margin-bottom: 0;\n        margin-top: 0;\n        padding: 10px 10px !important;\n        width: 100% !important;\n        box-sizing: border-box !important;\n        max-width: 100% !important;\n      }\n\n      #mlb2-5354301.ml-form-embedContainer .ml-form-embedWrapper .ml-form-embedBody .ml-form-fieldRow .custom-radio .custom-control-label::before, #mlb2-5354301.ml-form-embedContainer .ml-form-embedWrapper .ml-form-embedBody .ml-form-horizontalRow .custom-radio .custom-control-label::before, #mlb2-5354301.ml-form-embedContainer .ml-form-embedWrapper .ml-form-embedBody .ml-form-fieldRow .custom-checkbox .custom-control-label::before, #mlb2-5354301.ml-form-embedContainer .ml-form-embedWrapper .ml-form-embedBody .ml-form-horizontalRow .custom-checkbox .custom-control-label::before, #mlb2-5354301.ml-form-embedContainer .ml-form-embedWrapper .ml-form-embedBody .ml-form-embedPermissions .ml-form-embedPermissionsOptionsCheckbox .label-description::before, #mlb2-5354301.ml-form-embedContainer .ml-form-embedWrapper .ml-form-embedBody .ml-form-interestGroupsRow .ml-form-interestGroupsRowCheckbox .label-description::before, #mlb2-5354301.ml-form-embedContainer .ml-form-embedWrapper .ml-form-embedBody .ml-form-checkboxRow .label-description::before {\n          border-color: #cccccc!important;\n          background-color: #ffffff!important;\n      }\n\n      #mlb2-5354301.ml-form-embedContainer .ml-form-embedWrapper .ml-form-embedBody .ml-form-fieldRow input.custom-control-input[type=\"checkbox\"]{\n        box-sizing: border-box;\n        padding: 0;\n        position: absolute;\n        z-index: -1;\n        opacity: 0;\n        margin-top: 5px;\n        margin-left: -1.5rem;\n        overflow: visible;\n      }\n\n      #mlb2-5354301.ml-form-embedContainer .ml-form-embedWrapper .ml-form-embedBody .ml-form-fieldRow .custom-checkbox .custom-control-label::before, #mlb2-5354301.ml-form-embedContainer .ml-form-embedWrapper .ml-form-embedBody .ml-form-horizontalRow .custom-checkbox .custom-control-label::before, #mlb2-5354301.ml-form-embedContainer .ml-form-embedWrapper .ml-form-embedBody .ml-form-embedPermissions .ml-form-embedPermissionsOptionsCheckbox .label-description::before, #mlb2-5354301.ml-form-embedContainer .ml-form-embedWrapper .ml-form-embedBody .ml-form-interestGroupsRow .ml-form-interestGroupsRowCheckbox .label-description::before, #mlb2-5354301.ml-form-embedContainer .ml-form-embedWrapper .ml-form-embedBody .ml-form-checkboxRow .label-description::before {\n        border-radius: 4px!important;\n      }\n\n\n      #mlb2-5354301.ml-form-embedContainer .ml-form-embedWrapper .ml-form-embedBody .ml-form-checkboxRow input[type=checkbox]:checked~.label-description::after, #mlb2-5354301.ml-form-embedContainer .ml-form-embedWrapper .ml-form-embedBody .ml-form-embedPermissions .ml-form-embedPermissionsOptionsCheckbox input[type=checkbox]:checked~.label-description::after, #mlb2-5354301.ml-form-embedContainer .ml-form-embedWrapper .ml-form-embedBody .ml-form-fieldRow .custom-checkbox .custom-control-input:checked~.custom-control-label::after, #mlb2-5354301.ml-form-embedContainer .ml-form-embedWrapper .ml-form-embedBody .ml-form-horizontalRow .custom-checkbox .custom-control-input:checked~.custom-control-label::after, #mlb2-5354301.ml-form-embedContainer .ml-form-embedWrapper .ml-form-embedBody .ml-form-interestGroupsRow .ml-form-interestGroupsRowCheckbox input[type=checkbox]:checked~.label-description::after {\n        background-image: url(\"data:image\/svg+xml,%3csvg xmlns='http:\/\/www.w3.org\/2000\/svg' viewBox='0 0 8 8'%3e%3cpath fill='%23fff' d='M6.564.75l-3.59 3.612-1.538-1.55L0 4.26 2.974 7.25 8 2.193z'\/%3e%3c\/svg%3e\");\n      }\n\n      #mlb2-5354301.ml-form-embedContainer .ml-form-embedWrapper .ml-form-embedBody .ml-form-fieldRow .custom-radio .custom-control-input:checked~.custom-control-label::after, #mlb2-5354301.ml-form-embedContainer .ml-form-embedWrapper .ml-form-embedBody .ml-form-fieldRow .custom-radio .custom-control-input:checked~.custom-control-label::after {\n        background-image: url(\"data:image\/svg+xml,%3csvg xmlns='http:\/\/www.w3.org\/2000\/svg' viewBox='-4 -4 8 8'%3e%3ccircle r='3' fill='%23fff'\/%3e%3c\/svg%3e\");\n      }\n\n      #mlb2-5354301.ml-form-embedContainer .ml-form-embedWrapper .ml-form-embedBody .ml-form-fieldRow .custom-radio .custom-control-input:checked~.custom-control-label::before, #mlb2-5354301.ml-form-embedContainer .ml-form-embedWrapper .ml-form-embedBody .ml-form-horizontalRow .custom-radio .custom-control-input:checked~.custom-control-label::before, #mlb2-5354301.ml-form-embedContainer .ml-form-embedWrapper .ml-form-embedBody .ml-form-fieldRow .custom-checkbox .custom-control-input:checked~.custom-control-label::before, #mlb2-5354301.ml-form-embedContainer .ml-form-embedWrapper .ml-form-embedBody .ml-form-horizontalRow .custom-checkbox .custom-control-input:checked~.custom-control-label::before, #mlb2-5354301.ml-form-embedContainer .ml-form-embedWrapper .ml-form-embedBody .ml-form-embedPermissions .ml-form-embedPermissionsOptionsCheckbox input[type=checkbox]:checked~.label-description::before, #mlb2-5354301.ml-form-embedContainer .ml-form-embedWrapper .ml-form-embedBody .ml-form-interestGroupsRow .ml-form-interestGroupsRowCheckbox input[type=checkbox]:checked~.label-description::before, #mlb2-5354301.ml-form-embedContainer .ml-form-embedWrapper .ml-form-embedBody .ml-form-checkboxRow input[type=checkbox]:checked~.label-description::before  {\n          border-color: #552222!important;\n          background-color: #552222!important;\n          color: #ffffff!important;\n      }\n\n      #mlb2-5354301.ml-form-embedContainer .ml-form-embedWrapper .ml-form-embedBody .ml-form-fieldRow .custom-radio .custom-control-label::before, #mlb2-5354301.ml-form-embedContainer .ml-form-embedWrapper .ml-form-embedBody .ml-form-horizontalRow .custom-radio .custom-control-label::before, #mlb2-5354301.ml-form-embedContainer .ml-form-embedWrapper .ml-form-embedBody .ml-form-fieldRow .custom-radio .custom-control-label::after, #mlb2-5354301.ml-form-embedContainer .ml-form-embedWrapper .ml-form-embedBody .ml-form-horizontalRow .custom-radio .custom-control-label::after, #mlb2-5354301.ml-form-embedContainer .ml-form-embedWrapper .ml-form-embedBody .ml-form-fieldRow .custom-checkbox .custom-control-label::before, #mlb2-5354301.ml-form-embedContainer .ml-form-embedWrapper .ml-form-embedBody .ml-form-fieldRow .custom-checkbox .custom-control-label::after, #mlb2-5354301.ml-form-embedContainer .ml-form-embedWrapper .ml-form-embedBody .ml-form-horizontalRow .custom-checkbox .custom-control-label::before, #mlb2-5354301.ml-form-embedContainer .ml-form-embedWrapper .ml-form-embedBody .ml-form-horizontalRow .custom-checkbox .custom-control-label::after {\n           top: 2px;\n           box-sizing: border-box;\n      }\n\n      #mlb2-5354301.ml-form-embedContainer .ml-form-embedWrapper .ml-form-embedBody .ml-form-embedPermissions .ml-form-embedPermissionsOptionsCheckbox .label-description::before, #mlb2-5354301.ml-form-embedContainer .ml-form-embedWrapper .ml-form-embedBody .ml-form-embedPermissions .ml-form-embedPermissionsOptionsCheckbox .label-description::after, #mlb2-5354301.ml-form-embedContainer .ml-form-embedWrapper .ml-form-embedBody .ml-form-checkboxRow .label-description::before, #mlb2-5354301.ml-form-embedContainer .ml-form-embedWrapper .ml-form-embedBody .ml-form-checkboxRow .label-description::after {\n           top: 0px!important;\n           box-sizing: border-box!important;\n      }\n\n      #mlb2-5354301.ml-form-embedContainer .ml-form-embedWrapper .ml-form-embedBody .ml-form-checkboxRow .label-description::before, #mlb2-5354301.ml-form-embedContainer .ml-form-embedWrapper .ml-form-embedBody .ml-form-checkboxRow .label-description::after {\n        top: 0px!important;\n           box-sizing: border-box!important;\n      }\n\n       #mlb2-5354301.ml-form-embedContainer .ml-form-embedWrapper .ml-form-embedBody .ml-form-interestGroupsRow .ml-form-interestGroupsRowCheckbox .label-description::after {\n            top: 0px!important;\n            box-sizing: border-box!important;\n            position: absolute;\n            left: -1.5rem;\n            display: block;\n            width: 1rem;\n            height: 1rem;\n            content: \"\";\n       }\n\n      #mlb2-5354301.ml-form-embedContainer .ml-form-embedWrapper .ml-form-embedBody .ml-form-interestGroupsRow .ml-form-interestGroupsRowCheckbox .label-description::before {\n        top: 0px!important;\n        box-sizing: border-box!important;\n      }\n\n      #mlb2-5354301.ml-form-embedContainer .ml-form-embedWrapper .ml-form-embedBody .custom-control-label::before {\n          position: absolute;\n          top: 4px;\n          left: -1.5rem;\n          display: block;\n          width: 16px;\n          height: 16px;\n          pointer-events: none;\n          content: \"\";\n          background-color: #ffffff;\n          border: #adb5bd solid 1px;\n          border-radius: 50%;\n      }\n\n      #mlb2-5354301.ml-form-embedContainer .ml-form-embedWrapper .ml-form-embedBody .custom-control-label::after {\n          position: absolute;\n          top: 2px!important;\n          left: -1.5rem;\n          display: block;\n          width: 1rem;\n          height: 1rem;\n          content: \"\";\n      }\n\n      #mlb2-5354301.ml-form-embedContainer .ml-form-embedWrapper .ml-form-embedBody .ml-form-embedPermissions .ml-form-embedPermissionsOptionsCheckbox .label-description::before, #mlb2-5354301.ml-form-embedContainer .ml-form-embedWrapper .ml-form-embedBody .ml-form-interestGroupsRow .ml-form-interestGroupsRowCheckbox .label-description::before, #mlb2-5354301.ml-form-embedContainer .ml-form-embedWrapper .ml-form-embedBody .ml-form-checkboxRow .label-description::before {\n          position: absolute;\n          top: 4px;\n          left: -1.5rem;\n          display: block;\n          width: 16px;\n          height: 16px;\n          pointer-events: none;\n          content: \"\";\n          background-color: #ffffff;\n          border: #adb5bd solid 1px;\n          border-radius: 50%;\n      }\n\n      #mlb2-5354301.ml-form-embedContainer .ml-form-embedWrapper .ml-form-embedBody .ml-form-embedPermissions .ml-form-embedPermissionsOptionsCheckbox .label-description::after {\n          position: absolute;\n          top: 0px!important;\n          left: -1.5rem;\n          display: block;\n          width: 1rem;\n          height: 1rem;\n          content: \"\";\n      }\n\n      #mlb2-5354301.ml-form-embedContainer .ml-form-embedWrapper .ml-form-embedBody .ml-form-checkboxRow .label-description::after {\n          position: absolute;\n          top: 0px!important;\n          left: -1.5rem;\n          display: block;\n          width: 1rem;\n          height: 1rem;\n          content: \"\";\n      }\n\n      #mlb2-5354301.ml-form-embedContainer .ml-form-embedWrapper .ml-form-embedBody .custom-radio .custom-control-label::after {\n          background: no-repeat 50%\/50% 50%;\n      }\n      #mlb2-5354301.ml-form-embedContainer .ml-form-embedWrapper .ml-form-embedBody .custom-checkbox .custom-control-label::after, #mlb2-5354301.ml-form-embedContainer .ml-form-embedWrapper .ml-form-embedBody .ml-form-embedPermissions .ml-form-embedPermissionsOptionsCheckbox .label-description::after, #mlb2-5354301.ml-form-embedContainer .ml-form-embedWrapper .ml-form-embedBody .ml-form-interestGroupsRow .ml-form-interestGroupsRowCheckbox .label-description::after, #mlb2-5354301.ml-form-embedContainer .ml-form-embedWrapper .ml-form-embedBody .ml-form-checkboxRow .label-description::after {\n          background: no-repeat 50%\/50% 50%;\n      }\n\n      #mlb2-5354301.ml-form-embedContainer .ml-form-embedWrapper .ml-form-embedBody .ml-form-fieldRow .custom-control, #mlb2-5354301.ml-form-embedContainer .ml-form-embedWrapper .ml-form-embedBody .ml-form-horizontalRow .custom-control {\n        position: relative;\n        display: block;\n        min-height: 1.5rem;\n        padding-left: 1.5rem;\n      }\n\n      #mlb2-5354301.ml-form-embedContainer .ml-form-embedWrapper .ml-form-embedBody .ml-form-fieldRow .custom-radio .custom-control-input, #mlb2-5354301.ml-form-embedContainer .ml-form-embedWrapper .ml-form-embedBody .ml-form-horizontalRow .custom-radio .custom-control-input, #mlb2-5354301.ml-form-embedContainer .ml-form-embedWrapper .ml-form-embedBody .ml-form-fieldRow .custom-checkbox .custom-control-input, #mlb2-5354301.ml-form-embedContainer .ml-form-embedWrapper .ml-form-embedBody .ml-form-horizontalRow .custom-checkbox .custom-control-input {\n          position: absolute;\n          z-index: -1;\n          opacity: 0;\n          box-sizing: border-box;\n          padding: 0;\n      }\n\n      #mlb2-5354301.ml-form-embedContainer .ml-form-embedWrapper .ml-form-embedBody .ml-form-fieldRow .custom-radio .custom-control-label, #mlb2-5354301.ml-form-embedContainer .ml-form-embedWrapper .ml-form-embedBody .ml-form-horizontalRow .custom-radio .custom-control-label, #mlb2-5354301.ml-form-embedContainer .ml-form-embedWrapper .ml-form-embedBody .ml-form-fieldRow .custom-checkbox .custom-control-label, #mlb2-5354301.ml-form-embedContainer .ml-form-embedWrapper .ml-form-embedBody .ml-form-horizontalRow .custom-checkbox .custom-control-label {\n          color: #000000;\n          font-size: 12px!important;\n          font-family: 'Open Sans', Arial, Helvetica, sans-serif;\n          line-height: 22px;\n          margin-bottom: 0;\n          position: relative;\n          vertical-align: top;\n          font-style: normal;\n          font-weight: 700;\n      }\n\n      #mlb2-5354301.ml-form-embedContainer .ml-form-embedWrapper .ml-form-embedBody .ml-form-fieldRow .custom-select, #mlb2-5354301.ml-form-embedContainer .ml-form-embedWrapper .ml-form-embedBody .ml-form-horizontalRow .custom-select {\n        background-color: #ffffff !important;\n        color: #333333 !important;\n        border-color: #cccccc;\n        border-radius: 4px !important;\n        border-style: solid !important;\n        border-width: 1px !important;\n        font-family: 'Open Sans', Arial, Helvetica, sans-serif;\n        font-size: 14px !important;\n        line-height: 20px !important;\n        margin-bottom: 0;\n        margin-top: 0;\n        padding: 10px 28px 10px 12px !important;\n        width: 100% !important;\n        box-sizing: border-box !important;\n        max-width: 100% !important;\n        height: auto;\n        display: inline-block;\n        vertical-align: middle;\n        background: url('https:\/\/assets.mlcdn.com\/ml\/images\/default\/dropdown.svg') no-repeat right .75rem center\/8px 10px;\n        -webkit-appearance: none;\n        -moz-appearance: none;\n        appearance: none;\n      }\n\n\n      #mlb2-5354301.ml-form-embedContainer .ml-form-embedWrapper .ml-form-embedBody .ml-form-horizontalRow {\n        height: auto;\n        width: 100%;\n        float: left;\n      }\n      .ml-form-formContent.horozintalForm .ml-form-horizontalRow .ml-input-horizontal { width: 70%; float: left; }\n      .ml-form-formContent.horozintalForm .ml-form-horizontalRow .ml-button-horizontal { width: 30%; float: left; }\n      .ml-form-formContent.horozintalForm .ml-form-horizontalRow .ml-button-horizontal.labelsOn { padding-top: 25px;  }\n      .ml-form-formContent.horozintalForm .ml-form-horizontalRow .horizontal-fields { box-sizing: border-box; float: left; padding-right: 10px;  }\n      #mlb2-5354301.ml-form-embedContainer .ml-form-embedWrapper .ml-form-embedBody .ml-form-horizontalRow input {\n        background-color: #ffffff;\n        color: #333333;\n        border-color: #cccccc;\n        border-radius: 4px;\n        border-style: solid;\n        border-width: 1px;\n        font-family: 'Open Sans', Arial, Helvetica, sans-serif;\n        font-size: 14px;\n        line-height: 20px;\n        margin-bottom: 0;\n        margin-top: 0;\n        padding: 10px 10px;\n        width: 100%;\n        box-sizing: border-box;\n        overflow-y: initial;\n      }\n      #mlb2-5354301.ml-form-embedContainer .ml-form-embedWrapper .ml-form-embedBody .ml-form-horizontalRow button {\n        background-color: #552222 !important;\n        border-color: #552222;\n        border-style: solid;\n        border-width: 1px;\n        border-radius: 4px;\n        box-shadow: none;\n        color: #ffffff !important;\n        cursor: pointer;\n        font-family: 'Open Sans', Arial, Helvetica, sans-serif;\n        font-size: 14px !important;\n        font-weight: 700;\n        line-height: 20px;\n        margin: 0 !important;\n        padding: 10px !important;\n        width: 100%;\n        height: auto;\n      }\n      #mlb2-5354301.ml-form-embedContainer .ml-form-embedWrapper .ml-form-embedBody .ml-form-horizontalRow button:hover {\n        background-color: #333333 !important;\n        border-color: #333333 !important;\n      }\n      #mlb2-5354301.ml-form-embedContainer .ml-form-embedWrapper .ml-form-embedBody .ml-form-checkboxRow input[type=\"checkbox\"] {\n        box-sizing: border-box;\n        padding: 0;\n        position: absolute;\n        z-index: -1;\n        opacity: 0;\n        margin-top: 5px;\n        margin-left: -1.5rem;\n        overflow: visible;\n      }\n      #mlb2-5354301.ml-form-embedContainer .ml-form-embedWrapper .ml-form-embedBody .ml-form-checkboxRow .label-description {\n        color: #000000;\n        display: block;\n        font-family: 'Open Sans', Arial, Helvetica, sans-serif;\n        font-size: 12px;\n        text-align: left;\n        margin-bottom: 0;\n        position: relative;\n        vertical-align: top;\n      }\n      #mlb2-5354301.ml-form-embedContainer .ml-form-embedWrapper .ml-form-embedBody .ml-form-checkboxRow label {\n        font-weight: normal;\n        margin: 0;\n        padding: 0;\n        position: relative;\n        display: block;\n        min-height: 24px;\n        padding-left: 24px;\n\n      }\n      #mlb2-5354301.ml-form-embedContainer .ml-form-embedWrapper .ml-form-embedBody .ml-form-checkboxRow label a {\n        color: #000000;\n        text-decoration: underline;\n      }\n      #mlb2-5354301.ml-form-embedContainer .ml-form-embedWrapper .ml-form-embedBody .ml-form-checkboxRow label p {\n        color: #000000 !important;\n        font-family: 'Open Sans', Arial, Helvetica, sans-serif !important;\n        font-size: 12px !important;\n        font-weight: normal !important;\n        line-height: 18px !important;\n        padding: 0 !important;\n        margin: 0 5px 0 0 !important;\n      }\n      #mlb2-5354301.ml-form-embedContainer .ml-form-embedWrapper .ml-form-embedBody .ml-form-checkboxRow label p:last-child {\n        margin: 0;\n      }\n      #mlb2-5354301.ml-form-embedContainer .ml-form-embedWrapper .ml-form-embedBody .ml-form-embedSubmit {\n        margin: 0 0 20px 0;\n        float: left;\n        width: 100%;\n      }\n      #mlb2-5354301.ml-form-embedContainer .ml-form-embedWrapper .ml-form-embedBody .ml-form-embedSubmit button {\n        background-color: #552222 !important;\n        border: none !important;\n        border-radius: 4px !important;\n        box-shadow: none !important;\n        color: #ffffff !important;\n        cursor: pointer;\n        font-family: 'Open Sans', Arial, Helvetica, sans-serif !important;\n        font-size: 14px !important;\n        font-weight: 700 !important;\n        line-height: 21px !important;\n        height: auto;\n        padding: 10px !important;\n        width: 100% !important;\n        box-sizing: border-box !important;\n      }\n      #mlb2-5354301.ml-form-embedContainer .ml-form-embedWrapper .ml-form-embedBody .ml-form-embedSubmit button.loading {\n        display: none;\n      }\n      #mlb2-5354301.ml-form-embedContainer .ml-form-embedWrapper .ml-form-embedBody .ml-form-embedSubmit button:hover {\n        background-color: #333333 !important;\n      }\n      .ml-subscribe-close {\n        width: 30px;\n        height: 30px;\n        background: url('https:\/\/assets.mlcdn.com\/ml\/images\/default\/modal_close.png') no-repeat;\n        background-size: 30px;\n        cursor: pointer;\n        margin-top: -10px;\n        margin-right: -10px;\n        position: absolute;\n        top: 0;\n        right: 0;\n      }\n      .ml-error input, .ml-error textarea, .ml-error select {\n        border-color: red!important;\n      }\n\n      .ml-error .custom-checkbox-radio-list {\n        border: 1px solid red !important;\n        border-radius: 4px;\n        padding: 10px;\n      }\n\n      .ml-error .label-description,\n      .ml-error .label-description p,\n      .ml-error .label-description p a,\n      .ml-error label:first-child {\n        color: #ff0000 !important;\n      }\n\n      #mlb2-5354301.ml-form-embedContainer .ml-form-embedWrapper .ml-form-embedBody .ml-form-checkboxRow.ml-error .label-description p,\n      #mlb2-5354301.ml-form-embedContainer .ml-form-embedWrapper .ml-form-embedBody .ml-form-checkboxRow.ml-error .label-description p:first-letter {\n        color: #ff0000 !important;\n      }\n            @media only screen and (max-width: 700px){\n\n        .ml-form-embedWrapper.embedDefault, .ml-form-embedWrapper.embedPopup { width: 100%!important; }\n        .ml-form-formContent.horozintalForm { float: left!important; }\n        .ml-form-formContent.horozintalForm .ml-form-horizontalRow { height: auto!important; width: 100%!important; float: left!important; }\n        .ml-form-formContent.horozintalForm .ml-form-horizontalRow .ml-input-horizontal { width: 100%!important; }\n        .ml-form-formContent.horozintalForm .ml-form-horizontalRow .ml-input-horizontal > div { padding-right: 0px!important; padding-bottom: 10px; }\n        .ml-form-formContent.horozintalForm .ml-button-horizontal { width: 100%!important; }\n        .ml-form-formContent.horozintalForm .ml-button-horizontal.labelsOn { padding-top: 0px!important; }\n\n      }\n    <\/style>\n\n    <style type=\"text\/css\">\n\n      .ml-mobileButton-horizontal { display: none; }\n\n      #mlb2-5354301 .ml-mobileButton-horizontal button {\n\n        background-color: #552222 !important;\n        border-color: #552222 !important;\n        border-style: solid !important;\n        border-width: 1px !important;\n        border-radius: 4px !important;\n        box-shadow: none !important;\n        color: #ffffff !important;\n        cursor: pointer;\n        font-family: 'Open Sans', Arial, Helvetica, sans-serif !important;\n        font-size: 14px !important;\n        font-weight: 700 !important;\n        line-height: 20px !important;\n        padding: 10px !important;\n        width: 100% !important;\n\n      }\n\n      @media only screen and (max-width: 700px) {\n        #mlb2-5354301.ml-form-embedContainer .ml-form-embedWrapper .ml-form-embedBody .ml-form-formContent.horozintalForm {\n          padding: 0 0 10px 0 !important;\n        }\n        .ml-hide-horizontal { display: none !important; }\n        .ml-form-formContent.horozintalForm .ml-button-horizontal { display: none!important; }\n        .ml-mobileButton-horizontal { display: inline-block !important; margin-bottom: 20px;width:100%; }\n        .ml-form-formContent.horozintalForm .ml-form-horizontalRow .ml-input-horizontal > div { padding-bottom: 0px !important; }\n      }\n\n    <\/style>\n  <style type=\"text\/css\">\n    @media only screen and (max-width: 700px) {\n       .ml-form-formContent.horozintalForm .ml-form-horizontalRow .horizontal-fields {\n        margin-bottom: 10px !important;\n        width: 100% !important;\n      }\n    }\n  <\/style>\n    \n    \n\n    \n    \n\n    \n    \n\n    \n\n      \n        \n        \n      \n\n      \n        \n        \n      \n\n      \n\n            \n            \n            \n            \n            \n            \n      \n\n      \n\n      \n        \n        \n         \n        \n        \n      \n\n        \n        \n        \n        \n        \n        \n      \n\n       \n\n        \n        \n        \n        \n        \n        \n        \n       \n\n\n      \n        \n        \n        \n        \n  \n\n\n\n  \n        \n        \n        \n      \n\n\n      \n    \n    \n    \n    \n    \n  \n\n  \n        \n        \n        \n        \n        \n      \n\n      \n        \n        \n        \n        \n        \n      \n\n      \n        \n        \n        \n        \n        \n      \n\n       \n\n        \n        \n        \n        \n       \n\n       \n        \n        \n        \n        \n      \n\n      \n        \n        \n        \n        \n        \n        \n        \n       \n\n    \n\n    \n\n\n      \n\n\n      \n\n      \n      \n\n      \n\n      \n\n\n\n\n\n    \n\n      \n    <div id=\"mlb2-5354301\" class=\"ml-form-embedContainer ml-subscribe-form ml-subscribe-form-5354301\">\n      <div class=\"ml-form-align-center \">\n        <div class=\"ml-form-embedWrapper embedForm\">\n\n          \n          \n\n          <div class=\"ml-form-embedBody ml-form-embedBodyHorizontal row-form\">\n\n            <div class=\"ml-form-embedContent\" style=\" \">\n              \n                <h4>\u52a0\u5165\u5c0f\u6db5\u85e5\u5e2b\u5b78\u7fd2\u9031\u8a18<\/h4>\n                <p><span style=\"font-size: 16px;\">\u8b93\u6211\u6bcf\u5468\u8207\u4f60\u5206\u4eab\u91ab\u85e5\u9818\u57df\u7684\u6240\u5b78\u8207\u9ad4\u609f<\/span><\/p>\n              \n            <\/div>\n\n            <form class=\"ml-block-form\" action=\"https:\/\/assets.mailerlite.com\/jsonp\/122622\/forms\/89155739623359552\/subscribe\" data-code=\"\" method=\"post\" target=\"_blank\">\n              \n\n              <div class=\"ml-form-formContent horozintalForm\">\n                <div class=\"ml-form-horizontalRow\">\n                  <div class=\"ml-input-horizontal\">\n                    \n                      \n                      <div style=\"width: 50%;\" class=\"horizontal-fields\">\n\n\n\n\n\n\n                        <div class=\"ml-field-group ml-field-name\">\n                          \n                          <!-- input -->\n                      <input type=\"text\" class=\"form-control\" data-inputmask=\"\" name=\"fields[name]\" placeholder=\"\u4f60\u7684\u540d\u5b57\" autocomplete=\"given-name\">\n                      <!-- \/input -->\n                        <\/div>\n\n\n\n                      <\/div><div style=\"width: 50%;\" class=\"horizontal-fields\">\n\n\n\n\n\n\n                        <div class=\"ml-field-group ml-field-email ml-validate-email ml-validate-required\">\n                          \n                          <!-- input -->\n                      <input type=\"email\" class=\"form-control\" data-inputmask=\"\" name=\"fields[email]\" placeholder=\"\u4f60\u7684\u4fe1\u7bb1\" autocomplete=\"email\">\n                      <!-- \/input -->\n                        <\/div>\n\n\n\n                      <\/div>\n                    \n                  <\/div>\n\n\n                  <div class=\"ml-button-horizontal primary \">\n                    \n                      <button type=\"submit\" class=\"primary\">\u6b61\u8fce\u8a02\u95b1<\/button>\n                    \n                    <button disabled=\"disabled\" style=\"display: none;\" type=\"button\" class=\"loading\">\n                      <div class=\"ml-form-embedSubmitLoad\"><\/div>\n                      <span class=\"sr-only\">Loading&#8230;<\/span>\n                    <\/button>\n                  <\/div>\n                <\/div>\n              <\/div>\n\n              <!-- Privacy policy -->\n              \n              <!-- \/Privacy policy -->\n\n              \n\n              \n\n              \n\n\n\n\n\n\n              \n              <input type=\"hidden\" name=\"ml-submit\" value=\"1\">\n\n              \n\n              <div class=\"ml-mobileButton-horizontal\">\n                <button type=\"submit\" class=\"primary\">\u6b61\u8fce\u8a02\u95b1<\/button>\n                <button disabled=\"disabled\" style=\"display: none;\" type=\"button\" class=\"loading\">\n                  <div class=\"ml-form-embedSubmitLoad\"><\/div>\n                  <span class=\"sr-only\">Loading&#8230;<\/span>\n                <\/button>\n              <\/div>\n              <input type=\"hidden\" name=\"anticsrf\" value=\"true\">\n            <\/form>\n          <\/div>\n\n          <div class=\"ml-form-successBody row-success\" style=\"display: none\">\n\n            <div class=\"ml-form-successContent\">\n              \n                <h4>\u611f\u8b1d\u60a8\u7684\u8a02\u95b1\uff01<\/h4>\n                <p><span style=\"font-size: 16px;\">\u91ab\u85e5\u5b78\u7fd2\u9031\u5831\u56fa\u5b9a\u5468\u4e00\u6216\u5468\u4e8c\u5bc4\u51fa\uff0c\u5982\u679c\u6c92\u6536\u5230\uff0c\u53ef\u4ee5\u5230\u5783\u573e\u90f5\u4ef6\u4e2d\u78ba\u8a8d\uff0c\u6216\u4f86\u4fe1\u544a\u77e5\u5594\uff01<\/span><\/p>\n\n              \n            <\/div>\n\n          <\/div>\n        <\/div>\n      <\/div>\n    <\/div>\n\n  \n\n  \n  \n  <script>\n    function ml_webform_success_5354301() {\n      var $ = ml_jQuery || jQuery;\n      $('.ml-subscribe-form-5354301 .row-success').show();\n      $('.ml-subscribe-form-5354301 .row-form').hide();\n    }\n      <\/script>\n  \n  \n      <script src=\"https:\/\/groot.mailerlite.com\/js\/w\/webforms.min.js?v08a893c96141fbc55feeeeac1fda7508\" type=\"text\/javascript\"><\/script>\n        <script>\n            fetch(\"https:\/\/assets.mailerlite.com\/jsonp\/122622\/forms\/89155739623359552\/track-view\")\n        <\/script>\n\n\n\n<div style=\"height:100px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_50 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\">\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=\"Toggle Table of Content\" role=\"button\"><label for=\"item-663b7c3b4a3cb\" aria-hidden=\"true\"><span style=\"display: flex;align-items: center;width: 35px;height: 30px;justify-content: center;direction:ltr;\"><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><\/label><input  type=\"checkbox\" id=\"item-663b7c3b4a3cb\"><\/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:\/\/tinapoint.com\/excel\/#Excel_%E5%B8%B8%E7%94%A8%E5%9F%BA%E6%9C%AC%E5%8A%9F%E8%83%BD%E4%BB%8B%E7%B4%B9\" title=\"Excel \u5e38\u7528\u57fa\u672c\u529f\u80fd\u4ecb\u7d39\">Excel \u5e38\u7528\u57fa\u672c\u529f\u80fd\u4ecb\u7d39<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/tinapoint.com\/excel\/#%E5%87%BD%E6%95%B8%E5%9F%BA%E6%9C%AC%E9%81%8B%E7%AE%97%E8%A6%8F%E5%89%87\" title=\"\u51fd\u6578\u57fa\u672c\u904b\u7b97\u898f\u5247\">\u51fd\u6578\u57fa\u672c\u904b\u7b97\u898f\u5247<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/tinapoint.com\/excel\/#%E9%81%8B%E7%AE%97%E5%AD%90%E5%88%97%E8%A1%A8\" title=\"\u904b\u7b97\u5b50\u5217\u8868\">\u904b\u7b97\u5b50\u5217\u8868<\/a><ul class='ez-toc-list-level-3'><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/tinapoint.com\/excel\/#%E7%AE%97%E8%A1%93%E9%81%8B%E7%AE%97%E5%AD%90\" title=\"\u7b97\u8853\u904b\u7b97\u5b50\">\u7b97\u8853\u904b\u7b97\u5b50<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/tinapoint.com\/excel\/#%E6%AF%94%E8%BC%83%E9%81%8B%E7%AE%97%E5%AD%90\" title=\"\u6bd4\u8f03\u904b\u7b97\u5b50\">\u6bd4\u8f03\u904b\u7b97\u5b50<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/tinapoint.com\/excel\/#%E6%96%87%E5%AD%97%E4%B8%B2%E8%81%AF%E9%81%8B%E7%AE%97%E5%AD%90\" title=\"\u6587\u5b57\u4e32\u806f\u904b\u7b97\u5b50\">\u6587\u5b57\u4e32\u806f\u904b\u7b97\u5b50<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/tinapoint.com\/excel\/#%E5%8F%83%E7%85%A7%E9%81%8B%E7%AE%97%E5%AD%90\" title=\"\u53c3\u7167\u904b\u7b97\u5b50\">\u53c3\u7167\u904b\u7b97\u5b50<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/tinapoint.com\/excel\/#%E5%87%BD%E6%95%B8%E5%88%97%E8%A1%A8\" title=\"\u51fd\u6578\u5217\u8868\">\u51fd\u6578\u5217\u8868<\/a><ul class='ez-toc-list-level-3'><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/tinapoint.com\/excel\/#%E9%82%8F%E8%BC%AF%E5%87%BD%E6%95%B8\" title=\"\u908f\u8f2f\u51fd\u6578\">\u908f\u8f2f\u51fd\u6578<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/tinapoint.com\/excel\/#%E5%8A%A0%E7%B8%BD%E5%87%BD%E6%95%B8\" title=\"\u52a0\u7e3d\u51fd\u6578\">\u52a0\u7e3d\u51fd\u6578<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/tinapoint.com\/excel\/#%E7%B5%B1%E8%A8%88%E5%87%BD%E6%95%B8\" title=\"\u7d71\u8a08\u51fd\u6578\">\u7d71\u8a08\u51fd\u6578<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/tinapoint.com\/excel\/#%E6%97%A5%E6%9C%9F%E8%88%87%E6%99%82%E9%96%93%E5%87%BD%E6%95%B8\" title=\"\u65e5\u671f\u8207\u6642\u9593\u51fd\u6578\">\u65e5\u671f\u8207\u6642\u9593\u51fd\u6578<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-13\" href=\"https:\/\/tinapoint.com\/excel\/#%E5%85%B6%E4%BB%96%E5%B8%B8%E7%94%A8%E5%87%BD%E6%95%B8\" title=\"\u5176\u4ed6\u5e38\u7528\u51fd\u6578\">\u5176\u4ed6\u5e38\u7528\u51fd\u6578<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-14\" href=\"https:\/\/tinapoint.com\/excel\/#%E9%8C%AF%E8%AA%A4%E4%BB%A3%E7%A2%BC%E8%AA%AA%E6%98%8E\" title=\"\u932f\u8aa4\u4ee3\u78bc\u8aaa\u660e\">\u932f\u8aa4\u4ee3\u78bc\u8aaa\u660e<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-15\" href=\"https:\/\/tinapoint.com\/excel\/#%E5%B8%B8%E7%94%A8%E5%9C%96%E8%A1%A8%E7%B9%AA%E8%A3%BD\" title=\"\u5e38\u7528\u5716\u8868\u7e6a\u88fd\">\u5e38\u7528\u5716\u8868\u7e6a\u88fd<\/a><ul class='ez-toc-list-level-3'><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-16\" href=\"https:\/\/tinapoint.com\/excel\/#%E7%9B%B4%E6%A2%9D%E5%9C%96%EF%BC%88%E6%A2%9D%E5%BD%A2%E5%9C%96%EF%BC%89\" title=\"\u76f4\u689d\u5716\uff08\u689d\u5f62\u5716\uff09\">\u76f4\u689d\u5716\uff08\u689d\u5f62\u5716\uff09<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-17\" href=\"https:\/\/tinapoint.com\/excel\/#%E6%8A%98%E7%B7%9A%E5%9C%96\" title=\"\u6298\u7dda\u5716\">\u6298\u7dda\u5716<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-18\" href=\"https:\/\/tinapoint.com\/excel\/#%E7%B5%84%E5%90%88%E5%9C%96%E4%BB%8B%E7%B4%B9\" title=\"\u7d44\u5408\u5716\u4ecb\u7d39\">\u7d44\u5408\u5716\u4ecb\u7d39<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-19\" href=\"https:\/\/tinapoint.com\/excel\/#%E5%9C%93%E5%BD%A2%E9%A4%85%E5%9C%96\" title=\"\u5713\u5f62(\u9905)\u5716\">\u5713\u5f62(\u9905)\u5716<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-20\" href=\"https:\/\/tinapoint.com\/excel\/#%E6%9F%8F%E6%8B%89%E5%9C%96%E4%BB%8B%E7%B4%B9%EF%BC%88%E5%93%81%E7%AE%A1%E5%B8%B8%E8%A6%8B%EF%BC%89\" title=\"\u67cf\u62c9\u5716\u4ecb\u7d39\uff08\u54c1\u7ba1\u5e38\u898b\uff09\">\u67cf\u62c9\u5716\u4ecb\u7d39\uff08\u54c1\u7ba1\u5e38\u898b\uff09<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-21\" href=\"https:\/\/tinapoint.com\/excel\/#%E9%9B%B7%E9%81%94%E5%9C%96%EF%BC%88%E5%93%81%E7%AE%A1%E5%B8%B8%E8%A6%8B%EF%BC%89\" title=\"\u96f7\u9054\u5716\uff08\u54c1\u7ba1\u5e38\u898b\uff09\">\u96f7\u9054\u5716\uff08\u54c1\u7ba1\u5e38\u898b\uff09<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-22\" href=\"https:\/\/tinapoint.com\/excel\/#%E7%B5%90%E8%AA%9E\" title=\"\u7d50\u8a9e\">\u7d50\u8a9e<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Excel_%E5%B8%B8%E7%94%A8%E5%9F%BA%E6%9C%AC%E5%8A%9F%E8%83%BD%E4%BB%8B%E7%B4%B9\"><\/span><strong>Excel \u5e38\u7528\u57fa\u672c\u529f\u80fd\u4ecb\u7d39<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td><strong>\u529f\u80fd<\/strong><\/td><td><strong>\u6309\u9375<\/strong><\/td><\/tr><tr><td>\u65bc\u540c\u4e00\u500b\u5132\u5b58\u683c\u4e2d\u63db\u884c<\/td><td>Alt + Enter<\/td><\/tr><tr><td>\u4e0a\u4e0b\u5de6\u53f3\u9023\u7e8c\u9078\u53d6<\/td><td>Ctrl + Shift + \u2191 \u2193 \u2190 \u2192<\/td><\/tr><tr><td>\u5c0b\u627e<\/td><td>Ctrl + F<\/td><\/tr><tr><td>\u9396\u4f4f\u6b04\u4f4d<\/td><td> $<br>\u6bd4\u5982 H$2\uff08\u9396\u4f4f\u7b2c\u4e8c\u5217\uff09\u3001$H2\uff08\u9396\u4f4fH\u6b04\uff09\u3001$H$2\uff08\u9396\u4f4f H2 \u6b04\u4f4d\uff09<br><br>\u7b46\u96fb\u4e5f\u53ef\u4ee5\u4f7f\u7528\u4ee5\u4e0b\u5feb\u6377\u9375\uff1a<br>Fn + F4 \u2192 $H$2<br>Fn + F4 \u6309\u5169\u6b21 \u2192 H$2<br>Fn + F4 \u6309\u4e09\u6b21 \u2192 $H2<br><br>\u684c\u6a5f\u6c92\u6709 Fn\uff0c\u76f4\u63a5\u6309 F4 \u5c31\u597d<\/td><\/tr><tr><td>\u8a2d\u5b9a\u60f3\u8981\u7684\u65e5\u671f\u683c\u5f0f<br>\u5982 2023\/09\/03 23:11:59<\/td><td>\u7531\u300c\u6578\u503c\u300d\u53f3\u4e0b\u89d2\u9032\u5165\u300c\u5132\u5b58\u683c\u683c\u5f0f\u300d\uff0c\u9078\u64c7\u300c\u81ea\u8a02\u300d<br>\u985e\u578b\u8f38\u5165\u300cyyyy\/mm\/dd hh:mm:ss\u300d<\/td><\/tr><tr><td>\u65b7\u958b\u51fd\u6578\u904b\u7b97<\/td><td>\u5c07\u904b\u7b97\u7d50\u679c\u8907\u88fd\uff0c\u8cbc\u4e0a\u6642\u53ef\u5230\u5de6\u4e0a\u89d2\u9078\u64c7\u6027\u8cbc\u4e0a\uff0c\u9078\u64c7\u3010\u53ea\u6709\u503c\/\u503c\u8207\u6578\u5b57\u683c\u5f0f\u3011<br>\u6216\u662f\u8cbc\u4e0a\u5f8c\uff0c\u53f3\u4e0b\u89d2\u7684 ctrl \u5c0f\u6a19\u793a\u9ede\u9078\u5c55\u958b\uff0c\u6539\u9078\u64c7\u3010\u53ea\u6709\u503c\/\u503c\u8207\u6578\u5b57\u683c\u5f0f\u3011<\/td><\/tr><tr><td>F4<\/td><td>\u91cd\u8907\u4e0a\u4e00\u500b\u52d5\u4f5c\uff0c\u6bd4\u5982\u60f3\u8981\u8de8\u6b04\u7f6e\u4e2d\u597d\u591a\u500b\u6b04\u4f4d\uff0c\u4f46\u5979\u6c92\u6709\u5feb\u6377\u9375\uff0c\u53ef\u4ee5\u5584\u7528 F4<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<div style=\"height:100px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"box\"><strong>\u5ef6\u4f38\u95b1\u8b80\uff1a<a href=\"https:\/\/tinapoint.com\/clinical-pharmacist\/\">\u3010\u5206\u4eab\u3011\u91ab\u9662\u81e8\u5e8a\u85e5\u5e2b\u505a\u4ec0\u9ebc\uff1f\u4f60\u61c9\u8a72\u77e5\u9053\u768415\u9805\u5de5\u4f5c\u5167\u5bb9<\/a><\/strong><\/p>\n\n\n\n<div style=\"height:100px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E5%87%BD%E6%95%B8%E5%9F%BA%E6%9C%AC%E9%81%8B%E7%AE%97%E8%A6%8F%E5%89%87\"><\/span><strong>\u51fd\u6578<\/strong>\u57fa\u672c\u904b\u7b97\u898f\u5247<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"box\">\u9996\u5148\u8981\u77ad\u89e3\u6578\u5b78\u57fa\u672c\u904b\u7b97\u898f\u5247\uff0c\u70ba\u300c<mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-vivid-red-color\"><strong>\u5148\u4e58\u9664\u5f8c\u52a0\u6e1b\uff0c\u62ec\u865f\u5167\u512a\u5148\u8a08\u7b97<\/strong><\/mark>\u300d\u3002<\/p>\n\n\n\n<div class=\"wp-block-group list\"><div class=\"wp-block-group__inner-container is-layout-constrained wp-block-group-is-layout-constrained\">\n<p><strong>(1254+806)2 &#8211; 5228 = -56<\/strong><\/p>\n\n\n\n<p>\u5148\u628a 1254+806\uff0c\u518d\u4e58 2 \u5f97\u7d50\u679c 4120\uff0c\u6e1b\u53bb 522*8 \u4e5f\u5c31\u662f 4176\uff0c\u6700\u5f8c\u7d50\u679c\u70ba -56\u3002<\/p>\n<\/div><\/div>\n\n\n\n<div class=\"wp-block-group\"><div class=\"wp-block-group__inner-container is-layout-constrained wp-block-group-is-layout-constrained\">\n<div class=\"wp-block-group list\"><div class=\"wp-block-group__inner-container is-layout-constrained wp-block-group-is-layout-constrained\">\n<p><strong>1254+8062 &#8211; 5228 =  -1310<\/strong><\/p>\n\n\n\n<p>806 \u5148\u4e58 2 \u5f97 1612\uff0c\u4ee5\u53ca 522 \u5148\u4e58 8 \u5f97 4176\uff0c\u7136\u5f8c\u628a 1254 \u52a0 1612 \u6e1b\u53bb 4176\uff0c\u6700\u5f8c\u7d50\u679c\u70ba -1310\u3002<\/p>\n<\/div><\/div>\n<\/div><\/div>\n\n\n\n<p>\u4ee5\u4e0a\u70ba\u8209\u4f8b\uff0c\u6709\u62ec\u865f\u6c92\u62ec\u865f\u5dee\u5f88\u591a\uff5e<\/p>\n\n\n\n<div style=\"height:100px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E9%81%8B%E7%AE%97%E5%AD%90%E5%88%97%E8%A1%A8\"><\/span><strong>\u904b\u7b97\u5b50\u5217\u8868<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E7%AE%97%E8%A1%93%E9%81%8B%E7%AE%97%E5%AD%90\"><\/span><strong>\u7b97\u8853\u904b\u7b97\u5b50<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td class=\"has-text-align-center\" data-align=\"center\"><strong>\u7b26\u865f<\/strong><\/td><td class=\"has-text-align-center\" data-align=\"center\"><strong>\u610f\u601d<\/strong><\/td><td class=\"has-text-align-center\" data-align=\"center\"><strong>\u7bc4\u4f8b<\/strong><\/td><\/tr><tr><td class=\"has-text-align-center\" data-align=\"center\">+<\/td><td class=\"has-text-align-center\" data-align=\"center\">\u52a0<\/td><td class=\"has-text-align-center\" data-align=\"center\">2 + 2<\/td><\/tr><tr><td class=\"has-text-align-center\" data-align=\"center\">\uff0d<\/td><td class=\"has-text-align-center\" data-align=\"center\">\u6e1b<\/td><td class=\"has-text-align-center\" data-align=\"center\">2 &#8211; 2<\/td><\/tr><tr><td class=\"has-text-align-center\" data-align=\"center\">*<\/td><td class=\"has-text-align-center\" data-align=\"center\">\u4e58<\/td><td class=\"has-text-align-center\" data-align=\"center\">2 * 2<\/td><\/tr><tr><td class=\"has-text-align-center\" data-align=\"center\">\/<\/td><td class=\"has-text-align-center\" data-align=\"center\">\u9664<\/td><td class=\"has-text-align-center\" data-align=\"center\">2 \/ 2<\/td><\/tr><tr><td class=\"has-text-align-center\" data-align=\"center\">%<\/td><td class=\"has-text-align-center\" data-align=\"center\">\u767e\u5206\u6bd4<\/td><td class=\"has-text-align-center\" data-align=\"center\">20 %<\/td><\/tr><tr><td class=\"has-text-align-center\" data-align=\"center\">^<\/td><td class=\"has-text-align-center\" data-align=\"center\">\u6b21\u65b9<\/td><td class=\"has-text-align-center\" data-align=\"center\">2 ^ 2<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<div style=\"height:60px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<div class=\"wp-block-group list\"><div class=\"wp-block-group__inner-container is-layout-constrained wp-block-group-is-layout-constrained\">\n<p><strong>\u8209\u4f8b\uff1a\u5982\u4f55\u8a08\u7b97 BMI\uff1f<\/strong><\/p>\n\n\n\n<p>BMI \u7684\u8a08\u7b97\u65b9\u5f0f\u70ba \u9ad4\u91cd(kg) \u9664\u4ee5 \u8eab\u9ad8(m)\u7684\u5e73\u65b9<\/p>\n\n\n\n<p>Excel \u516c\u5f0f = F2[\u9ad4\u91cd\u6b04\u4f4d] \/ (E2[\u8eab\u9ad8\u6b04\u4f4d] \/ 100[\u516c\u5206\u8f49\u516c\u5c3a])^2 [\u5e73\u65b9]<\/p>\n<\/div><\/div>\n\n\n\n<div style=\"height:60px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E6%AF%94%E8%BC%83%E9%81%8B%E7%AE%97%E5%AD%90\"><\/span><strong>\u6bd4\u8f03\u904b\u7b97\u5b50<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td class=\"has-text-align-center\" data-align=\"center\"><strong>\u7b26\u865f<\/strong><\/td><td class=\"has-text-align-center\" data-align=\"center\"><strong>\u610f\u601d<\/strong><\/td><td class=\"has-text-align-center\" data-align=\"center\"><strong>\u7bc4\u4f8b<\/strong><\/td><\/tr><tr><td class=\"has-text-align-center\" data-align=\"center\">\uff1e<\/td><td class=\"has-text-align-center\" data-align=\"center\">\u5927\u65bc<\/td><td class=\"has-text-align-center\" data-align=\"center\">F2\uff1eF1<\/td><\/tr><tr><td class=\"has-text-align-center\" data-align=\"center\">\uff1c<\/td><td class=\"has-text-align-center\" data-align=\"center\">\u5c0f\u65bc<\/td><td class=\"has-text-align-center\" data-align=\"center\">F2\uff1cF1<\/td><\/tr><tr><td class=\"has-text-align-center\" data-align=\"center\">\uff1d<\/td><td class=\"has-text-align-center\" data-align=\"center\">\u7b49\u65bc<\/td><td class=\"has-text-align-center\" data-align=\"center\">F2\uff1dF1<\/td><\/tr><tr><td class=\"has-text-align-center\" data-align=\"center\">&gt;=<\/td><td class=\"has-text-align-center\" data-align=\"center\">\u5927\u65bc\u7b49\u65bc<\/td><td class=\"has-text-align-center\" data-align=\"center\">F2&gt;=F1<\/td><\/tr><tr><td class=\"has-text-align-center\" data-align=\"center\">&lt;=<\/td><td class=\"has-text-align-center\" data-align=\"center\">\u5c0f\u65bc\u7b49\u65bc<\/td><td class=\"has-text-align-center\" data-align=\"center\">F2&lt;=F1<\/td><\/tr><tr><td class=\"has-text-align-center\" data-align=\"center\">&lt;&gt;<\/td><td class=\"has-text-align-center\" data-align=\"center\">\u4e0d\u7b49\u65bc<\/td><td class=\"has-text-align-center\" data-align=\"center\">F2&lt;&gt;F1<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<div style=\"height:60px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E6%96%87%E5%AD%97%E4%B8%B2%E8%81%AF%E9%81%8B%E7%AE%97%E5%AD%90\"><\/span><strong>\u6587\u5b57\u4e32\u806f\u904b\u7b97\u5b50<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td class=\"has-text-align-center\" data-align=\"center\"><strong>\u7b26\u865f<\/strong><\/td><td class=\"has-text-align-center\" data-align=\"center\"><strong>\u610f\u601d<\/strong><\/td><td class=\"has-text-align-center\" data-align=\"center\"><strong>\u7bc4\u4f8b<\/strong><\/td><\/tr><tr><td class=\"has-text-align-center\" data-align=\"center\">&amp;<\/td><td class=\"has-text-align-center\" data-align=\"center\">\u9023\u7d50\u6587\u5b57\u5b57\u4e32<\/td><td class=\"has-text-align-center\" data-align=\"center\">A2 &amp; C2<br>B2 &amp; &#8220;\u60f3\u8981\u9023\u7d50\u7684\u6587\u5b57\u8981\u52a0\u96d9\u5f15\u865f&#8221;<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<div style=\"height:60px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"box\"><strong>\u5ef6\u4f38\u95b1\u8b80\uff1a<a href=\"https:\/\/tinapoint.com\/formosa-journal-of-clinical-pharmacy\/\">\u4f60\u60f3\u6295\u7a3f\u81e8\u5e8a\u85e5\u5b78\u96dc\u8a8c\u55ce\uff1f\u5f9e\u6295\u7a3f\u5230\u5be9\u7a3f\u4eba\u7684\u7d93\u9a57\u5206\u4eab<\/a><\/strong><\/p>\n\n\n\n<div style=\"height:60px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E5%8F%83%E7%85%A7%E9%81%8B%E7%AE%97%E5%AD%90\"><\/span><strong>\u53c3\u7167\u904b\u7b97\u5b50<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td class=\"has-text-align-center\" data-align=\"center\"><strong>\u7b26\u865f<\/strong><\/td><td class=\"has-text-align-center\" data-align=\"center\"><strong>\u610f\u601d<\/strong><\/td><td class=\"has-text-align-center\" data-align=\"center\"><strong>\u7bc4\u4f8b<\/strong><\/td><\/tr><tr><td class=\"has-text-align-center\" data-align=\"center\">\uff1a<\/td><td class=\"has-text-align-center\" data-align=\"center\">\u5192\u865f\uff0c\u9023\u7e8c\u7684\u5132\u5b58\u683c\u7bc4\u570d<\/td><td class=\"has-text-align-center\" data-align=\"center\">SUM(F2:F6)<br>\u52a0\u7e3d F2 \u5230 F6 \u5132\u5b58\u683c\u5167\u5bb9<\/td><\/tr><tr><td class=\"has-text-align-center\" data-align=\"center\">,<\/td><td class=\"has-text-align-center\" data-align=\"center\">\u9017\u865f\uff0c\u4e0d\u9023\u7e8c\u7684\u5132\u5b58\u683c\u7bc4\u570d<\/td><td class=\"has-text-align-center\" data-align=\"center\">SUM(F2:F6,F8,F100)<br>\u52a0\u7e3d F2 \u5230 F6\u3001F8 \u548c F100 \u7684\u5132\u5b58\u683c\u5167\u5bb9<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<div style=\"height:100px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E5%87%BD%E6%95%B8%E5%88%97%E8%A1%A8\"><\/span><strong>\u51fd\u6578\u5217\u8868<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E9%82%8F%E8%BC%AF%E5%87%BD%E6%95%B8\"><\/span><strong>\u908f\u8f2f\u51fd\u6578<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<figure class=\"wp-block-table\"><table><thead><tr><th class=\"has-text-align-center\" data-align=\"center\">\u51fd\u6578\u540d\u7a31<\/th><th class=\"has-text-align-center\" data-align=\"center\">\u610f\u601d<\/th><th class=\"has-text-align-left\" data-align=\"left\">\u8aaa\u660e<\/th><\/tr><\/thead><tbody><tr><td class=\"has-text-align-center\" data-align=\"center\">IF<\/td><td class=\"has-text-align-center\" data-align=\"center\">\u5982\u679c<\/td><td class=\"has-text-align-left\" data-align=\"left\">=IF(\u689d\u4ef6,\u689d\u4ef6\u7b26\u5408\u56de\u50b3,\u689d\u4ef6\u4e0d\u7b26\u5408\u56de\u50b3)<br><br>=IF(G2&gt;30.&#8221;\u7279\u8a13&#8221;,G2)<br>\u8aaa\u660e\uff1a\u5982\u679c G2 \u6578\u503c\u5927\u65bc 30\uff0c\u8acb\u56de\u50b3&#8221;\u7279\u8a13&#8221;\u5b57\u773c\uff0c\u5426\u5247\u56de\u50b3 G2 \u6b04\u4f4d\u5167\u5bb9<br><br>=IF(H2=&#8221;A&#8221;,1,H2)<br>\u8aaa\u660e\uff1a\u5982\u679c H2 \u6b04\u4f4d\u7684\u6587\u5b57\u70ba&#8221;A&#8221;\uff0c\u8acb\u56de\u50b3\u6578\u5b571\uff0c\u5426\u5247\u56de\u50b3 H2 \u6b04\u4f4d\u5167\u5bb9<\/td><\/tr><tr><td class=\"has-text-align-center\" data-align=\"center\">AND<\/td><td class=\"has-text-align-center\" data-align=\"center\">\u8207<\/td><td class=\"has-text-align-left\" data-align=\"left\">=IF(AND(G2&lt;30,G2&gt;18.5),&#8221;\u6a19\u6e96&#8221;,G2)<br>\u8aaa\u660e\uff1a\u5982\u679c G2 \u6578\u503c\u5c0f\u65bc 30 \u4e14 \u5927\u65bc 18.5\uff0c\u8acb\u56de\u50b3&#8221;\u6a19\u6e96&#8221;\u5b57\u773c\uff0c\u5426\u5247\u56de\u50b3 G2 \u6b04\u4f4d\u5167\u5bb9<\/td><\/tr><tr><td class=\"has-text-align-center\" data-align=\"center\">OR<\/td><td class=\"has-text-align-center\" data-align=\"center\">\u6216<\/td><td class=\"has-text-align-left\" data-align=\"left\">=IF(OR(G2&gt;30,G2&lt;18.5),&#8221;\u4e0d\u6a19\u6e96&#8221;,G2)<br>\u8aaa\u660e\uff1a\u5982\u679c G2 \u6578\u503c\u5927\u65bc 30 \u6216 \u5c0f\u65bc 18.5\uff0c\u8acb\u56de\u50b3&#8221;\u4e0d\u6a19\u6e96&#8221;\u5b57\u773c\uff0c\u5426\u5247\u56de\u50b3 G2 \u6b04\u4f4d\u5167\u5bb9<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<div style=\"height:60px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>\u5c0f\u5c0f\u8209\u4f8b\uff1a<\/p>\n\n\n\n<p>\u5982\u679c\u8981\u628a BMI \u8b8a\u6210\u4ee5\u4e0b\u6587\u5b57\uff0c\u8a72\u600e\u9ebc\u5beb\u516c\u5f0f\uff1f<\/p>\n\n\n\n<figure class=\"wp-block-table is-style-stripes\"><table><thead><tr><th class=\"has-text-align-center\" data-align=\"center\">\u9ad4\u614b\u8868\u73fe<\/th><th class=\"has-text-align-center\" data-align=\"center\">BMI \u6307\u6578 (G2\u6b04\u4f4d)<\/th><th class=\"has-text-align-center\" data-align=\"center\">\u9ad4\u614b\u8868\u73fe<\/th><th class=\"has-text-align-center\" data-align=\"center\">BMI \u6307\u6578 (G2\u6b04\u4f4d)<\/th><\/tr><\/thead><tbody><tr><td class=\"has-text-align-center\" data-align=\"center\">\u904e\u8f15<\/td><td class=\"has-text-align-center\" data-align=\"center\">\uff1c18.5<\/td><td class=\"has-text-align-center\" data-align=\"center\">\u8f15\u5ea6\u80a5\u80d6<\/td><td class=\"has-text-align-center\" data-align=\"center\">27 \u2266 BMI\uff1c30<\/td><\/tr><tr><td class=\"has-text-align-center\" data-align=\"center\">\u6b63\u5e38<\/td><td class=\"has-text-align-center\" data-align=\"center\">18.5 \u2266 BMI\uff1c24<\/td><td class=\"has-text-align-center\" data-align=\"center\">\u4e2d\u5ea6\u80a5\u80d6<\/td><td class=\"has-text-align-center\" data-align=\"center\">30 \u2266 BMI\uff1c35<\/td><\/tr><tr><td class=\"has-text-align-center\" data-align=\"center\">\u904e\u91cd<\/td><td class=\"has-text-align-center\" data-align=\"center\">24 \u2266 BMI\uff1c27<\/td><td class=\"has-text-align-center\" data-align=\"center\">\u91cd\u5ea6\u80a5\u80d6<\/td><td class=\"has-text-align-center\" data-align=\"center\">BMI \u2267 35<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"box\"><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-vivid-red-color\">\u79d8\u8a23\uff1a\u7531\u6700\u5927\u503c\u5f80\u4e0b\u7be9\u9078\uff01<\/mark><\/strong><\/p>\n\n\n\n<div class=\"wp-block-group list\"><div class=\"wp-block-group__inner-container is-layout-constrained wp-block-group-is-layout-constrained\">\n<p>\u516c\u5f0f\u4e00\uff1a<\/p>\n\n\n\n<p>= IF(G2\u226735,&#8221;\u91cd\u5ea6\u80a5\u80d6&#8221;,IF(G2&gt;=30,&#8221;\u4e2d\u5ea6\u80a5\u80d6&#8221;,IF(G2&gt;=27,&#8221;\u8f15\u5ea6\u80a5\u80d6&#8221;,IF(G2&gt;=24,&#8221;\u904e\u91cd&#8221;,IF(G2&gt;=18.5,&#8221;\u6b63\u5e38&#8221;,&#8221;<mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-vivid-red-color\"><strong>\u904e\u8f15<\/strong><\/mark>&#8220;)))))<\/p>\n<\/div><\/div>\n\n\n\n<div class=\"wp-block-group list\"><div class=\"wp-block-group__inner-container is-layout-constrained wp-block-group-is-layout-constrained\">\n<div class=\"wp-block-group\"><div class=\"wp-block-group__inner-container is-layout-constrained wp-block-group-is-layout-constrained\">\n<p>\u516c\u5f0f\u4e8c\uff1a\uff08\u50c5 2016 \u7248\u4ee5\u5f8c\uff0c\u8207 office 365 \u7248\uff09<\/p>\n\n\n\n<p>= IFS(G2&gt;=35,&#8221;\u91cd\u5ea6\u80a5\u80d6&#8221;,G2&gt;=30,&#8221;\u4e2d\u5ea6\u80a5\u80d6&#8221;,G2&gt;=27,&#8221;\u8f15\u5ea6\u80a5\u80d6&#8221;,G2&gt;=24,&#8221;\u904e\u91cd&#8221;,G2&gt;=18.5,&#8221;\u6b63\u5e38&#8221;,<strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-vivid-red-color\">G2&lt;18.5,&#8221;\u904e\u8f15&#8221;<\/mark><\/strong>)<\/p>\n<\/div><\/div>\n<\/div><\/div>\n\n\n\n<div style=\"height:100px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E5%8A%A0%E7%B8%BD%E5%87%BD%E6%95%B8\"><\/span><strong>\u52a0\u7e3d\u51fd\u6578<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<figure class=\"wp-block-table\"><table><thead><tr><th class=\"has-text-align-center\" data-align=\"center\">\u51fd\u6578\u540d\u7a31<\/th><th class=\"has-text-align-center\" data-align=\"center\">\u610f\u601d<\/th><th class=\"has-text-align-left\" data-align=\"left\">\u8aaa\u660e<\/th><\/tr><\/thead><tbody><tr><td class=\"has-text-align-center\" data-align=\"center\">SUM<\/td><td class=\"has-text-align-center\" data-align=\"center\">\u52a0\u7e3d<\/td><td class=\"has-text-align-left\" data-align=\"left\">=SUM(F2:F50)<br>\u8aaa\u660e\uff1a\u5c07 F2 \u5230 F50 \u6b04\u4f4d\u7684\u6578\u503c\u52a0\u7e3d<br><strong>\u6b65\u9a5f\uff1a\u9ede\u5132\u5b58\u683c F2\uff0cCtrl + Shift + \u4e0b\uff0c\u5c31\u53ef\u4ee5\u5411\u4e0b\u9078\u53d6\u6240\u542b\u8cc7\u6599\u7684\u5132\u5b58\u683c<\/strong><\/td><\/tr><tr><td class=\"has-text-align-center\" data-align=\"center\">SUNIF<\/td><td class=\"has-text-align-center\" data-align=\"center\">\u6709\u689d\u4ef6\u52a0\u7e3d<\/td><td class=\"has-text-align-left\" data-align=\"left\">=SUMIF(\u627e\u5c0b\u689d\u4ef6\u7bc4\u570d,\u689d\u4ef6,\u52a0\u7e3d\u7bc4\u570d)<br><br>=SUMIF(H2:H50,&#8221;A\u578b&#8221;,F2:F50)<br>\u8aaa\u660e\uff1a\u5982\u679c H2 \u5230 H50 \u6b04\u4f4d\u4e2d\u5c6c\u65bc&#8221;A\u578b&#8221;\u8840\uff0c\u52a0\u7e3d F \u6b04\u4f4d\u7684\u6578\u503c<\/td><\/tr><tr><td class=\"has-text-align-center\" data-align=\"center\">SUMIFS<\/td><td class=\"has-text-align-center\" data-align=\"center\">\u591a\u9805\u689d\u4ef6\u52a0\u7e3d<\/td><td class=\"has-text-align-left\" data-align=\"left\">=SUMIFS(\u52a0\u7e3d\u7bc4\u570d,\u627e\u5c0b\u689d\u4ef6\u7bc4\u570d1,\u689d\u4ef61,\u627e\u5c0b\u689d\u4ef6\u7bc4\u570d2,\u689d\u4ef62)<br><br>=SUMIFS(F2:F50,H2:H50,&#8221;A\u578b&#8221;,E2:E50,&#8221;155&#8243;)<br>\u8aaa\u660e\uff1a\u52a0\u7e3d\u8840\u578b\u662f&#8221;A\u578b&#8221;\uff0c\u4e14\u8eab\u9ad8 155 \u7684\u9ad4\u91cd<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<div style=\"height:60px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"box\"><strong>\u5ef6\u4f38\u95b1\u8b80\uff1a<a href=\"https:\/\/tinapoint.com\/pharmacist-clinic\/\">\u85e5\u5e2b\u9580\u8a3a\u7518\u82e6\u8ac7\uff1f\u6297\u51dd\u8840\u85e5\u5e2b\u9580\u8a3a\u5efa\u7f6e\u7d93\u9a57\u5206\u4eab<\/a><\/strong><\/p>\n\n\n\n<div style=\"height:60px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E7%B5%B1%E8%A8%88%E5%87%BD%E6%95%B8\"><\/span><strong>\u7d71\u8a08\u51fd\u6578<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<figure class=\"wp-block-table\"><table><thead><tr><th class=\"has-text-align-center\" data-align=\"center\">\u51fd\u6578\u540d\u7a31<\/th><th class=\"has-text-align-center\" data-align=\"center\">\u610f\u601d<\/th><th class=\"has-text-align-left\" data-align=\"left\">\u8aaa\u660e<\/th><\/tr><\/thead><tbody><tr><td class=\"has-text-align-center\" data-align=\"center\">AVERAGE<\/td><td class=\"has-text-align-center\" data-align=\"center\">\u5e73\u5747\u503c<\/td><td class=\"has-text-align-left\" data-align=\"left\">=AVERAGE(F2:F50)<br>\u8aaa\u660e\uff1a\u8a08\u7b97 F2 \u5230 F50 \u6b04\u4f4d\u7684\u5e73\u5747\u503c<\/td><\/tr><tr><td class=\"has-text-align-center\" data-align=\"center\">MEDIAN<\/td><td class=\"has-text-align-center\" data-align=\"center\">\u4e2d\u4f4d\u6578<\/td><td class=\"has-text-align-left\" data-align=\"left\">=MEDIAN(F2:F50)<br>\u8aaa\u660e\uff1a\u8a08\u7b97 F2 \u5230 F50 \u6b04\u4f4d\u7684\u4e2d\u4f4d\u503c<\/td><\/tr><tr><td class=\"has-text-align-center\" data-align=\"center\">MODE<\/td><td class=\"has-text-align-center\" data-align=\"center\">\u773e\u6578<\/td><td class=\"has-text-align-left\" data-align=\"left\">=MODE(F2:F50)<br>\u8aaa\u660e\uff1a\u8a08\u7b97 F2 \u5230 F50 \u6b04\u4f4d\u7684\u773e\u503c<\/td><\/tr><tr><td class=\"has-text-align-center\" data-align=\"center\">STDEV<\/td><td class=\"has-text-align-center\" data-align=\"center\">\u6a19\u6e96\u5dee<\/td><td class=\"has-text-align-left\" data-align=\"left\">=STDEV(F2:F50)<br>\u8aaa\u660e\uff1a\u8a08\u7b97 F2 \u5230 F50 \u6b04\u4f4d\u7684\u6a19\u6e96\u5dee<\/td><\/tr><tr><td class=\"has-text-align-center\" data-align=\"center\">VAR<\/td><td class=\"has-text-align-center\" data-align=\"center\">\u8b8a\u7570\u6578<\/td><td class=\"has-text-align-left\" data-align=\"left\">=VAR(F2:F50)<br>\u8aaa\u660e\uff1a\u8a08\u7b97 F2 \u5230 F50 \u6b04\u4f4d\u7684\u8b8a\u7570\u6578<\/td><\/tr><tr><td class=\"has-text-align-center\" data-align=\"center\">MIN<\/td><td class=\"has-text-align-center\" data-align=\"center\">\u6700\u5c0f\u503c<\/td><td class=\"has-text-align-left\" data-align=\"left\">=MIN(F2:F50)<br>\u8aaa\u660e\uff1a\u627e\u51fa F2 \u5230 F50 \u6b04\u4f4d\u7684\u6700\u5c0f\u503c<\/td><\/tr><tr><td class=\"has-text-align-center\" data-align=\"center\">MAX<\/td><td class=\"has-text-align-center\" data-align=\"center\">\u6700\u5927\u503c<\/td><td class=\"has-text-align-left\" data-align=\"left\">=MAX(F2:F50)<br>\u8aaa\u660e\uff1a\u627e\u51fa F2 \u5230 F50 \u6b04\u4f4d\u7684\u6700\u5927\u503c<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<div style=\"height:60px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E6%97%A5%E6%9C%9F%E8%88%87%E6%99%82%E9%96%93%E5%87%BD%E6%95%B8\"><\/span><strong>\u65e5\u671f\u8207\u6642\u9593\u51fd\u6578<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<figure class=\"wp-block-table\"><table><thead><tr><th class=\"has-text-align-center\" data-align=\"center\">\u51fd\u6578\u540d\u7a31<\/th><th class=\"has-text-align-center\" data-align=\"center\">\u610f\u601d<\/th><th class=\"has-text-align-left\" data-align=\"left\">\u8aaa\u660e<\/th><\/tr><\/thead><tbody><tr><td class=\"has-text-align-center\" data-align=\"center\">YEAR<\/td><td class=\"has-text-align-center\" data-align=\"center\">\u5e74<\/td><td class=\"has-text-align-left\" data-align=\"left\">=YEAR(E2)<br>\u8aaa\u660e\uff1a\u56de\u50b3 E2 \u6b04\u4f4d\u7684\u5e74\u4efd<\/td><\/tr><tr><td class=\"has-text-align-center\" data-align=\"center\">MONTH<\/td><td class=\"has-text-align-center\" data-align=\"center\">\u6708<\/td><td class=\"has-text-align-left\" data-align=\"left\">=MONTH(E2)<br>\u8aaa\u660e\uff1a\u56de\u50b3 E2 \u6b04\u4f4d\u7684\u6708\u4efd<\/td><\/tr><tr><td class=\"has-text-align-center\" data-align=\"center\">DAY<\/td><td class=\"has-text-align-center\" data-align=\"center\">\u65e5<\/td><td class=\"has-text-align-left\" data-align=\"left\">=DAY(E2)<br>\u8aaa\u660e\uff1a\u56de\u50b3 E2 \u6b04\u4f4d\u7684\u65e5\u5b50<\/td><\/tr><tr><td class=\"has-text-align-center\" data-align=\"center\">HOUR<\/td><td class=\"has-text-align-center\" data-align=\"center\">\u6642<\/td><td class=\"has-text-align-left\" data-align=\"left\">=HOUR(E2)<br>\u8aaa\u660e\uff1a\u56de\u50b3 E2 \u6b04\u4f4d\u7684\u5c0f\u6642<\/td><\/tr><tr><td class=\"has-text-align-center\" data-align=\"center\">MINUTE<\/td><td class=\"has-text-align-center\" data-align=\"center\">\u5206<\/td><td class=\"has-text-align-left\" data-align=\"left\">=MINUTE(E2)<br>\u8aaa\u660e\uff1a\u56de\u50b3 E2 \u6b04\u4f4d\u7684\u5206\u9418<\/td><\/tr><tr><td class=\"has-text-align-center\" data-align=\"center\">SECOND<\/td><td class=\"has-text-align-center\" data-align=\"center\">\u79d2<\/td><td class=\"has-text-align-left\" data-align=\"left\">=SECOND(E2)<br>\u8aaa\u660e\uff1a\u56de\u50b3 E2 \u6b04\u4f4d\u7684\u79d2\u6578<\/td><\/tr><tr><td class=\"has-text-align-center\" data-align=\"center\">WEEKDAY<\/td><td class=\"has-text-align-center\" data-align=\"center\">\u661f\u671f<\/td><td class=\"has-text-align-left\" data-align=\"left\">=WEEKDAY(E2,1)<br>\u8aaa\u660e\uff1a\u56de\u50b3 E2 \u6b04\u4f4d\u7684\u661f\u671f<\/td><\/tr><tr><td class=\"has-text-align-center\" data-align=\"center\">NOW<\/td><td class=\"has-text-align-center\" data-align=\"center\">\u73fe\u5728\u65e5\u671f\u8207\u6642\u9593<\/td><td class=\"has-text-align-left\" data-align=\"left\">=NOW( )-E2<br>\u8aaa\u660e\uff1a\u73fe\u5728\u6642\u9593\u8207 E2 \u7684\u6642\u9593\u5dee<\/td><\/tr><tr><td class=\"has-text-align-center\" data-align=\"center\">TODAY<\/td><td class=\"has-text-align-center\" data-align=\"center\">\u4eca\u5929\u65e5\u671f<\/td><td class=\"has-text-align-left\" data-align=\"left\">=TODAY( )-E2<br>\u8aaa\u660e\uff1a\u4eca\u5929\u8207 E2 \u7684\u6642\u9593\u5dee<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<div style=\"height:60px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E5%85%B6%E4%BB%96%E5%B8%B8%E7%94%A8%E5%87%BD%E6%95%B8\"><\/span><strong>\u5176\u4ed6\u5e38\u7528\u51fd\u6578<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<figure class=\"wp-block-table\"><table><thead><tr><th class=\"has-text-align-center\" data-align=\"center\">\u51fd\u6578\u540d\u7a31<\/th><th class=\"has-text-align-center\" data-align=\"center\">\u610f\u601d<\/th><th class=\"has-text-align-left\" data-align=\"left\">\u8aaa\u660e<\/th><\/tr><\/thead><tbody><tr><td class=\"has-text-align-center\" data-align=\"center\">ROUND<\/td><td class=\"has-text-align-center\" data-align=\"center\">\u56db\u6368\u4e94\u5165<\/td><td class=\"has-text-align-left\" data-align=\"left\">=ROUND(G2,1)<br>\u8aaa\u660e\uff1a\u5c07 G2 \u6b04\u4f4d\u6578\u503c\u56db\u6368\u4e94\u5165\u53d6\u5230\u5c0f\u6578\u9ede\u5f8c\u7b2c\u4e00\u4f4d<\/td><\/tr><tr><td class=\"has-text-align-center\" data-align=\"center\">ROUNDDOWN<\/td><td class=\"has-text-align-center\" data-align=\"center\">\u7121\u689d\u4ef6\u6368\u53bb<\/td><td class=\"has-text-align-left\" data-align=\"left\">=ROUNDDOWN(G2,0)<br>\u8aaa\u660e\uff1a\u5c07 G2 \u6b04\u4f4d\u6578\u503c\u7121\u689d\u4ef6\u6368\u53bb\u5230\u6574\u6578<br><br>=ROUNDDOWN(G2,1)<br>\u8aaa\u660e\uff1a\u5c07 G2 \u6b04\u4f4d\u6578\u503c\u7121\u689d\u4ef6\u6368\u53bb\u53d6\u5230\u5c0f\u6578\u9ede\u5f8c\u7b2c\u4e00\u4f4d<\/td><\/tr><tr><td class=\"has-text-align-center\" data-align=\"center\">ROUNDUP<\/td><td class=\"has-text-align-center\" data-align=\"center\">\u7121\u689d\u4ef6\u9032\u5165<\/td><td class=\"has-text-align-left\" data-align=\"left\">=ROUNDUP(G2,-1)<br>\u8aaa\u660e\uff1a\u5c07 G2 \u6b04\u4f4d\u6578\u503c\u7121\u689d\u4ef6\u9032\u5165\u5230\u5341\u4f4d\u6578<\/td><\/tr><tr><td class=\"has-text-align-center\" data-align=\"center\">VLOOKUP<\/td><td class=\"has-text-align-center\" data-align=\"center\">\u5f80\u53f3\u5c0b\u627e<\/td><td class=\"has-text-align-left\" data-align=\"left\">=VLOOKUP(D2,Sheet2!E:F,2,0)<br>\u8aaa\u660e\uff1a\u4ee5 D \u6b04\u70ba\u4f9d\u64da\uff0c\u5de5\u4f5c\u8868\u4e8c\u7684 E \u6b04\u5230 F \u6b04\u70ba\u5c0d\u61c9\u7bc4\u570d\uff0c\u7576 E \u6b04\u8207 D \u6b04\u5b8c\u5168\u7b26\u5408\u6642\uff0c\u56de\u50b3\u7b2c 2 \u500b\u6b04\u4f4d\uff08\u4e5f\u5c31\u662f F \u6b04\uff09\u7684\u6578\u503c<br>\u767d\u8a71\u8aaa\u660e\uff1a\u4ee5 D \u6b04\u70ba\u4f9d\u64da\uff0c\u56de\u50b3 F \u6b04\u8cc7\u8a0a<br><br> * 0 \u70ba\u5b8c\u5168\u7b26\u5408\uff0c1 \u70ba\u90e8\u4efd\u7b26\u5408<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<div style=\"height:70px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"box\"><strong>\u5ef6\u4f38\u95b1\u8b80\uff1a<a href=\"https:\/\/tinapoint.com\/bps-exam-experience\/\">\u7f8e\u570b\u5c08\u79d1\u85e5\u5e2b\u662f\u4ec0\u9ebc\uff1f\u6211\u7684\u8003\u8a66\u7d93\u9a57\u5206\u4eab\uff08\u6700\u5f8c\u6709\u597d\u5eb7\u5594\uff01\uff09<\/a><\/strong><\/p>\n\n\n\n<div style=\"height:100px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E9%8C%AF%E8%AA%A4%E4%BB%A3%E7%A2%BC%E8%AA%AA%E6%98%8E\"><\/span><strong>\u932f\u8aa4\u4ee3\u78bc\u8aaa\u660e<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<figure class=\"wp-block-table is-style-stripes\"><table><thead><tr><th class=\"has-text-align-center\" data-align=\"center\">\u932f\u8aa4\u503c<\/th><th class=\"has-text-align-left\" data-align=\"left\">\u8aaa\u660e<\/th><\/tr><\/thead><tbody><tr><td class=\"has-text-align-center\" data-align=\"center\">######<\/td><td class=\"has-text-align-left\" data-align=\"left\">\u8868\u793a\u6b04\u4f4d\u5bec\u5ea6\u4e0d\u8db3\uff0c\u7121\u6cd5\u986f\u793a\u6240\u6709\u5167\u5bb9\uff0c\u6216\u5728\u5132\u5b58\u683c\u4e2d\u8f38\u5165\u4e86\u8ca0\u6578\u503c\u7684\u65e5\u671f\u6216\u6642\u9593<\/td><\/tr><tr><td class=\"has-text-align-center\" data-align=\"center\">#DIV\/0<\/td><td class=\"has-text-align-left\" data-align=\"left\">\u9664\u6cd5\u7b97\u5f0f\u4e2d\u9664\u6578\u70ba\u7a7a\u767d\u5132\u5b58\u683c\u6216 0<\/td><\/tr><tr><td class=\"has-text-align-center\" data-align=\"center\">#NAME?<\/td><td class=\"has-text-align-left\" data-align=\"left\">\u51fd\u6578\u540d\u7a31\u4e0d\u6b63\u78ba\uff0c\u6216\u5b57\u4e32\u672a\u4ee5\u62ec\u865f &#8220;\u6846\u4f4f&#8221;<\/td><\/tr><tr><td class=\"has-text-align-center\" data-align=\"center\">#N\/A<\/td><td class=\"has-text-align-left\" data-align=\"left\">\u5fc5\u8981\u7684\u5f15\u6578\u6216\u904b\u7b97\u503c\u672a\u8f38\u5165\uff0c\u6216\u672a\u641c\u5c0b\u5230<\/td><\/tr><tr><td class=\"has-text-align-center\" data-align=\"center\">#NUM<\/td><td class=\"has-text-align-left\" data-align=\"left\">\u6578\u503c\u904e\u5927\u3001\u904e\u5c0f\u6216\u7a7a\u767d\uff0c\u8a08\u7b97\u7d50\u679c\u8d85\u51fa excel \u6240\u80fd\u8655\u7406\u7684\u6578\u503c\u7bc4\u570d\uff0c\u6216\u51fd\u6578\u53cd\u8986\u8a08\u7b97\u591a\u6b21\u7121\u6cd5\u6c42\u5f97\u5176\u503c\u6642<\/td><\/tr><tr><td class=\"has-text-align-center\" data-align=\"center\">#NULL<\/td><td class=\"has-text-align-left\" data-align=\"left\">\u4f7f\u7528\u7684\u53c3\u7167\u904b\u7b97\u5b50\u4e0d\u6b63\u78ba<\/td><\/tr><tr><td class=\"has-text-align-center\" data-align=\"center\">#REF!<\/td><td class=\"has-text-align-left\" data-align=\"left\">\u516c\u5f0f\u4e2d\u53c3\u7167\u7684\u5132\u5b58\u683c\u88ab\u522a\u9664\u6216\u79fb\u52d5<\/td><\/tr><tr><td class=\"has-text-align-center\" data-align=\"center\">#VALUE!<\/td><td class=\"has-text-align-left\" data-align=\"left\">\u5f15\u6578\u5167\u8cc7\u6599\u683c\u5f0f\u4e0d\u6b63\u78ba\uff0c\u4f8b\u5982\u8cc7\u6599\u61c9\u8a72\u70ba\u6578\u503c\u537b\u6307\u5b9a\u70ba\u6587\u5b57\uff0c\u6216\u53ea\u80fd\u6307\u5b9a\u55ae\u4e00\u5132\u5b58\u683c\u537b\u6307\u5b9a\u6210\u5132\u5b58\u683c\u7bc4\u570d&#8230;&#8230;\u7b49<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<div style=\"height:100px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E5%B8%B8%E7%94%A8%E5%9C%96%E8%A1%A8%E7%B9%AA%E8%A3%BD\"><\/span><strong>\u5e38\u7528\u5716\u8868\u7e6a\u88fd<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E7%9B%B4%E6%A2%9D%E5%9C%96%EF%BC%88%E6%A2%9D%E5%BD%A2%E5%9C%96%EF%BC%89\"><\/span><strong>\u76f4\u689d\u5716\uff08\u689d\u5f62\u5716\uff09<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p><strong><span style=\"text-decoration: underline;\">\u7279\u6027\uff1a<\/span><\/strong>\u6700\u5e38\u4f7f\u7528\u7684\u5716\u8868\u985e\u578b\uff0c\u91cf\u5316\u6578\u64da\u9593\u7684\u6bd4\u8f03\u7d50\u679c\uff0c\u4e00\u6bb5\u6642\u9593\u5167\u7684\u6578\u64da\u8b8a\u5316<\/p>\n\n\n\n<p><strong><span style=\"text-decoration: underline;\">\u4f7f\u7528\u6642\u6a5f\uff1a<\/span><\/strong>\u7e6a\u88fd\u4e00\u500b\u6216\u591a\u500b\u8cc7\u6599\u6578\u5217\uff0c\u9700\u91dd\u5c0d\u591a\u500b\u8cc7\u6599\u9805\u76ee\u9032\u884c\u6bd4\u8f03<\/p>\n\n\n\n<p><strong><span style=\"text-decoration: underline;\">\u5e38\u7528\u7684\u5b50\u985e\u578b\u5716\u8868\uff1a<\/span><\/strong>\u7fa4\u7d44\u76f4\u689d\u5716\u3001\u5806\u758a\u76f4\u689d\u5716\u3001\u767e\u5206\u6bd4\u5806\u758a\u76f4\u689d\u5716<\/p>\n\n\n\n<p class=\"box\"><strong>\u6ce8\u610f\uff1a\u4e0d\u8981\u4f7f\u7528\u7acb\u9ad4\u7684\uff0c\u6d6e\u8a87\u4f46\u4e0d\u597d\u95b1\u8b80<\/strong><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img decoding=\"async\" src=\"https:\/\/tinapoint.com\/wp-content\/uploads\/2023\/09\/Excel\u8a9e\u6cd5\u8207\u4f5c\u5716-1.jpg\" alt=\"\" class=\"wp-image-4428\" style=\"width:637px;height:395px\" width=\"637\" height=\"395\" srcset=\"https:\/\/tinapoint.com\/wp-content\/uploads\/2023\/09\/Excel\u8a9e\u6cd5\u8207\u4f5c\u5716-1.jpg 884w, https:\/\/tinapoint.com\/wp-content\/uploads\/2023\/09\/Excel\u8a9e\u6cd5\u8207\u4f5c\u5716-1-300x186.jpg 300w, https:\/\/tinapoint.com\/wp-content\/uploads\/2023\/09\/Excel\u8a9e\u6cd5\u8207\u4f5c\u5716-1-768x476.jpg 768w, https:\/\/tinapoint.com\/wp-content\/uploads\/2023\/09\/Excel\u8a9e\u6cd5\u8207\u4f5c\u5716-1-585x363.jpg 585w\" sizes=\"(max-width: 637px) 100vw, 637px\" \/><figcaption class=\"wp-element-caption\">Excel \u5982\u4f55\u756b\u51fa\u76f4\u689d\u5716<\/figcaption><\/figure><\/div>\n\n\n<p class=\"box\"><strong>Tips\uff1a\u76f4\u689d\u5716\u6700\u65b0\u4e00\u5e74\u8cc7\u6599\uff0c\u53ef\u4ee5\u7528\u6df1\u8272\u8868\u793a\u66f4\u52a0\u660e\u986f<\/strong><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img decoding=\"async\" width=\"481\" height=\"289\" src=\"https:\/\/tinapoint.com\/wp-content\/uploads\/2023\/09\/Excel\u8a9e\u6cd5\u8207\u4f5c\u5716-2.jpg\" alt=\"\" class=\"wp-image-4429\" srcset=\"https:\/\/tinapoint.com\/wp-content\/uploads\/2023\/09\/Excel\u8a9e\u6cd5\u8207\u4f5c\u5716-2.jpg 481w, https:\/\/tinapoint.com\/wp-content\/uploads\/2023\/09\/Excel\u8a9e\u6cd5\u8207\u4f5c\u5716-2-300x180.jpg 300w\" sizes=\"(max-width: 481px) 100vw, 481px\" \/><figcaption class=\"wp-element-caption\">\u6700\u65b0\u4e00\u5e74\u8cc7\u6599\u53ef\u4ee5\u7528\u6df1\u8272<\/figcaption><\/figure><\/div>\n\n\n<div style=\"height:60px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E6%8A%98%E7%B7%9A%E5%9C%96\"><\/span><strong>\u6298\u7dda\u5716<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p><strong><span style=\"text-decoration: underline;\">\u7279\u6027\uff1a<\/span><\/strong>\u770b\u51fa\u4f9d\u6642\u9593\u8b8a\u5316\u7684\u8da8\u52e2\uff0c\u5f37\u8abf\u6642\u9593\u8207\u5404\u9805\u76ee\u7684\u95dc\u4fc2<\/p>\n\n\n\n<p><strong><span style=\"text-decoration: underline;\">\u4f7f\u7528\u6642\u6a5f\uff1a<\/span><\/strong>\u986f\u793a\u4e00\u6bb5\u6642\u9593\u5167\u7684\u9023\u7e8c\u8cc7\u6599\uff0c\u6709\u76f8\u7b49\u9593\u9694\u6642\u9593\u5167\u7684\u8cc7\u6599\uff0cX \u8ef8\u9808\u70ba\u9023\u7e8c\u8cc7\u6599<\/p>\n\n\n\n<p><strong><span style=\"text-decoration: underline;\">\u5e38\u7528\u7684\u5b50\u985e\u578b\u5716\u8868\uff1a<\/span><\/strong>\u6298\u7dda\u5716\u3001\u542b\u6709\u8cc7\u6599\u6a19\u8a18\u7684\u6298\u7dda\u5716<\/p>\n\n\n\n<p class=\"box\"><strong>\u6ce8\u610f\uff1a\u5982\u679c\u592a\u591a\u7d44\u6298\u7dda\u5716\uff0c\u756b\u5728\u540c\u4e00\u5f35\u5716\u6703\u773c\u82b1\u64a9\u4e82\uff0c\u5efa\u8b70\u5206\u958b\u4f5c\u5716<\/strong><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img decoding=\"async\" width=\"481\" height=\"289\" src=\"https:\/\/tinapoint.com\/wp-content\/uploads\/2023\/09\/Excel\u8a9e\u6cd5\u8207\u4f5c\u5716-3.jpg\" alt=\"\" class=\"wp-image-4430\" srcset=\"https:\/\/tinapoint.com\/wp-content\/uploads\/2023\/09\/Excel\u8a9e\u6cd5\u8207\u4f5c\u5716-3.jpg 481w, https:\/\/tinapoint.com\/wp-content\/uploads\/2023\/09\/Excel\u8a9e\u6cd5\u8207\u4f5c\u5716-3-300x180.jpg 300w\" sizes=\"(max-width: 481px) 100vw, 481px\" \/><figcaption class=\"wp-element-caption\">\u773c\u82b1\u64a9\u4e82\u4e86\u55ce\uff1f<\/figcaption><\/figure><\/div>\n\n\n<div style=\"height:60px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E7%B5%84%E5%90%88%E5%9C%96%E4%BB%8B%E7%B4%B9\"><\/span><strong>\u7d44\u5408\u5716\u4ecb\u7d39<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p><strong><span style=\"text-decoration: underline;\">\u7279\u6027\uff1a<\/span><\/strong>\u76f4\u689d\u5716\u8207\u6298\u7dda\u5716\u7684\u7d44\u5408<\/p>\n\n\n\n<p><strong><span style=\"text-decoration: underline;\">\u5efa\u8b70\uff1a<\/span><\/strong>\u9019\u7a2e\u5716\u8868\u5448\u73fe\u4e26\u4e0d\u6613\u95b1\u8b80\uff0c\u5c07\u76f4\u689d\u5716\u8207\u6298\u7dda\u5716\u5206\u958b\u6703\u66f4\u597d<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img decoding=\"async\" width=\"481\" height=\"289\" src=\"https:\/\/tinapoint.com\/wp-content\/uploads\/2023\/09\/Excel\u8a9e\u6cd5\u8207\u4f5c\u5716-4.jpg\" alt=\"\" class=\"wp-image-4431\" srcset=\"https:\/\/tinapoint.com\/wp-content\/uploads\/2023\/09\/Excel\u8a9e\u6cd5\u8207\u4f5c\u5716-4.jpg 481w, https:\/\/tinapoint.com\/wp-content\/uploads\/2023\/09\/Excel\u8a9e\u6cd5\u8207\u4f5c\u5716-4-300x180.jpg 300w\" sizes=\"(max-width: 481px) 100vw, 481px\" \/><figcaption class=\"wp-element-caption\">\u5230\u5e95\u8981\u770b\u5de6\u908a\uff1f\u9084\u662f\u770b\u53f3\u908a\uff1f<\/figcaption><\/figure><\/div>\n\n\n<div style=\"height:60px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E5%9C%93%E5%BD%A2%E9%A4%85%E5%9C%96\"><\/span><strong>\u5713\u5f62(\u9905)\u5716<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p><strong><span style=\"text-decoration: underline;\">\u7279\u6027\uff1a<\/span><\/strong>\u5448\u73fe\u5404\u9805\u76ee\u4f54\u7e3d\u9ad4\u7a4d\u7684\u767e\u5206\u6bd4<\/p>\n\n\n\n<p><strong><span style=\"text-decoration: underline;\">\u4f7f\u7528\u6642\u6a5f\uff1a<\/span><\/strong>\u50c5\u4f7f\u7528\u65bc\u55ae\u4e00\u6578\u5217\uff0c\u8cc7\u6599\u4e2d\u7684\u6578\u503c\u9700\u7686\u70ba\u6b63\u6578\uff0c\u985e\u5225\u7684\u6578\u91cf<strong>\u6700\u591a\u516d\u500b\uff0c<\/strong>\u9805\u76ee\u9700\u7531\u5927\u81f3\u5c0f\u9806\u6642\u9418\u6392\u5217<\/p>\n\n\n\n<p><strong><span style=\"text-decoration: underline;\">\u5e38\u7528\u7684\u5b50\u985e\u578b\u5716\u8868\uff1a<\/span><\/strong>\u4f7f\u7528\u4e00\u822c\u7684\u5713\u9905\u5716\u5c31\u597d\uff0c\u6700\u6613\u8b80<\/p>\n\n\n\n<p class=\"box\"><strong>\u6ce8\u610f\uff1a\u4e0d\u8981\u9078\u5404\u7a2e\u82b1\u4fcf\u7684\u3001\u7acb\u9ad4\u7684\u5713\u9905\u5716\uff0c\u90fd\u4e0d\u5bb9\u6613\u95b1\u8b80<\/strong><\/p>\n\n\n\n<p class=\"box\"><strong>Tips\uff1a\u82e5\u9078\u64c7\u5f69\u8272\u5713\u9905\u5716\uff0c\u300c\u5176\u4ed6\u300d\u9805\u76ee\u4f7f\u7528\u6dfa\u8272<\/strong><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img decoding=\"async\" width=\"1024\" height=\"337\" src=\"https:\/\/tinapoint.com\/wp-content\/uploads\/2023\/09\/Excel\u8a9e\u6cd5\u8207\u4f5c\u5716-6-1024x337.jpg\" alt=\"\" class=\"wp-image-4433\" srcset=\"https:\/\/tinapoint.com\/wp-content\/uploads\/2023\/09\/Excel\u8a9e\u6cd5\u8207\u4f5c\u5716-6-1024x337.jpg 1024w, https:\/\/tinapoint.com\/wp-content\/uploads\/2023\/09\/Excel\u8a9e\u6cd5\u8207\u4f5c\u5716-6-300x99.jpg 300w, https:\/\/tinapoint.com\/wp-content\/uploads\/2023\/09\/Excel\u8a9e\u6cd5\u8207\u4f5c\u5716-6-768x253.jpg 768w, https:\/\/tinapoint.com\/wp-content\/uploads\/2023\/09\/Excel\u8a9e\u6cd5\u8207\u4f5c\u5716-6-585x193.jpg 585w, https:\/\/tinapoint.com\/wp-content\/uploads\/2023\/09\/Excel\u8a9e\u6cd5\u8207\u4f5c\u5716-6.jpg 1126w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><figcaption class=\"wp-element-caption\">\u5713\u9905\u5716\u9805\u76ee\u52ff\u8d85\u904e\u516d\u500b\uff0c\u5176\u4ed6\u9805\u76ee\u53ef\u4ee5\u7528\u6dfa\u8272<\/figcaption><\/figure><\/div>\n\n\n<div style=\"height:60px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E6%9F%8F%E6%8B%89%E5%9C%96%E4%BB%8B%E7%B4%B9%EF%BC%88%E5%93%81%E7%AE%A1%E5%B8%B8%E8%A6%8B%EF%BC%89\"><\/span><strong>\u67cf\u62c9\u5716\u4ecb\u7d39\uff08\u54c1\u7ba1\u5e38\u898b\uff09<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p><strong><span style=\"text-decoration: underline;\">\u7279\u6027\uff1a<\/span><\/strong>\u4e86\u89e3\u54ea\u4e9b\u56e0\u7d20\u5c0d\u7d50\u679c\u7684\u5f71\u97ff\u6700\u5927<\/p>\n\n\n\n<p><strong><span style=\"text-decoration: underline;\">\u4f7f\u7528\u6642\u6a5f\uff1a<\/span><\/strong>\u5927\u6982\u53ea\u6709\u5beb\u54c1\u8cea\u6539\u5584\u5c08\u6848\u6703\u7528\u5230\u9019\u500b\u5716\u5427\uff01<\/p>\n\n\n\n<p><strong><span style=\"text-decoration: underline;\">\u6ce8\u610f\u4e8b\u9805\uff1a<\/span><\/strong><\/p>\n\n\n\n<ol>\n<li>\u9808\u7531\u5927\u5230\u5c0f\u6392\u5217\uff0c\u300c\u5176\u4ed6\u300d\u653e\u6700\u5f8c<\/li>\n\n\n\n<li>\u300c\u5176\u4ed6\u300d\u4e0d\u53ef\u591a\u65bc\u91cd\u9ede\u9805\u76ee\u7684\u6700\u5f8c\u4e00\u9805\uff08\u91cd\u9ede\u9805\u76ee\u610f\u6307\u6703\u5217\u5165\u6539\u5584\u7684\u539f\u56e0\uff09<\/li>\n\n\n\n<li>\u4e3b\u5782\u76f4\u5ea7\u6a19\u8ef8\u6700\u5927\u503c\u70ba\u7e3d\u6a23\u672c\u6578\uff0c\u4e5f\u5c31\u662f\u53f3\u5074\u70ba 100%\uff0c\u5de6\u5074\u70ba\u7e3d\u6578\u91cf\u52a0\u7e3d<\/li>\n\n\n\n<li>\u9069\u7528\u55ae\u9078\u6a23\u672c\u7d71\u8a08<\/li>\n<\/ol>\n\n\n\n<p class=\"box\"><strong>\u63d0\u9192\uff1a\u96d6\u7136\u65b0\u7248 excel \u5efa\u8b70\u5716\u8868\u4e2d\u53ef\u4ee5\u76f4\u63a5\u756b\u67cf\u62c9\u5716\uff0c\u4f46\u662f\u5f88\u591a\u7d30\u7bc0\u4e0d\u7b26\u5408\u570b\u5167\u6bd4\u8cfd\u7684\u898f\u5b9a\uff0c\u6240\u4ee5\u9084\u662f\u5efa\u8b70\u81ea\u5df1\u8a2d\u5b9a\u5716\u8868<\/strong><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img decoding=\"async\" src=\"https:\/\/tinapoint.com\/wp-content\/uploads\/2023\/09\/Excel\u8a9e\u6cd5\u8207\u4f5c\u5716-5.jpg\" alt=\"\" class=\"wp-image-4432\" style=\"width:604px;height:363px\" width=\"604\" height=\"363\" srcset=\"https:\/\/tinapoint.com\/wp-content\/uploads\/2023\/09\/Excel\u8a9e\u6cd5\u8207\u4f5c\u5716-5.jpg 953w, https:\/\/tinapoint.com\/wp-content\/uploads\/2023\/09\/Excel\u8a9e\u6cd5\u8207\u4f5c\u5716-5-300x180.jpg 300w, https:\/\/tinapoint.com\/wp-content\/uploads\/2023\/09\/Excel\u8a9e\u6cd5\u8207\u4f5c\u5716-5-768x461.jpg 768w, https:\/\/tinapoint.com\/wp-content\/uploads\/2023\/09\/Excel\u8a9e\u6cd5\u8207\u4f5c\u5716-5-585x351.jpg 585w\" sizes=\"(max-width: 604px) 100vw, 604px\" \/><\/figure><\/div>\n\n\n<p class=\"box\"><strong>Tips\uff1a\u756b\u597d\u5f8c\u7559\u4e0b\u6a94\u6848\uff0c\u4ee5\u5f8c\u8981\u756b\u65b0\u7684\u67cf\u62c9\u5716\u6539\u5167\u5bb9\u5c31\u597d\uff0c\u4e0d\u7528\u6bcf\u6b21\u90fd\u91cd\u65b0\u8a2d\u5b9a<\/strong><\/p>\n\n\n\n<p>\u8a73\u7d30\u756b\u6cd5\u53c3\u8003<a href=\"https:\/\/www.researchmfg.com\/2021\/02\/excel-pareto-chart\/\" target=\"_blank\" data-type=\"link\" data-id=\"https:\/\/www.researchmfg.com\/2021\/02\/excel-pareto-chart\/\" rel=\"noreferrer noopener\"><span style=\"text-decoration: underline;\">\u9019\u7bc7\u7db2\u7ad9<\/span><\/a><\/p>\n\n\n\n<div style=\"height:60px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"box\"><strong>\u5ef6\u4f38\u95b1\u8b80\uff1a<a href=\"https:\/\/tinapoint.com\/pdca-tool\/\">\u3010\u54c1\u7ba1\u3011\u57f7\u884cPDCA\u55ce\uff1f\u4f60\u9700\u8981\u907f\u514d\u76846\u5927\u4f5c\u5716\u932f\u8aa4<\/a><\/strong><\/p>\n\n\n\n<div style=\"height:60px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E9%9B%B7%E9%81%94%E5%9C%96%EF%BC%88%E5%93%81%E7%AE%A1%E5%B8%B8%E8%A6%8B%EF%BC%89\"><\/span><strong>\u96f7\u9054\u5716<\/strong>\uff08\u54c1\u7ba1\u5e38\u898b\uff09<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p><strong><span style=\"text-decoration: underline;\">\u7279\u6027\uff1a<\/span><\/strong>\u5448\u73fe\u6230\u529b\u5206\u6790\uff0c\u5448\u73fe\u9805\u76ee\u9593\u7684\u5c6c\u6027\u5f37\u5f31<\/p>\n\n\n\n<p><strong><span style=\"text-decoration: underline;\">\u4f7f\u7528\u6642\u6a5f\uff1a<\/span><\/strong>\u5c0d\u6bd4\u591a\u9805\u6307\u6a19\u7684\u8cc7\u6599\u60c5\u6cc1\uff0c\u5e38\u6709 3-6 \u500b\u6307\u6a19\u9805\u76ee<\/p>\n\n\n\n<p><strong><span style=\"text-decoration: underline;\">\u5e38\u7528\u7684\u5b50\u985e\u578b\u5716\u8868\uff1a<\/span><\/strong>\u4f7f\u7528\u4e00\u822c\u7684\u96f7\u9054\u5716\u5c31\u597d\uff0c\u6700\u6613\u8b80<\/p>\n\n\n\n<p class=\"box\"><strong>\u6ce8\u610f\uff1a\u54c1\u7ba1\u756b\u6cd5\u8a18\u5f97\u8981\u52a0\u5916\u5708\uff0c\u81ea\u5df1\u7528\u63d2\u5165\u2192\u5716\u6848\u2192\u5713\u5f62\u7684\u7e6a\u5716\u5de5\u5177\u756b\uff0c\u6309\u4f4f Shift \u53ef\u4ee5\u756b\u51fa\u6b63\u5713\u5f62<\/strong><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img decoding=\"async\" src=\"https:\/\/tinapoint.com\/wp-content\/uploads\/2023\/09\/Excel\u8a9e\u6cd5\u8207\u4f5c\u5716-7.jpg\" alt=\"\" class=\"wp-image-4427\" style=\"width:380px;height:242px\" width=\"380\" height=\"242\" srcset=\"https:\/\/tinapoint.com\/wp-content\/uploads\/2023\/09\/Excel\u8a9e\u6cd5\u8207\u4f5c\u5716-7.jpg 446w, https:\/\/tinapoint.com\/wp-content\/uploads\/2023\/09\/Excel\u8a9e\u6cd5\u8207\u4f5c\u5716-7-300x191.jpg 300w\" sizes=\"(max-width: 380px) 100vw, 380px\" \/><figcaption class=\"wp-element-caption\">\u54c1\u7ba1\u756b\u6cd5\u8a18\u5f97\u8981\u6709\u5916\u5708\uff0c\u4e2d\u9593\u7684\u6578\u5b57\u662f\u5e73\u5747\u503c\u4e0d\u662f\u7e3d\u6578<\/figcaption><\/figure><\/div>\n\n\n<div style=\"height:70px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"box\"><strong>\u5ef6\u4f38\u95b1\u8b80\uff1a<a href=\"https:\/\/tinapoint.com\/hfmea\/\">\u3010\u54c1\u7ba1\u3011HFMEA\u624b\u6cd5\u4ecb\u7d39\uff1a5\u5927\u6b65\u9a5f\u6539\u5584\u9ad8\u98a8\u96aa\u6d41\u7a0b<\/a><\/strong><\/p>\n\n\n\n<div style=\"height:100px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E7%B5%90%E8%AA%9E\"><\/span><strong>\u7d50\u8a9e<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>\u6709\u597d\u7528\u7684\u8a9e\u6cd5\u4e5f\u6b61\u8fce\u7559\u8a00\uff0c\u4e4b\u5f8c\u9678\u7e8c\u65b0\u589e\u5230\u6587\u7ae0\u88e1\uff0c\u9700\u8981\u67e5\u8a62\u6642\u4f86\u9019\u88e1\u627e\u5c31\u597d\u56c9\uff5e<\/p>\n\n\n\n<div style=\"height:100px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<div class=\"wp-block-group box\"><div class=\"wp-block-group__inner-container is-layout-constrained wp-block-group-is-layout-constrained\">\n<p>\u4f60\u662f\u91ab\u9662\u85e5\u5e2b\u6216\u8b77\u7406\u5e2b\u55ce\uff1f<\/p>\n\n\n\n<p>\u6642\u5e38\u9047\u5230\u75c5\u4eba\u8981\u7d66\u8a31\u591a\u91dd\u5291\u85e5\u54c1\uff0c\u7919\u65bc\u7ba1\u8def\u4e0d\u5920\u9700\u8981\u540c\u6642\u7d66\u85e5 &#8230;&#8230;<\/p>\n\n\n\n<p>\u537b\u4e0d\u77e5\u9053\u9019\u4e9b\u85e5\u7269\u53ef\u4e0d\u53ef\u4ee5\u65c1\u63d2\u4f7f\u7528\u55ce\uff1f<\/p>\n\n\n\n<p>\u5225\u64d4\u5fc3\uff01<\/p>\n\n\n\n<p>\u5c0f\u6db5\u85e5\u5e2b\u6574\u7406\u4e86\u4f4f\u9662\u75c5\u4eba\u5e38\u7528\u7684\u91dd\u5291\u76f8\u5bb9\u6027\u901f\u67e5\u8868\uff0c\u6b61\u8fce\u9ede\u64ca\u4e0b\u5716\u7d22\u53d6\u5594\uff01<\/p>\n<\/div><\/div>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/subscribepage.io\/EPTKCz\" target=\"_blank\" rel=\"noopener\"><img decoding=\"async\" width=\"1024\" height=\"574\" src=\"https:\/\/tinapoint.com\/wp-content\/uploads\/2023\/04\/\u91dd\u5291\u76f8\u5bb9\u6027\u901f\u67e5\u8868\u5927\u5716-1024x574.png\" alt=\"\" class=\"wp-image-3721\" srcset=\"https:\/\/tinapoint.com\/wp-content\/uploads\/2023\/04\/\u91dd\u5291\u76f8\u5bb9\u6027\u901f\u67e5\u8868\u5927\u5716-1024x574.png 1024w, https:\/\/tinapoint.com\/wp-content\/uploads\/2023\/04\/\u91dd\u5291\u76f8\u5bb9\u6027\u901f\u67e5\u8868\u5927\u5716-300x168.png 300w, https:\/\/tinapoint.com\/wp-content\/uploads\/2023\/04\/\u91dd\u5291\u76f8\u5bb9\u6027\u901f\u67e5\u8868\u5927\u5716-768x431.png 768w, https:\/\/tinapoint.com\/wp-content\/uploads\/2023\/04\/\u91dd\u5291\u76f8\u5bb9\u6027\u901f\u67e5\u8868\u5927\u5716-585x328.png 585w, https:\/\/tinapoint.com\/wp-content\/uploads\/2023\/04\/\u91dd\u5291\u76f8\u5bb9\u6027\u901f\u67e5\u8868\u5927\u5716.png 1038w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/subscribepage.io\/o1gTEc\" target=\"_blank\" rel=\"noreferrer noopener\"><img decoding=\"async\" width=\"1024\" height=\"573\" src=\"https:\/\/tinapoint.com\/wp-content\/uploads\/2023\/04\/\u91ab\u85e5\u7b46\u8a18\u6587\u7ae0\u5927\u5716-1024x573.png\" alt=\"\" class=\"wp-image-3722\" srcset=\"https:\/\/tinapoint.com\/wp-content\/uploads\/2023\/04\/\u91ab\u85e5\u7b46\u8a18\u6587\u7ae0\u5927\u5716-1024x573.png 1024w, https:\/\/tinapoint.com\/wp-content\/uploads\/2023\/04\/\u91ab\u85e5\u7b46\u8a18\u6587\u7ae0\u5927\u5716-300x168.png 300w, https:\/\/tinapoint.com\/wp-content\/uploads\/2023\/04\/\u91ab\u85e5\u7b46\u8a18\u6587\u7ae0\u5927\u5716-768x430.png 768w, https:\/\/tinapoint.com\/wp-content\/uploads\/2023\/04\/\u91ab\u85e5\u7b46\u8a18\u6587\u7ae0\u5927\u5716-585x327.png 585w, https:\/\/tinapoint.com\/wp-content\/uploads\/2023\/04\/\u91ab\u85e5\u7b46\u8a18\u6587\u7ae0\u5927\u5716.png 1038w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>\u5728\u91ab\u9662\u5de5\u4f5c\uff0c\u8d85\u7d1a\u591a\u6587\u66f8\u8655\u7406\u5de5\u4f5c\uff0cexcel \u662f\u6bcf\u5929\u90fd\u8981\u7528\u7684\u5de5\u5177\uff0c\u6240\u4ee5\u6700\u8fd1\u4e0a\u4e86 excel \u5165\u9580\u8207\u5716\u8868\u7e6a\u88fd\u8ab2\uff0c\u89ba\u5f97\u771f\u7684\u592a\u5be6\u7528\u4e86\uff01\u60f3\u628a\u5e38\u7528\u7684\u8a9e\u6cd5\u529f\u80fd\u597d\u597d\u6574\u7406\uff0c\u4ee5\u5f8c\u5c31\u4e0d\u7528 google\uff0c\u4f86\u9019\u7bc7\u6587\u7ae0\u627e\u5c31\u597d\u5566\uff01<\/p>\n","protected":false},"author":1,"featured_media":4434,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_lmt_disableupdate":"","_lmt_disable":"","footnotes":""},"categories":[114],"tags":[119,113],"table_tags":[],"modified_by":"\u5c0f\u6db5\u85e5\u5e2b","_links":{"self":[{"href":"https:\/\/tinapoint.com\/wp-json\/wp\/v2\/posts\/4403"}],"collection":[{"href":"https:\/\/tinapoint.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tinapoint.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tinapoint.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/tinapoint.com\/wp-json\/wp\/v2\/comments?post=4403"}],"version-history":[{"count":1,"href":"https:\/\/tinapoint.com\/wp-json\/wp\/v2\/posts\/4403\/revisions"}],"predecessor-version":[{"id":4441,"href":"https:\/\/tinapoint.com\/wp-json\/wp\/v2\/posts\/4403\/revisions\/4441"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/tinapoint.com\/wp-json\/wp\/v2\/media\/4434"}],"wp:attachment":[{"href":"https:\/\/tinapoint.com\/wp-json\/wp\/v2\/media?parent=4403"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tinapoint.com\/wp-json\/wp\/v2\/categories?post=4403"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tinapoint.com\/wp-json\/wp\/v2\/tags?post=4403"},{"taxonomy":"table_tags","embeddable":true,"href":"https:\/\/tinapoint.com\/wp-json\/wp\/v2\/table_tags?post=4403"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}