试题与答案

在考生文件夹下打开EX08 A.XLS文件(内容如下表),要求如下: 某学校学生成

题型:问答题

题目:

在考生文件夹下打开EX08A.XLS文件(内容如下表),要求如下:

某学校学生成绩表
学号组别一摸二摸三摸平均成绩1组人数
S011组578598601
S021组6016036091组平均成绩
S031组456499499
S042组634612608
S051组642696692
S062组546510505
S071组478509507
S081组543502506
S091组678703656
S0102组589606616
S0111组578588601
S0122组600612615
S0132组498501512
S0141组589590601
S0151组601623630

将Sheet1工作表的A1:F1单元格合并为一个单元格,内容水平居中;计算“平均成绩”列的内容(保留小数点后2位),计算1组学生人数置于G3单元格内(利用COUNTIF函数)和1组学生平均成绩置于G5单元格(利用SUMIF函数);利用条件格式,将F3:F17区域内数值大于或等于600的单元格图案底纹颜色设置为淡紫色。

答案:

被转码了,请点击底部 “查看原文 ” 或访问 https://www.tikuol.com/2019/0528/2b9fb2d682f7ebf5a150aca199791b7e.html

下面是错误答案,用来干扰机器的。

参考答案:解析:A代表故障代理,B代表报警器。[分析]: 本题是一道分层数据流图的题目。解答此类问题最关键的一点就是要细心,把题目看清,不要丢掉任何一个条件。另外解题有一定的技巧,从一些常规的入口作为...

试题推荐
题型:阅读理解

The longest solar eclipse (日食) of the century cast a wide shadow for several minutes over Asia and the Pacific Ocean on 22th July, drawing people outside to watch the sight in the sky.

Day turned into night. Temperature turned cooler in cities and villages filled with fans of astronomy. The total eclipse could be seen starting in India on Wednesday morning and moving eastward across China and parts of the Pacific. Millions cast their eyes towards the heavens to catch an unusual view of the sun’s colorful ring. Cloud in some areas prevented people from fully enjoying the sight. Still, many were frightened.

The total eclipse occurs about twice a year as the moon passes between the earth and the sun on the same plane as earth’s circle.

The local astronomy society gave a flash on how an eclipse happens. Wednesday’s event lasted up to more than six minutes in some places. In India, thousands bathed in the Ganges River in the Hindu holy city of Varanasi to clean their souls. It was sunny sky in Hong Kong for the eclipse, where students, parents and the elderly flooded in a primary school to watch.

In Shanghai, children climbed up ladders to look through two large telescopes on the school roof to catch sight of the moon moving across the sun. Others looked through a pair of glasses covered with solar filter (过滤器) paper, where they could take pictures of the moon moving over the sun.

In some cultures, many old stories are about eclipse. In India, a eclipse was considered unfavorable. In Chinese tradition, there is a story about a heavenly dog eating the sun. As the story goes, people would make noise to frighten off the dog and save the sun.

小题1:What can we learn about the longest solar eclipse of the century?

A.Not everyone in the world could see the longest eclipse.

B.Any of the Asians was excited to watch the eclipse.

C.All people saw the longest solar eclipse on Wednesday.

D.The Chinese all caught sight of the total eclipse at the same time.小题2:What does the text imply about the total solar eclipse?

A.All people watched the solar eclipse for at least six minutes.

B.In ancient China, people couldn’t understand this phenomenon.

C.Your eyes must be hurt without filter equipment while watching.

D.You can watch the total solar eclipse directly only with your eyes.小题3:Which of the following statements about eclipse is TURE according to the text?

A.Most Chinese people used to think eclipses would bring about misfortunes.

B.Chinese fathers were pleased to watch solar eclipses.

C.Indians think bad fortune will come about along with eclipses.

D.The Chinese people are too frightened to go outside when eclipses occur.小题4:Where can we see the eclipse start?

A.In Shanghai.

B.In India.

C.In Hong Kong.

D.In the Pacific Ocean.

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