A, true or false (this question *** 10 points, choose a for right, choose b for wrong)
(1) Instructions and data are stored in the computer in the form of area code.
(2)UNIX is a multi-user single-task operating system.
(3) In Windows, double-click the time displayed on the taskbar to modify the computer time.
(4) In Windows Explorer, you can use the [Options] or [Folder Options] command in the [View] menu to make all file directories displayed in the window display extensions.
(5) The AutoCorrect function of Word can only replace words, not pictures.
(6) In Word, "format brush" can copy the style of wordart.
(7) In Excel, if a data list needs to be printed on multiple pages, and each page has the same title, it can be set in the Page Setup dialog box.
(8) In the data list of Excel, the Record Table command in the Data menu can easily insert, delete or modify the values of record data and formula fields.
(9) In PowerPoint slide view, only one slide can be viewed or edited in the main window at any time.
(10) A letter can be sent to multiple recipients at the same time by e-mail.
Second, multiple-choice questions (this question ***30 points)
(1 1) The following _ _ _ _ _ _ _ groups of devices include input devices, output devices and storage devices.
A, CRT, CPU, ROM B, mouse, plotter, CD.
C, disk, mouse, keyboard d, tape, printer, laser printer.
12) In a microcomputer, VGA stands for _ _ _ _ _ _ _ _.
A, monitor model b, machine model c, monitor standard d, CPU model
13) The capacity of computer hard disk is much larger than that of floppy disk, and the reading and writing speed is faster than that of floppy disk _ _ _ _ _.
A, almost B, slow down. -c, much faster. D, much slower.
14) The update and development of microcomputer is mainly based on the change of _ _ _ _ _.
A, software b, microprocessor c, memory d, disk capacity
15) The media is _ _ _ _ _ _ _ _.
A, the carrier representing information and spreading information B, the coding of various information.
C, computer input and output information D, computer screen display information
16) The operating system is a kind of _ _ _ _ _
Computer prediction test questions of Shandong college entrance examination in 2006 (including answers)
One. Multiple choice questions (65438+ 0 point for each question)
1. The auxiliary memory in the microcomputer can directly transfer data with the following () components? ( )
A. arithmetic unit
B. Internal memory
C. controller
D. microprocessor
2. The personnel file management system used on the microcomputer belongs to the following computer applications (). ( )
A. Artificial intelligence
B. Expert system
C. Information management
D. Scientific calculation
3. In the computer network, the index of data transmission reliability is (). ( )
A. Bit error rate
B. Frequency band utilization
C. Channel capacity
D. transmission rate
4. In the computer network, the index of data transmission effectiveness is (). ( )
A. Bit error rate
B. Frequency band utilization
C. Channel capacity
D. transmission rate
5. Among the following four statements, the wrong one is (). ( )
The ability of two or more systems to exchange information is called compatibility.
B when the software environment (hardware/supporting software) changes, the software can still play its original functions, so it is called compatible software.
Hardware components that can be used in various systems without adjustment or with little adjustment are called compatible hardware.
Computers produced by famous computer manufacturers are called compatible computers.
6. In order to guide the interconnection, interoperability and interoperability of computer networks, ISO promulgated the OSI reference model, the basic structure of which is divided into (). ( )
A.6 floor
B.5 floor
C.7 floor
D.4 floor
7. Among the following characters, the smallest ASCII code is _ _ _ _ ()
A.K
bachelor of arts
C.h
D.H
8. Compared with communication network, the most essential function of computer network is (). ( )
A. Data communication
B. Access to resources *
C. improving the reliability and availability of computers
D. distributed processing
9. The role of the modem is to realize (). ( )
A. conversion between analog and digital signals
B. Digital signal coding
C. amplification of analog signals
D. shaping of digital signals
10. After the LAN networking is completed, the key to determine the network performance is (). ( )
A. Topological structure of the network
B. Communication protocol of the network
C. network transmission medium
D. Network operating system
1 1. The main function of the network card (network adapter) does not include (). ( )
A. connecting a computer to a communication medium
B, performing electrical signal matching.
C. Realizing data transmission
D. network interconnection
12. The basic unit of data processing by microprocessor is word. The length of a word is usually (). ( )
A. 16 binary number
B.32 binary bits
C.64 binary digits
D. it is related to the model of microprocessor chip.
13. If the address segment of memory space is 300 1H to 7000H, it can represent () bytes of memory space. ( )
A. 16KB
4 kilobytes
4MB
D. 16MB
14. The main basis for choosing a network card is the topology of the network, the maximum length of the network segment, and the distance between the node and (). ( )
A. the type of computer connected to the network
B. Type of transmission medium used
C. Type of network operating system used
D. the scale of the internet
15. In Windows, the window of "Explorer" is divided into two parts, of which the left part shows (). ( )
A. the contents of the currently opened folder
B. Tree folder structure of the system
C. Names of currently opened folders and their contents
D. the name of the currently opened folder
16. In the keyboard used by microcomputer, the Shift key is (). ( )
A. shift key
B. Backspace key
C. space bar
D. Enter and line feed keys
17. In a computer, floating-point numbers are composed of two parts, namely sequence code and (). ( )
A. mantissa
B. Cardinality
C. integers
D. decimals
18. The salary management system developed by a company belongs to () according to the type of computer application. ( )
A. Scientific calculation
B. aided design
C. data processing
D. real-time control
19. The binary number equivalent to hexadecimal number (AB) is (). ( )
a . 10 10 10 10
b . 10 10 10 1 1
c . 10 1 1 10 10
d . 10 1 1 10 1 1
20. The main working feature of the computer is (). ( )
A. high-speed
B. High accuracy
C. Memory ability
D. stored programs and program control
2 1. Compared with Wan, Lan (). ( )
A. Good effectiveness but poor reliability
B. Poor effect but high reliability
C. good effectiveness and high reliability.
D. Poor effect and reliability
22. A complete computer system should include (). ( )
A. System hardware and system software
B. Hardware system and software system
C. Host and external devices
D. host, keyboard, display and auxiliary memory
23. According to the geographical scope of network distribution and coverage, computer networks can be divided into (). ( )
A. local area network, internet and internet
B. Wan, Lan and Man
C. Wan, Internet and MAN
D. Internet, metropolitan area network and Novell network
24. At present, the logic element used in microcomputers is (). ( )
A. Small scale integrated circuits
B. Medium-scale integrated circuits
C. large-scale and ultra-large-scale integrated circuits
D. discrete components
25. The difference between software and program is (). ( )
A. the program is cheap and the software is expensive.
B. The program is written by the user himself and the software is provided by the manufacturer.
C program is written in high-level language, and software is written in machine language.
D software is the general name of programs and all documents needed for development, use and maintenance, and programs are a part of software.
26. The following four different binary unsigned integer, the minimum value is (). ( )
A. 100 100 10(B)
B.22 1(O)
C. 147 (D)
D 94 (H)
27. LAN network software mainly includes network database management system, network application software and (). ( )
A. Server operating system
B. Network operating system
C. network transmission protocol
D. Workstation software
28. Among the following four statements, the one that is wrong is (). ( )
A. numerical calculation focusing on problems in the field of science and technology is called scientific calculation.
B Computer applications can be divided into numerical applications and non-numerical applications.
There are two kinds of information flow between computer components, namely data flow and control flow.
D collection, storage, processing and transmission of information (i.e. various forms of data) are collectively called real-time control.
29. The original code of decimal number (-123) is expressed as (). ( )
a . 1 1 1 1 10 1 1
B. 10000 100
C. 10000 10
d . 0 1 1 1 10 1 1
30. Client/server mode LAN, its network hardware mainly includes server, workstation, network card and (). ( )
A. Network topology
B. computers
C. transmission medium
D. network protocol
Two. Multiple choice questions (2 points for each small question)
1. In the following description about the first electronic computer ENIAC, () is wrong. ( )
A. Its main components are electron tubes and relays.
Its main working principle is stored program and program control.
It was invented in America in 1946.
D. its main purpose is data processing.
2. In Windows, the desktop refers to (). ( )
A. computer desk
B. Active window
C. Screen background where windows, icons and dialog boxes are located
Neither D.A nor b is correct.
3. The following belong to the system software (). ( )
A. A multi-user computer operating system
B. Disk operating system
C. computer-aided design
Be good at
4. In the Windows environment, assuming that the file has been selected, the following statement about the "copy" operation of the file manager is correct (). ( )
A. drag directly to the icons of different drives.
Hold down the SHIFT key and drag it to the icons on different drives.
Hold down the CTRL key and drag it to the icons on different drives.
Hold down the SHIFT key and drag it to another subdirectory of the same drive.
5. Change the date and time of the current computer in Windows. Yes (). ( )
A. Double-click the time on the taskbar
B. use the regional settings in the control panel.
C. Use accessories
D. use the date/time in the control panel.
6. In the following statement, the correct one is (). ( )
A complete computer system consists of hardware system and software system.
B. The main feature that computers are different from other computing tools is that they can store programs and data.
C. After the power is turned off, the information in the ROM will be lost.
D. 16-bit word length The maximum number that a computer can handle is 16-bit decimal number.
7. Among the following Excel formula input formats, () is correct. ( )
A.=SUM( 1,2,…,9, 10)
B.=SUM(E 1:E6)
C.= SUM(a 1; E7)
D.=SUM(" 18 "," 25 ",7)
8. The following software, () belongs to the system software. ( )
A. computer-aided design
B. words
C. assembler
D.c language compiler
9. The printer command in 9.Windows settings can be (). ( )
A. change the properties of the printer
B. Print screen information
C. Clear recently used documents
D. Add a new printer
10. In Word, the following statement about margins is true (). ( )
A. Setting margins will affect the indentation of the original paragraph.
B The setting of margins only affects the current page or the page where the selected text is located.
C users can set the left margin, right margin, upper margin and lower margin at the same time.
D. users can use the ruler to adjust the margins.
Three. True or false (65438+ 0 point for each small question)
1. The main technical index that determines the accuracy of computer calculation is the storage capacity of the computer. ( )
2. In Excel, once a chart is created, the font and font of its title cannot be changed. ( )
3. A workbook in 3.Excel is a collection of worksheets. ( )
4.UNIX is a multi-user single-task operating system. ( )
Both assembly language and machine language belong to low-level languages, because programs written with them can be directly recognized and executed by computers, so they are called low-level languages. ( )
6. You can't view the remaining space of the disk in Windows Explorer. ( )
7. In the Chinese character system, all national standard Chinese characters in China are arranged in pinyin order. ( )
8. If the microcomputer is infected with virus, all viruses can be eliminated by deleting all files with virus. ( )
9.Windows operating system allows a computer to install multiple print drivers at the same time and connect multiple printers. But the default printer is only one. ( )
Automatic correction function of 10. Word can only replace text, not images. ( )
Four. Fill in the blanks (2 points for each small question)
1. The storage capacity of floppy disk is calculated as follows: number of disks × number of tracks per side × _ _ _ _ _ × number of bytes per sector.
2. Insert the picture directly in the Word document, or insert the picture in the text box or _ _ _ _ _ _ _.
3. The ASCII code of "n" is 4EH, so it can be inferred that the characters corresponding to the ASCII code of 01010b are _ _ _ _ _ _ _ _.
4. Microcomputer with microprocessor as the core belongs to _ _ _ _ _ _ _ generation computer.
5. When inputting data in Excel, if the input data has some inherent laws, you can use its _ _ _ _ _ _ _ function to input.
6. An ordered set of computer instructions is called _ _ _ _ _ _ _ _.
7. In Excel, suppose there is a database worksheet with items such as departments, scholarships and grades. Now it is necessary for all departments to distribute the sum of scholarships. First, the department _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
8. In Word, after defining the commonly used words or graphs as the entry names, the purpose of quick and simple input can be achieved by using the entry names every time. This method adopts automatic correction or _ _ _ _ _ _ _ _.
9. The correct typing fingering should put the right index finger on _ _ _ _ _ _ _.
10. In Excel, it is known that numerical data is entered in (A 1: A 10), and the following results are required in A1:when (a1:a1) Then the formula of cell A 1 1 is _ _ _ _ _ _ _.
1 1.CPU is the core component of a computer, which is mainly composed of a controller and _ _ _ _ _ _ _.
12. _ _ _ _ _ _ The writing style of the language is close to people's thinking habits, which makes the program easier to read and understand.
13. The core of the system software in the computer is _ _ _ _ _ _ _ _, which is mainly used to control and manage all the software and hardware resources of the computer.
14. The operating system with timeliness and high reliability is _ _ _ _ _ _ _ _ _ _
15. In Excel, if there is a two-dimensional table, the fifth column is the student scholarship and the sixth column is the student achievement. Given the student data in rows 5 to 20, now the total number of scholarships should be filled in the fifth column of row 2 1, so the cell should be filled in _ _ _ _ _ _ _ _.
16. In Excel, if you only need to print part of the worksheet data, you should first _ _ _ _ _ _ _ _.
17. The main feature of multimedia technology is the diversity of information carriers. For the comprehensive processing and integrated processing of various information, the multimedia system is a _ _ _ _ _ _ _.
18. In Excel, the formula = sum (sheet 1: sheet 5! $E$6) means _ _ _ _ _ _ _.
19. The address range is 1000H? The storage space of 4FFFH _ _ _ _ _ _ _ _ _ _ KB.
20. Many computer software installers have the same file name, and so do Windows systems. The file name of their installer is generally _ _ _ _ _ _ _ _.
Answer one. Multiple choice questions (65438+ 0 point for each question)
1.B 2。 C 3。 A 4。 D 5。 D 6。 C 7。 D
8.B 9。 A 10。 D 1 1。 D 12。 D 13。 A 14。 B
15.B 16。 A 17。 A 18。 C 19。 B 20。 D 2 1。 C
22.B 23。 B 24。 C 25。 D 26。 B 27。 B 28。 D
29. A 30. C
Two. Multiple choice questions (2 points for each small question)
1.a,D 2。 c,D 3。 a,B 4。 a,C 5。 a6。 a,B 7。 b,D
8.c,D 9。 a,D 10。 C, d
Three. True or false (65438+ 0 point for each small question)
1.× 2.× 3.√ 4.× 5.× 6.× 7.×
8.× 9.√ 10.×
Four. Fill in the blanks (2 points for each small question)
1. Number of sectors per track 2. basic framework
3.J 4。 Four or four or four.
5. Fill in 6. procedure
7. ranking 8. Automatic atlas
9.j or j 10. = if (average (a 1: a2) > =, "qualified", "unqualified")
1 1. Operator 12. advanced
13. Operating system 14. rtos
15.= SUM(E5:E20)or = SUM(E5:E20)or = SUM(E5:E20)or = sun(E5:E20) 16。 Select the print area.
17. Interactive system 18. Sheet 1 to the sum of the values of all E6 cells in Sheet5.
19.16 20.setup.exe or SETUP.EXE or Setup.exe.
I don't know if this is what you want.