test2

第二部分主要经济业务的核算和成本计算

习题一

一、目的：练习材料采购业务的核算。

二、要求：根据下列资料所给的经济业务做出会计分录。

三、资料：

长征工厂为一般纳税人，适用增值税率为17%。20××年6月份发生下列材料采购业务：(1) 6月2日，红星工厂发来甲材料150吨(单价100元)，尚未验收入库。价税款及运费120元已由银行存款支付。

(2) 6月14日，企业向下列单位购入甲材料9,000元，材料尚未验收入库，价税款尚未支付。

新华工厂20吨单价100元计2,000元

大众工厂30吨单价100元计3,000元

光明工厂40吨单价100元计4,000元

(3) 6月15日, 用银行存款支付上述三个厂的火车运杂费450元(新华工厂100元，大众工厂150元，光明工厂200元)，并以现金支付市内临时工搬运费300元。

(4) 6月21日，向七一工厂购入甲材料60吨，货款6,000元，材料验收入库，运费120元，价税款及运费尚未支付。

(5) 6月24日，以银行存款支付七一工厂价税款及运杂费120元。

(6) 6月29日，从红星工厂购入原材料一批，计30，000元，验收入库，价税款未付。其中：

甲材料160吨单价100元计16,000元

乙材料1000吨单价10元计10,000元

丙材料800吨单价5元计4,000元

(7) 6月29日，购入上述原材料共支付运费900元，已由银行支付。(运杂费按所购原材料买价的比例分别计入甲、乙、丙三种原材料的采购成本)

(8) 6月2 9日，按实际采购成本结转已验收入库的材料。（作业用纸附于本章习题五后）习题二

一、目的：练习产品生产业务的核算。

二、要求：根据下列资料所给经济业务做出会计分录。

三、资料：长征工厂20××年6月份发生与产品生产有关的业务如下：

(10) 6月5日，车间职工张华因公暂借差旅费100元，财务科用现金付讫。

(11) 6月6日，开出现金支票174元购买管理部门办公用品。

(12) 6月9日，张华报销差旅费180元，交回余额20元(前借出200元)

(13) 6月17日，从银行提取现金7，000元，备发工资。

(14) 6月23日，从银行取得短期借款100,000元。

(15) 6月18日，以库存现金7,000元发放职工工资。

(16) 6月22日，用库存现金支付计划科李明同志差旅费130元(没有预借款)。

(17) 6月26日，按照规定计提本月固定资产折旧：

车间使用固定资产折旧600元

厂部使用固定资产折旧400元

合计1000元

(18) 6月27日，通过银行支付6月14日向新华工厂、大众工厂、光明工厂购进甲材料的价税款。

(19) 6月29日，计算应由本月负担的短期借款利息150元。

(20) 6月30日，本月应付的职工工资计入成本，具体资料如下：

A、生产工人工资6,000元

其中：子产品4,000元

丑产品2,000元

B、车间管理人员工资400元

C、厂部管理人员工资600元

(21) 6月30日，按工资的14%提取职工福利费。

(22) 6月30日，用银行存款支付第二季度短期借款利息450元。

(23) 6月30日，结转本月发生的制造费用总额(按生产工人工资比例分配)。

(24) 6月30日，上月投产的子产品500件本月全部完工入库，结转子产品生产总成本。(月初子产品生产成本：期初余额为22032，写出计算过程)。

注：作业用纸附于本章习题五后。

习题三

一、目的：练习产品销售的核算。

二、要求：根据下列所给资料的经济业务做出会计分录。

三、资料：长征工厂为一般纳税人，适用增值税率为17%。20××年6月份发生与产品销售有关的经济业务如下：

(25) 6月2日，销售子产品一批10件，该项货款1,500元，增值税率17%，收到对方签发商业汇票一张，票面金额为1,755元。

(26) 6月4日，用现金支付支付广告费200元。

(27) 6月6日，用银行存款支付企业专设销售机构人员的工资1000元。

(28) 6月8日，以银行存款支付上月应交税费3000元。

(29) 6月19日，销售子产品300件，价款45,000元，增值税率17%，价税款已通过银行收讫。

(30) 6月23日，销售子产品一批100件，该项货款共15,000元，增值税率17%，收到对方开具商业承兑汇票一张，票面金额为17,550元。

(31) 6月25日，销售给新风工厂子产品80件，计12,000元，增值税率17%，价税款尚未收到。

(32) 6月26日，从银行存款中支付售出子产品的运费480元。

(33) 6月27日，按销售收入总额计算本月应交城市维护建设税3,600元。

(34) 6月30日，结转销售子产品490件的制造成本58,800元。

(35) 6月30日，结转本月的主营业务收入、其他业务收入科目。

(36) 6月30日，结转本月主营业务成本、营业税金及附加科目。

(37) 6月30日，结转本月销售费用、管理费用和财务费用。

习题四

一、目的：练习利润分配的核算。

二、要求：根据下列经济业务做会计分录。

三、资料：长征工厂6月份发生与利润分配有关的业务如下：

(38) 6月25日，企业因对外投资收到其他单位分进的利润6,000元入银行。

(39) 6月28日，取得现金罚款收入258元，接受捐赠现金82,000元。

(40) 6月30日，结转本月取得的投资收益。

(41) 6月30日，结转本月取得的营业外收入。

(42) 6月30日，计算本月利润总额，并按25％的所得税率计算并结转本月所

得税费用(做出分录)。

(43) 6月30日，结转本年净利润到“利润分配”账户。

(44) 6月30日，按本月税后利润的10％计提法定盈余公积金。

(45) 6月30日，经董事会决定拟向投资者分配利润3,000元。其中应分给国家利润2,000元，应分给其他单位利润1,000元。

(46) 6月30日，用银行存款支付向投资者分配的利润3,000元。

注：作业用纸附于本章习题五后。

习题五

一、目的：练习所有者权益业务的核算。

二、要求：根据下列经济业务做会计分录。

三、资料：长征工厂6月份发生有关经济业务如下：

(47) 6月4日，国家投资20,000元，存入银行。

(48) 6月12日，收到联营单位投入设备一台，增值税专用发票上注明价款40,000元, 增值税6800元。

(49) 6月26日，经批准，以资本公积转增注册资本80,000元。

(50) 6月30日，以盈余公积10,000元转增资本。

习题用纸如下：

习题六

一、目的：练习成本计算

二、要求：

1、根据习题一所给资料，核算甲、乙、丙三种原材料的采购成本(对于共同发生的运杂费按各原材料买价比例分配)；

2、根据习题二所给资料，核算产品生产成本(对于制造成费用按生产工人工资比例分配，子产品500件本期全部完工入库，丑产品本期未完工)。（习题用纸如下）

一、材料采购成本核算

6月29日，运费分配：

①分配率=

②甲材料分配额=

③乙材料分配额=

④丙材料分配额=

(一)登记在途物资明细账

“在途物资”明细分类账户

二、产品生产成本核算

（二）分配制造费用

制造费用分配明细表

年月

（三）“生产成本”明细分类账户

产品名称：子产品产量：500件

（四）编制产品生产成本计算表

产品名称：子产品20××年6月产量：500件

剑桥雅思4Test2passage2阅读答案解析

虽然剑桥雅思已经出到了剑11，但是剑桥雅思4还是很有参考价值，今天雅思给大家带来了：剑桥雅思4Test2passage2阅读答案解析。相应的原文及翻译，请点击：剑桥雅思4Test2阅读passage2原文+译文：澳大利亚的另类疗法。更多解析，请点击：剑桥雅思4解析。剑4下载，请点击： passage1部分查看，请点击： 剑桥雅思4Test2阅读passage1原文+译文：语言的消失 剑桥雅思4Test2passage1阅读答案解析 剑桥雅思4Test2passage2阅读答案解析 Question 14 答案：C 关键词：Western 定位原文：第1段第1句“Australia has been unusual in the Western world in having a very conservative attitude to natural or alternative therapies, according to Dr Paul Laver, a lecturer in Public Health at the University of Sydney.” 解题思路：A答案说澳大利亚医生与制药公司关系紧密，属于完全未提及型答案。B答案认为澳大利亚医生总是和其他医师一同工作，与文中所说的事实恰好相反。D答案说澳大利亚医生会开出另类处方，这也是不正确的。只有C答案与文章叙述相符。 Question 15 答案：B 关键词：Americans 定位原文：第1段倒数第1句“Americans made more visits to alternative therapists than to orthodox doctors in 1990, and each year they spend about $US 12 billion on therapies that have not been scientifically tested.” 解题思路：文中这句话说1990年美国人去看另类疗法医师的次数比去看传统医生的次数还多。所以答案B是正确的。而A、C和D答案中提到的比较关系并不存在。 Question 16 答案：YES 关键词：20 years 定位原文：第2段第1句“Disenchantment with orthodox medicine has seen the

成熙英语_中级班_听力脚本

Unit 1 (1) I'm really sorry: Ted: Oh, I'm really sorry. Are you OK? Ana: I'm fine. But I'm not very good at this. Ted: Neither am I. Say, are you from South America? Ana: Yes, I am originally. I was born in Argentina. Ted: Did you grow up there? Ana: Yes, I did, but my family moved here eight years ago when I was in high school. Ted: And where did you learn to rollarblade? Ana: Here in the park. This is only my second time. Ted: Well, it's my first time. Can you give me some lessons? Ana: Sure. Just follow me. Ted : By the way, my name is Ted. Ana: And I'm Ana. Nice to meet you. Hey, hey! that was fun Ted: Hey, hey! that was fun. Thank you for the lesson! Ana: No problem. So, tell me a little about yourself. What do you do? Ted: I work in a travel agency. Ana: Really! What do you do there? Ted: I'm in charge of their computers. Ana: Oh, so you're a computer specialist. Ted: Well, sort of. Yeah, I guess so. Ana: That's great. Then maybe you can give me some help with a computer course I'm taking. Ted: Oh, sure...But only if you promise to give me some more rollarblading lessons. Ana: It's a deal! (2) Where are you from originally, Yu Hong Interviewer: Where are you from originally, Yu Hong? Yu Hong: I'm from China...from near Shanghai. Interviewer: And when did you move here? Yu Hong: I came here after I graduated from college. That was in 1992. Interviewer: And what do you do now? Yu Hong: I'm a transportation engineer. Interviewer: I see. So you 're an immigrant to the United States. Yu Hong: Yes, that's right. Interviewer: What are some of difficulties of being an immigrant in the U.S.? Yu Hong: Oh, that's not an easy question to answer. There are so many things,

数学选修2-2练习题及答案

目录：数学选修2-2 第一章 导数及其应用 [基础训练A 组] 第一章 导数及其应用 [综合训练B 组] 第一章 导数及其应用 [提高训练C 组] 第二章 推理与证明 [基础训练A 组] 第二章 推理与证明 [综合训练B 组] 第二章 推理与证明 [提高训练C 组] 第三章 复数 [基础训练A 组] 第三章 复数 [综合训练B 组] 第三章 复数 [提高训练C 组] （数学选修2-2）第一章 导数及其应用 [基础训练A 组] 一、选择题 1．若函数()y f x =在区间(,)a b 内可导，且0(,)x a b ∈则000()()lim h f x h f x h h →+-- 的值为（ ） A ．'0()f x B ．'02()f x C ．'02()f x - D ．0 2．一个物体的运动方程为21t t s +-=其中s 的单位是米，t 的单位是秒， 那么物体在3秒末的瞬时速度是（ ） A ．7米/秒 B ．6米/秒 C ．5米/秒 D ．8米/秒 3．函数3y x x =+的递增区间是（ ） A ．),0(+∞ B ．)1,(-∞ C ．),(+∞-∞ D ．),1(+∞ 4．32()32f x ax x =++,若'(1)4f -=,则a 的值等于（ ） A ．319 B ．3 16 C ． 313 D ．310 5．函数)(x f y =在一点的导数值为0是函数)(x f y =在这点取极值的（ ） A ．充分条件 B ．必要条件 C ．充要条件 D ．必要非充分条件 6．函数344 +-=x x y 在区间[]2,3-上的最小值为（ ） A ．72 B ．36 C ．12 D ．0 二、填空题 1．若3'0(),()3f x x f x ==，则0x 的值为_________________； 2．曲线x x y 43 -=在点(1,3)- 处的切线倾斜角为__________；

(完整版)初三化学实验操作题专项练习

1 化学实验操作题专项练习 17．（11分）某二氧化锰样品中含有杂质炭，为测定该样品中二氧化锰的质量分数，某兴趣小组设计了如下实验方案：在一定量的样品中通入干燥纯净的氧气，使杂质炭在加热条件下反应生成CO 2来进行分析测定。 （1）仪器①的名称是 。如果该实验选择图（一）装置来制取氧气，则所反应的化学方程为 。其中二氧化锰的起到 作用。 （2）用图（二）装置可收集和干燥氧气：若烧瓶充满水来收集氧气，气体应从 (“a”或“b”）端通入。 （3）图（三）是用干燥纯净的O 2与样品反应来测定二氧化锰质量分数的装置，装置③中装有碱石灰，其作用是________________________________。 （4）为验证图（三）中装置②已将CO 2吸收完全，可在装置②与③之间加 入图（四）装置进行证明，则图（四）装置中加入的试剂为___（填字母）。 A. NaOH 溶液 B. 澄清石灰水 C. 浓硫酸 五、（本题1个小题，共16分） 18.某化学兴趣小组有一次活动的内容是：对一包干燥的红色粉末组成进行 探究请你参与并回答有关问题。 【教师提醒】它由Cu 、Fe 2O 3 、Fe(OH)3三种固体中的一种或两种组成。 【提出猜想】红色粉末可能的组成有： ①只有Cu ②只有Fe 2O 3 ③只有 Fe(OH)3 ④是Fe 2O 3与Fe(OH)3的混合物 ⑤是Cu 与Fe 2O 3的混合物 ⑥是Cu 与Fe(OH)3的混合物 【资料获悉】 ⑴ ⑵白色无水CuSO 4遇水变蓝； ⑶Cu 在FeCl 3溶液中发生反应：2FeCl 3＋Cu ＝2FeCl 2＋CuCl 2。 【探究思路】利用物质的性质不同设计实验加以甄别，先分别探究其中是否含有Fe(OH)3 、Cu 等，逐步缩小范围，然后再选择适当的试剂和方法通过实验探究其组成。（装置内空气中的水蒸气、CO 2忽略不计） 【实验探究】 ⑴甲同学取适量红色粉末装入试管中，按下面左图进行实验。结果无水CuSO 4没有变蓝，从而排除猜想中的 （填猜想中的序号）。 ⑵在甲同学实验结论的基础上，乙同学另取少量红色粉末于试管中， 滴加足量稀盐酸，振荡后观察，发现固体全部溶解，溶液变色。乙同学认为可以排除猜想中的①和⑤，而丙同学认为只能排除猜想①，你认为 的观点正确（填“乙”或“丙”）。 ⑶丁同学为进一步确定红色粉末的组成，称取该粉末5.0g 装入硬质玻 璃管中，按上面右图在通风橱中进行实验。开始时缓缓通入CO 气体，过

英语听力_作业二(test2)

英语听力作业（二） T e s t2 Part A. Short Conversations Directions: In this part, you will hear 5 short conversations. At the end of each conversation, a question will be asked about what was said. The conversation and the question will be spoken only once. 1. A. Write a letter. √B. Fix a bookshelf. C. Paint the bookshelf. D. Search for a pen. 2. √A. She is an engineer. B. She is a mathematician. C. She is the manager of a company. D. She is an artist. 3. A. She has gone home. B. She has gone out for a walk. C. She is getting a newspaper. √D. She is at a store. 4. A. 1 5. B. 50. √C. 85. D. 100. 5. A. The new teacher is sick. √B. She hasn't met the new teacher yet. C. There are three new teachers. D. She didn't like the new teacher. Part B. Longer Conversations Directions: In this part, you will hear 2 conversations. At the end of each conversation, two questions will be asked about what was said. The conversation and the questions will be spoken only once. Question 6 and 7 are based on the following conversation. 6. A. Father and daughter. √B. Doctor and patient. C. Teacher and student. D. Shopkeeper and shopper. 7. A. In a few days. B. Very slowly. √C. Before leaving the office. D. In a moment. Question 8 and 9 are based on the following conversation. 8.√A. Type his paper. B. Help him with his research. C. Present his findings at the July conference. D. Organize all the notes. 9. A. February. B. July. C. September. √D. May. Part C. Passages Directions: In this part, you will hear 2 passages. At the end of each passage, three questions will be asked about what was said. The conversation and the questions will be spoken only once. Question 10 to 12 are based on the following passage. 10. A. Very well. B. Just so-so. C. Excellently. √D. Terribly. 11. A. Found a job in a big company. √B. Tried to get a job.

第二版本科英语test1和test2答案

英语 TEST 1 Part I 听力题没有题所以没有答案 Part II 16-25 DAAACBBACD 26 yourself 27 sending 28 traditional 29 solution 30 analysis 31 Personally 32 told 33 able 34 stores 35 be sure Part III 36-40 ADACB 41-45 CACAD 46 The two styles of job interviewing 47 The traditional job interview 48 the behavioral interview 49 Ability to communicate than on the truthfulness or content of his answer. 50 Past performance is the best indicator of future behavior. 51 贸易逆差（M-trade gap）分期付款（I-installment） 52 商标（N-trade mark ）交易会（G-fair，书上印刷错误有2个G） 53 关税（C-customs duty）合同（A-contract） 54 申报价值（E-declared value）免税入境（F-duty-free entry） 55 还盘（B-counter-offer）装运（K-shipment） 56 Hiram B.Rogan 57 The Chief Executive of Bubble Recordings 58 He is one of our best customers in the states. 59 He is coming over to see our working methods. 60 He has to arrange a top singer or group to make records when Mr.Rogan comes and sees 61-64 CAAD 65 尊敬的怀特先生, 非常感谢你上周五精彩的演讲。我代表中心的全体师生写信给你。我们很喜 欢你上周的演讲。我们最近也了解了一下近年来国际IT市场发展的趋势，十 分感谢你能来到我们学校，给我们带来了如此生动和有意义的演讲。再次感 谢，希望期待你的下次演讲。 真诚地 李明 Part V Dear Mr. Jackson, I hope you are still keeping well and that business is prospering. I'm writing to see if you can help me. Mr.Zhang has just taken the place of Mr. Wang to be the international sale's manager in your company.He is familar with American market，and will visit America lately,mainly stay in Washington，Please take care of him. Thank you . I hope to hear from you soon. Yours Sincerely Li Ming

成熙英语高级文本

Unit1 That's what friends are for. you have a date for the party yet Do you have a date for the party yet Actually,I don't. Do you know anyone I could go with em..what kind of guys do you like oh,I like guys who aren't too serious,and who have a good sense of humor. You know,someone like you. okay,erm,what else Well I prefer someone I have something in common with,who i can talk to easily. I think i know just the guy for you,Bob.. Do you know him

No,i don't think so. okay,I'll ask him to meet us for coffee,and you can tell me what you think. ,what's the verdict So,what's the verdict What did you think of Bob Well,I was worried at first,especially when I saw that he rode a huge motorcycle. I thought he might turn out to be one of those guys who is into heavy metal music and stuff like that. You know what I mean But he is just a regular kind of guy right Yeah,we got along really well. I knew you'd like him!

《计算机应用基础》综合练习题(二)及答案

《计算机应用基础》综合练习题（二）及答案 第1题、在Internet Explorer中，将https://www.wendangku.net/doc/1c11287856.html,加入可信站点，通过管理员认可，才能运行可信站点中的ActiveX控件和插件。 第1题操作步骤： 1．选择“开始”菜单中“设置”子菜单中的“控制面板”命令，打开“控制面板”窗口。2．在“控制面板”窗口中单击“网络和Internet连接”。 3．在“网络和Internet连接”窗口中单击“Internet选项”，打开“Internet属性”对话框。 4．打开“安全”选项卡，单击“受信任的站点”图标。 5．单击“站点”按钮，打开“可信站点”对话框。 6．在文本框中输入https://https://www.wendangku.net/doc/1c11287856.html,，单击“添加”按钮。 7．单击“确定”按钮，返回“Internet属性”对话框。 8．在“Internet属性”对话框中，单击“自定义级别”按钮，打开“安全设置”对话框。9．在“运行ActiveX控件和插件”下选择“管理员认可”选项，单击“确定”按钮，返回“Internet属性”对话框。 10．单击“Internet属性”对话框中的“确定”按钮，操作完成。 第2题、将InternetExplorer设置为取消智能图像抖动，不显示图片，不在媒体栏中显示联机媒体内容。 第2题操作步骤： 1．打开InternetExplorer。 2．选择“工具”菜单中的“Internet选项”命令，打开“Internet属性”对话框。 3．选择“高级”选项卡，取消“多媒体”栏下的“智能图像抖动”选项；取消“多媒体”栏下的“显示图片”选项；选中“多媒体”栏下的“不在媒体栏显示联机媒体内容”选项。4．单击“确定”按钮，操作完成。 第3题、为了更好地管理OutlookExpress发送的邮件，请做如下设置：自动将我的回复对象添加到通讯簿，在撰写邮件时自动完成电子邮件地址，将发送国际邮件时的默认编码设置为日文(JIS)，回复邮件时总是使用英文标头。 第3题操作步骤： 1．打开OutlookExpress。 2．选择“工具”菜单中的“选项”命令，打开“选项”对话框。 3．选择“发送”选项卡，选中“自动将我的回复对象添加到通讯簿”和“在撰写邮件时自动完成电子邮件地址”两个选项。

操作题练习题题目

信息技术学业水平测试考前上机练习操作题及操作要点 ?WORD操作题： 其它：项目符号和编号（选中段落，“格式”菜单—项目符号和编号：选择要求样式） 首字下沉（选中文字，“格式”菜单—首字下沉：选择下沉样式及行数等） 文字替换（选中替换范围，“编辑”菜单下“替换”，“查找内容”输入原来的字，“替换为”中输入换后的字） ?Excel操作题目：.打开“..\素材\excel\”文件夹中的文件“高一期中考试成绩统计表.xls”进行下 面操作并保存。 1、将单元格A1:I1(表示从A1单元格到I1单元格所有的单元格都选中)合并居中(单击“格式”工

具栏上）； 2、标题“高一（5）班期中考试成绩统计表”设为黑体，加粗，20号，红色；（格式菜单—单元格—字体）； 3、将单元格A2:I12内的数据设为水平居中，加内边框线为绿色单实线、加外边框为红色双实线(把相应单元格选中，格式菜单---单元格--对齐，水平居中，垂直居中，边框，外边框，内部)； 4、设第一行的行高为30，其他行为20（选中第一行，格式--行--行高）； 5、利用公式法计算每个人的总分（先选中I3单元格，输入公式“=c3+d3+e3+f3+g3+h3”，敲回车键，其他人的总分不用计算，把鼠标放在I3单元格右下角，鼠标变成+，向下拖动鼠标，覆盖需要应用公式的区域再松开）； 6、利用函数计算“学科平均分”（先选中c15单元格，插入---函数，average（c3:c12）,确定，其他人的平均分不用计算，向下拉加号即可。），保留一位小数（把平均分单元格都选中，格式菜单—单元格，数字选项卡，左侧选“数值”，小数位数为1）；计算“最高分”，“最低分”（插入---函数[求和sum，计数count，最大值max，最小值min（若找不到须先选“所有函数）]）。计算时注意数据区域要选对 7、将A3:A12数据格式为文本，并在“学号”列输入“04-501,..." （把A3:A12单元格选中，格式菜单---单元格，数字，文本，先输入04-501，向下拉+ ，产生其他学号）; 8、将A2:I12的数据拷贝到sheet2中，按总分进行降序排列（选中A2:I12,数据---排序，主要关键字：总分，降序）； 9、sheet1更名为“运算”，sheet2更名为“排序”，sheet3更名为“图表”（把窗口左下角的sheet1选中，单击鼠标右键，重命名,其它相同）； 10、“运算”工作表中的数据以“总分”列作簇状柱形图，系列产生在列，“姓名”列区域为分类（X）轴标志，图表标题为“成绩图”，不显示图例，最后将图插入到“图表”工作表中。(先选中I3到I12单元格，插入---图表，柱形图—下一步—系列产生在“列”；“系列”选项卡下，分类（X）轴标志点右边折叠按钮，拖动选择B3:B12—下一步—图表标题；图例—下一步—作为对象插入到“图表”工作表中—完成。)； 11、将“运算”工作表中，语文大于70的数据用红色粗体来表示（把c3到c12单元格选中，格式--- 条件格式-“单元格数值”、“大于”、输入数值；“格式”按钮设置红色粗体） 12、筛选：在“排序”工作表中筛选出总分大于450分的学生（先选中A2:I12单元格，数据菜单---筛选--自动筛选，点击总分右边的小按钮，在下拉列表中选择自定义，总分大于，从键盘输入450，确定） 13、在“运算”工作表中，以班级为分类字段，按总分求和分类汇总（目的是得到每个班学生总分的和）（注意：分类汇总前请先按分类字段，即班级排序，然后选定A2：J12单元格，然后数据菜单--- 分类汇总，分类字段：班级，汇总方式：求和，选定汇总项：总分） 14.其他：将工作表的视图显示比例设为"125%"（视图菜单，显示比例） 15.将文件以原文件名另存为在"" d:\SaveAs\"文件夹中。("SaveAs"文件夹如不存在请考生自建)。 （“文件”菜单下“另存为“命令——按要求选择另存的路径（若需新建，使用”新建文件夹 “按钮）、另存文件名） 16.将页面的方向设为纵向，上、下、左、右页边距设为3，页眉和页脚边距设为3。（文件菜单—页面设置。） 其它：插入行（插入菜单—行，默认插入行在选定行的上方），输入文字（双击单元格，输入） ●筛选功能是在工作表中只显示符合设定筛选条件的行，而隐藏其他行。选中数据区→“数据”菜单→“筛选”命令→“自动筛选”子命令→单击指定字段右侧的下拉箭头→选择筛选条件或者自定义（与：表示两个条件都得满足；或：表示两个条件满足其中一个即可）； ●分类汇总是对数据进行分析研究的一种方法，可使数据按照不同的类别进行求和、求平均值、求

高中英语听力强化训练 Test 2英语听力

听力强化训练Test 2 http:///res/2007-12-28/r291382.html 请点击此地址下载播放器播放英语听力 听力理解 第一节（共5小题；每小题1.5分，满分7.5分） 听下面5段对话，每段对话后有一个小题，从题中所给的A、B、C三个选项中选出最佳选项，并标在试卷的相应位置。听完每段对话后，你都有10秒钟的时间来回答有关小题和阅读下一小题。每段对话仅读一遍。 1. What’s true about John? A. John caught a cold while he was helping the man and the woman. B. John did not help us because it was too cold. C. John did not help us because of his cold. 2. What does the man mean? A. Some places are better to practise driving than the shopping center. B. He drives to the shopping center to buy things he wants. C. The shopping center is the best place to practise driving. 3. What does the woman suggest? A. Buying a new car. B. Buying a used car. C. Borrowing some money. 4. What does the woman mean? A. Size 7 is better than size 6. B. This style runs a little smaller than usual. C. They have only size 7 in this style. 5. What do we learn from the conversation? A. The man did not ask the secretary. B. The man had asked the secretary but she did not tell him about the meeting. C. The secretary told him about the meeting although he did not ask her. 第二节（共15小题；每小题1.5分，满分22.5分） 听下面5段对话或独白。每段对话或独白后有几个小题，从题中所给的A、B、C三个选项中选出最佳选项，并标在试卷的相应位置。听每段对话或独白前，你将有时间阅读各个小题，每个小题5秒钟；听完后，各小题将给出5秒钟的作答时间。每段对话或独白读两遍。 听第6段材料，回答6～8题。 6. Why does the man feel tired? A. Because he worked hard on the report. B. Because he went away for a couple of days. C. Because he didn’t sleep well the night before. 7. What does the woman suggest? A. The man should take a rest. B. The man should take exams. C. The man should work hard on his report.

大英综合3Test2答案

综合B3Test2答案( 60minutes ) Part I Reading Comprehension ( 25minutes ) Passage One There was one shop in the town of Mufulira that was notorious (臭名昭著的；臭名远扬的) for its color bar. It was a drugstore. While Europeans were served at the counter, a long line of Africans queued at the window and often not only were kept waiting but, when their turn came to be served, were rudely treated by the shop assistants. One day I was determined to make a public protest against this kind of thing, and many of the schoolboys in my class followed me to the store and waited outside to see what would happen when I went in. I simply went into the shop and asked the manager politely for some medicine. As soon as he saw me standing in the place where only European customers were allowed to stand he shouted at me in a bastard (杂种的，不纯粹的；伪的，假的；奇形怪状的，异常的) language that is only used by a boss when speaking to his servants. I stood at the counter and politely requested in English that I should be served. The manager became exasperated (愤怒的，恼火的) and said to me in English, "Even if you stand there till Christmas I will never serve you." I went to the District Commissioner’s office. Fortunately the District Commissioner was out, for he was one of the old school; however, I saw a young District Officer who was a friend of mine. He was very concerned to hear my story and told me that if ever I wanted anything more from the drugstore all I had to do was come to him personally and he would buy my medicine for me. I protested that that was not good enough. I asked him to accompany me back to the store and to make a protest to the manager. This he did, and I well remember him saying to the manager, "Here is Mr. Kaunda who is a responsible member of the Urban Advisory Council, and you treat him like a common servant." The manager of the drugstore apologized and said, "If only he had introduced himself and explained who he was, then, of course I should have given him proper service." I had to explain once again that he had missed my point. Why should I have to introduce myself every time I went into a store … any more than I should have to buy my medicine by going to a European friend? I want to prove that any man of any color, whatever his position, should have the right to go into any shop and buy what he wants. 1. Color bar in the first paragraph comes closest in meaning to _____. A) a bar which is painted in different colors B) the fact that white and black customers are served separately C) a bar of chocolate having different colors D) a counter where people of different colors are served with beer 2. The writer was, at the time of the story, _____. A) a black, but a member of the Urban Advisory Council B) an African servant C) a black, but a friend of the drugstore manager D) a rich black 3. The manager of the drugstore shouted at the writer in a bastard language because _____. A) he hadn’t learned to speak polite English B) he thought the writer wouldn’t understand English C) that was the usual language when speaking to Africans D) that was the only language he could speak when he was angry 4. In the third paragraph, "he was one of the old school" means _____. A) he believed in the age-old practice of racial discrimination B) he was a very old man C) he graduated from an old, conservative school D) he was in charge of an old school 5. Why didn’t the writer wait at the window of the drugstore like other black Africans? A) Because he thought he was educated and should be treated differently. B) Because he thought, being an important person, he should not be kept waiting.

成熙英语_中级班_听力脚本(新版)

成熙英语中级班听力脚本（剑桥二） 1.Break the Ice (1) Oh,I’m really sorry: Ted: Oh, I'm really sorry. Are you OK? Ana: I'm fine. But I'm not very good at this. Ted: Neither am I. Say, are you from South America? Ana: Yes, I am originally. I was born in Argentina. Ted: Did you grow up there? Ana: Yes, I did, but my family moved here eight years ago when I was in high school. Ted: And where did you learn to rollarblade? Ana: Here in the park. This is only my s econd time. Ted: Well, it's my first time. Can you give me some lessons? Ana: Sure. Just follow me. Ted : By the way, my name is Ted. Ana: And I'm Ana. Nice to meet you. (2) Hey, hey! that was fun Ted: Hey, hey! that was fun. Thank you for the lesson! Ana: No problem. So, tell me a little about yourself. What do you do? Ted: I work in a travel agency. Ana: Really! What do you do there? Ted: I'm in charge of their computers. Ana: Oh, so you're a computer specialist. Ted: Well, sort of. Yeah, I guess so. Ana: That's great. Then maybe you can give me some help with a computer course I'm taking. Ted: Oh, sure...But only if you promise to give me some more rollarblading lessons. Ana: It's a deal! (3) Yuhong the Immigrant. Interviewer: Where are you from originally, Yu Hong? Yu Hong: I'm from China...from near Shanghai. Interviewer: And when did you move here? Yu Hong: I came here after I graduated from college. That was in 1992. Interviewer: And what do you do now? Yu Hong: I'm a transportation engineer. Interviewer: I see. So you 're an immigrant to the United States. Yu Hong: Yes, that's right. Interviewer: What are some of difficulties of being an immigrant in the U.S.? Yu Hong: Oh, that's not an easy question to answer. There are so many things, really. I