{"id":331,"date":"2022-01-18T10:47:25","date_gmt":"2022-01-18T02:47:25","guid":{"rendered":"https:\/\/www.shiyest.cn\/?p=331"},"modified":"2022-01-18T10:50:11","modified_gmt":"2022-01-18T02:50:11","slug":"excel%e5%87%bd%e6%95%b0","status":"publish","type":"post","link":"https:\/\/www.shiyest.cn\/?p=331","title":{"rendered":"EXCEL\u51fd\u6570"},"content":{"rendered":"<h2 class=\"md-end-block md-heading\"><span class=\"md-plain md-expand\">\u7b2c\u4e00\u8bb2 \u51fd\u6570\u57fa\u7840\u548c\u8bed\u6cd5<\/span><\/h2>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">\u4e00\uff0e \u51fd\u6570\u7684\u4f5c\u7528<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">a) \u51fd\u6570\u5199\u597d\u4e4b\u540e\uff0c\u53ef\u4ee5\u81ea\u52a8\u751f\u6210\u4e00\u4e9b\u6709\u7528\u6570\u636e\uff0c\u63d0\u9ad8\u5de5\u4f5c\u6548\u7387<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">\u4e8c\uff0e \u516c\u5f0f\u7684\u5b9a\u4e49\uff1a\u542b\u6709\u4e00\u4e2a\u201c\uff1d\u201d\uff0c\u6309\u7167\u4e00\u4e9b\u89c4\u5b9a\u7684\u8fd0\u7b97\u89c4\u5219\u8fdb\u884c\u8fd0\u7b97\uff0c\u4e14\u6709\u4e00\u5b9a\u610f\u4e49\u7684\u7b49\u5f0f<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">\u4e09\uff0e \u51fd\u6570\u7684\u5b9a\u4e49\uff1a\u51fd\u6570\u662f\u7f16\u7a0b\u5e8f\u4eba\u5458\u6309\u7167\u9884\u5148\u5199\u597d\u7684\u8fd0\u7b97\u65b9\u6cd5\u8fdb\u884c\u8fd0\u7b97\u7684\uff0c\u4e0d\u540c\u7684\u51fd\u6570\u6709\u4e0d\u540c\u7684\u4f5c\u7528\uff0c\u51fd\u6570\u5b83\u662f\u516c\u5f0f\u7684\u4e00\u79cd\u7279\u6b8a\u5f62\u5f0f<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">\u56db\uff0e \u51fd\u6570\u7684\u8f93\u5165\u987a\u5e8f<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">a) \u7b2c\u4e00\u6b65\uff1a\u9996\u5148\u8f93\u5165\u4e00\u4e2a\u201c\uff1d\u201d<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">b) \u7b2c\u4e8c\u6b65\uff1a\u63a5\u7740\u8f93\u5165\u4e00\u4e2a\u51fd\u6570\u540d\uff08\u4e0d\u533a\u5206\u5927\u5c0f\u5199\uff09<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">c) \u7b2c\u4e09\u6b65\uff1a\u7136\u540e\u8f93\u5165\u4e00\u5bf9\u5c0f\u62ec\u53f7<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">d) \u7b2c\u56db\u6b65\uff1a\u6700\u540e\u5728\u62ec\u53f7\u91cc\u8f93\u5165\u53c2\u6570\uff08\u8fd9\u4e5f\u662f\u6211\u4eec\u5b66\u4e60\u51fd\u6570\u6700\u96be\u7684\u4e00\u90e8\u5206\uff0c\u8bf4\u5230\u5e95\u5b66\u51fd\u6570\u5c31\u662f\u5b66\u5b83\u7684\u53c2\u6570\uff0c\u5982\u679c\u4e0d\u660e\u767d\uff0c\u4e5f\u53ef\u4ee5\u901a\u8fc7Excel \u81ea\u5e26\u7684\u5e2e\u52a9\u6765\u89e3\u51b3\u8fd9\u4e2a\u95ee\u9898\uff09<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">\u4e94\uff0e \u76f8\u5bf9\u5f15\u7528,\u7edd\u5bf9\u5f15\u7528,\u6df7\u5408\u5f15\u7528<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">\u5728\u5b66\u4e60\u548c\u4f7f\u7528\u51fd\u6570\u7684\u8fc7\u7a0b\u4e2d\uff0c\u5927\u5bb6\u4e00\u5b9a\u8981\u7406\u89e3\u76f8\u5bf9\u548c\u7edd\u5bf9\u5f15\u7528<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">a) \u76f8\u5bf9\u5f15\u7528\uff1a\u884c\u53f7\u548c\u5217\u6807\u524d\u9762\u90fd\u6ca1\u6709\u7f8e\u5143\u7b26\u53f7$,\u5982A1<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">b) \u7edd\u5bf9\u5f15\u7528\uff1a\u884c\u53f7\u548c\u5217\u6807\u524d\u9762\u90fd\u6709\u7f8e\u5143\u7b26\u53f7$,\u5982$A$1<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">c) \u6df7\u5408\u5f15\u7528\uff1a\u5305\u542b\u4e8c\u79cd\uff0c\u4e00\u79cd\u662f\u7edd\u5bf9\u884c\u5f15\u7528\uff0c\u4e00\u79cd\u662f\u7edd\u5bf9\u5217\u5f15\u7528<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\"> i. \u7edd\u5bf9\u884c\u5f15\u7528:\u5c31\u662f\u884c\u53f7\u524d\u9762\u6709\u7f8e\u5143\u7b26\u53f7\uff0c\u800c\u5217\u6807\u524d\u9762\u6ca1\u6709\u7f8e\u5143\u7b26\u53f7\uff0c\u5982A$1<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\"> ii. \u7edd\u5bf9\u5217\u5f15\u7528\uff1a\u5c31\u662f\u884c\u53f7\u524d\u9762\u6ca1\u6709\u7f8e\u5143\u7b26\u53f7\uff0c\u800c\u5217\u6807\u524d\u6709\u7f8e\u5143\u7b26\u53f7\uff0c\u5982$A1<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">\u516d\uff0e \u5404\u5f15\u7528\u4e4b\u95f4\u7684\u533a\u522b<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">a) \u5982\u679c\u4e0d\u8003\u8651\u586b\u5145\u4e0b\u62c9\u516c\u5f0f\uff0c\u6211\u4eec\u7528\u90a3\u4e00\u79cd\u5f15\u7528\u90fd\u662f\u4e00\u6837\u7684\uff0c\u800c\u5f15\u7528\u5355\u5143\u683c\u65f6\u9ed8\u8ba4\u7684\u662f\u76f8\u5bf9\u5f15\u7528\uff0c\u56e0\u6b64\u6211\u4eec\u4e00\u822c\u5c31\u91c7\u7528\u76f8\u5bf9\u5f15\u7528<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">b) \u5982\u679c\u8981\u586b\u5145\u4e0b\u62c9\u516c\u5f0f\uff0c\u6211\u4eec\u4e00\u5b9a\u8981\u614e\u8003\u8651\u8981\u7528\u90a3\u4e00\u79cd\u5f15\u7528\uff0c\u5c31\u4e0d\u80fd\u968f\u4fbf\u7528\u4e00\u79cd<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">c) \u7528\u76f8\u5bf9\u5f15\u7528\uff1a\u5982\u679c\u6211\u4eec\u5411\u4e0b\u586b\u5145\u516c\u5f0f\u8981\u6c42\u884c\u53f7\u53d1\u751f\u6539\u53d8\uff0c\u4e14\u5411\u53f3\u586b\u5145\u516c\u5f0f\u8981\u6c42\u5217\u6807\u4e5f\u53d1\u751f\u6539\u53d8<\/span> <span class=\"md-plain\">d) \u7528\u7edd\u5bf9\u5f15\u7528\uff1a\u5982\u679c\u6211\u4eec\u5411\u4e0b\u586b\u5145\u516c\u5f0f\uff0c\u8981\u6c42\u884c\u53f7\u4e0d\u53d1\u751f\u6539\u53d8\uff0c\u800c\u4e14\u5411\u53f3\u586b\u5145\u516c\u5f0f\u8981\u6c42\u5217\u6807\u4e0d\u53d1\u751f\u6539\u53d8<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">e) \u7528\u7edd\u5bf9\u884c\u5f15\u7528\uff1a\u5982\u679c\u6211\u4eec\u5411\u4e0b\u586b\u5145\u516c\u5f0f\uff0c\u8981\u6c42\u884c\u53f7\u4e0d\u53d1\u751f\u6539\u53d8\uff0c\u4f46\u5411\u53f3\u586b\u5145\u516c\u5f0f\u8981\u6c42\u5217\u6807\u53d1\u751f\u6539\u53d8<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">f) \u7528\u7edd\u5bf9\u5217\u5f15\u7528\uff1a\u5982\u679c\u6211\u4eec\u5411\u4e0b\u586b\u5145\u516c\u5f0f\uff0c\u8981\u6c42\u884c\u53f7\u53d1\u751f\u6539\u53d8\uff0c\u4f46\u5411\u53f3\u586b\u5145\u8981\u6c42\u5217\u6807\u4e0d\u53d1\u751f\u6539\u53d8 <\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">\u4e03\uff0e \u516c\u5f0f\u7684\u7ec4\u6210<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">\u4e00\uff0e \u516c\u5f0f\u590d\u5236\u4e0e\u586b\u5145<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">a) \u65b9\u6cd5\u4e00\uff1a\u62d6\u62fd\u586b\u5145\u67c4<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">b) \u65b9\u6cd5\u4e8c\uff1a\u53cc\u51fb\u586b\u5145\u67c4<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">\u4e8c\uff0e \u516c\u5f0f\u4e2d\u7684\u8fd0\u7b97\u7b26<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">a) \u7b97\u672f\u8fd0\u7b97\u7b26\uff1a+\u3001-\u3001*\u3001\/\u3001%\u3001^<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">b) \u6bd4\u8f83\u8fd0\u7b97\u7b26\uff1a=\u3001&gt;\u3001&gt;=\u3001&lt;\u3001&lt;=\u3001&lt;&gt;<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">c) \u6587\u672c\u8fd0\u7b97\u7b26\uff1a&amp;<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">\u4e09\uff0e \u51fd\u6570\u7684\u5206\u7c7b<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">a) \u6587\u672c\u51fd\u6570\uff0c\u4fe1\u606f\u51fd\u6570\uff0c\u903b\u8f91\u51fd\u6570\uff0c\u67e5\u627e\u4e0e\u5f15\u7528\u51fd\u6570\uff0c\u65e5\u671f\u548c\u65f6\u95f4\u51fd\u6570\uff0c\u7edf\u8ba1\u51fd\u6570\uff0c\u6570\u5b66\u51fd\u6570\u7b49<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">\u56db\uff0e F9\u7684\u5999\u7528:\u5728\u51fd\u6570\u67e5\u9519\u6216\u8005\u770b\u4e00\u4e9b\u7ed3\u679c\u90fd\u4f1a\u7528\u5230F9<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">\u4e94\uff0e \u51fd\u6570True<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">a) True:\u8fd4\u56de\u903b\u8f91\u503cTrue<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">b) \u5728\u8fd0\u7b97\u4e2d\u7b49\u4e8e1<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">c) \u5728\u8fd0\u7b97\u4e2d\u975e\u96f6\u6570\u5b57\u90fd\u7b49\u4e8eTrue<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">d) 1=True<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">\u516d\uff0e \u51fd\u6570False<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">a) False:\u8fd4\u56de\u903b\u8f91\u503cFalse<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">b) \u5728\u8fd0\u7b97\u4e2d\u7b49\u4e8e0<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">c) 0=False<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">\u4e03\uff0e \u8fde\u5b57\u7b26 &amp;<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">a) \u8fde\u5b57\u7b26:\u8d77\u7740\u8fde\u63a5\u7684\u4f5c\u7528<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">\u516b\uff0e \u51fd\u6570Today<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">a) \u8fd4\u56de\u5f53\u5929\u7684\u65e5\u671f \uff0c\u4e0d\u8fc7\u5927\u5bb6\u8981\u6ce8\u610f\uff0c\u4f60\u7535\u8111\u672c\u8eab\u7684\u7cfb\u7edf\u65e5\u671f\u8981\u662f\u5bf9\u7684\uff0c\u5982\u679c\u4e0d\u5bf9\uff0c\u5b83\u7684\u503c\u4e5f\u4e0d\u4f1a\u5bf9<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">b) \u8fd9\u4e2a\u51fd\u6570\u7684\u53c2\u6570\u662f\u7a7a\u7684\u3002<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">\u4e5d\uff0e \u51fd\u6570Now<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">a) \u8fd4\u56de\u5f53\u5929\u7684\u65e5\u671f\u548c\u65f6\u95f4 \uff0c\u4e0d\u8fc7\u5927\u5bb6\u8981\u6ce8\u610f\uff0c\u4f60\u7535\u8111\u672c\u8eab\u7684\u7cfb\u7edf\u65e5\u671f\u548c\u65f6\u95f4\u8981\u662f\u5bf9\u7684\uff0c\u5982\u679c\u4e0d\u5bf9\uff0c\u5b83\u7684\u503c\u4e5f\u4e0d\u4f1a\u5bf9<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">b) \u8fd9\u4e2a\u51fd\u6570\u7684\u53c2\u6570\u662f\u7a7a\u7684\u3002<\/span><\/p>\n<h2 class=\"md-end-block md-heading\"><span class=\"md-plain\">\u7b2c\u4e8c\u8bb2 \u51fd\u6570Right Left Mid Len Lenb Int Find If Round Roundup Rounddown Rank Rand Randbetween<\/span><\/h2>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">\u4e00\uff0e\u51fd\u6570Right<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">a) \u4ece\u53f3\u8fb9\u63d0\u53d6\u5b57\u7b26<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">b) \u51fd\u6570Right\u6709\u4e8c\u4e2a\u53c2\u6570\uff0c\u7b2c\u4e00\u4e2a\u53c2\u6570\u662f\u4ece\u90a3\u91cc\u53d6\uff0c\u7b2c\u4e8c\u4e2a\u53c2\u6570\u4ece\u53f3\u8fb9\u63d0\u53d6\u591a\u5c11\u4e2a\u5b57\u7b26<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">\u4e8c\uff0e\u51fd\u6570Left<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">a) \u4ece\u5de6\u8fb9\u63d0\u53d6\u5b57\u7b26<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">b) \u51fd\u6570Left\u6709\u4e8c\u4e2a\u53c2\u6570\uff0c\u7b2c\u4e00\u4e2a\u53c2\u6570\u662f\u4ece\u90a3\u91cc\u53d6\uff0c\u7b2c\u4e8c\u4e2a\u53c2\u6570\u4ece\u5de6\u8fb9\u63d0\u53d6\u591a\u5c11\u4e2a\u5b57\u7b26<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">\u4e09\uff0e\u51fd\u6570Mid<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">a) \u4ece\u4e2d\u95f4\u63d0\u53d6\u5b57\u7b26<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">b) \u51fd\u6570Mid\u6709\u4e09\u4e2a\u53c2\u6570\uff0c\u7b2c\u4e00\u4e2a\u53c2\u6570\u662f\u90a3\u91cc\u53d6\uff1b\u7b2c\u4e8c\u4e2a\u53c2\u6570\u662f\u4ece\u4e2d\u95f4\u90a3\u4e2a\u4f4d\u7f6e\u5f00\u59cb\u63d0\u53d6\uff1b\u7b2c\u4e09\u4e2a\u53c2\u6570\u662f\u4e2d\u95f4\u63d0\u53d6\u591a\u5c11\u4e2a<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">\u56db\uff0e\u51fd\u6570Len<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">a) \u8ba1\u7b97\u5355\u5143\u683c\u91cc\u6709\u591a\u5c11\u4e2a\u5b57\u7b26\uff0c\u4e00\u4e2a\u6570\u5b57\uff0c\u6c49\u5b57\uff0c\u5b57\u6bcd\u90fd\u7b97\u4e00\u4e2a\u5b57\u7b26<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">b) Len\u51fd\u6570\u53ea\u6709\u4e00\u4e2a\u53c2\u6570\uff0c\u7edf\u8ba1\u90a3\u4e00\u4e2a\u5355\u5143\u683c\uff0c\u4e5f\u53ef\u4ee5\u662f\u4e00\u4e32\u5b57\u7b26<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">\u4e94\uff0e\u51fd\u6570Lenb<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">a) \u8ba1\u7b97\u5355\u5143\u683c\u91cc\u6709\u591a\u5c11\u4e2a\u5b57\u7b26\uff0c\u4e00\u4e2a\u6570\u5b57\uff0c\u5b57\u6bcd\u90fd\u7b97\u4e00\u4e2a\u5b57\u7b26,\u4f46\u662f\u4e00\u6c49\u5b57\u7b97\u4e8c\u4e2a\u5b57\u7b26<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">b) Lenb\u51fd\u6570\u53ea\u6709\u4e00\u4e2a\u53c2\u6570\uff0c\u7edf\u8ba1\u90a3\u4e00\u4e2a\u5355\u5143\u683c\uff0c\u4e5f\u53ef\u4ee5\u662f\u4e00\u4e32\u5b57\u7b26<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">\u516d\uff0e\u51fd\u6570Int<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">a) \u53d6\u6574\u51fd\u6570<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">b) \u51fd\u6570Int\u53ea\u6709\u4e00\u4e2a\u53c2\u6570 \u5982Int(7\/2)=3<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">\u4e03\uff0e\u51fd\u6570Find<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">a) \u67e5\u627e\u4e00\u4e2a\u5b57\u7b26\u5728\u53e6\u4e00\u4e2a\u5b57\u7b26\u4e32\u7684\u4f4d\u7f6e<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">b) Find \u51fd\u6570\u6709\u4e09\u4e2a\u53c2\u6570\uff0c\u7b2c\u4e00\u4e2a\u53c2\u6570\u662f\u8981\u67e5\u627e\u7684\u5b57\u7b26\uff1b\u7b2c\u4e8c\u4e2a\u53c2\u6570\u5728\u90a3\u4e00\u4e2a\u91cc\u9762\u627e\uff1b\u7b2c\u4e09\u53c2\u6570\u4ece\u7b2c\u51e0\u4e2a\u4f4d\u7f6e\u5f00\u59cb\u627e<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">\u516b\uff0e\u51fd\u6570If<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">a) \u5224\u65ad\u51fd\u6570\uff0c\u8fd9\u4e2a\u51fd\u6570\u7ecf\u5e38\u7528\u5230\uff0c\u6240\u4ee5\u5927\u5bb6\u4e00\u5b9a\u8981\u638c\u63e1<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">b) \u8fd9\u4e2a\u51fd\u6570\u6709\u4e09\u4e2a\u53c2\u6570\uff0c\u7b2c\u4e00\u4e2a\u53c2\u6570\u662f\u5224\u65ad\uff0c\u5224\u65ad\u4f1a\u6709\u4e8c\u79cd\u7ed3\u679c\uff0c\u6210\u7acb\u4e0e\u4e0d\u6210\u7acb\uff0c\u5224\u65ad\u6211\u4eec\u4f1a\u7528\u5230 \"&gt;\" \"&lt;\" \"=\" \"&lt;&gt;\" \"&gt;=\" \"&lt;=\"\uff1b\u7b2c\u4e8c\u4e2a\u53c2\u6570\uff1a\u5982\u679c\u7b2c\u4e00\u4e2a\u53c2\u6570\u6210\u7acb\u90a3\u4e48\u6267\u884c\u7b2c\u4e8c\u53c2\u6570\uff1b\u7b2c\u4e09\u53c2\u6570\uff1a\u5982\u679c\u7b2c\u4e00\u4e2a\u53c2\u6570\u4e0d\u6210\u7acb\uff0c\u90a3\u4e48\u5c31\u6267\u884c\u7b2c\u4e09\u4e2a\u53c2\u6570<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">c) \u5b9e\u4f8b1\uff1a\u5206\u6570\u7684\u5224\u65ad\uff0c\u5982\uff1a\u4e00\u4e2a\u8003\u8bd5\u6210\u7ee9\u7684\u5224\u65ad\uff0c\u5c0f\u4e8e60\u4e3a\u4e0d\u53ca\u683c\uff0c\u5176\u5b83\u7684\u4e3a\u53ca\u683c<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">=if(A1&lt;60,\"\u4e0d\u53ca\u683c\",\"\u53ca\u683c\")<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">\u89e3\u91ca\uff1a\u9996\u5148\u8f93\u5165\u4e00\u4e2a\u201c=\u201d\uff0c\u7136\u540e\u8f93\u5165\u51fd\u6570\u540dIf,\u63a5\u7740\u8f93\u5165\u4e00\u5bf9\u5c0f\u62ec\u53f7\uff0c\u6700\u540e\u5728\u62ec\u53f7\u91cc\u8f93\u5165\u53c2\u6570\uff0c\u7b2c\u4e00\u53c2\u6570\u628aA1\u91cc\u7684\u5206\u6570\u4e0e\u5e38\u91cf60\u5bf9\u6bd4\uff0c\u5982\u679c\u786e\u662f\u5c0f\u4e8e60\uff0c\u90a3\u4e48\u8fd9\u4e2a\u5224\u65ad\u662f\u6210\u7acb\u7684\uff0c\u90a3\u4e48\u5c31\u6267\u884c\u7b2c\u4e8c\u4e2a\u53c2\u6570\uff0c\u4e5f\u5c31\u662f\u663e\u793a\u4e3a\u201c\u4e0d\u53ca\u683c\u201d\uff0c\u5426\u5219\u5c31\u6267\u884c\u7b2c\u4e09\u4e2a\u53c2\u6570\uff0c\u663e\u793a\u4e3a\u201c\u53ca\u683c\u201d<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">d) \u5b9e\u4f8b2\uff1a\u5206\u6570\u7684\u5224\u65ad\uff0c\u8981\u6c42\u8981\u5907\u6ce8\u5217\u663e\u793a\u7ed3\u679c\uff0c\u5206\u6570\u5c0f\u4e8e60\u7684\u4e3a\u4e0d\u53ca\u683c\uff0c\u5927\u4e8e\u7b49\u4e8e60\u4e14\u5c0f70\u7684\u4e3a\u53ca\u683c\uff0c\u5927\u4e8e\u7b49\u4e8e70\u7684\u4e14\u5c0f\u4e8e80\u7684\u4e3a\u826f\u597d\uff0c\u5927\u4e8e\u7b49\u4e8e80\u7684\u4e3a\u4f18\u79c0<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\"> =IF(A1&lt;60,\"\u4e0d\u53ca\u683c\",IF(A1&lt;70,\"\u53ca\u683c\",IF(A1&lt;80,\"\u826f\u597d\",\"\u4f18\u79c0\")))<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\"> \u89e3\u91ca\uff1a\u7b2c\u4e00\u4e2aIf\u6709\u4e09\u4e2a\u53c2\u6570\uff0c\u7b2c\u4e00\u4e2a\u53c2\u6570\uff1a\u5982\u679cA1\u5355\u5143\u683c\u5c0f\u4e8e60\uff0c\u90a3\u4e48\u6267\u884c\u7b2c\u4e8c\u4e2a\u53c2\u6570\uff0c\u663e\u793a\u4e3a\u201c\u4e0d\u53ca\u683c\u201d\uff0c\u5426\u5219\u5c31\u4ea4\u7ed9\u7b2c\u4e09\u4e2a\u53c2\u6570\uff0c\u7b2c\u4e09\u4e2a\u53c2\u6570\u53c8\u662f\u4e00\u4e2aIf\u51fd\u6570\uff0c\u8fd9\u6837\u53eb\u505a\u51fd\u6570\u5d4c\u5957\u3002\u7b2c\u4e8c\u4e2aIF\u51fd\u6570\u53c8\u6709\u4e09\u4e2a\u53c2\u6570\uff0c\u7b2c\u4e00\u4e2a\u53c2\u6570\u662f\u5224\u65ad\uff0c\u5bf9A1\u5355\u5143\u683c\u8fdb\u884c\u7b2c\u4e8c\u6b21\u5224\u65ad\uff0c\u5982\u679cA1\u5c0f\u4e8e70\uff0c\u800c\u5c0f\u4e8e60\u7684\uff0c\u6211\u4eec\u7b2c\u4e00\u4e2aIf\u5df2\u7ecf\u6392\u9664\u4e86\uff0c\u56e0\u6b64\uff0c\u73b0\u5728\u662f\u5927\u4e8e\u7b49\u4e8e60\u4e14\u5c0f\u4e8e70\uff0c\u5982\u679c\u7b2c\u4e00\u4e2a\u53c2\u6570\u5224\u65ad\u6210\u7acb\uff0c\u90a3\u4e48\u5c31\u6267\u884c\u7b2c\u4e8c\u53c2\u6570\uff0c\u663e\u793a\u4e3a\u201c\u5408\u683c\u201d,\u5426\u5219\u6267\u884c\u5c31\u4e09\u53c2\u6570\u3002\u800c\u6211\u4eec\u7b2c\u4e8c\u4e2aIf \u7684\u7b2c\u4e09\u53c2\u6570\u53c8\u662f\u4e00\u4e2aIF\uff0c\u56e0\u6b64\u6211\u4eec\u628a\u4efb\u4f55\u4ea4\u7ed9\u4e86\u7b2c\u4e09\u4e2aIf\u3002\u7b2c\u4e09\u4e2aIf\u4e5f\u6709\u4e09\u4e2a\u53c2\u6570\uff0c\u7b2c\u4e00\u4e2a\u53c2\u6570\u662f\u5224\u65ad\u5927\u4e8e\u7b49\u4e8e70\u4e14\u5c0f\u4e8e80\uff0c\u5982\u679c\u7b2c\u4e00\u4e2a\u53c2\u6570\u5224\u65ad\u6210\u7acb\uff0c\u90a3\u8bf4\u660e\u662f\u826f\u597d\uff0c\u5982\u679c\u4e0d\u6210\u7acb\uff0c\u90a3\u4e48\u6211\u4eec\u5c31\u6267\u884c\u7b2c\u4e09\u53c2\u6570\uff0c\u7ed3\u679c\u4e3a\u201c\u4f18\u79c0\u201d<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">\u4e5d\uff0e\u51fd\u6570Round<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">a) \u6309\u6307\u5b9a\u7684\u4f4d\u6570\u8fdb\u884c\u56db\u820d\u4e94\u5165\uff0c\u8fd9\u4e2a\u51fd\u6570\u6709\u4e8c\u4e2a\u53c2\u6570\uff0c\u7b2c\u4e00\u53c2\u6570\u662f\u6570\u636e\uff0c\u7b2c\u4e8c\u53c2\u6570\u662f\u6307\u5b9a\u4fdd\u7559\u90a3\u4f4d\uff0c\u7136\u540e\u5bf9\u5b83\u540e\u7684\u90a3\u4e00\u4f4d\u8fdb\u884c\u56db\u820d\u4e94\u5165\u3002<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">\u5341\uff0e\u51fd\u6570Roundup<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">a) \u6309\u6307\u5b9a\u7684\u4f4d\u6570\u8fdb\u884c\u5411\u4e0a\u820d\u5165\uff0c\u8fd9\u4e2a\u51fd\u6570\u6709\u4e8c\u4e2a\u53c2\u6570\uff0c\u7b2c\u4e00\u53c2\u6570\u662f\u6570\u636e\uff0c\u7b2c\u4e8c\u53c2\u6570\u662f\u6307\u5b9a\u4fdd\u7559\u90a3\u4f4d\uff0c\u7136\u540e\u5bf9\u5b83\u540e\u7684\u90a3\u4e00\u4f4d\u8fdb\u884c\u820d\u53bb\uff0c\u800c\u5b83\u81ea\u5df1\u5c31\u5165\uff0c\u4e0d\u7ba1\u5c0f\u4e8e5\u8fd8\u662f\u5927\u4e8e5\u90fd\u8981\u52a01<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">\u5341\u4e00\uff0e\u51fd\u6570Rounddown<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">a) \u6309\u6307\u5b9a\u7684\u4f4d\u6570\u8fdb\u884c\u5411\u4e0b\u820d\u5165\uff0c\u8fd9\u4e2a\u51fd\u6570\u6709\u4e8c\u4e2a\u53c2\u6570\uff0c\u7b2c\u4e00\u53c2\u6570\u662f\u6570\u636e\uff0c\u7b2c\u4e8c\u53c2\u6570\u662f\u6307\u5b9a\u4fdd\u7559\u90a3\u4f4d\uff0c\u7136\u540e\u5bf9\u5b83\u540e\u7684\u90a3\u4e00\u4f4d\u8fdb\u884c\u820d\u53bb\uff0c\u800c\u5b83\u81ea\u5df1\u5c31\u5165\uff0c\u4e0d\u7ba1\u5c0f\u4e8e5\u8fd8\u662f\u5927\u4e8e5\u90fd\u4e0d\u8981\u52a01\uff0c\u8fd8\u662f\u539f\u6765\u5b83\u81ea\u5df1<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">\u5341\u4e8c\uff0e\u51fd\u6570Rank<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">a) \u6392\u540d\u51fd\u6570<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">b) \u8fd4\u56de\u4e00\u4e2a\u6570\u636e\u5728\u4e00\u7ec4\u6570\u5b57\u4e2d\u7684\u5927\u5c0f\u6392\u540d\u4f4d\u7f6e<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">c) \u8fd9\u4e2a\u51fd\u6570\u6709\u4e09\u4e2a\u53c2\u6570\uff0c\u7b2c\u4e00\u4e2a\u53c2\u6570\u201c\u8981\u6392\u540d\u7684\u6570\u636e\u201d\uff0c\u7b2c\u4e8c\u53c2\u6570\u4e00\u7ec4\u6570\u636e\uff0c\u4e5f\u5c31\u662f\u5168\u90e8\u8981\u6392\u540d\u7684\u6570\u636e\uff0c\u7b2c\u4e09\u53c2\u6570\u5982\u679c\u8f93\u51650\u5c31\u662f\u964d\u5e8f\uff0c\u4e5f\u5c31\u662f\u6700\u5927\u7684\u90a3\u4e2a\u6570\u636e\u5c31\u662f1\uff0c\u5982\u679c\u6700\u540e\u4e00\u4e2a\u53c2\u6570\u662f1\uff0c\u90a3\u4e48\u5c31\u662f\u5347\u5e8f\u6392\u540d\uff0c\u4e5f\u5c31\u662f\u8bf4\u6700\u5927\u7684\u90a3\u4e2a\u6570\u636e\u5c31\u662f\u6392\u5728\u6700\u540e\u4e86<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">\u5341\u4e09\uff0e\u51fd\u6570Rand<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">a) \u4f5c\u7528\uff1a\u751f\u6210\u968f\u673a0\u52301\u4e4b\u95f4\u7684\u4e00\u4e2a\u5c0f\u6570<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">b) \u8fd9\u4e2a\u51fd\u6570\u6ca1\u6709\u53c2\u6570<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">c) \u51fd\u6570\u5199\u597d\u4e4b\u540e\uff0c\u8bb0\u5f97\u6309F9\u5237\u65b0<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">\u5341\u56db\uff0e\u51fd\u6570Randbetween<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">a) \u4f5c\u7528\uff1a\u751f\u6210\u968f\u673a\u6574\u6570<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">b) \u8fd9\u4e2a\u51fd\u6570\u6709\u4e8c\u4e2a\u53c2\u6570\uff0c\u7b2c\u4e00\u4e2a\u53c2\u6570\u662f\u751f\u6210\u968f\u673a\u6574\u6570\u7684\u6700\u5c0f\u6570\uff0c\u7b2c\u4e8c\u4e2a\u53c2\u6570\u751f\u6210\u968f\u673a\u6574 \u6570\u7684\u6700\u5927\u6570<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">c) \u51fd\u6570\u5199\u597d\u4e4b\u540e\u6309F9\u5237\u65b0\uff0c\u5c31\u4f1a\u968f\u673a\u63d0\u53d6<\/span><\/p>\n<h2 class=\"md-end-block md-heading\"><span class=\"md-plain\">\u7b2c\u4e09\u8bb2 \u51fd\u6570Row Column Choose Offset Match Index<\/span><\/h2>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">\u4e00\uff0e\u51fd\u6570Row<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">a) \u8fd9\u4e2a\u51fd\u6570\u4f5c\u7528\u5f88\u5927\uff0c\u7279\u522b\u662f\u5728\u6570\u7ec4\u4e2d\uff0c\u7ecf\u5e38\u8981\u7528\u5230\uff0c\u6765\u4ea7\u751f\u6570\u5b57,123456789\u2026\u2026\u8fd9\u6837\u7684\u6570\u5b57\uff0c\u56e0\u6b64\u5927\u5bb6\u4e00\u5b9a\u5f04\u660e\u767d\u5b83<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">b) \u7528\u7684\u65f6\u5019\u6709\u4e8c\u79cd\u5f62\u5f0f<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">\u7b2c\u4e00\u79cd\uff1aRow\u53ea\u6709\u4e00\u4e2a\u53c2\u6570\uff0c\u5f53\u53c2\u6570\u7701\u7565\u65f6\uff0c\u8fd4\u56de\u8fd9\u4e2a\u516c\u5f0f\u6240\u5728\u5355\u5143\u683c\u7684\u884c\u53f7\uff0c\u6253\u4e2a\u6bd4\u65b9\uff0c\u5982=Row()\u5199\u5728D5\u5355\u5143\u683c\uff0c\u56e0\u4e3aD5\u7684\u884c\u53f7\u662f5\uff0c\u6240\u4ee5=Row()\u8fd4\u56de5<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">\u7b2c\u4e8c\u79cd\u7528\u6cd5\uff1a\u53c2\u6570\u4e0d\u7701\u7565 \uff0c\u5982\uff1a=Row(A8)\uff0c\u90a3\u4e48\u5c31\u8fd4\u56de8\uff0c\u7b2c\u4e8c\u79cd\u7528\u6cd5\uff0c\u6709\u65f6\u6211\u4eec\u4f1a\u653e\u4e00\u7ec4\u8fdb\u53bb\uff0c\u5982=Row(A1:A9)\uff0c\u8fd9\u65f6\u8fd4\u56de\u5c31\u662f123456789\uff0c\u4f46\u662f\u56e0\u4e3a\u4e00\u4e2a\u5355\u5143\u683c\u4e0d\u80fd\u5355\u72ec\u5b58\u50a8\u90a3\u4e48\u591a\u6570\u636e\uff0c\u90a3\u4e48\u5b83\u53ea\u663e\u793a1\uff0c\u5982\u679c\u6211\u4eec\u8981\u770b\u5230\u6240\u6709\u7684\u6570\u636e\uff0c\u90a3\u4e48\u628a\u5149\u6807\u5b9a\u4f4d\u5230\u7f16\u8f91\u680f\u91cc\uff0c\u6d82\u9ed1=Row(A1:A9)\uff0c\u7136\u540e\u6309\u4e00\u4e0bF9\uff0c\u7ed3\u679c\u5927\u5bb6\u5c31\u80fd\u770b\u5230\u4e86<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">\u4e8c\uff0e\u51fd\u6570Column <\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">a) \u8fd4\u56de\u5217\u53f7\uff0c\u548cRow\u7684\u7528\u6cd5\u4e00\u6837<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">b) \u5b83\u53ea\u6709\u4e00\u4e2a\u53c2\u6570\uff0c\u5982\u679c\u7701\u7565\uff0c\u90a3\u4e48\u5c31\u8fd4\u56deColumn\u51fd\u6570\u6240\u5728\u7684\u5355\u5143\u683c\u7684\u5217\u53f7\uff0c\u5982\u679c\u4e0d\u7701\u7565\uff0c\u90a3\u4e48\u5c31\u8fd4\u56de\u53c2\u6570\u7684\u5217\u53f7\u5982\uff1a=Column(D8)\uff0c\u90a3\u4e48\u5c31\u8fd4\u56de4,\u56e0\u4e3aD8\u662f\u7b2c\u56db\u5217<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">\u4e09\uff0e\u51fd\u6570Choose<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">a) \u6839\u636e\u7d22\u5f15\u503c\u8fd4\u56de\u53c2\u6570\u4e2d\u76f8\u5e94\u7684\u503c<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">b) \u6bd4\u5982=CHOOSE(6,\"A\",\"B\",\"C\",\"D\",\"E\",\"F\",\"G\")<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">Choose\u7684\u7b2c\u4e00\u53c2\u6570\u662f6\uff0c\u800c\u5176\u5b83\u53c2\u6570\u4f9d\u6b21\u662f\"A\",\"B\",\"C\",\"D\",\"E\",\"F\",\"G\"\uff0c\u90a3\u4e48\u7ed3\u679c\u5c31\u8fd4\u56deF<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">\u56db\uff0e\u51fd\u6570Offset<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">a) \u5f15\u7528\u4e00\u4e2a\u5355\u5143\u683c\u6216\u8005\u4e00\u4e2a\u8fde\u7eed\u7684\u533a\u57df<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">b) \u8fd9\u4e2a\u51fd\u6570\u6709\u4e94\u4e2a\u53c2\u6570\uff0c\u7b2c\u4e00\u4e2a\u53c2\u6570\u662f\u53c2\u7167\u5355\u5143\u683c\uff0c\u4e5f\u5c31\u662f\u4f60\u4ece\u90a3\u91cc\u5f00\u59cb\uff1b\u7b2c\u4e8c\u53c2\u6570\u662f\u504f\u79fb\u591a\u5c11\u884c\uff1b\u7b2c\u4e09\u53c2\u6570\u662f\u504f\u79fb\u591a\u5c11\u5217\uff1b\u7b2c\u56db\u53c2\u6570\u662f\u8fd4\u56de\u7684\u533a\u57df\u7684\u884c\u9ad8\uff1b\u7b2c\u56db\u53c2\u6570\u662f\u8fd4\u56de\u7684\u533a\u57df\u7684\u5217\u5bbd<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">c) \u6253\u4e2a\u6bd4\u65b9\uff0c=OFFSET(A1,4,3,1,1)\uff0c\u4eceA1\u5355\u5143\u683c\u8d77\uff0c\u504f\u79fb4\u884c\u5c31\u5230A5\uff0c\u504f\u79fb3\u5217\u5c31\u5230\u4e86D5\uff0c\u7136\u540e\u65b0\u7684\u5f15\u7528\u533a\u57df\uff0c\u884c\u9ad8\u4e3a1\uff0c\u5217\u5bbd\u4e3a1\uff0c\u6240\u4ee5\u662f\u8fd4\u56deD5\u91cc\u6570\u636e<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">d) \u518d\u6253\u4e2a\u6bd4\u65b9=<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\"> \u4eceA1\u5355\u5143\u683c\u8d77\uff0c\u504f\u79fb4\u884c\u5c31\u5230A5\uff0c\u504f\u79fb3\u5217\u5c31\u5230\u4e86D5\uff0c\u7136\u540e\u65b0\u7684\u5f15\u7528\u533a\u57df\u884c\u9ad8\u662f3\uff0c\u5217\u5bbd\u662f2\uff0c\u90a3\u4e48\u65b0\u7684\u5f15\u7528\u533a\u57df\u5c31\u662fD5:E7<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">e) Offset\u51fd\u6570\u4e2d\u6570\u636e\u6709\u6548\u6027\u4e2d\u5e94\u7528 \u5236\u4f5c\u52a8\u6001\u6709\u6548\u6027\uff0c\u590d\u5236G24\u5355\u5143\u683c\u7684\u516c\u5f0f\u201c=OFFSET($F$24,0,0,COUNTA(F24:F31),1)\u201d==&gt;\u9009\u4e2dH25\u5355\u5143\u683c==&gt;\u6570\u636e\u9009\u9879\u5361==&gt;\u6570\u636e\u5de5\u5177\u7ec4==&gt;\u6570\u636e\u6709\u6548\u6027==&gt;\u8bbe\u7f6e==&gt;\u5e8f\u5217==&gt;\u7c98\u8d34==&gt;\u786e\u5b9a<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">\u4e94\uff0e\u51fd\u6570Match<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">a) \u8fd9\u4e2a\u51fd\u6570\u7684\u4f5c\u7528\uff1a\u8fd4\u56de\u8981\u67e5\u627e\u7684\u503c\u5728\u533a\u57df\u7684\u4f4d\u7f6e\uff0c\u800c\u4e0d\u662f\u5176\u672c\u8eab\u3002\u4e14\u5927\u5bb6\u4e00\u5b9a\u8981\u8bb0\u4f4f\uff0c\u5b83\u7684\u7b2c\u4e8c\u4e2a\u53c2\u6570\u662f\u5355\u884c\u6216\u8005\u662f\u5355\u5217\uff0c\u4e0d\u80fd\u9009\u62e9\u591a\u884c\u591a\u5217\u7684\u533a\u57df<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">b) \u51fd\u6570Match\u6709\u4e09\u4e2a\u53c2\u6570\uff0c\u7b2c\u4e00\u4e2a\u53c2\u6570\u662f\u67e5\u627e\u7684\u503c\uff0c\u7b2c\u4e8c\u4e2a\u53c2\u6570\u662f\u67e5\u627e\u7684\u533a\u57df\u548c\u6570\u636e\uff0c\u7b2c\u4e09\u4e2a\u53c2\u6570\u67e5\u627e\u7684\u65b9\u5f0f<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">c) \u7b2c\u4e09\u4e2a\u53c2\u6570\u6211\u4eec\u8be6\u7ec6\u8bb2\u89e3\u4e00\u4e0b<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">\u7b2c\u4e09\u4e2a\u53c2\u6570\u4e3a0<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">\u90a3\u4e48\u5c31\u7cbe\u786e\u5339\u914d\uff0c\u4e5f\u5c31\u662f\u8bf4\u67e5\u627e\u503c\u5728\u67e5\u627e\u533a\u57df\u627e\u5230\u7684\u503c\u8981\u4e00\u6837\uff0c\u5426\u5219\u627e\u4e0d\u5230\u5c31\u4f1a\u8fd4\u56de\u9519\u8bef\u503c\u6240\uff0c\u4ee5\u8fd9\u4e2a\u53eb\u505a\u7cbe\u786e\u67e5\u627e<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">\u7b2c\u4e09\u4e2a\u53c2\u6570\u4e3a1\u6216\u8005\u7701\u7565<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">\u90a3\u4e48\u7b2c\u4e8c\u4e2a\u53c2\u6570\u91cc\u7684\u6570\u636e\u4e00\u5b9a\u8981\u7528\u5347\u5e8f\u6392\u5e8f\uff0c\u5426\u5219\u7ed3\u679c\u4e0d\u5bf9\u3002\u5982\u679c\u67e5\u627e\u7684\u533a\u57df\u91cc\u6ca1\u6709\u548c\u67e5\u503c\u76f8\u7b49\u7684\u8bdd\uff0c\u90a3\u4e48\u5c31\u4f1a\u518d\u5f80\u6bd4\u67e5\u627e\u503c\u7684\u5c0f\u4e00\u70b9\u7684\u6570\u67e5\uff0c\u4e14\u662f\u627e\u5230\u6700\u63a5\u8fd1\u4e8e\u5b83\u7684\u90a3\u4e2a\u503c\u7684\u4f4d\u7f6e\uff0c\u6240\u4ee5\u53eb\u505a\u6a21\u7cca\u67e5\u627e<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">\u7b2c\u4e09\u53c2\u6570\u4e3a-1<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">\u90a3\u4e48\u7b2c\u4e09\u4e2a\u53c2\u6570\u7684\u6570\u636e\u4e00\u5b9a\u8981\u964d\u5e8f\u6392\u5e8f\uff0c\u5426\u5219\u7ed3\u679c\u4e0d\u5bf9\uff0c\u5982\u679c\u67e5\u627e\u7684\u533a\u57df\u91cc\u6ca1\u6709\u548c\u67e5\u627e\u503c\u76f8\u7b49\u7684\u8bdd\uff0c\u90a3\u4e48\u5c31\u4f1a\u518d\u67e5\u627e\u6bd4\u67e5\u627e\u503c\u5927\u4e00\u70b9\u7684\u6570\u67e5\u627e\uff0c\u4e14\u662f\u6700\u63a5\u8fd1\u4e8e\u67e5\u627e\u503c\u7684\u90a3\u4e2a\u5927\u503c\u6570\u636e\u3002<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">\u516d\uff0e\u51fd\u6570Index<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">a) \u5728\u4e00\u4e2a\u533a\u57df\u4e2d\uff0c\u6839\u636e\u884c\u7684\u4f4d\u7f6e\u548c\u5217\u7684\u4f4d\u7f6e\u6765\u8fd4\u56de\u884c\u4f4d\u7f6e\u548c\u5217\u4f4d\u7f6e\u4ea4\u53c9\u7684\u90a3\u4e2a\u5355\u5143\u683c\u7684\u503c\uff0cIndex\u51fd\u6570\u6709\u4e8c\u79cd\u53c2\u6570\u5f62\u5f0f<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">b) \u7b2c\u4e00\u79cd\u6709\u4e09\u4e2a\u53c2\u6570\uff1a\u7b2c\u4e00\u53c2\u6570\u662f\u6570\u636e\u533a\u57df\u548c\u6570\u636e\uff0c\u7b2c\u4e8c\u53c2\u6570\u662f\u533a\u57df\u4e2d\u7684\u884c\uff0c\u7b2c\u4e09\u53c2\u6570\u662f\u533a\u57df\u7684\u5217<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">c) \u7b2c\u4e8c\u79cd\u6709\u56db\u4e2a\u53c2\u6570\uff1a\u7b2c\u4e00\u662f\u591a\u533a\u57df\u548c\u6570\u636e\uff0c\u7b2c\u4e8c\u53c2\u6570\u662f\u533a\u57df\u4e2d\u7684\u884c\uff0c\u7b2c\u4e09\u53c2\u6570\u662f\u533a\u57df\u7684\u5217\uff0c\u7b2c\u56db\u53c2\u662f\u533a\u57df,\u7684\u7b2c\u51e0\u4e2a\u533a\u57df,\u7279\u522b\u8981\u6ce8\u610f\u7684\u662f\u7b2c\u4e00\u53c2\uff0c\u56e0\u4e3a\u662f\u4e0d\u8fde\u7eed\u7684\u533a\u57df\uff0c\u6211\u4eec\u5f15\u7528\u65f6\u8981\u7528\u62ec\u53f7\u62ec\u4f4f\u5b83\uff0c\u4e0d\u7136\u5c31\u591a\u4e86\u53c2\u6570<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">d) \u5b9e\u4f8b1\u7684\u89e3\u91ca<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">=INDEX($C$16:$F$22,MATCH($H$17,$C$16:$C$22,0),COLUMN(B1))<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">\u7b2c\u4e00\u53c2\u6570\u662f\u533a\u57df\uff0c\u7b2c\u4e8c\u53c2\u6570\u7528\u4e86\u4e00\u4e2aMatch\u51fd\u6570\uff0c\u662f\u6839\u636e\u59d3\u540d\u6765\u786e\u5b9a\u59d3\u540d\u5728C\u5217\u7684\u4f4d\u7f6e\uff0c\u7136\u540e\u544a\u8bc9Index\u7684\u7b2c\u4e8c\u53c2\u884c\u4f4d\u7f6e\uff0c\u7b2c\u4e09\u53c2\u662f\u5217\u4f4d\u7f6e\uff0c\u56e0\u4e3a\u6211\u4eec\u662f\u4ece\u7b2c\u4e8c\u5217\u5f00\u59cb\u5f15\u7528\uff0c\u6240\u4ee5\u7528Column(B1),\u5411\u53f3\u5217\u5c31\u4f1a\u8fd4\u56de2\uff0c3\uff0c4\uff0c5\u2026\u2026\u3002<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">\u7279\u522b\u63d0\u9192\uff1aIndex\u51fd\u6570\uff0c\u5982\u679c\u662f\u7b2c\u4e00\u79cd\uff0c\u6709\u4e09\u4e2a\u53c2\u6570\u7684\u90a3\u79cd<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">1.\u5982\u679c\u7701\u7565\u7b2c\u4e8c\u53c2\u6570\uff0c\u90a3\u4e48\u5c31\u8fd4\u56de\u7b2c\u4e09\u53c2\u6570\u7684\u90a3\u4e00\u6574\u5217<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">2..\u5982\u679c\u7701\u7565\u7b2c\u4e09\u53c2\u6570\uff0c\u90a3\u4e48\u5c31\u8fd4\u56de\u7b2c\u4e8c\u53c2\u6570\u7684\u90a3\u4e00\u6574\u884c<\/span><\/p>\n<h2 class=\"md-end-block md-heading\"><span class=\"md-plain\">\u7b2c\u56db\u8bb2 \u51fd\u6570 And Or Small Large Lookup Indirect Substitute Text<\/span><\/h2>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">\u4e00\uff0e\u51fd\u6570And<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">a) \u8fd9\u4e2a\u51fd\u6570\u662f\u5373\u2026\u2026\u53c8\u7684\u610f\u601d\uff0c\u800c\u4e14\u7684\u610f\u601d\uff0c\u4e5f\u5c31\u662f\u5b83\u91cc\u7684\u53c2\u6570\u6761\u4ef6\u90fd\u8981\u6ee1\u8db3\uff0c\u5b83\u7684\u7ed3\u679c\u8fd4\u56deTRUE\uff0c\u5426\u5219\u8fd4\u56deFalse<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">\u4e8c\uff0e\u51fd\u6570Or<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">a) Or\u51fd\u6570\u662f\u6216\u8005\u2026\u2026\u6216\u8005\u7684\u610f\u601d\uff0c\u53ea\u8981\u6ee1\u8db3\u91cc\u53c2\u6570\u91cc\u7684\u4e00\u4e2a\u6761\u4ef6\uff0c\u7ed3\u679c\u5c31\u8fd4\u56deTrue\uff0c\u5982\u679c\u5168\u90e8\u4e0d\u6ee1\u8db3\u5c31\u4f1a\u8fd4\u56deFlase<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">\u4e09\uff0e\u51fd\u6570Small<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">a) \u8fd9\u4e2a\u51fd\u6570\u7684\u4f5c\u7528\u662f\u8fd4\u56de\u4e00\u4e32\u6570\u5b57\u7684\u4e2d\u7b2c\u51e0\u5c0f\uff1f\u6709\u4e8c\u4e2a\u53c2\u6570\uff0c\u7b2c\u4e00\u4e2a\u53c2\u6570\u662f\u4e00\u4e32\u6570\u5b57\uff0c\u7b2c\u4e8c\u4e2a\u53c2\u6570\u662f\u7b2c\u51e0\u5c0f\uff1f<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">b) \u642d\u914dif\u51fd\u6570\u7528\u5904\u5f88\u5927<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">\u56db\uff0e\u51fd\u6570Large<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">a) \u8fd9\u4e2a\u51fd\u6570\u548cSmall\u51fd\u6570\u662f\u4e00\u5bf9\uff0c\u5b83\u7684\u4f5c\u7528\u662f\u8fd4\u56de\u7b2c\u51e0\u5927\u3002\u53c2\u6570\u6709\u4e8c\u4e2a\uff0c\u7b2c\u4e00\u4e2a\u53c2\u6570\u662f\u6570\u636e\u533a\u57df\uff0c\u7b2c\u4e8c\u4e2a\u53c2\u6570\u662f\u7b2c\u51e0\u5927\uff1f<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">\u4e94\uff0e\u51fd\u6570Lookup<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">a) lookup\u51fd\u6570\u7684\u53c2\u6570\u6709\u4e8c\u79cd\u5f62\u5f0f\uff0c\u4e00\u662f\u5411\u91cf\uff0c\u4e8c\u662f\u6570\u7ec4<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">b) \u5982\u679c\u662f\u5411\u91cf\uff0c\u4e00\u5b9a\u8981\u5148\u5347\u5e8f\u6392\u5e8f\u7b2c\u4e8c\u53c2\u6570<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">c) \u5411\u91cf\uff1a\u7b2c\u4e00\u53c2\uff1a\u67e5\u627e\u503c\uff0c\u7b2c\u4e8c\u53c2\u67e5\u627e\u503c\u6240\u5728\u7684\u533a\u57df\uff0c\u7b2c\u4e09\u53c2\u8fd4\u56de\u7684\u7ed3\u679c<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">d) \u6570\u7ec4\uff1a\u7b2c\u4e00\u53c2\uff1a\u67e5\u627e\u503c\uff0c\u7b2c\u4e8c\u53c2\uff1a\u67e5\u627e\u533a\u57df\u662f\u6570\u7ec4<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">e) \u5b9e\u4f8b\u4e00\uff1a\u6839\u636e\u5206\u6570\u7b97\u6210\u7ee9=LOOKUP(L14,{0,60,70,80;\"\u4e0d\u53ca\u683c\",\"\u53ca\u683c\",\"\u826f\u597d\",\"\u4f18\u79c0\"})<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">\u89e3\u91ca\uff1a\u7b2c\u4e00\u53c2\u6570\u662f\u67e5\u627e\u503c\uff0c\u7b2c\u4e8c\u53c2\u6570\u662f\u67e5\u627e\u503c\u6240\u5728\u7684\u533a\u57df\uff0c\u5fc5\u987b\u8981\u5347\u5e8f\u6392\u5e8f\uff0c\u7b2c\u4e09\u53c2\u6570\u662f\u7ed3\u679c<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">f) \u5b9e\u4f8b\u4e8c\uff1a\u63d0\u53d6\u4e00\u884c\u6700\u540e\u4e00\u4e2a\u975e\u7a7a\u5355\u5143\u683c\u7684\u6570\u636e=LOOKUP(1,0\/(C27:K27&lt;&gt;\"\"),C27:K27)<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">\u89e3\u91ca\uff1a\u7b2c\u4e00\u53c2\u6570\u662f\u67e5\u627e\u503c\uff0c\u7b2c\u4e8c\u53c2\u6570\u91ccC27:K27&lt;&gt;\"\"\u662f\u5224\u65ad\u4e0d\u4e3a\u7a7a\uff0c\u8fd9\u6837\u6709\u6570\u636e\u7684\u5355\u5143\u683c\u5c31\u8fd4\u56deTrue,\u800cTrue\u5728\u8fd0\u7b97\u65f6\u5f53\u4f5c1\uff0c\u800c\u6ca1\u6709\u6570\u636e\u7684\u5355\u5143\u683c\u5c31\u8fd4\u56deFalse\uff0c\u800cFalse \u5728\u8fd0\u7b97\u65f6\u5f53\u4f5c0\uff0c\u75280\u6765\u9664\u4ee50\u8fd4\u56de\u4e00\u4e2a\u9519\u8bef\u503c\uff0c\u800c\u75280\u9664\u4ee51\u8fd4\u56de0\uff0c\u8fd9\u6837\u6709\u6570\u636e\u5355\u5143\u683c\u5c31\u8fd4\u56de0\uff0c\u8fd9\u6837\u5c31\u6709\u8bb8\u591a\u4e2a0\uff0c\u4f46lookup\u6709\u4e00\u4e2a\u7279\u70b9\uff0c\u5982\u679c\u67e5\u627e\u503c\u5728\u67e5\u627e\u533a\u57df\u91cc\u6709\u8bb8\u591a\u4e2a\u65f6\uff0c\u5c31\u8fd4\u56de\u6700\u540e\u4e00\u4e2a\u3002\u7136\u540e\u5728\u7b2c\u4e09\u53c2\u6570\u76f8\u5e94\u7684\u4f4d\u7f6e\u627e\u5230\u67e5\u627e\u7684\u7ed3\u679c<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">g) \u6ca1\u6709\u6392\u5e8f\u600e\u6837\u7528lookup\u67e5\u627e=LOOKUP(1,0\/($B$39:$B$44=$H39),C$39:C$44)<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">\u89e3\u91ca\uff1a\u7b2c\u4e00\u53c2\u6570\u662f\u67e5\u627e\u503c\u4e3a1\uff0c\u7b2c\u4e8c\u53c2\u6570\u5148\u7528$B$39:$B$44=$H39\u5224\u65ad\uff0c\u6210\u7acb\u5c31\u8fd4\u56deTrue\uff0c\u4e0d\u6210\u7acb\u7684\u5c31\u8fd4\u56deFalse \u7136\u540e\u75280\u6765\u9664\u4ee5\u5b83\u4eec\uff0c\u8fd9\u6837\u6210\u7acb\u7684\u5c31\u5f97\u5230\u4e860\uff0c\u800c\u4e0d\u6210\u7acb\u7684\u5c31\u8fd4\u56de\u9519\u8bef\u503c\u4e86\uff0c\u8fd9\u6837\u5c31\u627e\u5230\u4e86\u6210\u7acb\u7684\u90a3\u4e2a\u6570\u636e\u4f4d\u7f6e\uff0c\u6700\u540e\u4ece\u7b2c\u4e09\u53c2\u6570\u76f8\u5e94\u7684\u4f4d\u7f6e\u627e\u5230\u6570\u636e\u663e\u793a\u51fa\u6765\u3002<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">h) \u6839\u636e\u59d3\u540d\u5f15\u7528\u5404\u5458\u5de5\u7684\u4fe1\u606f\uff0c\u6211\u4eec\u53ef\u4ee5\u7528Vlookup\u67e5\u627e\uff0c\u5b83\u53ea\u80fd\u5b9e\u73b0\u9996\u5217\u67e5\u627e\uff0c\u4e0d\u80fd\u5b9e\u73b0\u5411\u53f3\u67e5\u627e\uff0c\u5982\u679c\u8981\u5b9e\u73b0\uff0c\u8981\u501f\u52a9\u522b\u7684\u51fd\u6570\uff0c\u6211\u4eec\u53ef\u4ee5\u7528lookup\u6765\u5b9e\u73b0=LOOKUP(1,0\/($C$58:$C$63=$H58),INDEX($B$58:$E$63,,MATCH(I$57,$B$57:$E$57,0)))<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">\u89e3\u91ca\uff1a\u7b2c\u4e00\u53c2\u6570\u67e5\u627e\u662f1\uff0c\u76f8\u4fe1\u5927\u5bb6\u5bf9\u5b83\u6709\u4e86\u4e00\u5b9a\u4e86\u89e3\uff0c\u4e5f\u5c31\u662fLookup\u627e\u4e0d\u5230\u548c\u67e5\u627e\u503c\u4e00\u6837\u7684\u65f6\uff0c\u5b83\u5c31\u4f1a\u627e\u6bd4\u5b83\u5c0f\u4e14\u8fd8\u8981\u6700\u63a5\u8fd1\u4e8e\u5b83\u7684\u90a3\u4e2a\u503c\uff1b\u7b2c\u4e8c\u53c2\u6570\u5c31\u662f\u5229\u75280\u6765\u9664\u4ee51\u5f97\u52300\uff0c\u800c0\u9664\u4ee50\u5f97\u5230\u4e00\u4e2a\u9519\u8bef\u503c\uff0c\u8fd9\u6837\u5c31\u627e\u5230\u4e86\u7b26\u5408\u6761\u4ef6\u7684\u5bf9\u5e94\u7684\u90a3\u4e2a\u4f4d\u7f6e\uff0c\u800c\u7b2c\u4e09\u53c2\u6570\u521a\u597d\u7528\u51fd\u6570Indext\u8fd9\u4e2a\u51fd\u6570\uff0c\u8fd9\u4e2a\u51fd\u6570\u5982\u679c\u7b2c\u4e8c\u53c2\u6570\u7701\u7565\uff0c\u90a3\u4e48\u5c31\u8fd4\u56de\u7b2c\u4e09\u53c2\u6570\u7684\u6574\u5217\uff0c\u8fd9\u6837\u521a\u597d\u505aLookup\u51fd\u6570\u7684\u7b2c\u4e09\u53c2\u6570\uff0c\u4ece\u800c\u5b9e\u73b0\u4e86\u975e\u9996\u884c\u67e5\u627e\u3002\u8fd9\u91cc\u7684Match\u51fd\u6570\u7acb\u4e86\u5927\u529f\uff0c\u56e0\u4e3a\u6211\u4eec\u8fd9\u4e2a\u533a\u57df\u7684\u5217\u53f7\u4e0d\u80fd\u786e\u5b9a\uff0c\u6240\u4ee5\u7528Match\u51fd\u6570\u6765\u786e\u5b9a\uff0cMatch\u51fd\u6570\u521a\u597d\u6709\u8fd9\u4e2a\u529f\u80fd\uff0c\u67e5\u627e\u5355\u884c\uff0c\u5355\u5217\u7684\u6570\u636e\u6240\u5728\u7684\u4f4d\u7f6e\u3002<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">\u516d\uff0e\u51fd\u6570indirect<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">a) \u8fd4\u56de\u6587\u672c\u5b57\u7b26\u4e32\u6240\u6307\u5b9a\u7684\u5f15\u7528<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">b) \u8fd9\u4e2a\u51fd\u6570\u53c2\u6570\u5fc5\u987b\u662f\u5355\u5143\u683c\u5730\u5740\uff0c\u7ed3\u679c\u662f\u8fd4\u56de\u8fd9\u4e2a\u5355\u5143\u683c\u5730\u5740\u91cc\u6570\u636e<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">c) \u5b9e\u5217\u4e00\uff1a\u5236\u4f5c\u4e8c\u7ea7\u4e0b\u62c9\u83dc\u5355<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">\u7b2c\u4e00\u6b65\uff1a\u521b\u5efa\u5217\u8868\uff0c\u76ee\u7684\u662f\u52a8\u6001\u7684\uff0c\u4e3a\u4e86\u540e\u671f\u7684\u6dfb\u52a0<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">\u7b2c\u4e8c\u6b65\uff1a\u9009\u4e2d\u533a\u57dfH6:H25,\u6570\u636e\u6709\u6548\u6027\uff0c\u5e8f\u5217\uff0c\u6570\u636e\u6e90\u6765\u6e90\u4e8eD3:F3<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">\u7b2c\u4e09\u6b65\uff1a\u5b9a\u4e49\u4e09\u4e2a\u540d\u79f0\uff0c\u5206\u522b\u53eb\u505a\u5e7f\u4e1c\u7701\uff0c\u6e56\u5357\u7701\uff0c\u6e56\u5317\u7701<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">\u7b2c\u56db\u6b65\uff1a\u9009\u4e2d\u534e\u533a\u57dfI16:I25\uff1d\uff1d\u3009\u6570\u636e\u9009\u9879\u5361\uff1d\uff1d\u3009\u6570\u636e\u6709\u6548\u6027\uff1d\uff1d\u3009\u5e8f\u5217\uff1d\uff1d\u3009\u8f93\u5165\u516c\u5f0f=indirect(H16) \uff1d\uff1d\u3009\u786e\u5b9a\uff1d\uff1d\u3009<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">\u5907\u6ce8\uff1aH16\u4e00\u5b9a\u8981\u7528\u76f8\u5bf9\u5f15\u7528<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">\u4e03\uff0e\u51fd\u6570Substitute<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">a) \u67e5\u627e\u66ff\u6362\u51fd\u6570<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">b) \u8fd9\u4e2a\u51fd\u6570\u6709\u56db\u4e2a\u53c2\u6570\uff0c\u7b2c\u4e00\u4e2a\u53c2\u6570\u662f\u8981\u67e5\u627e\u66ff\u6362\u7684\u6587\u672c<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">c) \u7b2c\u4e8c\u53c2\u6570\u8981\u66ff\u6362\u4e3a\u7684\u5b57\u7b26\uff0c\u4e5f\u5c31\u662f\u65b0\u7684\u6587\u672c\uff1b\u7b2c\u4e09\u53c2\u6570\u88ab\u66ff\u6362\u4e3a\u7684\u5b57\u7b26\uff0c\u4e5f\u5c31\u662f\u539f\u6765\u7684\u90a3\u4e2a\uff0c\u65e7\u7684\uff1b\u7b2c\u56db\u53c2\u662f\u8fd9\u6837\u7684\uff0c\u5982\u679c\u8981\u66ff\u6362\u7684\u6587\u672c\u6709\u8bb8\u591a\uff0c\u90a3\u4e48\u5c31\u8981\u6307\u5b9a\u66ff\u6362\u7b2c\u51e0\u4e2a\uff0c\u5982\u679c\u7b2c\u56db\u53c2\u6570\u7701\u7565\u90a3\u4e48\u5c31\u628a\u91cc\u9762\u5168\u90e8\u66ff\u6362\u3002<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">\u516b\uff0e\u51fd\u6570Text<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">a) \u628a\u6570\u5b57\u6839\u636e\u6307\u5b9a\u7684\u683c\u5f0f\u8f6c\u4e3a\u6587\u672c<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">b) \u8fd9\u4e2a\u51fd\u6570\u6709\u4e8c\u4e2a\u53c2\u6570\uff0c\u7b2c\u4e00\u4e2a\u53c2\u6570\u5c31\u662f\u8981\u8f6c\u5316\u7684\u6570\u5b57\uff0c\u7b2c\u4e8c\u53c2\u6570\u662f\u6307\u5b9a\u7684\u683c\u5f0f<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">c) \u5b9e\u4f8b\u201c\u628a\u5c0f\u4e0e\u6570\u5b57\u8f6c\u4e3a\u5927\u5199\u91d1\u989d\u201d=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(TEXT(F10*100,\"[Dbnum2]0\u767e0\u62fe0\u51430\u89d20\u5206\"),\"\u96f6\u767e\",\"\"),\"\u96f6\u62fe\",\"\"),\"\u96f6\u5143\",\"\"),\"\u96f6\u89d2\",\"\"),\"\u96f6\u5206\",\"\")<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">\u516c\u5f0f\u89e3\u91ca\uff1aText\u7b2c\u4e00\u4e2a\u53c2\u6570\u4e58\u4ee5100\uff0c\u76ee\u7684\u662f\u4e3a\u4e86\u53bb\u6389\u90a3\u4e2a\u5c0f\u6570\u70b9\u53f7\uff0c[Dbnum2]\u662f\u6570\u5b57\u5927\u5199\u7684\u683c\u5f0f\uff0c\u5927\u5bb6\u53ef\u4ee5\u53bb\u81ea\u5b9a\u4e49\u5355\u5143\u683c\u683c\u5f0f\u91cc\u67e5\u627e\uff0c\u201c0\u767e0\u62fe0\u51430\u89d20\u5206\u201d\u8fd9\u4e9b\u662f0\u662f\u6570\u5b57\u5360\u4f4d\u7b26\uff0c\u6211\u4eec\u5728\u5355\u5143\u683c\u683c\u5f0f\u90a3\u8282\u8bfe\u5df2\u7ecf\u8bb2\u8fc7\uff0c\u7531\u4e8e\u5f53\u6211\u4eec\u6ca1\u6709\u767e\u4f4d\u65f6\uff0c\u5c31\u4f1a\u51fa\u73b0\u201c\u96f6\u767e\u201d\u8fd9\u4e24\u4e2a\u5b57\uff0c\u800c\u8fd9\u79cd\u4e0d\u7b26\u5408\u6211\u4eec\u4e2d\u56fd\u4eba\u7684\u4e60\u60ef\uff0c\u6240\u4ee5\u540e\u7528Substitute\u8fd9\u4e2a\u51fd\u6570\u6765\u66ff\u6362\u4e3a\u7a7a\uff0c\u540c\u7406\u201c\u96f6\u62fe\u201d\uff0c\u96f6\u5143\uff0c\u96f6\u89d2\uff0c\u96f6\u5206\u201c\u4e5f\u662f\u8fd9\u4e2a\u9053\u7406\uff0c\u90fd\u7528Substitute\u8fd9\u4e2a\u51fd\u6570\u6765\u66ff\u6362\u4e3a\u7a7a<\/span><\/p>\n<h2 class=\"md-end-block md-heading\"><span class=\"md-plain\">\u7b2c\u4e94\u8bb2 \u51fd\u6570Iserror Iferror Count Counta Countif Vlookup Hlookup Sum Sumif Sumifs<\/span><\/h2>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">\u4e00\uff0e \u51fd\u6570iserror<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">a) \u68c0\u67e5\u4e00\u4e2a\u516c\u5f0f\u662f\u5426\u6709\u9519\u8bef\uff0c\u5982\u679c\u6709\u5c31\u8fd4\u56deTrue \u53cd\u4e4b\u8fd4\u56deFalse\uff0c\u4e00\u822c\u642d\u914dif\u4f7f\u7528<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">\u4e8c\uff0e \u51fd\u6570iferror<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">a) \u7b2c\u4e00\u4e2a\u53c2\u6570\uff0c\u68c0\u67e5\u516c\u5f0f\u7684\u8ba1\u7b97\u7ed3\u679c\u662f\u5426\u5b58\u5728\u9519\u8bef\uff0c\u5982\u679c\u6ca1\u6709\u9519\u8bef\u5219\u8fd4\u56de\u516c\u5f0f\u7684\u7ed3\u679c\uff1b\u7b2c\u4e8c\u4e2a\u53c2\u6570\uff0c\u516c\u5f0f\u7684\u8ba1\u7b97\u7ed3\u679c\u4e3a\u9519\u8bef\u65f6\u8981\u8fd4\u56de\u7684\u503c\uff0c\u8ba1\u7b97\u5f97\u5230\u7684\u9519\u8bef\u7c7b\u578b\u6709\uff1a#N\/A\u3001#VALUE!\u3001#REF!\u3001#DIV\/0!\u3001#NUM!\u3001#NAME? \u3001 #NULL!<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">\u4e09\uff0e \u51fd\u6570Count<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">a) \u7edf\u8ba1\u5355\u5143\u683c\u533a\u57df\u6709\u6570\u5b57\u7684\u5355\u5143\u683c\u4e2a\u6570<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">\u56db\uff0e \u51fd\u6570Counta<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">a) Counta\u662f\u7edf\u8ba1\u975e\u7a7a\u5355\u5143\u683c\u7684\u4e2a\u6570<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">\u4e94\uff0e \u51fd\u6570Countif<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">a) Countif\u51fd\u6570\u6309\u6761\u4ef6\u7edf\u8ba1\u5355\u5143\u683c\u7684\u4e2a\u6570\uff0c\u6709\u4e8c\u4e2a\u53c2\u6570\uff0c\u7b2c\u4e00\u4e2a\u53c2\u6570\uff0c\u6761\u4ef6\uff1b\u7b2c\u4e8c\u4e2a\u53c2\u6570\uff0c\u6761\u4ef6\u6240\u5728\u7684\u533a\u57df<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">b) \u5b9e\u5217\u4e00\uff1a\u5982\u679c\u91cd\u590d\u5c31\u5728\u5907\u6ce8\u5217\u663e\u793a\u91cd\u590d\u4e8c\u5b57<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">=IF(COUNTIF($D$40:D40,D40)&gt;1,\"\u91cd\u590d\",\"\")<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">c) \u5b9e\u5217\u4e8c\uff1a\u51fa\u73b0\u4e8c\u6b21\u5c31\u663e\u6807\u793a\u7ea2\u8272\u5e95\u7eb9\uff0c\u51fa\u73b0\u4e00\u6b21\u5c31\u4e0d\u7528\u63d0\u793a,\uff08\u8fd9\u4e2a\u51fd\u6570\u5728\u6761\u4ef6\u683c\u5f0f\u91cc\u7684\u5e94\u7528\uff09\u65b9\u6cd5\uff0c\u9009\u4e2d\u4f60\u5b9e\u73b0\u8fd9\u79cd\u529f\u80fd\u7684\u533a\u57df\uff1d\uff1d&gt;\u5f00\u59cb\u9009\u9879\u5361\uff1d\uff1d&gt;\u6837\u5f0f\u7ec4\uff1d\uff1d&gt;\u6761\u4ef6\u683c\u5f0f\uff1d\uff1d&gt;\u65b0\u5efa\u89c4\u5219\uff1d\uff1d&gt;\u4f7f\u7528\u516c\u5f0f\u786e\u5b9a\u8bbe\u7f6e\u683c\u5f0f\u7684\u5355\u5143\u683c\uff1d\uff1d&gt;\u8f93\u5165\u4e0b\u9762\u7684\u516c\u5f0f\uff1d\uff1d&gt;\u786e\u5b9a<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">=COUNTIF(D$11:D11,D11)&gt;1<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">d) \u5f53\u4f60\u8f93\u5165\u91cd\u590d\u7684\u59d3\u540d\u65f6\uff0c\u8981\u63d0\u9192\u7528\u6237\u3002Countif\u51fd\u6570\u5728\u6709\u6548\u6027\u91cc\u5e94\u7528\uff0c\u65b9\u6cd5\uff1a\u9009\u4e2d\u4f60\u5b9e\u73b0\u8fd9\u79cd\u529f\u80fd\u7684\u533a\u57df\uff1d\uff1d&gt;\u6570\u636e\u9009\u9879\u5361\uff1d\uff1d&gt;\u6570\u636e\u5de5\u5177\u7ec4\uff1d\uff1d&gt;\u6570\u636e\u6709\u6548\u6027\uff1d\uff1d&gt;\u8bbe\u7f6e\uff1d\uff1d&gt;\u5141\u8bb8\uff1d\uff1d&gt;\u81ea\u5b9a\u4e49\uff1d\uff1d&gt;\u8f93\u5165\u516c\u5f0f\u201c=COUNTIF($D$26:$D$34,D30)=1\u201d \uff1d\uff1d&gt;\u51fa\u9519\u8b66\u544a\u4e2d\u8f93\u5165\u201c\u4f60\u8f93\u5165\u4e86\u91cd\u590d\u7684\u59d3\u540d\u4e86\u201d \uff1d\uff1d&gt;\u786e\u5b9a<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">\u516d\uff0e \u51fd\u6570Vlookup<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">a) Vlookupp \u8fd9\u4e2a\u51fd\u6570\u6709\u56db\u4e2a\u53c2\u6570\uff0c\u4f5c\u7528\u662f\u6839\u636e\u9996\u5217\u6765\u67e5\u627e<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">b) vlookup\u51fd\u6570\u662f\u4e00\u4e2a\u5f15\u7528\u67e5\u627e\u51fd\u6570\uff0c\u5b83\u6709\u56db\u4e2a\u53c2\u6570\uff0c\u7b2c\u4e00\u53c2\uff1a\u67e5\u627e\u503c\uff0c\u7b2c\u4e8c\u53c2\uff1a\u67e5\u627e\u533a\u57df\uff0c\u7b2c\u4e09\u53c2\uff1a\u8fd4\u56de\u67e5\u627e\u533a\u57df\u4e2d\u7684\u7b2c\u51e0\u5217\uff0c\u4e0d\u662f\u6574\u4e2a\u8868\u683c\u7684\u7b2c\u51e0\u5217\uff0c\u7b2c\u56db\u53c2\u662f\u67e5\u627e\u7684\u65b9\u6cd5\uff0c\u5206\u4e3a\u7cbe\u786e\u5339\u914d\u548c\u8fd1\u4f3c\u5339\u914d\uff0c0\u4e3a\u7cbe\u786e\u5339\u914d\uff0c1\u4e3a\u8fd1\u4f3c\u5339\u914d<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">c) \u5b9e\u4f8b\u4e00\uff1a\u6839\u636e\u59d3\u540d\u67e5\u627e\u5e95\u85aa\uff0c\u516c\u5f0f\u5982\u4e0b<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">=VLOOKUP(B25,C14:E19,3,0)<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">d) \u5b9e\u4f8b\u4e8c\uff1a\u8f93\u5165\u59d3\u540d\u81ea\u52a8\u663e\u793a\u5de5\u53f7\uff0c\u6027\u522b\uff0c\u5e95\u85aa\uff0c\u516c\u5f0f\u5982\u4e0b<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">=VLOOKUP($B$41,$B$31:$E$37,COLUMN(B1),0)<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">\u516c\u5f0f\u89e3\u91ca\uff1a\u7b2c\u4e00\u4e2a\u53c2\u6570\u67e5\u627e\u503c\uff0c\u7b2c\u4e8c\u4e2a\u53c2\u6570\u67e5\u627e\u533a\u57df\uff0c\u7b2c\u4e09\u53c2\u6570\u7528\u4e86Column(B1),\u8fd4\u56de2\uff0c\u5f80\u53f3\u62c9\u4f9d\u6b21\u4ea7\u751f2\uff0c3\uff0c4\uff0c\u2026\u2026\uff1b\u7b2c\u56db\u53c2\u6570\u662f\u67e5\u627e\u65b9\u6cd5\uff0c\u7cbe\u786e\u67e5\u627e\uff0c\u4e5f\u5c31\u662f\u8bf4\u8981\u4e00\u6a21\u4e00\u6837\u3002<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">e) \u5b9e\u4f8b\u4e09\uff1a\u5982\u679c\u67e5\u627e\u503c\u4e0d\u5728\u9996\u5217\u600e\u6837\u67e5\u627e\uff0c\u516c\u5f0f\u5982\u4e0b<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">=VLOOKUP($B$56,IF({1,0},C47:C52,B47:B52),2,0)<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">\u516c\u5f0f\u89e3\u91ca\uff1a\u7b2c\u4e00\u53c2\u6570\u662f\u67e5\u627e\u503c\uff1b\u7b2c\u4e8c\u53c2\u6570\u7528\u4e86\u4e00\u4e2aIF\u51fd\u6570\uff0c\u4e14\u91cc\u9762\u8fd8\u6709\u4e00\u4e2a\u5e38\u91cf\u6570\u7ec4\uff0c\u5b83\u7684\u4f5c\u7528\u5c31\u662f\u5728\u67e5\u627e\u7684\u8fc7\u7a0b\u4e2d\u628aC\u5217\u548cB\u5217\u7684\u4f4d\u7f6e\u5bf9\u8c03\u4e86\u4e00\u4e0b\uff1b\u7b2c\u4e09\u53c2\u6570\u662f2\uff0c\u56e0\u4e3a\u5bf9\u8c03\u4e4b\u540e\uff0c\u7b2c\u4e8c\u5217\u5c31\u662f\u5de5\u53f7\u4e86\uff1b\u7b2c\u56db\u53c2\u6570\u662f\u67e5\u627e\u7684\u65b9\u6cd5\u3002<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">\u4e03\uff0e \u51fd\u6570Hlookup<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">a) Hlookup\u51fd\u6570\u67094\u4e2a\u53c2\u6570\uff0c\u8fd9\u4e2a\u51fd\u6570\u7684\u4f5c\u7528\u662f\u6839\u636e\u9996\u884c\u6765\u67e5\u627e<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">b) \u7b2c\u4e00\u53c2\uff0c\u67e5\u627e\u7684\u503c\uff1b\u7b2c\u4e8c\u53c2\uff0c\u662f\u67e5\u627e\u533a\u57df\uff1b\u7b2c\u4e09\u53c2\uff0c\u8fd4\u56de\u8fd9\u4e2a\u67e5\u627e\u533a\u57df\u884c\u53f7\uff0c\u4e0d\u662f\u6574\u4e2a\u8868\u683c\u7684\u884c\uff1b\u7b2c\u56db\u53c2\uff0c\u67e5\u627e\u7684\u65b9\u6cd5<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">c) \u5b9e\u4f8b\uff1a\u6839\u636e\u6708\u5206\u548c\u540d\u5b57\u67e5\u627e\u9500\u552e\u91d1\u989d<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">=HLOOKUP(G22,E13:J18,MATCH(G23,D13:D18,0),0)\u5f53\u7136\u4e5f\u53ef\u4ee5Vlookup\u5b9e\u73b0\uff0c\u516c\u5f0f=VLOOKUP(G23,D13:J18,MATCH(<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">G22,D13:J13,0),0)<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">\u516b\uff0e \u51fd\u6570Sum<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">a) \u8bed\u6cd5\uff1aSUM(number1,number2,...)<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">b) \u8fd4\u56denumber1,number2\u7b49\u4e2d\u6570\u5b57\u3001\u903b\u8f91\u503c\u53ca\u6570\u5b57\u7684\u6587\u672c\u8868\u8fbe\u5f0f\u4e4b\u548c<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">\u4e5d\uff0e \u51fd\u6570Sumif<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">a) Sumif\u662f\u6309\u6761\u4ef6\u6c42\u548c\uff0c\u6709\u4e09\u4e2a\u53c2\u6570\uff0c\u7b2c\u4e00\u4e2a\u53c2\u6570\u662f\u6761\u4ef6\u6240\u5728\u7684\u533a\u57df\uff0c\u7b2c\u4e8c\u4e2a\u53c2\u6570\u662f\u6761\u4ef6\uff0c\u7b2c\u4e09\u4e2a\u53c2\u6570\u662f\u771f\u6b63\u8981\u6c42\u548c\u7684\u533a\u57df<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">b) \u5b9e\u4f8b\uff0c\u586b\u597d\u8fdb\u4ed3\u8868\u548c\u51fa\u4ed3\u8868\u4e2d\u7684\u6570\u636e\u81ea\u52a8\u7b97\u51fa\u5e93\u5b58\u8868\u4e2d\u7684\u6570\u636e<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">=SUMIF($B$26:$B$33,I26,$C$26:$C$33)-SUMIF($F$26:$F$33,I26,$G$26:$G$33)<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">\u89e3\u91ca\uff1a\u7528Sumif\u51fd\u6570\u7b97\u51fa\u8fdb\u4ed3\u8868A\u4ea7\u54c1\u7684\u6570\u91cf\u548c\uff0c\u7136\u540e\u51cf\u53bb\u51fa\u4ed3\u8868\u4e2dA\u4ea7\u54c1\u7684\u6570\u91cf\uff0c\u5c31\u5f97\u5230\u5e93\u5b58\u8868\u7684A\u4ea7\u54c1\u7684\u6570\u91cf\uff0c\u505a\u4ed3\u7ba1\u7684\u4e00\u5b9a\u8981\u7528\u8fd9\u4e2a\u51fd\u6570<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">\u5341\uff0e \u51fd\u6570Sumifs<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">a) Sumifs\u662f\u591a\u6761\u4ef6\u6c42\u548c\uff0c\u7b2c\u4e00\u4e2a\u53c2\u6570\u662f\u771f\u6b63\u8981\u6c42\u548c\u7684\u533a\u57df\uff0c\u7b2c\u4e8c\u4e2a\u53c2\u6570\u662f\u6761\u4ef61\u6240\u5728\u7684\u533a\u57df\uff0c\u7b2c\u4e09\u4e2a\u53c2\u6570\u662f\u6761\u4ef61\uff0c\u4ece\u7b2c\u56db\u4e2a\u53c2\u6570\u5f00\u59cb\u4e3a\u975e\u5fc5\u987b\u53c2\u6570\uff0c\u7b2c\u56db\u4e2a\u53c2\u6570\u662f\u6761\u4ef62\u6240\u5728\u7684\u533a\u57df\uff0c\u7b2c\u4e94\u4e2a\u53c2\u6570\u662f\u6761\u4ef62\uff0c\u4ee5\u6b64\u7c7b\u63a8<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">b) \u5b9e\u4f8b\uff0c\u7edf\u8ba1\u67d0\u4e00\u5458\u5de5\u67d0\u4e00\u4e2a\u6708\u7684\u5de5\u8d44<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">=SUMIFS(\u5de5\u8d44\u8868!$V:$V,\u5de5\u8d44\u8868!$B:$B,$C15,\u5de5\u8d44\u8868!$A:$A,F$1)<\/span><\/p>\n<h2 class=\"md-end-block md-heading\"><span class=\"md-plain\">\u7b2c\u516d\u8bb2 \u51fd\u6570Sumproduct Eomonth Ceiling Floor Mmult Clean Abs Phonetic<\/span><\/h2>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">\u4e00\uff0e\u51fd\u6570sumproduct<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">a) \u4f5c\u7528\uff1a\u5728\u7ed9\u5b9a\u7684\u51e0\u7ec4\u6570\u7ec4\u4e2d\uff0c\u5c06\u6570\u7ec4\u95f4\u5bf9\u5e94\u7684\u5143\u7d20\u76f8\u4e58\uff0c\u5e76\u8fd4\u56de\u4e58\u79ef\u4e4b\u548c<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">b) \u53c2\u6570\uff1a\u8fd9\u4e2a\u51fd\u6570\u6709255\u4e2a\u53c2\u6570\uff0c\u7b2c\u4e00\u4e2a\u53c2\u6570\u662f\u6570\u7ec41\uff0c\u7b2c\u4e8c\u4e2a\u53c2\u6570\u662f\u4e0e\u6570\u7ec41\u76f8\u540c\u7ef4\u6570\u7684\u6570\u7ec42\uff0c\u4ee5\u6b64\u7c7b\u63a8<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">c) \u7528\u6cd5\u4e3e\u4f8b\uff1a\u4e1a\u52a1\u5458\u9500\u552e\u4e0d\u540c\u7c7b\u578b\u7684\u4ea7\u54c1\uff0c\u5bf9\u5e94\u4e0d\u540c\u7684\u63d0\u6210\u7cfb\u6570\uff0c\u7b97\u5176\u63d0\u6210\uff1b\u53ef\u4ee5\u7528\u6b64\u51fd\u6570\u66ff\u4ee3\u666e\u901a\u51fd\u6570\u7684\u6570\u7ec4\u6a21\u5f0f\u7b49\u3002<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">\u4e8c\uff0e\u51fd\u6570eomonth<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">a) \u4f5c\u7528\uff1a\u8ba1\u7b97\u6307\u5b9a\u65e5\u671f\u4e4b\u524d\u6216\u8005\u4e4b\u540e\u51e0\u4e2a\u6708\u7684\u65e5\u671f\uff0c\u8fd4\u56de\u7ed3\u679c\u65e5\u671f\u7684\u5f53\u6708\u6700\u540e\u4e00\u5929\u3002<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">b) \u53c2\u6570\uff1a\u8fd9\u4e2a\u51fd\u6570\u6709\u4e24\u4e2a\u53c2\u6570\uff0c\u7b2c\u4e00\u4e2a\u53c2\u6570\u662f\u5f00\u59cb\u65e5\u671f\uff0c\u7b2c\u4e8c\u4e2a\u53c2\u6570\u662f\u8bbe\u5b9a\u6708\u6570\uff0c\u5f53\u6708\u8bbe\u4e3a0\uff0c\u4e4b\u524d\u51e0\u4e2a\u6708\u8bbe\u7f6e\u4e3a\u8d1f\u6570\uff0c\u4e4b\u540e\u51e0\u4e2a\u6708\u8bbe\u7f6e\u4e3a\u6b63\u6570\u3002<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">c) \u7528\u6cd5\u4e3e\u4f8b\uff1a\u4e00\u822c\u7528\u4e8e\u8bc1\u5238\u7684\u5230\u671f\u65e5\u7b49\u8ba1\u7b97\uff0c\u957f\u644a\u8868\u548c\u6298\u65e7\u8868\u5236\u4f5c\u7b49\u3002<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">\u4e09\uff0e\u51fd\u6570ceiling<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">a) \u4f5c\u7528\uff1a\u662f\u5c06\u6570\u503c\u5411\u4e0a\u820d\u5165\u5230\u6307\u5b9a\u57fa\u6570\u6700\u63a5\u8fd1\u7684\u500d\u6570<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">b) \u53c2\u6570\uff1a\u8fd9\u4e2a\u51fd\u6570\u6709\u4e24\u4e2a\u53c2\u6570\uff0c\u7b2c\u4e00\u4e2a\u53c2\u6570\u662f\u8981\u820d\u5165\u7684\u6570\u503c\uff0c\u7b2c\u4e8c\u4e2a\u53c2\u6570\u662f\u8981\u820d\u5165\u5230\u57fa\u6570\u7684\u500d\u6570\u3002<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">c) \u7528\u6cd5\u4e3e\u4f8b\uff1aceiling\uff0822,3\uff09\u662f\u6307\u6c42\u51fa\u4e00\u4e2a\u662f3\u7684\u500d\u6570\u7684\u503c\u5e76\u4e14&gt;=22\uff0c\u4e5f\u5c31\u662f24\uff1bceiling\uff08-22,-3\uff09\u662f\u6307\u6c42\u51fa\u4e00\u4e2a\u662f-3\u7684\u500d\u6570\u7684\u503c\u5e76\u4e14&lt;=-22\uff0c\u4e5f\u5c31\u662f-24\uff1b\u53ef\u7528\u4e8e\u8ba1\u7b97\u6bcf\u4e2a\u6708\u521d\u7b2c\u4e00\u4e2a\u5468\u516d\u7684\u65e5\u671f\uff1b\u4e5f\u53ef\u7528\u4e8e\u8ba1\u7b97\u6bcf\u4e2a\u6708\u4efd\u5bf9\u5e94\u7684\u5b63\u5ea6\u7b49\u3002<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">\u56db\uff0e\u51fd\u6570floor<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">a) \u4f5c\u7528\uff1a\u4e0eceiling\u76f8\u5bf9\uff0c\u662f\u5c06\u6570\u503c\u5411\u4e0b\u820d\u5165\u5230\u6307\u5b9a\u57fa\u6570\u6700\u63a5\u8fd1\u7684\u500d\u6570<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">b) \u53c2\u6570\uff1a\u8fd9\u4e2a\u51fd\u6570\u6709\u4e24\u4e2a\u53c2\u6570\uff0c\u7b2c\u4e00\u4e2a\u53c2\u6570\u662f\u8981\u820d\u5165\u7684\u6570\u503c\uff0c\u7b2c\u4e8c\u4e2a\u53c2\u6570\u662f\u8981\u820d\u5165\u5230\u57fa\u6570\u7684\u500d\u6570\u3002<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">c) \u7528\u6cd5\u4e3e\u4f8b\uff1afloor\uff0822,3\uff09\u662f\u6307\u6c42\u51fa\u4e00\u4e2a\u662f3\u7684\u500d\u6570\u7684\u503c\u5e76\u4e14&lt;=22\uff0c\u4e5f\u5c31\u662f21\uff1bfloor\uff08-22,-3\uff09\u662f\u6307\u6c42\u51fa\u4e00\u4e2a\u662f-3\u7684\u500d\u6570\u7684\u503c\u5e76\u4e14&gt;=-22\uff0c\u4e5f\u5c31\u662f-21\uff1b=floor\uff08\u9500\u552e\u6570\u91cf-\u8ba1\u5212\u6570\u91cf,5\uff09\/5*10\u7528\u4e8e\u8ba1\u7b97\u9500\u552e\u6570\u91cf\u6bcf\u8d85\u8fc7\u8ba1\u5212\u6570\u91cf5\u4e2a\uff0c\u5956\u52b110\u5143\u7b49\u3002<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">\u4e94\uff0e\u51fd\u6570mmult<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">a) \u4f5c\u7528\uff1a\u8fd4\u56de\u4e24\u4e2a\u6570\u7ec4\u7684\u77e9\u9635\u4e58\u79ef\uff0c\u7ed3\u679c\u77e9\u9635\u7684\u884c\u6570\u4e0e\u6570\u7ec41\u7684\u884c\u6570\u76f8\u540c\uff0c\u77e9\u9635\u7684\u5217\u6570\u4e0e\u6570\u7ec42\u7684\u5217\u6570\u76f8\u540c\u3002<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">b) \u53c2\u6570\uff1a\u8fd9\u4e2a\u51fd\u6570\u6709\u4e24\u4e2a\u53c2\u6570\uff0c\u7b2c\u4e00\u4e2a\u53c2\u6570\u662f\u77e9\u9635\u6570\u7ec41\uff0c\u7b2c\u4e8c\u4e2a\u53c2\u6570\u662f\u77e9\u9635\u6570\u7ec42\uff0c\u77e9\u9635\u6570\u7ec41\u5217\u6570\u5fc5\u987b\u4e0e\u77e9\u9635\u6570\u7ec42\u884c\u6570\u76f8\u540c\uff0c\u8fd4\u56de\u7ed3\u679c\u4e5f\u662f\u4e00\u4e2a\u77e9\u9635\u6570\u7ec4\u3002<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">c) \u7528\u6cd5\u4e3e\u4f8b\uff1a\u8fd9\u4e2a\u51fd\u6570\u6bd4\u8f83\u96be\u61c2\uff0c\u4e0d\u5efa\u8bae\u521d\u5b66\u8005\u4f7f\u7528\uff0c<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">\u516d\uff0e\u51fd\u6570clean<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">a) \u4f5c\u7528\uff1a\u7528\u4e8e\u5220\u9664\u6587\u672c\u4e2d\u4e0d\u80fd\u6253\u5370\u7684\u5b57\u7b26\uff0c\u5982\u6362\u884c\u7b26\u7b49<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">\u4e03\uff0e\u51fd\u6570abs<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">a) \u4f5c\u7528\uff1a\u8fd4\u56de\u6570\u503c\u7684\u7edd\u5bf9\u503c<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">\u516b\uff0e\u51fd\u6570phonetic<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">a) \u4f5c\u7528\uff1a\u5c06\u591a\u4e2a\u5355\u5143\u683c\u5185\u5bb9\u5408\u5e76<\/span><\/p>\n<h2 class=\"md-end-block md-heading\"><span class=\"md-plain\">\u7b2c\u4e03\u8bb2 \u51fd\u6570Vlookup Lookup Index Offset Indirect\u4e0eMatch\u7efc\u5408\u5e94\u7528<\/span><\/h2>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">\u4e00\uff0e\u5404\u51fd\u6570\u4e0eMatch\u51fd\u6570\u7684\u7efc\u5408\u5e94\u7528\u6765\u5f15\u7528\u6570\u636e<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">a) \u4e0eVlookup\u51fd\u6570<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">=VLOOKUP(B11,$B$4:$F$7,MATCH(C10,B3:F3,0),0)<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">\u516c\u5f0f\u89e3\u91ca\uff1aB11\u662f\u67e5\u627e\u503c\uff0c$B$4:$F$7\u67e5\u627e\u533a\u57df\uff0c\u7b2c\u4e09\u53c2\u6570\u7528\u4e86Match\u8fd4\u56de\u5217\u53f7\uff0cMatch\u51fd\u6570\u7684\u7b2c\u4e00\u4e2a\u53c2\u6570\u662f\u67e5\u627e\u503c\uff0c\u7b2c\u4e8c\u53c2\u6570\u662f\u4e00\u4e2a\u6a2a\u5411\u533a\u57df\uff0c\u5373\u5355\u884c\uff1b\u7b2c\u4e09\u53c2\u6570\u662f\u67e5\u627e\u65b9\u6cd5\u3002Vlookup\u7b2c\u56db\u53c2\u6570\u662f\u67e5\u627e\u65b9\u6cd5\u2014\u2014\u8f93\u51650\u7cbe\u786e\u67e5\u627e\u3002<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">b) \u4e0eLookup\u51fd\u6570<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">=LOOKUP(1,0\/(B4:B7=B11),INDEX(C4:F7,,MATCH(C10,C3:F3,0)))<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">\u516c\u5f0f\u89e3\u91ca\uff1aLookup\u7684\u7b2c\u4e00\u4e2a\u53c2\u6570\u662f\u67e5\u627e\u503c\uff0c\u7b2c\u4e8c\u53c2\u6570\u53ef\u4ee5\u4e00\u4e2a\u6570\u7ec4\uff0cB4:B7=B11\u4ea7\u751f\u4e00\u4e2a\u6570\u7ec4{FALSE;TRUE;FALSE;FALSE}\uff0c\u7136\u540e\u75280\u9664\u4ee5\u5b83\uff0c\u53c8\u4ea7\u751f\u4e00\u4e2a\u65b0\u7684\u6570\u7ec4{#DIV\/0!;0;#DIV\/0!;#DIV\/0!}\uff0c\u53ea\u6709\u4e00\u4e2a0\uff0c\u5176\u5b83\u5168\u90e8\u4e3a\u9519\u8bef\u503c\uff0c\u8fd9\u4e2a0\u5c31\u662f\u6211\u4eec\u9700\u8981\u7684\uff0c\u8fd9\u6837\u5c31\u89e3\u51b3\u4e86Lookup\u51fd\u6570\u7b2c\u4e8c\u53c2\u6570\u8981\u6309\u5347\u5e8f\u6392\u5e8f\u7684\u8981\u6c42\u4e86\u3002Lookup\u51fd\u6570\u7b2c\u4e09\u53c2\u4e5f\u662f\u4e00\u4e2a\u6570\u7ec4\uff0c\u6211\u4eec\u7528Index\u51fd\u6570\u6765\u5b9e\u73b0\uff0c\u56e0\u4e3aIndex\u51fd\u6570\u5982\u679c\u7701\u7565\u7b2c\u4e8c\u53c2\u6570\uff0c\u521a\u597d\u662f\u8fd4\u56de\u7b2c\u4e09\u53c2\u6570\u7684\u5217\u533a\u57df\uff0c\u800cIndex\u51fd\u6570\u7b2c\u4e8c\u53c2\u6570\u4e5f\u7528\u4e86Match\u51fd\u6570\u6765\u627e\u5230\u7b26\u5408\u6761\u4ef6\u7684\u5217\u3002<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">c) \u4e0eIndex\u51fd\u6570<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">=INDEX(C4:F7,MATCH(B11,B4:B7),MATCH(C10,C3:F3,0))<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">\u516c\u5f0f\u89e3\u91ca\uff1a\u8fd9\u79cd\u65b9\u6cd5\u76f8\u5bf9\u6765\u8bf4\u7b80\u5355\u4e86\u8bb8\u591a\uff0c\u4e5f\u5c31\u662f\u7528Match\u51fd\u6570\u6765\u627eIndex\u7684\u884c\u53c2\u6570\u548c\u5217\u53c2\u6570\u3002\u8fd9\u516c\u5f0f\u6211\u5c31\u4e0d\u518d\u591a\u5570\u55e6\u4e86<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">d) \u4e0eOffset\u51fd\u6570<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">=OFFSET(B3,MATCH(B11,B4:B7,0),MATCH(C10,C3:F3,0),1,1)<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">\u516c\u5f0f\u89e3\u91ca\uff1aOffset\u8fd9\u4e2a\u51fd\u6570\u4f5c\u7528\u662f\u6839\u636e\u67d0\u4e00\u53c2\u7167\u5355\u5143\u683c\uff0c\u7ecf\u8fc7\u504f\u79fb\u884c\uff0c\u7ecf\u8fc7\u504f\u79fb\u5217\uff0c\u7136\u540e\u5f97\u5230\u65b0\u7684\u5f15\u7528\u533a\u57df\u7684\uff0c\u8fd9\u4e2a\u65b0\u7684\u5f15\u7528\u533a\u57df\u5982\u679c\u662f\u4e00\u4e2a\u5355\u5143\u683c\u7684\u5316\uff0c\u90a3\u5c31\u6700\u540e\u4e24\u4e2a\u53c2\u6570\u90fd\u662f1\uff0c\u5982\u679c\u5f97\u5230\u7684\u8fd9\u4e2a\u65b0\u7684\u5f15\u7528\u533a\u57df\u662f\u4e00\u4e2a\u591a\u884c\u591a\u5217\u7684\u533a\u57df\u7684\u5316\uff0c\u90a3\u4e48\u6700\u540e\u4e24\u4e2a\u53c2\u6570\u5c31\u662f\u884c\u9ad8\u4e0e\u5217\u5bbd<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">Offset\u7684\u7b2c\u4e00\u4e2a\u53c2\u6570\u662fB3\uff0c\u53c2\u7167\u5355\u5143\u683c\uff0c\u7b2c\u4e8c\u53c2\u6570\u7528Match\u51fd\u6570\u6765\u8fd4\u56de\u504f\u79fb\u591a\u5c11\u884c\uff0c\u540c\u6837\u7528Match\u51fd\u6570\u6765\u5b9e\u73b0\u504f\u79fb\u591a\u5c11\u5217\uff0c\u7b2c\u56db\u53c2\u6570\u662f\u6307\u65b0\u533a\u57df\u7684\u884c\u9ad8\u662f1\uff0c\u7b2c\u4e94\u53c2\u6570\u662f\u6307\u65b0\u533a\u57df\u7684\u5217\u5bbd\u662f1\uff0c\u5982\u679c\u6700\u540e\u4e24\u4e2a\u53c2\u6570\u90fd\u662f1\uff0c\u90a3\u4e48\u65b0\u533a\u57df\u5c31\u662f\u4e00\u4e2a\u5355\u5143\u683c\u3002<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">e) \u4e0eIndirect\u51fd\u6570<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">=INDIRECT(LOOKUP(MATCH(C10,C3:F3,0),{1,2,3,4},{\"C\",\"D\",\"E\",\"F\"})&amp;MATCH(B11,B4:B7,0)+3)<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">\u516c\u5f0f\u89e3\u91ca\uff1aIndirect\u8fd9\u4e2a\u51fd\u6570\u7684\u4f5c\u7528\u662f\u6839\u636e\u5355\u5143\u683c\u7684\u5f15\u7528\u8fd4\u56de\u5f15\u7528\u5355\u5143\u683c\u7684\u503c\uff0c\u8fd9\u4e2a\u51fd\u6570\u6709\u4e8c\u4e2a\u53c2\u6570\uff0c\u4e0d\u8fc7\u6211\u4eec\u7528\u65f6\u90fd\u662f\u53ea\u5199\u5b83\u7684\u7b2c\u4e00\u4e2a\u53c2\u6570\uff0c\u56e0\u4e3a\u7b2c\u4e8c\u53c2\u6570\u662f1\u6216\u8005\u7701\u7565\u7684\u5316\uff0c\u90a3\u4e48\u7b2c\u4e00\u53c2\u6570\u7528\u7684\u662fA1\u5f15\u7528\u6837\u5f0f\u3002<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">\u6211\u4eec\u7528\u4e86Lookup\u8fd9\u4e2a\u51fd\u6570\u8fd4\u56de\u5217\u53f7\uff0c \u800clookup\u51fd\u6570\u7684\u7b2c\u4e00\u53c2\u6570\u7528\u4e86Match\u51fd\u6570\u6765\u627e\u5217\u7684\u4f4d\u7f6e\uff0c\u627e\u5230\u76f8\u5e94\u7684\u4f4d\u7f6e\u4e4b\u540e\uff0c\u5c31\u4f1a\u5bf9\u5e94\u76f8\u5e94\u7684\u5b57\u6bcdCDEF,\u7136\u540e\u6211\u4eec\u7528Match\u51fd\u6570\u6765\u627e\u884c\u53f7\uff0c\u884c\u53f7\u8fd8\u8981\u52a0\u4e0a\u8fd9\u4e2a\u516c\u5f0f\u524d\u9762\u7684\u884c\u6570<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">f) \u4e0e\u6570\u7ec4\u51fd\u6570<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">{ =INDEX(B3:F7,MAX(IF(B3:B7=B11,ROW(B3:B7)-2,0)),MATCH(C10,B3:F3,0)) }<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">\u516c\u5f0f\u89e3\u91ca\uff1aIndex\u51fd\u6570\u7684\u7b2c\u4e8c\u53c2\u6570\u7528\u4e86\u6570\u7ec4\uff0c\u5148\u5224\u65ad\u7b26\u5408\u6761\u4ef6\u7528\u4e86if\u51fd\u6570<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">IF(B3:B7=B11,ROW(B3:B7)-2,0)\u8fd9\u4e2a\u8fd4\u56de\u4e00\u7ec4\u6570{0;0;3;0;0}\uff0c\u7b26\u5408\u6761\u4ef6\u5c31\u663e\u793a\u7eb5\u5411\u4f4d\u7f6e\uff0c\u4e0d\u7b26\u5408\u7684\u5c31\u663e\u793a0\uff0c\u7136\u540e\u7528\u6700\u5927\u503c\u51fd\u6570Max\u4ece{0;0;3;0;0}\u4e2d\u63d0\u53d6\u8fd9\u4e2a3\uff0c\u8fd9\u4e2a3\u5c31\u662fIndex\u51fd\u6570\u7684\u7b2c\u4e8c\u53c2\uff0c\u884c\u53c2\u6570\uff0cIndex\u7b2c\u4e09\u53c2\u6570\u7528\u4e86Match\u5b9e\u73b0\uff0c\u8fd9\u4e2a\u6211\u5c31\u4e0d\u518d\u591a\u5570\u55e6\u4e86<\/span><\/p>\n<h2 class=\"md-end-block md-heading\"><span class=\"md-plain\">\u7b2c\u516b\u8bb2 \u6570\u7ec4\u57fa\u7840\u77e5\u8bc6<\/span><\/h2>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">\u4e00\uff0e\u6570\u7ec4\u516c\u5f0f<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">a) \u6570\u7ec4\u5c31\u662f\u4e00\u7ec4\u6570\u636e\uff0c\u6570\u7ec4\u516c\u5f0f\u53ef\u4ee5\u8fdb\u884c\u591a\u91cd\u8fd0\u7b97\uff0c\u51cf\u5c11\u4e86\u591a\u6b21\u5199\u4e8e\u5355\u5143\u683c\u7684\u8fc7\u7a0b\uff0c\u53ef\u4ee5\u5b9e\u73b0\u5e38\u7528\u516c\u5f0f\u8f83\u70e6\u9501\u7684\u64cd\u4f5c\uff0c\u4e00\u6b65\u5230\u4f4d<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">\u4e8c\uff0e\u5220\u9664\u6570\u7ec4\u516c\u5f0f<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">a) \u56e0\u4e3a\u6570\u7ec4\u516c\u5f0f\u4e0d\u80fd\u5220\u9664\u4e00\u4e2a\uff0c\u6211\u4eec\u8981\u5220\u9664\u6570\u7ec4\u516c\u5f0f\u8981\u5168\u90e8\u9009\u4e2d\uff0c\u5f53\u6211\u4eec\u6709\u65f6\u4fee\u6539\u4e00\u4e2a\u5355\u5143\u683c\u7684\u6570\u7ec4\u516c\u5f0f\uff0c\u4e0d\u80fd\u9000\u51fa\u65f6\uff0c\u5927\u5bb6\u8bb0\u5f97\u6309ESC\u952e<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">\u4e09\uff0e\u4e00\u4e2a\u5355\u5143\u683c\u663e\u793a\u6570\u7ec4\u7684\u60c5\u51b5<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">a) \u7531\u4e8e\u4e00\u4e2a\u5355\u5143\u683c\u5185\u53ea\u80fd\u50a8\u5b58\u4e00\u4e2a\u6570\u503c,\u6240\u4ee5\u5f53\u7ed3\u679c\u662f\u4e00\u7ec4\u6570\u636e\u65f6,\u5355\u5143\u683c\u53ea\u8fd4\u56de\u7b2c\u4e00\u4e2a\u503c<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">\u56db\uff0e\u6570\u7ec4\u5206\u7c7b<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">a) \u6a2a\u5411\u6570\u7ec4\uff1b\u7eb5\u5411\u6570\u7ec4\uff0c\u533a\u57df\u6570\u7ec4\uff08\u591a\u884c\u591a\u5217\uff09\uff0c\u4e5f\u53ef\u4ee5\u6309\u7ef4\u6765\u5206\uff0c\u6a2a\u5411\u6570\u7ec4\u548c\u7eb5\u5411\u6570\u7ec4\u90fd\u5c5e\u4e8e\u4e00\u7ef4\u6570\u7ec4\uff0c\u533a\u57df\u6570\u7ec4\u5c5e\u4e8e\u4e8c\u7ef4\u6570\uff0c\u50cf\u8fd9\u79cd\uff5b1,2,3,1}\u5c31\u662f\u5e38\u91cf\u6570\u7ec4<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">\u4e94\uff0e\u600e\u6837\u67e5\u770b\u6570\u7ec4\u7684\u7ed3\u679c\uff0c\u5f53\u7136\u662fF9<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">\u516d\uff0e\u6570\u7ec4\u6210\u5458\u4e2d\u95f4\u6709\u65f6\u6709\u5206\u53f7\uff0c\u6709\u65f6\u7528\u9017\u53f7\u662f\u600e\u4e48\u56de\u4e8b\uff1f\uff0c\u7b54:\u6a2a\u5411\u6570\u7ec4\u7528\u9017\u53f7\u5206\u5f00\uff0c\u7eb5\u5411\u6570\u7ec4\u7528\u5206\u53f7\u5206\u5f00<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">\u4e03\uff0e\u5e38\u91cf\u6570\u636e\u5728\u51fd\u6570\u91cc\u7684\u5e94\u7528<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">a) 23 =INDEX({23,24,25,22},1,1) <\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">b) 24=INDEX({23,24,25,22},1,2) <\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">c) 25=INDEX({23,24,25,22},1,3) <\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">d) 22=INDEX({23,24,25,22},1,4) <\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">\u516b\uff0e\u8981\u4e48\u7528\u67d0\u4e9b\u51fd\u6570\u6765\u53d6\u5176\u5171\u6027,\u5982SUM Max\/Min,Small\/Large\u7b49<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">a) 94=Sum({23,24,25,22}) <\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">b) 25=Max({23,24,25,22}) <\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">c) 22=Min({23,24,25,23}) <\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">d) 25=Large({23,24,25,22},ROW(A1)) <\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">e) 22 =SMALL({23,24,25,22},ROW(A1)) <\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">f) 23=SMALL({23,24,25,22},ROW(A2)) <\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">g) 24=SMALL({23,24,25,22},ROW(A3)) <\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">h) 25=SMALL({23,24,25,22},ROW(A4)) <\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">\u4e5d\uff0e\u53c2\u6570<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">a) \u6570\u7ec4\u516c\u5f0f\u6700\u5927\u7684\u7279\u5f81\u5c31\u662f\u6240\u5f15\u7528\u7684\u53c2\u6570\u662f\u6570\u7ec4\u53c2\u6570,\u5305\u62ec\u533a\u57df\u6570\u7ec4\u548c\u5e38\u91cf\u6570\u7ec4\u3002 <\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">b) \u533a\u57df\u6570\u7ec4,\u662f\u4e00\u4e2a\u77e9\u5f62\u7684\u5355\u5143\u683c\u533a\u57df,\u5982 $A$1:$D$5 <\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">c) \u5e38\u91cf\u6570\u7ec4,\u662f\u4e00\u7ec4\u7ed9\u5b9a\u7684\u5e38\u91cf,\u5982{1,2,3}\u6216{1;2;3}\u6216{1,2,3;1,2,3} <\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">d) \u6570\u7ec4\u516c\u5f0f\u4e2d\u7684\u53c2\u6570\u5fc5\u987b\u4e3a\"\u77e9\u5f62\",\u5982{1,2,3;1,2}\u5c31\u65e0\u6cd5\u5f15\u7528\u4e86 <\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">\u5341\uff0e\u8f93\u5165<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">a) \u540c\u65f6\u6309\u4e0bCTRL+SHIFT+ENTER\uff0c\u6570\u7ec4\u516c\u5f0f\u7684\u5916\u9762\u4f1a\u81ea\u52a8\u52a0\u4e0a\u5927\u62ec\u53f7{}\u4e88\u4ee5\u533a\u5206<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">\u5341\u4e00\uff0eRow()\u51fd\u6570\u5728\u6570\u7ec4\u516c\u5f0f\u4e2d\u7684\u8fd0\u7528<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">a) \u8c08\u5230\u6570\u7ec4\u516c\u5f0f,\u6211\u4eec\u4e0d\u5f97\u4e0d\u8bf4\u4e00\u4e0bROW()\u8fd9\u4e2a\u51fd\u6570,\u5b83\u5728\u6570\u7ec4\u516c\u5f0f\u4e2d\u8d77\u5230\u4e86\u5f88\u5927\u7684\u4f5c\u7528,\u8bb8\u591a\u516c\u5f0f\u4e2d\u90fd\u9700\u8981\u7528\u5230\u5b83\u6765\u4f5c\u4e3a\u53c2\u6570<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">b) \u6211\u4eec\u5148\u6765\u505a\u4e00\u4e2a\u9898\u76ee\uff1a\u6c42\u6b63\u6574\u6570\u52171,2,3,4\u2026\u2026100\u8fd9100\u4e2a\u6570\u5b57\u4e4b\u548c=SUM(ROW($A$1:$A$100)) \u6211\u4eec\u5229\u7528Row(A1:A100)\u6765\u4ea7\u751f1\u5230100\u81ea\u7136\u6570\uff0c\u7136\u540e\u7528Sum\u6c42\u548c\u3002\u6211\u4eec\u90fd\u77e5\u9053,ROW()\u662f\u7528\u4e8e\u8fd4\u56de\u5355\u5143\u683c\u884c\u53f7\u7684\u51fd\u6570,\u901a\u5e38\u5b83\u53ea\u80fd\u5f15\u7528\u4e00\u4e2a\u53c2\u6570\u3002\u4f46\u662f\u5728\u6570\u7ec4\u516c\u5f0f\u4e2d,\u8be5\u51fd\u6570\u5c31\u80fd\u5f15\u7528\u591a\u4e2a\u5355\u5143\u683c\u4f5c\u4e3a\u53c2\u6570,\u5bf9\u4e8e\u6574\u4e2a\u5f15\u7528\u533a\u57df\u8fdb\u884c\u5206\u522b\u8fd0\u7b97,\u4ece\u800c\u5c31\u80fd\u8fd4\u56de\u4e00\u7ec4\u6570\u636eROW(A1)=1 ROW(A2)=2 \u2026\u2026 ROW(A100)=100 ROW($A$1:$A$100)={1;2;3\u2026\u2026100} \u77e5\u9053\u4e86\u8fd9\u4e00\u70b9\u4ee5\u540e,\u6211\u4eec\u5c31\u80fd\u5728\u6570\u7ec4\u516c\u5f0f\u4e2d\u5229\u7528\u8fd9\u4e00\u4e2a\u529f\u80fd\u6765\u5f97\u5230\u4e00\u7ec4\u8fde\u7eed\u7684\u6b63\u6574\u6570\u5f53\u7136COLUMN()\u7684\u4f5c\u7528\u548cROW()\u662f\u76f8\u540c\u7684,\u4e0a\u9762\u7684\u8ba1\u7b97\u4e5f\u80fd\u7528\u4ee5\u4e0b\u516c\u5f0f:{=SUM(COLUMN($A$1:$CV$1))}\u4f46\u662f\u76f8\u5bf9\u4e8eROW()\u7684\u5f15\u7528\u65b9\u5f0f\u6765\u8bf4,A1:A100\u8981\u6bd4A1:CV1\u66f4\u76f4\u89c2\u5730\u4f53\u73b0\u51fa\u6240\u5f15\u7528\u7684\u662f100\u884c\u8fd8\u662f100\u5217, \u6240\u4ee5ROW()\u4e00\u822c\u6765\u8bf4\u4f7f\u7528\u5f97\u66f4\u666e\u904d\u4e9b,\u5f53\u7136\u4e5f\u4e0d\u6392\u9664\u6709\u65f6\u5019\u9700\u8981\u7528\u5230COLUMN(),\u8fd9\u5c31\u8981\u770b\u5177\u4f53\u60c5\u51b5\u4e86\u3002<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">\u5341\u4e8c\uff0e\u4ece\u6587\u672c\u91cc\u63d0\u53d6\u6570\u5b57<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">a) =--MID(D7,MIN(FIND(ROW($A$1:$A$10)-1,D7&amp;5\/19,1)),LEN(D7)-(LENB(D7)-LEN(D7)))\u516c\u5f0f\u89e3\u91ca\uff1a\u5148\u8f93\u5165\u51fd\u6570Mid\u4ece\u4e2d\u95f4\u63d0\u53d6\u5b57\u7b26\uff0c\u8fd9\u4e2a\u51fd\u6570\u6709\u4e09\u4e2a\u53c2\u6570\uff0c\u7b2c\u4e00\u4e2a\u53c2\u6570\u597d\u8bf4\uff0c\u4ece\u90a3\u91cc\u53d6\uff0c\u4eceD7\u5355\u5143\u683c\u53d6\uff0c\u7b2c\u4e8c\u53c2\u6570\u4ece\u51e0\u4e2a\u4f4d\u7f6e\u63d0\u53d6\uff0c\u8fd9\u4e2a\u5934\u75db\uff0c\u4e3a\u4ec0\u4e48\u5934\u75db\u5462\uff0c\u56e0\u4e3a\u6570\u5b57\u7684\u4f4d\u7f6e\u6ca1\u6709\u89c4\u5f8b\uff0c\u600e\u4e48\u529e\u5462\uff1f\u5f53\u7136\u8981\u60f3\u529e\u6cd5\uff0c\u591a\u770b\u770b\uff0c\u518d\u60f3\u60f3\uff0c\u65e0\u975e\u5c31\u662f\u8981\u627e\u5230\u7b2c\u4e00\u4e2a\u6570\u5b57\u51fa\u73b0\u7684\u4f4d\u7f6e\uff0c\u6570\u5b57\u6709\u90a3\u4e48\u591a\u4e2a\uff0c\u670910\u4e2a\u963f\u62c9\u4f2f\u6570\u5b57\uff080123456789\uff09\uff0c\u60f3\u5230\u4e86Find\u51fd\u6570\u53bb\u627e\uff0c\u4ee5\u524d\u6211\u4eec\u5b66\u5f97\u65f6\u5019\u662f\u4e00\u4e2a\u4e00\u4e2a\u627e\uff0c\u521a\u624d\u6211\u4eec\u4e0d\u662f\u5b66\u4e86\u6570\u7ec4\uff0c\u6211\u4eec\u628a10\u4e2a\u6570\u5b57\u5168\u90e8\u4e00\u8d77\u653e\u8fdb\u53bb\u627e\uff0c\u8fd9\u5c31\u5bf9\u4e86\uff0c\u8fd9\u5c31\u662f\u6570\u7ec4\u4f18\u52bf\uff0c\u600e\u6837\u624d\u80fd\u4ea7\u751f10\u4e2a\u963f\u4f4d\u4f2f\u6570\u5b57\u5462\uff0c\u6211\u4eec\u53ef\u4ee5\u8f93\u5165\u5e38\u91cf\u6570\u7ec4{0,1,2,3,4,5,6,7,8,9} \u8fd9\u4e2a\u6253\u7684\u8f9b\u82e6\uff0c\u56e0\u6b64\u6211\u4eec\u53ef\u4ee5\u7528Row(A1:A10)-1,\u8bb0\u5f97\u8981\u7ed9\u5b83\u7edd\u5bf9\u5f15\u7528\uff0c10\u4e2a\u6570\u5b57\u4e00\u8d77\u62ff\u8fdb\u53bb\u627e\uff0c\u6709\u7684\u5355\u5143\u683c\u6ca1\u6709\u8fd910\u4e2a\u963f\u62c9\u4f2f\u6570\u5b57\u516c\u5f0f\u4f1a\u62a5\u9519\uff0c\u56e0\u6b64\u7528\u4e86D7&amp;5\/19\uff0c\u56e0\u4e3a5\/19\u4f1a\u4ea7\u751f\u8fd9\u4e2a10\u4e2a\u963f\u62c9\u4f2f\u6570\u5b57\uff0c\u5f53\u71361\/17\u4e5f\u4f1a\u4ea7\u751f\u8fd910\u4e2a\u963f\u62c9\u4f2f\u6570\u5b57\uff0c\u600e\u4e48\u8bb0\u4f4f\u5b83\u4e86\uff0c\u6211\u53eb\u5927\u5bb6\u4e00\u53e5\u8bdd\u201c\u6211\u8981\u559d\u9152\u201d\uff0c\u4e5f\u5c315\/19\uff0cFind\u67e5\u627e\u4e4b\u540e\uff0c\u4f1a\u5f97\u5230\u4e00\u4e2a\u6570\u7ec4{6;3;8;10;16;4;9;13;14;15}\uff0c\u4e5f\u5c31\u662f\u8fd910\u4e2a\u963f\u4f4d\u4f2f\u6570\u5b57\u7684\u4f4d\u7f6e\uff0c\u7136\u540e\u6211\u4eec\u7528Min\u51fd\u6570\u628a\u8fd9\u4e2a\u65b0\u6570\u7ec4{6;3;8;10;16;4;9;13;14;15}\u53d6\u51fa\u6765\u662f3\uff0c\u8fd9\u4e2a3\u5c31\u662f\u6570\u5b571\u51fa\u73b0\u7684\u4f4d\u7f6e\u3002\u56de\u8fc7\u5934\u6765\u770bFind\u51fd\u6570\u4e09\u4e2a\u53c2\u6570\uff0c\u7b2c\u4e00\u4e2a\u67e5\u627e\u7528\u4e86Row($A$1:$A$10)-1,\u7b2c\u4e8c\u4e2a\u53c2\u6570D7&amp;5\/19\uff0c\u7b2c\u4e09\u4e2a\u53c2\u6570\u75281\uff0c\u8868\u793a\u4ece\u7b2c\u4e00\u4e2a\u4f4d\u7f6e\u5f00\u59cb\u67e5\u627e\u3002\u73b0\u5728\u6211\u4eec\u6765\u770bMid\u51fd\u6570\u7684\u7b2c\u4e09\u4e2a\u53c2\u6570\uff0c\u4e5f\u5c31\u662f\u8981\u5f97\u5230\u6570\u5b57\u7684\u4e2a\u6570\uff0c\u524d\u9762\u6211\u4eec\u5b66\u8fc7\u8ba1\u7b97\u5b57\u7b26\u4e2a\u6570\u7684\u51fd\u6570Len\u548cLenb\u8fd9\u4e24\u4e2a\u51fd\u6570\uff0c\u8fd9\u4e24\u4e2a\u51fd\u6570\u533a\u522b\u662f\uff0cLenb\u51fd\u6570\u6c49\u5b57\u7b972\u4e2a\uff0c\u5b57\u6bcd\u548c\u6570\u5b57\u7b97\u4e00\u4e2a\uff0c\u56e0\u4e9b\u6211\u4eec\u5f97\u77e5\u6709\u4e00\u4e2a\u6c49\u5b57\u5c31\u4f1a\u591a1\uff0c\u6709\u4e8c\u4e2a\u6c49\u5b57\u5c31\u4f1a\u591a2\uff0c\u8fd9\u6837\u53ef\u4ee5\u7528Lenb(D7)-Len(D7)\u5f97\u5230\u6c49\u5b57\u7684\u4e2a\u6570\uff0c\u73b0\u5728\u77e5\u9053\u5b57\u7684\u603b\u6570\u7528Lenb(D7)\uff0c\u6570\u5b57\u7684\u4e2a\u6570\u5c31\u7b49\u4e8e\u5b57\u7684\u603b\u6570\u51cf\u53bb\u6c49\u5b57\u7684\u4e2a\u6570\u5c31\u662f\u6570\u5b57\u7684\u4e2a\u6570\uff0c\u8ba1\u7b97\u516c\u5f0f\uff1aLEN(D7)-(LENB(D7)-LEN(D7)) \uff0c\u51fd\u6570Mid\u8fd9\u4e2a\u4e09\u4e2a\u51fd\u6570\u6211\u4eec\u90fd\u89e3\u51b3\u4e86\u6700\u540e\u6709\u7684\u5b66\u751f\u53ef\u80fd\u4f1a\u95ee\uff1a\u8001\u5e08\u4f60\u7684Mid\u524d\u9762\u600e\u4e48\u4f1a\u8fd8\u6709\u4e24\u4e2a\u8d1f\u53f7\u5462\uff1f\u6253\u4e2a\u6bd4\u65b9\u7ed9\u5927\u5bb6\u542c\u4e00\u4e0b\uff0c9\u4e58\u4ee5-1\u7b49\u4e8e-9\uff0c\u7136\u540e-9\u518d\u4e58\u4ee5-1\u5f97\u52309\uff0c\u7ecf\u8fc7\u8fd0\u7b97\u8fd8\u662f\u8fd8\u6765\u76849\uff0c\u6ca1\u6709\u53d8\uff0c\u5bf9\uff0c\u786e\u662f\u6ca1\u6709\u53d8\uff0c\u4f46\u662f\u7ecf\u8fc7\u4e58\u6cd5\u8fd0\u7b97\uff0c\u800c\u6211\u4eec\u7684\u6587\u672c\u578b\u6570\u5b57\u7ecf\u8fc7\u8fd0\u7b97\u5c31\u4f1a\u8f6c\u4e3a\u6570\u503c\u578b\u6570\u5b57\u3002\u8fd9\u4e00\u70b9\u5728\u5927\u5bb6\u8981\u8bb0\u4f4f\u5b83\uff0c\u53e6\u5916\u5927\u5bb6\u8fd8\u8981\u8bb0\u4f4f\u4e00\u70b9\uff0c\u4e00\u822c\u60c5\u51b5\u6211\u4eec\u7684\u6587\u672c\u662f\u5de6\u5bf9\u9f50\uff0c\u800c\u6570\u5b57\u662f\u53f3\u5bf9\u9f50\u3002\u6211\u4eec\u7684\u6587\u672c\u51fd\u6570Right\uff0cLeft\uff0cMid\u53d6\u51fa\u6765\u7684\u6570\u5b57\u90fd\u662f\u6587\u672c\u578b\u7684\u6570\u5b57\uff0c\u6240\u4ee5\u8981\u8bb0\u5f97\u628a\u5b83\u8f6c\u4e3a\u6570\u503c\u578b\u6570\u5b57\uff0c\u4e0d\u8f6c\u7684\u5316\uff0c\u4f60\u6c42\u548c\u7ed3\u679c\u90fd\u662f0\uff0c\u4f60\u505a\u56fe\u8868\u65f6\uff0c\u505a\u4e0d\u51fa\u56fe\u8868\u3002\u5207\u8bb0<\/span><\/p>\n<p class=\"md-end-block md-p\">\n","protected":false},"excerpt":{"rendered":"<p>\u7b2c\u4e00\u8bb2 \u51fd\u6570\u57fa\u7840\u548c\u8bed\u6cd5 \u4e00\uff0e \u51fd\u6570\u7684\u4f5c\u7528 a) \u51fd\u6570\u5199\u597d\u4e4b\u540e\uff0c\u53ef\u4ee5\u81ea\u52a8\u751f\u6210\u4e00\u4e9b\u6709\u7528\u6570\u636e\uff0c\u63d0\u9ad8\u5de5\u4f5c\u6548\u7387 \u4e8c\uff0e \u516c [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5],"tags":[],"_links":{"self":[{"href":"https:\/\/www.shiyest.cn\/index.php?rest_route=\/wp\/v2\/posts\/331"}],"collection":[{"href":"https:\/\/www.shiyest.cn\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.shiyest.cn\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.shiyest.cn\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.shiyest.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=331"}],"version-history":[{"count":3,"href":"https:\/\/www.shiyest.cn\/index.php?rest_route=\/wp\/v2\/posts\/331\/revisions"}],"predecessor-version":[{"id":334,"href":"https:\/\/www.shiyest.cn\/index.php?rest_route=\/wp\/v2\/posts\/331\/revisions\/334"}],"wp:attachment":[{"href":"https:\/\/www.shiyest.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=331"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.shiyest.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=331"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.shiyest.cn\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=331"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}