问题 问答题

请在“答题”菜单下选择“电子表格”菜单项,然后按照题目要求再打开相应的命令,完成下面的内容。具体要求如下: 考生文件夹中有名为EX35.XLS的EXCEL工作表如下:

按要求对此工作表完成如下操作并原名保存: (1) 打开工作簿文件EX35.XLS,将表中各字段名的字体设置为楷体、12号。 (2) 将工作表sheetI的Al:Cl单元格合并为一个单元格,内容居中。 (3) 计算“人数”列的“总计”项及“所占比例”列的内容(所占比例=人数/总计),将工作表命名为“员工年龄情况表”。 (4) 取“员工年龄情况表”的“年龄”列和“所占比例”列的单元格内容(不包括“总计”行),建立“分离型圆环图”,数据标志为“显示百分比”,标题为“员工年龄情况图”。 (5) 将“员工年龄情况图”插入到表的A9:C19单元格区域内。

答案

参考答案:

解析:测试点:字体设置1.单击“格式”→“单元格”命令,打开“单元格格式”对话框。2.在“字体”列表框中选择字体,在“字号”列表框中选择字号。测试点:合并单元格1.单击“格式”→“单元格”命令,打开“单元格格式”对话框。2.在“对齐”选项卡的“文本控制”区内选中“合并单元格”复选框。测试点:公式计算1.选择要输入的单元格。2.如果是简单的计算公式,可以通过手动来书写:如果公式比较复杂,可以单击“插入”→“函数”命令选择相应的函数。3.选择相应的计算区域。测试点:设置图表1.选定要操作的数据范围,单击“插入”→“图表”命令,或单击“常用”工具栏上的“图表向导”按钮,根据提示进行设置。2.在选择数据源的时候,要区分数据源的数据区和系列,从而可以使数据的选择更加精确。测试点:重命名工作表1.双击相应的工作表标签,使其反显。2.输入新名称覆盖原有名称。测试点:格式设置1.选定要操作的单元格。2.单击“格式”→“单元格”命令,打开“单元格格式”对话框。3.如果题面要求对格式进行操作,可以在“对齐”选项卡中选择:如果要求设置字体,可以在“字体”选项中进行设置。4.如果要设置行高或列宽,可以单击“格式”→“行”→“行高”或“格式”→“列”→“列宽”命令选项,在出现的对话框中进行相应的设置。5.用户还可以选择“格式”工具栏中相应的按钮进行设置。测试点:移动或复制公式 1.选定包含待移动或复制公式的单元格。2.指向选定区域的边框。3.如果要移动单元格,请把选定区域拖到粘贴区域左上角的单元格中。Excel替换粘贴区域中所有的现有数据。如果要复制单元格,请在拖动时按住Ctrl键。 4.还可以通过使用填充柄将公式复制到相邻的单元格中。如果要这杆做,请选定包含公式的单元格,再拖动填充柄,使之覆盖需要填充的区域。

阅读理解

      阅读理解。

      It is well known that the Japanese people's love of fish is almost as a bee's interest in honey. As fish

populations were decreasing, fishing companies were forced to fish further and further away from the shore.

Then they had a big challenge-how to keep the fish fresh for longer. So they decided to keep the fish

stored in freezers on the boats. But the public did not like frozen fish. So again the fishing companies had

a new bigger challenge. What they decided to do was to have fish tanks on their boats. After catching fishes,

they would put them in the tanks and keep them living there until they got back to shore. But in this protected

environment, lacking predators (掠食者), the fish stopped moving around. The Japanese public felt these

dull fish did not taste fresh, which had an unpleasant effect upon sales. Once again the fishing companies

had an even bigger challenge.

     Stop for a minute! Before we go any further, I would like to ask "What are your challenges? How do you

handle an unexpected challenge?" May I think it this way that you should try to attack your challenges?

Conquer them with a Swiss Army knife. Take the most proper and simple tool that you can adopt to deal

with your situation. 

     Now back to our story. How did the Japanese finally figure out the fresh fish problem?Sharks! You

might think the same. Sharks were caught and put into the tanks with other fishes. Don't sharks eat fish?

Well, they do eat a few fish, but they did also keep more fish active alert (警觉的). The fish stay fresh

because they are challenged.

     Now, try to keep yourself fresh by finding your own shark to offer yourself a challenge in your own

business and career.

1. The main reason for the fishing company to fish in the far sea is that _____.

A. the fish resource near the shore was decreasing

B. the fishes farther away from the sea tasted fresher

C. people would prefer eating fresh fishes to less fresh ones

D. it was getting harder and harder to keep fishes fresh

2. The relationship between fishes and sharks is similar to that between _____ in nature.

A. dogs and cats

B. monkeys and mosquitoes

C. wolves and antelopes

D. children and lions 

3. The underlined part of the last paragraph means " _____."

A. If you went fishing, you might do as the fishing companies did

B. Try to find a big shark and you will meet your challenge

C. To succeed in life, you should always be ready to meet challenges

D. Sharks are usually compared to the challenges in people's life

4. The purpose for the author to write the passage is to _____.

A. tell the readers "no pains, no gains"

B. tell the readers how the Japanese keep the fish fresh

C. suggest readers looking for challenges to make progress

D. advise readers to find something difficult to do

计算题