问题 单项选择题

在Excel中,______函数用来计算某个区域中空单元格的数量。

A.COUNT

B.COUNTA

C.COUNTBLANK

D.COUNTIF

答案

参考答案:C

解析:COUNT函数返回包含数字以及包含参数列表中的数字的单元格的个数。函数COUNT在计数时,将把数字、日期或以文本代表的数字计算在内,但是错误值或其他无法转换成数字的文字将被忽略。
COUNTA函数返回参数列表中非空值的单元格个数。利用函数COUNTA可以计算单元格区域或数组中包含数据的单元格个数。在这种情况下,参数值可以是任何类型,可以包括空字符(""),但不包括空白单元格。如果参数是数组或单元格引用,则数组或引用中的空白单元格将被忽略。
COUNTBLANK函数用来计算指定单元格区域中空白单元格的个数。单元格中含有返回值为空文本("")的公式时,该单元格也会计算在内,但包含零值的单元格不计算在内。
COUNTIF函数计算区域中满足给定条件的单元格的个数,其中条件的用法非常多。

阅读理解

Edgar felt quite excited at the thought of his first swim of the summer. With the sun shining down so strongly, the sea was certain to be warm enough. He walked quickly along the sea-front towards the steps that led on to the sands. He smiled cheerfully at the passersby. He had just smiled and raised his hat to an elderly lady when a man with a camera caught his arm and stopped him. Edgar heard a little buzzing noise from the camera.

“Your photograph, sir, in glorious colour in just one moment if you please,” said the man in one breath. Then the buzzing stopped, and he held the photograph in his hand and was waving it to and fro. In a

moment he handed it over, and Edgar saw the bright blue splash of his shirt half filling the picture.

“Seventy pence, sir,” the man said. “It’s the bargain of your holiday.”

“Seventy pence,” Edgar repeated, mildly. “For this?” He stared at the photographer.

“They’re normally eighty-five, sir, but for a single subject I make a cut-price offer. It’s the best value you’ll get in Chadwell.”

“You’ll have to make a better offer,” Edgar said. It was a good photo though, he thought, so bright and clear. His hat was held high, and he was smiling broadly at the old lady, whose arm and handbag came into a lower corner. He had had no idea that he was being snapped. He thought he was really quite a good-looking chap.

“That’s as good as any studio job that would cost you pounds,” said the cameraman. “It’s better in a way because it’s so natural. Only seventy pence, sir.”

“I’ve never paid so much for a snap in my life. It simply isn’t worth that kind of money. It’s not as if I need the thing. Look, I’ll give you twenty-five.”

“No, I can’t do that. Each of these instant colour shots costs me 50p — that’s the price of the blank frame, so you see…”

“Criminal, criminal,” Edgar broke in. “You want a profit of forty per cent. Well, not at my expense, I’m afraid. I’ll give you your 50p and that’s that.”

“Let me see, then.” The man suddenly took the photograph out of Edgar’s hand. “I can’t waste any more time with you. It’s 70p or I keep it.”

“Keep it,” Edgar said. He turned, looked out to the sea, and then walked quickly away.

小题1:Why do you suppose Edgar was in Chadwell?

A.It was his hometown.

B.He was there on holiday.

C.He was in the making of a film.

D.He was there to have his photograph taken.小题2:Edgar smiled at and raised his hat to the lady because ________.

A.he thought he recognized her

B.he wanted the photograph to be amusing

C.she was having her photograph taken

D.he was feeling excited and cheerful小题3: The photographer lowered his price to 70p because __________.

A.Edgar wanted to bargain for the photo

B.Edgar couldn’t afford to pay the normal price

C.Edgar was the only person in the photo

D.there was only one copy of the photo小题4:What did Edgar think of the photo?

A.He thought it made him look like a criminal.

B.He liked it but thought it was too dear.

C.It annoyed him because he hadn’t expected it.

D.He thought it was a bargain at the price.小题5:We can infer from the passage that _______ .

A.Edgar was an indifferent but good-looking man

B.Edgar smiled at the photographer because he was being photographed

C.the photographer was actually a criminal

D.Edgar didn’t buy the snap at length.

单项选择题