问题 问答题

按下列要求用Excel建立数据表格和图表,具体要求如下:
(1)请将下列数据建成一个数据表(存放在A1:D5的区域内),并求出“上升案例数”(保留小数点后面两位),其计算公式是:上升案例数=去年案例数×上升比率,其数据表保存在sheet1工作表中。

地区 去年案例数 上升比率 上升案例数
A地区 1400 2.0%
B地区 2200 0.8%
C地区 5010 1.5%
D地区 2400 3.5%
(2)对建立的数据表选择“地区”、“上升案例数”两列数据建立分离型圆环图,图表标题为“地区案例上升情况图”,并将其嵌入到工作表的A8:D16区域中。将工作表sheet1更名为“案例调查表”。

答案

参考答案:①在考生文件夹下新建EX09.XLS工作簿文件。
②打开新建文档,输入表格内容。
③选中D2单元格,在编辑栏中输入“=B2*C2”,单击编辑栏的“输入”按钮;然后单击D2单元格,将鼠标指针指向该单元格右下角的填充柄,使其形状由空心的十字型变为黑色的十字型,按住鼠标左键,拖动单元格填充柄到D5单元格。
④选中图表的A2:A5单元格,按住<Ctrl>键,再选中D2:D5单元格,单击“常用”工具栏中的“图表向导”按钮,弹出“图表向导-4步骤之1-图表类型”对话框,在“标准类型”选项卡下,“图表类型”选中“圆环图”,“子图标类型”选中“分离型圆环图”,单击“下一步”按钮,弹出“图表向导-4步骤之2-图表数据源”对话框,保持默认设置,并单击“下一步”按钮,弹出“图表向导-4步骤之3-图表选项”对话框,在“标题”选项卡下,“田标标题”输入“地区案例上升情况图”,单击“下一步”按钮,弹出“图表向导-4步骤之4-图表位置”对话框,选择“作为其中的对象插入”,单击“完成”按钮,即可在工作表中插入图表,利用鼠标光标调整图表大小到A8:D16单元格区域内。
⑤双击工作表“sheet1”文件名,输入新的工作表名“案例调查表”。
⑥设置完成后,单击“常用”工具栏中的“保存”按钮。

多项选择题
单项选择题

It is said that in England death is pressing, in Canada inevitable and in California optional. Small wonder. Americans’ life expectancy has nearly doubled over the past century. Failing hips can be replaced, clinical depression controlled, cataracts removed in a 30-minute surgical procedure. Such advances offer the aging population a quality of life that was unimaginable when I entered medicine 50 years ago. But not even a great health-care system can cure death—and our failure to confront that reality now threatens this greatness of ours.

Death is normal; we are genetically programmed to disintegrate and perish, even under ideal conditions. We all understand that at some level, yet as medical consumers we treat death as a problem to be solved. Shielded by third-party payers from the cost of our care we demand everything that can possibly be done for us, even if it’s useless. The most obvious example is latestage cancer care. Physicians—frustrated by their inability to cure the disease and fearing loss of hope in the patient—too often offer aggressive treatment far beyond what is scientifically justified.

In 1950, the U. S. spent $12.7 billion on health care. In 2002, the cost will be $1,540 billion. Anyone can see this trend is unsustainable. Yet few seem willing to try to reverse it. Some scholars conclude that a government with finite resources should simply stop paying for medical care that sustains life beyond a certain age—say 83 or so. Former Colorado governor Richard Lamm has been quoted as saying that the old and infirm "have a duty to die and get out of the way" so that younger, healthier people can realize their potential.

I would not go that far. Energetic people now routinely work through their 60s and beyond, and remain dazzlingly productive. At 78 Viacom chairman Sumner Redstone jokingly claims to be 53. Supreme Court Justice Sandra Day O’Connor is in her 70s, and former surgeon general C. Everett Koop chairs an Internet start-up in his 80s. These leaders are living proof that prevention works and that we can manage the health problems that come naturally with age. As a mere 68-year-old, I wish to age as productively as they have.

Yet there are limits to what a society can spend in this pursuit. As a physician, I know the most costly and dramatic measures may be ineffective and painful. I also know that people in Japan and Sweden, countries that spend far less on medical care, have achieved longer, healthier lives than we have. As a nation we may be overfunding the quest for unlikely cures while underfunding research on humbler therapies that could improve people’s lives.

The author uses the example of cancer patients to show that ().

A. medical resources are often wasted

B. doctors are helpless against fatal diseases

C. some treatment are too aggressive

D. medical costs are becoming unaffordable