问题 单项选择题

某品牌商品销售情况表如下图所示。若想按产品类别分别累计销售量,可使用分类汇总命令。汇总的结果如下图所示。在进行分类汇总前,应先对数据清单中的记录按(1)字段进行排序;选择"数据/分类汇总"命令,并在弹出的"分类汇总"对话框中的"选定汇总项"列表框内,选择要进行汇总的(2)字段,再点击确认键。

空白(1)处应选择()

A.产品

B.销售日期

C.销售地点

D.销售量

答案

参考答案:B

解析:

在Excel中,在进行分类汇总前,应先对数据清单进行排序,数据清单的第一行必须有字段名。

操作步骤如下:

(1)对数据清单中的记录按需分类汇总的字段"产品"进行排序,排序的结果如下图所示。

(2)在数据清单中选定任一个单元格。

(3)选择"数据/分类汇总"命令,屏幕弹出如下图所示的"分类汇总"对话框。

(4) 在"分类字段"下拉列表框中,选择进行分类的字段名。

(5)在"汇总方式"下拉列表框中,单击所需的用于计算分类汇总的方式,如求和。

(6)在"选定汇总 项"下拉列表框中,选择要进行汇总的数值字段"销售量"。

(7)单击"确定"按钮,完成汇总操作,得到所需的结果。

阅读理解

Cause and effect is one way to explain things that happen around us. Many things happen because something caused or influenced them to happen. Sometimes it is hard to look at a cause and find out what causes the effect. It may help you to start with the effect and use your reasoning(推理的) skills. Think about all the things you know that could be reasons for the effect you can see.

For example, you may see someone putting on a heavy jacket. This is the effect. To look for a cause, think to yourself, “What would make someone put on a heavy jacket?” Maybe the person works in the penguin pen(企鹅圈养地) at a Sea World. Maybe the person is going to visit an ice skating rink where the air is kept very cold. All of these things could be a cause for putting on a heavy jacket.

Now, think about a second example. The effect is a boy named Abi has to go to the head teacher’s office. What are the possible causes? Maybe he bullied(欺负)another student. Maybe he is just being picked up early. Maybe he is being given a prize!

Here is another example for you to think about its cause and effect. Cait, 13, was trying to fall asleep when her 8-year-old brother,Doug, came into her room. He looked around a bit, but seemed really out of it. Then Doug went back into the hallway and stood there looking straight up at the hall light for quite a while. Little brothers can be very strange, this was really much too strange. Cait didn’t know what to do. Just then, Cait’s father appeared and explained that Doug was sleepwalking. What’s the cause and effect, could you tell?

小题1:According to the second paragraph, which of the following is an effect?

A.Someone will go outside into cold weather.

B.Someone works in the penguin pen.

C.Someone puts on a heavy jacket.

D.Someone will go to visit an ice skating rink.小题2:Abi has to go to the head teacher’s office. Which of the following isn’t the possible  cause?

A.He bullied another student.

B.He is going shopping.

C.He is being picked up early.

D.He is being given a prize.小题3: What was Doug doing when his sister Cait tried to fall asleep?

A.He was going outside

B.He was reading a story.

C.He was leep walking.

D.He was looking for his dad.小题4:Which of the following is cause and effect?

A.Tony got up and had a glass of water.

B.We came home and found him sleeping.

C.The ball was lost and a window was broken.

D.Tim was late again and his teacher got angry.小题5:What is the best title for the text?

A.Truth and lies

B.Work and sleep

C.Cause and effect

D.Life and dreams

单项选择题