问题 问答题

请在“考试项目”菜单上选择“电子表格软件使用”菜单项,完成下面的内容。
(所有的电子表格文们:都必须建立在指定的文件夹中)
在考生文件夹下创建:[作簿文件EX6.XLS,按要求在EX6.XLS中完成以下操作。
1.在sheetl工作表中建立如下内容工作表,并用公式求出每人的总评成绩,总评二平时×30%+期末×70%,表中字体设为楷体16磅,数据水平居中、垂直居中,表标题合并居中、20磅、蓝色字,并将刀:作表命名为“成绩表”。

ABCDE
1成绩表
2学号姓名平时期末总评
3188001任静7887
4188002陈东7776
5188003成刚8690
6188004段明9085
2.将成绩表复制为一张新工作表,将期末成绩在80分到89分的人筛选出来,并将工作表命名为“筛选”保存在EX6.XLS中。

答案

参考答案:

解析:①建立表格,输入数据。在E3中键入“=C3*30%+D3*70%”公式,双击此单元格,出现公式,向下拖动右下角的实心方块填充到其他需要产生结果的单元格。 ②选中表格,使用[单元格]→[单元格格式]→[字体]命令,设置字号、颜色;在[对齐]选项卡中设置水平和垂直的对齐方式。 ③选中标题,合并居中。使用[单元格]→[单元格格式]→[字体]命令设置字体格式。2. 选中筛选的数据源列,使用[数据]→[筛选]→[自动筛选]命令激活“筛选”命令。在此列的标题单元格下角出现的下拉选项中选择[自定义],打开对话框,设置筛选条件为“大于80”、“与”、“小于90”。

选择题
阅读理解

Tens of thousands of theatre tickets will be given away to young people next year as part of a government campaign to inspire a lifelong love for theatre.

The plan to offer free seats to people aged between 18 to 26—funded with £2.5 million of taxpayers’ money—was announced yesterday by Andy Burnham, the Culture Secretary. It received a cautious welcome from some in the arts world, who expressed concern that the tickets may not reach the most underprivileged.

The plan comes as West End theatres are enjoying record audiences, thanks largely to musicals teaming up with television talent shows. Attendances reached. 13.6 million in 2007, up 10 percent on 2006, itself a record year. Total sales were up 18 percent on 2006 to almost £470 million.

One theatre source criticised the Government’s priorities(优先考虑的事) in funding free tickets when pensioners were struggling to buy food and fuel, saying: “I don’t know why the Government’s wasting money on this. The Yong Vic, as The Times reported today, offers excellent performances at cheap prices.”

There was praise for the Government’s plan from Dominic Cooke of the Royal Court Theatre, who said: “I support any move to get young people into theatre, and especially one that aims to do it all over England, not just in London.”

Ninety-five publicly funded theatres could apply for funding under the two-year plan. In return, they will offer free tickets on at least one day each week to 18 to 26-year-olds, first-come, first-served. It is likely to be on Mondays, traditionally a quiet night for the theatre.

Mr. Burnham said: “A young person attending the theatre can find it an exciting experience, and be inspired to explore a new world. But sometimes people miss out on it because they fear it’s ‘not for them’. It’s time to change this perception.”

Jeremy Hunt, the Shadow Culture Secretary, said: “The real issue is not getting enthusiastic children into the theatre, but improving arts education so that more young people want to go in the first place. For too many children theatres are a no-go area.”

小题1:Critics of the plan argued that ______.

A.the theatres would be overcrowded

B.it would be a waste of money

C.pensioners wouldn’t get free tickets

D.the government wouldn’t be able to afford it小题2:According to the supporters, the plan should ______.

A.benefit the television industry

B.focus on producing better plays

C.help increase the sales of tickets

D.involve all the young people in England小题3:Which of the following is TRUE about the plan?

A.Ninety-five theatres have received funding.

B.Everyone will get at least one free ticket.

C.It may not benefit all the young people.

D.Free tickets are offered once every day.小题4:We can infer from the passage that in England ______.

A.many plays are not for young people

B.many young people don’t like theatre

C.people know little about the plan

D.children used to receive good arts education小题5:According to the passage, the issue to offer free tickets to young people seems ______.

A.controversial

B.inspiring

C.exciting

D.unreasonable