问题 问答题

在考生文件夹下创建工作簿文件EX16.XLS,按要求在EX16.XLS中完成以下操作: 1.在sheetl工作表中建立如下内容工作表,并用公式求出每人的总评成绩,总评:平时×40%+期末×60%,表中字体设为宋体16磅,数据水平居中、垂直居中,表标题合并居中、20磅、加粗,将工作表命名为“体育成绩表”,并保存为EX16.XLS。

2.将成绩表复制为一张新工作表,将期末成绩在70分到79分之间的人筛选出来,并将工作表命名为“成绩表筛选”保存在EX16.XLS中。

答案

参考答案:

解析:第1小题 建立表格,输入数据。在E3中键入“=C3*40%+D3*60%”,双击此单元格,向下拖动右下角的实心方块填充到其他需要产生结果的单元格。选中表格,使用[格式]|[单元格]|[字体]命令,设置字体的属性,在 [对齐]选项卡中设置水平和垂直的对齐方式,使用[格式]|[单元格]|[对齐]命令,合并第一行单元格,并输入“体育成绩表”。 第2小题 选中筛选的数据,使用[数据]|[筛选]|[自动筛选]命令,设置筛选条件,并保存文件。

选择题
填空题

We already live in an ever-communicated world that will only become mere so in the next tech era. We’ve (1) that gets us so much information. We’ve got every second (2) , we’ve get computers and laptops, we’ve get personal organizers and we’re just being (3) and every advance in technology seems to create more and more communications at us. We are sort of (4) .
Research suggests that all the multi-tasking may actually make our brains (5) , producing a world-wide increase in IQ (6) and mere in recent decades. Is there any real benefit in (7) we new have to go through
We’re net becoming a race of (8) , but many de think certain skills are enhanced and certain are net. You knew the ability to (9) , to answer a dozen e- mails in five minutes, or to fill out (10) . That’s enhanced. But when someone is out there with his kids (11) or something like that, he’s got his cell phone in his pocket. He’s always wondering, "Gee, did I get a voicemail " This might have negative effects (12) .
Creativity is something that happens slowly. It happens when your brain is just (13) , just playing, when it (14) which you hadn’t thought of, or maybe you have time to read a book. You are a businessperson but you have time to (15) ,or about a philosopher and something that happened long age or something or some idea (16) . Actually, it might occur to you that you (17) in that way, and so it’s this mixture of unrelated ideas that feeds your productivity, (18) . And if your mind is disciplined to answer every e-mail, then you don’t have time for that playful noodling. You don’t have time for (19) . So I think maybe we’re getting smarter in .some senses, but ever-communication is (20) and to our reflection.

We already live in an ever-communicated world that will only become mere so in the next tech era. We’ve (1) that gets us so much information. We’ve got every second (2) , we’ve get computers and laptops, we’ve get personal organizers and we’re just being (3) and every advance in technology seems to create more and more communications at us. We are sort of (4) .
Research suggests that all the multi-tasking may actually make our brains (5) , producing a world-wide increase in IQ (6) and mere in recent decades. Is there any real benefit in (7) we new have to go through
We’re net becoming a race of (8) , but many de think certain skills are enhanced and certain are net. You knew the ability to (9) , to answer a dozen e- mails in five minutes, or to fill out (10) . That’s enhanced. But when someone is out there with his kids (11) or something like that, he’s got his cell phone in his pocket. He’s always wondering, "Gee, did I get a voicemail " This might have negative effects (12) .
Creativity is something that happens slowly. It happens when your brain is just (13) , just playing, when it (14) which you hadn’t thought of, or maybe you have time to read a book. You are a businessperson but you have time to (15) ,or about a philosopher and something that happened long age or something or some idea (16) . Actually, it might occur to you that you (17) in that way, and so it’s this mixture of unrelated ideas that feeds your productivity, (18) . And if your mind is disciplined to answer every e-mail, then you don’t have time for that playful noodling. You don’t have time for (19) . So I think maybe we’re getting smarter in .some senses, but ever-communication is (20) and to our reflection.