涓�銆佸～绌洪锛堟瘡灏忛
1
鍒嗭紝
10
棰橈紝鍏?/p>
10
鍒嗭級
1. Excel
鏄?/p>
鐢靛瓙琛ㄦ牸搴旂敤
杞欢銆?/p>
2.
涓�涓?/p>
Excel
宸ヤ綔琛ㄦ渶澶氭湁
256
鍒?/p>
,65536
琛屻�?/p>
3.
鐢ㄥ揩鎹烽敭閫�鍑?/p>
Excel
鐨勬寜閿槸
alt+f4
閿�?/p>
4.
榛樿鎯呭喌涓?/p>
Excel
涓墍鏈夋暟鍊煎瀷鏁版嵁鍦ㄥ崟鍏冩牸鍐呭潎闈?/p>
鍙?/p>
瀵归綈
5.
鍦?/p>
Excel
涓緭鍏ユ枃瀛楁椂锛岄粯璁ゅ榻愭柟寮忔槸锛氬崟鍏冩牸鍐呴潬
宸?/p>
瀵归綈銆?/p>
6.
鍦?/p>
Excel
宸ュ叿鏍忎腑鏈変竴涓?/p>
"
鈭?/p>
"
鑷姩姹傚拰鎸夐挳銆傚畠浠ｈ〃浜?/p>
sum
鍑芥暟銆?/p>
7.
鍦?/p>
Excel
鍗曞厓鏍间腑锛岃緭鍏ョ敱鏁板瓧缁勬垚鐨勬枃鏈暟鎹紝搴斿湪鏁板瓧鍓嶅姞
銆?/p>
8.
鍦?/p>
Excel
涓櫎浜嗙洿鎺ュ湪鍗曞厓鏍间腑缂栬緫鍐呭澶栵紝杩樺彲浠ヤ娇鐢?/p>
杩涜缂栬緫銆?/p>
10.
鍦?/p>
A1
鑷?/p>
A5
鍗曞厓鏍间腑姹傚嚭骞冲潎鍊硷紝搴旂敤鍑芥暟
銆?/p>
浜屻�侀�夋嫨棰橈紙姣忓皬棰樺彧鏈変竴涓纭瓟妗堬紝
30
棰橈紝鍏?/p>
90
鍒嗭級
1.
鍚姩
Excel2000
鐨勬纭搷浣滄柟娉曟槸
___________
銆?/p>
A.
寮�濮嬧啋绋嬪簭鈫?/p>
Microsoft Excel
B.
寮�濮嬧啋绋嬪簭鈫?/p>
Microsoft word
C.
寮�濮嬧啋绋嬪簭鈫?/p>
Microsoft PowerPoint
D.
寮�濮嬧啋绋嬪簭鈫?/p>
Microsoft Exchange
2.
鍦?/p>
Excel
宸ヤ綔绐楀彛涓婏紝
"
鐘舵�佹爮
"
鏄湪灞忓箷鐨?/p>
____b_____
銆?/p>
A.
涓婇潰
B.
涓嬮潰
C.
宸﹂潰
D.
鍙抽潰
3.
鎻掑叆鍗曞厓鏍肩殑甯歌鎿嶄綔姝ラ鏄?/p>
___________
銆?/p>
A.
閫夊畾鍗曞厓鏍硷紝鏍煎紡鈫掑崟鍏冩牸鈫掑湪
"
鎻掑叆
"
瀵硅瘽妗嗕腑浣滈�傚綋閫夋嫨鈫掔‘瀹?/p>
B.
閫夊畾鍗曞厓鏍硷紝鎻掑叆鈫掑崟鍏冩牸鈫掑湪
"
鎻掑叆
"
瀵硅瘽妗嗕腑浣滈�傚綋閫夋嫨鈫掔‘瀹?/p>
C.
閫夊畾鍗曞厓鏍硷紝宸ュ叿鈫掗�夐」鈫掑湪
"
閫夐」
"
瀵硅瘽妗嗕腑浣滈�傚綋閫夋嫨鈫掔‘瀹?/p>
D.
閫夊畾鍗曞厓鏍硷紝鎻掑叆鈫掑璞♀啋鍦?/p>
"
瀵硅薄
"
瀵硅瘽妗嗕腑浣滈�傚綋閫夋嫨鈫掔‘瀹?/p>
4.
鍒犻櫎褰撳墠宸ヤ綔琛ㄧ殑鏌愬垪鐨勬纭搷浣滄楠ゆ槸
:
閫夊畾璇ュ垪锛屾墽琛?/p>
___________
銆?/p>
A.
缂栬緫鈫掑垹闄?/p>
B.
缂栬緫鈫掑壀鍒?/p>
C.
缂栬緫鈫掓竻闄?/p>
D.
鎸?/p>
Delete
閿?/p>
5.
鍦?/p>
Excel
鍏紡涓敤鏉ヨ繘琛屼箻鐨勬爣璁颁负锛?/p>
锛?/p>
銆?/p>
A.
脳
B.
锛?/p>
锛?/p>
C.
鈭?/p>
D.*
6.
鍦?/p>
Excel
宸ヤ綔琛ㄤ腑锛屽亣璁?/p>
A2=7
锛?/p>
B2=6.3
锛岄�夋嫨
A2
锛?/p>
B2
鍖哄煙锛屽苟灏嗛紶鏍囨寚閽堟斁鍦ㄨ鍖哄煙
鍙充笅瑙掑～鍏呭彞鏌勪笂锛屾嫋鍔ㄨ嚦
E2
锛屽垯
E2=
锛?/p>
锛?/p>
銆?/p>
A.3.5
B.4.2
C.9.1
D.9.8
7.
璁剧疆鍗曞厓鏍间腑鏁版嵁灞呬腑瀵归綈鏂瑰紡鐨勭畝渚挎柟娉曟槸
_________
銆?/p>
A.
閫夊畾鍗曞厓鏍煎尯鍩熲啋
"
璺ㄥ垪灞呬腑
"
鎸夐挳
B.
閫夊畾鍗曞厓鏍煎尯鍩熲啋
"
灞呬腑
"
鎸夐挳
C.
鍗曞嚮鏍煎紡宸ュ叿鏍?/p>
"
璺ㄥ垪灞呬腑
"
鎸夐挳
D.
鍗曞嚮鏍煎紡宸ュ叿鏍?/p>
"
灞呬腑
"
鎸夐挳
8.
Excel
涓嚱鏁?/p>
A
VERAGE
鐨勫姛鑳芥槸
________
銆?/p>
A.
姹傝寖鍥村唴鎵�鏈夋暟瀛楃殑骞冲潎鍊?/p>
B.
姹傝寖鍥村唴鏁版嵁鐨勪釜鏁?/p>
C.
姹傝寖鍥村唴鎵�鏈夋暟瀛楃殑鍜?/p>
D.
杩斿洖鍑芥暟涓殑鏈�澶у�?/p>
9. Excel
涓嚱鏁?/p>
SUM
鐨勫姛鑳芥槸
__________
銆?/p>
A.
姹傝寖鍥村唴鎵�鏈夋暟瀛楃殑骞冲潎鍊?/p>
B.
姹傝寖鍥村唴鏁版嵁鐨勪釜鏁?/p>
C.
姹傝寖鍥村唴鎵�鏈夋暟瀛楃殑鍜?/p>
D.
杩斿洖鍑芥暟涓殑鏈�澶у�?/p>
10.
鍦ㄥ崟鍏冩牸涓緭鍏ュ叕寮忔椂锛岃緭鍏ョ殑绗竴涓鍙锋槸
__________
銆?/p>
A
銆?/p>
=
B
銆?/p>
锛?/p>
C
銆侊紞
D
銆?/p>
$
11.Microsoft Excel
宸ヤ綔绨跨殑鎵╁睍鍚嶆槸
_______
A. bok
B. xls
C. doc
D. txt
12.
鍦?/p>
Excel
涓紝鎵�鏈夊宸ヤ綔琛ㄧ殑鎿嶄綔閮芥槸寤虹珛鍦ㄥ
______
鎿嶄綔鐨勫熀纭�涓婄殑銆?/p>
A.
宸ヤ綔绨?/p>
B.
宸ヤ綔琛?/p>
C.
鍗曞厓鏍?/p>
D.
鏁版嵁
13.Excel
鐢靛瓙琛ㄦ牸搴旂敤杞欢涓紝鍏锋湁鏁版嵁
_____
鐨勫姛鑳姐�?/p>