銆婅绠楁満搴旂敤鍩虹銆?/p>
Excel2010
娴嬭瘯棰?/p>
涓�銆佸～绌洪銆傦紙姣忕┖
2
鍒嗭紝鍏?/p>
14
鍒嗭級
1.Excel 2010
榛樿淇濆瓨宸ヤ綔钖勭殑鏍煎紡鎵╁睍涓?/p>
(
)
銆?/p>
2.
鍦?/p>
Excel
涓紝濡傛灉瑕佸皢宸ヤ綔琛ㄥ喕缁撲究浜庢煡鐪嬶紝鍙互鐢?/p>
(
)
鍔熻兘鍖虹殑
鈥?/p>
鍐荤粨绐楁牸
鈥?/p>
鏉?/p>
瀹炵幇銆?/p>
3.
鍦?/p>
Excel 2010
涓柊澧?/p>
鈥?/p>
杩蜂綘鍥?/p>
鈥?/p>
鍔熻兘锛屽彲閫夊畾鏁版嵁鍦ㄦ煇鍗曞厓鏍间腑鎻掑叆杩蜂綘鍥撅紝鍚屾椂鎵?/p>
寮�
(
)
鍔熻兘鍖鸿繘琛岀浉搴旂殑璁剧疆銆?/p>
4.
鍦?/p>
Excel
涓紝濡傛灉瑕佸鏌愪釜宸ヤ綔琛ㄩ噸鏂板懡鍚嶏紝鍙互鐢?/p>
(
)
鍔熻兘鍖虹殑
鈥?/p>
鏍煎紡
鈥?/p>
鏉ュ疄
鐜般�?/p>
5.
鍦?/p>
A1
鍗曞厓鏍煎唴杈撳叆
鈥?0001鈥?/p>
锛岀劧鍚庢寜涓?/p>
鈥淐TRL 鈥?/p>
閿紝鎷栧姩璇ュ崟鍏冩牸濉厖鏌勮嚦
A8
锛屽垯
A8
鍗曞厓鏍间腑鍐呭鏄?/p>
(
)
銆?/p>
6.
涓�涓伐浣滆杽鍖呭惈澶氫釜宸ヤ綔琛紝缂虹渷鐘舵�佷笅鏈?/p>
(
)
涓伐浣滆〃锛屽垎鍒负
Sheet1
銆?/p>
Sheet2
銆?/p>
Sheet3
銆?/p>
7.Excel 2010
涓紝瀵硅緭鍏ョ殑鏂囧瓧杩涜缂栬緫鏄�夋嫨
(
)
鍔熻兘鍖恒�?/p>
浜屻�侀�夋嫨棰樸�?/p>
(
姣忓皬棰?/p>
2
鍒嗭紝鍏?/p>
50
鍒?/p>
)
1.
鍦?/p>
Excel 2010
涓墦寮�
鈥?/p>
鍗曞厓鏍兼牸寮?/p>
鈥?/p>
鐨勫揩鎹烽敭鏄?/p>
(
)
銆?/p>
A)CTRL+Shift+E
B)CTRL+Shift+F
C)CTRL+Shift+G
D)CTRL+Shift+H
2.
鍦ㄥ崟鍏冩牸杈撳叆涓嬪垪鍝釜鍊硷紝璇ュ崟鍏冩牸鏄剧ず
0.3
銆?/p>
(
)
A)6/20
B)=6/20
C) 鈥?/20鈥?/p>
D)=鈥?/20鈥?/p>
3.
涓嬪垪鍑芥暟锛岃兘瀵规暟鎹繘琛岀粷瀵瑰�艰繍绠?/p>
(
)
銆?/p>
A)ABS
B)ABX
C)EXP
D)INT
4.Excel 2010
涓紝
濡傛灉缁欐煇鍗曞厓鏍艰缃殑灏忔暟浣嶆暟涓?/p>
2
锛?/p>
鍒欒緭鍏?/p>
100
鏃舵樉绀?/p>
锛?/p>
锛?/p>
銆?/p>
A)100.00
B)10000
C)1
D)100
5.
缁欏伐浣滆〃璁剧疆鑳屾櫙锛屽彲浠ラ�氳繃涓嬪垪鍝釜閫夐」鍗″畬鎴愩�?/p>
(
)
A) 鈥?/p>
寮�濮?/p>
鈥?/p>
閫夐」鍗?/p>
B) 鈥?/p>
瑙嗗浘
鈥?/p>
閫夐」鍗?/p>
C) 鈥?/p>
椤甸潰甯冨眬
鈥?/p>
閫夐」鍗?/p>
D) 鈥?/p>
鎻掑叆
鈥?/p>
閫夐」
6.
浠ヤ笅鍏充簬
Excel 2010
鐨勭缉鏀炬瘮渚嬶紝璇存硶姝ｇ‘鐨勬槸
(
)
銆?/p>
A)
鏈�灏忓�?/p>
10%
锛屾渶澶у�?/p>
500%
B)
鏈�灏忓�?/p>
5%
锛屾渶澶у�?/p>
500%
C)
鏈�灏忓�?/p>
10%
锛屾渶澶у�?/p>
400%
D)
鏈�灏忓�?/p>
5%
锛屾渶澶у�?/p>
400%
7.
宸茬煡鍗曞厓鏍?/p>
A1
涓瓨鏈夋暟鍊?/p>
563.68
锛岃嫢杈撳叆鍑芥暟
=INT(A1)
锛屽垯璇ュ嚱鏁板�间负
(
)
銆?/p>
A)563.7
B)563.78
C)563
D)563.8