问题 问答题

在考生文件夹下打开EXCEL.XLS文件:(1)将sheet1工作表的A1:E1单元格合并为一个单元格,内容水平居中;计算“同比增长”列的内容[同比增长=(07年销售量-06年销售量)/06年销售量,百分比型,保留小数点后两位];如“同比增长”列内容高于或等于20%,在“备注”列内给出信息“较快”;否则内容“”(一个空格)(利用IF函数)。(2)选取“月份”列(A2:A4)和“同比增长”列(D2:D14)数据区域的内容建立“数据点折线图”(系列产生在“列”),标题为“销售同比增长统计图”。清除图例;将图插入到表A16:F30单元格区域内,将工作表命名为“销售情况统计表”,保存EXCEL.XLS文件。

答案

参考答案:

解析:拖动鼠标选中A1:E1单元格,单击工具栏上的合并及居中,选中E3单元格,在fx输入栏中输入“=(B3-C3)/C3”,单击对号,用鼠标按下D3单元格的右下角点,拖动到D14单元格,选中E3单元格,单击工具栏上的fx,选择IF,单击确定,上栏输入“D3>=20%”,中栏输入“较快”,下栏输入“”,用鼠标拖动E3单元格的右下角点,拖动到E14,选中A2:A4列和D2:D4列,单击工具栏上的生成图表,选择数据点折线图,输入标题为“销售同比增长统计图”。取消选中图例;拖动图表到A16:F30,调整大小,双击下面的Sheet1,输入“销售同比增长统计表”,保存文件。

选择题
阅读理解

阅读理解。

     Education is not an end, but a means to an end. In other words, we do not educate children only for the

purpose of educating them. Our purpose is to fit them for life.

     In some modern countries it has for some time been fashionable to think that hy free education for all-

whether rich or poor, clever or stupid-one can solve all the problems of society and build a perfect nation.

But we can already see that free education for all is not enough; we find in such countries a far larger

number of people with university degrees refuse to do what they think to be "low" work, and, in fact, work

with hands is thought to be dirty and shameful in such countries. But we have only to think a moment to

understand that the work of a completely uneducated farmer is far more important than that of a professor.

We can live without education, but we die if we have no food. If no one cleaned our streets and took the

rubbish away from our houses, we should get terrible diseases in our towns.

     In fact, when we say that all of us must be educated to fit us for life, it means that we must be educated

in such a way that, firstly, each of us can do whatever work suited to his brains and ability and, secondly,

that we can realize that all jobs are necessary to society, and that is very bad to be ashamed of one's work.

Only such a type of education can be considered valuable to society.

1. The writer of this passage thinks that _____. [ ]

A. education can settle all of the world's problems

B. free education for all probably leads to a perfect world

C. free education won't help to solve social problems

D. all the social problems can't be solved by education

2. The writer wants to prove that _____. [ ]

A. our society needs all kinds of jobs

B. our society needs free education for all

C. a farmer is more important than a professor

D. people with university degrees refuse to do what they think to be "low" work

3. According to the passage _____. [ ]

A. work with hands is dirty and shameful

B. work with hands is low work

C. work with hands is the most important

D. we can't regard work with hands as low work

4. The purpose of education is _____.[ ]

A. to choose a system of education

B. to prepare children mainly for their future work

C. to let everyone receive education fit for him

D. to build a perfect world

5. The passage tells us about _____. [ ]

A. system of education

B. means of education

C. value of education

D. type of education