问题 问答题

用Excel按下列要求建立数据表格和图表,具体要求如下:
(1) 新建工作簿文件EX06.XLS,将下列某市学生的大学升学和分配情况数据建成一个数据表(存放在“A1:D6”的区域内),并求出“考取/分配回市比率”(保留小数点后两位),其计算公式是:考取/分配回市比率=分配回市人数/考取人数。数据表保存在Sheet1工作表中。

时间 考取人数 分配回市人数 考取/分配叫市比率
2003 456 195
2004 423 211
2008 550 244
2006 536 260
2007 608 330
(2) 选“时间”和“考取/分配回市比率”两列数据,创建“折线散点图”图表。图表标题为“回市散点图”,设置分类(X)轴为“时间”,数值(Y)轴为“考取/分配回市比率”,嵌入在工作表的“A6:E19”的区域内。将Sheet1更名为“回市比率表”。

答案

参考答案:①在考生文件夹下新建EX06.XLS工作簿文件。
②打开新建工作簿文件,在工作表Sheet1中输入表格内容。
③选择D2单元格,在编辑栏中输入“=C2/B2”,单击编辑栏的

(输入)按钮;执行“格式”→“单元格”命令,弹出“单元格格式”对话框。在“数字”选项卡中,“分类”选择“百分比”,“小数位数”输入“2”,单击“确定”按钮;单击D2单元格,将鼠标指针指向该单元格右下角的填充句柄,使其形状由空心的十字形变为黑色的十字形,按住鼠标左键,拖动单元格填充句柄到D6单元格。
④选择工作表的“A1:A6”单元格,按住<Ctrl>键,再选择“D1:D6”单元格,单击“常用”工具栏中的

(图表向导)按钮,弹出“图表向导-4步骤之1-图表类型”对话框。在“标准类型”选项卡中,“图表类型”选择“XY散点图”,“子图表类型”选择“折线散点图”,单击“下一步”按钮,弹出“图表向导-4步骤之2-图表源数据”对话框。接受默认设置,并单击“下一步”按钮,弹出“图表向导-4步骤之3-图表选项”对话框。在“标题”选项卡的“图表标题”文本框中输入“回市散点图”,在“分类(X)轴”文本框中输入“时间”,在“数值(Y)轴”文本框中输入“考取/分配回市比率”,单击“下一步”按钮,弹出“图表向导-4步骤之4-图表位置”对话框。点选“作为其中的对象插入”单选钮,单击“完成”按钮,即可在工作表中插入图表。利用鼠标调整图表大小到“A6:E19”单元格区域内。
⑤双击工作表Sheet1文件名,输入新的工作表名“回市比率表”。
⑥设置完成后,单击“常用”工具栏中的

(保存)按钮。

单项选择题 A1/A2型题
完形填空
Our tolerating ability is indeed beyond our imagination. But not until the very critical moment will we realize our    tolerating ability.
There was a woman in the countryside who had to     with her children wherever she could at the age of 26 due to the Japanese army’s    . Many people could not bear the     and wanted to commit suicide. After she knew about it, she would come to those people and      them by saying, “Don’t do that silly thing. There are no such setbacks that we could not overcome. The Japanese armies are sure to be     one day!”
Finally she insisted until the day when all the Japanese armies were kicked out of China. However, her son died of disease without     medicine and nutrition in those days of hardships. Her husband lay in bed for two days without eating and drinking    . She teared to her husband and said, “We have a tough    , but however tough our lives will be, we should never    . Though our son has passed away, we can have another. There are no such setbacks that we could not overcome.”
After giving birth to the second son, her husband died of edema(水肿), which    blew her away. But eventually, she     and hugged the three young children, saying, “My sweet hearts, don’t feel scared. You still have me, your dear mum!”
It took her painstaking efforts to raise her children up and the life of her family was getting    . She was aging     and could not do the farm work any more.     she stayed at home and did some housework. Nevertheless, the Heaven     to show no affection to her who had undergone a rough life. She lived until 86. Before she went to Heaven, she said to her children, “You all should live     your best. There are no such setbacks that we could not overcome!”
We will     get to realize our own iron will and strong tolerating     after getting stricken heavily. Therefore, no matter what you are suffering from now, do not merely complain about the     of our destiny.
小题1:
A.potentialB.partialC.beneficialD.influential
小题2:
A.fightB.liveC.escapeD.hide
小题3:
A.arrivalB.attackC.activityD.invasion
小题4:
A.troubleB.sorrowC.starvationD.suffering
小题5:
A.persuadedB.informedC.comfortedD.warned
小题6:
A.killedB.defeatedC.punishedD.blamed
小题7:
A.sufficientB.effectiveC.satisfactory D.proper
小题8:
A.nothingB.everythingC.anythingD.something
小题9:
A.destinyB.environmentC.periodD.future
小题10:
A.break awayB.break downC.give awayD.give up
小题11:
A.immediatelyB.exactlyC.almostD.slowly
小题12:
A.struggledB.curedC.weakenedD.recovered
小题13:
A.betterB.sadderC.worseD.richer
小题14:
A.eventuallyB.graduallyC.healthilyD.unluckily
小题15:
A.ButB.AndC.ThenD.So
小题16:
A.seemedB.happenedC.attemptedD.intended
小题17:
A.forB.toC.atD.with
小题18:
A.onlyB.neverC.evenD.still
小题19:
A.effortB.willC.desireD.ability
小题20:
A.arrangementB.unfairnessC.appointmentD.unhappiness