涓�銆佸～绌洪
1
銆?/p>
Excel2003
涓崟鍏冩牸榛樿瀵归綈鏂瑰紡涓庢暟鎹被鍨嬫湁鍏筹紝鏂囧瓧鏄?/p>
宸﹀榻?/p>
锛屾暟瀛楁槸
鍙冲榻愩�?/p>
2
銆佽嫢閫夋嫨浜嗕粠
A5
鍒?/p>
B7
锛屼粠
C7
鍒?/p>
E9
涓や釜鍖哄煙锛屽垯鍦?/p>
EXCEL2003
涓殑琛ㄧず鏂规硶涓?/p>
A5:B7,C7:E9
銆?/p>
3
銆?/p>
Excel2003
涓紝娣诲姞杈规銆侀鑹叉搷浣滄槸浠?/p>
鏍煎紡
鑿滃崟寮�濮嬨�?/p>
4
銆佸湪鍗曞厓鏍间腑杈撳叆鏁板瓧鏃讹紝鏈夋椂鍗曞厓鏍兼樉绀轰负鈥滐純锛冿純锛冿純锛冿純鈥濊繖鏄洜涓?/p>
鍗曞厓鏍煎搴﹀お
灏忔棤娉曟甯告樉绀哄叾涓殑鏁版嵁鍐呭銆?/p>
5
銆佸皢鍗曞厓鏍?/p>
E1
鐨勫叕寮?/p>
SUM
锛?/p>
A1:D1)
澶嶅埗鍒板崟鍏冩牸
E2,
鍒?/p>
E2
涓殑鍏紡涓?/p>
SUM(A2:D2)
銆?/p>
6
銆佸湪
Excel2003
涓紝鍏崇郴杩愮畻绗︾殑杩愮畻缁撴灉鏄?/p>
TRUE
鎴?/p>
FASLE
銆?/p>
7
銆佸湪
Excel2003
鐨勪竴涓崟鍏冩牸涓緭鍏?/p>
6/20
锛屽垯璇ュ崟鍏冩牸鏄剧ず
6
鏈?/p>
20
銆?/p>
8
銆佸湪
Excel2003
鐨勪竴涓崟鍏冩牸涓緭鍏?/p>
锛屽垯琛ㄧず鏁板�间竷鍒嗕箣浜屻�?/p>
9
銆佸湪宸ヤ綔琛?/p>
Sheetl
涓紝鑻?/p>
A1
涓?/p>
"20"
锛?/p>
B1
涓?/p>
"40"
锛?/p>
A2
涓?/p>
"15"
锛?/p>
B2
涓?/p>
"30"
锛屽湪
C1
杈撳叆鍏紡
"=A1+B1"
锛屽皢
鍏紡浠?/p>
C1
澶嶅埗鍒?/p>
C2
锛屽垯
C2
鐨勫�间负
45
銆?/p>
10
銆佸湪
Excel
涓紝
D5
杈撳叆鍏紡
"=A5+$B$4"
锛屽垹闄ょ
3
琛屽悗锛屽垯
D5
鐨勫叕寮忎负
=A4+$B$3
銆?/p>
11
銆?/p>
鍦ㄥ伐浣滆〃
Sheetl
涓紝
鑻ュ湪
C3
杈撳叆鍏紡
"=$A3+B$3"
锛?/p>
鐒跺悗灏嗗叕寮忎粠
C3
澶嶅埗鍒?/p>
C4
锛?/p>
鍐嶅皢鍏紡澶嶅埗鍒?/p>
D4
锛?/p>
鍒?/p>
D4
涓殑鍏紡涓?/p>
$A4+C$3
銆?/p>
12
銆佸湪
Excel
涓紝鍦ㄥ嚱鏁拌绠楁椂锛岃嫢鏈?/p>
=SUM(A1
锛?/p>
A2
锛?/p>
D2
锛?/p>
C5)
锛屽垯琛ㄧず
A1+A2+B2+C2+D2+C5
銆?/p>
13
銆佸鏋滃湪
A1
銆?/p>
B1
鍜?/p>
C1
涓変釜鍗曞厓鏍煎垎鍒緭鍏ユ暟鎹?/p>
1
銆?/p>
2
鍜?/p>
3
锛屽啀閫夋嫨鍗曞厓鏍?/p>
D4
锛岀劧鍚庡崟鍑诲父鐢ㄥ伐鍏锋爮涓?/p>
鐨勬寜閽?/p>
"
危
"
锛屽垯鍦ㄥ崟鍏冩牸
D1
鏄剧ず
=SUM
锛?/p>
A1
锛?/p>
C1
锛?/p>
銆?/p>
14
銆佸湪宸ヤ綔琛?/p>
Sheetl
涓紝璁惧凡瀵瑰崟鍏冩牸
A1
銆?/p>
B1
鍒嗗埆杈撳叆鏁版嵁
20
銆?/p>
40
锛岃嫢瀵瑰崟鍏冩牸
C1
杈撳叆鍏紡
"=A&B1"
锛?/p>
鍒?/p>
C1
鐨勫�间负
2040
銆?/p>
15
銆佸悜鍗曞厓鏍间腑杈撳叆鐨勬暟鎹紝鍏剁被鍨嬪彲浠ユ槸
鏂?/p>
鏈紝鏁?/p>
鍊硷紝鏃堕棿鏃舵湡
銆?/p>
16
銆侀粯璁ゅ瓧浣撲负
瀹嬩綋
锛?/p>
纾?/p>
锛?/p>
鍙互鍔?/p>
锛岃缃?/p>
銆?/p>
17
銆佺壒娈婃晥鏋滄湁锛?/p>
鍒犻櫎绾?/p>
锛?/p>
涓婃爣
锛?/p>
涓嬫爣
銆?/p>
18
銆佸湪
Excel2003
绐楀彛鐨勪富浣撴槸
宸ヤ綔琛紝
瀹冩槸鐢?/p>
鍗曞厓鏍?/p>
缁勬垚銆?/p>
19
銆佸湪
Excel2003
涓紝姣忎竴涓崟鍏冩牸閮芥湁鍥哄畾鐨勫湴鍧�锛屸�?/p>
R4CF
鈥濊〃绀虹殑鏄?/p>
F
鍒楋紝绗?/p>
4
琛屻�?/p>
20
銆佸湪
Excel
涓紝涓�涓伐浣滅翱灏辨槸涓�涓?/p>
Excel
鏂囦欢锛屽叾鎵╁睍鍚嶄负
.XLS
21
銆?/p>
Excel 2003
鐨勪竴涓伐浣滅翱锛屾渶澶氬彲浠ユ坊鍔犺嚦
255
涓伐浣滆〃
.
22
銆?/p>
Excel 2003
鐨勯粯璁ゅ伐浣滆〃鍒嗗埆鍛藉悕涓?/p>
Sheetl
銆?/p>
Sheet2
銆?/p>
Sheet3
23
銆?/p>
浠庡井鏈虹殑瑁呴厤瑙掑害鏉ヨ锛岄�氬父鎶婂井鏈哄垎涓?/p>
纭欢绯荤粺
鍜?/p>
杞欢绯荤粺
涓ら儴鍒嗐�?/p>
24
銆佽绠楁満涓殑瀛樺偍鍣ㄤ竴鑸槸鎸?/p>
涓诲瓨鍌ㄥ櫒
鍜?/p>
杈呭姪瀛樺偍鍣?/p>
25
銆侀粯璁ょ殑鏁版嵁浼樺厛椤哄簭鏄細鏁板瓧
--ASCII
瀛楃
--
閫昏緫鍊?/p>
--
閿欒鍊?/p>
--
绌虹櫧鍗曞厓鏍?/p>
鍒ゆ柇姝ｈ
鍦?/p>
Excel2003
绐楀彛涓紝缂栬緫鏍忓乏杈圭殑鏄伐鍏锋爮銆?/p>
锛?/p>
閿?/p>
锛?/p>
2
銆佸湪
Excel2003
鍗曞厓鏍间腑杈撳叆
=9>(7-4)
锛屽皢鏄剧ず
Fasle
銆?/p>
锛?/p>
閿?/p>
锛?/p>
3
銆佸湪
Excel2003
鐨勪竴涓崟鍏冩牸涓緭鍏?/p>
(100),
鍒欏崟鍏冩牸鏄剧ず涓?/p>
-100
銆?/p>
锛?/p>
瀵?/p>
锛?/p>
4
銆佸湪
Excel2003
涓紝鍑芥暟
MAX
鐨勫姛鑳芥槸姹傛渶灏忓�?/p>
锛?/p>
閿?/p>
锛?/p>
5
銆佸湪鍦?/p>
Excel2003
涓紝杈撳叆鍏紡蹇呴』浠モ�?/p>
=
鈥濆紑澶达紝杈撳叆鍑芥暟鏃剁洿鎺ヨ緭鍏ュ嚱鏁板悕锛岃�屼笉闇�瑕佷互鈥?/p>
=
鈥濆紑澶淬�?/p>
锛?/p>
瀵?/p>
锛?/p>
6
銆佹寜鐓х己鐪佺殑瑙勫畾锛屽湪
Excel2003
琛ㄦ牸涓崟鍏冩牸鐨勬暟鍊兼暟鎹湪鏄剧ず鏃堕潬宸﹀榻愩�?/p>
锛?/p>
閿?/p>
锛?/p>
7
銆佸湪
Excel2003
涓紝
A1
鍗曞厓鏍艰瀹氬叾鏁板瓧鏍煎紡涓烘暣鏁帮紝褰撹緭鍏モ�?/p>
33.7
鈥濇椂锛屾樉绀轰负鈥?/p>
33
鈥濄�?/p>
锛?/p>
閿?/p>
锛?/p>
涓夈�侀�夋嫨棰?/p>
1
銆佺紪杈戞爮涓殑绗﹀彿鈥滃嬀鈥濊〃绀猴細锛?/p>
A
锛?/p>
銆?/p>
A
銆佺‘璁よ緭鍏?/p>
B
銆佸彇娑堣緭鍏?/p>
C
銆佺紪杈戝叕寮?/p>
D
銆佺紪杈戞枃瀛?/p>
2
銆?/p>
Excel2003
涓?/p>
,
瑕佸鏌愪簺鏁板瓧姹傚拰锛屽垯閲囩敤涓嬪垪鍝釜鍑芥暟
锛?/p>
C
锛?/p>
銆?/p>
A
銆?/p>
SUM B
銆?/p>
AVERAGE C
銆?/p>
MAX D
銆?/p>
IP
3
銆佸湪宸ヤ綔琛?/p>
Sheel1
涓紝鑻?/p>
A1
涓?/p>
"20"
锛?/p>
B1
涓?/p>
"40"
锛屽湪
C1
杈撳叆鍏紡
"=A1+B1"
锛屽垯
C1
鐨勫�间负
锛?/p>
C
锛?/p>
銆?/p>
A
銆?/p>
35 B
銆?/p>
45 C
銆?/p>
60 D
銆?/p>
70
4
銆佸湪宸ヤ綔琛?/p>
Sheetl
涓紝鑻?/p>
A1
涓?/p>
"20"
锛?/p>
B1
涓?/p>
"40"
锛?/p>
A2
涓?/p>
"15"
锛?/p>
B2
涓?/p>
"30"
锛屽湪
C1
杈撳叆鍏紡
"=A1+B1"
锛屽皢
鍏紡浠?/p>
C1
澶嶅埗鍒?/p>
C2
锛屽啀灏嗗叕寮忓鍒跺埌
D2
锛屽垯
C2
鐨勫�间负
锛?/p>
C
锛?/p>
銆?/p>
A
銆?/p>
35 B
銆?/p>
45 C
銆?/p>
75 D
銆?/p>
90
5
銆佸湪宸ヤ綔琛?/p>
Sheetl
涓紝鑻?/p>
A1
涓?/p>
"20"
锛?/p>
B1
涓?/p>
"40"
锛?/p>
A2
涓?/p>
"15"
锛?/p>
B2
涓?/p>
"30"
锛屽湪
C1
杈撳叆鍏紡
"=$A1+B$1"
锛?/p>
灏嗗叕寮忎粠
C1
澶嶅埗鍒?/p>
C2
锛屽垯
C2
鐨勫�间负锛?/p>
B
锛?/p>
銆?/p>
A
銆?/p>
45 B
銆?/p>
55 C
銆?/p>
60 D
銆?/p>
75
6
銆?/p>
鍦?/p>
Excel
2000
涓紝
濡傛灉闇�瑕佸紩鐢ㄥ悓涓�宸ヤ綔绨跨殑鍏跺畠宸ヤ綔琛ㄧ殑鍗曞厓鏍兼垨鍖哄煙锛?/p>
鍒欏湪宸ヤ綔琛ㄥ悕涓庡崟鍏冩牸
锛堝尯
濮?/p>
鍚?/p>
骞?/p>
绾?/p>
瀛?/p>
鍙?/p>