What does the information technology test for special post teachers in primary schools take?

29 information technology examination questions for special post teacher recruitment primary school

29-7-13 14:19

Full score 1 minutes

Basic professional knowledge part

1. Multiple choice questions. (Of the four alternative answers to each question, there is only one correct answer that meets the meaning of the question. Please choose the correct answer and fill its number in the brackets after the question. There are 2 questions in this big question, and each question is 1 point. ***2 points)

1. A program written in a high-level language is called ()

A. Source program B. Application program

C. User program D. Utility program

2. In windows2, The function of the recycle bin is ()

a. Recover the files or folders deleted from the hard disk

b. Recover the files or folders deleted from the floppy disk

c. Recover the cut documents

d. Recover the files or folders deleted from the CD

3a, 4a, 5d,

a. CTRL+A B. Press and hold. Click the selected object

C. Shift+A D. After holding down the Ctrl key, click the selected object

7. In the binary arithmetic operation, 1+l is equal to ()

a.1b.2c.1d.

o8. Which of the following buttons is not the alignment button in the formatting toolbar in Word ()

A. Align both ends B. Align left

C. Align right D. Center in the font format

9. By default, The extension of Excel2 document is ()

a.doc.b.xls.c.ppt.d.txt.

1. When searching by file name in Excel, you can use a single character. () instead of any

a.? B．* C．! D.%

11. In Excel2, an area consists of six cells C2, C3, C4, D2, D3 and D4. The following items that cannot represent this area are ()

a.c2: d4b.c4: d2

c.d4: c2d.c2: d2

12. It is known that the ASCII code of the character A is 1lB, and the ASCII code of the character D is: ()

a.1 l l b b. ()

A. Control B. Input

C. Output D. Point menu

17. In the following statement about email, Incorrectly ()

A. The transmission speed of e-mail is faster than that of ordinary letters

B. E-mail is also called e-mail

C. E-mail is a letter sent through the Internet

D. E-mail can be sent without knowing the email address of the other party

18. The biggest advantage of computer network is ().

A. Increase capacity B. Accelerate calculation

C. * * * Enjoy resources D. Save manpower

19. In the editing state of Excel, The function of average (B4: c8) is ()

a. Find the average value of all cells in B4: c8

b. Find the sum of all cells in B4: c8

c. Find the minimum value of all cells in B4: c8

d. Find the maximum value of all cells in B4: c8

2. Which of the following is not commonly used in computer networks? (Choose 2-5 correct answers that meet the meaning of the question from the 5 alternative answers of each question, and fill in the number of the correct answer in the brackets after the stem of the question. If you choose less, choose more or choose wrong, you will not get any points, and each question will get 2 points, ***1 points)

1. In Excel, Which of the following formulas can correctly calculate the sum of all data in cell Al: B2 ()

A. = sum (A1: B2) B. = A1+A2+B1+B2

C. sum (A1: B2) E. = count (A1: B2) D.A1+A2+BL+B2 <

a. The number of disk files increases or decreases without reason

b. The speed of the computer slows down obviously

c. The computer often crashes or restarts for no reason

d. Some inexplicable information or abnormal phenomena often appear on the display

e. Some programs that can be run can't be executed suddenly

1\ The computer sounds abnormally

2\ The computer restarts itself suddenly < The running speed of the computer program is slow

5\ The computer antivirus software can't run normally

6\ The inexplicable window pops up (including dialogs such as DOS)

7\ The screen suddenly turns blue during the use of the computer

8 \ The CPU uses 1% of the resources

9 \ The computer desktop is started, and the loading time is too long

1\ The computer can't start and run normally/

3. What are the following precautions when using the computer? ()

A. Stable voltage and uninterrupted power supply

B. Quiet and humid environment

C. Prevention of electromagnetic interference

D. Don't get close to heat sources (such as electric furnaces, etc.)

E. Normal power on and off

4.

a. table B. page number

C. file D. date and time

5. In PowerPoint, you can set ()

A. width B. font alignment

C. height D. slide size

E. color

III. (Please write the correct answer at the top of the underlined picture, with 1 point for each blank, and 1 points for * * *)

1. A complete computer system includes _ _ _ _ hardware system and _ _ _ _ _ software system. Most of them.

2. according to the geographical range (distance) of network coverage, computer networks can be divided into three categories: _ _ wide area network _ _ _ _ _ _ _ _ _ _ _ _ local area network _ _ _ _ _ and metropolitan area network.

3. in windows 2, to select all files and folder objects in the current folder, the key combination can be __ctrl+A___.

4. The byte in the computer is a common unit, and its English name is _____byte.

5. in. ．Power．Point, there are various views to watch slides, and any three are listed: normal view, slide browsing view, outline view, slide view and slide show view.

6. in excel, to calculate the sum of values in a column, the statistical function that can be used is _ sum _ _ _.