中职计算机英语基础试卷(无答案版)
中职—基础英语试卷
2013年上学期期终考试试卷班级姓名计分一、找出相应的单词 ,把序号填在括号内。
（20分）（ A ）1、火焰 A、fame B、 flame C、game（ C ）2、奖章 A、check B、catch C、medal（ A ）3、欺骗 A、cheat B、fool C、guess（ B ）4、申请 A、express B、apply C、launch（ C ）5、习惯 A、mascot B、track C、custom（ C ）6、牛排 A、race B、taste C、steak（ B ）7、经历 A、practice B、experience C、develop （ A ）8、技能 A、technique B、trouble C、embarrass （ B ）9、假装 A、trust B、pretend C、local（ B ）10、祝福 A、luck B、blessing C、figure二、找出相应的短语，把序号填在括号内。
（20分）（ E ）11、pass by a shop A、非常成功（ F ）12、can't help doing B、上体育课（ J ）13、to tell the truth C、在 ...上有困难（ C ）14、have truble with D、求助（ G ）15、with these words E、经过一家商店（ I ）16、take part in the Games F、禁不住（ A ）17、a great success G、说完这些话（ H ）18、visit another country H、去另一个国家（ D ）19、ask for help I、参加比赛（ B ）20、have sports J、说实话三、选择合适的单词或短语的序号填在横线上（20分）A. stand forB.rush intoC.had betterD.can't helpugh atF.on timeG.waiting forH.take part inI.have truble withJ.tip( I )21.If you still______________ your French, you can'tgo to France with us.( J )22.Did you ______________the waiter when you wereeating in the restaurant?( C )23.It was pretty cold outside. You ____________takeyour overcoat with you.( E )24.We can't ___________our friends when they makemistakes.( B )25.When the bell rings, the students will___________the classroom as quickly as they can.( G )26.Many people are ______________the bus at the busstop.( A )27.The five mascots ______________differentblessings in Chinese culture.( H )28.A great many athletes will _____________the 2008Beijing Olympic Games.( D )29.People _______________cheering when they arewatching a football match.( F )30.In order to get to school ________________, we tooka taxi.四、选择最佳答案，把序号填在括号内。
中职计算机英语练习册答案
中职计算机英语练习册答案练习一：词汇匹配1. Hardware - 硬件2. Software - 软件3. Operating System - 操作系统4. Application - 应用程序5. Database - 数据库6. Network - 网络7. Interface - 界面8. Algorithm - 算法9. Compiler - 编译器10. Encryption - 加密练习二：选择题1. What is the most commonly used operating system in the world?A. WindowsB. LinuxC. MacOSD. AndroidAnswer: A2. Which of the following is not a programming language?A. PythonB. JavaC. PhotoshopD. C++Answer: C3. What does CPU stand for?A. Central Processing UnitB. Central Power UnitC. Central Printing UnitD. Central Processing UnitAnswer: A4. What is the function of a database?A. To store dataB. To encrypt dataC. To compile codeD. To design graphicsAnswer: A5. What is the purpose of a compiler?A. To translate high-level code into machine codeB. To encrypt dataC. To design graphicsD. To store dataAnswer: A练习三：填空题1. A computer virus is a type of malicious software that can replicate itself and cause damage to a computer system.2. The term "byte" is a unit of digital information that typically consists of 8 bits.3. A web browser is a software application used to access anddisplay web pages over the Internet.4. The process of converting data into a secret code is known as encryption.5. A spreadsheet is a computer application used for organization, analysis, and storage of data in tabular form.练习四：阅读理解Read the following passage and answer the questions:In the modern world, the use of computers and the Internet has become an integral part of our daily lives. From personal communication to business transactions, the digital world has transformed the way we interact and operate. The Internet, in particular, has opened up a new realm of possibilities, connecting people across the globe and providing access to a wealth of information.1. What is the main topic of the passage?Answer: The main topic of the passage is the impact of computers and the Internet on daily life.2. What has the Internet done for personal communication and business transactions?Answer: The Internet has transformed the way we communicate and conduct business by connecting peopleglobally and providing access to a wealth of information.3. What does the passage suggest about the Internet?Answer: The passage suggests that the Internet has opened up new possibilities and plays a significant role in ourdaily interactions and operations.结束语通过以上练习，我们希望能够帮助中职学生更好地掌握计算机英语的基本知识和技能。
中职英语基本版（基础模块1）期末试题（卷）
中职英语基本版（基础模块1）期末试题（卷）10、11级英语（基本版）期末考试卷班级姓名一、Fill in the blanks with proper words and proper phrases.用适当的单词和短语填空。
（15分）（一）单词（10*1=10）1、瓷器＿＿2、电梯＿＿3、球门＿＿4、饭店＿＿5、点餐＿＿6、钓鱼＿＿7、喜好＿＿8、下雪的＿＿9、购物＿＿10、电子邮件＿＿（二）短语(英汉互译)（5*1=5）1、职业学校2、check out3、去饭店吃饭4、throw in5、留神，小心二、Match the words to their definitions. 连接相应的单词和释义，把正确答案写在括号内。
（5*2=10）( ) 1. player A taking care( ) 2. menu B someone who takes part in a game or sport( ) 3. favorite C. person or thing that one likes more than anythingelse( ) 4.careful D. a list of the dishes served in a restaurant( ) 5.invite E. ask someone to come三、Choose the proper answer to complete the sentences. 从所给单词中选择适当的单词完成句子。
（5*2=10）f ee waitress engineer delicious hostess1. My father builds roads. He is a(n) ＿＿.2. If you want to join a club, you need to pay some ＿＿for membership.3. Chinese food is very ＿＿, and many westerners like it.4. My mother was the ＿＿at the garden party.5. A ＿＿came to the table to take our order.四、Choose the proper sentences to fill in the blanks in the coversation.选择正确的句子完成对话。
职高计算机英语期末考试试卷
2012-2013学年第二学期13级计算机英语期末考试试卷一、写出所给出的英语单词的中文意思(10分)1. library2. hamburger3. dining hall4. vocational5. dormitory6. teaching building7. playground 8. favorite9. retired worker 10. gift二、按要求改写单词（10分）1. she________(宾格)2. country_________（复数）3. close__________(现在分词)4. three________(序数词)5. China__________（形容词）6. I _______ （名词性物主代词）7. potato ______(复数)8. swim ________（现在分词）9.photo________（复数）10.child _______(复数)三、选择题（30 分）( ) (1). I get up _______ about seven fifty -five .A. inB. onC. atD. for( ) (2). Why are you looking at _______like that?A. IB. mineC. myD. me( ) (3). I want _______ a map of China .A. buyB. is buyingC. to buyD. am buying( ) (4). Is it a picture ______ your school ？A. ofB. toC. andD. with( ) (5). Do you like _______ ?A. swimB. swimmingC. are swimmingD. swim, too( ) (6). The man ______ a book in his hand is my uncle .A. andB. ofC. withD. for( ) (7). Who‟s the lady ______ blue ?A. inB. onC. atD. with( ) (8). We usually stay _____ home ____ Saturday afternoon .A. at…inB. at…onC. in…atD. on…on( ) (9). A: It‟s a white shirt , is it yours ? B: No, ____ is yellow .A. IB. MyC. MineD. Me( ) (10). ______ any men in the room ?A. Is th ereB. Are thereC. There aren‟tD. There isn‟t ( ) (11). The bed ______ the right is yours .A. onB. inC. atD. of( ) (12). Look at _______ picture .A. oneB. the oneC. firstD. the first( ) (13). These books are my _______ .A. st udentsB. students‟sC. students‟D. students of ( ) (14). My parents often tell me ______ your family .A. aboutB. fromC. forD. by( ) (15). ______ any food in the fridge ？A.Are thereB. Is thereC. HaveD. Has四、阅读理解（20分）ADear Anna,Thanks for your letter. I‟m glad you like your school. I go to school from Monday to Friday. We have five classes in the morning and two in the afternoon. And we have many subjects to learn: Chinese, math, English, P.E., science, biology, music, history and so on. We also have many things to do after class. On Monday and Wednesday afternoons we play sports after class. On Tuesday afternoons some of us have a drawing class, and on Thursdays some have a dancing class. I like music, history and English. But my favorite is music.On Saturdays and Sundays I don‟t go to school. Usually I go to the park and have a good time with my father and mother there.Love,Lin Fang ( ) 1. Lin Fang has classes a day.A. fiveB. twoC. seven( ) 2. Some students on Tuesdays.A. play sportsB. have a drawing classC. have a dancing class ( ) 3. Anna likes .A. historyB. P.E.C. her school( ) 4. Lin Fang likes best.A. musicB. EnglishC. history( ) 5. Lin Fang spends the weekends with in the park.A. AnnaB. her classmatesC. her parentsBA very strict officer was talking to some new soldiers whom he hadto train. He had never seen them before, so began, “My name is Stone, and I‟m even harder than stone, so do what I tell you or there‟ll be trouble. Don‟t try any tricks (诡计) with me, and then we‟ll get on well together.” Then he went to each soldier one after the other and asked him his name, “Speak loudly so that everyone can hear you clearly,”he said, “and don‟t forget to call me …sir‟.”Each soldier told him name, until he came to the last one. This man remained silent. and so Captain Stone shouted at him, “when I ask you a question, answer it! I‟ll ask you again：What‟s your name, soldier?”The soldier was very unhappy, but at last he replied, “My name‟s Ston ebreaker, sir,” he said nervously.6. The officer was strict（）A.because the soldiers were newB.with anyof his soldiers,new or old.C.because he was named Stone.D. only when he was before soldiers.7. According to what the officer said, （）A. obeying his orders would sometimes bring no trouble.B. trouble would come if anybody made tricks.C. he always got on well with his soldiers.D. he often had trouble with his soldiers.8. The last soldier remained silent because （）A. he didn‟t lik e the way the officer spoke to them.B. he wanted to see what would happen if he disobeyed his order.C. the question was difficult for him to answer.D. he was afraid the officer would be angry when he heard his name.9. According to the officer, how to answer the question,“How old are you ?”（）A. (sadly)Twenty, sir.B. (clearly)Twenty.C. (loudly)Twenty, sirD. (quickly)Ten years younger than you, sir10. Which is the best title (题目) for the passage? （）A. A Clever AnswerB. A Terrible AnswerC. A Sorry AnswerD. A Strange Answer五、根据问话选择正确的答语（１０分）（）1.Are you Li Ming?（）2.What‟s she doing?（）3.How old are you?（）4.Who‟s this little girl?（）5.Would you like to talk to the baby?A.I‟m ten.B.Yes. I am.C.Yes, I‟d love toD.She‟s reading a story book.E.Shie is Jenny.六、写出下列缩写词的中文意思（20分）1.PRC2.PC3.KFC4.a.m.A6.VIP7.WWW8.ATM9.CPU10. MTV答题卡一、写出所给出的英语单词的中文意思(10分)1. 2. 3. 4.5. 6. 7. 8.9. 10.二、按要求改写单词（10分）1. 2. 3. 4.5. 6. 7. 8.9. 10.三、选择题（30 分）1-5 6-10 10-15 四、阅读理解（20分）1-5 6-10五、根据问话选择正确的答语（１０分）1-5六、写出下列缩写词的中文意思（20分）1. 2. 3. 4.5. 6. 7. 8.9. 10.。
技工学校电脑英语期末考试试卷
省机械高级技工学校潮州分校11计网班《计算机英语》期末考试卷班级姓名座号成绩题号一二三四五六评分得分一、单项选择，请为下列问题选择正确的答案，并将答案的字母写在题号前。
(每题1.5分，共15分) ( )1.The typical interface elements include prompts, wizard, commands, and so on. A. keyboard B. menu C. text D. mouse ( )2.A (An) is a collection of micro c ircuit elements such circuit elements such a s as as wires, transistors, capacitors wires, transistors, capacitors and registers packed on a very small square of silicon. A. CPU B. IC C. RAM D. ROM ( )3.A(An) can give graphical prompt to help users perform tasks. A. prompt B. command-line C. icon D. wizard ( )4.A(An) provide more commands when users make a selection from the main menu. A. dialog box B. icon C. submenu D. prompt ( )5.T o use use a a interface, interface, users users users have have have to to to input input input various various various commands commands commands correctly, correctly, correctly, or or or an an an error error message appears on the screen. A.GUI B. command-line C. menu D. dialog box ( )6. GUI users as the basic interface element and users can manipulate the small icon on the screen instead of entering commands or selecting menu options. A. commands B. prompts C. graphical objects D. natural voice ( )7. )7. Unlike Unlike Unlike clumsy clumsy clumsy operation operation operation of of of command-line, command-line, command-line, the the interface interface makes makes makes it it it easier easier easier for for for users users users to to input a command to the computer. A. prompt B. menu C. character D. natural language ( )8. )8. The The code code uses uses uses seven seven seven bits bits bits to to to represent represent represent 128 128 128 symbols, symbols, symbols, including including including upper upper upper case case case and and lowercase letters, special control codes, numerals, etc. A. EBCDIC B. binary C. ASCII D. MIDI ( )9. A can display options associated with a command by a window on the screen. A. dialog box B. menu C. submenu D. prompt ( )10. The in the CPU directs and coordinates the operations of the entire computer system A. CU B. IC C. CPU D. ALU 二、填空题。
高职单独招生计算机+英语卷(答案) (2)
单独考试招生文化考试综合试题卷（60分钟，共100分）一.选择题(60分)1.在计算机中,汉字"国"所占的字节数是( )A.1B.2C.4D.82.小明为家中的计算机安装了瑞星杀毒软件,该软件被安装到计算机的哪个硬件设备中( )A.硬盘B.内存C.光盘D.CPU5.以下行为中,不恰当的是( )A.安装正版软件B.购买正版CDC.利用互联网散布他人隐私D.参加反盗版公益活动4.关于病毒,以下说法错误的是( )A.可通过网络传播B.可传染给操作计算机的人C.可潜伏于软盘中5.目前,配"Pentium 4"CPU的微型计算机属于计算机的( )A.第一代产品B.第二代产品C.第三代产品D.第四代产品6.计算机软件系统应包括( )A.编辑软件和连接程序B.数据库软件和管理软件C.程序和数据D.系统软件和应用软件7.下列方法中,可以有效降低计算机病毒危害的是( )A.使用盗版软件B.对重要数据定期进行备份C.对来历不明的软盘和光盘不需要防毒检查D.打开来历不明的电子邮件8.下列不属于计算机输入设备的是( )A.鼠标B.话筒C.键盘D.打印机9.智能机器人利用计算机来模拟人类思维而展开的系列活动,属于计算机应用中的( )A.数值计算B.自动控制D.辅助教育10.RAM中存储的数据在断电后是否会丢失( )A.部分丢失B.完全丢失C.不会丢失D.不一定丢失11.关于计算机病毒的传播途径,不正确的说法是( )A.外来磁盘软件的复制B.通过E-Mail的收发C.通过生物病毒传播D.通过网络下载软件12.在微型计算机内存储器中,不能用指令修改其存储内容的部分( )A.RAMB.DRAMC.ROMD.SRAM13.计算机病毒发作后,可能( )A.损坏计算机的键盘B.再也无法清除病毒C.影响计算机的正常运行D.影响计算机使用者的身体健康14.瑞星.金山毒霸等杀毒软件属于( )A.系统软件C.应用软件D.智能软件15.计算机发展的总趋势是( )A.智能化.多媒体化.网络化B.机械化.自动化.简单化C.智能化.简单化.网络化D.人工化.网络化.复杂化16.计算机能处理声音.动画.图像等信息,这种技术属于( )A.网络技术B.多媒体技术C.人工智能技术D.自动控制技术17.在微型计算机中,不属于微处理器功能的是( )A.算术运算B.逻辑运算C.控制和指挥各部分协调工作D.显示数据处理18.家用电脑属于( )A.巨型机B.中型机C.小型机D.微型机19.计算机辅助设计的简称是( )B.CAIC.CPUD.CAM20.微型计算机硬件系统中最核心的部件是( )A.存储器B.输入输出设备C.CPUD.UPS二.判断题(20分)1.文件夹中只能包含文件A.正确B.错误2.计算机辅助测试的英文缩写是CATA.正确B.错误3.中央处理器和主存储器构成计算机的主体，称为主机。
中等职业技术学校计算机专业英语试卷 B卷
英语期末考试试卷(B卷)考试形式闭卷考试时间100分钟出卷教师第一部分英语基础知识运用(共两节，满分35分)第一节默写26个英语字母，包括大小写（20分）第二节单项填空(共10小题；每小题1.5分，满分15分)从题中所给的A、B、C、D四个选项中选出能填入空白处的正确选项，并将所选答案写到试卷的相应位置上。
1.Don’t worry. Let me ______ it.A. checkingB. checkedC. checksD. check2、Monitors, speakers and printers _______ popular output devices. A. are B. is C. am D. be3、This is marry. What can I ______ for you ?A. doesB. didC. doD. am4、I turned _______ the computer and get a message.A. inB. onC. offD. down5、You are welcome, Thanks for ______ PC Support Center.A. is callingB. am callingC. are callingD. calling6、Are there any _______ before the hard drive fails ?A. signsB. signC. singD. sings7、Windows will look _______ and install a driver automatically after you install the sound card in your computer and turn the computer back on.A. atB. onC. inD. for8、The operating system is the _______ important program that runs ona computer.A. moreB. mostC. betterD. well9、Properly managed telemarketing contributes _______ collating data for important decision makers.A. toB. onC. asD. of10、A spreadsheet is a grid that _______ data into columns and rows.A. organizingB. organizedC. organizeD. organizes第二部分阅读理解(共两节，满分20分)第一节根据短文内容，从题中所给的A、B、C、D四个选项中，选出正确选项填在试卷的相应位置上。
中职《计算机基础》期末试题
深州市职教中心·技工学校2022-2023学年第一学期期末考试《计算机基础》试题试卷说明：1.考试时间90分钟，满分100分。
2.考试范围：WORD部分。
3.本试题共3页，共两道大题。
4.答案均涂在答题卡上。
判断题正确涂A，错误涂B一、单项选择题：（每小题1.5分，共90分）1. Word2010是Microsoft公司提供的一个________。
A. 操作系统B. 表格处理软件C. 文字处理软件D. 数据库管理系统2. 启动Word2010是在启动________的基础上进行的。
A. WindowsB. UCDOSC. DOSD. WPS3. 在Word2010“文件”菜单底部列出的文件名表示________。
A. 该文件正在使用B. 该文件正在打印C. 扩展名为DOC的文件D. Word2010最近处理过的文件4. Word2010文档文件的扩展名是_________ 。
A. txtB. wpsC. docD. word5. 第一次保存文件，将出现________对话框。
A. 保存 B 全部保存C. 另存为 D 保存为6. 在Word2010的编辑状态中，如果要输入希腊字母Ω，则需要使用的菜单是___。
A. 编辑B. 插入C. 格式D. 工具7. 要打开菜单，可用________键和各菜单名旁带下划线的字母。
A. Ctrl B ShiftC. Alt D Ctrl+Shift8. 以下关于“Word2010文本行”的说法中，正确的说法为________。
A. 输入文本内容到达屏幕右边界时，只有按回车键才能换行B. Word2010文本行的宽度与页面设置有关C. 在Word2010中文本行的宽度就是显示器的宽度D. Word2010文本行的宽度用户无法控制9.“剪切”命令用于删除文本和图形，并将删除的文本或图形放置到________。
A. 硬盘上 B 软盘上C. 剪贴板上 D 文档上10. 关于Word2010查找操作的错误说法是________。
- 1、下载文档前请自行甄别文档内容的完整性，平台不提供额外的编辑、内容补充、找答案等附加服务。
- 2、"仅部分预览"的文档,不可在线预览部分如存在完整性等问题,可反馈申请退款(可完整预览的文档不适用该条件!)。
- 3、如文档侵犯您的权益，请联系客服反馈,我们会尽快为您处理(人工客服工作时间：9:00-18:30)。
望城区职业中专2019学年第一学期期中考试
《计算机应用基础》理论考试试题
（适用班级：计算机57班）
一、单项选择题（2*15，共30分）
1.PowerPoint2010 系统默认的视图方式是（）
A．大纲视图B．幻灯片浏览视图C．普通视图D．幻灯片视图2. 在EXCEL 2010中，列宽和行高（）。
A．都可以改变 B.只能改变列宽 C.只能改变行高 D.都不能改变
3. EXCEL 2010所属的套装软件是（）
A．LOTUS 2010 B. Windows 2010 C. Office 2010 D. Word 2010
4. 在演示文稿中，给幻灯片重新设置背景，若要给所有幻灯片使用相同背景，则在“背景”对话框中应单击（）按钮。
A. 全部应用
B. 应用
C. 取消
D. 重置背景
5．EXCEL 2010工作薄文件的默认扩展名为（）
A．doc B．xls C．ppt D．mdb
6. 下列（）不属于 PowerPoint2010 创建的演示文稿的格式文件保存类型。
A．PowerPoint放映 B．RTF 文件 C．PowerPoint模板 D．WORD文档
7. 选择全部幻灯片时，可用快捷键（）
A．Shift+A B. Ctr+A C．F3 D．F4
8．在EXCEL 2010中，求一组数值中的平均值函数为（）
A．AVERAGE B．MAX C．MIN D．SUM
9. 在EXCEL 2010中，单元格B2的列相对行绝对的混合引用地址为（）
A、$B$2
B、$B2
C、B$2
D、B2
10. EXCEL 2010主界面窗口中编辑栏上的“fx”按钮用来向单元格插入（）
A、文字
B、数字
C、公式
D、函数11. Excel 2010系统中，下列叙述正确的是（）
A. 只能打开一个文件
B. 最多能打开4个文件
C. 能打开多个文件，但不能同时将它们打开
D. 能打开多个文件，并能同时将它们打开
12.绘制圆时，需要按下（）键再拖动鼠标。
A．Shift B. Ctrl C．F3 D．F4
13. EXCEL 2010中，如果B2、B3、B4、B5单元格的内容分别是4、2、5、=B2*B3-B4，则B2、B3、B4、B5单元格实际显示的内容分别是（）
A. 4 2 5 2
B. 2 3 4 5
C. 5 4 3 2
D.4 2 5 3
14. 在EXCEL 2010中，以下公式中正确的是（）
A. =A1+B1
B. =’计算机’&’应用’
C. =“计算机”&“应用”
D. =(计算机)&(应用)
15.PowerPoint中，下列说法中错误的是（）
A.可以动态显示文本和对象
B.可以更改动画对象的出现顺序
C.图表中的元素不可以设置动画效果
D.可以设置幻灯片切换效果
二、多项选择题（3*5，共15分）
1.要在学生成绩表中筛选出语文成绩在85分以上的同学,可通过（）
A. 自动筛选
B. 自定义筛选
C. 高级筛选
D. 条件格式
2.以下说法正确的是（）
A. 在Word中，视图默认的视图为普通视图
B. 在Excel中，视图默认的视图为普通视图
C. 在PowerPoint中，视图默认的视图为普通视图
D. 以下答案只有A、B正确
3.以下选项中,中文版式方式包括以下几种（）
A. 拼音指南
B. 带圈字符
C. 双行合一
D. 纵横混排
4.在Excel 2010中，“Delete”和“全部清除”命令的区别在于（）
A. Delete 删除单元格的内容，格式和批注
B. Delete 仅能删除单元格的内容
C. 清除命令可删除单元格的内容，格式或批注
班级学号姓名
D. 清除命令仅能删除单元格的内容
5.在Excel 2010中,工作表“销售额”中的B2:H308中包含所有的销售数据，在工作表“汇总”中需要计算机销售总额，可采用哪些方法（）
A. 在工作表“汇总”中，输入“=销售额！(B2:H308)”
B. 在工作表“汇总”中，输入“=SUM销售额！(B2:H308)”
C. 在工作表“销售额”中，选中B2:H308区域，并在名称框输入“sales ”在工作表“汇总”中，输入“=sales ”
D. 在工作表“销售额”中，选中B2:H308区域，并在名称框输入“sales ”在工作表“汇总”中，输入“=SUM(sales)”
三、判断题（2*5，共10分）
1.Microsoft Office Excel 2010是Microsoft公司推出的Office系列办公软件中的电子表格处理软件，是办公自动化集成软件包的重要组成部分。
（）
2.．PowerPoint 2010具有动画功能，可使幻灯片中的各种对象以充满动感的形式
展示在屏幕上。
（）
3.编辑栏用于编辑当前单元格的内容。
如果该单元格中含有公式，则公式的运算结果会显示在单元格中，公式本身会显示在编辑栏中。
（）
4．在PowerPoint 2010的“幻灯片浏览”视图中可以给一张幻灯片或几张幻灯片中的所有对象添加相同的动画效果。
（）
5.选择两个不相邻的区域的一种方法是：先选择一个区域，再按住Shift键选择另一个区域。
（）
四、操作题（5*5，共25分）
1.有一个EXCEL数据表，区域C3-C52是学生班级，区域E3-E52是高数成绩, 区域
F3-F52是英语成绩，区域K3-K52是学生总分，根据上述已知条件用函数求下列问题：①10物流1班人数（写出完整函数式子）
②10路2班英语总分（写出完整函数式子）
③英语最高分（写出完整函数式子）④以总分进行排名，降序排列（写出完整函数式子）
⑤高数最低分（写出完整函数式子）
五、理论题（4*5，共20分）
1.如下图所示：解释函数式并写出函数式结果
=COUNTIF(A1:C4,”>=1000”) =_____
=COUNTIF(A1:C4,”>=100”)-COUNTIF(A1:C4,”>2000”)=_______ 2. 如下图所示：解释函数式并写出函数式结果
=SUM(6,8)= _______
=SUM(A1,C1)= _______
=SUM(A1:C1)= _______
3.写出下列函数式结果
①=LEN(“abcdefg”)= _______
②=CONCATENATE(“ab”,“cd”,“ef”)= _______
③=LEFT(“abcdefg”,3)= _______
④=RIGHT(“abcdefg”,3)= _______
⑤=MID(“abcdefg”,2,3)=
______。