1
Excel 2010
鐢靛瓙琛ㄦ牸娴嬭瘯鍗峰強鍙傝�冪瓟妗堬紙
D
鍗凤級
锛堟湰鍗锋弧鍒?/p>
100
鍒嗭紝鑰冭瘯鏃堕棿涓?/p>
45
鍒嗛挓锛?/p>
涓亴淇℃伅鎶�鏈被瀵瑰彛鍗囧鏁欏璧勬枡
涓瓑鑱屼笟鏁欒偛璇剧▼鏀归潻鍥藉瑙勫垝鏂版暀鏉?/p>
涓�銆佸崟椤归�夋嫨棰?/p>
锛堟瘡棰?/p>
3
鍒嗭紝鍏?/p>
45
鍒嗭級
1.
鍦?/p>
Excel
涓紝濡傛灉娌℃湁棰勫厛璁惧畾鏁翠釜宸ヤ綔琛ㄧ殑瀵归綈鏂瑰紡锛屽垯鏁板瓧鑷姩锛?/p>
锛夋柟
寮忓瓨鏀俱�?/p>
A.
宸﹀榻?/p>
B.
鍙冲榻?/p>
C.
涓ょ瀵归綈
D.
瑙嗗叿浣撴儏鍐佃�屽畾
2.
涓嬪垪鍙栧�肩浉鍚戠殑琛ㄨ揪寮忔槸锛?/p>
锛?/p>
銆?/p>
A.T&S
涓庘�?/p>
T
鈥?/p>
+
鈥?/p>
S
鈥?/p>
B.
鈥?/p>
T
鈥?/p>
&
鈥?/p>
S
鈥濅笌鈥?/p>
T
鈥?/p>
+
鈥?/p>
S
鈥?/p>
C.
鈥?/p>
T
鈥?/p>
+
鈥?/p>
S
鈥濅笌鈥?/p>
T
鈥?/p>
&
鈥?/p>
S
鈥?/p>
D.
鈥?/p>
T
鈥?/p>
&
鈥?/p>
S
鈥濅笌
LEFT(
鈥?/p>
TSST
鈥?/p>
,2)
3.
宸茬煡
A1
鍗曞厓鏍间腑鐨勫叕寮忎负
=AVERAGE
锛?/p>
B1:F6
锛?/p>
锛屽皢
B
鍒楀垹闄や箣鍚庯紝
Al
鍗曞厓鏍间腑
鐨勫叕寮忓皢璋冩暣涓猴紙
锛?/p>
銆?/p>
A.=AVERAGE
锛堬純
REF
锛?/p>
锛?/p>
B.=AVERAVE
锛?/p>
Cl
锛?/p>
F6
锛?/p>
C.=AVERAGE
锛?/p>
B1
锛?/p>
E6
锛?/p>
D.=AVERAGE
锛?/p>
B1
锛?/p>
F6
锛?/p>
4.
濡備笅鎵�绀虹殑琛ㄦ牸鍖哄煙锛?/p>
濡傛灉瑕佺畻鍑哄悇鏁颁腑
鍦ㄦ�绘暟涓墍鍗犵殑姣斾緥锛屽彲鍦?/p>
A2
鍗曞厓鏍间腑杈?/p>
鍏ワ紙
锛変箣鍚庡啀澶嶅埗鍒板尯鍩?/p>
B2:D2
涓�?/p>
A.=A1/SUM($A1
锛?/p>
$D1)
B.=Al/SUM
锛?/p>
Al:$D$1
锛?/p>
C.=Al/SUM
锛?/p>
A$1:D$1
锛?/p>
D.=Al/SUM
锛?/p>
A1:D1
锛?/p>
5.
鍦?/p>
Exeel
鎿嶄綔涓紝濡傛灉鍗曞厓鏍间腑鍑虹幇鈥滐純
DIV/0!
鈥濈殑淇℃伅锛岃繖琛ㄧず锛?/p>
锛?/p>
銆?/p>
A.
鍏紡涓嚭鐜拌闆堕櫎鐨勭幇璞?/p>
B.
鍗曞厓鏍煎紩鐢ㄦ棤鏁?/p>
C.
娌℃湁鍙敤鏁板�?/p>
D.
缁撴灉澶暱锛屽崟鍏冩牸瀹圭撼涓嶄笅
6.
浣跨敤
Excel
搴旂敤杞欢澶嶅埗鏁版嵁锛?/p>
锛?/p>
銆?/p>
A.
涓嶈兘鎶婁竴涓尯鍩熺殑鏍煎紡锛屽鍒跺埌鍙︿竴宸ヤ綔绨挎垨琛ㄦ牸
B.
鍙互鎶婁竴涓尯鍩熺殑鏍煎紡锛屽鍒跺埌鍙︿竴涓伐浣滅翱锛屼絾涓嶈兘澶嶅埗鍒板彟涓�寮犺〃鏍?/p>
C.
鍙互鎶婁竴涓尯鍩熺殑鏍煎紡锛屽鍒跺埌鍙︿竴宸ヤ綔绨挎垨琛ㄦ牸
D.
鍙互鎶婁竴涓尯鍩熺殑鏍煎紡锛屽鍒跺埌鍙︿竴寮犺〃鏍硷紝浣嗕笉鑳藉鍒跺埌鍙︿竴涓伐浣滅翱
7.
褰撳伐浣滅翱涓湁涓�鑸伐浣滆〃鍜屽浘琛ㄥ伐浣滆〃鏃讹紝鍒欏湪瀛樻枃浠舵椂浼氬垎鎴愶紙
锛変釜鏂囦欢
瀛樺偍銆?/p>
A.1 B.2 C.3 D.4
8.
鍦?/p>
Exeel
鎿嶄綔涓紝
绯荤粺鍦ㄨ繘琛屾帓搴忔椂锛?/p>
濡傞�夋嫨閫掑鏂瑰紡锛?/p>
鎺掑簭缁撴灉涓�鑸細鎸?/p>
锛?/p>
锛?/p>
鐨勯『搴忚繘琛屾帓搴忋�?/p>
A.
鏁板�硷紝涓枃锛屾棩鏈燂紝瀛楁瘝
B.
鏁板�硷紝瀛楁瘝锛屼腑鏂囷紝鏃ユ湡
C.
涓枃锛屾暟鍊笺�佹棩鏈燂紝瀛楁瘝
D.
鏃ユ湡锛屾暟鍊硷紝瀛楁瘝锛屼腑鏂?/p>
9.
闇�瑕侊紙
锛夎�屽彉鍖栫殑鎯呭喌涓嬶紝蹇呴』寮曠敤缁濆鍦板潃銆?/p>
A.
鍦ㄥ紩鐢ㄧ殑鍑芥暟涓～鍏ヤ竴涓寖鍥存椂锛屼负浣垮嚱鏁颁腑鐨勮寖鍥撮殢鍦板潃浣嶇疆涓嶅悓
B.
鎶婁竴涓崟鍏冩牸鍦板潃鐨勫叕寮忓鍒跺埌涓�涓柊鐨勪綅缃椂锛?/p>
涓轰娇鍏紡涓崟鍏冩牸鍦板潃闅?/p>
鏂颁綅缃?/p>
C.
鎶婁竴涓惈鏈夎寖鍥寸殑鍏紡鎴栧嚱鏁板鍒跺埌涓�涓柊鐨勪綅缃椂锛?/p>
涓轰娇鍏紡鎴栧嚱鏁颁腑鑼?/p>
鍥翠笉闅忔柊浣嶇疆涓嶅悓
D.
鎶婁竴涓惈鏈夎寖鍥寸殑鍏紡鎴栧嚱鏁板鍒跺埌涓�涓柊鐨勪綅缃椂锛?/p>
涓轰娇鍏紡鎴栧嚱鏁颁腑鑼?/p>
鍥撮殢鏂颁綅缃笉鍚?/p>
.
10.
鍦ㄥ崟鍏冩牸涓緭鍏ワ紙
锛?/p>
锛屼娇璇ュ崟鍏冩牸鐨勫�间负
8
銆?/p>
A.="160/20" B.=160/20 C.160/20
D."160/20鈥?/p>