绮惧搧鏂囨。
绮惧搧鏂囨。
澶у璁＄畻鏈哄熀纭�鑰冭瘯濉┖棰?/p>
1
锛庡壀璐存澘鏄?/p>
鍐呭瓨
涓殑涓�涓尯鍩熴�?/p>
2
锛?/p>
锛?/p>
WORD
鏂囧瓧澶勭悊锛?/p>
鈥滄牸寮忊�濆伐鍏锋爮涓紝鏈�澶х鍊兼槸
72
纾?/p>
銆?/p>
WORD
鑳借缃殑鏈�澶у瓧
纾呭�兼槸
1638
纾呫�?/p>
3
锛?/p>
锛?/p>
WORD
鏂囧瓧澶勭悊锛?/p>
鎸?/p>
Ctrl+
End
閿彲浠ユ妸鎻掑叆鐐圭Щ鍒版枃妗ｅ熬閮ㄣ�?/p>
锛堣鍐欏ぇ鍐欏瓧姣嶏級
4
锛?/p>
鍒╃敤蹇嵎閿?/p>
Ctrl + A
鍙互閫夋嫨鏁翠釜鏂囨。
(
涓夊嚮琛屽乏锛?/p>
鎸?/p>
F8
鈥斺�斾竴娆′负鎵╁睍銆?/p>
浜屾
閫犺瘝銆佷笁娆￠�夐」鍙ャ�佸洓娆￠�夋銆佷簲娆″叏閫夛紱鎸変笅
CTRL+
鍗曞嚮琛屽乏涓哄叏閫?/p>
)
銆?/p>
5
锛庡湪鏅�氳鍥句腑
,
鍙嚭鐜?/p>
姘村钩
鏂瑰悜鐨勬爣灏猴紱椤甸潰瑙嗗浘涓獥鍙ｆ棦鏄剧ず
姘村钩鏍囧昂锛?/p>
鍙堟樉绀虹珫鐩存爣灏?/p>
銆?/p>
6
锛庡湪
Word
鐜涓嬶紝瑕佸皢涓�涓钀藉垎鎴愪袱涓钀斤紝闇�瑕佸皢鍏夋爣瀹氫綅鍦ㄦ钀藉垎鍓插锛屾寜
閿?/p>
ENTER
銆?/p>
锛?/p>
鎹㈣浣嗕笉鍒嗘鎸?/p>
SHIFT+ENTER
锛?/p>
鎻掑叆鍒嗛〉绗︽寜
CTRL+ENTER
锛?/p>
銆?/p>
7
銆佸湪
Word
涓澶嶅埗宸查�夊畾鐨勬枃鏈紝鍙互鎸変笅
CTRL
閿紝鍚屾椂鐢ㄩ紶鏍囨嫋鍔ㄩ�夊畾鏂囨湰鍒版寚
瀹氱殑浣嶇疆銆?/p>
8
銆佸鏋滆鏌ョ湅鏂囨。鐨勯〉鏁般�佸瓧绗︽暟銆佹钀芥暟銆佹憳瑕佷俊鎭瓑锛岃鍗曞嚮鈥滄枃浠垛�濊彍鍗曚腑鐨?/p>
灞?/p>
鎬?/p>
鍛戒护銆?/p>
锛堝伐鍏疯彍鍗曚笅鐨勮闄ゆ暟缁熻涔熸湁姝ゅ姛鑳斤級
9
锛庢牱寮忔槸涓�缁勫凡鍛藉悕鐨?/p>
瀛楃
鏍煎紡鍜?/p>
娈佃惤
鏍煎紡鐨勭粍鍚堛�?/p>
10
锛?/p>
妯℃澘
鏄澶氱瘒鍏锋湁鐩稿悓鏍煎紡鐨勬枃妗ｇ殑鏍煎紡瀹氫箟銆傛ā鏉夸笌鏍峰紡鐨勫叧绯绘槸锛?/p>
妯℃澘鍖?/p>
鍚牱寮忥紝妯℃澘鏈夊搴旂殑鏂囦欢锛?/p>
.DOT
锛?/p>
锛涙牱寮忔湁鍚嶅瓧浣嗘病鏈夌浉搴旀枃浠?/p>
銆?/p>
11
銆?/p>
WORD
涓鎯冲娆′娇鐢ㄦ牸寮忓嵃锛屽簲璇ョ敤榧犳爣
鍙屽嚮
鏍煎紡鍗版寜閽紱鍙栨秷璇ラ」鍔熻兘鎸?/p>
Esc
閿�?/p>
12
銆佽缃?/p>
WORD
鏂囨。鐨勪繚鎶ゅ瘑鐮侊紝鏈�闀垮彲鐢?/p>
15
涓瓧绗?/p>
銆?/p>
13
銆?/p>
.EXCEL
鍗曞厓鏍肩殑榛樿瀹藉害涓?/p>
8
涓瓧绗︺�?/p>
14
銆?/p>
.
鑻?/p>
A1
鍗曞厓鏍间负鏂囨湰鏁版嵁
1
锛?/p>
A2
鍗曞厓鏍间负閫昏緫鍊?/p>
TRUE
锛?/p>
鍒?/p>
SUM
锛?/p>
A1
锛?/p>
A2
锛?/p>
2
锛?/p>
=
2
锛?/p>
鍏紡
=SUM(
鈥?/p>
3
鈥?/p>
,2,TRUE)
鐨勮绠楃粨鏋滄槸
6
锛涘叕寮?/p>
=1&234
鐨勮绠楃粨鏋滄槸
1234
鏂囨湰銆傚叕寮?/p>
SUM
锛?/p>
A3
锛?/p>
A8
锛?/p>
/6
绛夋晥浜?/p>
AVERAGE
锛?/p>
A3
锛?/p>
A8
锛?/p>
銆傝嫢
COUNT
锛?/p>
F1
锛?/p>
F7
锛?/p>
=2
锛屽垯
COUNT
锛?/p>
F1
锛?/p>
F7
锛?/p>
3
锛?/p>
=
3
15
銆?/p>
涓�涓?/p>
EXCEL
宸ヤ綔绨挎渶澶氭湁
255
涓伐浣滆〃锛?/p>
256
鍒?/p>
锛?/p>
A
锛?/p>
B
锛?/p>
C
锛?/p>
D
鈥︹�︼紝
IV
锛?/p>
锛?/p>
65536
琛?/p>
锛屽伐浣滅翱鍚嶆渶闀?/p>
255
涓瓧绗?/p>
锛屽伐浣滆〃鍚嶆渶闀?/p>
32
涓瓧绗?/p>
銆?/p>
16
銆?/p>
鐢ㄥ揩鎹烽敭閫�鍑?/p>
Excel
鐨勬寜閿槸
ALT
+
F4
閿�?/p>
锛堝鏈夎嫳鏂囪鍐欏ぇ鍐欏瓧姣嶏級
.
17
銆?/p>
Excel
鍏佽鐢ㄦ埛鏀瑰彉鏂囨湰鐨勯鑹层�?/p>
鍏堥�夋嫨鎯宠鏀瑰彉鏂囨湰棰滆壊鐨勫崟鍏冩牸鎴栧尯鍩燂紝
鐒跺悗鍗曞嚮
"
鏍煎紡
"
宸ュ叿鏍忕殑
"
瀛椾綋棰滆壊
"
鎸夐挳銆?/p>
18
銆?/p>
鍗曞厓鏍肩殑寮曠敤鏈夌浉瀵瑰紩鐢ㄣ�佺粷瀵瑰紩鐢ㄣ�?/p>
娣峰悎寮曠敤
銆傚锛?/p>
B2
灞炰簬
鐩稿寮?/p>
鐢?/p>
銆?/p>
19
銆?/p>
鍦?/p>
Excel
涓緭鍏ユ枃瀛楁椂锛岄粯璁ゅ榻愭柟寮忔槸锛氬崟鍏冩牸鍐呴潬
宸?/p>
瀵归綈銆?/p>
锛堟暟
瀛楅潬鍙冲榻愩�侀�昏緫鏁版嵁灞呬腑瀵归綈锛?/p>
20
銆?/p>
鍚?/p>
EXCEL
鍗曞厓鏍间腑锛岃緭鍏ョ敱鏁板瓧缁勬垚鐨勬枃鏈暟鎹紝搴斿湪鏁板瓧鍓嶅姞瑗挎枃鍗曞紩鍙?/p>
鈥?/p>
'
鈥?/p>
銆?/p>
21
銆?/p>
鍦?/p>
A1
鑷?/p>
A5
鍗曞厓鏍间腑姹傚嚭鏈�灏忓�硷紝搴旂敤鍑芥暟
MIN
锛?/p>
A1
锛?/p>
A5
锛?/p>
銆?/p>
22
銆?/p>
鍦?/p>
Excel
涓櫎浜嗙洿鎺ュ湪鍗曞厓鏍间腑缂栬緫鍐呭澶栵紝杩樺彲浠ヤ娇鐢?/p>
缂栬緫鏍?/p>
杩涜
缂栬緫銆?/p>
23
銆?/p>
鍦?/p>
EXCEL
涓�夊畾澶氫釜涓嶈繛缁殑鍖哄煙鐨勬柟娉曟槸锛?/p>
鍏堥�夊畾绗竴涓尯鍩燂紝
鎸変笅
CTRL+
榧犳爣鎷栨洺
閫夊畾浠ュ悗鐨勫尯鍩熴�?/p>