{"id":6758,"date":"2024-07-28T18:01:01","date_gmt":"2024-07-28T10:01:01","guid":{"rendered":""},"modified":"2024-07-28T18:01:01","modified_gmt":"2024-07-28T10:01:01","slug":"excel100\u4e2a\u5e38\u7528\u6280\u5de7_excel\u638c\u63e127\u4e2a\u6280\u5de7","status":"publish","type":"post","link":"https:\/\/mushiming.com\/6758.html","title":{"rendered":"excel100\u4e2a\u5e38\u7528\u6280\u5de7_excel\u638c\u63e127\u4e2a\u6280\u5de7"},"content":{"rendered":"<div id=\"js_content\">\n<p style=\"text-align: left\"><img decoding=\"async\" src=\"https:\/\/imgconvert.csdnimg.cn\/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy90WFlpY3Q0MHhmTGhXS0poM2JpYW90VDQ1SldxWWliSjF3VXAzVVFNenBZTmFVQnJjZ1EzVFRHaWFYZnY3NW03R0pMbndvcFliUmlhUnFtRlRBWmE3NmlhOUtUUS82NDA\" =\"\" =\"\" alt=\"excel100\u4e2a\u5e38\u7528\u6280\u5de7_excel\u638c\u63e127\u4e2a\u6280\u5de7 (https:\/\/mushiming.com\/)  \u7b2c1\u5f20\" title=\"excel100\u4e2a\u5e38\u7528\u6280\u5de7_excel\u638c\u63e127\u4e2a\u6280\u5de7  \u7b2c1\u5f20-\u7a46\u4e16\u660e\u535a\u5ba2\" ><\/p>\n<p style=\"text-align: right\">\u8def\u4e0a\u7684\u4f60\uff5c\u4f5c\u8005<\/p>\n<p style=\"text-align: right\">\u77e5\u4e4e\uff5c\u6765\u6e90<\/p>\n<hr>\n<p><strong><span title=\"\">1<\/span><\/strong><\/p>\n<p><strong>excel\u5224\u65ad\u5206\u6570\u6210\u7ee9\u662f\u5426\u53ca\u683c\uff0c\u600e\u4e48\u505a?<\/strong><\/p>\n<p>\u7b54\uff1aexcel\u5224\u65ad\u5206\u6570\u6210\u7ee9\u662f\u5426\u53ca\u683c\u53ef\u4ee5\u7528IF\u8fdb\u884c\u533a\u95f4\u5224\u65ad\u3002<\/p>\n<p>=IF(A1&gt;60,\"\u53ca\u683c\",\"\u4e0d\u53ca\u683c\")<\/p>\n<p><strong><span title=\"\">2<\/span><\/strong><\/p>\n<p><strong>excel\u9891\u7387\u7edf\u8ba1\u7528\u4ec0\u4e48\u51fd\u6570?<\/strong><\/p>\n<p>\u7b54\uff1aFREQUENCY\u4ee5\u4e00\u5217\u5782\u76f4\u6570\u7ec4\u8fd4\u56de\u67d0\u4e2a\u533a\u57df\u4e2d\u6570\u636e\u7684\u9891\u7387\u5206\u5e03\uff0c\u5177\u4f53\u7528\u6cd5\u56de\u590dfrequency\u6216 \u9891\u7387\u67e5\u770b\u793a\u4f8b\u3002<\/p>\n<p><strong><span title=\"\">3<\/span><\/strong><\/p>\n<p><strong>excel\u4ec0\u4e48\u65f6\u5019\u8981\u7528$\u7b26\u53f7\u5462?<\/strong><\/p>\n<p>\u7b54\uff1a\u590d\u5236\u516c\u5f0f\u65f6\uff0c\u5355\u5143\u683c\u7684\u5f15\u7528\u4f4d\u7f6e\u4e0d\u60f3\u53d1\u751f\u53d8\u5316\u65f6\uff0c\u5c31\u5728\u884c\u53f7\u6216\u5217\u6807\u524d\u52a0$\uff0c\u4e86\u89e3\u8be6\u60c5\u56de\u590d \u201c\u7edd\u5bf9\u5f15\u7528\u201d\u67e5\u770b\u6559\u7a0b<\/p>\n<p><strong><span title=\"\">4<\/span><\/strong><\/p>\n<p><strong>\u5408\u5e76\u5355\u5143\u683c\u540e\u91cc\u9762\u7684\u6570\u636e\u6216\u6587\u5b57\u6211\u90fd\u60f3\u4fdd\u7559\u5982\u4f55\u5904\u7406?<\/strong><\/p>\n<p>\u7b54\uff1a\u591a\u4e2a\u5355\u5143\u683c\u90fd\u542b\u6709\u5185\u5bb9\uff0c\u5982\u679c\u8981\u5728\u5408\u5e76\u540e\u4fdd\u7559\u6240\u6709\u5355\u5143\u683c\u7684\u5185\u5bb9\uff0c\u53ef\u4ee5\u7528\u4e0b\u9762\u7684\u65b9\u6cd5\u3002<\/p>\n<ul>\n<li>\n<p>\u9009\u53d6\u5355\u5143\u683c\u533a\u57df\uff0c\u5e76\u628a\u5217\u5bbd\u62c9\u5230\u53ef\u4ee5\u5bb9\u4e0b\u6240\u6709\u5355\u5143\u683c\u5408\u5e76\u540e\u7684\u5bbd\u5ea6\u3002<\/p>\n<\/li>\n<li>\n<p>\u5f00\u59cb\u9009\u9879\u5361 - \u7f16\u8f91 - \u4e24\u7aef\u5bf9\u9f50\u3002\u628a\u591a\u4e2a\u5355\u5143\u683c\u7684\u5185\u5bb9\u5408\u5e76\u5230\u4e00\u4e2a\u5355\u5143\u683c\u4e2d<\/p>\n<\/li>\n<li>\n<p>\u5728\u5206\u9694\u7684\u7a7a\u9694\u5904\u6309alt+enter\u952e\u6dfb\u52a0\u5f3a\u5236\u6362\u884c\u7b26\uff0c\u6362\u884c\u3002<\/p>\n<\/li>\n<li>\n<p>\u518d\u5408\u5e76\u5355\u5143\u683c<\/p>\n<\/li>\n<\/ul>\n<p><strong><span title=\"\">5<\/span><\/strong><\/p>\n<p><strong>\u63d2\u5165\u8868\u683c\u540e\u53d1\u73b0\u884c\u6570\u4e0d\u591f\uff0c\u600e\u6837\u624d\u80fd\u518d\u6b21\u5feb\u901f\u63d2\u5165\u66f4\u591a\u884c?<\/strong><\/p>\n<p>\u7b54\uff1a\u9700\u8981\u63d2\u5165\u591a\u5c11\u884c\u5c31\u9009\u53d6\u591a\u5c11\u884c\uff0c\u7136\u540e\u5c31\u4f1a\u4e00\u6b21\u63d2\u5165\u591a\u5c11\u7a7a\u884c<\/p>\n<p><strong><span title=\"\">6<\/span><\/strong><\/p>\n<p><strong>\u5982\u4f55\u590d\u5236\u7c98\u8d34\u884c\u5bbd<\/strong><\/p>\n<p>\u7b54\uff1a\u7c98\u8d34\u540e\u7684\u7c98\u8d34\u9009\u9879\u4e2d\uff0c\u4f1a\u6709 \u4fdd\u7559\u6e90\u5217\u5bbd\u7684\u9009\u9879\u3002\u5982\u4e0b\u56fe\u6240\u793a<\/p>\n<p><strong><span title=\"\">7<\/span><\/strong><\/p>\n<p><strong>Excel\u5982\u4f55\u628a\u6570\u503c\u6279\u91cf\u8f6c\u6362\u6210\u6587\u672c<\/strong><\/p>\n<p>\u7b54\uff1a\u6570\u636e - \u5206\u5217 - \u7b2c\u4e09\u6b65\u9009\u6587\u672c<\/p>\n<p><strong><span title=\"\">8<\/span><\/strong><\/p>\n<p><strong>Excel\u5982\u4f55\u628a\u7a7a\u503c\u5168\u90e8\u586b\u5199\u4e3a\u201c0\u201c<\/strong><\/p>\n<p>\u7b54\uff1a\u5b9a\u4f4d - \u6761\u4ef6 - \u7a7a\u503c - \u5728\u7f16\u8f91\u680f\u4e2d\u8f93\u5165 0\uff0c\u6309 ctrl+enter\u5b8c\u6210\u8f93\u5165<\/p>\n<p><strong><span title=\"\">9<\/span><\/strong><\/p>\n<p><strong>Excel2010\u7684\u63d2\u5165\u7279\u6b8a\u7b26\u53f7\u5728\u54ea\u91cc?<\/strong><\/p>\n<p>excel2010\u7248\u672c\u7684\u7279\u6b8a\u7b26\u53f7, \u5f88\u591a\u540c\u5b66\u5728\u641c\u8fd9\u4e2a\u95ee\u9898 \uff0c\u53ef\u4ee5\u80af\u5b9a\u7684\u8bf4excel2010\u7248\u672c\u91cc\u6ca1\u6709\u8fd9\u4e2a\u547d\u4ee4\u7684\u3002\u5927\u5bb6\u4e0d\u7528\u518d\u8d39\u5fc3\u627e\u4e86\uff0c\u5982\u679c\u8981\u63d2\u5165\u7b26\u53f7\uff0c\u53ef\u4ee5\u4ece\u63d2\u5165\u9009\u9879\u5361 - \u7b26\u53f7 \u91cc\u627e\u627e\u3002\u5728\u5fae\u4fe1\u5e73\u53f0\u56de\u590d\u201c\u7279\u6b8a\u7b26\u53f7\u201d\u53ef\u4ee5\u67e5\u770b\u66f4\u591a\u7b26\u53f7\u8f93\u5165\u65b9\u6cd5<\/p>\n<p><strong><span title=\"\">10<\/span><\/strong><\/p>\n<p><strong>Excel\u5982\u4f55\u53bb\u6389\u5730\u5740\u680f\u7684\u540d\u79f0<\/strong><\/p>\n<p>excel\u5982\u4f55\u53bb\u6389\u5730\u5740\u680f\u7684\u540d\u79f0\uff0cexcel2003\u7248\uff0c\u63d2\u5165\u83dc\u5355 - \u540d\u79f0 - \u5b9a\u4e49 - \u5728\u5f39\u51fa\u7684\u7a97\u53e3\u627e\u5230\u8be5\u540d\u79f0 \u70b9\u5220\u9664\u6309\u94ae \uff0c2010\u7248\uff0c\u516c\u5f0f\u9009\u9879\u5361 - \u540d\u79f0\u7ba1\u7406\u5668 -\u627e\u5230\u540d\u79f0\u70b9\u5220\u9664<\/p>\n<p><strong><span title=\"\">11<\/span><\/strong><\/p>\n<p><strong>\u5982\u4f55\u6309\u65e5\u671f\u663e\u793a\u661f\u671f?<\/strong><\/p>\n<p>\u95ee\uff1aexcel\u5982\u4f55\u6309\u65e5\u671f\u663e\u793a\u6210\u661f\u671f<\/p>\n<p>\u7b54\uff1a\u516c\u5f0f<\/p>\n<p>=TEXT(A2,\"aaaa\")<\/p>\n<p>=WEEKDAY(A2,2)<\/p>\n<p>\u4e5f\u53ef\u4ee5\u901a\u8fc7\u683c\u5f0f\u8bbe\u7f6e\u628a\u65e5\u671f\u663e\u793a\u6210\u661f\u671f<\/p>\n<p><strong><span title=\"\">12<\/span><\/strong><\/p>\n<p><strong>Excel\u5982\u4f55\u9690\u85cf\u516c\u5f0f?<\/strong><\/p>\n<p>\u5728excel\u91cc\uff0c\u5982\u4f55\u9690\u85cf\u516c\u5f0f\uff0c\u8ba9\u516c\u5f0f\u522b\u4eba\u770b\u4e0d\u5230\u5462?<\/p>\n<p>\u7b54\uff1a\u5728excel\u91cc\u9690\u85cf\u516c\u5f0f\u662f\u901a\u8fc7\u8bbe\u7f6e\u5355\u5143\u683c\u683c\u5f0f\u8bbe\u7f6e\u7684\u3002<\/p>\n<p>\u9009\u53d6\u516c\u5f0f\u6240\u5728\u5355\u5143\u683c\uff0c\u53f3\u952e\u83dc\u5355\u4e2d\u70b9\u8bbe\u7f6e\u5355\u5143\u683c\u683c\u5f0f\uff0c\u7136\u540e\u5728\u5f39\u51fa\u7684\u5355\u5143\u683c\u683c\u5f0f\u7a97\u53e3\u70b9\u4fdd\u62a4\u9009\u9879\u5361\uff0c\u52fe\u9009\u9690\u85cf\u516c\u5f0f\u9009\u9879\u3002<\/p>\n<p>\u6700\u540e\u901a\u8fc7\u5de5\u5177 - \u4fdd\u62a4 -\u4fdd\u62a4\u5de5\u4f5c\u8868(excel2010\u91cc\u662f\u901a\u8fc7 \u5ba1\u9605 - \u4fdd\u62a4\u5de5\u4f5c\u8868)\u3002\u7136\u540e\u5728\u5355\u5143\u683c\u6216\u7f16\u8f91\u680f\u91cc\u5c31\u770b\u4e0d\u5230\u516c\u5f0f\u4e86\u3002<\/p>\n<p><strong><span title=\"\">13<\/span><\/strong><\/p>\n<p><strong>Excel\u8868\u683c\u4e2d\u4e0b\u62c9\u590d\u5236\u6570\u5b57\u600e\u4e48\u624d\u80fd\u9012\u589e?<\/strong><\/p>\n<p>\u7b54\uff1a\u590d\u5236\u6570\u5b57\u65f6\uff0c\u53ea\u9700\u8981\u6309ctrl\u952e\u518d\u4e0b\u62c9\uff0c\u6570\u5b57\u5c31\u4f1a\u53d1\u751f\u53d8\u5316\u4e86\u3002<\/p>\n<p><strong><span title=\"\">14<\/span><\/strong><\/p>\n<p><strong>Excel\u4e2d\u5e73\u65b9\u51fd\u6570\u662f\u54ea\u4e2a?<\/strong><\/p>\n<p>excel\u4e2d\u5e73\u65b9\u51fd\u6570\u662f\u54ea\u4e2a?<\/p>\n<p>\u5728excel\u4e2d\u6211\u4eec\u6709\u65f6\u9700\u8981\u8ba1\u7b97\u4e00\u4e2a\u6570\u7684\u5e73\u65b9\uff0c\u8be5\u600e\u4e48\u8ba1\u7b97\u5462\uff0cexcel\u63d0\u4f9b\u4e86\u4e24\u79cd\u65b9\u6cd5<\/p>\n<p><strong>\uff081\uff09\u4f7f\u7528\u8131\u5b57\u8282\u7b26\u53f7^<\/strong><\/p>\n<p>\u4f8b 3\u76842\u6b21\u65b9\u53ef\u4ee5\u5199\u6210 =3^2 \u7ed3\u679c\u662f9<\/p>\n<p><strong>\uff082\uff09\u4f7f\u7528\u5e73\u65b9\u51fd\u6570<\/strong><\/p>\n<p>=POWER(3,2) \u8868\u793a3\u76842\u6b21\u65b9\uff0c\u5982\u679c\u662f4\u76843\u6b21\u65b9\u53ef\u4ee5\u5199\u4e3a=POWER(4,3)<\/p>\n<p><strong><span title=\"\">15<\/span><\/strong><\/p>\n<p><strong>Excel\u5408\u5e76\u5355\u5143\u683c\u590d\u5236\u516c\u5f0f\u600e\u64cd\u4f5c\u5440<\/strong><\/p>\n<p>excel\u8868\u683c\u4e2d\uff0c\u5982\u679c\u60f3\u5728\u5408\u5355\u5143\u683c\u4e2d\u590d\u5236\u516c\u5f0f\uff0c\u4f1a\u63d0\u793a\u5927\u5c0f\u4e00\u6837\u4e2d\u65ad\u4f60\u7684\u590d\u5236\uff0c\u8fd9\u65f6\u5019\u6211\u4eec\u53ef\u4ee5\u7528\u5feb\u6377\u952e\u586b\u5145\u516c\u5f0f\u3002<\/p>\n<p>\u9009\u4e2d\u6240\u6709\u5305\u542b\u5408\u5e76\u5355\u5143\u683c\u7684\u533a\u57df(\u7b2c\u4e00\u4e2a\u5355\u5143\u683c\u8981\u542b\u516c\u5f0f)\uff0c\u53cc\u51fb\u7f16\u8f91\u680f\u4e2d\u516c\u5f0f\uff0c\u7136\u540e\u6309ctrl+\u56de\u8f66\u952e\u586b\u5145\u5373\u53ef\u3002<\/p>\n<p><strong><span title=\"\">16<\/span><\/strong><\/p>\n<p><strong>Excel\u6570\u5b57\u4e0d\u80fd\u6c42\u548c\uff0c\u600e\u4e48\u529e?<\/strong><\/p>\n<p>\u6570\u636e\u5bfc\u5165Excel\u4e2d\u540e\u5c45\u7136\u662f\u4ee5\u6587\u672c\u5f62\u5f0f\u5b58\u5728\u7684(\u6570\u5b57\u9ed8\u8ba4\u662f\u53f3\u5bf9\u9f50\uff0c\u800c\u6587\u672c\u662f\u5de6\u5bf9\u9f50\u7684)\uff0c\u5373\u4f7f\u662f\u91cd\u65b0\u8bbe\u7f6e\u5355\u5143\u683c\u683c\u5f0f\u4e3a\u6570\u5b57\u4e5f\u65e0\u6d4e\u4e8e\u4e8b\u3002<\/p>\n<p>\u4e0b\u9762\u7684\u65b9\u6cd5\u53ef\u4ee5\u5e2e\u4f60\u5feb\u901f\u8f6c\u6362\u6210\u53ef\u4ee5\u8ba1\u7b97\u7684\u6570\u5b57\uff0c\u9009\u53d6\u6570\u5b57\u533a\u57df\uff0c\u7b2c\u4e00\u4e2a\u5355\u5143\u683c\u4e00\u5b9a\u662f\u5305\u62ec\u6570\u5b57\u7684\uff0c\u800c\u4e14\u5355\u5143\u683c\u5de6\u4e0a\u65b9\u6709\u7eff\u4e09\u89d2\uff0c\u9009\u53d6\u540e\u6253\u5f00\u7eff\u4e09\u89d2\uff0c\u70b9\u8f6c\u6362\u4e3a\u6570\u5b57\u3002\u5982\u4e0b\u56fe\u6240\u793a<\/p>\n<p><strong><span title=\"\">17<\/span><\/strong><\/p>\n<p><strong>Excel\u4ea7\u751f\u968f\u673a\u6570,\u600e\u4e48\u505a?<\/strong><\/p>\n<p>\u7b54\uff1aexcel\u63d0\u4f9b\u4e86\u4e00\u4e2a\u53ef\u4ee5\u751f\u6210\u968f\u673a\u6570\u7684\u51fd\u6570rand\uff0c\u7528\u5b83\u53ef\u4ee5\u751f\u6210\u6307\u5b9a\u8303\u56f4\u7684\u968f\u673a\u6570<\/p>\n<p>=rand()*(\u6700\u5927\u6570-\u6700\u5c0f\u6570)+\u6700\u5c0f\u6570\u3002\u6bd4\u5982\u751f\u6210 10~100\u4e4b\u95f4\u7684\u968f\u673a\u6570=rand()*90+10<\/p>\n<p>\u5982\u679c\u8981\u751f\u6210\u968f\u673a\u7684\u6574\u6570\u5462=int(rand()*90+10 ) \u4e5f\u53ef\u4ee5\u7528=RANDBETWEEN(1,100)<\/p>\n<p><strong><span title=\"\">18<\/span><\/strong><\/p>\n<p><strong>Excel\u4e2d\u5982\u4f55\u5f00\u6839\u53f7<\/strong><\/p>\n<p>\u95ee\uff1aexcel\u91cc\u5f00\u6839\u53f7\u600e\u4e48\u505a\uff0c\u4f8b\u5982 9\u5f002\u6b21\u65b9\uff0c\u7ed3\u679c\u662f3<\/p>\n<p>\u7b54\uff1a\u5728excel\u91cc\u5f00\u6839\u53f7\u53ef\u4ee5\u7528^\u7b26\u53f7\u5b8c\u6210\uff0c\u5982<\/p>\n<p>9^(1\/2)\u7684\u7ed3\u679c\u662f3<\/p>\n<p><strong><span title=\"\">19<\/span><\/strong><\/p>\n<p><strong>Excel\u7b5b\u9009\u7528\u4e0d\u4e86<\/strong><\/p>\n<p>\u95ee\uff1a\u5728excel\u4e2d\u4f7f\u7528\u81ea\u52a8\u7b5b\u9009\u65f6\uff0c\u53ef\u7528\u4e0d\u4e86\u4e86\uff0c\u600e\u4e48\u56de\u4e8b?<\/p>\n<p>\u7b54\uff1a\u5bfc\u81f4\u7b5b\u9009\u65e0\u6cd5\u4f7f\u7528\u6709\u5f88\u591a\u539f\u56e0\uff0c\u6700\u5e38\u89c1\u7684\u539f\u56e0\u662f\u5de5\u4f5c\u8868\u6216\u5de5\u4f5c\u7c3f\u88ab\u4fdd\u62a4\u4e86\uff0c\u4f60\u53ef\u4ee5\u68c0\u67e5\u4e00\u4e0b\u662f\u4e0d\u662f\u5de5\u4f5c\u8868\u6dfb\u52a0\u4e86\u4fdd\u62a4\u5bc6\u7801\u3002<\/p>\n<p><strong><span title=\"\">20<\/span><\/strong><\/p>\n<p><strong>\u56db\u5206\u4e4b\u4e00\u600e\u4e48\u6253<\/strong><\/p>\n<p>\u7b54\uff1a\u5148\u8f93\u51650 \u7136\u540e\u518d\u8f93\u5165\u7a7a\u683c\uff0c\u518d\u8f93\u51651\/4\u3002<\/p>\n<p><strong><span title=\"\">21<\/span><\/strong><\/p>\n<p><strong>Excel\u4e2d\u5982\u4f55\u9650\u5236\u4f7f\u7528\u7b5b\u9009\u6309\u94ae<\/strong><\/p>\n<p>\u7b54\uff1aexcel\u4e2d\u5982\u4f55\u9650\u5236\u4f7f\u7528\u7b5b\u9009\u6309\u94ae\u5462?\u7b54\u6848\u53ef\u80fd\u51fa\u4e4e\u5927\u5bb6\u7684\u610f\u6599\u4e4b\u5916\uff0c\u5982\u679c\u4f60\u662fEXCEL2003\u7684\u7528\u6237\uff0c\u53ef\u4ee5\u6267\u884c\uff1a\u5de5\u5177\u83dc\u5355 - \u9009\u9879 - \u89c6\u9891 - \u5bf9\u8c61\u9009\u62e9\u5168\u90e8\u4e0d\u663e\u793a\uff0c\u4f60\u518d\u770b\u770b\u81ea\u52a8\u7b5b\u9009\u5df2\u5148\u6cd5\u518d\u4f7f\u7528\u4e86\u3002<\/p>\n<p><strong><span title=\"\">22<\/span><\/strong><\/p>\n<p><strong>Excel\u5076\u6570\u884c\u600e\u4e48\u9009\u53d6\u548c\u5220\u9664?<\/strong><\/p>\n<p>\u7b54\uff1aexcel\u9009\u53d6\u5076\u6570\u884c\u6709\u5f88\u591a\u65b9\u6cd5\uff0c\u4f46\u6700\u597d\u7684\u65b9\u6cd5\u8fd8\u662f\u8f85\u52a9\u5217+\u81ea\u52a8\u7b5b\u9009\u65b9\u6cd5\u3002\u5177\u4f53\u7684\u6b65\u9aa4\u4e3a<\/p>\n<ul>\n<li>\n<p>\u5728\u6700\u540e\u7684\u8f85\u52a9\u5217\u4e2d\uff0c\u57282\u884c\u8f93\u5165\u6570\u5b571\uff0c\u9009\u53d61\u884c\u548c2\u884c\u5411\u4e0b\u62d6\u52a8\u590d\u5236\uff0c\u590d\u5236\u540e\u8f85\u52a9\u5217\u7684\u5076\u6570\u884c\u4e3a\u586b\u5145\u62101\u3002<\/p>\n<\/li>\n<li>\n<p>\u7b5b\u9009 - \u81ea\u52a8\u7b5b\u9009\uff0c\u9009\u53d6\u503c\u4e3a1\u7684\u884c\u3002<\/p>\n<\/li>\n<li>\n<p>\u9009\u53d6\u6240\u6709\u663e\u793a\u7684\u5076\u6570\u884c\u533a\u57df\u3002<\/p>\n<\/li>\n<\/ul>\n<p>\u5982\u679c\u662f\u5220\u9664\u5076\u6570\u884c\uff0c\u76f4\u63a5\u5220\u9664\u7b5b\u9009\u51fa\u7684\u5076\u6570\u884c\u5373\u53ef\u3002<\/p>\n<p><strong><span title=\"\">23<\/span><\/strong><\/p>\n<p><strong>EXCEL\u91cc\u9690\u85cf\u7684\u7b2c\u4e00\u884c\u663e\u793a\u51fa\u6765<\/strong><\/p>\n<p>\u7b54\uff1a\u9009\u53d6\u7b2c\u4e8c\u884c\uff0c\u7136\u540e\u62d6\u52a8\u5411\u4e0a\u9009\u53d6\uff0c\u53d6\u6d88\u9690\u85cf,\u6216\u8005 \u5168\u9009\uff0c\u683c\u5f0f - \u884c - \u53d6\u6d88\u9690\u85cf<\/p>\n<p><strong><span title=\"\">24<\/span><\/strong><\/p>\n<p><strong>Excel\u6253\u5f00\u9ed8\u8ba4\u8bbe\u7f6e\u621003\u7248\uff0c\u5982\u679c\u505a<\/strong><\/p>\n<p>\u8bbe\u7f6e\u9ed8\u8ba4\u6253\u5f0003\u7248\u7684\u65b9\u6cd5\uff1b<\/p>\n<p>\u5230excel 2003\u7684\u5b89\u88c5\u76ee\u5f55\uff0c\u628a03\u7248\u7684excel.exe \u6539\u6210excel2003.exe\uff0c\u7136\u540e\u5c31\u53ef\u4ee5\u6309\u6b63\u5e38\u7684\u65b9\u6cd5\u8bbe\u7f6e\u9ed8\u8ba4\u6253\u5f00excel \u6587\u4ef6\u4e3a03\u7248\u7684<\/p>\n<p><strong><span title=\"\">25<\/span><\/strong><\/p>\n<p><strong>Excel\u8868\u683c\u8ba1\u7b97\u516c\u5f0f\u4e0d\u80fd\u7528\u4e86<\/strong><\/p>\n<p>\u8868\u683c\u4e2d\u7684\u516c\u5f0f\u4ecd\u7136\u5b58\u5728\uff0c\u4f46\u662f\u66f4\u6539\u4e86\u5176\u4e2d\u4e00\u4e2a\u5355\u5143\u683c\u7684\u6570\u5b57\uff0c\u5176\u516c\u5f0f\u7ed3\u679c\u600e\u4e48\u4e0d\u53d8\u4e86\u5462?\u5c31\u662f\u4e24\u4e24\u76f8\u4e58\u7684\u516c\u5f0f\uff0c\u4e4b\u524d\u90fd\u662f\u81ea\u52a8\u66f4\u65b0\u51fa\u7ed3\u679c\uff0c\u73b0\u5728\u4e0d\u5f97\u884c\u4e86\uff0c\u8f93\u5165\u65b0\u7684\u6570\u5b57\uff0c\u4ecd\u7136\u662f\u539f\u6765\u7684\u7ed3\u679c<\/p>\n<p>\u7b54\uff1a\u5de5\u5177\u83dc\u5355 - \u9009\u9879 - \u91cd\u65b0\u8ba1\u7b97 \u4f60\u770b\u770b\u662f\u624b\u52a8\u8fd8\u662f\u81ea\u52a8<\/p>\n<p><strong><span title=\"\">26<\/span><\/strong><\/p>\n<p><strong>Excel\u6bcf\u9875\u663e\u793a\u8868\u5934\uff0c\u600e\u4e48\u8bbe\u7f6e?<\/strong><\/p>\n<p>\u95ee\uff1a\u5728\u6253\u5f00\u8868\u683c\u65f6\uff0c\u56e0\u4e3a\u8868\u683c\u6bd4\u8f83\u957f\uff0c\u600e\u4e48\u5728\u6bcf\u4e00\u9875\u7684\u6700\u4e0a\u9762\u8bbe\u7f6e\u8868\u5934\u3002<\/p>\n<p>\u7b54\uff1a\u5728EXCEL\u6253\u5370\u9884\u89c8\u89c6\u56fe\u4e2d\uff0c\u6253\u5f00\u201c\u9875\u9762\u8bbe\u7f6e\u201d\u5bf9\u8bdd\u6846\u4e2d\u7684\u201c\u5de5\u4f5c\u8868\u201d\u6807\u7b7e\uff0c\u5355\u51fb\u201c\u9876\u7aef\u6807\u9898\u884c\u201d\u6587\u672c\u6846\u53f3\u4fa7\u7684[\u538b\u7f29\u5bf9\u8bdd\u6846]\u6309\u94ae\uff0c\u9009\u5b9a\u8868\u5934\u548c\u9876\u7aef\u6807\u9898\u6240\u5728\u7684\u5355\u5143\u683c\u533a\u57df\uff0c\u518d\u5355\u51fb\u8be5\u6309\u94ae\u8fd4\u56de\u5230\u201c\u9875\u9762\u8bbe\u7f6e\u201d\u5bf9\u8bdd\u6846\uff0c\u5355\u51fb[\u786e\u5b9a]\u6309\u94ae\u3002<\/p>\n<p><strong><span title=\"\">27<\/span><\/strong><\/p>\n<p><strong>Excel\u591a\u6761\u4ef6\u6c42\u548c\u51fd\u6570\u6709\u54ea\u4e9b<\/strong><\/p>\n<p>\u5728EXCEL\u91cc\uff0c\u6709\u54ea\u4e9b\u51fd\u6570\u53ef\u4ee5\u5b8c\u6210\u591a\u6761\u4ef6\u6c42\u548c\u5462?SUMIF\u51fd\u6570\u548cCOUNTIF\u51fd\u6570\u7528\u6cd5\u5dee\u4e0d\u591a.\u591a\u6761\u4ef6\u7684\u5904\u7406\u65b9\u6cd5\u5982\u4e0b:<\/p>\n<ul>\n<li>\n<p>\u591a\u9879\u76ee\u6c42\u548c<\/p>\n<p>=SUM(SUMIF(B31:B35,{\"A\",\"C\"},C31:C35))<\/p>\n<\/li>\n<li>\n<p>03\u7248\u672c\u53ef\u4ee5\u7528SUMPRODUCT\u51fd\u6570\u66ff\u4ee3.<\/p>\n<p>=SUMPRODUCT((MONTH(A3:A9)=3)*(B3:B9=\"A\")*C3:C9)<\/p>\n<\/li>\n<li>\n<p>07\u7248\u672c\u53ef\u4ee5\u7528SUMIFS\u66ff\u6362:<\/p>\n<p>=SUMIFS(D2:D11,A2:A11,\"\u516c\u53f81\",B2:B11,\"\u4eba\u4e8b\u90e8\")<\/p>\n<\/li>\n<li>\n<p>\u591a\u6761\u4ef6\u6c47\u603b\uff0c\u4e5f\u53ef\u4ee5\u7528SUMPRODUCT\u51fd\u6570\u5b8c\u6210\u3002<\/p>\n<p>=SUMPRODUCT(\u6761\u4ef61 *\u6761\u4ef62*\u6761\u4ef63*\u6570\u636e\u5217)<\/p>\n<p>=sumproduct((a1:a10=\"\u8d22\u52a1\")*(b1:b10=\"\u51fa\u7eb3\")*c1:c10)\u2018\u7edf\u8ba1A\u5217\u662f\u8d22\u52a1\uff0c\u540c\u65f6B\u5217\u662f\u51fa\u7eb3\u7684C\u5217\u6570\u636e\u4e4b\u548c<\/p>\n<\/li>\n<\/ul>\n<p><strong><span title=\"\">28<\/span><\/strong><\/p>\n<p><strong>\u600e\u4e48\u8ba1\u7b97\u4e24\u65e5\u671f\u76f8\u9694\u591a\u5c11\u6708\u96f6\u591a\u5c11\u5929?<\/strong><\/p>\n<p>\u5728excel\u91cc\u8ba1\u7b97\u600e\u4e48\u8ba1\u7b97\u4e24\u65e5\u671f\u76f8\u9694\u591a\u5c11\u6708\u96f6\u591a\u5c11\u5929,\u53ef\u4ee5\u7528DATE\u548cDATEDIF\u51fd\u6570\u914d\u5408\u7740\u8ba1\u7b97\u3002\u6bd4\u5982A1\u662f\u5f00\u59cb\u65e5\u671f\uff0cB1\u662f\u7ed3\u679c\u65e5\u671f\uff0cC1\u662f\u76f8\u9694\u591a\u5c11\u6708\uff0c\u53ef\u4ee5\u8fd9\u6837\u8bbe\u7f6e\u516c\u5f0f<\/p>\n<p>=DATEDIF(A2,B2,\"M\")<\/p>\n<p>D1\u76f8\u9694C1\u6708\u8fd8\u96f6\u591a\u5c11\u5929\uff0c\u53ef\u4ee5\u8fd9\u6837\u8bbe\u7f6e\u516c\u5f0f<\/p>\n<p>=B2-DATE(YEAR(A2),MONTH(A2)+C2,DAY(A2))<\/p>\n<p><strong><span title=\"\">29<\/span><\/strong><\/p>\n<p><strong>Excel\u8868\u683c\u5185\u5982\u4f55\u6362\u884c?<\/strong><\/p>\n<p>\u95ee\uff1a\u6211\u60f3\u5728excel\u5355\u5143\u683c\u4e2d\u8f93\u5165\u6587\u672c\u65f6\uff0c\u600e\u4e48\u6362\u5230\u4e0b\u4e00\u884c\u5462?\u7b54\uff1aexcel\u5355\u5143\u683c\u5185\u6362\u884c\u53ef\u4ee5\u7528\u63d2\u5165\u6362\u884c\u7b26\u7684\u65b9\u6cd5\u3002\u6bd4\u5982\u8981\u8f93\u5165\u4e2d\u56fd \u7136\u540e\u6362\u4e0b\u4e00\u884c \u6cb3\u5357\u3002<\/p>\n<ul>\n<li>\n<p>\u8f93\u5165\u201c\u4e2d\u56fd\u201d\uff0c\u6309ATL+\u56de\u8f66\u952e\u540e\u6362\u5230\u4e0b\u9762\u4e00\u884c<\/p>\n<\/li>\n<li>\n<p>\u8f93\u5165\u6cb3\u5357<\/p>\n<\/li>\n<\/ul>\n<p><strong><span title=\"\">30<\/span><\/strong><\/p>\n<p><strong>Excel\u8868\u683c\u600e\u4e48\u5f00\u6839\u53f7?<\/strong><\/p>\n<p>\u7b54\uff1a\u5728excel\u91cc\u5f00\u6839\u53f7\u53ef\u4ee5\u7528\u4e58\u65b9\u6765\u8fd0\u7b97\uff0c\u53ef\u80fd\u5927\u5bb6\u5f88\u7591\u60d1\uff0c\u5f00\u6839\u53f7\u600e\u4e48\u7528\u4e58\u65b9\u7684\u7b97\u5f0f\u5462?<\/p>\n<p>\u539f\u6765\u5728EXCEL\u91cc\uff0c\u53ef\u4ee5\u7528^\u6570\u5b57\u6765\u8868\u793a\u4e58\u65b9\u8fd0\u7b97\uff0c\u59823^2\uff0c\u8868\u793a3\u76842\u6b21\u65b9\uff0c\u7ed3\u679c\u4e3a9\uff0c\u800c\u5982\u679c^\u540e\u7684\u6570\u5b57\u662f\u5206\u6570\u5219\u53ef\u4ee5\u8fdb\u884c\u5f00\u65b9\u8fd0\u7b97\u3002<\/p>\n<p>\u5982\uff1a9^(1\/2)\u5c31\u53ef\u4ee5\u8fd0\u7b979\u7684\u5f00\u65b9\u3002\u7ed3\u679c\u4e3a3<\/p>\n<p><strong><span title=\"\">31<\/span><\/strong><\/p>\n<p><strong>\u5e73\u65b9\u7c73(M2)\u7b26\u53f7\u600e\u4e48\u6253?<\/strong><\/p>\n<p>\u7b54\uff1a\u5728excel\u91cc\uff0c\u8f93\u5165\u5e73\u65b9\u7c73\u7b26\u53f7\u53ef\u4ee5\u5148\u8f93\u5165M2\uff0c\u7136\u540e\u9009\u4e2d2\uff0c\u6309CTRL+1\u6253\u5f00\u5355\u5143\u683c\u8bbe\u7f6e\u5bf9\u8bdd\u6846\uff0c\u7136\u540e\u52fe\u9009\u4e0a\u6807\u3002<\/p>\n<p><strong><span title=\"\">32<\/span><\/strong><\/p>\n<p><strong>Excel\u6587\u4ef6\u6253\u5f00\u4e71\u7801\u600e\u4e48\u529e?<\/strong><\/p>\n<p>\u7b54\uff1aExcel\u6587\u4ef6\u6709\u6253\u5f00\u4f1a\u51fa\u73b0\u4e00\u4e9b\u4e71\u7801\u6587\u5b57\uff0c\u8fd9\u65f6\u5019\u8be5\u600e\u4e48\u529e\u5462?\u4e0b\u9762\u662f\u641c\u96c6\u81ea\u7f51\u7edc\u7684\u4e00\u4e9b\u89e3\u51b3\u65b9\u6cd5\uff0c\u5e0c\u671b\u80fd\u5bf9\u5927\u5bb6\u6709\u7528\u3002<\/p>\n<p><strong>\u62db\u6570\u4e00\uff1a\u5c06\u5de5\u4f5c\u7c3f\u53e6\u5b58\u4e3aSYLK\u683c\u5f0f<\/strong><\/p>\n<p>\u5982\u679cExcel\u6587\u4ef6\u80fd\u591f\u6253\u5f00\uff0c\u90a3\u4e48\u5c06\u5de5\u4f5c\u7c3f\u8f6c\u6362\u4e3aSYLK\u683c\u5f0f\u53ef\u4ee5\u7b5b\u9009\u51fa\u6587\u6863\u7684\u635f\u574f\u90e8\u5206\uff0c\u7136\u540e\u518d\u4fdd\u5b58\u6570\u636e\u3002<\/p>\n<p>\u9996\u5148\uff0c\u6253\u5f00\u9700\u8981\u7684\u5de5\u4f5c\u7c3f\u3002\u5728\u201c\u6587\u4ef6\u201d\u83dc\u5355\u4e2d\uff0c\u5355\u51fb\u201c\u53e6\u5b58\u4e3a\u201d\u547d\u4ee4\u3002\u5728\u201c\u4fdd\u5b58\u7c7b\u578b\u201d\u5217\u8868\u4e2d\uff0c\u5355\u51fb\u201cSYLK(\u7b26\u53f7\u8fde\u63a5)(*.slk)\u201d\uff0c\u7136\u540e\u5355\u51fb\u201c\u4fdd\u5b58\u201d\u6309\u94ae\u3002\u5173\u95ed\u76ee\u524d\u5f00\u542f\u7684\u6587\u4ef6\u540e\uff0c\u6253\u5f00\u521a\u624d\u53e6\u5b58\u7684SYLK\u7248\u672c\u5373\u53ef\u3002<\/p>\n<p><strong>\u62db\u6570\u4e8c\uff1a\u8f6c\u6362\u4e3a\u8f83\u65e9\u7684\u7248\u672c<\/strong><\/p>\n<p>\u5982\u679c\u7531\u4e8e\u542f\u52a8\u6545\u969c\u800c\u6ca1\u6709\u4fdd\u5b58Excel\u5de5\u4f5c\u7c3f\uff0c\u5219\u6700\u540e\u4fdd\u5b58\u7684\u7248\u672c\u53ef\u80fd\u4e0d\u4f1a\u88ab\u635f\u574f\u3002\u5f53\u7136\uff0c\u8be5\u7248\u672c\u4e0d\u5305\u62ec\u6700\u540e\u4e00\u6b21\u4fdd\u5b58\u540e\u5bf9\u6587\u6863\u6240\u4f5c\u7684\u66f4\u6539\u3002<\/p>\n<p>\u5173\u95ed\u6253\u5f00\u7684\u5de5\u4f5c\u7c3f\uff0c\u5f53\u7cfb\u7edf\u8be2\u95ee\u662f\u5426\u4fdd\u5b58\u66f4\u6539\u65f6\uff0c\u5355\u51fb\u201c\u5426\u201d\u3002\u5728\u201c\u6587\u4ef6\u201d\u83dc\u5355\u4e2d\uff0c\u5355\u51fb\u201c\u6253\u5f00\u201d\u547d\u4ee4\uff0c\u53cc\u51fb\u8be5\u5de5\u4f5c\u7c3f\u6587\u4ef6\u5373\u53ef\u3002<\/p>\n<p><strong>\u62db\u6570\u4e09\uff1a\u6253\u5f00\u5e76\u4fee\u590d\u5de5\u4f5c\u7c3f<\/strong><\/p>\n<p>\u5982\u679cExcel\u6587\u4ef6\u6839\u672c\u4e0d\u80fd\u591f\u4f7f\u7528\u5e38\u89c4\u65b9\u6cd5\u6253\u5f00\uff0c\u90a3\u4e48\u53ef\u4ee5\u5c1d\u8bd5Excel 2003\u4e2d\u7684\u201c\u6253\u5f00\u5e76\u4fee\u590d\u201d\u529f\u80fd\uff0c\u8be5\u529f\u80fd\u53ef\u4ee5\u68c0\u67e5\u5e76\u4fee\u590dExcel\u5de5\u4f5c\u7c3f\u4e2d\u7684\u9519\u8bef\u3002<\/p>\n<p>\u5728\u201c\u6587\u4ef6\u201d\u83dc\u5355\u4e2d\uff0c\u5355\u51fb\u201c\u6253\u5f00\u201d\u547d\u4ee4\u3002\u901a\u8fc7\u201c\u67e5\u627e\u8303\u56f4\u201d\u6846\uff0c\u5b9a\u4f4d\u5e76\u6253\u5f00\u5305\u542b\u53d7\u635f\u6587\u6863\u7684\u6587\u4ef6\u5939\uff0c\u9009\u62e9\u8981\u6062\u590d\u7684\u6587\u4ef6\u3002\u5355\u51fb\u201c\u6253\u5f00\u201d\u6309\u94ae\u65c1\u8fb9\u7684\u7bad\u5934\uff0c\u7136\u540e\u5355\u51fb\u201c\u6253\u5f00\u5e76\u4fee\u590d\u201d\u5373\u53ef\u3002<\/p>\n<p><strong>\u62db\u6570\u56db\uff1a\u7528Excel\u67e5\u770b\u7a0b\u5e8f\u6253\u5f00\u5de5\u4f5c\u7c3f<\/strong><\/p>\n<p>\u5728\u7528\u5c3d\u5404\u79cd\u65b9\u6cd5\u4ecd\u4e0d\u80fd\u89e3\u51b3\u95ee\u9898\u7684\u60c5\u51b5\u4e0b\uff0c\u5927\u5bb6\u4e0d\u59a8\u8003\u8651\u4e00\u4e0b\u4f7f\u7528\u7b2c\u4e09\u65b9\u8f6f\u4ef6\u5f00\u5c55\u6062\u590d\u5de5\u4f5c.\u4e0b\u9762\u7684\u94fe\u63a5\u662f\u4e00\u4e2a\u7ecf\u8fc7\u5b9e\u9645\u68c0\u9a8c\u7684Excel\u6062\u590d\u8f6f\u4ef6\uff0c\u4f60\u53ef\u4ee5\u901a\u8fc7\u6b64\u8f6f\u4ef6\u8fbe\u5230\u6062\u590d\u60a8Excel\u6570\u636e\u7684\u76ee\u7684\u3002<\/p>\n<p>\u5e0c\u671b\u5927\u5bb6\u90fd\u80fd\u89e3\u51b3\u8fd9\u4e2a\u6587\u4ef6\u4e71\u7801\u7684\u95ee\u9898\u3002<\/p>\n<p><strong><span title=\"\">33<\/span><\/strong><\/p>\n<p><strong>Excel\u5982\u4f55\u51bb\u7ed3\u7a97\u683c<\/strong><\/p>\n<p>\u4f8b\uff1a\u4f60\u8981\u51bb\u7ed3\u524d\u4e09\u884c\u524d\u4e24\u884c\uff0c\u90a3\u4e48\u4f60\u53ef\u4ee5\u9009\u4e2dC4\u5355\u5143\u683c\uff0c\u7136\u540e\u6267\u884c\u7a97\u53e3(excel2010\u7248 \u89c6\u56fe) - \u51bb\u7ed3\u7a97\u683c<\/p>\n<p><strong><span title=\"\">34<\/span><\/strong><\/p>\n<p><strong>SUMIF\u51fd\u6570\u662f\u6613\u5931\u6027\u51fd\u6570\u5417?<\/strong><\/p>\n<p>\u7b54\uff1aSUMIF\u51fd\u6570\u672c\u8eab\u4e0d\u662f\u6613\u5931\u6027\u51fd\u6570\uff0c\u4f46\u5f53SUMIF\u7b2c\u4e00\u4e2a\u53c2\u6570\u548c\u7b2c\u4e09\u4e2a\u53c2\u6570\u533a\u57df\u5927\u5c0f\u4e0d\u81f4\u65f6\uff0c\u4f1a\u6709\u6613\u5931\u6027\u51fd\u6570\u7684\u7279\u5f81\u3002\u4e0d\u4fee\u6539\u6570\u636e\u4e5f\u4f1a\u5728\u5173\u95ed\u65f6\u63d0\u793a\u6587\u4ef6\u662f\u5426\u4fdd\u5b58<\/p>\n<p><strong><span title=\"\">35<\/span><\/strong><\/p>\n<p><strong>\u5982\u4f55\u66f4\u6539Excel\u64a4\u9500\u6b21\u6570?<\/strong><\/p>\n<p>\u5230\u6ce8\u518c\u8868(\u4e0d\u77e5\u9053\uff0c\u5728\u5f00\u59cb\u8fd0\u884c\u91cc\u8f93\u5165regedit\u56de\u8f66\u5373\u53ef)<\/p>\n<p>\u5230\u4ee5\u4e0b\u4f4d\u7f6e!!!!\u6211\u7684\u662foffice2003!!!!\u572811.0\u5904\u53ef\u80fd\u6709\u6240\u4e0d\u540c!<\/p>\n<p>[HKEY_CURRENT_USER\\Software\\Microsoft\\Office\\11.0\\Excel\\Options]<\/p>\n<p>\u65b0\u5efadword\u503c \u952e\u540d\u4e3aUndoHistory (\u53cc\u51fb\u540d\u79f0)\u503c\u4e3a10\u8fdb\u5236\uff0c\u8f93\u5165\u6570\u503c\u4e3a30\u3002\u5373\u53ef<\/p>\n<p><strong><span title=\"\">36<\/span><\/strong><\/p>\n<p><strong>Excel\u5982\u4f55\u6253\u5370\u4e0d\u8fde\u7eed\u533a\u57df<\/strong><\/p>\n<p>\u7b54\uff1a\u6309CTRL\u952e\u4e0d\u677e\uff0c\u9009\u53d6\u533a\u57df\uff0c\u518d\u70b9\u6587\u4ef6\u83dc\u5355\u4e2d\u7684\u6253\u5370\u533a\u57df--\u8bbe\u7f6e\u6253\u5370\u533a\u57df<\/p>\n<p><strong><span title=\"\">37<\/span><\/strong><\/p>\n<p><strong>Excel\u4e07\u5143\u663e\u793a\u5982\u4f55\u8bbe\u7f6e?<\/strong><\/p>\n<p>\u5143 \u752816\u4e07\u5143\u8868\u793a \u5982\u4f55\u8bbe\u7f6e<\/p>\n<p>\u6211\u7406\u89e3!\u7684\u4f5c\u7528\u662f\u628a\u540e\u9762\u7684\u8fd9\u4e2a\u5b57\u7b26\u4f5c\u4e3a\u7b26\u53f7\u5904\u7406\uff0c\u6362\u53e5\u8bdd\u8bf4\uff1a<\/p>\n<blockquote>\n<p>#!.0,\u4e07\u5143 \u548c #\".\"0,\u4e07\u5143 \u8fd9\u4e24\u79cd\u5199\u6cd5\u7684\u4f5c\u7528\u3001\u610f\u4e49\u90fd\u662f\u5b8c\u5168\u76f8\u540c\u7684<\/p>\n<p>\u8f93\u51653451 \u663e\u793a3#451 \u5355\u5143\u683c\u683c\u5f0f\u600e\u6837\u8bbe\u5b9a<\/p>\n<p>\u81ea\u5b9a\u4e49\u683c\u5f0f\uff1a0!#000<\/p>\n<p>\u4e5f\u53ef\u4ee50\"#\"000<\/p>\n<\/blockquote>\n<p><strong><span title=\"\">38<br \/><\/span><\/strong><\/p>\n<p><strong>VLOOKUP(B3,IF({1,0}\u662f\u4ec0\u4e48\u610f\u601d?<\/strong><\/p>\n<p>=VLOOKUP(B3,IF({1,0},G$3:G$5,F$3:F$5),2,0)<\/p>\n<p>\u516c\u5f0f\u4e2d\u7684 IF({1,0},G$3:G$15,F$3:F$15)\u4f5c\u4f55\u89e3\u91ca?<\/p>\n<p>\u7406\u89e3:{1,0}\u7684\u542b\u4e49\u662f1\u4ee3\u8868TRUE(\u5373\u903b\u8f91\u503c\u4e3a\u771f),0\u4ee3\u8868FALSE(\u5373\u903b\u8f91\u503c\u4e3a\u5047),\u516c\u5f0f\u4e3a<\/p>\n<p>=VLOOKUP(B3,IF({TRUE,FALSE},G3:G17,F3:F17),2,0)\u4e5f\u540c\u6837\u6b63\u786e,\u8fd9\u6837\u66f4\u597d\u7406\u89e3.\u901a\u8fc7\u6267\u884cIF({TRUE,FALSE},G3:G17,F3:F17)\u4e3a\u771f,\u5f97\u5230G3:G17\u8fd9\u5217\u6570,\u7531\u4e8e\u662f\u6570\u7ec4,\u518d\u6267\u884cFALSE\u5f97\u5230F3:F17,\u56e0\u6b64\u5f97\u5230\u4e00\u4e2a2\u5217\u591a\u884c\u7684\u6570\u7ec4\u3002<\/p>\n<p><strong><span title=\"\">39<\/span><\/strong><\/p>\n<p><strong>Excel\u5bc6\u7801\u5fd8\u8bb0\u4e86\u600e\u4e48\u529e?\u51c9\u62cc?<\/strong><\/p>\n<p>\u5982\u679cexcel\u5bc6\u7801\u5fd8\u8bb0\u4e86\uff0c\u4e0d\u8981\u6025\u3002\u53ef\u4ee5\u7528officekey\u5de5\u5177\u89e3\u9664\u5bc6\u7801\u3002<\/p>\n<p>\u5de5\u4f5c\u7c3f\u5bc6\u7801\uff0c\u5de5\u4f5c\u8868\u5bc6\u7801\u548cVBA\u5bc6\u7801\u90fd\u53ef\u4ee5\u89e3<\/p>\n<p><strong><span title=\"\">40<\/span><\/strong><\/p>\n<p><strong>Excel\u9875\u7709\u9875\u811a\u600e\u4e48\u8bbe\u7f6e?<\/strong><\/p>\n<p>\u7b54\uff1a\u8bbe\u7f6eexcel\u7684\u9875\u7709\u9875\u811a\u7684\u65b9\u6cd5\u662f\uff1a<\/p>\n<p>excel2003\u4e2d\uff0c\u6587\u4ef6\u83dc\u5355 - \u9875\u9762\u8bbe\u7f6e - \u9875\u7709\/\u9875\u811a \u9009\u9879\u5361\u4e2d<\/p>\n<p>excel2007\u548cexcel2016\u4e2d\uff0c\u9875\u9762\u5e03\u5c40\u9009\u9879\u5361 - \u6253\u5370\u6807\u9898 - \u9875\u7709\/\u9875\u811a \u9009\u9879\u5361\u4e2d<\/p>\n<p><strong><span title=\"\">41<\/span><\/strong><\/p>\n<p><strong>Excel\u5206\u7c7b\u6c47\u603b\uff0c\u5982\u4f55\u505a?<\/strong><\/p>\n<p>\u7b54\uff1aexcel\u5206\u7c7b\u6c47\u603b\u662f\u4e00\u4e2a\u7b80\u5355\u5b9e\u7528\u7684\u6570\u636e\u6c47\u603b\u5de5\u5177\u3002\u5148\u5bf9\u5355\u5143\u683c\u8fdb\u884c\u6392\u5e8f,\u7136\u540e\u6267\u884c\u6570\u636e\u83dc\u5355-\u5206\u7c7b\u6c47\u603b\u5c31OK\u4e86.\u5177\u4f53\u7684\u5236\u505a\u65b9\u6cd5<\/p>\n<p><strong><span title=\"\">42<\/span><\/strong><\/p>\n<p><strong>Excel\u9501\u5b9a\u5355\u5143\u683c\u4e0d\u8ba9\u7f16\u8f91\u600e\u4e48\u505a<\/strong><\/p>\n<p>\u7b54\uff1a\u9ed8\u8ba4\u72b6\u6001\u4e0b\uff0cexcel\u5355\u5143\u683c\u662f\u9501\u5b9a\u72b6\u6001\u3002\u4f46\u4e3a\u4ec0\u4e48\u9501\u5b9a\u8fd8\u53ef\u4ee5\u7f16\u8f91\u5462\u3002\u56e0\u4e3a\u5c11\u4e86\u4e00\u6b65\u4fdd\u62a4\u5de5\u4f5c\u8868\uff0c\u4fdd\u62a4\u5de5\u4f5c\u8868\u540e\uff0c\u5c31\u65e0\u6cd5\u518d\u7f16\u8f91\u5355\u5143\u683c\u4e86\u3002<\/p>\n<p>\u4e5f\u8bb8\u4f60\u4f1a\u95ee\uff0c\u6211\u60f3\u8ba9\u7f16\u8f91\u5176\u4e2d\u4e00\u90e8\u5206\u5355\u5143\u683c\u600e\u4e48\u529e?\u51c9\u62cc\uff0c\u53ea\u9700\u8981\u628a\u9700\u8981\u7f16\u8f91\u7684\u901a\u8fc7\u53f3\u952e--\u8bbe\u7f6e\u5355\u5143\u683c\u683c\u5f0f--\u4fdd\u62a4--\u53bb\u6389\u9501\u5b9a\u524d\u7684\u52fe\u5373\u53ef\u3002<\/p>\n<p><strong><span title=\"\">43<\/span><\/strong><\/p>\n<p><strong>Excel\u6253\u4e0d\u5f00\u600e\u4e48\u529e?<\/strong><\/p>\n<p>\u7b54\uff1aexcel\u6587\u4ef6\u6253\u4e0d\u5f00\uff0c\u539f\u56e0\u6709\u5f88\u591a\u79cd\u3002<\/p>\n<ul>\n<li>\n<p>\u6587\u4ef6\u635f\u574f\u3002\u8fd9\u65f6\u53ea\u6709\u627e\u4e00\u4e9b\u4e13\u4e1a\u4fee\u590d\u8f6f\u4ef6\u624d\u53ef\u4ee5\u3002<\/p>\n<\/li>\n<li>\n<p>\u52a0\u8f7d\u5b8f\u6587\u4ef6\uff0c\u52a0\u8f7d\u5b8f\u6587\u4ef6\u662f\u9690\u85cf\u7a97\u53e3\u7684\u3002\u53ef\u4ee5\u52a0\u8f7d\u5b8f\u6587\u4ef6xla\u6216xlam\u6539\u4e3a\u6b63\u5e38\u7684xls\u6587\u4ef6\u548cxlsx\u6587\u4ef6\u5c31\u53ef\u4ee5\u6253\u5f00\u4e86\u3002<\/p>\n<\/li>\n<li>\n<p>\u6253\u5f00\u6587\u4ef6\u770b\u4e0d\u5230excel\u754c\u9762\u3002\u8fd9\u65f6\u53ef\u4ee5\u5c1d\u8bd5\u901a\u8fc7\u5de5\u5177\u680f\u4e2d\u7684\u6253\u5f00\u547d\u4ee4\u6253\u5f00EXCEL\u6587\u4ef6\u3002\u7136\u540e\u901a\u8fc7\u201c\u5de5\u5177--\u9009\u9879--\u5728\u9009\u9879\u7a97\u53e3\u4e2d\u7684\u5e38\u89c4\u9009\u9879\u5361\u4e2d\u9009\u53d6\u201c\u5ffd\u7565\u5176\u4ed6\u5e94\u7528\u7a0b\u5e8f\u201d\u540e\uff0c\u5c31\u53ef\u4ee5\u6b63\u5e38\u6253\u5f00EXCEL\u6587\u4ef6\u4e86<\/p>\n<\/li>\n<\/ul>\n<p><strong><span title=\"\">44<\/span><\/strong><\/p>\n<p><strong>excel\u7edf\u8ba1\u4e2a\u6570\u600e\u4e48\u505a?<\/strong><\/p>\n<p>\u7b54\uff1a\u5728excel\u4e2d\u7edf\u8ba1\u4e2a\u6570\u53ef\u4ee5\u5206\u4ee5\u4e0b\u51e0\u79cd\u60c5\u51b5\uff1a<\/p>\n<ul>\n<li>\n<p>\u7edf\u8ba1\u975e\u7a7a\u5355\u5143\u683c\u4e2a\u6570;=COUNTA(A1:A1000)<\/p>\n<\/li>\n<li>\n<p>\u7edf\u8ba1\u6570\u5b57\u4e2a\u6570;=counta(a1:a1000)<\/p>\n<\/li>\n<li>\n<p>\u6839\u636e\u6761\u4ef6\u7edf\u8ba1\u4e2a\u6570: =countif(a1:a1000,\"&gt;100\")<\/p>\n<\/li>\n<\/ul>\n<p>\u5e94\u7528\u793a\u4f8b\uff1a<\/p>\n<p>\u4f8b1\uff1a\u7edf\u8ba1\u5728A\u5217\u662f\u201c\u516c\u53f8A\u201d\u7684\u4e2a\u6570<\/p>\n<p>\u516c\u5f0f=Countif(A:A,\"\u516c\u53f8A\")<\/p>\n<p>\u4f8b2\uff1a\u7edf\u8ba1A\u5217\u5305\u542b\u201c\u516c\u53f8A\u201d\u7684\u4e2a\u6570<\/p>\n<p>\u516c\u5f0f=Countif(A:A,\"*\u516c\u53f8A*\")<\/p>\n<p>\u6ce8\uff1a\u8fd9\u91cc\u4f7f\u7528\u901a\u914d*\u8868\u793a\u5b57\u7b26\u524d\u540e\u6709\u4efb\u610f\u4e2a\u5b57\u7b26\u3002<\/p>\n<p>\u4f8b3\uff1a\u7edf\u8ba1C\u5217\u6210\u7ee9\u5927\u4e8e60\u7684\u5b66\u751f\u4e2a\u6570<\/p>\n<p>\u516c\u5f0f =Countif(C\uff1aC,\"&gt;60\")<\/p>\n<p>\u6ce8\uff1a\u8fd9\u91cc\u662f\u7528\u8fd0\u7b97\u5bf9\u6bd4\u7b26\u53f7\u548c\u6570\u5b57\u6784\u6210\u7684\u6761\u4ef6<\/p>\n<p>\u4f8b4\uff1a\u7edf\u8ba1\u5927\u4e8eC1\u5355\u5143\u683c\u6570\u503c\u7684C\u5217\u4e2a\u6570\u3002<\/p>\n<p>\u516c\u5f0f\uff1a=Countif(c:c,\"&gt;\" &amp; c1)<\/p>\n<p>\u6ce8\uff1a\u8fd9\u91cc\u662f\u7528&amp;\u63d2\u5165\u4e86\u4e00\u4e2a\u53d8\u91cf\uff0c\u5373C1\u7684\u503c\u3002<\/p>\n<p>\u4f8b5\uff1a\u7edf\u8ba1C\u5217\u5927\u4e8e\u5e73\u5747\u6570\u7684\u4e2a\u6570<\/p>\n<p>\u516c\u5f0f\uff1a=Countif(c:c,\"&gt;\" &amp; average(c:c))<\/p>\n<p>\u6ce8\uff1a\u8fd9\u91cc\u662f\u4f7f\u7528\u4e86\u5e73\u5747\u503c\u51fd\u6570average\u5148\u8ba1\u7b97\u5e73\u5747\u503c\uff0c\u7136\u540e\u4f5c\u4e3a\u6761\u4ef6\u3002<\/p>\n<p>\u4f8b6\uff1a\u7edf\u8ba1A\u5217\u4e3a\u201c\u516c\u53f8A\u201d\u6216\u201c\u516c\u53f8B\u201d\u7684\u4e2a\u6570<\/p>\n<p>\u516c\u5f0f\uff1a{=Sum(Countif(A\uff1aA,{\"\u516c\u53f8A\",\"\u516c\u53f8B\"})) }<\/p>\n<p>\u6ce8\uff1a\u8fd9\u91cc\u5728\u7b2c\u4e8c\u4e2a\u53c2\u6570\u91cc\u52a0\u5165\u4e86\u5e38\u91cf\u6570\u7ec4\uff0c\u4f7f\u7528countif\u7684\u7ed3\u679c\u662f\u5206\u522b\u6309\u4e24\u4e2a\u516c\u53f8\u540d\u79f0\u7edf\u8ba1\u7684\u7ed3\u679c\uff0c\u4e5f\u662f\u4e00\u4e2a\u6570\u7ec4\u5047\u5982\u662f{3,4}\uff0c\u5f97\u5230\u6570\u7ec4\u540e\u7528sum\u51fd\u6570\u5bf9\u4e24\u4e2a\u6570\u8fdb\u884c\u6c42\u548c\uff0c\u5f97\u5230\u603b\u7684\u4e2a\u6570\uff0c\u8fd9\u4e2a\u516c\u5f0f\u662f\u6570\u7ec4\u516c\u5f0f\uff0c\u6240\u4ee5\u4e00\u5b9a\u8981\u8f93\u5165\u516c\u5f0f\u540e\u628a\u5149\u6807\u653e\u5728\u516c\u5f0f\u6700\u540e\uff0c\u6309ctrl+shift\uff0c\u7136\u540e\u6309enter\u952e\u7ed3\u675f\u8f93\u5165\u3002<\/p>\n<p>\u53e6\uff1a\u4e5f\u8bb8\u4e5f\u8fd8\u4f1a\u95ee\uff0c\u5982\u679c\u8bbe\u7f6e\u66f4\u591a\u6761\u4ef6\u8be5\u600e\u4e48\u5f04\uff0c\u5170\u8272\u5e7b\u60f3\u5efa\u8bae\u4f7f\u7528\u53e6\u4e00\u4e2a\u53ef\u4ee5\u591a\u6761\u4ef6\u6c42\u548c\u4e0e\u8ba1\u6570\u7684\u51fd\u6570:sumproduct<\/p>\n<p>\u4f8b\uff1a\u7edf\u8ba1\u5927\u4e8e1000\uff0c\u5c0f\u4e8e3000\u7684\u6570\u5b57\u4e2a\u6570<\/p>\n<p>=sumprodcut((a1:a100&gt;1000)*(a1:a100&lt;3000))<\/p>\n<p><strong><span title=\"\">45<\/span><\/strong><\/p>\n<p><strong>excel\u5982\u4f55\u6279\u91cf\u53d6\u6d88\u6279\u6ce8<\/strong><\/p>\n<p>\u6279\u91cf\u5220\u9664\u6279\u6ce8\u53ea\u9700\u8981\u4ee5\u4e0b\u4e24\u6b65\uff1a<\/p>\n<ul>\n<li>\n<p>\u9009\u53d6\u5305\u542b\u6279\u6ce8\u7684\u533a\u57df<\/p>\n<\/li>\n<li>\n<p>\u53f3\u952e\u83dc\u5355\u4e2d\u201c\u5220\u9664\u6279\u6ce8\u201d<\/p>\n<\/li>\n<\/ul>\n<p><strong><span title=\"\">46<\/span><\/strong><\/p>\n<p><strong>excel\u600e\u4e48\u6253\u5370\u6279\u6ce8<\/strong><\/p>\n<p>\u7b54\uff1a\u9875\u9762\u5e03\u5c40 - \u6253\u5370\u6807\u9898 - \u6279\u6ce8 \u4e0b\u62c9\u6846\u4e2d\u9009\u6253\u5370\u4f4d\u7f6e<\/p>\n<p><strong><span title=\"\">47<\/span><\/strong><\/p>\n<p><strong>\u8ba1\u7b97\u4e24\u4e2a\u65e5\u671f\u95f4\u7684\u6708\u6570<\/strong><\/p>\n<p>\u7b54\uff1a\u8ba1\u7b97\u4e24\u4e2a\u65e5\u671f\u4e4b\u95f4\u7684\u6708\u6570\uff0c\u53ef\u4ee5\u7528\u4ee5\u4e0b\u516c\u5f0f\u5b9e\u73b0<\/p>\n<p>=DATEDIF(\u5f00\u59cb\u65e5\u671f\uff0c\u7ed3\u675f\u65e5\u671f\uff0c\"M\")<\/p>\n<p><strong><span title=\"\">48<\/span><\/strong><\/p>\n<p><strong>Excel\u53d6\u6d88\u9690\u85cf\u884c\u5217\u600e\u4e48\u505a<\/strong><\/p>\n<p>\u7b54\uff1a\u53d6\u6d88excel\u9690\u85cf\u5217\u5206\u4ee5\u4e0b\u51e0\u79cd\u60c5\u51b5\u3002<\/p>\n<ul>\n<li>\n<p>\u4f7f\u7528\u9690\u85cf\u884c\u6216\u9690\u85cf\u5217\u7684\u9690\u85cf\uff0c\u53ef\u4ee5\u9009\u53d6\u5305\u62ec\u9690\u85cf\u884c\u548c\u9690\u85cf\u5217\u533a\u57df\uff0c\u53f3\u952e\u83dc\u5355\u4e2d\u53d6\u6d88\u9690\u85cf\u5373\u53ef\u3002cda.pinggu.org\/view\/198<\/p>\n<\/li>\n<li>\n<p>\u4f7f\u7528\u7a97\u53e3\u51bb\u7ed3\u7684\u9690\u85cf\u3002\u7a97\u53e3--\u53d6\u6d88\u7a97\u53e3\u51bb\u7ed3\u3002<\/p>\n<\/li>\n<li>\n<p>\u4f7f\u7528\u7b5b\u9009\u529f\u80fd\u9690\u85cf\u7684\u5217\u3002\u6570\u636e--\u7b5b\u9009--\u53d6\u6d88\u7b5b\u9009<\/p>\n<\/li>\n<li>\n<p>\u4f7f\u7528\u8bbe\u7f6e\u5217\u5bbd\u7684\u9690\u85cf\u3002\u53ef\u4ee5\u683c\u5f0f-\u5217\u5bbd\uff0c\u8f93\u5165\u6570\u503c\u5373\u53ef\u53d6\u6d88\u9690\u85cf<\/p>\n<\/li>\n<\/ul>\n<p><strong><span title=\"\">49<\/span><\/strong><\/p>\n<p><strong>\u8eab\u4efd\u8bc1\u53f7\u7801\u8f6c\u6362\u5e74\u9f84,\u600e\u4e48\u505a?<\/strong><\/p>\n<p>\u5982\u679c\u8eab\u4efd\u8bc1\u53f7\u5728A1\uff0c\u5728\u8981\u7b97\u5e74\u9f84\u7684\u5355\u5143\u683c\u8f93\u5165<\/p>\n<p>=DATEDIF(TEXT(MID(A1,7,8),\"0000-00-00\"),TODAY(),\"y\")<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/imgconvert.csdnimg.cn\/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X2dpZi90WFlpY3Q0MHhmTGhwZjNzcEJTbkx2Zk56WklaNkVLb0JBYmsxd1d4TTFqaWNZVTQ0clF2c2FvUmN6VHRpYlJTOFVtbWI3Vk1hTldvM1M3cjRnMVlETnduQS82NDA\" =\"\" =\"\" alt=\"excel100\u4e2a\u5e38\u7528\u6280\u5de7_excel\u638c\u63e127\u4e2a\u6280\u5de7 (https:\/\/mushiming.com\/)  \u7b2c2\u5f20\" title=\"excel100\u4e2a\u5e38\u7528\u6280\u5de7_excel\u638c\u63e127\u4e2a\u6280\u5de7  \u7b2c2\u5f20-\u7a46\u4e16\u660e\u535a\u5ba2\" ><\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"excel100\u4e2a\u5e38\u7528\u6280\u5de7_excel\u638c\u63e127\u4e2a\u6280\u5de7\u8def\u4e0a\u7684\u4f60\uff5c\u4f5c\u8005\u77e5\u4e4e\uff5c\u6765\u6e901excel\u5224\u65ad\u5206\u6570\u6210\u7ee9\u662f\u5426\u53ca\u683c\uff0c\u600e\u4e48\u505a?\u7b54\uff1aexcel\u5224\u65ad\u5206\u6570\u6210\u7ee9...","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[],"tags":[],"_links":{"self":[{"href":"https:\/\/mushiming.com\/wp-json\/wp\/v2\/posts\/6758"}],"collection":[{"href":"https:\/\/mushiming.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mushiming.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mushiming.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/mushiming.com\/wp-json\/wp\/v2\/comments?post=6758"}],"version-history":[{"count":0,"href":"https:\/\/mushiming.com\/wp-json\/wp\/v2\/posts\/6758\/revisions"}],"wp:attachment":[{"href":"https:\/\/mushiming.com\/wp-json\/wp\/v2\/media?parent=6758"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mushiming.com\/wp-json\/wp\/v2\/categories?post=6758"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mushiming.com\/wp-json\/wp\/v2\/tags?post=6758"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}