表为EXCEL学生成绩统计表，最右边的一列数据为总成绩排名，G2单

【名词&注释】

单元格(unit grid)、学生成绩统计表、总成绩(total score)

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

A. =RANK(F2,$FS3:$FS10)
B. =RANK(F3,$F$l:$F$10)
C. =RANK(F3,$FS2:$FS10)
D. =RANK(F3,$F$3:$F$10)

查看答案&解析 查看所有试题

学习资料：

[单选题] 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 ________.

A. to have a stiff drink
B. to pop an allergy pill
C. to sleep and get up early
D. cognitive / behavioral therapy

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

A. 花的香气吸引昆虫，有利于花粉传播
B. 漫天飞舞的柳絮是柳树的花
C. 鸟类取食果实不利于植物繁殖
D. 雌花、雄花都可结出果实

本文链接：https://www.51bdks.net/show/6n399w.html