问题 问答题

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


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

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

答案

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

单项选择题
阅读理解

阅读理解。

     Environmentalists said our planet was doomed to die. Now one man says they are wrong.

    "Everyone knows the planet is in bad shape," thundered a magazine article last year. Species are being

driven to die out at record rates, and the rivers are so poisonous that fish are floating on the surface, dead.

    But there's a growing belief that what everyone takes for granted is wrong: things are actually getting

better. A new book is about to overturn our most basic assumptions about the world's environment. Rivers, seas, rain and the atmosphere are all getting cleaner. The total amount of forests in the world is not

declining. The Skeptical Environmentalist by Bjorn Lomborg, professor of statistics at the University of

Aarhus in Denmark, is an attack on the misleading claims of environmental groups, and the "bad news"

culture that makes people believe everything is getting worse.

    Now the attacks are increasingly coming from left-wing environmentalists such as Lomborg, a former

member of Greenpeace. The accusation is that, although the environment is improving, green groups-with

profits of hundreds of mil-lions of pounds a year - are using scare tactics(谋略)to gain donations. Lomborg's book doesn't deny global warming - probably the biggest environmental threat - but destroys almost

every other environmental claim with many official statistics.

    The Worldwatch Institute claims that "deforestation(沙漠化) has been accelerating over the last 30

years". But Lomborg says that is simply rubbish. Since the dawn of agriculture the world has lost about

20 per cent of its forest cover, but in recent decades the forest area's depleting has come to a stop.

According to UN figures, the area of forests has remained almost steady, at about 30 per cent of total

land area, since the 1940s. Forests in countries such as the US, the UK and Canada have actually been

expanding over the past 40 years. Despite all the warnings the Amazon rainforest has only shrunk by

about 15 per cent.

    Nor are all our species dying out. Some campaigners claim that 50 per cent of all species will have

died out within 50 years. But other studies show only 0.08 per cent of species are dying out each year.

Conservation efforts have been successful. Whales are no longer threatened and the bald eagle is off the

endangered list.

    Environmental groups claim that many of the improvements are the results of the success of their

campaigns. Stephen Tindale, director of Greenpeace UK, said, "There are important examples, such as

acid rain and ozone, where things aren't as bad as predicted, and that's because behavior has changed."

1. In his book, The Skeptical Environmentalist, what is Lomborg's main argument?

A. Our planet is in bad shape.

B. The world's environment is improving.

C. The total amount of forests in the world is not declining.

D. Conservation efforts have been successful.

2. What is Lomborg's main accusation of environmentalists?

A. They scared people into making donations.

B. They overturned our basic assumptions about the world's environment.

C. They changed their behavior toward the environment.

D. They only told people bad news about the environment.

3. The underlined word "depleting" in Paragraph 5 is closest in meaning to "____".

A. reducing                

B. limiting  

C. expanding            

D. accelerating

4. According to the passage, which of the following statements is true?

A. The total area of forests in the world has increased significantly.

B. The effects of global warming are not as bad as first expected.

C. It appears that the bald eagle will now survive.

D. In the last 50 years the number of whales has increased.