1.鍦‥xcel涓�锛屼繚瀛樺伐浣滅翱鏅傚睆骞曡嫢鍑虹従(xi脿n)”鍙﹀瓨鐐�”灏嶈┍妗�锛屽墖瑾槑____C_____銆�

(A) 瑭叉枃浠朵綔浜嗕慨鏀�

(B) 瑭叉枃浠跺凡缍�(j墨ng)淇濆瓨閬�

(C) 瑭叉枃浠舵湭淇濆瓨閬�

(D) 瑭叉枃浠朵笉鑳戒繚瀛�

2.闂�(gu膩n)浜庡湒琛ㄧ殑閷鏁樿堪鏄痏__C______銆�

(A) 閬稿畾鏁�(sh霉)鎿�(j霉)鍗€(q奴)鍩熸檪鏈€濂介伕瀹氬付琛ㄩ牠鐨勪竴鍊嬫暩(sh霉)鎿�(j霉)鍗€(q奴)鍩�

(B) 鍦栬〃鍙互鏀惧湪涓€鍊嬫柊鐨勫伐浣滆〃涓�,涔熷彲宓屽叆鍦ㄤ竴鍊嬬従(xi脿n)鏈夌殑宸ヤ綔琛ㄤ腑

(C) 鍙兘浠ヨ〃鏍煎垪浣滅偤鏁�(sh霉)鎿�(j霉)绯诲垪

(D) 鐣�(d膩ng)宸ヤ綔琛ㄥ崁(q奴)鍩熶腑鐨勬暩(sh霉)鎿�(j霉)鐧�(f膩)鐢熻畩鍖栨檪锛岀敱閫欎簺鏁�(sh霉)鎿�(j霉)鐢�(ch菐n)鐢熺殑鍦栬〃鐨勫舰鐙€鏈冭嚜鍕曟洿鏂�

3.鍦‥xcel涓紝閬稿彇鏁村€嬪伐浣滆〃鐨勬柟娉曟槸___A_____銆�

(A) 鎸夌祫鍚堥嵉銆恈trl銆�+A

(B) 鍠搳A1鍠厓鏍硷紝鐒跺悗鎸変綇銆怌trl銆戦嵉鍠搳宸ヤ綔琛ㄧ殑鍙充笅瑙掑柈鍏冩牸

(C) 鍠搳”绶ㄨ集”鑿滃柈鐨�”鍏ㄩ伕”鍛戒护

(D) 鍠搳A1鍠厓鏍�锛岀劧鍚庢寜浣忋€怱hift銆戦嵉鍠搳鐣�(d膩ng)鍓嶅睆骞曠殑鍙充笅瑙掑柈鍏冩牸

4.鍦‥xcel涓�锛屼笅鍒梍___C____鏄几鍏ユ纰虹殑鍏紡褰㈠紡銆�

(A) >=b2*d3+1

(B) ='c7+c1

(C) =sum(d1:d2)

(D) 64

(A) 鍠搳”鎻掑叆”鑿滃柈涓殑”鍑芥暩(sh霉)”鍛戒护 (鎻掑叆灏嶈薄鍏紡)

(B) 鍠搳宸ュ叿娆勪腑鐨�”绮樿布鍑芥暩(sh霉)”鎸夐垥

(C) 鍠搳”绶ㄨ集”鑿滃柈涓殑”灏嶈薄...”鍛戒护

(D) 鍠搳”绶ㄨ集鍏紡”鎸夐垥锛屽湪寰炲乏绔殑鍑芥暩(sh霉)鍒楄〃涓伕鎿囨墍闇€鍑芥暩(sh霉)

6.鍙敤____D_____琛ㄧずSheet2宸ヤ綔琛ㄧ殑B9鍠厓鏍�銆�

(A) =Sheet2$B9

(B) =Sheet2.B9

(C) =Sheet2:B9

7.浣滅偤鏁�(sh霉)鎿�(j霉)鐨勪竴绋〃绀哄舰寮忥紝鍦栬〃鏄嫊鎱�(t脿i)鐨�锛岀暥(d膩ng)鏀硅畩浜嗗叾涓璤__D_____涔嬪悗锛孍xcel鏈冭嚜鍕曟洿鏂板湒琛�銆�

(A) Y杌镐笂鐨勬暩(sh霉)鎿�(j霉)

(B) 妯�(bi膩o)椤岀殑鍏�(n猫i)瀹�

(C) X杌镐笂鐨勬暩(sh霉)鎿�(j霉)

(D) 鎵€渚濊炒鐨勬暩(sh霉)鎿�(j霉) (鑷嫊鏇存柊鍦栬〃)

8.鍦‥xcel涓紝瑷�(sh猫)A1鍠厓鏍间腑鐨勫叕寮忕偤=AVERAGE(C1:E5)锛屽皣C鍒楀埅闄ゅ悗锛孉1鍠厓鏍间腑鐨勫叕寮忓皣瑾�(di脿o)鏁確__A______銆�

(A) =AVERAGE(C1:D5)

(B) =AVERAGE(D1:E5)

(C)=AVERAGE(C1:E5)

(D) 鍑洪尟

9.鍦‥xcel涓紝涓嬮潰鎿嶄綔搴忓垪灏囬伕鍙朹___C_____鍗€(q奴)鍩燂細鍠搳A2鍠厓鏍�锛屾寜銆怓8銆戦嵉锛屽柈鎿奅8鍠厓鏍�锛屽柈鎿奃9鍠厓鏍硷紝鍐嶆寜銆怓8銆戦嵉銆�

(A) E8:D9

(B) A2:E8

(C) A2:D9

(D) A2:E9

10.闂�(gu膩n)浜庡埅闄ゅ伐浣滆〃鐨勬晿杩伴尟瑾ょ殑鏄痏___D_____銆�

(A) 宸ヤ綔琛ㄧ殑鍒櫎鏄案涔呮€у埅闄�锛屼笉鍙仮寰�(f霉)

(B) 鍙虫搳鐣�(d膩ng)鍓嶅伐浣滆〃妯�(bi膩o)绨�,鍐嶅緸蹇嵎鑿滃柈涓伕"鍒櫎"鍙埅闄ょ暥(d膩ng)鍓嶅伐浣滆〃

(C) 鍩�(zh铆)琛�"绶ㄨ集/鍒櫎宸ヤ綔琛�"鑿滃柈鍛戒护鍙埅闄ょ暥(d膩ng)鍓嶅伐浣滆〃

(D) 瑾ゅ埅浜嗗伐浣滆〃鍙柈鎿婂伐鍏锋瑒鐨�"鎾ゆ秷"鎸夐垥鎾ゆ秷鍒櫎鎿嶄綔

鐠�(hu谩n)鐞冪恫(w菐ng)鏍″弸鎯呮彁绀猴細浠ヤ笂鍏�(n猫i)瀹规槸鐠�(hu谩n)鐞冪恫(w菐ng)鏍＄祼(ji茅)妲�(g貌u)宸ョ▼甯牷閬撶偤鎮ㄦ暣鐞嗙殑"2019涓€绱氱祼(ji茅)妲�(g貌u)宸ョ▼甯熀绀�(ch菙)鐭ヨ瓨鍌欒€冮"锛屾洿澶氳硣鏂欒珛榛炴搳鏂囩珷涓嬫柟“鍏嶈不涓嬭級>>>绲�(ji茅)妲�(g貌u)宸ョ▼甯│椤�/鑰冮粸绮捐彲”鍏嶈不涓嬭級瀛�(xu茅)缈�(x铆)銆�