Excel
娴嬭瘯棰?/p>
涓�銆?/p>
鍗曢�夐
1
銆佷笅鍒楁湁鍏?/p>
Excel
宸ヤ綔琛ㄥ懡鍚嶇殑璇存硶涓紝姝ｇ‘鐨勬槸锛?/p>
锛?/p>
A
銆佸伐浣滆〃鐨勫悕瀛楀彧鑳戒互瀛楁瘝寮�澶?/p>
B
銆佸悓涓�涓伐浣滅翱鍙互瀛樺湪涓や釜鍚屽悕鐨勫伐浣滆〃
C
銆佸伐浣滆〃鐨勫懡鍚嶅簲璇モ�滆鍚嶇煡涔夆�?/p>
D
銆佸伐浣滅翱榛樿鐨勫伐浣滆〃鍚嶇О涓?/p>
Book1
2
銆佷笅鍒楁湁鍏?/p>
Excel
宸ヤ綔琛ㄥ崟鍏冩牸鐨勮娉曚腑锛岄敊璇殑鏄紙
锛?/p>
A
銆佹瘡涓崟鍏冩牸閮芥湁鍥哄畾鐨勫湴鍧�
B
銆佸悓鍒椾笉鍚屽崟鍏冩牸鐨勫搴﹀彲浠ヤ笉鍚?/p>
C
銆佽嫢骞插崟鍏冩牸鏋勬垚宸ヤ綔琛?/p>
D
銆佸悓鍒椾笉鍚屽崟鍏冩牸鍙互閫夋嫨涓嶅悓鐨勬暟瀛楀垎绫?/p>
3
銆佸鍥炬墍绀猴紝鍚戝伐浣滆〃
A2:A7
鍖哄煙杈撳叆鑰冨彿鈥?/p>
001
锝?/p>
006
鈥濅箣鍓嶏紝搴斿皢鍗曞厓鏍肩殑鏁板瓧鍒嗙被璁?/p>
缃负锛?/p>
锛?/p>
A
銆佸父瑙?/p>
B
銆佹暟鍊?/p>
C
銆佹枃鏈?/p>
D
銆佽嚜瀹氫箟
4
銆?/p>
涓嬪垪鍏充簬
Excel
鍏紡鎴栧嚱鏁扮殑璇存硶涓?/p>
,
閿欒鐨勬槸
锛?/p>
锛?/p>
A
銆佸叕寮忎腑鐨勪箻銆侀櫎鍙峰垎鍒敤
*
銆?/p>
/
琛ㄧず
B
銆佸叕寮忓鍒跺悗锛岃寮曠敤鐨勫湴鍧�鏈夊彲鑳藉彉鍖?/p>
C
銆佸叕寮忓繀椤讳互鈥?/p>
=
鈥濆彿寮�澶?/p>
D
銆佸嚱鏁扳�溿�?/p>
MAX(A1:C3)
鈥濆紩鐢ㄤ簡
4
涓崟鍏冩牸
5
銆佺敤榧犳爣鎷栨斁鎿嶄綔澶嶅埗鍗曞厓鏍兼暟鎹椂蹇呴』鍚屾椂鎸変綇锛?/p>
锛夐敭銆?/p>
A
銆?/p>
<Tab>
B
銆?/p>
<Alt>
C
銆?/p>
<Ctrl>
D
銆?/p>
<Shift>
6
銆佸鍥炬墍绀猴紝瑕佸湪宸ヤ綔琛ㄤ腑璁＄畻鍏ㄧ彮姣忎釜瀛︾敓鐨勬�诲垎锛屾渶蹇嵎鐨勬柟娉曟槸锛?/p>
锛?/p>
A
銆佺敤鍑芥暟閫愪釜璁＄畻
B
銆佺敤璁＄畻鍣ㄩ�愪釜璁＄畻
C
銆佺敤
F2
鐨勫～鍏呮焺瀹屾垚璁＄畻
D
銆佺敤鍏紡閫愪釜璁＄畻
7
銆佸湪
Excel
宸ヤ綔琛ㄤ腑锛岃兘鍦ㄥ悓涓�鍗曞厓鏍间腑鏄剧ず澶氫釜娈佃惤鐨勬搷浣滄槸锛?/p>
锛?/p>
A
銆佸皢鍗曞厓鏍兼牸寮忚涓鸿嚜鍔ㄦ崲琛?/p>
B
銆佹寜缁勫悎閿?/p>
<Alt>+<Enter>
C
銆佸悎骞朵笂涓嬪崟鍏冩牸
D
銆佹寜
<Enter>
閿?/p>
8
銆佸鍥炬墍绀猴紝鍦ㄥ伐浣滆〃涓彧鏄剧ず鏌愮鍨嬪彿杞﹁締鐨勮褰曞苟鎸夐攢鍞噺澶у皬鎺掑垪锛岄渶瑕佷娇鐢ㄧ殑鑿?/p>
鍗曞懡浠ゆ槸锛?/p>
锛?/p>
A
銆佲憼鈶?/p>
B
銆佲憼鈶?/p>
C
銆佲憽鈶?/p>
D
銆佲憽鈶?/p>
9
銆?/p>
鍏磋叮灏忕粍鐨勫悓瀛﹀鏍″洯鍐呯殑妞嶇墿绉嶇被杩涜浜嗚皟鏌ョ粺璁★紝
骞剁敤
Excel
瀵瑰師濮嬫暟鎹繘琛屽鐞嗗垎