A. Word琛ㄦ牸涓镊锷ㄦ眰鍜屾垨姹傚钩鍧囧肩殑4绉嶆柟娉
镞ュ父宸ヤ綔涓镄勬暟鎹澶勭悊澶у氶兘鍦╡xcel涓杩涜岋纴浣嗘湁镞朵竴浜涚亩鍗旷殑琛ㄦ牸涓轰简鏂逛究word
𨱒ヨ繘琛屽勭悊鏁版嵁浜嗭纴姣斿傦细姹傚拰鍜屽钩鍧囧硷纴闾d箞word鏂囨。涓镊锷ㄦ眰鍜屼笌骞冲潎链夊嚑涓鏂规硶锻锛熶笅闱㈢粰澶у跺垎浜涘父鐢ㄧ殑4绉嶆柟娉曘
鏂规硶涓锛氩埄鐢ㄢ垜鎸夐挳绠鍗曞揩阃熸眰鍜 杩欑嶆柟娉曚篃鏄链甯哥敤镄勬柟娉曪纴涔熸槸链蹇阃熺殑鏂规硶锛岄偅灏辨槸搴旂敤姹傚拰(鈭)锻戒护锛岄栧厛鎶婂厜镙囩偣鍑昏佹樉绀虹粨鏋灭殑鍗曞厓镙间笂锛岀劧钖庣偣鍑昏〃镙煎伐鍏锋爮涓婄殑镊锷ㄦ眰鍜(鈭)鎸夐挳锛岃繖镞剁数鑴戝氨浼氲嚜锷ㄦ眰鍜屻
鏂规硶浜屻佽彍鍗曚腑镄勚愭彃鍏ャ戯纴鎺ョ潃寮瑰嚭銆愬烟銆戞搷浣灭獥鍙o纴铹跺悗镣瑰嚮銆愬叕寮忋戞寜阍锛屽傚浘镓绀猴细
鍦ㄥ叕寮忕紪杈戞嗕腑杈揿叆=SUM(LEFT)锛岃繖灏辨槸瀵瑰乏杈规暟鎹姹傚拰锛屽傛灉瑕佸逛笂闱㈡暟鎹姹傚拰鏀规垚=SUM(ABOVE)鍗冲彲锛屽傚浘镓绀猴细
鏂规硶涓夈佸埄鐢ㄥ畯澶氭℃眰鍜岋纸閲嶅嶆眰鍜岋级 链夋椂鎴戜滑鐩歌繘琛岀浉钖岀殑鍏寮忚繘琛屾眰鍜岋纴杩欐椂鎴戜滑鍙浠ラ氲繃鍒╃敤瀹忔潵瀹炵幇锛岄栧厛銆愬伐鍏枫戋啋銆愬畯銆戋啋銆愬綍鍒舵柊瀹忋戯纴濡傚浘锛
鍐欎笂銆愬畯钖嶃戯纴铹跺悗镣广愰敭鐩樸戞寜阍锛岃繘琛屻愬揩鎹烽敭銆戣剧疆
杈揿叆鏂扮殑蹇鎹烽敭锛岀劧钖庣偣宸︿笅瑙掔殑銆愭寚瀹氥戞寜阍锛岀偣銆愬叧闂銆戯纴杩欐椂寮濮嬭繘琛屽逛綘镄勬搷浣滆繘琛屽綍鍒朵简銆
铹跺悗鍙闇鎶婂厜镙囩Щ锷ㄨ佽嚜锷ㄦ眰鍜岀殑鍦版柟鎸変笅鍒氭墠瀹氢箟濂界殑蹇鎹烽敭锛屼緥濡傦细Ctrl+Shift+S锛岃繖镙峰氨鑳藉揩阃熼吨澶嶅湴姹傚拰浜嗐
鏂规硶锲涖佸埄鐢ㄥ叕寮弚ord姹傚钩鍧囧 瑕佸硅〃镙间腑镄勬暟鎹杩涜屾眰骞冲潎鍊硷纴鏂规硶镀忔眰鍜屼竴镙凤纴鍙鏄鎶婃眰鍜屽叕寮忔崲鎴愭眰骞冲潎鍊煎叕寮忥纴阃夋嫨凿滃崟镙忚〃镙煎叕寮忥纴铹跺悗阃夋嫨绮樿创鍑芥暟涓镄勬眰骞冲潎鍊煎嚱鏁(AVERAGE)锛岃佽繘琛屽乏姹傚钩鍧囱缮鏄涓婂钩鍧囧悓镙峰啓涓奓EFT鎴朅BOVE杩涜屾眰骞冲潎锛屽傚浘锛