1、excel練習題及答案文化根底練習題Excel2000I. Excel文件的擴展名是().(A) doc (B)xls (C) exe (D)ppt 2. Excel 是一種()軟件.(A) 郵件治理(B)數據庫(C)文字處(D)電子表格3. Excel菜單欄包括()個菜 單項.(A) 7 (B)8 (C)9 (D)104. Excel菜單項中帶下畫線的字母與()鍵合用可選取該菜單.(A)Shift(B) Ctrl (C)Alt (D)F1 5. Excel I作表編輯欄中的名字框顯示的是().(A)活動 單元格的地址名字(B)活動單元格的內容(C)單元格的地址名字(D)單元格的內容6. Ex

2、cel工作表編輯欄包括().(A) 名稱框(B)公式欄(C)狀態欄(D)名稱框和編輯框7.當鼠標通過Excel工 作表的工作區時,鼠標指針為().(A)空心“ + 字形(B) “I形(C) 箭頭形(D)手形8. 當鼠標通過Excel工作表的菜單欄時,鼠標指針為().(A)空心“ + 字形(B) T 形(C) 箭頭形(D)手形9. Excel _E作表的編輯欄中的編輯框用來編輯().(A)活動單元格中的數據和 公式(B)單元格中的數據和公式(C)單元格的地址(D)單元格的名字10. Excel工作表的根本單位是().(A) 單元格區域(B)單元格(C)工作表(D)工作簿II. Excel工作表的

3、行和列名稱有()標識方法.A種B兩種C三種D四種12. 地址R7C6表示的是單元格.use it as a basis for project acceptance and handover project completion final accounts, if the employer, the design proposed engineering changes, resulting in rework, downtime, material waste, and so on, we give economic visa units out into the field, econo

4、mic damage check. Signature recognition, Visa records in the hands of the economy and budget staff, as a basis for project completion final accounts of the original information. Engineering change documents are important components of technical documentation management, engineering and technical man

5、agement and even an important part of the overall project management. Nineth section, and engineering meeting system assigned project head participate in owners and total contracting people recruiting of engineering meeting, understand engineering command on engineering specific progress, and requir

6、ements, situation, coordination solution engineering implementation process in the appeared of problem, coordination I company and the construction units Zhijian of construction progress, informed I company in implementation process in the appeared of technology problem, and quality problem and solu

7、tion and the rectification of method, and means and completed of date. Formation meeting and at each meeting record-keeping system reporting to the company in a timely manner and through the construction of grass-roots teams. Tenth section, and construction technology low-down we by technology chief

8、 engineer is responsible for implementation related sector and the personnel, technology low-down work of purpose has two aspects： a is to clear by bear construction task of(A) G7 (B)F7 (C)G6 (D)F6 13.在選中的Excel主菜單的下拉菜單名命令中, 帶下畫線的字母與()功能鍵合用可選取該菜單命令.(A) Alt (B)Ctrl (C) Shift (D)Del 14.在Excel菜單中,如果命令選項

9、后面有 三角符號,表示選擇這個命令時將().(A) 有子菜單(B)有快捷菜單(C)有對話框(D)什么也沒有15. Excel工具按鈕().(A) 只有利用鼠標才能使用(B)利用鼠標和快捷鍵都能使用(C)只有利用快捷 鍵能使用(D)任何時候都有效16. Excel工作表行號和列標交叉處全選按鈕的作用是().(A)沒作用(B)選中 行號(C)選中列標(D)選中整個工作表17. 在Excel中,凍結窗口的條件是().(A) 新建窗口(B)翻開多個窗口(C)分割窗口(D)沒有條件18. 在Excel菜單中,如果命令選項后面有“,符號,表示選擇這個命令時將 ()出現.(A)有子菜單(B)有快捷菜單(C)

10、有對話框(D)什么也沒有19. Excel編輯欄中的“X表示().(A) 公式欄中的編輯有效,且接收(B) 公式欄中的編輯無效,不接收(C) 不允許接收數學公式(D) 無意義20. Excel編輯欄中的表示().(A) 公式欄中的編輯有效,且接收(B) 公式欄中的編輯無效,不接收(C) 不允許接收數學公式(D) 允許接收數學公式21. 在Excel中,執行自動篩選操作的條件是().(A)在數據清單的第一行必須有列標記,否那么篩選結果不正確use it as a basis for project acceptance and handover project completion final

11、accounts, if the employer, the design proposed engineering changes, resulting in rework, downtime, material waste, and so on, we give economic visa units out into the field, economic damage check. Signature recognition, Visa records in the hands of the economy and budget staff, as a basis for projec

12、t completion final accounts of the original information. Engineering change documents are important components of technical documentation management, engineering and technical management and even an important part of the overall project management. Nineth section, and engineering meeting system assi

13、gned project head participate in owners and total contracting people recruiting of engineering meeting, understand engineering command on engineering specific progress, and requirements, situation, coordination solution engineering implementation process in the appeared of problem, coordination I co

14、mpany and the construction units Zhijian of construction progress, informed I company in implementation process in the appeared of technology problem, and quality problem and solution and the rectification of method, and means and completed of date. Formation meeting and at each meeting record-keepi

15、ng system reporting to the company in a timely manner and through the construction of grass-roots teams. Tenth section, and construction technology low-down we by technology chief engineer is responsible for implementation related sector and the personnel, technology low-down work of purpose has two

16、 aspects: a is to clear by bear construction task of(B) 單擊需要篩選的數據清單中任一單元格(C) 點擊任意單元格(D) 數據清單的第一列必須有行標記22. 在Excel中,說法正確的選項是().(A) 當需要利用復雜的條件篩選數據清單時,必須使用“高級篩選(B) 執行“高級篩選之前必須為之指定一個條件區域(C)篩選的條件可以自 定義(D) 執行篩選命令后,篩選結果和原數據清單一起顯示在屏幕上23.以下說法 正確的選項是().(A)Excel將圖表分為標準型和自定義型兩大類(B)圖表標題只能有一行(C) 在產生圖表時,使用者無法自行限制圖表

17、的大小(D)圖表向導的第一個對 話框是確定圖表的類型24.在Excel中,以下說法正確的選項是().(A) 更改圖表中信息必須用鼠標(B) 圖表中圖例只能位于圖的右側(C) 圖例可以顯示也可以不顯示(D) 除圖表向導中指定的內容外,不能增加任何內容25.在Excel中,使用打 印預覽命令().(A) 可以預先看到打印結果(B) 可以實現對文件的最后編輯(C) 可以檢查分頁、頁眉、頁腳及頁面設置情況(D)可以節省許多打印的校對 工作,提升打印效率26.在Excel中,以下說法正確的選項是().(A) 公式是由系統預先建立好的函數(B) 常用函數的種類并不會因使用者使用其他函數而改變(C)函數的參

18、數與參 數之間以逗號分開(D) 常用函數的種類會因使用者使用其他函數而改變27.在Excel中,()不是 函數 MIX(2, 5, FALSE)的執行結果.(A)2 (B)3 (C)-l (D)0 use it as a basis for project acceptance and handover project completion final accounts, if the employer, the design proposed engineering changes, resulting in rework, downtime, material waste, and so

19、on, we give economic visa units out into the field, economic damage check. Signature recognition, Visa records in the hands of the economy and budget staff, as a basis for project completion final accounts of the original information. Engineering change documents are important components of technica

20、l documentation management, engineering and technical management and even an important part of the overall project management. Nineth section, and engineering meeting system assigned project head participate in owners and total contracting people recruiting of engineering meeting, understand enginee

21、ring command on engineering specific progress, and requirements, situation, coordination solution engineering implementation process in the appeared of problem, coordination I company and the construction units Zhijian of construction progress, informed I company in implementation process in the app

22、eared of technology problem, and quality problem and solution and the rectification of method, and means and completed of date. Formation meeting and at each meeting record-keeping system reporting to the company in a timely manner and through the construction of grass-roots teams. Tenth section, an

23、d construction technology low-down we bytechnology chief engineer is responsible for implementation related sector and the personnel, technology low-down work of purpose has two aspects: a is to clear by bear construction task of28. 在Excel中,對NOW函數的正確說法是().(A)該函數要給出一個參數(B) 可利用該函數在單元格內輸入當前日期和時間t (C)該函

24、數返回系統日期(D) 該函數值是一個系列日期,時間值,包括一個整數(日期)和一個小數值(時間)29. 在Excel中,對SUM函數不正確的說法是().(A)只能對“列信息實現 求和(B) 可對所選矩形區域的所有內容求和(C) 可實現對由多個矩形域組成的單元格區域的所有數值數據求和(D)不能實 現對由多個矩形域組成的單元格區域求和30.在Excel中,對"A1:C3這個3行3 列矩形區域所有數據求和,正確的函數寫法是().(A)SUM(Al, A2, A3, Bl, B2, B3, Cl, C2, C3) (B)SUM(Al:C3)(C) SUM(Al:A3, C1:C3)(D) SU

25、M(Al:Cl, A3:C3)可以改變.31.在Excel中,表格邊框線的A粗細B顏色C線型D形狀32. Excel單元格可以接收數據.A文字B數值C圖表D公式33. 在Excel中,單元格數字格式的調整可通過進行.A菜單欄中的插入 菜單B菜單欄中的格式菜單C菜單欄中的工具菜單D數字格式工具按鈕34. 在Excel中,輸入不能得到負數.A"-10 B 10 C-10 D '-10'35. 在Excel中,單元格中的文本內容可以.A刪除B旋轉C縮進D 跨列居中36. 在Excel中,單元格不可以接收數據.A文字B圖形C圖表D 日期37. 在Excel中,頁眉和頁腳的內容

26、可以是.A文本B工作表C圖表D日期use it as a basis for project acceptance and handover project completion final accounts, if the employer, the design proposed engineering changes, resulting in rework, downtime, material waste, and so on, we give economic visa units out into the field, economic damage check. Signatu

27、re recognition, Visa records in the hands of the economy and budget staff, as a basis for project completion final accounts of the original information. Engineering change documents are important components of technical documentation management, engineering and technical management and even an impor

28、tant part of the overall project management. Nineth section, and engineering meeting system assigned project head participate in owners and total contracting people recruiting of engineering meeting, understand engineering command on engineering specific progress, and requirements, situation, coordi

29、nation solution engineering implementation process in the appeared of problem, coordination I company and the construction units Zhijian of construction progress, informed I company in implementation process in the appeared of technology problem, and quality problem and solution and the rectificatio

30、n of method, and means and completed of date. Formation meeting and at each meeting record-keeping system reporting to the company in a timely manner and through the construction of grass-roots teams. Tenth section, and construction technology low-down we by technology chief engineer is responsible

31、for implementation related sector and the personnel, technology low-down work of purpose has two aspects: a is to clear by bear construction task of38. 在Excel中,對排序問題以下說法正確的選項是().(A)如果只有一個排序關鍵字,可直接使用工具欄中的“升序或“降序按 鈕(B)可實現按列縱向排序(C) 可實現按行橫向排序(D) 只能對列排序,不能對行排序39. 在Excel中,點擊排序對話框中的“選項按鈕,在彈出的“排序選 項對話框中().(

32、A)選擇排序方向(B)選擇排序方法(C)指定關鍵字(D)指定有無標題40. Excel提供了()命令來篩選數據.A選擇B自動篩選C高級篩選D有效數據答案如下：I. B 2.D 3. C 4. C 5. A6.D 7. A 8. C 9. A 10. BII. B 12. B 13. A 14. A 15. A16. D 17. D 18. C 19. B 20. D21. AB 22. AC 23. AD 24. CD 25. ACD 26. CD 27. ABC 28. BD 29. ABD 30. ABCD 31. ABC 32. ABD 33. BD 34. AD 35. ABCD 36

33、. BC 37. ABC 38. AB 39. BC 40. ABCDuse it as a basis for project acceptance and handover project completion final accounts, if the employer, the design proposed engineering changes, resulting in rework, downtime, material waste, and so on, we give economic visa units out into the field, economic damage check. Signature recognition, Visa records in the hands of the economy and budget staff, as a basis for project completion final accounts of the original information. Engineering change documents are important components of technical do