问题 单项选择题

在Excel中,通过冻结或者拆分窗格可以在滚动工作表时始终保持部分数据可见。下图中(1),当鼠标指针在上述位置变为()后,将该框拖至所需的位置即可。

当鼠标指针在上述位置变为()后,将该框拖至所需的位置即可。

A.

B.

C.

D.

答案

参考答案:A

解析:

本题考查的是Excel表处理软件的基本操作。在Excel表处理软件中,通过拆分或冻结窗格查看工作表的两个部分。

拆分窗格是垂直滚动条的顶端或水平滚动条的右端指向拆分框,题图②指向的是垂直拆分框,③指向的是水平拆分框。

当鼠标拆分指针变为后,将拆分框向下或向左拖至所需的位置。例如,员工薪资表如下图所示:

如果想比较35001,35002与35040,35041的工作时数、小时报酬及薪水,由于窗口大小所限比较起来十分不便,但是,我们将拆分框向下拖至第三行与第四行中间处,将表格拆分成两部分,拖动另一部分的垂直滚动条观看起来将十分方便,如下图所示。

选择题
单项选择题

Just as world oil scarcity is already causing international conflicts, so will the scarcity of water reach a point where wars will break out. The statistics on water are already scary. Already well over 1 billion people suffer from water shortages and 30 countries get more than a third of their water from outside their borders-an obvious source of disputes and instability especially as the climate changes. The whole of the sub-Saharan Africa, most of South Asia and western South America are most at risk. The reason: the rapid melting of glaciers due to global warming.

At the meeting of the coalition of 27 International charities last month, Gareth Thomas, minister of International Development of the British government, wrote to prime minister Gordon Brown demanding action to ensure fresh water to 1.1 billion people with poor supplies. "If we do not act now, the reality is that water supplies may become the subject of international conflict in the years ahead. We need to invest now to prevent us having to pay that price in the future." Thomas said. The department warned that two-thirds of the word’s population will live in water-stressed countries by 2025.

The coalition of charities has appealed for a global effort to bring running water to the developing world and supply sanitation to a further 2.6 billion people. It said that international investment is needed now to prevent competition for water to destabilize communities and escalate into conflicts.

Tackling the water and sanitation crisis is essential if the Millennium Development Goal Call to Action is to be a success. Otherwise, progress on health, education, and environment sustainability will be undermined. Each year 443 million school days are lost globally to diarrhea and 1.8 million children die from these diseases. In fact, it is often not realized that investing in sanitation and water brings the greatest public health gains, more than any other single development intervention and delivers enormous economic gains. Already, some Asian countries have put tackling these issues at the forefront of their development efforts. The Millennium Development Goals aim to halve the proportion of people without access to safe drinking water by 2015. To achieve that urgent action needs to be taken.

There is no doubt that climate change is potentially the most important factor affecting water shortage. This, compounded with a growing and increasingly urbanized global population will put pressure on food and water. For a temperature rise of 2 C, which is likely to happen by 2050, there would be a catastrophic 2 to 3 billion people suffering from water stress.

What can the coalition of charities do to prevent competition for water?()

A.Appealing for international investment.

B.Bringing running water to the developing world.

C.Supplying sanitation to billions of water-stressed people.

D.Enhancing world environment sustainability.