问题 问答题

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

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

答案

参考答案:①在考生文件夹下新建EX06.XLS工作簿文件。
②打开新建工作簿文件,在工作表sheetl中输入表格内容。
③选定D2单元格,在编辑栏中输入“=C2/B2”,单击编辑栏的“输入”按钮;执行“格式”→“单元格”命令,弹出“单元格格式”对话框。在“数字”选项卡中,“分类”选择“百分比”,“小数位数”输入“2”,单击“确定”按钮:单击D2单元格,将鼠标指针指向该单元格右下角的填充柄,使其形状由空心的十字形变为黑色的十字形,按住鼠标左键,拖动单元格填充柄到D6单元格。
④选定工作表的A1:A6单元格,按住<Ctrl>键,再选定D1:D6单元格,单击“常用”工具栏的“图表向导”按钮,弹出“图表向导-4步骤之1-图表类型”对话框。在“标准类型”选项卡中,“图表类型”选择“XY散点图”,“子图表类型”选择“折线散点图”,单击“下一步”按钮,弹出“图表向导-4步骤之2-图表源数据”对话框。保持默认设置,并单击“下一步”按钮,弹出“图表向导—4步骤之3-图表选项”对话框。在“标题”选项卡的“图表标题”文本框中输入“回市散点图”,在“分类(X)轴”文本框中输入“时间”,在“数值(Y)轴”文本框中输入“考取/分配回市比率”,单击“下一步”按钮,弹出“图表向导-4步骤之 4-图表位置”对话框。点选“作为其中的对象插入”单选钮,单击“完成”按钮,即可在工作表中插入图表。利用鼠标调整图表大小到A6:E19单元格区域内。
⑤双击工作表sheetl文件名,输入新的工作表名“回市比率表”。
⑥设置完成后,单击“常用”工具栏的“保存”按钮。

计算题
阅读理解

When women sit together to watch a movie on TV, they usually talk simultaneously(同时的)about a variety of subjects, including children, men, careers and what' s happening in their lives. When groups of men and women watch a movie together, the men usually end up telling the women to shut up. Men can either talk or watch the screen -- they can' t do both -- and they don' t understand that women can. Besides, women consider that the point of all getting together is to have a good time and develop relationships -- not just to sit there like couch potatoes staring at the screen.

During the ad breaks, a man often asks a woman to explain the plot and tell him where the relationship between the characters is going. He is unable, unlike women, to read the subtle body language signals that reveal how the characters are feeling emotionally. Since women originally spent their days with the other women and children in the group,  they developed the ability to communicate successfully in order to maintain relationships. For a woman, speech continues to have such a clear purpose: to build relationships and make friends. For men, to talk is to relate the facts.

Men see the telephone as a communication tool for sending facts and information to other people, but a woman sees it as a means of bonding. A woman can spend two weeks on vacation with her girlfriend and, when she returns home, telephone the same girlfriend and talk for another two hours.

There is no convincing evidence that social conditioning, the fact that girls' mothers talked them more, is the reason why girls talk more than boys. Psychiatrist Dr Michael Lewis, author Social Behaviour and Language Acquisition, conducted experiments that found mothers talked  to and looked at, baby girls more often than baby boys. Scientific evidence shows parents res the brain bias of their children. Since a girl' s brain is better organized to send and receive speech ,

we therefore talk to them more. Consequently, mothers who try to talk to their sons are usually pointed to receive only short grunts in reply.

56.While watching TV with others, women Usually talk a lot because they

A. are afraid of awkward silence with their families and friends

B. can both talk and watch the screen at the Same time

C. think they can have a good time and develop relationships

D. have to explain the plot and body language to their husbands

57. After a vacation with her girlfriend, a woman would talk to her again on the phone for hours in order to              .

A. experience the happy time again    B. keep a close tie with her

C. recommend her a new scenic spot   D. remind her of something forgotten

58. What does the author want to tell us most?

A. Women' s brains are better organized for language and communication

B. Women love to talk because they are more sociable than men.

C. Men do not like talking because they rely more on facts.

D. Social conditioning is not the reason why women love talking.

59. Which of the following would be the best title for the passage?

A. Women Are Socially Trained to Talk          B. Talking Maintains Relationships

C, Women Love to Talk                     D. Men Talk Differently from Women