问题 问答题

请在“答题”菜单下选择“电子表格”命令,然后按照题目要求再打开相应的命令,完成下面的内容,具体要求如下:
注意:下面出现的所有文件都必须保存在考生文件夹下。


在考生文件夹下打开EXCEL.XLS文件,将Sheet1工作表的A1:C1单元格合并为一个单元格,内容水平居中;计算人数的“总计”和“所占比例”列的内容(百分比型,保留小数点后两位);选取“毕业去向”列(不包括“总计”行)和“所占比例”列的内容建立“三维饼图”(系列产生在“列”),图标题为“毕业去向统计图”,清除图例,同时“显示百分比和类别名称”;将图插入到表的A10:E24单元格区域内,将工作表命名为“毕业去向统计表”,保存EXCEL.XLS文件。

答案

参考答案:首先在“考试系统”中选择[答题→电子表格题→excel.xls]命令,将文档“excel.xls”打开。
(1)计算总计和所占比例
[步骤1] 选中工作表sheet1中的A1:C1单元格,单击工具栏上的[*],设置选中单元格合并,单元格中的文本水平居中对齐。
[步骤2] 选择B3:B8单元格,单击工具栏上的[*],将自动计算出选择单元格的总计值。
[步骤3] 将鼠标光标直接定位到C3单元格中,在“编辑栏”中输入“=B3/B8”,按[Enter]键即可计算出所占比例,并使用相同的方法依次计算出其他部分所占总量比例。
[步骤4] 选定C3:C11,选择[格式→单元格]命令,打开“单元格格式”对话框,在“数字”下“分类”中选择“百分比”,在“小数位数”中选择“2”,单击“确定”按钮完成操作。
(2)新建和编辑图表
[步骤1] 选取“毕业去向”列(不包括“总计”行)和“所占比例”列的内容,选择[插入→图表]命令,在弹出的“图表向导”对话框“标准类型”的“图表类型”中选择“饼图”,在“子图表类型”中选择“三维饼图”。
[步骤2] 单击“下一步”按钮,在弹出的对话框的“系列产生”中选中“列”单选按钮,单击“下一步”按钮,在弹出的“标题”对话框“图表标题”中输入文本“毕业去向统计图”,在“图例”中取消“显示图例”复选框的选中状态。
[步骤3] 单击“数据标志”选项卡,在弹出功能项的“数据标签包含”栏中选中“类别名称”和“百分比”复选框。
[步骤4] 单击“完成”按钮,图表将插入到表格中,拖动图表到A10:E24区域内,将鼠标光标移动到工作表下方的表名处,单击鼠标右键,在弹出的快捷菜单中选择“重命名”命令,直接输入表的新名称“毕业去向统计表”并保存表格。

单项选择题 A1型题
单项选择题

If you smoke, you’d better hurry. From July 1st pubs all over England will, by law, be no-smoking areas. So will restaurants, offices and even company cars, if more than one per-son uses them. England’s smokers are following a well-trodden path. The other three bits of the United Kingdom have already banned smoking in almost all enclosed public spaces, and there are anti-smoking laws of varying strictness over most of Western Europe. The smoker’ s journey from glamour through toleration to suspicion is finally reaching its end in pariah status.

But behind this public-health success story lies a darker tale. Poorer people are much more likely to smoke than richer ones—a change from the 1950s, when professionals and la-borers were equally keen. Today only 15% of men in the highest professional classes smoke, but 42% of unskilled workers do. Despite punitive taxation—20 cigarettes cost around £ 5.00 ($10.00), three-quarters of which is tax—55% of single mothers on benefits smoke. The figure for homeless men is even higher; for hard-drug users it is practically 100% . The message that smoking kills has been heard, it seems, but not by all.

Having defeated the big killers of the past—want, exposure, poor sanitation—governments all over the developed world are turning their attention to diseases that stem mostly from how individuals choose to live their lives. But the same deafness afflicts the same people when they are ply encouraged to give up other sorts of unhealthy behavior. The lower down they are on practically any pecking order—job prestige, income, education, background-the more likely people are to be fat and unfit, and to drink too much.

That tempts governments to shout ever louder in an attempt to get the public to listen and nowhere do they do so more aggressively than in Britain. One reason is that pecking orders matter more than in most other rich countries: income distribution is very unequal and the unemployed, disaffected, ill-educated rump is comparatively large. Another reason is the frustration of a government addicted to targets, which often aim not only to improve some-thing but to lessen inequality in the process. A third is that the National Health Service is free to patients, and paying for those who have arguably brought their ill-health on themselves grows alarmingly costly.

Britain’ s aggressiveness, however, may be pointless, even counter-productive. There is no reason to believe that those who ignore measured voices will listen to shouting. It irritates the majority who are already behaving responsibly, and it may also undermine all government pronouncements on health by convincing people that they have an ultra-cautious margin of error built in.

Such hectoring may also be missing the root cause of the problem. According to Mr. Marmot, who cites research on groups as diverse as baboons in captivity, British civil servants and Oscar nominees, the higher rates of ill health among those in more modest walks of life can be attributed to what he calls the "status syndrome". People in privileged positions think they are worth the effort of behaving healthily, and find the will-power to do so. The implication is that it is easier to improve a person’s health by weakening the connection between social position and health than by targeting behavior directly. Some public-health experts speak of social cohesion, support for families and better education for all. These are bigger undertakings than a bossy campaign; but more effective, and quieter.

According to the text, why does the same deafness afflict the same people()

A. Because governments all turned their attention to these people

B. Because these people are more likely to have unhealthy behaviors

C. Because these people suffer more from their poor income and education

D. Because governments always neglect the real needs of these people