问题 问答题

请建立如下的表格,计算D列的“总计”,其数据表保存在sheet 1工作表中。

ABCD
1某厂各车间1月份生产情况
2车间数量价格(元)总计
31412000
4259000
5368500
64126500
2.对建立的数据表选择“车间”和“总计”数据建立“三维簇状柱形图”,图表标题为“粮食产量图”,并将其嵌入到工作表的A9:F20区域中。将工作表sheet1更名为“1月份生产表”,保存到EX20.XLS。

答案

参考答案:

解析:第1小题 输入文字,在D3中键入公式“=B3*CY”,双击此单元格,向下拖动右下角的实心方块填充到其他需要产生结果的单元格。选中全表,使用[格式]|[单元格]| [字体]命令,设置字体的属性,在[对齐]选项卡中设置水平和垂直的对齐方式,使用[格式]|[单元格]|[对齐]命令,合并单元格,并输入“某厂各车间1月份生产情况”。 第2小题 选中“车间”和“总计”两列,单击工作栏上[图表向导]按钮,弹出[图表向导-4步骤之1-图表类型]对话框中进行[图表选择]。 单击下一步,在[图表向导-4步骤之2-图表源数据]对话框中选择[数据区域]。 单击下一步,在[图表向导-4步骤之3-图表选项]对话框中选择[图表标题]。 单击下一步,在[图表向导-4步骤之4-图表位置]对话框中选择[作为其中的对象插入]。

阅读理解

“Well, we’re in our new house. Let’s get a new pet to get along with it,” Mrs. Brown said to her husband.

“That sounds like a pretty good idea,” he answered. “Do you want to see the ads in the newspaper?”

“Let’s go to the animal shelter. Many pets there need homes. Since tomorrow is Saturday, we can both go,” she said.

The next morning the Browns met Mr. Snow at the animal shelter. “We want to be sure that the pets here go to good homes,” Mr. Snow said, “So I need to ask you some questions.”

After they talked for a while, the Browns decided to get a small dog. It wouldn’t need a big house or a big yard. A small dog would bark(吠) and warn them if someone tried to break into their house. After Mr. Snow gave the Browns a book on pet care, they chose one and wanted to take her home right away. But the animal doctor hadn’t checked her yet. So Mr. Snow told them to return on Sunday.

On Sunday afternoon the Browns went to the animal shelter again. The animal doctor said, “Shadow has had all of her shots(预防针). She will be healthy.” The Browns thanked the doctor and took Shadow home.

小题1:From the reading we learn that _______.

A.the Browns have never had a pet before.

B.the Browns knew about Shadow from the newspaper.

C.Shadow is a small and healthy dog.

D.Mr Brown didn’t quite agree with his wife.小题2:The word shelter in the reading means _______.

A.a place to sell small dogs

B.a place to keep homeless animals

C.a place to study animals

D.a place to sell books on pet care小题3:Mr Snow asked the Browns some questions to _______.

A.see if they had moved to a new house

B.find out how rich the Browns were

C.know where they’d keep their new pet

D.make sure they’d take care of pets小题4:The Browns thinks that a small dog _______.

A.doesn’t need any room to keep

B.can help them watch their house

C.eats less food than a bigger one

D.usually has a beautiful name小题5:It’s clear that _______.

A.Shadow will not be easy to get ill

B.the Browns were not satisfied with Shadow

C.Mr Snow didn’t check Shadow at all

D.Shadow likes barking a lot

单项选择题