【正文】 個(gè)工作簿中建立的工作表的數(shù)量是有限的 46．在Excel97中，編輯數(shù)據(jù)是以[ ]為單位。A．工作簿B．工作表C．單元格D．工作區(qū)域47．改變Excel97圖表的大小可拖動(dòng)圖表[ ]完成。B．控點(diǎn)C．中間D．上部48．若在Sheet2的C1單元格內(nèi)輸入公式時(shí)，需引用Sheetl的A2單元格的數(shù)據(jù)，正確引用為[ ]。A．Sheetl!A2 B．Sheet1(A2)C．Sheet1A2 D．Sheetl!(A2)49．如在Excel97單元格中輸入公式“＝SUM(A1：A2，B1：C2)，其功能是[ ]A．＝A1十A2十B1十B2十C2 B．＝A1十A2十A3十B2十C2C．＝A1十A2十B1十B2十C1十C2 D．＝A1十A2十B1十C2 50．用Del鍵可以刪除單元格中[ ]A．內(nèi)容B．格式C．批注51．就目前的實(shí)際情況而言，使用最普遍的拓?fù)浣Y(jié)構(gòu)是[ ]。A。星型B．環(huán)狀C．網(wǎng)狀D．以上都不對(duì) 52．連接計(jì)算機(jī)與物理線(xiàn)路的是[ ]。A．路由器B．交換機(jī)C．中繼器D．網(wǎng)卡53．能夠提供兩個(gè)節(jié)點(diǎn)之間路徑選擇功能的協(xié)議是[ ]層協(xié)議oA．傳輸D．物理54。關(guān)于IP地址，下面說(shuō)法錯(cuò)誤的是[ ]。A．所有接入Internet的計(jì)算機(jī)都必須有一個(gè)IP地址B．IP地址可以靜態(tài)分配，也可以動(dòng)態(tài)分配、B、C、D四類(lèi)D．IP地址是0SI參考模型中的第三層地址 ，“工具”菜單下“Internet”選項(xiàng)不能完成的任務(wù)是[ ]。A．自定義安全級(jí)別C．設(shè)置代理服務(wù)器地址D．設(shè)置本機(jī)IP地址59．一個(gè)用戶(hù)在一臺(tái)名為“”的郵件服務(wù)器上有一個(gè)帳號(hào)“test”，則其郵件地址為[ ]。A．test＠＠C．test＠＠ ，以下的[ ]原因，可能會(huì)導(dǎo)致郵件無(wú)法發(fā)出oA．接收方計(jì)算機(jī)關(guān)閉 63．計(jì)算機(jī)感染病毒后，比較合適的處理方法是[ ]。A．立即刪除磁盤(pán)上的文件C，通過(guò)工具軟件隔離或刪除被感染文件D．報(bào)告上級(jí)領(lǐng)導(dǎo) 64．通常說(shuō)的“WebMail”指的是[ ]A．通過(guò)Web界面使用MailB．通過(guò)HTTP協(xié)議傳輸MailC．通過(guò)Web服務(wù)器保存Mail “WebMail”軟件訪(fǎng)問(wèn)Mail 65．導(dǎo)致信息安全問(wèn)題產(chǎn)生的原因比較多；但綜合起來(lái)一般有[ ]兩類(lèi)oA．物理與人為B．黑客與病毒C．系統(tǒng)漏洞與硬件故障D．計(jì)算機(jī)犯罪與破壞 66．防火墻軟件一般用在[ ]A．工作站與工作站之間B．服務(wù)器與服務(wù)器之間C．工作站與服務(wù)器之間D．網(wǎng)絡(luò)與網(wǎng)絡(luò)之間 67．目前，被認(rèn)為是最有效的安全控制方法是[ ]B．用戶(hù)權(quán)限設(shè)置C．限制對(duì)計(jì)算機(jī)的物理接觸 68．一個(gè)數(shù)據(jù)備份系統(tǒng)至少應(yīng)包括[ ]A．先進(jìn)的備份技術(shù)B．備份軟件及相應(yīng)物理設(shè)備C。磁帶機(jī)及磁帶D。光盤(pán)驅(qū)動(dòng)器及光盤(pán) 69．關(guān)于源程序，以下說(shuō)法正確的是[ ]A。源程序是可執(zhí)行程序B。源程序只能通過(guò)編程工具打開(kāi)，不能用EDIT、記事本之類(lèi)的工具打開(kāi)C．源程序是純文本文件，可用任何文本編輯工具打開(kāi)D．源程序是二進(jìn)制文件，不能用文本編輯工具打開(kāi) 70．關(guān)于數(shù)據(jù)庫(kù)文件，下面說(shuō)法錯(cuò)誤的是．A．?dāng)?shù)據(jù)庫(kù)文件需要在某一數(shù)據(jù)庫(kù)管理系統(tǒng)支持下建立B．?dāng)?shù)據(jù)庫(kù)文件是以一定的組織方式存儲(chǔ)在一起的相關(guān)數(shù)據(jù)的集合 C．在結(jié)構(gòu)固定時(shí)，記錄的多少?zèng)Q定數(shù)據(jù)庫(kù)文件的大小D．多個(gè)用戶(hù)不能同時(shí)訪(fǎng)問(wèn)數(shù)據(jù)庫(kù)文件二、多項(xiàng)選擇題(共10小題，每小題2分，共20分。在給出的選項(xiàng)中至少有二個(gè)是正確的，請(qǐng)將你選擇的答案寫(xiě)在答題紙上相應(yīng)位置處，多選或少選均不得分)o 1．計(jì)算機(jī)指令組成包括[ ]。A．原碼B．操作碼C．地址碼D．BCD碼 2．以下屬于外部設(shè)備的是[ ]。A．光盤(pán)驅(qū)動(dòng)器B．顯示器C．ROM D．硬盤(pán) 3．通過(guò)“添加／刪除程序”能夠完成的任務(wù)是[ ]。A．安裝新的軟件B．刪除已安裝的軟件C．制作Window698啟動(dòng)盤(pán) 4．磁盤(pán)掃描程序的主要功能有[ ]。A．檢測(cè)文件及文件夾是否有錯(cuò)B．對(duì)硬盤(pán)的碎片進(jìn)行整理C．掃描磁盤(pán)表面，檢測(cè)是否有錯(cuò)誤D．壓縮磁盤(pán)文件 5．通過(guò)“頁(yè)面設(shè)置”選項(xiàng)，可以完成[ ]設(shè)置。A．頁(yè)邊距B．紙張大小C．打印頁(yè)碼范圍D．紙張的打印方向 6．在Word 97中，可以對(duì)[ ]加邊框。A．表格B．段落C．圖片D．選定文本 7．在Excel97中，單元格地址的引用方式有[ ]。A．絕對(duì)引用B．相對(duì)引用C．混合引用D．間接引用 8．關(guān)于Internet，下面說(shuō)法正確的是[ ]。A．Internet是安全可靠的B．Internet也在不斷發(fā)展，下一代Intemet也已經(jīng)出現(xiàn)C．Internet是由許多LAN與WAN組成的D．Internet中有許多商業(yè)機(jī)會(huì)9．為保證電力供應(yīng)系統(tǒng)的可靠性，常采用的方式有[ ]。A．安裝接地系統(tǒng)B．安裝UPSC．直接從供電局接專(zhuān)線(xiàn)D．安裝穩(wěn)壓電源 10．程序設(shè)計(jì)過(guò)程中必不可少的步驟是[ ]。A．編輯源程序B．程序排版D．資料歸檔三、填空題(共10小題，每題2分，共20 分，請(qǐng)將你的答案寫(xiě)在答題紙上相應(yīng)位置處)o 1．馮諾伊曼(Von．Neumann)第一個(gè)提出了計(jì)算機(jī)的[ ]概念，莫定了計(jì)算機(jī)的基本結(jié)構(gòu) 2．運(yùn)算器的主要功能是[ ]。3．十進(jìn)制數(shù)130對(duì)應(yīng)的八進(jìn)制數(shù)是[ ]。4．如果Windows98系統(tǒng)出現(xiàn)了錯(cuò)誤，可以在啟動(dòng)時(shí)選擇[ ]模式來(lái)自動(dòng)修正錯(cuò)誤。5．可以通過(guò)“控制面板”中的[ ]選項(xiàng)設(shè)置或更改計(jì)算機(jī)名稱(chēng)。6．在Word97中，頁(yè)碼除可在“插入”菜單項(xiàng)中設(shè)置外，還可在“視圖”菜單中選擇[]設(shè)置。7．目前使用最多的是[ ]型數(shù)據(jù)庫(kù)o 8．欲使Excel97表格的標(biāo)題在表格的中央，應(yīng)使用格式工具欄中的[ ]命令按鈕o 9．在沒(méi)有用戶(hù)名及口令時(shí)，一般均可以通過(guò)[ ]方式登錄到FTP服務(wù)器o 10．計(jì)算機(jī)病毒是具有生物病毒特點(diǎn)的[ ]。四、簡(jiǎn)答題(共5小題，每題4分，共20分，請(qǐng)?jiān)诖痤}紙上答題)。1．簡(jiǎn)述程序的幾種基本控制結(jié)構(gòu)，并用你最熟悉的程序設(shè)計(jì)語(yǔ)言給出其語(yǔ)法示例。2．簡(jiǎn)述計(jì)算機(jī)基本工作過(guò)程，并舉例說(shuō)明。3．右鍵單擊“網(wǎng)上鄰居”，選擇快捷菜單中“屬性”選項(xiàng)，能夠完成的主要任務(wù)有哪些? 4．簡(jiǎn)述Word97中格式復(fù)制的操作過(guò)程。5．局域網(wǎng)的主要組成部分及其功能是什么?五、程序設(shè)計(jì)(三小題，共20分，程序設(shè)計(jì)語(yǔ)言不限。請(qǐng)將程序?qū)懺诖痤}紙上)o 1．(5分)從鍵盤(pán)輸入三個(gè)數(shù)，編程求出三個(gè)數(shù)中最大數(shù)和最小數(shù)，并顯示輸出。2．(7分)從鍵盤(pán)輸入一個(gè)正整數(shù)n，編程求出，即，并將結(jié)果顯示輸出。3．(8分)已知三個(gè)矩陣A(32)、B(24)、C(34)，分別由數(shù)組AL3，2]、B[2，4]、C[3，4]表示，請(qǐng)編程實(shí)現(xiàn)矩陣乘法，即C＝AxB(C(i，j)＝A(i，1)xB(1，j)十A(i，2)B(2，j))o安徽省2003年普通高等學(xué)校專(zhuān)升本招生考試計(jì)算機(jī)基礎(chǔ)參考答案及評(píng)分標(biāo)準(zhǔn)第四篇：安徽省普通高等學(xué)校專(zhuān)升本招生考試英語(yǔ)考前密押試卷安徽省普通高等學(xué)校專(zhuān)升本招生考試考前密押試卷（一）英 語(yǔ)Part Ⅰ.Vocabulary and Structure(1 point each, 30 points in all)Directions: There are 30 inplete are required to plete each one by deciding on the most appropriate word or words from the 4 choices marked A, B, C and D, then write the corresponding letter on the Answer don’t think Mary understood what you said, _____? I ’t she you she it in 1969 _____ the American astronaut succeed _____ landing on the moon? 。on 。on 。in D that。in news reporters hurried to the airport, only _____ the film stars had tell be told became a teacher in _____ for twenty years by next teach have taught been teaching have been teaching that you know _____ in fact you don’t is not a good _____ when the bus came to a sudden almost hurt almost to hurt himself almost hurt himself almost hurting himself differs from plastics _____ it is produced naturally and not in file that that that that no money but _____ to know, he simply said he would go without to want anyone no one wanting anyone want no one man is often much wiser than a time of the times of the time of time of answered all the questions _____the last I mention the problem, I’m not _____ all of about to to out haven’t time _____ to catch the train team was counting on Joe _____the win bought a dozen eggs, six _____broke when I dropped the box at my which which which which ’m sorry I can’t help _____your fixed fix fixing did very well, but he failed _____the breaking break broken idea seems to be good but it isn’t trusts you。only you can _____ her to give up the foolish Internet has brought _____ big changes in the way we am sure David will be able to find the library because he has a pretty good _____ of evening news es on at seven o’clock and _____ only thirty factory had to _____ a number of employees because of the economic crisis in the out off aside down may have different opinions about Karen, but I admire , she is a great all a result other words usual had a pleasant chat _____ a cup of ments which he made _____ marketing bothered his boss concerned concerned the new technique was introduced, the factory produced _____ cars in 2002 as the year many twice twice many many as as many dictionary _____me ten , you are so job _____hours finish be finished have been finished have been finished salesman persuaded us _____his buy bought you learn or not is entirely _____ to to to to Part Ⅱ.Cloze(1 point each, 15 points in all)Directions: There are 15 blanks in the following each blank there are 4 choices marked A, B, C and should choose the ONE that best fits into the passage and write the corresponding letter on the Answer young people enjoy physical activities, walking, cycling, football, or who have a passion(31)climbing high and difficult mountains are of