问题 单项选择题

如果已知一个Excel表格A1单元格是空格,A2单元格的内容为数值2,A3单元格的内容为数值3, A4单元格的内容为数值4.5,A5单元格的内容为数值5.5,A6单元格的内容为“=COUNT (A1:A5)”,那么,A6单元格显示的内容应为 (17)

A.4

B.5

C.6.5

D.15

答案

参考答案:A

解析:[要点解析] 在Excel中,COUNT函数返回包含数字以及包含参数列表中的数字的单元格的个数。可利用COUNT函数计算单元格区域或数字数组中数字字段的输入项的个数。COUNT(A1:A5)的统计范围是A1~A5这5个单元格,但其中A1单元格是空格,不能转换为数字,将被忽略,因此A6单元格显示的内容应为“4”。

阅读理解

A Battery’s Nightmare

Portable electronics that can be carried about easily are only as good as their batteries (电池) and, let’s face it, batteries aren’t very good, especially when compared with, say, petrol, which packs 100 times a battery’s energy into an equal space. That’s why a large group of mechanical engineers (centered at the Massachusetts Institute of Technology, but with partners at other universities and companies) are hard at work in an effort to replace batteries with a tiny engine that runs on fuel. Imagine a battery-free life! When the fuel runs out in your mobile phone, you just fill up and go.

The engine---about the size of a ten-cent coin---starts with a combustion chamber (燃烧室) that burns hydrogen. Its tiny parts are etched (蚀刻) onto silicon wafers (硅片) in the same manner that computer parts are etched onto integrated circuits (集成电路). The first engine is made up of five wafers. And since these wafers could be produced in much the same way as computer chips, they could probably be produced quite cheaply.

But the devil in all this nice detail is efficiency. Tiny engine parts don’t always behave like the bigger parts of the first engine. Something between the parts can slow down the works, according to Columbia University Professor LucFrechette, one of the engine’s designers. Extreme heat from the combustion chamber is also a problem, often leaking to other parts of the engine.

The scientists’ goal is to create an engine that will operate 10 times better than batteries operate. Frechette says that a complete system, with all parts in place and working, will be set up in the next couple of years, but commercial models aren’t likely until at least the end of the next ten years.

小题1:According to the passage, the title suggests that _______ .

A.batteries should be greatly improved

B.petrol will be used instead of batteries

C.the time of batteries will be gone forever

D.pollution problems caused by batteries must be solved小题2:What’s the meaning of the underlined word “devil” in paragraph 3?

A.Problem

B.Advantage

C.Invention

D.Technique小题3:What can we infer from the passage?

A.The new invention doesn’t need any fuel.

B.The new engine has been produced in large quantities.

C.The new invention is much cheaper than the battery.

D.The new engine needs to be improved before it’s on sale.

写作题