问题 问答题

考生文件夹下文件KS.XLS工作簿中的工作表Sheet1的内容如下。
[文档开始]


[文档结束]
按要求对该工作表进行如下操作:
(1)在考生文件夹下打开KS.XLS文件,将Sheet1工作表的A1:D1单元格合并为一个单元格,水平对齐方式设置为居中;计算各种设备的销售额(销售额=单价×数量,单元格格式数字分类为货币,货币符号为¥,小数点位数为0);将工作表命名为“设备销售情况表”;
(2)取“设备销售情况表”的“设备名称”和“销售额”两列的内容(总计行除外)建立“柱形棱锥图”,X轴为设备名称,标题为“设备销售情况图”,不显示图例,网络线分类(X)轴和数值(Z)轴显示主要网格线,将图插入到工作表的A9:F22单元格区域内。

答案

参考答案:(1)操作步骤如下:
①打开KS.XLS工作簿中的Sheet1,将工作表Sheet1中A1:D1单元格选中,单击格式工具栏上的[合并及居中]按钮,将A1:D1单元格合并为一个单元格,并将内容居中。
②选中D3单元格,在“编辑”栏中输入“=PRODUCT(B3,C3)”,按[Enter]键,选中D3单元格,将光标置于D3单元格的右下角上,光标变成实心十字形,拖曳至D6单元格释放即可。
③选中“销售额”列中的任意一个单元格,在菜单工具栏中选择[格式]→[单元格]命令,在弹出的对话框中选择“货币”,将小数位数设为0,单击[确定]按钮。
④双击工作表标签“Sheet1”,输入“设备销售情况表”,按[Enter]键,保存文件。
(2)操作步骤如下:
①选中“设备销售情况表”列和“设备名称”列,选择[插入]→[图表]命令,弹出“图表向导”对话框。
②在“图表类型”中选择“棱锥图”,单击[下一步]按钮。在“系列产生在”中选择“列”单选按钮,单击[下一步]按钮。
③在“标题”选项卡中输入图表标题为“设备销售情况图”,在“图例”选项卡中设置不显示图例,在“网格线”选项卡中设置网络线分类(X)轴和数值(Z)轴显示主要网格线。
④单击[下一步]按钮。在“将图表”选项组中选择“作为其中的对象插入”单选按钮,单击[完成]按钮。
⑤选中生成的图表,光标移动到其边框上,通过拖动来发改变图表的位置,使其插入到表的A9:F22单元格区域内。

填空题

Part 4


Questions 26-45


·Read the following passage and decide which answer best fits each space.
·For questions 26-45, mark one letter A, B, C or D on the Answer Sheet.
Participation (26) high school sports is not a constitutional right. (27) , it is a privilege, paid for by taxpayers, open to students who promise to (28) certain conduct requirements on and off the field. One of these promises is to (29) from using drugs. Drug use is a serious problem among high school students. Studies show that as many as 500, 000 high school students use muscle-pumping, life-destroying substances such as steroids. Many more use illegal drugs, (30) cause discipline problems and (31) the stage for lifelong (32) .
Drug testing works to (33) and identify use. That is why drug testing is required to compete in the Olympics, the National Collegiate Athletic Association and the National Football League. (34) drug testing was instituted by these organizations, use of performance- (35) drugs has been greatly reduced. We should want (36) in schools.
Indeed, many athletes (37) testing programs, and no wonder. Without testing, athletes have to choose between drug use and a competitive disadvantage (38) the field.
Those who challenge the need for drug testing may be forgetting (39) it is like be an adolescent. Peer pressure is enormous, and one of the few effective counter-weights is the fear of being caught. More importantly, once drug use is (40) , a school can (41) to the student before he or she gets addicted or arrested.
For 25 years, public schools (42) by federal judges and civil libertarians, with results everyone can see. It is time (43) decisions on how to run public schools locally (44) officials. There is nothing unconstitutional about asking those who gain the advantages of school-sponsored athletics to contribute to the safety of other players, the integrity of the game and their own well-being. The Supreme Court should leave these programs (45) .

A.Since

B.After

C.When

D.While

单项选择题 A1/A2型题