excel如何利用公式来制作学生成绩通知单

[[{"txt": "\u5b66\u751f\u6210\u7ee9\u901a\u77e5\u5355\u7684\u5236\u4f5c\u5f88\u591a\uff0c\u5e38\u89c1\u7684\u662f\u5229\u7528Word+excel\u7ec4\u5408\uff0c\u901a\u8fc7\u53f3\u952e\u5408\u5e76\u7684\u65b9\u5f0f\u4ea7\u751f\u3002\u4f46\u662f\u82e5\u4e0d\u7528Word\uff0c\u5355\u72ec\u7528excel\u6765\u505a\uff0c\u7531\u4e8e\u5355\u5143\u683c\u4e0e\u5355\u5143\u683c\u4e4b\u95f4\u6ca1\u6709\u7a7a\u884c\uff0c\u82e5\u4e00\u884c\u7684\u63d2\u5165\u7a7a\u767d\u884c\u4e5f\u5f88\u8017\u65f6\u95f4\uff0c\u82e5\u7528\u516c\u5f0f\u6765\u5b9e\u73b0\uff0c\u5c82\u4e0d\u662f\u7b80\u4fbf\u5f97\u591a\uff1f\u4eca\u5929\u5c0f\u7f16\u8981\u4ecb\u7ecd\u7684\u5c31\u662f\u8fd9\u6837\u7684\u65b9\u6cd5\uff0c\u4e00\u8d77\u6765\u770b\u770b\u5427\u3002"}, {"img": ["https://exp-picture.cdn.bcebos.com/e9a4f2eeadbcbe2fcb8856ad54dae43b3a86784d.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}], [{"txt": ["\u5de5\u5177/\u539f\u6599"]}, {"txt": "excel2013"}], [{"txt": ["\u65b9\u6cd5/\u6b65\u9aa4"]}, {"txt": "\u6253\u5f00\u5b66\u751f\u6210\u7ee9\u8868\uff0c\u5e76\u5bf9\u7b2c\u4e00\u884c\u8fdb\u884c\u9009\u4e2d\u3002"}, {"img": ["https://exp-picture.cdn.bcebos.com/04201aa355e983ae752f499f68efe0781531694d.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1", "https://exp-picture.cdn.bcebos.com/e3d059e833e0397293fbab5fb58630486043564d.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}, {"txt": "\u63d2\u5165\u4e00\u5f20\u65b0\u7684\u5de5\u4f5c\u8868\uff0c\u5e76\u5c06\u6211\u4eec\u4e4b\u524d\u590d\u5236\u7684\u7b2c\u4e00\u884c\u6570\u636e\u7c98\u8d34\u5728sheet2\u4e2d\u7684\u7b2c\u4e00\u884c\uff0c\u5e76\u5728A2\u5355\u5143\u683c\u4e2d\u8f93\u51651\u3002"}, {"img": ["https://exp-picture.cdn.bcebos.com/8db0c6a7263348840c1b5b99ddee7b7f870e454d.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}, {"txt": "\u6240\u6709\u5de5\u4f5c\u51c6\u5907\u5b8c\u6210\uff0c\u73b0\u5728\u6211\u4eec\u5c31\u7528\u51fd\u6570\u6765\u8fdb\u884c\u5b9e\u73b0\uff0c\u5728B2\u5355\u5143\u683c\u4e2d\u8f93\u5165\u516c\u5f0f\uff1a=VLOOKUP($A2,Sheet1!$A:$F,COLUMN(B1),0)\uff0c\u89e3\u91ca\u4e00\u4e0b\u53c2\u6570\u7684\u542b\u4e49\uff0c$A2\uff1aA2\u4e2d\u7684\u503c\u5c31\u662f\u5e8f\u53f7\uff0c\u5c31\u662f\u6211\u4eec\u8981\u67e5\u627e\u7684\u503c\uff0c\u901a\u8fc7\u8fd9\u4e2a\u503c\u8fd4\u56de\u5176\u4ed6\u7684\u91cf\uff1bSheet1!$A:$F\uff1aA:F\u5c31\u662f\u8868\u793asheet1\u4e2d\u5e8f\u53f7\u5230\u603b\u5206\u8fd9\u4e9b\u6240\u6709\u7684\u5217\uff0c\u5c31\u662f\u6211\u4eec\u8981\u67e5\u627e\u7684\u533a\u57df\uff1bCOLUMN(B1)\uff1a\u5c31\u662f\u8fd4\u56de\u59d3\u540d\u6240\u5728\u5217\u53f7\uff1b0\u4e0d\u7528\u8bb2\u90a3\u5c31\u662f\u7cbe\u786e\u67e5\u627e\u4e86\u3002"}, {"img": ["https://exp-picture.cdn.bcebos.com/ef4c24ceaad7726bc11a7552bf0f64781523b94d.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}, {"txt": "\u56de\u8f66\u4e4b\u540e\uff0c\u6211\u4eec\u5f97\u5230B2\u7684\u7ed3\u679c\u5df2\u7ecf\u51fa\u6765\uff0c\u5c31\u662f\u5f20\u4e091\uff0c\u5411\u53f3\u81ea\u52a8\u586b\u5145\uff0c\u5f97\u5230\u4e00\u4f4d\u540c\u5b66\u7684\u6210\u7ee9\u3002"}, {"img": ["https://exp-picture.cdn.bcebos.com/777f3fc2bbd6e1d0ba108ad40d254193cfe8af4d.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1", "https://exp-picture.cdn.bcebos.com/d04eec260d9a310ef561f99f31b842406bfea24d.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}, {"txt": "\u73b0\u5728\u6211\u4eec\u8981\u5c06\u5176\u4ed6\u7684\u5b66\u751f\u6210\u7ee9\u5355\u505a\u51fa\u6765\uff0c\u4e2d\u95f4\u7a7a\u4e0a\u4e00\u884c\uff0c\u4e8e\u662f\u6211\u4eec\u5148\u5bf9\u6807\u9898\u884c\u548c\u6570\u636e\u884c\u52a0\u4e0a\u4e00\u884c\u7a7a\u767d\u884c\u8fdb\u884c\u9009\u62e9\uff0c\u7136\u540e\u5f80\u4e0b\u8fdb\u884c\u586b\u5145\u3002"}, {"img": ["https://exp-picture.cdn.bcebos.com/ad121888912ca5ca2c1080fd8bfc77f7990e944d.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}, {"txt": "\u586b\u5145\u4e4b\u540e\u6211\u4eec\u5c31\u5f97\u5230\u6240\u6709\u5b66\u751f\u7684\u6210\u7ee9\u5355\u4e86\uff0c\u4e14\u8fd8\u4e0d\u5bf9\u539f\u8868\u8fdb\u884c\u4fee\u6539"}, {"img": ["https://exp-picture.cdn.bcebos.com/2184380f8835dd8aa62655b203013870d441874d.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}, {"txt": "\u8c03\u6574\u4e00\u4e0b\u76f8\u5e94\u7684\u5b57\u4f53\u548c\u884c\u9ad8\u7b49\u53c2\u6570\u5c31\u53ef\u4ee5\u6253\u5370\uff0c\u88c1\u526a\u4e86\u3002"}, {"img": ["https://exp-picture.cdn.bcebos.com/95bd4e8c9bcec7f8818e4d68034ce54a2e27fb4d.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}]]