问题 单项选择题

在如图2-3所示的Excel表中,在H2单元格中输入公式“=RANK(G2,$G$2:$G$6,2)”,则H2单元格中显示的值为
[*]

A.2
B.3

C.4
D.5

答案

参考答案:A

解析:[要点解析] 函数RANK的主要功能是返回某一数值在一列数值中的相对于其他数值的排位。其语法格式如下。
RANK(Number, ref, order)
其中,参数Number表示需要参加排序的数值;ref表示需要参加排序的数值是要在哪个单元格区域内排序;order为排序方式参数。如果order值为“0”或者忽略,则按降序排名,即数值越大,排名结果数值越小;如果order值为非“0”值,则按升序排名,即数值越大,排名结果数值越大。在如图2-3所示的Excel表中,在H2单元格中输入公式“=RANK(G2,$G$2:$G$6,2)”,即将G2:G6单元格的总分按升序排名,由于239<252<264<267<269,即252在[总分]列升序排名中为第2位,因此H2单元格的值为2,如图2-16所示。注意:Number的值要用相对引用。ref的数值要用绝对引用,否则在按其他要求排序后它的值会产生变化。

阅读理解

阅读理解。

     Because of my curiosity (好奇心), I had a really exciting weekend. I took a trip to Gloucester to see

some of the world's most beautiful animals-whales in the North Atlantic Ocean. After a long trip by train

and bus, we got on the ship called the "Privateer". On our way to see the whales on that beautiful sunny

day, I grew more and more excited.

     After a while we stopped, and everyone on the ship started to shout because we'd seen whales. It was

wonderful! 

     While we were watching the whales, a guide was giving us information about them. She told us we

were seeing only two kinds of whales-50-foot whales (singing whales) and 70-foot whales (the second

largest whales on the earth). She also said we could easily tell the different kinds of whales by their tales

(尾巴), since every whale has a different tail, just as people have different fingerprints (指纹).

     They all have names as well. On this trip, we saw "Salt" and "Pepper", two whales named by a scientist

and a fisherman. They swam together all the time. Sometimes whales came so close to the ship that we

thought we could touch them.

      I took twenty-seven photos, which was a really hard job because they moved so quickly, and stayed

on the surface of the ocean for such a short time. Having seen the whales was one of the chances few

people ever got. I was lucky enough to have that chance.

1. The passage is mainly about _____.[ ]

A. the different kinds of whales

B. the different kinds of animals in the ocean

C. a trip to study ocean animals

D. a trip to see whales

2. Which of the following transport did the author NOT use during the trip? [ ]

A. The train.

B. The plane.

C. The bus.

D. The ship.

3. We can learn from the third paragraph that _____. [ ]

A. there were only two kinds of whales

B. 70-foot whales are the largest in the world

C. whales all have different tails

D. whales have fingerprints as people do

4. What did the author do when she saw the whales? [ ]

A. She gave them the names "Salt" and "Pepper".

B. She swam with them.

C. She got close to touch them

D. She took photos of them.

单项选择题