【精选】2019年山东省专升本计算机公共课试题+答案文件

合集下载

山东专升本(计算机)历年真题试卷汇编2(题后含答案及解析)

山东专升本(计算机)历年真题试卷汇编2(题后含答案及解析)

山东专升本(计算机)历年真题试卷汇编2(题后含答案及解析) 题型有:1. 填空题 2. 单选题 3. 多选题 4. 判断题填空题每空2分,共20分。

请将每一个空的正确答案写在答题卡上。

1.在计算机系统中扩展名为TXT的文件被称为______文件,可以用记事本打开。

正确答案:文本文件解析:在计算机系统中,扩展名为TXT的文件被称为文本文件,可以用记事本创建、编辑和打开。

2.在Windows操作系统中,用鼠标双击______,可以关闭该窗口。

正确答案:程序图标解析:标题栏的最左边是应用程序的程序图标(又称“控制图标”),双击窗口的程序图标,可关闭该窗口。

关闭一个Windows XP窗口的操作有:①Alt+F4;②单击标题栏中的“×”按钮;③用鼠标双击程序图标;④在任务栏上右击该图标,选择关闭。

3.计算机中通常所说的总线包括地址总线、数据总线和______三种。

正确答案:控制总线4.在Windows XP中,要进入当前对象的帮助窗口,可以按______键。

正确答案:Fl解析:在Windows XP中,要进入当前对象的帮助窗口,可以按F1键。

5.地址码长度为二进制24位时,其寻址范围是______MB。

正确答案:16解析:有24位二进制数作为地址,则有224种地址组合,对应224个存储单元。

假设一个存储单元对应一个字节,则24位地址码的寻址范围是224Byte=24×20Byte=16 MB。

6.在计算机内,多媒体数据最终是以______形式存在的。

正确答案:二进制代码解析:由于计算机只能处理二进制数字信号,因此,在计算机内多媒体数据也是以二进制代码的形式存在的。

7.MPEG是一个通用的标准,适用于______的压缩。

正确答案:运动图像解析:MPEG压缩标准是由MPEG专家针对运动图像而设计的,MPEG标准包括MPEG视频、MPEG音频和MPEG系统三部分。

8.JPEG是一种图像压缩格式,其含义是______。

山东专升本2019计算机真题试题

山东专升本2019计算机真题试题

机密★启用前试卷类型:公共课科目代码:101山东省2019年普通高等教育专升本统一考试计算机试题本试卷分为第I卷和第II卷两部分,共8页。

满分100分。

考试用时120分钟。

考试结束后,将本试卷和答题卡一并交回。

注意事项:1.答题前,考生务必用0.5毫米黑色签字笔将自己的姓名、考生号、座号填写到试卷规定的位置上,并将姓名、考生号、座号填(涂)在答题卡规定的位置。

2.第Ⅰ卷每小题选出答案后,用2B铅笔把答题卡上对应题目的答案标号涂黑;如需改动,用橡皮擦干净后,再选涂其他答案标号,答在本试卷上无效。

3.第Ⅱ卷答题必须用0.5毫米黑色签字笔作答,答案必须写在答题卡各题目指定区域内相应的位置;如需改动,先划掉原来的答案,然后再写上新的答案;不能使用涂改液、胶带纸、修正带。

不按以上要求作答的答案无效。

第Ⅰ卷一、单项选择题(本大题共50小题,每小题1分,共50分)在每小题列出的四个备选项中只有一个是符合题目要求的,请将其选出并将答题卡的相应代码涂黑。

错涂、多涂或未涂均无分。

1.第一代电子计算机采用的电子元器件是A.晶体管B.电子管C.集成电路D.大规模集成电路2.网页是一种应用______语言编写,可以在WWW上传输,能被浏览器认识和翻译成页面并显示出来的文件。

A.VisualBasicB.JavaC.HTMLD.C++3.关于数据的描述中,错误..的是A.数据可以是数字、文字、声音、图像B.数据可以是数值型数据和非数值型数据C.数据是数值、概念或指令的一种表达形式D.数据就是指数值的大小4.通过按下键盘上的______按键可以将屏幕画面复制到剪贴板。

A.PrintScreenB.Alt+PrintScreenC.Ctrl+DeleteD.Shift+PrintScreen5.下列不属于...系统软件的是A.数据库管理系统B.操作系统C.程序语言处理系统D.电子表格处理软件6.计算机软件系统中,最核心的软件是A.操作系统B.数据库管理系统C.语言和处理程序D.诊断程序7.Word2010是Microsoft公司推出的一款A.电子表格处理软件B.数据库管理系统C.文字处理软件D.操作系统8.Word2010中,第一次保存某文件,出现的对话框为A.全部保存B.另存为C.保存D.保存为9.Excel2010中,工作表是一个A.树形表B.三维表C.一维表D.二维表10.下列计算机网络的传输介质中,传输率最高的是A.同轴线缆B.双绞线C.电话线D.光纤11.Access2010数据表中的一列,称为A.标题B.数据C.记录D.字段12.Internet中计算机之间通信必须共同遵循的协议是A.FTPB.SMTPC.UDPD.TCP/IP13.构成Excel2010工作簿的基本要素是A.工作表B.单元格C.单元格区域D.数据14.在Windows7中,按名称、大小等排列方式排列桌面上图标的正确操作是A.在开始菜单上右击,将出现一个快捷菜单,然后选择排序方式B.在桌面的任意图标上右击,将出现一个快捷菜单,然后选择排序方式C.在任务栏上右击,将出现一个快捷菜单,然后选择排序方式D.桌面的任意空白处右击,将出现一个快捷菜单,然后选择排序方式15.在Windows7中,如果菜单项的文字后出现“√”标记,则表明A.此菜单项目当前不可用B.此菜单项正处于选中状态C.此菜单项目下还有下级菜单D.单击此菜单会打开一个对话框16.在Word2010中,按下______组合键可以将光标定位到文件末尾。

山东专升本计算机最新必考题含答案真题习题

山东专升本计算机最新必考题含答案真题习题

计算机必考重点全篇计算题专项训练附有答案解析不同进制数值换算§1基本知识几个概念:数制、数码、数位、基数、位全不同进制数的书写方式:B D O H不同数制转换的口诀:★★★十进制整数转换为R进制数——除R(基数)取余法,余数倒序排列。

十进制纯小数转换为R进制数——乘R(基数)取整法,整数正序排列。

R进制数转换为十进制数——乘权求和法。

★★★八、十六进制转换为二进制——每1位八进制数码用3位二进制数码表示,每1位十六进制数码用4位二进制数码表示。

二进制转换为八、十六进制——从小数点开始分别向左向右展开:每3位二进制数码用1位八进制数码表示,每4位二进制数码用1位十六进制数码表示。

§2练习题1、用八进制表示一个字节的无符号整数,最多需要( C )A.1位 B.2位 C.3位 D.4位2、用十六进制表示一个字节的无符号整数,最多需要(D )A.1位 B.2位 C.3位 D.4位3、用八进制表示32位二进制地址,最多需要( C )解 32b:xx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxxA.9位 B.10位 C.11位 D.12位4、用十六进制表示32位二进制地址,最多需要(D )解 32b:xxxx xxxx xxxx xxxx xxxx xxxx xxxx xxxxA.5位 B.6位 C.7位 D.8位5、将二进制数1111011转换为十进制数是___B___。

解 2^0+2^1+2^3+2^4+2^5+2^6=123A.59 B.123 C.121 D.1076、将二进制数1111011转换为八进制数是__C____。

解根据“421”法则:1 111 011====1 7 3A.153 B.171 C.173 D.3717、将二进制数1111011转换为十六进制数是__D____。

解根据“8421”法则:111 1011====7 BA.B7 B.711 C.79 D.7B8、在某进制的运算中4﹡5=14,则根据这一运算规则,则5﹡7= D解 4*5=20D=14H 则5*7=35D=10 0011B=2 3HA.3A B.35 C.29 D.239、在计算机中设有某进制数3×3=10,根据这个运算规则8+6=___C___。

2019年山东专升本考试信息技术真题及答案

2019年山东专升本考试信息技术真题及答案

2019年专升本信息真题本试卷分为第Ⅰ卷的第Ⅱ卷两部分,共八页。

满分100分。

考试用时120分钟。

考试结束后,将本试卷和答题卡一并交回。

第Ⅰ卷一、单项选择题(本大题共50小题,每小题1分,共50分)在每小题列出的四个备选项中只有一个是符合题目要求的,请将其选出并将答题卡的相应代码涂黑。

错涂、多涂或未涂均无分。

1.第一代电子计算机采用的电子元器件是()A.晶体管B.电子管C.集成电路D.大规模集成电路2.网页是一种应用()语言编写,可以在www上传输,能被浏览器认识和翻译成页面并显示出来的文件。

A.Visual BasicB.JavaC.HTMLD.++3.关于数据的描述中,错误的是()A.数据可以是数字,文字、声音图像B.数据可以是数值型数据和非数值型数据C.数据是数值、概念或指令的一种表达形式D.数据就是指数值的大小4.通过按下键盘上的()按键可以将屏幕画面复制到剪贴板。

A.PrintScreenB.Al+PrintScreenC.Cirl+DeleteD.Shif+PrintScreen5.下列不属于系统软件的是()A.数据库管理系统B.操作系统C.程序语言处理系统D.电子表格处理软件6.计算机软件系统中,最核心的软件是()A.操作系统B.数据库管理系统C.语言和处理程序D.诊断程序7.Word2010是Microsoft公司推出的一款()A.电子表格处理软件B.数据库管理系统C.文字处理软件D.操作系统8.Word2010中,第一次保存某文件,出现的对话框为()A.全部保存B.另存为C.保存D.保存为9.Excel2010中,工作表是一个()A.树形表B.三维表C.一维表D.二维表10.下列计算机网络的传输介质中,传输率最高的是()A.同轴线缆B.双绞线C.电话线D.光纤11.Access2010数据表中的一列,称为()A.标题B.数据C.记录D.字段12.Internet中计算机之间通信必须共同遵循的协议是()A.FTPB.SMTPC.UDPD.TCP/IP13.构成Excel2010工作律的基本要求是()A工作表 B.单元格 C.单元格区域D.数据14.在Windows7中,按名称、大小等排列方式排列桌面上图标的正确操作是()A.在开始菜单上右击,将出现一个快捷菜单,然后选择排序方式B.在桌面的任意图标上右击,将出现一个快捷菜单,然后选择排序方式C.在任务栏上右击,将出现一个快捷菜单,然后选择排序方式D.桌面的任意空白处右击,将出现一个快捷菜单,然后选择排序方式15.在Windows7中,如果菜单项的文字后出现“√”标记,则表明()A.此菜单项目当前不可用B.此菜单项正处于选中状态C.此菜单项目下还有下级菜单D.单击此菜单会打开一个对话框16.在Word2010中,按下()组合键可以将光标定位到文件末尾。

2019年“专升本”考试《计算机基础》试卷及答案

2019年“专升本”考试《计算机基础》试卷及答案

2019年“专升本”考试《计算机基础》试卷及答案一、单项选择题(每题1分,共20分)1.以下各种进制的数据中最小的数是()A.(100001)2 B.(2C)16 C.(37)8 D.(40)102.字长为64bit的计算机,表示它能作为一个整体进行传送的数据长度为()字节。

A.2 B.4 C.6 D.83.“全角、半角”方式的主要区别在于()A.全角方式下输入的英文字母与汉字输出时同样大小,半角方式下则为汉字的一半大;B.半角方式下输入的汉字为全角方式下输入的汉字的一半大;C.全角方式下只能输入汉字,半角方式下只能输入英文字母;D.无论是全角方式还是半角方式,均能输入英文字母或输入汉字。

4.以下设备属于输入设备的是()A.绘图仪 B.打印机 C.扫描仪 D.显示器5.在Windows XP操作系统中,执行“开始”菜单的“关闭计算机”命令,可以打开“关闭计算机”对话框,其中没有的按钮是()A.关闭 B.注销 C.待机 D.重新启动6.为了执行一个应用程序,可以在“资源管理器”窗口内用鼠标()A.左键单击一个文档 B.左键双击相应的可执行程序C.左键单击相应的可执行程序 D.右键单击相应的可执行程序7.在Windows XP环境中,用鼠标双击某窗口左上角的“控制菜单”按钮,可以()。

A.放大该窗口 B.关闭该窗口C.缩小该窗口 D.移动该窗口8.假设在某个文档窗口中以进行了多次剪切操作,当关闭了该文档窗口后,剪贴板中的内容为()A.第一次剪切的内容 B.空白C.所有剪切的内容 D.最后一次剪切的内容9.在Windows XP环境中,选用中文输入法后,可以实现全角和半角切换的快捷键是()A.CapsLock B.Ctrl+圆点键C.Shift+空格键 D.Ctrl+空格键10.在Word2000中,可以显示分页效果的视图是()A.普通视图 B.大纲视图C.页面视图 D.Web版式视图11.在Word2000中,要将一段文字内容移动到另一处,可以执行的操作是()A.选取、剪切、粘贴 B.选取、复制、粘贴C.选取、剪切、复制 D.选取、粘贴、复制12.在Excel2000中,如果某单元格显示结果为#VALUE,则可能的出错原因是()A.公式中的数字有问题 B.是用了错误的参数或运算对象C.单元格引用无效 D.A、B、C都有可能13.在Excel2000中,能表示第5行、第6列单元格绝对地址的是()A.$F5 B.$5$F C.$F$5 D.$5F14.在PowerPoint2000中,选项超级链接的对象后,以下操作中不能建立超级链接的是()A.利用“插入”菜单中的“超级链接”命令B.利用“编辑”菜单中的“链接”命令C.单击常用工具栏“插入超级链接”命令D.右键单击,选项弹出菜单中的“超级链接”命令15.以下IP地址中,正确的是( )A.202.9.1.12 B.CX.9..23.01C.202.122.202.345.3 D.202.146..36.E16.网络要有条不紊的工作,每台联网的计算机都必须遵守一些事先约定的规则,这些规则称为( )A.协议 B.标准 C.地址 D.公约17.在计算机网络中,“带宽”这一术语表示( )A.数据传输的宽度 B.数据传输的速率C.计算机的字长 D.CPU的主频18.在ISO/OSI参考模型中,最底层是( )A.网络层 B.传输层C.应用层 D.物理层19.在IE浏览器中,“收藏夹”的主要作用是收藏()A.图片 B.文档 C.邮件 D.网址20.所谓媒体,是指( )A.存储介质 B.各种信息的编码C.计算机的输入输出信息 D.表示和传播信息的载体二、多项选择题(每题2分,共20分)1.对计算特点的描叙正确的有( )A.运算速度快 B.价格昂贵C.具有自动执行程序的能力 D.具有“记忆”空能2.下列叙述中正确的有( )A.磁盘驱动器和磁盘属于外设B.汇编语言是高级语言C.计算机能直接识别和执行的指令叫机器指令D.IT是人工智能的英文缩写3.Windows XP操作系统中,对“对话框”可以实现的操作有( )A.最小化 B.移动 C.改变大小 D.关闭 4.以下属于文件的属性的有()A.只写 B.隐藏 C.只读 D.保存 5.在打印文档时,欲打印第1~3,5~7,9页,在打印对话框中“页面范围”栏应输入()A.1,3,5,7,9 B.1~9C.1~3,5~7,9 D.1,2,3,5,6,7,96.在Excel2000中,如果要在单元格中输入-0.123,正确的输入方法有()A.-.123 B.(.123) C.(-.123) D.-0.123 7.在PowerPoint2000中,默认的占位符有()A.命令按钮 B.图片C.文本框 D.艺术字8.对计算机网络功能的描叙,正确的有( )A.计算机之间和计算机用户之间的相互通信交往B.资源共享C.计算机之间和计算机用户之间的协同工作D.只有A和B是对的9.计算机局域网的特点有( )A.覆盖的范围较小 B.传输速率高C.误码率低 D.投入特别大10.多媒体计算机可以处理的信息类型有( )A.除了文字和数字之外,都可以 B.图形、图像C.音频、视频 D.以上说法都对三、填空题(每空1分,共15分)1.已知汉字“啊”的国标码是3021H,则它的机内码是________H。

2019年山东专升本计算机真题

2019年山东专升本计算机真题

2019 年山东省普通高等教育专升本统一考试计算机试题本试卷分为第Ⅰ卷和第Ⅱ卷两部分,共 8 页。

满分 100 分。

考试用时120 分钟。

考试结束后,将本试卷和答题卡一并交回。

注意事项:1.答题前,考生务必用0.5 毫米黑色签字笔将自己的姓名、考生号、座号填写到试卷规定的位置上,并将姓名、考生号、座号填(涂)在答题卡规定的位置。

2.第Ⅰ卷每小题选出答案后,用2B 铅笔把答题卡上对应题目的答案标号涂黑;如需改动,用橡皮擦干净后,再选涂其他答案标号,答在本试卷上无效。

3.第Ⅱ卷答题必须用0.5 毫米黑色签字笔作答,答案必须写在答题卡各题目指定区域内相应的位置;如需改动,先划掉原来的答案,然后再写上新的答案;不能使用涂改液、胶带纸、修正带。

不按以上要求作答的答案无效。

答案请加QQ1372884639获取。

第Ⅰ卷一、单项选择题(本大题共 50 小题,每小题 1 分,共 50 分) 在每小题列出的四个备选项中只有一个是符合题目要求的,请将其选出并将答题卡的相应代码涂黑。

错涂、多涂或未涂均无分。

1.第一代电子计算机采用的电子元器件是()A.晶体管B.电子管C.集成电路D.大规模集成电路2.网页是一种应用()语言编写,可以在 www 上传输,能被浏览器认识和翻译成页面并显示出来的文件。

A. VisualBasicB. JavaC. HTMLD.++3.关于数据的描述中,错误的是()A.数据可以是数字,文字、声音图像B.数据可以是数值型数据和非数值型数据C.数据是数值、概念或指令的一种表达形式D.数据就是指数值的大小4.通过按下键盘上的()按键可以将屏等而面复制到剪贴板。

A. PrintScreenB. Al+PrintScreenC. Cirl+DeleteD. Shif+PrintScreen5.下列不属于系统软件的是()A.数据库管理系统B.操作系统C.程序语言处理系统D.电子表格处理软件6.计算机软件系统中,最核心的软件是()A.操作系统B.数据库管理系统C.语言和处理程序D.诊断程序7.Word 2010 是 Microsoft 公司推出的一款()A.电子表格处理软件B.数据库管理系统C.文字处理软件D. 操作系统8.Word2010 中, 第一次保存某文件,出现的对话框为()A.全部保存B. 另存为C.保存D.保存为9.Excel 2010 中,工作表是一个()A.树形表B.三维表 C 一维表 D.二维表10.下列计算机网络的传输介质中,传输率最高的是()A.同轴线缆B. 双绞线C.电话线D.光纤11.Access 2010 数据表中的一列,称为()A.标题B.数据C.记录D.字段12.Intermet 中计算机之间通信必须共同遵循的协议是()A.F TPB. SMTPC. UDPD. TCP/IP13.构成 Excel 2010 工作律的基本要求是()A.工作表B.单元格C.单元格区域D.数据14.在 Windows7 中,按名称、大小等排列方式排列桌面上图标的正确操作是()A.在开始菜单上右击,将出现一个快捷菜单,然后选择排序方式B.在桌面的任意图标上右击,将出现一个快捷菜单,然后选择排序方式C.在任务栏上右击,将出现一个快捷菜单,然后选择排序方式D.桌面的任意空白处右击,将出现一个快捷菜单,然后选择排序方式15.在 Windows7 中,如果菜单项的文字后出现“√”标记,则表明()A.此菜单项目当前不可用B.此菜单项正处于选中状态C.此菜单项目下还有下级菜单D.单击此菜单会打开一个对话框16.在 Word2010 中,按下()组合键可以将光标定位到文件末尾。

2019山东专升本计算机基础-14页word资料

2019山东专升本计算机基础-14页word资料

计算机文化基础试题一、单项选择题(在每小题的四个备选答案中,选出一个正确的答案,并将其字母填涂答题卡上。

每小题1分,共50分)1.由高级语言编写的源程序要转换成计算机能直接招待的目标程序,必须经过( b )。

A.编辑B.编译C.汇编D.解释2.在Word软件的“文件”菜单底部所显示的多个文件名是( b )。

A.正在使用的文件名B.最近被Word处理过的文件名C.扩展名为.doc的文件名D.正在打印的文件名3.在资源管理器右窗格中,如果需要选定多个非连续排列的文件,应按组合键(a )。

A.Ctrl+单击要选定的文件对象B.Alt+单击要选定的文件对象C.Shift+单击要选定的文件对象D.Ctrl+双击要选定的文件对象4.在Windows中,用鼠标左键单击某应用程序窗口的最小化按钮后,该应用程序处于的状态( d )。

A.不确定B.被强制关闭C.被暂时挂起D.在后台继续运行5.在Windows中,下列启动查找程序的操作中,正确的是( d )。

A.单击"开始"按钮,选择开始菜单中的"查找"项B.右单击"我的电脑"图标,单击快捷菜单中的"查找"命令C.在"资源管理器"窗口中,单击"工具"菜单中的"查找"命令D.在Word程序窗口中,单击编辑菜单中的"查找"命令6.习惯上,CUP与组成了计算机的主机( c )。

A.控制器B.运算器C.内存储器D.控制器和运算器7.有关第一台电子计算机的描述中,不正确的是( c )。

A.第一台电子计算机叫ENIACB.第一台电子计算机内部采用了二进制。

C.第一台电子计算机未采用存储程序工作原理。

D.第一台电子计算机的基本逻辑部件采用了电子管制作。

8.不能退出Word2019应用程序的操作是( b )。

A.Alt+F4B.单击“文件”菜单中的“关闭”命令C.双击应用程序窗口左上角的控制图标D.单击窗口的“关闭”按钮9.当一个文件更名后,该文件的内容( c )。

专升本公共课计算机试题及答案

专升本公共课计算机试题及答案
A.软盘驱动器属于主机,软盘属于外设
B.键盘和显示器都是计算机的外部设备
C.键盘和鼠标均为输入设备
D.软盘存储器由软盘、软盘驱动器和驱动器接口电路三部分组成
6.关于软件系统的知识,正确的说法是(AB)。
A.系统软件的特点是通用性和基础性
B.高级语言是一种独立于机器的语言
C.任何程序都可被视为计算机的系统软件
(C)任务栏不能隐藏(D)既能改变位置也能改变大小
41.在NTFS文件系统中,压缩后的文件就不能再(B)。
(A)索引 (B)加密 (C)只读 (D)存档
42.格式化后的硬盘(C)。
(A)没有数据和病毒 (B)没有数据,可能有病毒
(C)没有病毒,可能有系统文件 (D)只可以有病毒
43.Windows XP是(C)
9.二进制数转换成十进制数为 (C)。
A.157 B.159C.227 D.228
10.十六进制数58.C的二进制数表示是(A)。
A. B.1000101.01 C. D.
11.在计算机中,一个字节包含二进制的位数是(C)。
A.2B.4C.8D.16
12.硬盘工作时,应特别注意避免(A)。
A.剧烈震动 B.噪声 C.光线直射 D.环境卫生不好
30.目前支持热拔插,连接设备最多的总线是(D)。
A.ISA B.EISA C.PCI D.USB
31、下列(A)不属于操作系统
A.CADB.DOS C.Windows NT D.WindowsXP
32、下列(C)不是WindowsXP的特性
A.播放丰富的媒体 B.更好的软、硬件兼容性 C.比以前版本自带了防火墙,使WindowsXP有更高的安全性 D.具有了远程协助功能

2019年专升本计算机真题

2019年专升本计算机真题

2019年计算机专升本题选择题1.能打开开始的菜单的快捷键里_____B. ctrl+Esc2.在word中写完了一行会自动跳转到下一行体现了word的什么功能?D.自动换行-3.在卫星发射过程中,计算机一直操控差卫星的运行,这体现了计算机应用的_____D.过程控制简答题1.计算机的性能指标★IP地址的概念,IP地址的分类★计算机病毒的概念和特征★在“233…上半年”文件来中有隐藏的只读文件Test.doc,现在相对test.doc文件进行编辑,该如何操作多选题★总线有哪几类★计算机填充的类型★能实现选中一行的操作是★要配置一个局域网,需要的设备★控制结构填空题★…….,是()部门★小写字母b的ASCZZ码值____★指令由(),地址码组成简述题五.1.简述微型计算机的主要性能指标2.简述IP地址的概念,按照网络规模大小,可分为哪五种类型。

3.病毒的概念和主要特征4.若修改“2019年上半年文档”文件中隐藏的只读文件test.doc的内容,该如何操作?六.1.(1)将表格标题“销售清单”设置为20号加粗,宋体,蓝色,在A1:E1“合并及居中”调整行高32,刘宽12(2)对工作表中销售清单具体内容以“金额”作为关键字,进行升序排列。

若金额相同则按“公司”降序排列(3)应用公式,计算下列金额的具体值。

(金额=单价X数量)(4)对工作表中售内容进行分类汇总,分类字段为“公司”汇总方式为“求和”汇总项为金额。

(5)设置表格的外边框,12色双线边框,内边框为蓝色单虚线(6)为确保数据的安全,降低表格中数据被泄露的风险,请设置打开权限密码和修改权限密码2.word2010基本操作,多选题1.错误的是A.裸机是指没有机箱设备的计算机B.用高级语言编写的程序是源程序C.机器语言编写的程序,执行力最低D.高级语言编写的程序可写值最差E.计算机能直接识别并执行汇编语言2.计算机的系统总成A.数据B.地址C.控制D.信号E.通信3.英文编写和中文对照,正确的是A.CAD-计算器铺助设计B.CAM-制造C.CAZ-教学D.CAE-测试E.CAT-工程4.算法的基本结构A.顺序B.逻辑C.选择D.循环E.存储5.在excel2010中,填充序列的类型A.等差B.等比C.日期D.自动填充E.任意序列6.在word2010编辑状态下,若选定一行文字信息,可采用方法包括A.鼠标左键单击该行首端空白处选定区B.将光标插入总行的首端或尾端然后按住拖动另一端C.双击行首空白处D.Hrl+左键单击首空白处E.Alt+左键7.文件查找,通序符A.*B.?C.@D.#E.%8.文件和文件夹的属性A.只读B.隐蔽C.共享D.存档E.系统填空题1.线和队列都是特殊列线性表,其逻辑结构都是___2.算法复杂度分为空间复杂度和____3.常用的数据模型,层次,网状,_____。

(完整版)2019年山东专升本计算机真题

(完整版)2019年山东专升本计算机真题

2019 年山东省普通高等教育专升本统一考试计算机试题本试卷分为第Ⅰ卷和第Ⅱ卷两部分,共8 页。

满分100 分。

考试用时120 分钟。

考试结束后,将本试卷和答题卡一并交回。

注意事项:1.答题前,考生务必用0.5 毫米黑色签字笔将自己的姓名、考生号、座号填写到试卷规定的位置上,并将姓名、考生号、座号填(涂)在答题卡规定的位置。

2.第Ⅰ卷每小题选出答案后,用2B 铅笔把答题卡上对应题目的答案标号涂黑;如需改动,用橡皮擦干净后,再选涂其他答案标号,答在本试卷上无效。

3.第Ⅱ卷答题必须用0.5 毫米黑色签字笔作答,答案必须写在答题卡各题目指定区域内相应的位置;如需改动,先划掉原来的答案,然后再写上新的答案;不能使用涂改液、胶带纸、修正带。

不按以上要求作答的答案无效。

答案请加QQ1372884639获取。

第Ⅰ卷一、单项选择题(本大题共50 小题,每小题1 分,共50 分) 在每小题列出的四个备选项中只有一个是符合题目要求的,请将其选出并将答题卡的相应代码涂黑。

错涂、多涂或未涂均无分。

1.第一代电子计算机采用的电子元器件是()A.晶体管B.电子管C.集成电路D.大规模集成电路2.网页是一种应用()语言编写,可以在www 上传输,能被浏览器认识和翻译成页面并显示出来的文件。

A. VisualBasicB. JavaC. HTMLD.++3.关于数据的描述中,错误的是()A.数据可以是数字,文字、声音图像B.数据可以是数值型数据和非数值型数据C.数据是数值、概念或指令的一种表达形式D.数据就是指数值的大小4.通过按下键盘上的()按键可以将屏等而面复制到剪贴板。

A. PrintScreenB. Al+PrintScreenC. Cirl+DeleteD. Shif+PrintScreen5.下列不属于系统软件的是()A.数据库管理系统B.操作系统C.程序语言处理系统D.电子表格处理软件6.计算机软件系统中,最核心的软件是()A.操作系统B.数据库管理系统C.语言和处理程序D.诊断程序7.Word 2010 是Microsoft 公司推出的一款()A.电子表格处理软件B.数据库管理系统C.文字处理软件D. 操作系统8.Word2010 中, 第一次保存某文件,出现的对话框为()A.全部保存B. 另存为C.保存D.保存为9.Excel 2010 中,工作表是一个()A.树形表B.三维表 C 一维表 D.二维表10.下列计算机网络的传输介质中,传输率最高的是()A.同轴线缆B. 双绞线C.电话线D.光纤11.Access 2010 数据表中的一列,称为()A.标题B.数据C.记录D.字段12.Intermet 中计算机之间通信必须共同遵循的协议是()A.F TPB. SMTPC. UDPD. TCP/IP13.构成Excel 2010 工作律的基本要求是()A.工作表B.单元格C.单元格区域D.数据14.在Windows7 中,按名称、大小等排列方式排列桌面上图标的正确操作是()A.在开始菜单上右击,将出现一个快捷菜单,然后选择排序方式B.在桌面的任意图标上右击,将出现一个快捷菜单,然后选择排序方式C.在任务栏上右击,将出现一个快捷菜单,然后选择排序方式D.桌面的任意空白处右击,将出现一个快捷菜单,然后选择排序方式15.在Windows7 中,如果菜单项的文字后出现“√”标记,则表明()A.此菜单项目当前不可用B.此菜单项正处于选中状态C.此菜单项目下还有下级菜单D.单击此菜单会打开一个对话框16.在Word2010 中,按下()组合键可以将光标定位到文件末尾。

山建成人教育《19专升本计算机科学与技术》期末考试复习题及参考答案

山建成人教育《19专升本计算机科学与技术》期末考试复习题及参考答案

大学英语(本科)I. Vocabulary & Structure1. After three days’ waiting, there was a little doubt in the mother’s mind _______ the police could find her lost child.A. howB. thatC. whereD. whether2. Energy is _________ makes things work.A. whatB. everythingC. somethingD. anything3. We’d like to do _______ we can _________ the poor.A. how; helpB. all; to helpC. whatever; helpD. however; to help4. My parents used ________they had to get a new car for my brother.A. whichB. all whatC. whatD. 不填5.We give them quizzes(测试) on Britain and allow themto the Net.A. surfB. whereC. saveD. address6.They arrived at a farmhouse, in front of ______sat a small boy.A. whomB. whoC. whichD. that7.The engineer ______my father works is about 50 years old.A. to whomB. on whomC. with whichD. with whom8.They talked a lot about things and persons ________they remembered in the school.A. whichB. thatC. whomD. what9.My neighbors used to give me a hand in time of trouble, _______ was very kind of them.A. whoB. whichC. thatD. it10. I have bought two ball pens, _______ writes well.A. none of themB. neither of themC. neither of whichD. none of which11. Nowadays consumers become more and more practical and buy only _______ they need.A. whereB. whichC. whenD. what12. She’d like to offer money to ________ needs it to continue his or her study.A. whoB. whomC. whoeverD. whomever13. ---If you are admitted to a key university, _________ as a prize?--- I’m looking for a cell phone.A. What you expect your father will offer youB. Do you expect what your father will offer youC. What do you expect will your father offer youD. What do you expect your father will offer you14. Yesterday he sold out all his stamps at ____ he thought was a reasonable price.A. thatB. whichC. whatD. as15. Generally speaking, _______ we have seen seems more believable than _______ we have been told.A. what; thatB. what; whatC. that; whatD. that; that16. She was so angry at all ________ he was doing _________ she stayed up all night.A. that; thatB. that; whichC. what; thatD. what; as17. ____in this way, the situation doesn't seem so disappointing.A. To lookB. Looking atC. Looked atD. To be looked at18. You will see this product ____ wherever you go.A. to be advertisedB. advertisedC. advertiseD. advertising19. ____in a recent science competition, the three students were awarded scholarship totaling 21,000 dollars.A. To be judged the bestB. having judged the bestC. Judged the bestD. Judging the best20. From the dates ____ on the plates, we decided that they were made in Song Dynasty.A. markingB. having been markedC. markedD. to be marked21.The place _______interested me most was the Children's Palace.A. WhichB. whereC. whatD. in which22.Do you know the man _______?A. whom I spokeB. to who spokeC. I spoke toD. that I spoke23.This is the hotel _______last month.A. which they stayedB. at that they stayedC. where they stayed atD. where they stayed24.Do you know the year ______the Chinese Communist Party was founded?A. whichB. thatC. whenD. on which25.That is the day ______I'll never forget.A. whichB. on whichC. in whichD. when26. The old man came upstairs with great strength, his right hand ____ a stick for support.A. heldB. holdingC. being holdingD. was holding27. ____ three times in a row, the boxer decide to give up fighting.A. Having defeatedB. To have defeatedC. Having been defeatedD. To have been defeated28. ____neglecting our education, my father sent me to school.A. Accused ofB. Accusing ofC. To be accused ofD. That he was accused of29. ____ mainly for the invention of the telephone, Alexander Graham Bell devoted his life to helping the deaf.A. He is rememberedB. While being rememberedC. To be rememberedD. Though remembered30. ____ that they are fresh from university, the young people have done a good job.A. GivenB. BecauseC. GivingD. As31.The factory ______we'll visit next week is not far from here.A. whereB. to whichC. whichD. in which32.Great changes have taken place since then in the factory _______we are working.A. whereB. thatC. whichD. there33.This is one of the best films _______.A. that have been shown this yearB. that have shownC. that has been shown this yearD. that you talked34.Can you lend me the book ______the other day?A. about which you talkedB. which you talkedC. about that you talkedD. that you talked35.The pen ______he is writing is mine.A. with whichB. in whichC. on whichD. by which36. She stood by the window, ____.A. thinkingB. thinkC. thoughtD. thinks37. ____ to meet anybody, he went in from the back door.A. Not wishingB. WishingC. Not wishedD. No wishing38.The editorial ____ now will appear in tomorrow's newspaper.A. writingB. to writeC. being writtenD. write39. It ____ now pretty late, we took our things and retired to our room.A. isB. beingC. turnedD. got40. ____ with the size of the whole earth, the highest mountain does not seem high at all.A. When comparedB. While comparingC. CompareD. Comparing 41.He is no one to ____ to rules and regulations blindly.A.form B. conform C. inform D. perform42.Why does the space shuttle _____ those long streams of flame and smoke?A. emissionB. permitC. permissionD. emit43. It is against_____ for a mother to hurt her children.A. natureB. naturalistC. inheritanceD. determination44. After spending several hours trying to find out the lost companion, wefinally______ him down in a public house.A. trailedB. trackedC. caughtD. traced45. I_____ to answer this question.A. suggestedB. avoidedC. hesitatedD. approved46. ____ on a clear day, far from the city crowds, the mountains give him a sense of infinite peace.A. If walkingB. While walkingC. WalkingD. When one is walking47. I understood you were third-year students ____ in English.A. who majorsB. who major isC. have majoredD. majoring48. A cool rain was falling, ____ with snow.A. mixedB. mixingC. to mixD. having mixed49. ____ by the police, the kidnappers had no choice but to surrender.A. SurroundedB. SurroundingC .having surrounded D. To be surrounded50.____ equal educational opportunities, American Indians in the reservations remained backward and illiterate for a long time.A. Deprived offB. Depriving offC. Deprived ofD. Depriving of51. After the Arab states won independence, great emphasis was laid on expanding education, with girls as well boys____ to go to school.A. to be encouragedB. been encouragedC. being encouragedD. be encouraged52. ____,a man who expresses himself effectively is sure to succeed more rapidly thana man whose command of language is poor.A. Other things being equalB. Were other things equalC. To be equal to other thingsD. Other things to be equal53.All things ____, the planned trip will have to be called off.A. consideredB. be consideredC. consideringD. having considered54. The house was very quiet, ____as it was on the side of a mountain.A. isolatedB. isolatingC. being isolatedD. having been isolated55. This crop has similar qualities to the previous one, ____both wind-resistant and adapted to the same type of soil.A. beingB. beenC. to beD. having been56. The rate of unemployment is_______.A. risingB. increaseC. decreaseD. raising57. His idea that_____ is a relative matter is not universally accepted.A. brightB. smartC. intelligenceD. intelligent58. You should look for contextual clues to_____ the meaning of a word.A. delayB. determineC. differD. deny59. In Britain people_____ four million tons of potatoes every year.A. swallowB. disposeC. consumeD. exhaust60. This picture will _____to you some idea of the beauty of the scenery.A. coincideB. commenceC. conveyD. commend01-05 DABCA 06-10CDBBC 11-15 DCDCB 16-20ACBCC21-25 ACDCA 26-30BCADA 31-35 CAAAA 36-40AACBA41-45 BDABC 46-50DDAAC 51-55CAAAA 55-60ACBCCII. Cloze: Put in the missing words. The first letter in each blank has been given.According 1) t Dossey, one of the most common 2) i in our society is "time sickness", because the 3)s of time pressure and hurry will 4) canxiety and 5) t . These symptoms can contribute to heart 6) d and strokes, two of our most frequent 7) c of death. Dossey has discovered that these and8) o stress-induced ills can often be successfully 9) t by using simple techniques to change how a person thinks 10) a time.1.to2.ills3.sense4.cause5.tension6.disease7.causes8.other9.treated 10.aboutNowadays the number of "netizens" in China is getting larger and 1) l . About 40% of them are teenagers. The main reasons 2)w teenagers 3) s the Web are to get useful information, 4)w their knowledge, 5) cwith others, and relax in their 6) s time. It is 7) c than phoning somebody far away and also much quicker. Nearly one-third of young 8) n surf the internet for fun. They like to listen to 9) m , watch films, and go to their 10) f stars' website.rger2.why3.surf4.widenmunicate6.spare7.cheaperizens9.music 10.favoriteIII. Reading comprehensionPassage OneThe causes that lead to conditions likely for crime and fights are stronger in urban communities than in country ones. As you know, urban life is more crowdedand separate, and almost few people get to know the other people's existence in the city. And it often sets the individual free from the limitations (局限) of city life than the tradition-centered societies did. But more freedom from limitations and controls also gives the people greater freedom to get away from it. And living in the colder, well organized urban area means that ruling orders of action are often guided by the departments far away. The police are strangers carrying out these orders, at worst, a different community and, at best, a same set of subjects. Minor offences in a small town or village are often dealt with without the usage of official police action. As doubtful as such action may seem to be, it results in fewer recorded breaking of the law as compared to the city, however. Although perhaps causing some decision difficulties for the police in small towns, normal and smooth law making is not always acceptable to villagers.Urban areas with more population, greater wealth, more commercial establishments(设施), and more products of our technology also provide more opportunities for stealing. The people are independent, their money is insured,well-made goods in a large number are beautifully exhibited and easier to carry.1. The passage mainly tells us that .A) being known to the neighbors increases the danger of being attackedB) there are more crime rates in the urban area than in the country areaC) small villages have more minor crimes than urban centersD) there is no way to prevent urban crimes from happening2. What was the traditional society like?A) It provided too much freedom of personal movement and travel.B) It provided less freedom for the individual in many situations.C) The technology was not fully used in the traditional society.D) A lot of old traditions passed on to modern society.3. The phrase "minor offenses" (Line 9, Para.1) refers to offenses likeA) theft B) robbery C) bribery D) murder4. According to the passage, the crime rate in small villages is .A) higher than that of urban centers B) lower than that of urban centersC) the same as that of urban centers D) now being reduced5. Which of the following does NOT lead to the high crime rate in urban areas?A) Store window exhibits. B) High level of living.C) Fewer police departments. D) Large population.Passage TwoWho talks more,women or men? The seemingly conflicting evidence is resolved by the difference between what I call public and private speaking. More men feelcomfortable doing "public speaking" while more women feel comfortable doing "private" speaking.Another way of capturing these differences is by using the terms report-talk and rapport-talk. For most women, the language of conversation is primarily a language of rapport: a way of establishing connections and negotiating relationships. Emphasis is placed on displaying similarities and matching experiences. From childhood, girls criticize their friends who try to stand out or appear better than others. People feel their closest connections at home, or in places where they feel at home -- with one or a few people they feel close to and comfortable with -- in other words, during private speaking. But even the most public situations can be approached like private speaking.For most women, talk is primarily a means to preserve independence and negotiate and maintain status in a hierarchical(等级制度的) social order. This is done by exhibiting knowledge and skill, and by ho1ding center stage through verbal performance such as storytelling, joking, or conveying information. From childhood, men learn to use talking as a way to get and keep attention. Therefore, they are more comfortable speaking in 1arger groups made up of people they know 1ess well, in the broadest sense, "public speaking.” But even the most private situations can be approached like public speaking, more like giving a report than establishing rapport.6.A similar term for "private talking" is ___________.A. report-talkB. rapport-talkC. persuasive talkD. women's talk7.When women talk,they tend to________.A. admire their friends who stand outB. make others feel at homeC. approach public situations like private talkingD. seek close relationship with other speakers8. Men talk in order to________.A. make new friendsB. share experienceC. argue with othersD. attract attention9. The purpose of this passage is to _______.A. contrast the male and female talking stylesB. prove that men talk more effectively than womenC. analyze why men and women are differentD. draw people's attention to the difference between men and women10. Which of the following is true?A. Men talk more than women.B. Men feel more comfortable making a public speech than women.C. Men are more knowledgeable than women.D. Men are more independent than women.Passage ThreeLabor force is defined as being the total number of people who are available to work and earn income. This definition includes everyone who is employed or seeking paid employment, so it includes employers and the self—employed. Labor is one of the country's resources which can be combined with other resources to produce the goods and services wanted by the community. Although the size of the workforce depends a great deal on the size of the total population, there are several other influences which a1so affect it. The age distribution of the total population has a very marked effect on the available workforce. If the population has a high proportion of very young people or of those too o1d to work, then the available workforce would be lower than if there were an evenly spread age distribution. If the population naturally grows rapidly, i.e. the number of births greatly exceeds the number of deaths, then as a total population increases the proportion in the workforce declines.Sometimes a population is described as aging, which means that the birth rate is either falling or growing very slowly, and as people retire from the workforce there are insufficient numbers of young people entering it to replace those who are leaving it. The population is top-heavy(头重脚轻) with older people. So the percentage of the population in the workforce declines when there is either a rapid increase in births or a falling birth rate.The age distribution of the population has several important effects on the economy. If the population is aging and there is an increase in the number of people retiring without a corresponding increase in the number entering the workforce, this raises the problem of the ability of the economy to provide a reasonable 1evel of social services to the retired group. If the aged are to be cared for in special homes, finance must be avai1able for that purpose. If the size of the workforce is small relative to the total population, then the government tax revenue is relatively low and either the government has less money available to it or the workforce members have to be taxed more heavily.bor force is referred to as ____________A. people who are available to work and earn incomeB. self-employed people onlyC. only those who are looking for an employmentD. only the employers12.According to the passage, which of the following factors is NOT mentioned as an influence on the size of the workforce?A. The size of the population.B. The age distribution of the population.C. The national economy.D. The number of births and deaths.13.The conclusion which can be drawn safely from the second paragraph is that________.A. a population growth from natural increase leads to a greater proportion of the workforceB. a large population does not necessarily mean a higher proportion of workforceC. the larger the number of the aged in a population, the higher the proportion of the workforceD. if the population has an evenly spread age distribution, the workforce will be lower14.When a population is said to aging,____________.A. there are more people retiring than those entering the workforce.B. the birth rate must be growingC. there should be an oversupply of workforceD. young people outnumber old people15.The population which is top-heavy with older people exerts pressure on ________A. the employersB. the self-employedC. the young peopleD. the economy of the countryPassage Fore.The age of space science began less than thirty years ago. But already people have made great discoveries and have done exciting things. They have walked in space, visited the moon, and lived in space laboratories for long periods of time. Some scientists are now working on ways to make it possible for people to live on other planets. They are trying to solve problems of living in space, even though they don't yet know what all of the problems will be. For example, they don't yet know what problems people would have if they loved being weightless for several years.If you were a space traveler you might have to spend several months, or even years, in a spaceship. While you were in the ship you wouldn't live as you usually do. You might have to find new ways to spend your time. Your body would have to adjust to different conditions. And you would have some problems that you never think about here on Earth. For example, you would have to have a huge supply of food with you because you can't go to the supermarket when you're halfway to another planet. You also would need fresh water and a way to get rid of waste. In fact, there would be many problems to solve in order to live in space.16. According to the passage, which of the following is not true?A) if you were a space traveler, you had to live in a spaceship for some timeB) scientists have solved problems of living in spaceC) while you were in the ship you wouldn't live as you usually doD) scientists are finding ways to make people live on other planets17. The sentence "what problems people would have if they loved being weightless"(Line6- 7, Para. 1) is probably, closest in meaning to .A) people who were light had many problemsB) many people who loved to be very lightC) many problems people would face in spaceD) weightless people who loved to have problems18. The phrase "a huge supply of food" (Line 5, Para. 2) means .A) a large amount of foodB) a huge piece of foodC) the food that is largely supplied on the marketD) the food at the supermarket19. While you were in the spaceship, you would NOTA) need fresh water and a way to get rid of wasteB) have some unusual problemsC) go to the supermarket when you were halfway to another planetD) find new ways to spend your time20. It can be concluded from the passage that .A) life in space was interesting and excitingB) there would be many problems if you wanted to live in spaceC) if you were a space traveler, you had to stay in spaceD) it was easy to enjoy oneself in spacePassage FiveThe best example of how associations influence eating is that we often eat not because we're hungry but because it's "lunchtime," because foods smell good, or because our friends are eating.More evidence that associations influence eating comes from marketing and advertising pressures to sell foods by offering huge servings. For example, movie theatres offer an extra large box of popcorn(爆玉米花),which, at almost 900 calories, is equivalent to a major meal. Health professionals warn that as children, adolescents(青少年),and adults learn to prefer large portions and tasty foods high in fat, sugar, and calories, there has been a corresponding increase in rates of being overweight(from 25% in 1988 to 35% in 1998).Researchers are especially concerned about the continued rates of overweight and obesity(肥胖) in children since childhood obesity is very difficult to treat and an obese child has a high probability of becoming an obese adult with the associated health risks we discussed earlier.Health professionals suggest that to avoid future increases in rates of overweight and obesity, we need to try hard to forget many of our food associations, which primarily involves decreasing size of food portions, increasing levels of activity to burn off excess calories.21.The influence of food association can be seen clearly from the example that we often eat NOT because________.A. it's time for lunchB. we're hungryC. foods smell deliciousD. our friends are eating22.From the passage we can infer that the "serving" in the second paragraph most probably means________.A. an amount of foodB. a special serviceC. a mealD. some calories23.According to the author, because of an unhealthy food preference, the increase in rates of being overweight was _____________ during the ten years from 1988 to 1998.A. 10 per centB. 20 per centC. 30 per centD. 40 per cent24.According to the passage, an obese child is _____________.A. less at risk of heart diseasesB. healthily fatC. very hard to get along withD. more likely to become an obese adult25.In order to avoid future increases in rates of overweight and obesity, we need to do a11 the following EXCEPT _____________.A. make an effort to forget our food associationB. eat less foodC. do more exercise to consume excess caloriesD. eat more fruitPassage SixWeddings ceremonies in the United States vary as much as the people do. But many weddings, no matter where or how they are performed, include certain traditional customs. For instance, the bride and groom often exchange rings at the ceremony. The rings are usually worn on the fourth finger of the left hand, and are exchanged in the middle of the ceremony. Today, the ring shows the couple's love for one another.After the ceremony, the couple is often showered with handfuls of uncooked rice by friends and family. Rice, as we know, shows productivity and harvest. And then, there is often a party, where the food is so plentiful that it almost takes the attention away from the people. Soon the bride stands in the center of the room, often on a chair, and throws her flowers to the unmarried women at the party. Tradition says that whoever catches the flowers will be the next bride. Some women eagerly try to catch the flower; others shy away.And then it is time for the bride and groom to set off the tradition of a honeymoon, a trip after the wedding. The trip nowadays varies greatly by wealth, time and preference. Sometimes the couple will spend a single night at a nearby hotel; or they may spend two weeks at a faraway foreign city as well.26. According to the passage,.A) American wedding ceremonies are somewhat traditionalB) American wedding ceremonies provide a lot of flowersC) American wedding ceremonies are preferableD) American wedding ceremonies are magnificent27. According to the passage, what does the sentence "no matter where or how theyare performed" (line 2, Para.1 ) really mean?A) The wedding ceremonies may be held everywhere.B) The wedding ceremonies may be held at any time.C) The wedding ceremonies may be held in different ways and places.D) The wedding ceremonies may be held in any way.28. The word "'showered" (Line 1, Para. 2) probably means .A) dressed B) scattered C) provided D) touched29. From the passage, we can safely conclude that .A) American couples hold traditional wedding ceremoniesB) American couples hold fashionable wedding ceremoniesC) American couples go on expensive honeymoon tripsD) American couples exchange rings after the honeymoon30. Which of the following is the best title for this passage?A) Weddings in North America B) Weddings in AmericaC) Wedding Ceremonies D) Wedding Traditions1-5. BBABC 6-10.BCDAB 11-15.ACBAD16-20. BCACB 21-25.BAADD 26-30. ACBABIV TranslationPassage AI remember being vaguely annoyed when the gunman pulled me from the car by the hair. I remember the walk to the house----Jeremy, me, the two men with two guns. I remember the fear and anger in the gunmen's voices because Jeremy was being slow, and I remember wondering why he was being slow. I did not realize that Jeremy had thrown the keys into the shrubbery. But I remember the sound of the gun hitting Jeremy's head and the feeling that he released me.我记得当那个拿着枪的人抓住我的头发,把我从车里拖出来的时候,我隐约觉得有点恼火。

(完整)2019年山东专升本考试信息技术真题与答案,推荐文档

(完整)2019年山东专升本考试信息技术真题与答案,推荐文档

2019 年专升本信息真题本试卷分为第Ⅰ卷的第Ⅱ卷两部分,共八页。

满分100 分。

考试用时120 分钟。

考试结束后,将本试卷和答题卡一并交回。

第Ⅰ卷一、单项选择题(本大题共50 小题,每小题 1 分,共 50 分 )在每小题列出的四个备选项中只有一个是符合题目要求的,请将其选出并将答题卡的相应代码涂黑。

错涂、多涂或未涂均无分。

1.第一代电子计算机采用的电子元器件是()A.晶体管B.电子管C.集成电路D.大规模集成电路2.网页是一种应用()语言编写,可以在 www 上传输,能被浏览器认识和翻译成页面并显示出来的文件。

A.Visual BasicB.JavaC.HTMLD.++3.关于数据的描述中,错误的是()A.数据可以是数字,文字、声音图像B.数据可以是数值型数据和非数值型数据C.数据是数值、概念或指令的一种表达形式D.数据就是指数值的大小4.通过按下键盘上的()按键可以将屏幕画面复制到剪贴板。

A.PrintScreenB.Al+PrintScreenC.Cirl+DeleteD.Shif+PrintScreen5.下列不属于系统软件的是()A.数据库管理系统B.操作系统C.程序语言处理系统D.电子表格处理软件6.计算机软件系统中,最核心的软件是()A.操作系统B.数据库管理系统C.语言和处理程序D.诊断程序7.Word2010 是Microsoft 公司推出的一款()A.电子表格处理软件B.数据库管理系统C.文字处理软件D.操作系统8.Word2010 中 ,第一次保存某文件,出现的对话框为()A.全部保存B.另存为 C.保存 D.保存为9.Excel2010 中,工作表是一个()A.树形表B.三维表 C.一维表 D.二维表10.下列计算机网络的传输介质中,传输率最高的是()A.同轴线缆B.双绞线 C.电话线 D.光纤11.Access2010 数据表中的一列,称为()A.标题B.数据C.记录D.字段12.Internet 中计算机之间通信必须共同遵循的协议是()A.FTPB.SMTPC.UDPD.TCP/IP13.构成 Excel2010 工作律的基本要求是()A 工作表B.单元格C.单元格区域 D.数据14.在 Windows7 中,按名称、大小等排列方式排列桌面上图标的正确操作是()A.在开始菜单上右击,将出现一个快捷菜单,然后选择排序方式B.在桌面的任意图标上右击,将出现一个快捷菜单,然后选择排序方式C.在任务栏上右击,将出现一个快捷菜单,然后选择排序方式D.桌面的任意空白处右击,将出现一个快捷菜单,然后选择排序方式15.在 Windows7 中,如果菜单项的文字后出现“√”标记,则表明()A.此菜单项目当前不可用B.此菜单项正处于选中状态C.此菜单项目下还有下级菜单D.单击此菜单会打开一个对话框16.在 Word2010 中,按下()组合键可以将光标定位到文件末尾。

2019年山东专升本计算机真题及答案

2019年山东专升本计算机真题及答案

A.放映方式 B.白定义放映 C.自定义功画
D.幻灯片切换
计算机试题第 5页(共 10页)
47.为了将制作完成的幻灯片发布到 Web,应该( ) A.直接保存幻灯片文件 B.超级链接幻灯片文件 C.在“文件 ”选项卡中,选择 “保存并发送 ”命令 D.在制作网页的软件中重新制作
48.下列关于 Access2010 的叙述中 ,正确的是( ) A.数据库中的数据存储在表和报表中 B.数据库中的所有数据存储在表中 C.数据库中的数据存储在表和查询中 D.数据库中的数据存储在表、查询和报表中
52 下列选项中,属于微机主要性能指标的有(
)。
A 运算速度 B.内存容量 C.能配备的设备数量 D.接口数
53.剪贴板的操作包括( )
A.选择
B.复制
C.剪切
D.移动
54. 下列选项中,属丁 Word 2010 缩进效果的是( )
A.两端缩进 B 分散缩进 C.左缩进 D.右缩进
55.下列属于输入设备的是( ) A.显示器 B.打印机 C.鼠标 D.扫描仪
45.在 Excel 2010 中,如果想限制单元格只允许输入一定大范围内数值 的 “数据工具 ”组,单击其中的 “数据有效性 ”命令。
,可以选择 ____选项卡
A.开始
B.审阅
C.公式
D.数据
46.在 PowerPoint 2010 的演示文稿中,若需使幼灯片从 则应设置( )
“随机线条 "效果变换到下张幻灯片,
计算机试题第 1页(共 10页)
4.通过按下键盘上的( )按键可以将屏等而面复制到剪贴板。
A. PrintScreen C. Cirl+Delete
B. Al+PrintScreen D. Shif+PrintScreen
  1. 1、下载文档前请自行甄别文档内容的完整性,平台不提供额外的编辑、内容补充、找答案等附加服务。
  2. 2、"仅部分预览"的文档,不可在线预览部分如存在完整性等问题,可反馈申请退款(可完整预览的文档不适用该条件!)。
  3. 3、如文档侵犯您的权益,请联系客服反馈,我们会尽快为您处理(人工客服工作时间:9:00-18:30)。

山东省2018年普通高等教育专升本统一考试计算机试题本试卷分为第Ⅰ卷和第Ⅱ卷两部分,共8 页。

满分100 分。

考试用时120 分钟。

考试结束后,将本试卷和答题卡一并交回。

第I 卷一、单项选择题( 本大题共50 小题,每小题 1 分,共50 分)在每小题类出的四个备选项中只有一个是符合题目要求的,请将其选出并将答题卡的相应代码涂黑。

错涂、多涂或未涂均无分。

1.在计算机辅助系统中,CAM 的含义是()。

A.计算机辅助设计B.计算机辅助制造C.计算机辅助教学D.计算机辅助测试1.【答案】B。

解析:计算机辅助设计是CAD ,计算机辅助教学是CAI ,计算机辅助测试是CAT。

还有,计算机辅助工程CAE。

2.将程序像数据一样存放在计算机中运行,1946 年由()提出的。

A.图灵B.布尔C.爱因斯坦D.冯·诺依曼2.【答案】D。

解析:1946 年冯·诺依曼提出了“存储程序与程序控制”的设计思想。

将编好的程序和执行程序所需要的数据存储在计算机中,计算机在工作时能在不需要人员干预的情况下,自动逐条取出指令并加以执行。

3.下列属于存储器且断电后信息全部丢失的是()。

A. ROMB. FROMC.RAMD.CD-ROM3.【答案】C。

解析:存储器分为内存储器和外存储器,内存储器包括随机存储器(RAM )、只读存储器(ROM ),随机存储器(RAM )断电丢失数据,只读存储器(ROM )永久保存数据,存储微型机的重要信息。

可读型光盘(CD-ROM )是外存储器。

4. 8 位无符号二进制数可以表示的最大十进制整数是()。

A. 127B. 128C.255D.2564.【答案】C。

解析:8 位无符号二进制数为“11111111”,采用位权展开法得到十进制数255。

因此答案选C。

5.计算机中,通常用英文字母“bit ”表示()。

A.字B.字节C.二进制位D.字长5.【答案】C。

解析:数据的存储常用位、字节、字和字长等来表示。

C 选项,二进制位(bit),表示一个二进制数码0 或1,是计算机中数据存储的最小单位; A 选项,字(Word),是计算机进行数据处理时,一次存储、处理和传送的数据; B 选项,字节(Byte),由8 位组成,是数据存储的基本单位;D 选项,字长是在同一时间中处理二进制数的位数。

6.计算机的主频是指()。

A.硬盘的读写速度B.显示器的刷新速度C.CPU 的时钟频率D.内存的读写速度6【.答案】C。

解析:本题考察的是计算机的性能指标。

计算机的主频是指CPU 的时钟频率,即CPU位为M Hz 。

它在很大程度上决定计算机越高,计算机的运算速度。

主频出的脉冲数,单在单发位时间内、运算速度、存取周期、存取容量。

的运算速度越快。

性能指标还包括:字长7.下列描述中,正确的是()。

A.1KB=1000BB.1KB=1024 ×1024BC.1MB=1024BD.1MB=1024 ×1024B7.【答案】D。

解析:二进制序列用以表示计算机、电子信息数据容量的量纲,基本单位为字节B,的1024 倍,比如1KB=1024B ,1M=1024KB ,字节向上分别为KB 、MB 、GB、TB ,每级为前一级1GB=1024MB 。

8.在Window7 中,关于快捷方式说法正确的是()。

A.一个对象可以有多个快捷方式B.不允许为快捷方式创建快捷方式C.一个快捷方式可以指向多个目标对象D.只有文件和文件夹对象可以创建快捷方式8.【答案】A 。

解析:一个对象可以创建多个快捷方式,快捷方式也可以再次创建快捷方式,一个建快捷方式。

因此 A 正确。

算机中的任何文件、文件夹都可以创对象,计快捷方式只能指向一个目标9.下列不属于操作系统的是()。

A.LinuxB. MicroSoft OfficeC.WindowsD.Mac OS9.【答案】B。

解析:B选项MicroSoft Office 是微软公司开发的一套基于Windows 操作系统的办公项,Windows;C选项,Linux 来源于UNIX ,是一个开放源码的操作系统软件套装,不属于操作系统。

A选项,Mac OS 是一套运行于苹果Macintosh 系列电脑上的操作系开发是美国微软的窗口化操作系统;D选。

统10.下列关于Windows7 的描述中,错误的是()。

A.Windows7 是一个多任务操作系统,允许多个程序同时运行B.在某一时刻,只能有一个窗口处于活动状态C.非活动窗口在后台运行D.非活动窗口可以接收用户的键盘和鼠标输入等操作10.【答案】D。

解析:某一时刻,只能有一个窗口处于活动状态,非活动窗口不能接收用户的键盘等操作。

和鼠标11.在Windows 系统中,如果菜单项的文字后出现()标记,则表明单击此菜单会打开一个对话框。

A. ?B.⋯C.√D.?11【.答案】B。

解析:本题考察Windows 系统中菜单的常用符号的含义。

命令名后带有省略号(⋯):行该命令将会打开一个级菜的三角形:表示执联表示该命令执行后将弹出对话框;A选项,命令名右侧单;C 选项,命令名前有√号标记:表示该命令正在起作用,再次单击该命令可删除√号标记,则该命令将不再起作用; D 选项,命令名前有?号标记:表示在并列的几项功能中,每次只能选用其中一项。

12.下列关于对话框的叙述中,正确的是()。

A.拖动标题栏可以移动对话框B.都可以改变大小C.可以最小化成任务栏图标D.可以双击标题栏完成窗口的最大化和还原的切换12.【答案】A。

解析:窗口分为应用程序窗口、文档窗口和对话框窗口。

对话框窗口可以通过拖动标题栏进行移动,但不能改变大小,也不能进行最小化、最大化和还原等操作。

13.在Windows7 中文件名不能使用()。

A.空格 C.下划线 D.单引号13.【答案】B。

解析:文件命名时,不能使用的字符有“”、“/”、“* ”、“:”、“?”、“<”、“>”、“| ”、“””等。

14.在Windows7 中,文件的属性不包含()。

A.隐藏B.只读C.共享D.存档14.【答案】C。

解析:文件和文件夹都有属性,包括只读、隐藏、存档和系统属性,没有共享属性,因此本题选择C。

15.在Word2010 中,插入图片时,默认的文字环绕方式是()。

A.嵌入型B.四周型C.紧密型D.浮于文字上方15.【答案】A。

解析:Word 中,插入图片时,默认的文字环绕方式是嵌入型。

16.在Word2010 中,如果操作出现操作失误,可以使用()返回到原来的状态。

A.撤消 B 恢复 C.删除 D.重启应用程序16.【答案】A。

17.在Word2010 中,插入分节符,应该选择()下的“分隔符”命令。

A.开始B.页面布局C.插入D.引用17.【答案】B。

18.在Word2010 中,主要用于设置和显示标题层级结构的是()。

A.页面视图B.大纲视图C.Web 版式视图D.阅读版式视图18.【答案】B。

19. Excel2010 中,一个工作簿最多可包含()个工作表。

A.3B.16C.255D.无数19.【答案】D。

20.Excel2010 中,若要同时选定B2:C6 和E1:F2,下列正确的操作的是()。

A.按住鼠标左键从B2 拖动到C6,然后按住鼠标左键从E1 拖动到F2B.按住鼠标左键从B2 拖动到C6,按住Shift ,并按鼠标左键从E1 拖动到F2C.按住鼠标左键从B2 拖动到C6,按住Ctrl ,并按鼠标左键从E1 拖动到F2D.按住鼠标左键从B2 拖动到C6,按住Alt ,并按鼠标左键从E1 拖动到F221.Excel2010 中,若单元格中的数字超过11 位时,将会()。

A.自动加大列宽B.显示为######C.显示错误值#VALUE!D.以科学计数法形式显示22.在Excel2010 中,将Sheet1的A1 单元格内容与Sheet2的B2 单元格内容相加,计算结果放在Sheet3 的A1 单元格中,则在Sheet3的A1 单元格中应输入()。

A.=Sheet1$A1+Sheet2$B2B.=Sheet1 !A1+Sheet2!B2C.Sheet1$A1+Sheet2!B2D.Sheet1! A1+Sheet2$B223.Excel2010 中,使用升序、降序按钮做排序操作时,活动单元格应选定()。

A.工作表的任何地方B.数据清单的任何地方C.排序依据数据列的任一单元格D.数据清单标题行的任一单元格24. Excel2010 中,若在单元格中输入“1/2”,则系统将其视作()。

A.0.5B.分数1/2C.1 月2 日D.字符串25.()的性能直接影响计算机的运行速度,很大程度上代表了所配置的计算机系统的性能。

A.CPUB.内存C.硬盘D.显卡26.在Excel2010 中,公式“ 3.14*$C$4 ”中对C4 单元格进行了()。

A.相对引用B.绝对引用C.混合引用D.非法引用27.在Excel2010 中有三种迷你图样式,其中不包含()。

A.折线图B.柱形图C.饼状图D.盈亏图28.在Excel2010 中,单元格Cl 到C10 分别存放了10 位同学的考试成绩,下列用于计算机考试成绩在80 分以上的人数的公式是()。

A.=COUNT(C l :C10 ,“>80”)B.=COUNT(C1:C10 ,>80)C.=COUNTIF(Cl:C10 ,“>80”)D.=COUNTIF(C1:C10 ,>80)29.CPU 主频的单位是()。

A.GHzB.GBC.bpsD.MB/s29.【答案】A。

解析:计算机的主频是指CPU 的时钟频率,即CPU 在单位时间内发出的脉冲数,单位为MHz 、GHz 。

30.PowerPoint 2010 中,在“幻灯片”选项卡下,如果选择不连续的多张幻灯片,则按住()键,依次单击要选的幻灯片。

A.ShiftB.CtrlC.AltD.Space31.一张分辨率为640*480 的位数为32 位真彩色的位图,其文件大小是()。

A.307200MBB.307200KBC.1200KBD.1200B32.PowerPoint 2010 中,若要设置换片方式,应该选择()选项卡。

A.设计B.切换C.动画D.幻灯片放映33.快捷方式就是一个扩展名为()的文件。

A.batB.exeC.inkD.ini33.【答案】C。

解析:快捷方式的扩展名是“.ink ”。

A 选项.bat 是批处理文件的扩展名; B 选项.exe 是应用程序的扩展名; D 选项.ini 是配置文件扩展名。

34. PowerPoint 2010 在幻灯片浏览视图下,不能进行的操作是()。

A.排列幻灯片B.删除幻灯片C.编辑单张幻灯片的具体内容D.改变幻灯片的版式35.Access2010 的数据库文件扩展名是()。

相关文档
最新文档