问题 问答题

打开工作簿文件EXC.XLS,对工作表“某商城服务态度考评表”内数据清单的内容进行自动筛选,条件为日常考核、抽查考核、年终考核三项成绩均大于或等于75分;对筛选后的内容按主要关键字“平均成绩”的降序次序和次要关键字“部门”的升序排序,保存EXC.XLS文件。

答案

参考答案:

解析:第2小题 首先在“考试系统”中选择[答题→电子表格题→exc.xls]命令,将文档“exc.xls”打开。 (1) 自动筛选 打开需要编辑的工作簿EXC.XLS,首先对其进行筛选操作,再设置其排序,其具体操作如下: 步骤1 在“考试系统”中选择[答题→电子表格→EXC.XLS]命令,将工作簿“EXC.XLS”打开。单击工作表中带数据的单元格(任意一个),选择[数据→筛选→自动筛选]命令,在第一行单元格的列标中将出现按钮。 步骤2 单击“日常考核”列的按钮,在下拉菜单中选择“自定义”命令,在“自定义自动筛选方式”的“日常考核”中选择“大于或等于”,在其后输入“75”。 步骤3 用相同的方法设置“抽查考核”和“年终考核”列的筛选条件,其设置方法和设置值同“日常考核”列相同,完成自动筛选的效果。 (2) 排序 步骤1 单击工作表中带数据的单元格,选择[数据→排序]命令,在“排序”的“主要关键字”中选择“平均成绩”,在其后选中“降序”,在“次要关键字”中选择“部门”,在其后选择“升序”。 步骤2 保存文件EXC.XLS。

完形填空
A long time ago, there was an emperor. One day he told his horseman that if he could ride on his horse and 1  as much land area as he liked, he would give him the area of land he had covered.  2 enough, the horseman quickly jumped onto his horse and 3  as fast as possible to cover as much land area as he could. He 4  riding and riding, whipping the horse to go as fast as possible. Even when he was 5  and tired, he did not stop 6  he wanted to cover as much area as possible. When he at last covered a large amount of land, he was exhausted and was  7 . Then he asked himself, “Why did I 8  myself so hard to cover so much land area? Now I am dying and I only 9  a very small area to 10  myself.”
The above story is 11  to the journey of our 12 . We push ourselves very hard every day to make more  13 , to gain power or recognition. We neglect our 14 , time with our family and to appreciate the surrounding 15  and the things we love to do. One day 16  we look back, we will 17  that we don’t really need that much, 18  then we cannot turn back time for what we have 19 .
Life is not about making money. Life is definitely not about work! Work is only 20  to keep us living so as to enjoy the beauty and pleasures of life.
小题1:
A.useB.coverC.workD.get
小题2:
A.Good B.Strange C.SureD.Interesting
小题3:
A.rodeB.ranC.expandedD.struggled
小题4:
A.kept onB.asked forC.gave upD.succeeded in
小题5:
A.sadB.excitedC.confusedD.hungry
小题6:
A.butB.soC.becauseD.if
小题7:
A.sleepingB.arguingC.dyingD.smiling
小题8:
A.push B.makeC.destroyD.prove
小题9:
A.need B.have C.findD.show
小题10:
A.live B.bury C.supportD.sleep
小题11:
A.usefulB.certainC.similarD.special
小题12:
A.futureB.pastC.historyD.life
小题13:
A.friends B.progressC.discoveriesD.money
小题14:
A.healthB.career C.honorD.freedom
小题15:
A.thingsB.conditionC.peopleD.beauty
小题16:
A.beforeB.whenC.unlessD.since
小题17:
A.realizeB.regretC.apologizeD.explain
小题18:
A.orB.untilC.howeverD.but
小题19:
A.savedB.missedC.reducedD.won
小题20:
A.possibleB.probableC.necessaryD.suitable
单项选择题