问题 单项选择题

学生成绩表如下表所示。若要计算学生各科成绩、总分和平均分各项的最高分,可先在C10单元格中输入(1),并(2)拖动填充柄至H10单元格,则可自动算出这些学生各科成绩、总分和平均分的最高分。

空白(1)处应选择()

A.MAX(C3:C9)

B.=MAX(C3,C9)

C.=MAX(C3+C9)

D.=MAX(C3:C9)

答案

参考答案:D

解析:

试题1的正确选项为D。

因为对于选项A,"MAX(C3:C9)"格式不对,公式前必须加"="号;选项B"=MAX(C3,C9)"是求单元格C3和C9中的最大值;选项C"=MAX(C3+C9)"是将单元格C3和C9相加,与题意不符;选项D"=MAX(C3:C9)"是求单元格C3至C9中的最大值,与题意相符。试题2的正确选项为B。

根据题意,要计算学生的各科成绩、总分和平均分的最高分,可先在C10单元格中输入"=MAX(C3:C9)"并向水平方向拖动填充柄至H10单元格,则可自动算出这些学生各科成绩、总分和平均分的最高分。

完形填空

任务型阅读(共5小题;每小题1 分,满分5 分)

Martin, Henry, Margaret, Joseph和Alex五个人都想要参加各自喜欢的俱乐部。请仔细阅读第1-4题中的个人情况说明,然后从A到D的四个项目中,选出符合个人要求的最佳选项,并回答第5小题。

小题1:Martin wants to learn how to be a team leader and how to organize activities.

小题2:Henry is interested in gardening and taking care of flowers and plants.

小题3:Margaret wants to have a try in the making of TV programs.

小题4:Joseph hopes to be given a chance to act in a play. 

Club information

A.This club is a group of students who are interested in the art of TV broadcasting. Members learn how to use equipment in our television studio. They also work as part of a team to produce TV programs.

Advisor: Mr. Koehler

B.The aim of this club is to help the members to develop their own leadership skills by organizing different kinds of activities. The members meet every Tuesday from 3:00 to 4:00.

Advisor: Mr. Wells

C.This club for students in Grades 2 and 3 helps plant and take care of the School Front Garden and the Butterfly Garden.

Advisor: Mr. Michael

D.This club produces musical and nonmusical plays in which 75 to 100 players can act depending on which play is chosen. The plays like Dinosaurs Alive, Disney Days and so on have been enjoyed by many people. All students are welcome.Advisor: Mrs. Sands

小题5:Alex likes basketball very much and wants to become a member of the school team. What club will he choose?

A.Do you want to play with classmates? You can take part in kinds of activities.

B.Do you want to become a Kobe or a James in our school? Our club has invited a retired NBA player, who will help you a lot.

C.Do you want to travel all the world? We will invite a famous traveler to introduce the world.

D.Please take part in our club. The teachers will help you practice spoken English.

问答题 简答题