正确答案: C

=RANK(F3,$FS2:$FS10)

题目：表为EXCEL学生成绩统计表，最右边的一列数据为总成绩排名，G2单元格格输入的公式为"=rank(F2，$F$2：$F$10)"，则G3单元格对应的公式为( )。

解析：下表为Excel学生成绩统计表，最右边的一列数据为总成绩排名，G2单元格输入的公式为"=RANK(F2，$F$2：$F$10)"，则G3单元格与之对应的公式为A=RANK

查看原题 查看所有试题

学习资料的答案和解析：

[单选题] Millions of Americans lie awake at night counting sheep, or have a stiff drink or pop an allergy pill, hoping it will make them drowsy. But experts agree all that self-medicating is a bad idea, and the causes of chronic insomnia remain mysterious. Almost a third of adults have trouble sleeping, and about 10 percent have symptoms of daytime impairment that signal true insomnia. Sufferers readily cite the resulting problems: walking around in a fog, as memory and other cognitive functions slowly. Dozing off at the wheel or at work. Depression. Lack of energy. But for all the complaints, scientists know surprisingly little about what causes chronic insomnia, its health consequences and how best to treat it, a panel of specialists brought together by the National Institutes of Health concluded Wednesday. Two things are clear, the panel found: Chronic insomnia is a major public health problem. And too many people are using unproven therapies, even while there are a few treatments that do work. Among the panel's findings: Cognitive / behavioral therapy-a psychology-based treatment that trains people to reduce anxiety and take other sleep-promoting steps-is very effective, and doesn't cause side effects. But it can be hard to find health providers trained in the techniques. Insomniacs should check with board-certified sleep specialists and psychologists. Newer prescription sleep pills called Sonata, Ambien and Lunesta work without many of the side-effect concerns of older agents known as benzodiazepines (苯二氮类镇静药). One study of Lunesta showed effectiveness with six months of use, but more research on long-term use of all three is needed, as chronic msomma can linger for years. The most commonly used treatments are alcohol and over-the-counter sedating antihistamines (抗组．胺剂) like Benadryl. Alcohol use actually disrupts quality sleep, and antihistamines can cause lingering daytime sedation and other cognitive problems. The most common prescription insomnia medicine is an older, sedating antidepressant called trazodone, even though there's no good evidence that it offers more than a two-week benefit, and it comes with side effects.

One of most effective ways to deal with choric insomma is ________.

cognitive / behavioral therapy

解析：1.细节题。根据文章第四段，“Cognitive/behavioral therapy-a psychology-based treatment that trains people to reduce anxiety and take other sleep-promoting steps-is very effective”,这种方式非常有效，故D正确。而A、B在文章开头都被作者否定了，“experts agree all that self-medicating is a bad idea”。而C文章没有提及。 2.细节题。文章的第二段详细地描述了成年人失眠的症状：走路晃悠如在梦中，记忆和认知功能缓慢，在开车和工作中打盹，没有力气等。A、B、C都有所提及。但是D意为“认知功能缺失”，和原文表述不相同。这里应该注意选项和原文的细微区别。 3.细节题。根据文章第三段，“Chronic insomma is a major public health problem. And too many people are using unproven therapies, even while there are a few treatments that do work”，即慢性失眠是一个事关公众身体健康的大问题；尽管目前有一些行之有效的治疗方法，还是有不少人使用未经验证的疗法。应该注意这里说的是该机构的研究发现，不是文章中的所有发现，B、C、D都没有提及，故选A。 4.词义题。over意为“在……之上”，counter意为“柜台”。A项提醒我们药分为处方药和非处方药，而over the counter非常形象地描述了非处方药的销售方法，即直接在柜台上销售。此外， C、D都与语境相距甚远，B过于字面，用排除法可以选出A。 5.推断题。对于A，文中涉及unproven medicines的只有“too many people are using unproven therapies，even while there are a few treatments that do work”，而A没有被提及。B中说失眠者已经找到了可医治的药物，而文中说太多的人们都在用没有经过验证的治疗方法，故人们实际上没有找到。C项在文中没有提及。由“scientists know surprisingly little about what causes chronic insomma，its health consequences and how best to treat it"可知D项正确。

[单选题]春天来了，花红柳绿，鸟语花香。下列关于有花植物说法正确的是( )。

花的香气吸引昆虫，有利于花粉传播

解析：花朵利用鲜铯的颜色、芬芳的香气、精致的花瓣和美味的花蜜吸引蜜蜂和苍蝇等昆虫前来传粉，A项正确。漫天飞舞的柳絮是柳树的种子，柳树依靠风力将种子传播出去，B项错误。自然界中，鸟类取食植物的种子和果实后，它们在飞行过程中会将一些没有消化的种子随粪便排出体外，而后种子萌发生长，有利于植物繁殖，C项错误。雄花没有子房，无法结出果实，D项错误。故本题选A。