问题 问答题

打开工作簿文件EXC.XLS,对工作表“图书销售情况表”内数据清单的内容按主要关键字“经销部门”的降序次序和次要关键字“季度”的升序次序进行排序,对排序后的数据进行高级筛选(在数据表格前插入三行,条件区域设在A1:F2单元格区域),条件为社科类图书且销售量排名在前30名,工作表名不变,保存EXC.XLS工作簿。

答案

参考答案:双击打开EXC.XLS,选择数据菜单下的筛选,单击相应列的向下箭头,设置条件社科类图书且销售量排名在前30名,选择数据菜单下的排序,设置主要关键字“经销部门”的降序次序和次要关键字“季度”的升序次序,保存文件。

阅读理解

At 50 I was the first woman to travel alone to the North Pole. But what should I do to celebrate my 60th birthday? What else, but a journey at the opposite end of the world, Antarctica. I began my almost 400-mile journey on November 1st, 1997,a few days before my birthday. I walked and skied alone. My dog team were not with me to pull my sled. Another journey of challenge and danger was about to begin.

The first days the weather was very good. The wind was icy but not very strong and there was bright sunshine 24 hours a day. But changes were just around the corner. On the third day I was struggling through stormy weather and during the nest week the wind grew stronger and I found myself spending a whole day in my tent.

I had traveled only two hours one day when the winds increased so much that I had to put my tent up before the winds became too strong. Within a few minutes the winds increased to a howling storm that threatened to blow me and the tent away, but none of that happened.

小题1:from the text we know the writer was born on ___.

A.1st November 1937

B.12th November 1937

C.22nd November 1947

D.1st November 1957小题2:Another journey of challenge and danger was about to begin. “ Another journey” here means ___.

A.the travel to the North Pole.

B.another journey to Antarctica.

C.400- mile journey on November 1st 1997.

D.a new trip that she was planning.小题3:After reading the short passage, we can guess that ___.

A.the trip to the North Pole must be the same hard as that to the South Pole.

B.The trip to the Antarctica may be more dangerous than that to the Arctic

C.There was no danger though the trip to the South Pole was hard.

D.During the trip to the Antarctica, the weather, most of the time, was not so bad.小题4:Do you think which kind of people the writer is?

A.mean

B.generous

C.brave

D.handsome

单项选择题