问题 问答题

在考生文件夹下打开文件EX05A.XLS(内容如下表),要求如下:
(1)将工作表Sheet1的A1:E1单元格合并为一个单元格,内容水平居中;计算“总成本”;计算“材料费”、“生产加工费”和“人员工资”列的最大值(利用MAX函数);将A2:E6单元格区域格式设置为自动套用格式“古典2”;将工作表命名为“项目开发费用使用情况表”。
(2)选取“项目编号”和“总成本”两列数据(不包括“最大值”行)建立“簇状柱形图”(系列产生在“列”),图标题为“项目开发费用使用情况图”,清除图例,设置系列的颜色为绿色,将图插入到表的A7:E18单元格区域内,保存EX05A.XLS文件。

某企业项目开发费用使用情况表(万元)
项目编号 材料费 生产加工费 人员工资 总成本
J0050 46.5 3.4 12.4
C3178 89.7 7.32 24.3
B0007 12.5 1.8 61.4
最大值

答案

参考答案:(1)本小题操作步骤如下:
①打开工作簿文件EX05A.XLS。
②选中A1:E1单元格区域,单击工具栏中的“合并及居中”按钮。
③选中E3单元格,单击工具栏中的“自动求和”按钮,默认求和区域为B3:D3,按Enter键。
④选中E3单元格,拖动填充句柄到单元格E5,复制公式。
⑤选中B6单元格,输入“=”,在数据编辑区左侧的函数下拉列表中选择函数MAX,弹出“函数参数”对话框,系统默认数据区域为B3:B5,点击“确定”按钮。
⑥选中B6单元格,拖动填充句柄到单元格D6,复制公式。
⑦选中A2:E6单元格区域,选择“格式”→“自动套用格式”命令,在“自动套用格式”对话框中选择“古典2”。
⑧双击工作表标签Sheet1,输入“项目开发费用使用情况表”,按.Enter键。
(2)本小题操作步骤如下:
①单击工具栏中的“图表向导”按钮,图表类型选择“簇状柱形图”,单击“下一步”按钮,在数据区域选择“项目编号”和“总成本”列(按Ctrl键同时选择),在“系列产生在”选择“列”,单击“下一步”按钮。在“标题”选项卡的“图表标题”文本框中输入“项目开发费用使用情况图”;在“图例”选项卡中,取消“显示图例”复选框的选择,单击“完成”按钮。
②调整图表大小,并将图表移动到A7:E18单元格区域内。
③双击系列,在“数据系列格式”对话框的“图案”选项卡中设置颜色为绿色。
④按Ctrl+S键。

阅读理解

“I’ve never met a human worth cloning,” says cloning expert Mark Westhusin from his lab at Texas A&M University. “It’s a stupid endeavor.”

That’s an interesting choice of adjective, coming from a man who has spent millions of dollars trying to clone a 13-year-old dog named Missy. So far, he and his team have not succeeded, though they have cloned two cows and a cat.

They just might succeed in cloning Missy soon — or perhaps not for another five years.

Westhusin's experience with cloning animals leaves him upset by all this talk of human cloning. In three years of work on the Missy project, using hundreds upon hundreds of dog's eggs, the A&M team has produced only a dozen or so embryos carrying Missy's DNA. None have survived the transfer to a surrogate(代孕的)mother. The wastage of eggs and the many spontaneously aborted(流产,发育不全) fetuses(胎)may be acceptable when you're dealing with cats or bulls, he argues, but not with humans. “Cloning is incredibly inefficient, and also dangerous,” he says.

Even so, dog cloning is a commercial opportunity, with a nice research payoff. Ever since Dolly the sheep was cloned in 1996, Westhusin's phone has been ringing with people calling in hopes of duplicating their cats and dogs, cattle and horses. “A lot of people want to clone pets, especially if the price is right,” says Westhusin. Cost is no obstacle for Missy's mysterious billionaire owner; he's put up $3.7 million so far to fund A&M's research.

Contrary to some media reports, Missy is not dead. The owner wants a twin to carry on Missy's fine qualities after she does die. The prototype(原型;雏形)is, by all accounts, athletic, good-natured and super-smart. Missy's master does not expect an exact copy of her. He knows her clone may not have her temperament(气质、性情). In a statement of purpose, Missy's owner and the A&M team say they are “both looking forward to studying the ways that her clones differ from Missy.”

Besides cloning a great dog, the project may contribute insight into the old question of nature vs. nurture. It could also lead to the cloning of special rescue dogs and many endangered animals.

However, Westhusin is cautious about his work. He knows that even if he gets a dog pregnant, the offspring, should they survive, will face the problems shown at birth by other cloned animals: abnormalities like immature lungs and heart and weight problems~ “Why would you ever want to clone humans,” Westhusin asks, “when we're not even close to getting it worked out in animals yet?”

小题1:By “stupid endeavor”, Westhusin means to say that ________.

A.human cloning is a foolish undertaking

B.animal cloning is absolutely impractical

C.human cloning should be done selectively

D.animal cloning is not worth the effort at all小题2:What does the second paragraph tell us about Westhusin's dog cloning project?

A.Its success is already in sight.

B.It is progressing smoothly.

C.It is doomed to utter failure.

D.Its outcome remains uncertain.小题3:By cloning Missy, Mark Westhusin hopes to ________.

A.study the possibility of cloning humans

B.search for ways to modify its temperament

C.find out the differences between Missy and its clones

D.examine the reproductive system of the dog species小题4:We learn from the passage that animal clones are likely to have ________.

A.a bad temper

B.defective(有缺陷的、有毛病的)organs

C.immune deficiency

D.an abnormal shape小题5:What’s the best title of the passage?

A.Cloning of Missy

B.Scientist Says ‘No’ to Human Cloning

C.Human Cloning Is Dangerous .

D.Westhusin Is Cautious about Cloning

单项选择题 A1/A2型题