问题 问答题

打开丁作簿文件EX02.XLS(内容如下),将工作表Sheet1的A1:DI单元格合并为一个单元格,内容居中;计算“销售额”列(销售额=销售数量×单价),将工作表命名为“图书销售情况表”。

(2)打开工作簿文件EX03.XLS(内容如下),对工作表“计算机动画技术成绩单”内的数据清单的内容按主要关键字为“考试成绩”的递减次序和次要关键字为“学号”的递增次序进行排序,排序后的工作表还保存在EX03.XLS工作簿文件中,工作表名不变。

答案

参考答案:

解析:本题考核如何合并单元格及内容居中,输入公式进行计算以及修改工作表的名称。操作步骤如下。 ①打开工作表。 ②拖动选中A1:D1单元格。 ⑧单击工具栏中的“合并及居中”按钮(图片)。结果如图2-25。 ④选中D3单元格,输入“=B3*C3”并按回车键。结果如图2—26。

图2-25 合并居中单元格

图2-26 销售额公式 ⑤选中单元格D3,拖曳填充句柄,使虚线包括单元格D4、D5,复制公式。结果如图2-27。 ⑥双击下作表标签Sheetl,输入“图书销售情况表”并按回车键。参见图2-28。 ⑦单击工具栏的“保存”按钮(或按Ctrl+S键)保存文件。

图2-27 复制公式

图2-28 工作表命名 (2)本题考核如何刘数据根据主要关键字以及次要关键字进行排序。操作步骤如下。 ①打开工作表。 ②选中A2:D5数据区,选择“数据”菜单中的“排序”命令,打开“排序”对话框。 ⑧将“主要关键字”设置为“考试成绩”,单击“递减”单选按钮,“次要关键字”设置为“学号”,单击“递增”单选按钮,参见图2-29,然后单市“确定”按钮。排序结果如图2-30。

图2-29 “排序”对话框

图2-30 排序结果 ④单击工具栏的“保存”按钮(或按Ctrl+S键)保存文件。

阅读理解

At times we all get angry when we are driving. It might be because we are stuck in a traffic jam or stuck behind a very slow driver. It might be because we think another driver has done something very stupid and dangerous. Whatever the reason, it seems that getting angry in a car is something which happens more and more often and there is now a special term for it “road rage”. Some experts even think that road rage is a kind of mental illness! How can we recognize this “illness” of road rage?

There are two kinds of road rage: aggressive driving and aggressive reactions to the way other people are driving. Aggressive driving can take different forms:

●Driving much faster than the speed limit.

●Increasing your speed very quickly.

●Driving very close behind the car in front and sounding the horn or flashing the headlights.

●Changing lanes very suddenly and blocking another car.

●Moving into a parking space where another car is trying to park.

There are also different reactions to the way other people are driving. These include:

●Making rude signs at people.

●Shouting at people and threatening them.

●Deliberately driving into another person’s car.

●Hitting somebody.

●Using a weapon such as a baseball bat, or even a gun or a knife.

Road rage is certainly not a joke. There have been incidents of road rage which have led to serious injuries and even murder.

Experts think that one reason for road rage is that films show a lot of examples of fast and aggressive driving such as car chases where this kind of driving seems to be positive.

Experts also think that the punishments for dangerous driving are not serious enough.

Experience shows that driving problems can be controlled, but it takes a long time. In the UK in the last 30 years, the police have been quite successful in reducing the number of people who drink and drive. They are now working to stop people using mobile phones when they are driving. Let’s hope they can have the same success with the road rage.

小题1:Which of the following statements does NOT describe aggressive     driving?

A.Driving much faster than the speed limit.

B.Drinking and driving

C.Moving into a parking space where another car is trying to park.

D.Changing lanes very suddenly and blocking another car.小题2:Road rage happens possibly because______.

A.the drivers are drunk

B.it won’t cause serious injuries or death

C.we’re in a fast-changing society

D.the punishments are not serious enough小题3:What’s the tone(语气)of the last paragraph?

A.Sad

B.Cold

C. Optimistic

D.Exciting

单项选择题