试题内容 在工作表“区域销售”的单元格P3中使用COUNTIFS函数,以计算区域“

题型:问答题

问题:

试题内容


在工作表“区域销售”的单元格P3中使用COUNTIFS函数,以计算区域“北京”中有多少名销售人员的销售量超过了25000。

准备


打开练习文档(\Excel素材\21.区域销售.xlsx)。

注释


COUNTIFS函数是将条件应用于跨多个区域的单元格,并返回符合所有条件的单元格个数的函数。
函数书写格式为
COUNTIFS(criteria_range1,criteria1,[criteria_range2,criteria2],...)
COUNTIFS函数参数说明如下。
criteria_range1:第一个计算关联条件的区域范围。
criteria1:判定条件,条件的形式可为数字、表达式、单元格引用或文本,用来定义将对哪些单元格进行计数。
criteria_range2,criteria2,...:添加附加的区域及其关联条件。

考点:计算机认证考试微软认证微软办公软件国际认证
题型:问答题

阅读理解。

     A man was sitting in the doctor's office.He was telling the doctor about his problem. "I like football,

Doctor," he said."Please help me. My life has never been a good one since I became interested in football; and it is getting worse and worse.I can't even get away from it in my sleep.As soon as I close my eyes,

I'm out there on the football field and running after a flying ball. When I wake up,I'm more tired than

I was when I went to bed. What am I going todo?"

    The doctor sat back and said,"First of all,you have to do your best not to dream about football.When

you close your eyes,try to think about something else. Try to think that you are at a party andsomeone is

going to give you several million dollars, "

     "Are you crazy(疯狂的,古怪的), Doctor?"  the  manshouted at the doctor."I will miss my ball."

1. The man went to see the doctor because ______. 

A. there was something wrong with his heart

B. the doctor was interested in football

C. he wanted to get some advice about his trouble with football

D. his wife was ill

2. Football makes the man's life ______.  

A. happy          

B. interesting

C. good          

D. difficult

3.The man felt more tired after he got up because ______.

A. he thought of getting several million dollars even in his sleep

B. he thought of football even in his sleep

C. he watched a football match on TV too late at night

D. he ran after the flying balls before he went to bed

4. The doctor told the man ______. 

A. not to think of football when he went to sleep

B. not to close his eyes when he was lying in bed

C. to be a rich man with several million dollars

D. not to dream in his sleep

5. The best title for this story is ______. 

A. Crazy Doctor

B. Flying Football

C. Exciting Football

D. A Man Crazy About Football

题型:问答题
0.25立方米=______立方分米5600毫升=______升
538毫升=______立方厘米30秒=______分.
题型:问答题

下列哪一项不是肠外营养的并发症()。

A.胆囊内胆泥淤积和胆结石的形成

B.肝脏内淤胆和肝功能损害

C.肠屏障功能的减退导致肠源性感染

D.胃应激性溃疡引起上消化道出血

E.以上均不是

题型:问答题

项目实施过程中,围绕对项目质量的监控、追踪管理,以下做法不正确的是()

A.可采用控制图来对质量进行监控

B.使用挣值分析来对质量进行监控

C.通过分析测试报告来对质量进行监控

D.通过分析施工日志中的施工参数来对质量进行监控

题型:问答题

平权法案(AffirmativeAction)

更多题库