问题 问答题

请在“答题”菜单下选择“电子表格”命令,然后按照题目要求再打开相应的命令,完成下面的内容,具体要求如下:注意:下面出现的所有文件都必须保存在考生文件夹下。

(1) 在考生文件夹下打开EXCEL.XLS文件,将Sheetl工作表的A1:F1单元格合并为—个单元格,内容水平居中;计算“总积分”列的内容(金牌获10分,银牌获7分,铜牌获3分),按递减次序计算各队的积分排名(利用RANK函数);按主要关键字“金牌”递减次序,次要关键字“银牌”递减次序,第三关键字“铜牌”递减次序进行排序;将工作表命名为“成绩统计表”,保存EXCEL.XLS文件。 (2) 选取“成绩统计表”的A2:D10数据区域,建立“簇状柱形图”,系列产生在“列”,图表标题为“成绩统计图”,图例位置置底部,将图插入到表的A12:G26单元格区域内,保存EXCEL.XLS文件。

答案

参考答案:

解析:本题分为一小题(对应excel,xls)。首先在“考试系统”中选择[答题→电子表格题→excel.xls]命令,将文档“excel.xls”打开; (1) 基本计算 步骤1 选中工作表sheetl中的A1:F1单元格,单击工具栏上的设置选中单元格合并,单元格中的文本水平居中对齐。 步骤2 在E3小输入公式“=B3*10+C3*7+D3*3”,该值出现在E3单元格中。将鼠标移动到E3单元格的右下角,按住鼠标左键不放向下拖动到E10单元格的位置,释放鼠标即可得到其他项的总分值。 (2) 使用RANK函数计算排名 步骤1 将鼠标光标定位在F3单元格中,在“编辑栏”中单击“插入函数”按钮

在弹出对话框的“选择函数”列表中的“搜索函数”一栏中输入“RANK”,并单击“确定”按钮,弹出“函数参数”对话框。此对话框中的三个输入框对应RANK函数的 3个参数。 第一个参数:是要参加排名的单元格。可以是一个单元格地址、一个数值,也可以是一个表达式。本题中,条件应该是“E3”。(即 E3中的数据去和其他数据排名) 第二个参数:是所有参加排名的单元格。本题中,应是“E3:E10”。 (即本题中,E3单元格和E3:E10区域中其他单元格对比,求出E3在此区域内的排名。) 第三个参数:决定排名升序或降序。参数为0或不填此参数,表示降序;否则是升序。本题中,应是“降序”。(所谓排名的升降序,就相当于100、200、300三个数字排名,如果按升序排名,则最小值100排名第一;如果按降序排,则最大值300为第一) 步骤2 设置完毕后,单击“确定”按钮完成F3单元格的公式输入,并将该单元格中的公式复制到其他相应单元格中。(注意:在其他单元格中复制该公式后,应修改相对单元格的地址。) (3) 数据排序 步骤1 单击工作表中带数据的单元格,选择[数据→排序]命令,在“排序”的“主要关键字”中选择“积分排名”,在其后选中“降序”。 步骤2 单击工作表中带数据的单元格,选择[数据→排序]命令,在“排序”的“主要关键字”中选择“金牌”,在其后选中“降序”;在“次要关键字”中选择“银牌”,在其后选择“降序”;在“第三关键字”中选择“铜牌”,在其后选择“降序”。 步骤3 将鼠标光标移动到工作表下方的表名处,单击鼠标右键,在弹出的快捷菜单中选择“重命名”命令,直接输入表的新名称“成绩统计表”。 (4) 新建和编辑图表 步骤1 选取“成绩统计表”的A2:D10数据区域,选择[插入→图表]命令,在弹出的“图表向导”对话框“标准类型”的“图表类型”中选择“柱形图”,在“子图表类型”中选择“簇状柱形图”。 步骤2 单击“下—步”按钮,在弹出的对话框的“系列产生”中选中“列”单选按钮,单击“下一步”按钮,在弹出的“标题”对话框“图表标题”中输入文本“成绩统计图”,在“图例”的“位置”中选择“底部”。 步骤3 单击“完成”按钮,图表将插入到表格中,拖动图表到A12:G26区域内。

单项选择题
单项选择题

Advertisers tend to think big and perhaps this is why they’re always coming in for criticism. Their critics seem to resent them because they have a flair for self promotion and because they have so much money to throw around. "It’s iniquitous," they say, "that this entirely unproductive industry (if we can call it that) should absorb millions of pounds each year. It only goes to show how much profit the big companies are making. Why don’t they stop advertising and reduce the price of their goods After all, it’s the consumer who pays... "
The poor old consumer! He’d have to pay a great deal more if advertising didn’t create mass markets for products. It is precisely because of the heavy advertising that consumer goods are so cheap. But we get the wrong idea if we think the only purpose of advertising is to sell goods. Another equally important function is to inform. A great deal of the knowledge we have about household goods derives largely from the advertisements we read. Advertisements introduce us to new products or remind us of the existence of the ones we already know about. Supposing you wanted to buy a washing machine, it is more than likely you would obtain details regarding performance, price, etc. , from an advertisement.
Lots of people pretend that they never read advertisements, but this claim may be seriously doubted. It is hardly possible not to read advertisements these days. And what fun they often are, too! Just think what a railway station or a newspaper would be like without advertisements. Would you enjoy gazing at a blank wall or reading railway bylaws while waiting for a train Would you like to read only closely printed columns of news in your daily paper A cheerful, witty advertisement makes such a difference to a drab wall or a newspaper full of the daily ration of calamities.
We must not forget, either, that advertising makes a positive contribution to our pockets. Newspapers, commercial radio and television companies could not subsist without this source of revenue. The fact that we pay so little for our daily paper, or can enjoy so many broadcast programs is due entirely to the money spent by advertisers. Just think what a newspaper would cost if we had to pay its full price !
Another thing we mustn’t forget is the "small ads" which are in virtually every newspaper and magazine. What a tremendously useful service they perform for the community! Just about anything can be accomplished through these columns. For instance, you can find a job, buy or sell a house, announce a birth, marriage or death in what used to be called the "hatch, match and dispatch" column but by far the most fascinating section is the personal or "agony" column. No other item in a newspaper provides such entertaining reading or offers such a deep insight into human nature. It’s the best advertisement for advertising there is!

Why do the critics criticize advertisers

A.Because advertisers often brag.
B.Because critics think advertisement is a "waste of money".
C.Because customers are encouraged to buy more than necessary.
D.Because customers pay more.