Who knows the business administration of Chengdu University?

Examination questions of Computer Culture Basis

First, multiple-choice questions (65438+ 0 points for each small question)

1. The unit of microcomputer memory capacity is ().

A. a small amount

B. bytes

C. words

D.bit

2. 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

3. The main working feature of the computer is ().

A. high-speed

B. High accuracy

C. Memory ability

D. stored programs and program control

4. 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

5. 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

6. 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

7. In Excel, if you want to modify the calculation order, you need to enclose the first part of the formula with ().

A. in parentheses

B. in double quotation marks

C. Enclose in single quotation marks

D. in parentheses

8. 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.

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

The original code of 10. The 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

1 1. 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

12. 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

13. 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

14. Among the following four unsigned decimal numbers, () can be expressed in octet.

A.256

B.299

C. 199

D.3 12

15. 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.

16. In Word, if you want to make two Chinese characters overlap, you can use the () command in the Format menu to set it.

A. Font

B. Overlap

C. severe

D. side-by-side characters

17. 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

18. 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

19. In order to guide the interconnection, interoperability and interoperability of computer networks, ISO promulgated the OSI reference model, and its basic structure is divided into ().

A.6 floor

B.5 floor

C.7 floor

D.4 floor

20. Among the following four statements, the one that is wrong 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.

2 1. In a computer, floating-point numbers consist of two parts; They are ().

A. Integer part and decimal part

B. Rank code part and radix part

C. radix part and mantissa part

D. Rank code part and mantissa part

22. It is known that a complement is10001kloc-0/,and its true value is expressed in binary as ().

A.-0000 10

B.- 1 1 1 10 10

C.-000000

D.- 1 1 1 10 1 1

23. 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

24. The lowest layer of OSI (Open Systems Interconnection) reference model is ().

A. transport layer

B. Network layer

C. physical layer

D. application layer

25. 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

26. By default, in the Windows Recycle Bin, you can store ().

A. Deleted files or folders on the hard disk

B. Deleted files or folders on floppy disks

C. Deleted files or folders on hard disk or floppy disk

D. Deleted files or folders on the network

27. 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

28. 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.

29. The following four different decimal unsigned integer, the minimum value is ().

A. 100 100 10(B)

B.22 1(O)

C. 147 (D)

D 94 (H)

30. Perform the following logical addition operation (i.e. logical OR operation)101010 ν 01065438. The result is ().

a . 1 1 1 10 100

b . 1 1 10 10 10

C. 1000 10 10

D. 1 1 100000

Second, multiple-choice questions (2 points for each small question)

1. Of the following statements about Word, the correct one is ().

A. When the file was imported, everything displayed on the screen was saved on the disk.

B. After pasting the contents of the clipboard into the document, the contents of the clipboard will no longer exist.

C you can move or copy selected objects in multiple documents by cutting and pasting, copying and pasting.

D the clipboard stores the contents of the cut or copy operation.

2. Among the following components, the input device is ().

A. barcode reader

B. Display

C. scanner

D. printer

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 following description about the printer, () is correct.

A. inkjet printers are non-impact printers.

B.LQ- 1600K is a laser printer.

C. a laser printer is a page printer.

D. The printer with the highest resolution is a stylus printer.

5. Among the following statements about the composition of computer hardware, () is correct.

A. Host and peripheral devices

B. Arithmetic unit, controller and input/output equipment

C.CPU and I/O devices

D. arithmetic unit, controller, memory, input device and output device.

6. In Windows Explorer, assuming that the file has been selected, the following statement about the "copy" operation 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.

7. 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.

8. In Excel, the formula SUM(B 1:B4) is equivalent to ().

A. total (A 1:B4 B 1:C4)

B. Sum (B 1+B4)

C. Sum (b 1+B3 B2+B4)

D. Sum (B 1, B4)

9. 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)

10. The translation program of computer programming language is ().

A. Editing program

B. compiler

C. connecting program

D. assembler

Three. True or false (65438+ 0 point for each small question)

1. When editing text in Word, if you want to Delete the contents of a paragraph of text in the text area, you can select the paragraph of text and press the delete key.

2. In Windows Explorer, you can rename files and subdirectories by using Rename in the File menu.

3. The homepage is a text written in Hypertext Markup Language (HTML).

4. In the Chinese character system, all the national standard Chinese characters in China are arranged in pinyin order.

5. There is no insert/rewrite status in WordPad. It can only enter text by inserting.

6. In Excel, once a chart is created, the font and font of its title cannot be changed.

7. The operating system stores the data or program just entered in ram. In order to prevent information loss, users should save information in ROM before turning off the computer.

8. Double-click the rewrite status box in Word to make the word "rewrite" thicker, indicating that the current input status has been set to rewrite status.

9. You can't send letters to multiple recipients at the same time by email.

10. If the microcomputer is infected with a virus, all viruses can be eliminated by deleting all files with viruses.

1 1. Assembly language and machine language belong to low-level languages, so they are called low-level languages because programs written with them can be directly recognized and executed by computers.

12. Files with the same name are allowed on the same floppy disk.

13. In Windows, as long as "Use Chinese Symbols" is selected in the Chinese character input method, full-width Chinese punctuation marks such as half-width, quotation marks and periods can also be output in the state of "Chinese half-width".

14. In Word text, only one text block can be defined at a time.

15. If a computer wants to run a program, it must be transferred to ram before it can run.

16. Generally speaking, the characters in the computer are encoded with ASCII code. If the ASCII value of "H" is known to be 48H, it can be inferred that the ASCII value of "J" is 50H.

The hidden text in 17.Word can still be displayed on the screen, but it will not be output when printed.

Automatic correction function of 18. Word can only replace text, not images.

19. Instructions and data are stored in the computer in the form of area code.

20. In Word, "format brush" can copy artistic writing style.

4. Fill in the blanks (65438+ 0 point for each small question)

1. After starting Word, two windows will appear on the screen: the application window and _ _ _ _ _ _ _.

2. The standard ASCII code is binary coded with _ _ _ _ _ _ _ bits.

3. The internal code of each Chinese character needs to be represented by _ _ _ _ _ _ _ _ bytes.

4. In Word, after the paragraph is indented, the distance between the text and the printing paper boundary is _ _ _ _ _ _ _ _.

5. The writing method of _ _ _ _ _ _ _ language is close to people's thinking habits, which makes the program easier to read and understand.

6. When inputting data in Excel, if the input data has some inherent laws, you can use its _ _ _ _ _ _ _ function for input.

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. An ordered set of computer instructions is called _ _ _ _ _ _ _ _.

9. 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.

10. In Word, the function of the Cut command under the Edit menu is _ _ _ _ _ _ _ _.

1 1. The information is uniformly coded in the computer. ASCII is an encoding method. The standard ASCII code uses _ _ _ _ _ _ _ bits to represent 128 characters.

12. To enter arithmetic progression in Excel, you can first enter the first and second series items, then select these two cells, and then move the mouse pointer to _ _ _ _ _ _ _ _ _ _, and drag it in a certain direction.

13. Generally, the information input into the computer can be divided into two categories, one is data, and the other is _ _ _ _ _ _ _ _ _.

14. To modify the date or time in Windows, you should double-click the date/time icon in "_ _ _ _ _ _ _".

15. The operating system with timeliness and high reliability is _ _ _ _ _ _ _ _ _ _

16. In Excel, if there is a two-dimensional table, the fifth column is student scholarships and the sixth column is student grades. 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 _ _ _ _ _ _ _ _.

17. In Excel, if you only need to print part of the worksheet data, you should first _ _ _ _ _ _ _ _.

18. Insert a picture directly in a Word document, or insert a picture in a text box or _ _ _ _ _ _ _.

19. Decimal number1125 converted into hexadecimal number is _ _ _ _ _ _ h.

20. 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 _ _ _ _ _ _ _.

2 1. In Word, after defining commonly used words or graphics as entry names, you can use the entry names every time to achieve the purpose of quick and simple input. This method adopts automatic correction or _ _ _ _ _.

22. In Excel, if you want to print a multi-page list and make the title line of the list appear on each page, you should set it in the _ _ _ _ _ _ _ command on the [File] menu.

23. The easiest way to create an embedded chart in Excel is to use the Chart Type button in the _ _ _ _ _ _ toolbar.

24. The storage space with the address range of 1000h-4ffffh _ _ _ _ _ _ _ _ _ KB.

25. In Excel, the formula = sum (sheet 1: sheet5! $E$6) means _ _ _ _ _ _ _.

26. Many computer software installers have the same file name, and so do Windows systems. The file name of their installer is generally _ _ _ _ _ _ _ _.

27. In Excel, a workbook can contain at most _ _ _ _ _ _ _ sheets.

28. In Excel, suppose there is a database worksheet, which contains items such as name, major, scholarship and grades. Now it is required to rank students of the same major according to the scholarship from high to low, and to rank several key areas. The main keyword segment is _ _ _ _ _ _ _ _ _.

29. in Excel, let the value of cell A 1-A4 be 82,71,53,60, and the formula of cell A5 be = if (average (a $1:a $4) > = 60, "pass" and "fail".

30. For a 2KB storage space, its address can be 000H to _ _ _ _ _ _ _ _.

Simulation test of Computer Culture Foundation.

Reference answers and grading standards

(for reference)

First, multiple-choice questions (65438+ 0 points for each small question)

1.B 2。 C 3。 D 4。 C 5。 B 6。 C 7。 A

8.D 9。 A 10。 A 1 1。 D 12。 C 13。 B 14。 C

15.D 16。 A 17。 D 18。 A 19。 C 20。 D 2 1。 D

22.D 23。 B 24。 C 25。 B 26。 A handful of 27. C 28。 D

29.B 30。 B

Second, multiple-choice questions (2 points for each small question)