A. Word琛ㄦ牸涓鑷鍔ㄦ眰鍜屾垨奼傚鉤鍧囧肩殑4縐嶆柟娉
鏃ュ父宸ヤ綔涓鐨勬暟鎹澶勭悊澶у氶兘鍦╡xcel涓榪涜岋紝浣嗘湁鏃朵竴浜涚畝鍗曠殑琛ㄦ牸涓轟簡鏂逛究word
鏉ヨ繘琛屽勭悊鏁版嵁浜嗭紝姣斿傦細奼傚拰鍜屽鉤鍧囧礆紝閭ｄ箞word鏂囨。涓鑷鍔ㄦ眰鍜屼笌騫沖潎鏈夊嚑涓鏂規硶鍛錛熶笅闈㈢粰澶у跺垎浜涘父鐢ㄧ殑4縐嶆柟娉曘
鏂規硶涓錛氬埄鐢ㄢ垜鎸夐挳綆鍗曞揩閫熸眰鍜 榪欑嶆柟娉曚篃鏄鏈甯哥敤鐨勬柟娉曪紝涔熸槸鏈蹇閫熺殑鏂規硶錛岄偅灝辨槸搴旂敤奼傚拰(鈭)鍛戒護錛岄栧厛鎶婂厜鏍囩偣鍑昏佹樉紺虹粨鏋滅殑鍗曞厓鏍間笂錛岀劧鍚庣偣鍑昏〃鏍煎伐鍏鋒爮涓婄殑鑷鍔ㄦ眰鍜(鈭)鎸夐挳錛岃繖鏃剁數鑴戝氨浼氳嚜鍔ㄦ眰鍜屻
鏂規硶浜屻佽彍鍗曚腑鐨勩愭彃鍏ャ戱紝鎺ョ潃寮瑰嚭銆愬煙銆戞搷浣滅獥鍙ｏ紝鐒跺悗鐐瑰嚮銆愬叕寮忋戞寜閽錛屽傚浘鎵紺猴細
鍦ㄥ叕寮忕紪杈戞嗕腑杈撳叆=SUM(LEFT)錛岃繖灝辨槸瀵瑰乏杈規暟鎹奼傚拰錛屽傛灉瑕佸逛笂闈㈡暟鎹奼傚拰鏀規垚=SUM(ABOVE)鍗沖彲錛屽傚浘鎵紺猴細
鏂規硶涓夈佸埄鐢ㄥ畯澶氭℃眰鍜岋紙閲嶅嶆眰鍜岋級 鏈夋椂鎴戜滑鐩歌繘琛岀浉鍚岀殑鍏寮忚繘琛屾眰鍜岋紝榪欐椂鎴戜滑鍙浠ラ氳繃鍒╃敤瀹忔潵瀹炵幇錛岄栧厛銆愬伐鍏楓戔啋銆愬畯銆戔啋銆愬綍鍒舵柊瀹忋戱紝濡傚浘錛
鍐欎笂銆愬畯鍚嶃戱紝鐒跺悗鐐廣愰敭鐩樸戞寜閽錛岃繘琛屻愬揩鎹烽敭銆戣劇疆
杈撳叆鏂扮殑蹇鎹烽敭錛岀劧鍚庣偣宸︿笅瑙掔殑銆愭寚瀹氥戞寜閽錛岀偣銆愬叧闂銆戱紝榪欐椂寮濮嬭繘琛屽逛綘鐨勬搷浣滆繘琛屽綍鍒朵簡銆
鐒跺悗鍙闇鎶婂厜鏍囩Щ鍔ㄨ佽嚜鍔ㄦ眰鍜岀殑鍦版柟鎸変笅鍒氭墠瀹氫箟濂界殑蹇鎹烽敭錛屼緥濡傦細Ctrl+Shift+S錛岃繖鏍峰氨鑳藉揩閫熼噸澶嶅湴奼傚拰浜嗐
鏂規硶鍥涖佸埄鐢ㄥ叕寮弚ord奼傚鉤鍧囧 瑕佸硅〃鏍間腑鐨勬暟鎹榪涜屾眰騫沖潎鍊礆紝鏂規硶鍍忔眰鍜屼竴鏍鳳紝鍙鏄鎶婃眰鍜屽叕寮忔崲鎴愭眰騫沖潎鍊煎叕寮忥紝閫夋嫨鑿滃崟鏍忚〃鏍煎叕寮忥紝鐒跺悗閫夋嫨綺樿創鍑芥暟涓鐨勬眰騫沖潎鍊煎嚱鏁(AVERAGE)錛岃佽繘琛屽乏奼傚鉤鍧囪繕鏄涓婂鉤鍧囧悓鏍峰啓涓奓EFT鎴朅BOVE榪涜屾眰騫沖潎錛屽傚浘錛