第十章练习

创建与编辑公式

1．插入一个公式时总是以一个_______作为开头，然后才是公式的表达式··································（）A．空格B．“=”C．“+”D．选择单元格

2．以下关于公式的说法正确的是·······················································································（）A．公式是对工作表中数据进行计算和分析的重要工具

B．公式一般由运算符，单元格标识，数据值，工作表函数等组成

C．A和B

D．以上说法都不对

3．%属于______运算符 ····································································································（）A．算术B．比较C．引用D．文本

4．下列不是Excel表达式的算术运算符的是 ·······································································（）A．% B．/ C．＜＞D．＾

5．在Excel2003提供的四类运算符中，“＆”属于································································（）A．算术运算符B．关系运算符C．文本运算符D．引用运算符

6．在Excel规定可以使用的运算符中，没有_________运算符·················································（）A．算术B．比较C．逻辑D．文本

7．在Excel中，将两个字符串连接起来的运算符是 ······························································（）A．$ B．+ C．& D．-

8．在Excel提供的4类运算符中，优先级最高的是 ······························································（）A．算术运算符B．比较运算符C．文本运算符D．引用运算符

9．在Excel中，“，”属于································································································（）A．算术运算符B．比较运算符C．文本运算符D．引用运算符

10．Excel工作表的单元格里输入的公式，运算符有优先顺序，下列说法不正确的是 ···················（）A．百分比优先乘方B．乘和除优先于加和减

C．文本运算符优先于比较运算符D．乘方优先于负号

11．下列有关运算符的叙述中，不正确的是 ·········································································（）A．算术运算符的优先级低于关系运算符

B．算术运算符的操作数与运算结果均为数值类型数据

C．关系运算符的操作数可能是字符串或数值类型数据

D．关系运算符的运算结果是TRUE或FALSE

12．在Excel中，如果要在B6单元格中建立公式，使B6等于B1乘以B3、B4、B5的和，则应在B6单元格中输入···························································································································（）A．B6=B1*（B3+B4+B5）B．=B1*（B3：B5）

C．=B1*（B3+B4+B5）D．B1*（B3+B4+B5）

13．已知工作表中C3单元格与D4单元格的值均为0，C4以单元格中为公式“=C3=D4”，则C4单元格显示的内容为···························································································································（）A．C3=D4 B．TRUE C．#N/A D．0

14．若在Excel的A2单元格中输入“=56>=57”，则显示结果为 ···············································（）A．56<57 B．=56<57 C．TRUE D．FALSE

15．在Excel工作表中，在某一个单元格内输入=6＆8作为公式，会产生结果 ····························（）A．会提示公式错误，产生结果“#NAME？”B．会产生一个宏代换结果

C．会产生一个字符串“68”D．会产生一个数值68

16．在Excel2003中，下面四种公式的使用，正确的是··························································（）A．=（100*23-66）：B6 B．=A3/100-B4

C．=SUM E5 D．=SQRT（A5！C7）

17．在Excel工作表单元格中输入公式=A3*100-B4，则该单元格的值 ·······································（）A．为单元格A3的值乘以100再减去单元格B4的值，该单元格的值不再变化

B．为单元格A3的值乘以100再减去单元格B4的值，该单元格的值将随着单元格A3和B4值的变化而变化C．为单元格A3的值乘以100再减去单元格B4的值，其中A3、A4分别代表某个变量的值

D．为空，因为该公式非法

18．以下公式中正确的是 ·································································································（）A．=“计算机”&“应用”B．=‘计算机’&‘应用’

C．=“计算机”&‘应用’D．=计算机&应用

19．在Excel工作表单元格中，输入下列表达式哪一项是错误的··············································（）A．=(15-A1)/3 B．=A2/C1 C．SUM(A2:A4)/2 D．=A2+A3+A4

20．在Excel中，选定某单元格后单击“复制”按钮，再选中目的单元格后单击“粘贴”按钮，此时被粘贴的是源单元格中的············································································································（）A．格式和公式B．数值和公式C．全部D．格式和批注

21．在Excel中，关于“选择性粘贴”的叙述，错误的是·······················································（）A．选择性粘贴可以只粘贴格式

B．选择性粘贴可以只粘贴公式

C．选择性粘贴可以源数据的排序旋转90度，即“转置”粘贴

D．选择性粘贴只能粘贴数值型数据

22．某个Excel工作表C列所有单元格的数据是利用B列相应单元格通过公式计算得到的，此时如果将该工作表B列删除，那么，删除B列对C列 ·················································································（）A．不产生影响B．产生影响，但C列中的数据正确无误

C．产生影响，C列中数据部分能用D．产生影响，C列中的数据失去意义

23．在Excel中，若一个单元格中显示的错误信息“#VALUE!”，表示该单元格的 ·······················（）A．公式引用了一个无效的单元格坐标

B．公式中的参数或操作数出现类型错误

C．公式结果产生溢出

D．公式中使用了无效的名字

24．创建复杂工作表最容易出错，当错误发生时，单元格会显示代码为你提供发生错误的原因，如显示“#NAME？”

表示························································································································（）A．表示Excel认为你正在使用一个不存在的名字

B．表示Excel认为你提供一个数字参数存在问题

C．表示一个单元格引用是错误的

D．表示提供的值不是公式参数所要求的类型

25．______________是进对单元格中数值进行计算的等式。

26．______________是Excel2003中预定的内置公式。

27．公式以_________开头，后面紧跟着___________________和___________________。

28．Excel的运算符有4类，分别是算术运算符、________________、________________和________________。29．将光标快速定位到活动单元格的快捷键是______________________。

30．Excel中显示的日期是以______________日期为起点的。