问题 问答题

注意:下面出现的所有文件都必须保存在考生文件夹下。

打开工作簿文件EXCEL2.XLS,对工作表“客房出租情况表”内数据清单的内容按主要关键字“客房名称”的降序次序和次要关键字“数量”的升序次序进行排序,对排序后的数据进行分类汇总(汇总结果显示在数据下方),计算各方分店所有出租房的最数量,保存EXCEL2.XLS文件。
[*]

答案

参考答案:[解题步骤]
步骤1 在“考试模拟系统”中选择“答题→电子表格→EXCEL2.XLS”命令,将文档“EXCEL2.XLS”打开。
步骤2 选择工作表中带数据的单元格,选择“数据→排序”命令,在“排序”对话框的”主要关键字”中选择“客房名称”,在其后选中“降序”,在“次要关键字”中选择“数量”,在其后选中“升序”。单击“确定”按钮完成设置。
步骤3 选择“数据→分类汇总”命令,弹出“分类汇总”对话框,在“分类字段”中选择“客房名称”,在“汇总方式”中选择“最大值”,在“选定汇总项”中选择“数量”,最后勾选“汇总结果显示在数据下方”,单击“确定”按钮完成设置。最后保存文件EXCEL2.XLS。

选择题
完形填空
My husband and I sat outside. A small child about three came up the street, accompanied by her mother. As she saw another girl a few feet away, she gave her admiring comment, “Mommy, I like her dress.” Her mom   21 , “Well, why don’t you go and tell her?”
The little girl walked   22  toward the girl wearing the pretty dress. The other one,
  23  the same age, was standing with her   24  turned, alongside her parents. They had not heard the compliment (赞美). Receiving no answer, this little one   25 . My husband said to the other girl, “  26  wants to tell you something.” As she turned around, connection was made. Once again, the little one   27  “I like your dress,” and upon hearing those words, the other one gave her a big smile and excitedly   28  “Look, it’s a spinning (旋转) dress!”, at which moment she began to spin in  29. Both of them smiled widely.
Now, the one stopped spinning and said, “It’s my favorite dress and I have (a)   30  that match!” She   31  running toward a stroller (婴儿车) parked nearby.
The mom and the daughter started to   32  down the street,   33  the encounter (邂逅) had ended. Moments later, the “spinning dress girl” reappeared, shoes in hand,   34  her new friend who had seemingly disappeared. Now, an elderly couple, seated on a bench, had obviously been  35  of all this. The man   36  the child, saying, “There’s someone coming behind you.” Then we saw one showed and the other   37  the beautiful shoes.
If you can make a   38  better, do it. I have no idea how many others that evening might have   39  this act, hoping to help good things to happen. But such brief moments,  40  together, make up what might very well be the important times in our lives.
小题1:
A.repliedB.scoldedC.laughedD.required
小题2:
A.secretlyB.shylyC.heavilyD.suddenly
小题3:
A.usuallyB.hopefullyC.likelyD.luckily
小题4:
A.backB.headC.noseD.hand
小题5:
A.shoutedB.leftC.criedD.hesitated
小题6:
A.AnyoneB.SomeoneC.EveryoneD.No one
小题7:
A.suggestedB.apologizedC.explainedD.announced
小题8:
A.turnedB.sharedC.jumpedD.agreed
小题9:
A.circlesB.linesC.directionsD.rows
小题10:
A.shoesB.socksC.shirtD.hat
小题11:
A.took offB.turned downC.put onD.made up
小题12:
A.leadB.lookC.headD.get
小题13:
A.rememberingB.hopingC.sayingD.thinking
小题14:
A.coming acrossB.looking forC.shouting atD.calling on
小题15:
A.watchfulB.carefulC.proud D.fond
小题16:
A.calmedB.comfortedC.stoppedD.seated
小题17:
A.woreB.admiredC.comparedD.bought
小题18:
A.momentB.lifeC.girlD.dress
小题19:
A.learnedB.performedC.praisedD.observed
小题20:
A.seizedB.spentC.threadedD.lost