试题与答案

在Excel中,设A1单元格的值为23,A2单元格的值为36,若在A3单元格中输入A

题型:单项选择题

题目:

在Excel中,设A1单元格的值为23,A2单元格的值为36,若在A3单元格中输入Al—A2,则A3单元格中的内容为();若在A3单元格输入公式“=TEXT(A2,”¥0.00”)”,则A3单元格的值为()。

若在A3单元格输入公式“=TEXT(A2,”¥0.00”)”,则A3单元格的值为()。

A.¥36

B.¥36.00

C.36.00

D.#VALUE

答案:

参考答案:B

解析:

函数TEXT的功能是根据指定格式将数值转换为文本,公式“=TEXT(A1,"¥0.00")”转换的结果为¥36.00。

试题推荐
题型:阅读理解

阅读短文,判断正(T)误(F)。

     On day afternoon Bob and Jane were walking along a quiet street when they heard a big noise from the

street corner. They ran there and found that a small car knocked into the side of a truck. Both the car driver

and the truck driver were hurt. 

     "Bob," said Jane, "Run back down the road to Mrs. Day's house. Ask her to call the police and the

ambulance (救护车). Hurry! I'll stay here." Bob went off as fast as he could. There was nothing Jane could

do but wait. She knew that when people were hurt in an accident, we shouldn't move them. 

     It wasn't long before the police car and the ambulance arrived. The policemen got the car door open and

moved the man out. Then they got the truck driver out. Luckily, the men weren't badly hurt, and the

ambulance took them to the hospital. The policemen thanked Bob and Jane, "You were very good to act so

quickly when you saw the accident. Thank you for all your help."

( )1. The accident happened in a quiet street one afternoon.

( )2. Bob, Jane, Mrs. Day and the policemen heard the noise.

( )3. Both of the drivers were hurt in the accident.

(     )4. Jane asked Bob to call the police.

(     )5. It was a long time before the policeman arrived.

查看答案
微信公众账号搜索答案