瀹為獙鎶ュ憡
:
瀹為獙棰樼洰锛?/p>
EXCEL
鐢靛瓙琛ㄦ牸杞欢鐨勬暟鎹～鍏呬笌鏍煎紡璁剧疆
瀹為獙鐩殑锛氳鏈殑绗?/p>
9
绔?/p>
P227
绗竴娈碉細
Excel2007
鈥︹�︹�︹�︹�︹�﹀疄鐜拌祫婧愬叡浜紙鍐欏畬璇ユ锛?/p>
瀹為獙鍐呭锛?/p>
1.
灏嗙涓�鍒椻�滃鍙封�濆垪璁句负鏂囨湰锛屽皢鎵�鏈夋垚缁╁垪璁句负淇濈暀涓や綅灏忔暟鐨勬暟鍊硷紱
2.
鍒╃敤鈥滄潯浠舵牸寮忊�濆姛鑳借繘琛屼笅鍒楄缃細
灏嗚鏂囥�?/p>
鏁板銆?/p>
鑻辫涓夌涓笉浣庝簬
110
鍒嗙殑鎴愮哗鎵�鍦ㄧ殑鍗曞厓鏍?/p>
浠ヤ竴绉嶉鑹插～鍏咃紝鎵�鐢ㄩ鑹叉繁娴呬互涓嶉伄鎸℃暟鎹负瀹溿�?/p>
3.
鍒╃敤
sum
鍜?/p>
average
鍑芥暟璁＄畻姣忎竴涓鐢熺殑鎬诲垎鍙婂钩鍧囨垚缁┿�?/p>
4.
瀛﹀彿绗?/p>
3
銆?/p>
4
浣嶄唬琛ㄥ鐢熸墍鍦ㄧ殑鐝骇锛屼緥濡傦細
"120105"
浠ｈ〃
12
绾?/p>
1
鐝?/p>
5
鍙枫�傝閫氳繃鍑芥暟鎻愬彇姣忎釜瀛?/p>
鐢熸墍鍦ㄧ殑鐝骇骞舵寜涓嬪垪瀵瑰簲鍏崇郴濉啓鍦ㄢ�滅彮绾р�濆垪涓�?/p>
5.
閫氳繃鍒嗙被姹囨�诲姛鑳芥眰鍑烘瘡涓彮鍚勭鐨勫钩鍧囨垚缁╋紝骞跺皢姣忕粍缁撴灉鍒嗛〉鏄剧ず銆?/p>
6.
浠ュ垎绫绘眹鎬荤粨鏋滀负鍩虹锛屽垱寤轰竴涓皣鐘舵煴褰㈠浘锛屽姣忎釜鐝悇绉戝钩鍧囨垚缁╄繘琛屾瘮杈冦�?/p>
瀹為獙姝ラ锛?/p>
銆愭妸涓嬮潰鐨勫唴瀹逛緷娆″～鍐欏埌瀹為獙鎶ュ憡鍐岀殑瀹為獙鍐呭鍜屽疄楠屾楠ゃ�?/p>
1.
棣栧厛閫夋嫨
A2
锛?/p>
A19
鍗曞厓鏍硷紝鐒跺悗鍗曞嚮鈥滃紑濮嬧�濋�夐」鍗♀啋鈥滄暟瀛椻�濈粍鐨勫璇濇鍚姩鍣紝鎵撳紑鈥滆缃崟鍏?/p>
鏍兼牸寮忊�濆璇濇锛屽湪鈥滄暟瀛椻�濋�夐」鍗＄殑鈥滃垎绫烩�濅腑閫夋嫨鈥滄枃鏈�?/p>
銆?/p>
2.
棣栧厛閫夋嫨
D2
锛?/p>
L19
鍗曞厓鏍硷紝鐒跺悗鍗曞嚮鈥滃紑濮嬧�濋�夐」鍗♀啋鈥滄暟瀛椻�濈粍鐨勫璇濇鍚姩鍣紝鎵撳紑鈥滆缃崟鍏?/p>
鏍兼牸寮忊�濆璇濇锛屽湪鈥滄暟瀛椻�濋�夐」鍗＄殑鈥滃垎绫烩�濅腑閫夋嫨鈥滄暟鍊尖�?/p>
锛屽湪鈥滃皬鏁扮偣浣嶆暟鈥濅腑杈撳叆
2
銆?/p>
3.
棣栧厛閫夋嫨
D2
锛?/p>
F19
鍗曞厓鏍硷紝鐒跺悗鍗曞嚮鈥滃紑濮嬧�濋�夐」鍗♀啋鈥滄牱寮忊�濈粍鈫掆�滄潯浠舵牸寮忊�濃啋鈥滅獊鍑烘樉绀哄崟鍏?/p>
鏍艰鍒欌�濃啋鈥滃叾浠栬鍒欌�濇寜閽紝鎵撳紑鈥滄柊寤烘牸寮忚鍒欌�濆璇濇锛屾墦寮�鈥滆缃崟鍏冩牸鏍煎紡鈥濆璇濇锛岀偣
鍑烩�滃～鍏呪�濋�夐」鍗★紝璁剧疆涓�绉嶉鑹诧紝鐐瑰嚮纭畾銆?/p>
4.
棣栧厛閫夋嫨
K2
鍗曞厓鏍硷紝鐒跺悗鍐欏叆
=sum(D2:J2)
锛涢�変腑
L2
鍗曞厓鏍煎啓鍏?/p>
=
average
(D2:J2)
锛屾帴鐫�閫変腑
C2
鍗曞厓
鏍艰緭鍏モ�?/p>
=INT(MID(A2,3,2))&"
鐝?/p>
"
5.
榧犳爣瀹氫綅鍦ㄤ换浣曚竴涓崟鍏冩牸锛岀劧鍚庡崟鍑烩�滃紑濮嬧�濊彍鍗曚笅锛?/p>
鈥滅紪杈戔�濋�夐」鍗′腑锛岀偣鍑烩�滄帓搴忓拰绛涢�夆�濅笅
鎷変笁瑙掞紝閫夋嫨鈥滆嚜瀹氫箟鎺掑簭鈥?/p>
锛屾墦寮�鈥滄帓搴忊�濆璇濇锛屽湪鍏抽敭瀛椾腑閫夋嫨鈥滅彮绾р�?/p>
锛岀偣鍑烩�滅‘瀹氣�?/p>
銆傚崟鍑?/p>
鈥滄暟鎹�濋�夐」鍗♀啋鈥滃垎绾ф樉绀衡�濈粍鈫掆�滃垎绫绘眹鎬烩�濇寜閽紝鎵撳紑鈥滃垎绫绘眹鎬烩�濆璇濇锛岃繘琛屽鍥?/p>
8
鎵�绀?/p>
鐨勮缃�傞�夊畾姹囨�婚」涓紝鍙嬀閫?/p>
7
涓鐩�?/p>
6.
閫夋嫨
C3
锛?/p>
J3
鍖哄煙锛?/p>
鎸変綇
ctrl
閿紝
渚濇閫夋嫨
C10
锛?/p>
J10;C17
锛?/p>
J17
锛?/p>
鏈�鍚庨�夋嫨
C1
锛?/p>
J1
锛?/p>
鐒跺悗鍗曞嚮
鈥滄彃鍏モ�?/p>
閫夐」鍗♀啋鈥滃浘琛ㄢ�濈粍鈫掆�滄煴褰㈠浘鈥濃啋鈥滅皣鐘舵煴褰㈠浘鈥?/p>
锛?/p>
瀹為獙鍒嗘瀽锛氬～鍐欒嚜宸卞璇ヨ蒋浠剁殑璁よ瘑涓庡湪瀛︿範杩囩▼涓亣鍒扮殑涓�浜涢棶棰樸�?/p>
瀹為獙鎶ュ憡
:
瀹為獙棰樼洰锛氬埄鐢?/p>
EXCEL
杞欢涓殑鍑芥暟濉啓鏁版嵁
瀹為獙鐩殑锛氳鏈殑绗?/p>
9
绔?/p>
P227
绗竴娈碉細
Excel2007
鈥︹�︹�︹�︹�︹�﹀疄鐜拌祫婧愬叡浜紙鍐欏畬璇ユ锛夊疄楠屽唴瀹癸細
1.
鏍规嵁鍥句功缂栧彿锛岃鍦ㄢ�滆鍗曟槑缁嗏�濆伐浣滆〃鐨勨�滃浘涔﹀悕绉扳�濆垪涓紝浣跨敤
VLOOKUP
鍑芥暟瀹屾垚鍥句功鍚嶇О鐨勮嚜
鍔ㄥ～鍏呫�傗�滃浘涔﹀悕绉扳�濆拰鈥滃浘涔︾紪鍙封�濈殑瀵瑰簲鍏崇郴鍦ㄢ�滅紪鍙峰鐓р�濆伐浣滆〃涓�?/p>
2.
鏍规嵁鍥句功缂栧彿锛岃鍦ㄢ�滆鍗曟槑缁嗏�濆伐浣滆〃鐨勨�滃崟浠封�濆垪涓紝浣跨敤
VLOOKUP
鍑芥暟瀹屾垚鍥句功鍗曚环鐨勮嚜鍔ㄥ～
鍏呫�傗�滃崟浠封�濆拰鈥滃浘涔︾紪鍙封�濈殑瀵瑰簲鍏崇郴鍦ㄢ�滅紪鍙峰鐓р�濆伐浣滆〃涓�?/p>