1
1.
鍦?/p>
Excel
琛ㄦ牸鍥捐〃涓紝娌℃湁鐨勫浘褰㈢被鍨嬫槸锛?/p>
D
锛?/p>
銆?/p>
A.
鏌卞舰鍥?/p>
B.
鏉″舰鍥?/p>
C.
鍦嗛敟褰㈠浘
D.
鎵囧舰鍥?/p>
2.
浠ヤ笅鍗曞厓鏍煎紩鐢ㄤ腑锛屼笅鍒楀摢涓�椤瑰睘浜庢贩鍚堝簲鐢紙
c
锛?/p>
銆?/p>
A.E3 B.$C$18 C.C$20 D.$D$13
3.
浠ヤ笅鍥炬爣涓紝
锛?/p>
a
锛夋槸
"
鑷姩姹傚拰
"
鎸夐挳銆?/p>
A.危
B.S C.f D.fx
4.
浠ヤ笅鍥炬爣涓紝
锛?/p>
D
锛夋槸
"
绮樿创鍑芥暟
"
鎸夐挳銆?/p>
A.危
B.S C.f D.fx
5.
鍥捐〃鏄伐浣滆〃鏁版嵁鐨勪竴绉嶈瑙夎〃绀哄舰寮忥紝鍥捐〃鏄姩鎬佺殑锛屾敼鍙樺浘琛紙
D
锛夊悗锛岀郴缁熷氨浼氳嚜鍔ㄦ洿鏂?/p>
鍥捐〃銆?/p>
A.x
杞存暟鎹?/p>
B.y
杞存暟鎹?/p>
C.
鏍囬
D.
鎵�渚濊禆鏁版嵁
6.
鍙冲嚮涓�涓浘琛ㄥ璞★紝
锛?/p>
B
锛夊嚭鐜般�?/p>
A.
涓�涓浘渚?/p>
B.
涓�涓揩鎹疯彍鍗?/p>
C.
涓�涓澶?/p>
D.
鍥捐〃鍚戝
7.
鍦?/p>
Excel
鍏紡涓敤鏉ヨ繘琛屼箻鐨勬爣璁颁负锛?/p>
D
锛?/p>
銆?/p>
A.脳
B.
锛?/p>
锛?/p>
C.
鈭?/p>
D.*
8.
鍦?/p>
Excel
宸ヤ綔琛ㄤ腑锛屽亣璁?/p>
A2=7
锛?/p>
B2=6.3
锛岄�夋嫨
A2
锛?/p>
B2
鍖哄煙锛屽苟灏嗛紶鏍囨寚閽堟斁鍦ㄨ鍖哄煙鍙充笅瑙掑～鍏呭彞
鏌勪笂锛屾嫋鍔ㄨ嚦
E2
锛屽垯
E2=
锛?/p>
B
锛?/p>
銆?/p>
A.3.5 B.4.2 C.9.1 D.9.8
9.
鍦?/p>
EXCEL
涓紝鍑芥暟
SUM
锛?/p>
A1
锛?/p>
A4
锛夌瓑浠蜂簬
(
d)
A
銆?/p>
SUM
锛?/p>
A1*A4
锛?/p>
B
銆?/p>
SUM
锛?/p>
A1+A4
锛?/p>
C
銆?/p>
SUM
锛?/p>
A1/A4
锛?/p>
D
銆?/p>
SUM
锛?/p>
A1+A2+A3+A4
锛?/p>
10.
鍦?/p>
Excel
涓紝鑻ヨ瀵规墽琛岀殑鎿嶄綔杩涜鎾ゆ秷锛屽垯鏈�澶氬彲浠ユ挙娑堬紙
B
锛夋銆?/p>
A.1 B.16 C.100 D.
鏃犳暟
11
锛?/p>
鍦ㄥ鍥?/p>
4-46
鎵�绀哄伐浣滆〃鐨勫崟鍏冩牸涓绠楀伐璧勪负
800
鍏冪殑鑱屽伐鐨勯攢鍞�婚锛?/p>
搴斿湪
C6
鍗曞厓鏍间腑
杈撳叆璁＄畻鍏紡
d
銆?/p>
A
B
C
1
宸ヨ祫
閿�鍞
濂栭噾
2
800
23571
3
1000
3168
4
800
5168
5
1200
1123
鍥?/p>
4
锛?/p>
46
璁＄畻宸ヨ祫涓?/p>
800
鍏冪殑鑱屽伐鐨勯攢鍞�婚
A
锛?/p>
=SUM(A2:A5) B
锛?/p>
=SUMIF(A2:A5,800,B2:B5)
C
锛?/p>
=COUNTIF(A2:A5,800) D
锛?/p>
=SUMIF(B2:B5,800,A2:A5)
12.
鍋囪鍦?/p>
A3
鍗曞厓鏍煎瓨鏈変竴鍏紡涓?/p>
SUM(B$2:C$4
锛?/p>
,
灏嗗叾澶嶅埗鍒?/p>
B4
鍚?/p>
,
鍏紡鍙樹负
______
銆?/p>
A.SUM(B$50:B$52)
B.SUM(D$2:E$4
锛?/p>
C.SUM(B$2:C$4)
D.SUM(C$2:D$4
锛?/p>
13.
鍦?/p>
Excel
涓?/p>
,
涓�涓暟鎹竻鍗曠敱
______3
涓儴鍒嗙粍鎴愩�?/p>
A.
鏁版嵁銆佸叕寮忓拰鍑芥暟
B.
鍏紡銆佽褰曞拰鏁版嵁搴?/p>
C.
宸ヤ綔琛ㄣ�佹暟鎹拰宸ヤ綔钖?/p>
D.
鍖哄煙銆佽褰曞拰瀛楁
绛旀
.D
14.
鍦ㄥ悓涓�涓伐浣滅翱涓寮曠敤鍏朵粬宸ヤ綔琛ㄦ煇涓崟鍏冩牸鐨勬暟鎹?/p>
(
濡?/p>
Sheet8
涓?/p>
D8
鍗曞厓鏍间腑鐨勬暟鎹級
,
涓嬮潰鐨?/p>
琛ㄨ揪鏂瑰紡涓纭殑鏄?/p>
______
銆?/p>
A.=Sheet8!D8
B.=D8(Sheet8)
C.+Sheet8!D8
D.$Sheet8>$D8
绛旀
.A
15.
鍦?/p>
A1
鍗曞厓鏍间腑杈撳叆
=SUM(8,7,8,7),
鍒欏叾鍊间负
______
銆?/p>
A.15
B.30
C.7
D.8
绛旀
.B
16.
褰撳湪鏌愬崟鍏冩牸鍐呰緭鍏ヤ竴涓叕寮忓苟纭鍚?/p>
,
鍗曞厓鏍煎唴瀹规樉绀轰负
#REF!,
瀹冭〃绀?/p>
______
銆?/p>
A.
鍏紡寮曠敤浜嗘棤鏁堢殑鍗曞厓鏍?/p>
B.
鏌愪釜鍙傛暟涓嶆纭?/p>
C.
鍏紡琚浂闄?/p>
D.
鍗曞厓鏍煎お灏?/p>
绛旀
.A
17.
鍦?/p>
Excel
鎿嶄綔涓?/p>
,
鍦?/p>
A1
杈撳叆锛?/p>
COUNT("C1",120,26),
鍏跺嚱鏁板�肩瓑浜?/p>
______
銆?/p>
A.120
B.26 C.3
D.2
绛旀
.D
18.
鍋囪鍦?/p>
C1
鍗曞厓鏍煎瓨鍌ㄤ竴鍏紡涓?/p>
$A3,
灏嗗叾澶嶅埗鍒?/p>
D2
鍚?/p>
,
鍏紡鍙樹负
______
銆?/p>
A.$B3
B.$A3
C.$A4 D.$B4
绛旀
.C
19.
19.
鍦?/p>
Excel2000
宸ヤ綔琛ㄧ殑鍗曞厓鏍间腑杈撳叆鍒嗘暟
1/2 ,.
姝ｇ‘鐨勬柟娉?/p>
(
)
A 0 1/2
B 1/2
C
鈥?/p>
1/2
鈥?/p>
D 1/2%
20.
鍦ㄦ暟鎹浘琛ㄤ腑瑕佸鍔犳爣棰?/p>
,
鍦ㄦ縺娲诲浘琛ㄧ殑鍩虹涓?/p>
,
鍙互
______
銆?/p>
A.
鎵ц
"
鎻掑叆鈫掓爣棰?/p>
"
鑿滃崟鍛戒护
,
鍦ㄥ嚭鐜扮殑瀵硅瘽妗嗕腑閫夋嫨
"
鍥捐〃鏍囬
"
鍛戒护
B.
鎵ц
"
鏍煎紡鈫掕嚜鍔ㄥ鐢?/p>
鏍煎紡鍖栧浘琛?/p>
"
鍛戒护
C.
鎸夐紶鏍囧彸閿?/p>
,
鍦ㄥ揩鎹疯彍鍗曚腑鎵ц
"
鍥捐〃鏍囬
"
鑿滃崟鍛戒护
,
閫夋嫨
"
鏍囬
"
閫夐」鍗?/p>
21.
鍦?/p>
Excel
涓紝鏌愬叕寮忎腑寮曠敤浜嗕竴缁勫崟鍏冩牸锛屽畠浠槸锛?/p>
C3
锛?/p>
D7
锛?/p>
A2
锛?/p>
F1
锛夛紝璇ュ叕寮忓紩鐢ㄧ殑鍗曞厓鏍兼�绘暟
涓?/p>
_______
銆?/p>
A.4
B.8
C.12
D.16
绛旀
.A
22.
鍦?/p>
Excel
涓紝褰撲娇鐢ㄩ櫎鏁颁负
0
锛屽皢浜х敓閿欒鍊?/p>
______
銆?/p>
A.#####!
B.#DIV/0!
C.#NAME?
D.#VALUE!
绛旀
.B
23.Excel
涓紝鍦ㄨ褰曞崟鐨勫彸涓婅鏄剧ず鈥?/p>
3/30
鈥濓紝鍏舵剰涔夋槸
______
銆?/p>
A.
褰撳墠璁板綍鍗曚粎鍏佽
30
涓敤鎴疯闂?/p>
B.
鎮ㄦ槸璁块棶褰撳墠璁板綍鍗曠殑绗?/p>
30
涓敤鎴?/p>
C.
褰撳墠璁板綍鏄
3
鍙疯褰?/p>
D.
褰撳墠璁板綍鏄
30
鍙疯褰?/p>
绛旀
.C
24
锛庡湪
Excel
涓紝鍑芥暟
=sum(12,max(5,min(2,10),3))
鐨勫�间负
d
銆?/p>
A
锛?/p>
5 B
锛?/p>
10 C
锛?/p>
15 D
锛?/p>
17
25
鍦?/p>
Excel
涓紝褰撳叕寮忎腑寮曠敤浜嗘棤鏁堢殑鍗曞厓鏍兼椂锛屼骇鐢熺殑閿欒鍊兼槸锛?/p>
B
锛?/p>
銆?/p>
A
銆?/p>
#DIV/0
锛?/p>
B
銆?/p>
#REF
锛?/p>
C
銆?/p>
#NULL
锛?/p>
D
銆?/p>
#NUM
锛?/p>
26.
Excel
涓彲浠ュ疄鐜版竻闄ゆ牸寮忕殑鑿滃崟鏄?/p>
锛?/p>
D
锛?/p>
A
銆?/p>
Ctrl+C B
銆?/p>
Ctrl+V C
銆?/p>
Delete
閿?/p>
D
銆?/p>
"
缂栬緫
"
鑿滃崟涓殑
"
娓呴櫎
"
27.Excel
涓紝鍦ㄥ畬鎴愪簡鍥捐〃鍚庯紝鎯宠鍦ㄥ浘琛ㄥ簳閮ㄧ殑缃戞牸涓樉绀哄伐浣滆〃涓殑鍥捐〃鏁版嵁锛屽叾姝ｇ‘鐨勬搷浣滄槸
___D___
銆?/p>
A.
鍗曞嚮鈥滃浘琛ㄢ�濆伐鍏锋爮涓殑鈥滃浘琛ㄥ悜瀵尖�濇寜閽?/p>
B.
閫変腑鍥捐〃锛涘崟鍑烩�滃浘琛ㄢ�濆伐鍏锋爮涓殑鈥滃浘琛ㄥ悜瀵尖�濇寜閽?/p>
C.
鍗曞嚮鈥滃浘琛ㄢ�濆伐鍏锋爮涓殑鈥滄暟鎹〃鈥濇寜閽?/p>
D.
閫変腑鍥捐〃锛涘崟鍑烩�滃浘琛ㄢ�濆伐鍏锋爮涓殑鈥滄暟鎹〃鈥濇寜閽?/p>
28.
鍦?/p>
Excel
涓紝宸ヤ綔绨夸竴鑸槸鐢?/p>
______
缁勬垚鐨勩�?/p>
A.
鍗曞厓鏍?/p>
B.
鏂囧瓧
C.
宸ヤ綔琛?/p>
D.
鍗曞厓鏍煎尯鍩?/p>
绛旀
.C
29.Excel
涓紝鍦ㄥ伐浣滆〃涓鍒涘缓鍥捐〃鏃舵渶甯镐娇鐢ㄧ殑宸ュ叿鏄?/p>
__b____
銆?/p>
A.
鈥滃父鐢ㄢ�濆伐鍏锋爮涓殑鈥滅粯鍥锯�濇寜閽?/p>
B.
鈥滃父鐢ㄢ�濆伐鍏锋爮涓殑鈥滃浘琛ㄥ悜瀵尖�濇寜閽?/p>
C.
鈥滃伐鍏封�濊彍鍗曠殑鈥滈�夐」鈥濆懡浠ょ殑鈥滃浘琛ㄢ�濇爣绛?/p>
D.
鈥滄暟鎹�濊彍鍗曠殑鈥滄暟鎹�忚鏍団�濆懡浠?/p>
30.Excel
涓紝鎵�鏈夊宸ヤ綔琛ㄧ殑鎿嶄綔閮芥槸寤虹珛鍦ㄥ
______
鎿嶄綔鐨勫熀纭�涓婄殑銆?/p>
A.
宸ヤ綔绨?/p>
B.
宸ヤ綔琛?/p>
C.
鍗曞厓鏍?/p>
D.
鏁版嵁
绛旀
.C