问题 问答题

(1)打开工作簿文件EX5.xls,将工作表Sheet1的A1:C1单元格合并为一个单元格,内容居中,计算“数量”列的“总计”项及“所占比例”列的内容(所占比例—数量/总计,保留小数点后面两位),将工作表命名为“人力资源情况表”。某企业人力资源情况如下表所示:

人力资源情况表
人员类型 数最 所占比例
市场销售 78
研究开发 165
工程管理 76
售后服务 58
总计
(2)选取“人力资源情况表”的“人员类型”列和“所占比例”列的单元格内容(不包括“总计”行),建立“分离型饼图”,数据标志为“显示百分比”,标题为“人力资源情况图”,插入到表的A9:D19单元格区域内。

答案

参考答案:(1)本题主要考核单元格合并及内容居中操作,自动求和,手工输入公式并计算,设置单元格格式,工作表命名的操作。
①打开工作表。
②选中A1:C1单元格,单击工具条中的“合并及居中”按钮。
③选中B3:B6单元格,单击工具条中的“自动求和”按钮。
④选中C3单元格,在数据编辑区中输入“:B3/$B$7”并按回车键。
⑤选中单元格C3,拖曳填充句柄,使虚线包括单元格C4到C7,复制公式。
⑥选中单元格C3:C6右键单击,选择陕捷菜单中的“设置单元格格式”命令,打开“单元格格式”对话框,在“分类”列表中单击“数值”,“小数位数”设置为2,单击“确定”按钮。
⑦双击工作表标签Sheet 1,输入“人力资源情况表”并按回车键。
(2)本题主要考核插入图表操作。操作步骤如下:
①按住Ctrl键,选中A2:A6和C2:C6单元格区域。
②单击工具条中的“图表向导”按钮,打开图表向导对话框。在步骤1对话框中打开“标准类型”选项卡,在“图表类型”列表中单击“饼图”,“子图表类型”列表中单击“分离型饼图”。选择完毕后单击“下一步”按钮。
⑨在步骤2对话框中,“系列产生在”中单击“列”,单击“下一步”按钮。
④在步骤3对话框中,打开“标题”选项卡,在“图表标题”中输入“季度销售数量情况图”,随后再打开“数据标志”选项卡,在“数据标志”选项组中单击“显示百分比”。设置完成后,单击“下一步”按钮。
⑤在步骤4对话框中,在“作为其中的对象插入”单击“人力资源情况表”,确定图表插入位置,单击“完成”按钮。
⑥调整大小并拖动图表到指定位置。
最后单击工具条的“保存”按钮(或按Ctrl+S键)保存文件。

阅读理解

The orderly came back in a few minutes with a rifle(步枪)and some Burmans. He told us that the elephant was in the rice fields below, only a few hundred yards away. As I started forward practically the whole population of the quarter flocked out of the houses and followed me. They had seen the rifle and were all shouting that I was going to shoot the elephant. It was fun to them, as it would be to an English crowd; besides, they wanted the meat. It made me a little uneasy. I had no intention of shooting the elephant—I had merely sent for the rifle to defend myself—and it is always uneasy to have a crowd following you. I marched down the hill, looking and feeling a fool, with the rifle over my shoulder and an ever-growing army of people knocking and pushing at my heels. Beyond the huts there was a rice field a thousand yards across, muddy from the first rains. The elephant was standing eight yards from the road. He took not the slightest notice of the crowd. He was tearing up bunches of grass, beating them against his knees to clean them and feeding them into his mouth.

As soon as I saw the elephant I knew with perfect certainty that I ought not to shoot him. It is a serious matter to shoot a working elephant — it is comparable to destroying a huge and costly piece of machinery. There, peacefully eating, the elephant looked no more dangerous than a cow. I thought then and I think now that his attack of “must” was already passing off, in which case he would merely wander harmlessly about. Moreover, I did not in the least want to shoot him.

But at that moment I glanced round at the crowd that had followed me. It was an immense crowd, two thousand at the least and growing every minute. I looked at the sea of the faces above the colorful clothes—faces all happy and excited over this bit of fun, all certain that the elephant was going to be shot. They were watching me as they would watch a magician about to perform a trick. They did not like me. But with the magical rifle in my hands I was momentarily worth watching. And suddenly I realized that I should have to shoot the elephant after all. The people expected it of me and I had got to do it; I could feel their two thousand wills pressing me forward. And it was at this moment that I first felt the hollowness, the uselessness of the white man's control in the East. Here was I, standing in front of the unarmed crowd—seemingly the leading actor; but in reality only a puppet (傀儡). I understood in this moment that when the white man turns ruler of complete power it is his own freedom that he destroys.

小题1:The people were glad to think the elephant was to be shot mainly because ______.

A.it had damaged their homes and crops

B.it would provide them with meat

C.it would make them feel entertained

D.it was spoiling their rice fields小题2:When the writer saw the elephant he felt       .

A.foolish

B.afraid

C.pitiful

D.confident小题3:The writer realized that he had to shoot the elephant because        .

A.shooting elephants is a serious problem

B.everybody expected it of him

C.he did not wish to disappoint the rulers

D.he had to show how guns are fired小题4:What does the writer intend to tells us when he tells the story?

A.Leading actors are sometimes foolish puppets.

B.Government for white people are useless.

C.Power can sometimes turn people imprisoned.

D.Unarmed crowds are in control of everything.

单项选择题