问题 问答题

考生文件夹中有Excel工作表如下:

按下列要求完成对工作簿的操作:

1.打开考生文件夹中的工作簿文档Gzb7.xls,调整工作表的各列列宽到“最适合的列宽”。

2.在年份为2007的记录之后插入一条新记录:

2008 25890 19121 23128 40123

3.在表格前插入一行,并输入表格标题“AUDI汽车专卖市场各类汽车销量统计表(辆)”,字体设置成黑体、18磅、加粗,将单元格区域A1:F1合并,使标题居中对齐。

4.根据公式“D类汽车所占比例—D类汽车/(A类汽车+B类汽车+C类汽车+D类汽车)”计算D类汽车所占比率的值,显示格式为:百分比、保留小数1位。计算各类汽车的“年平均销售量”,无小数位。

5.绘制各类汽车的年平均销售量的“三维饼图”,要求显示百分比,图表标题为“AUDI各类汽车的年平均销售量”。插入到工作表的A10:F25区域中。

答案

参考答案:

1.打开考生文件夹中的工作簿文件Gzb7.xls。选定A、B、C、D、E和F6列,选择“格式”→“列”→“最适合的列宽”命令,将表格各列调整到最适合的列宽。

2.选定单元格B6,输入25890。按“Tab”键,使C6成为当前单元格,再输入下一个数据。反复操作,直到全部数据输完为止。

3.选定第1行,选择“插入”→“行”命令,在第1行前插入一个空行。再选定单元格A1,输入“AUDI汽车专卖市场各类汽车销量统计表(辆)”。选定区域A1:F1。单击工具栏中的“合并及居中”按钮圆,合并单元格并使标题居中对齐。在“格式”工具栏中设置标题字体为黑体、加粗、18磅。

4.选定单元格F3,输入公式“=E3/SUM(B3:E3)”。单击F3选定单元格,拖动单元格“填充句柄”,将公式复制到单元格F4、F5、F6和F7中,计算出各年份D类汽车的比例。选择“格式”→“单元格”命令,弹出“单元格格式”对话框,在“数字”选项卡中,选择“百分比”和小数1位,单击“确定”按钮。选定单元格B8,输入公式“=AVERAGE (B3:B7)”。单击B8单元格以选定它,拖动单元格“填充句柄”,将公式复制到单元格C8、D8和E8中,计算年平均销售量。选择“格式”→“单元格”命令,弹出“单元格格式”对话框,在“数字”选项卡中,选择“数值”和小数0位,单击“确定”按钮。

5.选定区域B2:E2,按住[Ctrl]键,再选定区域B8:E8。单击“常用”工具栏中的“图表向导”按钮

,选择“三维饼图”;设置系列产生于行,作为其中的对象插入Sheet1等属性,最后单击“完成”按钮。

解析:

本题主要考查接收邮件和转发邮件。

单项选择题
阅读理解

When something goes wrong, it can be very satisfying to say, "Well, it’s so-and-so’s fault. "or "I know I’m late, but it’s not my fault; the car broke down. " It is probably not your fault, but once you form the habit of blaming somebody or something else for a bad situation, you are a loser. You have no power and could do nothing that helps change the situation. However, you can have great power over what happens to you if you stop focusing on whom to blame and start focusing on how to remedy the situation. This is the winner’s key to success.

Winners are great at overcoming problems. For example, if you were late because your car broke down, maybe you need to have your car examined more regularly. Or, you might start to carry along with you the useful phone numbers, so you could call for help when in need. For another example, if your colleague causes you problems on the job for lack of responsibility or ability, find ways of dealing with his irresponsibility or inability rather than simply blame the person. Ask to work with a different person, or don’t rely on this person. You should accept that the person is not reliable and find creative ways to work successfully regardless of how your colleague fails to do his job well.

This is what being a winner is all about — creatively using your skills and talents so that you are successful no matter what happens. Winners don’t have fewer problems in their lives; they have just as many difficult situation to face as anybody else. They are just better at seeing those problems as challenges and opportunities to develop their own talents. So, stop focusing on "whose fault it is. " Once you are confident about your power over bad situations, problems are just stepping stones for success.

小题1:According to the passage, winners    .

A.deal with problems rather than blame others

B.meet with fewer difficulties in their lives

C.have responsible and able colleagues

D.blame others rather than themselves小题2:The underlined word remedy in Paragraph 1 is closest in meaning to         .

A.avoid

B.accept

C.improve

D.consider小题3:When your colleague brings about a problem, you should     .

A.find a better way to handle the problem

B.blame him for his lack of responsibility

C.tell him to find the cause of the problem

D.ask another person for help小题4:Which of the following is the best title for the passage?

A.Winner’s Secret.

B.A Winner’s Problem.

C.A Winner’s Opportunity.

D.A Winner’s Achievement.