excel练习题及答案

excel练习题及答案

[文化基础练习题]Excel2000

1.Excel文件的扩展名是()。

(A)doc (B)xls (C)exe (D)ppt 2.Excel是一种()软件。

(A)邮件管理 (B)数据库 (C)文字处 (D)电子表格 3.Excel菜单栏包括()个菜单项。

(A)7 (B)8 (C)9 (D)10

4.Excel菜单项中带下画线的字母与()键合用可选取该菜单。 (A)Shift

(B)Ctrl (C)Alt (D)F1 5.Excel工作表编辑栏中的名字框显示的是()。 (A)活动单元格的地址名字 (B)活动单元格的内容 (C)单元格的地址名字 (D)单元格的内容

6.Excel工作表编辑栏包括()。

(A)名称框 (B)公式栏 (C)状态栏 (D)名称框和编辑框 7.当鼠标通过Excel工作表的工作区时，鼠标指针为()。 (A)空心“+”字形(B)“I”形

(C)箭头形 (D)手形

8.当鼠标通过Excel工作表的菜单栏时，鼠标指针为()。 (A)空心“+”字形

(B)“I”形

(C)箭头形 (D)手形

9.Excel工作表的编辑栏中的编辑框用来编辑()。 (A)活动单元格中的数据和公式 (B)单元格中的数据和公式 (C)单元格的地址 (D)单元格的名字

10.Excel工作表的基本单位是()。

(A)单元格区域 (B)单元格

(C)工作表 (D)工作簿

11.Excel工作表的行和列名称有()标识方法。

(A)一种 (B)两种 (C)三种 (D)四种

12.地址R7C6表示的是()单元格。

safety catch. Any production safety accident will cause an

additional burden on the county should bear joint and several liability, not worth the candle. So enterprises should conscientiously assume the production safety of the main responsibility for the safety production and then catch production. All units and departments responsible for safety production responsibility, as the main party leaders must intervene. Third, dereliction of duty will pursue responsibility. Stable now out of the question to responsibility and accountability is very strict. As far as possible to check the production is the same, the

first few days of the mainland occurred in production safety accidents, the accident investigation results also did not come out, the county Party Secretary, county magistrate, deputy magistrate and deputy county magistrate all in situ removal, later also shall be investigated for criminal responsibility. This is the dereliction of duty shall be accountable, we must attach great importance to. The fourth, prevention first, safety in production in place. Safety in production to prevent the main, less trouble, not afterwards to solve. Prevention is the key to implement the safety production responsibility system and the safety measures. The danger of enterprises should take the initiative to pay close attention to the time to do procedures, there is no legal compliance procedures, once out of trouble and regret. Unannounced

visits to enterprises to actively take the initiative to seize the time

to formalities. In important holidays to increase publicity and education

(A)G7 (B)F7 (C)G6 (D)F6 13.在选中的Excel主菜单的下拉菜单名命令中，带下画线的字母与()功能键合用可选取该菜单命令。

(A)Alt (B)Ctrl (C)Shift (D)Del 14.在Excel菜单中，如果命令选项后面有三角符号，表示选择这个命令时将()。

(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)有对话框 (D)什么也没有

19.Excel编辑栏中的“×”表示()。

(A)公式栏中的编辑有效，且接收

(B)公式栏中的编辑无效，不接收