EXCEL
鐞嗚鑰冭瘯妯℃嫙璇曢
鐝骇锛?/p>
濮撳悕锛?/p>
鍒嗘暟锛?/p>
鑰冭瘯鏃堕棿锛?/p>
45
鍒嗛挓
涓�銆佸崟椤归�夋嫨棰橈紙姣忛
2
鍒嗭紝鍏?/p>
60
鍒嗭級
1
銆?/p>
EXCEL
涓竴涓伐浣滆〃鏈夊灏戝垪锛?/p>
锛?/p>
A)16384
B)255
C)256
D)3
2
銆?/p>
Max
鍑芥暟鐨勫姛鑳芥槸锛?/p>
锛?/p>
A)
姹傛寚瀹氬尯鍩熸渶澶у�?/p>
B)
姹傛寚瀹氬尯鍩熸渶灏忓�?/p>
C)
姹傛寚瀹氬尯鍩熶箣鍜?/p>
D)
姹傛寚瀹氬尯鍩熷钩鍧囨暟
3
銆?/p>
涓嬪垪涓嶅睘浜?/p>
office
缁勪欢鐨勬槸杞欢鏄?/p>
锛?/p>
锛?/p>
A)Word
B)PowerPoint
C)Excel
D)Internet Explorer
4
銆?/p>
鍦?/p>
EXCEL2007
涓紝姣忎釜宸ヤ綔琛ㄦ渶澶氱敱锛?/p>
锛夎鏋勬垚
A
锛?/p>
256
B
锛?/p>
512
C
锛?/p>
1024
D
锛?/p>
1048576
5
銆?/p>
鍦ㄥ伐浣滆〃涓閫夋嫨澶氫釜涓嶈繛缁尯鍩燂紝鍦ㄩ�夊畾绗竴涓崟鍏冩牸鍖哄煙鍚庯紝鎸変綇锛?/p>
锛夐敭涓嶆斁锛屽啀閫夋嫨鍏跺畠
鍖哄煙
A
锛?/p>
SHIFT
B
锛?/p>
ESC
C
锛?/p>
CTRL
D
锛?/p>
CTRL+ENTER
6
銆佹帓搴忔渶澶氬彲鎸囧畾锛?/p>
锛夊灏戝垪
A
锛?/p>
1
B
锛?/p>
2
C
锛?/p>
3
D
锛?/p>
4
7
銆?/p>
EXCEL
涓繚瀛樻煇宸ヤ綔绨垮悗锛岃宸ヤ綔绨挎墿灞曞悕涓猴紙
锛?/p>
A
锛?/p>
.DOC
B
锛?/p>
.XLS
C
锛?/p>
.TXT
D
锛?/p>
.BAT
8
銆佷笅鍒楀湴鍧�涓娇鐢ㄧ浉瀵瑰湴鍧�鐨勬槸
( )
A)$A$1
B)A1
C)$A1
D)A$1
9
銆佽缃崟鍏冩牸鏂囧瓧鏂瑰悜鏄湪鈥滃崟鍏冩牸鏍煎紡鈥濆璇濇涓紙
锛夐�夐」鍗′腑
A
锛夋暟瀛?/p>
B
锛夊榻?/p>
C
锛夊瓧浣?/p>
D
锛夌紪杈?/p>
10
銆?/p>
A1=220,B1=150,
鍒欏叕寮?/p>
=sum(A1,B1)
缁撴灉涓猴紙
锛?/p>
A)220
B)150
C) 270
D) 370
11
銆?/p>
A1=100,B1=200,A2=300,B2=400,
鍒欏叕寮?/p>
=SUM
锛?/p>
A1:B2
锛夌粨鏋滀负锛?/p>
锛?/p>
A)100
B)200
C)1000
D)500
12
銆?/p>
A1=100,B1=50,A2=30,B2=20,
鍒欏叕寮?/p>
=if(a1<=60,a2,b2)
缁撴灉涓猴紙
锛?/p>
A)100
B)50
C)30
D)20
13
銆?/p>
A1=80,B1=35,
鍒欏叕寮?/p>
=if(and(a1<60,b1<60)
锛屸�濅笉鍙婃牸鈥濓紝鈥濊ˉ鑰冣�?/p>
)
锛?/p>
锛?/p>
A)
浼樼
B)
鍙婃牸
C)
涓嶅強鏍?/p>
D)true
14
銆佽緭鍏ユ棩鏈熸柟娉曟槸锛屽
5
鏈?/p>
4
鏃ャ�?/p>
锛?/p>
锛?/p>
A)5/4
B)5|4
C)5\4
D)
浠ヤ笂鍧囧