untitled

B Windows

2002 B Windows 6 Windows 98 Word 2000 Excel 2000 Internet B Windows B Windows B Windows CIP /. 2000 ISBN 7-302-03934-8............ TV. TP393 CIP 2000 31044 B Windows 100084 http://www.tup.tsinghua.edu.cn 787 1092 1/16 19.75 448 2003 6 1 2003 6 1 ISBN 7-89494-113-1 0001~5000 29.00

1 1 2 3 ASCII 20 1.1 1.1.1 1. Computer 2.

B Windows 3. 1 - - - 2 100 / ~ / 32 ~64 3 4 5 8 ~64 4. 1 2

1 2 3 4 CAD Computer Aided Design CAM Computer Aided Manufacturing CAD CAT Computer Aided Testing CAI Computer Aided Instruction 5. IBM/PC PC 1 CPU ROM BIOS I/O I/O 2 CPU CPU CPU 3 3 3

B Windows CPU 3 CD-ROM WORM 4 101 4 3 3 5 RGB 6. 4

1 1 2 / 3 MHz 4 KB MB MB GB / 1.1.2 1. 1 1 2 2 123.45 1 100 10 2 1 100 2 10 10 1 1 10 3 1 10 0 3 1 4 0.1 10 1 4 0.1 5 0.01 10 2 5 0.01 10 1 10 10 5

B Windows 10 2 8 16 1 0 0 1 2. 1 Decimal notation 0 1 2 3 4 5 6 7 8 9 10 n m D D=D n 1 10 n 1 +D n 2 10 n 2 +D n 3 10 n 3 + +D 0 10 0 +D 1 10 1 +D 2 10 2 + +D m 10 m 10 9876.54 10 9876.54 10 =9 10 3 +8 10 2 +7 10 1 +6 10 0 +5 10 1 +4 10 2 =9000+800+70+6+0.5+0.04 2 Binary notation 0 1 2 n m B B=B n 1 2 n 1 +B n 2 2 n 2 +B n 3 2 n 3 + +B 0 2 0 +B 1 2 1 + +B m 2 m 2 6

1 1001.01 2 1001.01 2 =1 2 3 +0 2 2 +0 2 1 +1 2 0 +0 2 1 +1 2 2 = 9.25 10 3 Octal notation 0 1 2 3 4 5 6 7 8 n m O O=O n 1 8 n 1 +O n 2 8 n 2 +O n 3 8 n 3 + +O 1 8 1 +O 0 8 0 +O 1 8 1 + +O m 8 m 8 217 8 217 8 =2 8 2 +1 8 1 +7 8 0 =128+8+7= 143 10 4 Hexdecimal notation 0 1 2 3 4 5 6 7 8 9 A B C D E F 16 n m H H=H n 1 16 n 1 +H n 2 16 n 2 +H n 3 16 n 3 + +H 1 16 1 +H 0 16 0 +H 1 16 1 + +H m 16 m 16 2CB 16 2CB 16 =2 16 2 +12 16 1 +11 16 0 = 715 10 1-1 3. 1 1 1101.01 2 1101.01 2 =1 2 3 +1 2 2 +0 2 1 +1 2 0 +0 2 1 +1 2 2 = 13.25 10 7

B Windows 1-1 0 0000 00 0 9 1001 11 9 1 0001 01 1 10 1010 12 A 2 0010 02 2 11 1011 13 B 3 0011 03 3 12 1100 14 C 4 0100 04 4 13 1101 15 D 5 0101 05 5 14 1110 16 E 6 0110 06 6 15 1111 17 F 7 0111 07 7 16 10000 20 10 8 1000 10 8 17 10001 21 11 2 2 2 0 2 2 2 0 123 2 2 123 2 61 2 30 2 15 2 7 2 3 1 1 1 0 1 1 1 1 123 10 = 1111011 2 89 89 10 = 1011001 2 2 89 2 44 2 22 2 11 2 5 2 2 1 1 0 0 1 1 0 1 8

1 0.125 10 2 0.125 2 0.250 0 2 0.500 0 2 1.000 1 0.125 10 = 0.001 2 2 1 8 253 8 253 8 =2 8 2 +5 8 1 +3 8 0 = 171 10 2 8 8 112.25 10 = 160.2 8 3 16 16 16 258.125 10 = 102.2 16 4 1 2 8 8=2 3 9

B Windows 0 0 100100111.011101 2 100 100 111.011 101 4 4 7 3 5 100100111.011101 2 = 447.35 8 2 1357.26 8 1 3 5 7. 2 6 001 011 101 111 010 110 1357.26 8 = 1011101111.01011 2 5 2 16 2 4 =16 1 0 0 1101111001.1001 2 0011 0111 1001. 1001 3 7 9 9 1101111001.1001 2 = 379.9 16 2 3A4B.0C 16 3 A 4 B. 0 C 10 0011 1010 0100 1011 0000 1100

1 3A4B.0C 16 = 11101001001011.000011 2 D 123D 123 B 1110B Q 135Q H 3D4AH 4. 1 0+0=0 110101 2 + 100110 2 0+1=1 110101 1+0=1 + 100110 1+1=10 1011011 2 110101 2 + 100110 2 = 1011011 2 110101 2 100110 2 0 0=0 110101 1 0=1 100110 0 1=1 001111 1 1=0 3 110101 2 100110 2 = 001111 2 110 2 101 2 0 0=0 110 1 0=0 101 0 1=0 110 1 1=1 000 + 110 11110 110 2 101 2 = 11110 2 4 11

B Windows 1101001 2 101 2 0 0=0 10101 0 1=0 101 1101001 1 0 101 1 1=1 110 101 101 101 0 1101001 2 101 2 = 10101 2 1.1.3 1 0 3 3 1. ( ) AND 0 0=0 0 0=0 0 0=0 0 1=0 0 1=0 0 1=0 1 0=0 1 0=0 1 0=0 1 1=1 1 1=1 1 1=1 X=11011001 Y=10011000 X Y= 11011001 AND 10011000 10011000 X Y=10011000 2. ( ) 12

1 + OR 0+0=0 0 0=0 0+1=1 0 1=1 1+0=1 1 0=1 1+1=1 1 1=1 X=11011001 Y=1001100 X+Y= 11011001 OR 10011000 11011001 X+Y=11011001 3. ( ) B B NOT 0=1 0 1 1=0 1 0 X=1001101 X= X =0110010 4. XOR 0 0=0 0 1=1 1 0=1 1 1=0 X=11011001 Y=1001100 X Y= 11011001 XOR 10011000 01000001 X Y=1000001 0 13

B Windows 1.1.4 1. 1 0 8 16 32 64 2. 1 ASCII ASCII ASCII 7 8 7 ASCII 1-2 1-2 ASCII b 7 b 6 b 5 000 001 010 011 100 101 110 111 b 4 b 3 b 2 b 1 0000 NUL DLE SP 0 @ P p 0001 SOH DC1 1 A Q a q 0010 STX DC2 2 B R b r 0011 ETX DC3 # 3 C S c s 0100 EOT DC4 $ 4 D T d t 0101 ENQ NAK % 5 E U e u 0110 ACK SYN & 6 F V f v 0111 BEL ETB 7 G W g w 1000 BS CAN ( 8 H X h x 1001 HT EM ) 9 I Y i y 14

1 b 7 b 6 b 5 000 001 010 011 100 101 110 111 b 4 b 3 b 2 b 1 1010 LF SUB * : J Z j z 1011 VT ESC + ; K [ k { 1100 FF FS, < L \ l : 1101 CR GS - = M ] m } 1110 SO RS. > N n ~ 1111 SI US /? O o DEL ASCII 128 10 52 32 34 NUL SOH STX ETX EOT ENQ ACK BEL BS HT LF VT FF CR SO SI SP DLE DC1 1 DC2 2 DC3 3 DC4 4 NAK SYN ETB CAN EM SUB ESC FS GS RS US DEL 2 GB2312-80 7445 3755 3008 682 1 2 7 1-3 1-3 b 7 b 6 b 5 b 4 b 3 b 2 b 1 B 0 b 7 b 6 b 5 b 4 b 3 b 2 b 1 b 0 0 0 1992 20902 ISOLEC10646 15

B Windows 1.2 1.2.1 1-1 4 A. B. C. D. 3 D D 1-2 CPU A. B. C. D. / 4 CPU A 1-3 CAD A. B. C. D. CAD CAM CAT CAI D 1-4 A. B. 16

1 C. D. / MHz KB MB MB GB / B 1-5 A. B. C. D. C 1-6 A. B. C. D. 1 2 16 8 1 16 4 1 32 C 1-7 1001 A. 1 B. 2 C. 7 D. 9 1001 17

B Windows D 1001=1 2 3 +0 2 2 +0 2 1 +1 2 0 =9 1-8 ASCII A. B. C. D. ASCII B 1-9 A=0 B=1 C=1 A B+ C + A B= A. 1 B. 0 C. A D. B A B+ C + A B 0 1+1 + 0 1=1 1+0 +1 1=1+1 A B C 1+1=1 A 1-10 315 8 A. 315 B. 3F C. 4C D. CD 3 1 5 8 011 001 101 2 315 8 = CD 16 D 1-11 215 10 A. A8 B. D7 C. 215 D. 22 16 16 215 13 7 13 D 215 10 = D7 16 B 1-12 18

1 A. 2 7 B. 2 7 C. 4 7 D. 4 7 7 B 1-13 A. B. C. D. 3 3 D 1-14 A. 0 1 B. C. D. 3 3 1 0 D 1-15 4 A. 1111011 2 B. 174 8 C. 7D 16 D. 126 10 19

B Windows 1111011 2 = 123 10 174 8 = 124 10 7D 16 = 125 10 126 10 = 126 10 A 1-16 A. B. C. D. C 1-17 A. B. C. D. B 1-18 A. B. C. D. CPU 20

1 CPU D 1-19 1001 1110 A. 1111110 B. 1110011 C. 1001101 D. 1001111 0 0=0 0 1=0 1 0=0 1 1=1 1001 1110 1111110 A 1-20 A. B. C. D. C 1-21 1bit A. 2 B. 0 1 C. 4 D. 8 0 1 bit 1bit 0 1 B 1-22 3E A. 74 B. 75 C. 76 D. 77 00111110 00111110 76 21

B Windows C 1-23 100 / ~ / A. B. C. D. 100 / ~ / 32 ~64 A 1-24 A. B. C. D. CPU A 1-25 A. B. C. D. D 1.2.2 1-1 22

1 1-2 1-3 315 2 315 100111011 100111011 1-4 8MB 8MB 8MB 8MB 1-5 1-6 ASCII ASCII 1-7 5 1-8 2 23

B Windows 2 1-9 1-10 214 8 214 8 010001100 2 010001100 2 = 8C 16 8C 16 1.3 1.3.1 1. A. B. C. D. 2. A. B. C. D. 3. A. B. C. D. 4. 100111001 2 A. 470 B. 471 C. 472 D. 473 5. 7D 16 24

1 A. 1111011 B. 1001011 C. 1111101 D. 1111010 6. A. 3008 B. 682 C. 7445 D. 3755 7. A. B. C. D. 8. CPU A. B. C. D. 9. CPU A. B. C. D. 10. A. CAD B. CAT C. CAM D. CAI 11. A. 2 B. 4 C. 8 D. 16 12. A. B. C. D. 13. 35 8 A. 11101 B. 11001 C. 10011 D. 10001 14. 8D 16 A. 140 B. 141 C. 142 D. 143 15. A. 16 B. 15 C. 10 D. 17 16. A. B. C. D. 25

B Windows 17. A. B. C. D. 18. A. B. C. D. 19. 4 A. C9 16 B. 312 8 C. 11001011 2 D. 204 10 20. CPU A. B. C. D. 1.3.2 1. 2. 3. ASCII 7 4. 11001101 2 5. 6. 1.125 7. 8. ASCII 7 9. 10. 26

1 1.3.3 A B C D A B C D A B C D 1 8 15 2 9 16 3 10 17 4 11 18 5 12 19 6 13 20 7 14 1. 2. 3. 128 4. 205 315 CD 5. 6. 1.001 7. 8. ASCII 0 9. 10. 27

2 1 CPU ROM RAM 2 3 2.1 2.1.1 2-1 2-1

2 2.1.2 1. 5 2-2 + 2-2 1 Arithmetic Logic Unit ALU 2 3 CPU CPU Control Unit Logic Unit Memory Unit 3 CPU CPU 4 29

B Windows 2. CPU CPU CPU CPU / 1 RAM Random Access Memory RAM RAM / RAM RAM Dynamic RAM Static RAM 2 ROM Read Only Memory ROM ROM ROM RAM ROM 4 ROM PROM EPROM EEPROM E 2 PROM PROM Programmable Read Only Memory ROM EPROM Erasable Programmable Read Only Memory EEPROM E 2 PROM Electrically Erasable PROM EPROM EPROM 3. CD-ROM WORM 1 2-3 30

2 / 2-3 2-4 2-4 2 2-5 2-5 31

B Windows / MB GB 3 1 2 C D E 3 3 3 CD-ROM WORM 2-6 2-6 CD-ROM WORM 4. 1 101 102 104 2-7 101 4 4 32

2 Shift Caps Lock Shift 2-7 101 2-1 2-1 Shift Caps Lock Backspace Enter Tab Alt Alt+Fn n=1~12 Ctrl Ctrl+Alt+Del Caps Lock Alt+Fn 3 33

B Windows Esc F1~F12 F1~F12 8 2 2-2 2-2 Home End Page Up Page Down Del Ins 0~9 + * /. 5 Num Lock Enter Enter 2 2-8 PC Windows 2-8 34

2 5. 1 2-9 2-9 2 1 9 24 2 35

B Windows 3 6. CPU CMOS BIOS 3 1 AB I/O 20 2 20 B=1024KB=1MB 2 DB CPU I/O CPU 8088 3 CB ISA MAC ELSA VISA PCI 2.1.3 1. 36

2 1 Operating System OS 2 5 1 CPU 2 3 / 4 / / 5 3 37

B Windows 6 1 CP/M MS-DOS 2 3 UNIX XENIX 4 5 Novell NetWare Windows NT 6 38

2 2. 3. 3 1 0 1 0 1 2-3 Inter 8088 2-3 Inter 8088 1 2 10110000 00001001 00000100 00001000 3 11110100 9 AL AL AL 2 2-4 39

B Windows 2-4 1 MOV AL 7 7 AL 2 ADD AL 8 3 HLT A AL 7+8 3 Basic Pascal Fortran C Visual C++ 4 3 1 2-10 2-10 2 2-11 2-11 40

2 3 2-12 2-12 Fortran C Pascal FoxBASE 2.1.4 1. 1 220V 50Hz UPS 2 1 10 ~30 2 3 41

B Windows 3 1 Ctrl+Alt+Del Reset 2 / 3 4 2. 1 42

2 IBM/PC 2 1 2 3 CPU 3 4 1 CPAV SCAN KILL KV300 43

B Windows 2 2.2 2.2.1 2-1 A. B. C. D. A 2-2 A. B. C. D. D 2-3 A. B. C. D. D 2-4 CPU 3 A. B. C. D. 44

2 CPU Control Unit Arithmetic Logic Unit Memory Unit 3 CPU CPU B 2-5 A. B. C. D. A 2-6 CD-ROM A. B. C. D. CD-ROM C 2-7 A. B. Ctrl C. Caps Lock D. Shift Caps Lock Shift C 2-8 A. Alt B. Shift C. Insert D. Table Alt Shift Insert 45

B Windows Table C 2-9 A. B. C. D. I/O CPU I/O B 2-10 MS-DOS A. B. C. D. 6 CP/M MS-DOS B 2-11 MOV AL 7 A. B. C. D. C 11000101 MOV AL 7 7 AL C 46

2 C++ Basic C 2-12 A. B. C. D. D 2-13 A. B. C. D. C 2-14 A. B. C. D. B 2-15 A. B. C. D. A 47

B Windows 2-16 A. B. C. D. A 2-17 A. B. C. D. A 2-18 A. B. C. CPU D. CPU CPU I/O CPU 8088 C 2-19 OS A. B. C. D. OS Operating System D 2-20 A. CPU B. C. D. A B C D D 48

2 2-21 Pascal A. B. C D. B C Pascal D 2-22 A. B. C. D. C 2-23 A. B. C. D. A 2-24 E 2 PROM EPROM A. B. C. D. E 2 PROM EPROM C 2-25 A. DOS B. C. D. B 2.2.2 2-1 49

B Windows 2-2 2-3 2-4 2-5 CPU CPU / CPU CPU CPU / 2-6 / 2-7 3 Ctrl+Alt+Del 3 Ctrl+Alt+Del 2-8 Basic Basic 50

2 2-9 2-10 2-11 6 2-12 2-13 Fortran C Pascal FoxBASE FoxBASE 2-14 10 ~30 10 ~30 2-15 51

B Windows 3 2.3 2.3.1 1. RAM A. B. C. D. 2. A. / B. C. / D. 3. ROM A. B. C. D. 4. A. B. C. D. 5. A. B. C. D. 6. A. B. C. D. 7. A. B. C. D. 8. 3 A. B. C. D. 9. Basic 52

2 A. B. C. D. 10. A. B. C. D. CPU 11. Num Lock A. Num Lock B. C. D. 12. 4 A. B. C. Pascal D. A B 13. A. CD B. CD-ROM C. RAM D. VCD 14. A. B. C. D. 15. A. B. C. D. 16. C A. B. C. D. 17. A. B. C. D. 18. 40 A. 2M B. 4M C. 1024K D. 4096K 19. A. B. C. D. 20. 53

B Windows CPU A. B. C. D. 2.3.2 1. 2. 3. 4. 5. 6. 7. 8. 9. 10. 2.3.3 A B C D A B C D A B C D 1 8 15 2 9 16 3 10 17 4 11 18 5 12 19 6 13 20 7 14 1. 2. 3. 54

2 4. 5. 6. 7. 8. Ctrl+Shift 9. 10. 55

3 1 2 3 Windows 1 Windows 2 Windows 3 4 5 6 DOS 7 4 Windows Windows 98 Microsoft Windows 95 Windows 98 3.1 3.1.1 1.

3 Windows 98 255 mypic.exe.bat.com \ * / Windows 98 * * 2. \ \ 3.1.2 Windows 98 Windows 98 32 1. Windows 98 Windows 98 Web Web Internet Explorer Windows 98 Windows 98 57

B Windows Windows 98 2. Windows 98 Windows 98 80486DX 66MHz Pentium 16MB 24MB 165MB VGA 640 480 16 3.5 CD-ROM Windows 98 Windows 98 3. Windows 98 Windows 98 Windows 98 3-1 Windows 98 3-1 Windows 98 Windows 98 3-2 4. Ctrl+Esc 3-3 1 58

3 MS-DOS 4 3-2 Windows 98 3-3 59

B Windows Windows 98 MS-DOS MS-DOS Windows Win 2 3-4 Windows 98 3 3-5 3-4 Windows 3-5 4 Windows 98 Help Web Internet 5 Windows 98 Internet 3-6 3-6 60

3 3-7 3-7 3-8 3 3-8 2002-7-19 2002-10-17 3-9 3KB 3-8 3-9 3-10 61

B Windows 3-10 6 Windows Update 3-11 3-11 7 15 3-12 8 Internet Favorites 3-13 3-12 3-13 62

3 9 Windows 98 3-14 3-14 10 Office Office Web 8 3-15 3-15 Office 1 Office 63

B Windows Office 2 Windows Update Windows Update 5. 3-16 Windows 98 3-16 Alt+Tab 1 3-17 2 3-18 3-18 3-17 64

3 3 3-19 3-19 5 Internet Internet Explorer Outlook Express 3-19 4 3-20 6. Windows 98 65

B Windows 3-20 Windows 98 3-21 3-21 3-22 3-22 66

3 Alt Alt Esc 7. 3-23 3-23 8. 3-24 3-24 9. 67

B Windows 3-25 3-25 3-26 3-26 4 Web Web Internet 68

3 10. 3-27 3-27 1 Windows 98 1 3-28 3-28 69

B Windows 3-29 3-29 3-30 3-31 3-32 3-33 3-30 3-31 2 Windows 98 70

3 3-32 3-33 2 / / / 1 / / / 3-34 3-34 / CD-ROM Windows 98 / 2 / Windows 98 / Windows 98 71

B Windows / Windows 3-35 3 Windows 98 Windows 98 3-36 3-35 Windows 98 3-36 3 Windows 98 1 3-37 72

3 3-37 2 3-38 3-38 3 Windows Windows 4 1 73

B Windows 3-39 3-39 2 3-40 3-40 74

3 3 3 3-41 3-41 Windows 11. Windows 3-42 1 3 3-43 3 75

B Windows 3-42 3-43 2 1 3-44 3-44 2 3-45 3 3-46 76

3 3-45 3-46 4 3-47 5 3-48 Internet 3-47 3-48 6 3-49 Windows 98 3 3-50 3-49 3-50 77

B Windows 3-51 3-51 F5 4 3-52 3-53 3-52 3-53 78

3 5 5-54 3-54 6 Shift Ctrl 7 8 79

B Windows Delete 3-55 3-55 9 3-56 MS-DOS Windows 3-57 80

3 3-56 3-57 12. 1 3-58 3-59 3-58 3-59 81

B Windows 3 3 2 Windows 98 3-58 3-60 3-60 13. Windows 98 ABC 1 3-61 3-62 82

3 3-61 3-62 2 3 14. DOS Windows 98 MS-DOS Windows 98 MS-DOS DOS DOS 1 MS-DOS MS-DOS MS-DOS 3-63 MS-DOS DOS MS-DOS EXIT MS-DOS Windows 83

B Windows 3-63 MS-DOS MS-DOS D C \WINDOWS>d: D:\> Windows 98 MS-DOS MS-DOS Windows 98 MS-DOS Windows 98 Alt+Enter 2 MS-DOS MS-DOS MS-DOS 5 3-64 3-64 MS-DOS 84

3 MS-DOS DOS DOS DOS MS-DOS MS-DOS 3 MS-DOS MS-DOS MS-DOS MS-DOS MS-DOS Windows MS-DOS Windows F8 Windows 98 Command prompt only 4 MS-DOS DOS DOS 1 DIR DIR[ ][ ][ ][/P][/W] /P /W 5 2 TYPE TYPE[ ][ ]< > 3 COPY 85

B Windows COPY[ ][ ]< >[ ][ ][ ] COPY 4 REN RENAME REN[ ][ ]< >< > 5 DEL ERASE DEL[ ][ ]< >[/P] ERASE[ ][ ]< >[/P] /P 6 FORMAT [ 1][ ]FORMAT< 2>/S/V/B/1/4/8/Q/U FORMAT FORMAT.COM 7 DISKCOPY [ ][ ]DISKCOPY< >< > DOS DISKCOPY.COM 8 DATE DATE[ ] mm dd yy 86

3 mm/dd/yy / / 9 TIME TIME[ ] HH MM SS.ss. 10 VER DOS DOS VER 11 CLS CLS 12 PROMPT DOS DOS PROMPT[ ] A> C> PROMPT DOS $Q = $V DOS $$ $ $N $T $G > $D $L < $P DOS 5 MS-DOS MS-DOS Windows Delete 87

B Windows 15. Delete 3.1.3 3-65 3-65 Windows 98 1. Windows 98 3-66 16 28 88

3 3-66 1 3-67 3-67 89

B Windows Shift 2 3-68 3-69 4 3-68 3-69 3-70 3-71 3-70 3-71 90

3 3 3-72 3-73 3-72 3-73 / 0~239 6 2. 3-74 3-75 3-74 3-75 91

B Windows 3. 3-76 1 3-77 3-76 3-77 3-78 Windows 2 3-79 3-78 3-79 92

3 3-80 3-80 3 3-81 3-82 3-81 3-82 4. Windows 98 93

B Windows 1 3-83 3-83 10% / 2 3-84 3-85 94

3 3-84 3-85 3.2 3.2.1 3-1 A. B. C. D. C 3-2 Windows 98 A. *.COM B. aa.exe C. mybook. exe.bat.com D. mn.bat Windows 98 255 mypic.exe.bat.com \ * / Windows 98 * * 4 A * 95

B Windows A 3-3 A. B. C. D. \ \ D 3-4 Windows 98 A. 16 B. 32 C. 48 D. 64 Windows 98 32 Windows B 3-5 Windows 98 A. B. C. D. Windows 98 Microsoft A 3-6 Windows 98 A. B. Office C. D. Windows 98 C 3-7 A. 96

3 B. C. D. C C 3-8 A. Windows 98 B. C. D. 3 D D 3-9 Windows 98 A. B. C. D. A B C Windows 98 Web Web Internet Explorer Windows 98 Windows 98 Windows 98 A B C 3 D 3 D D 97

B Windows 3-10 DOS Starting Windows 98 A. F1 B. F2 C. F8 D. F6 DOS Starting Windows 98 F8 C 3-11 A. Alt+ B. Alt+Tab C. Alt+F4 D. Alt+Ctrl Alt+F4 C 3-12 A. Shift B. Alt C. Tab D. Ins Shift A 3-13 A. Shift B. Ctrl C. Tab D. Ins Ctrl B 3-14 A. / B. C. D. Windows 98 3 C 98

3 3-15 A. B. C. D. B B 3-16 A. B. C. D. / B 3-17 A. B. F1 C. D. F4 F5 A 3-18 A. B. C. D. A B C C C C 3-19 Windows MS-DOS A. MS-DOS 99

B Windows B. MS-DOS C. Starting Windows F4 D. C Command A B D Windows MS-DOS C Starting Windows F8 MS-DOS C 3-20 Windows 98 A. MS-DOS B. Windows 98 C. D. Windows 98 Windows 98 Windows 98 B 3-21 MS-DOS E A. E: B. E C. d E: D. E MS-DOS E C:\WINDOWS>E: E:\> A 3-22 Windows 98 A. B. C. D. Windows 98 C 100

3 3-23 A. B. C. D. 4 D 3-24 A. B. C. D. A 3-25 Windows 98 A. Ctrl+Shift B. Ctrl+ C. Shift+ D. Alt+Tab Windows 98 Ctrl+ B 3-26 Windows A. B. C. D. Windows 98 D 3-27 A. B. 101

B Windows C. D. B 3-28 Windows 98 A. 10 B. 20 C. 100 D. 255 Windows 98 DOS Windows 3.X 8.3 Windows 98 255 D 3-29 2 x 6.bat A. *x*.bat B. x.bat C.?x?.bat D.?.bat * * C C 3-30 Windows 98 A. B. C. D. Windows 98 Web A 3-31 A. B. C. D. A C D B 102

3 B 3-32 A. F1 B. F2 C. F5 D. F9 F5 C 3-33 A. B. C. D. Windows C 3-34 A. B. Windows 98 C. D. Windows 98 Windows 98 A C D Windows 98 B B 3-35 DOS A. FORMAT B. DISKCOPY C. DIR D. COPY A C D B 103

B Windows B 3-36 DOS A. DIR B. CLS C. VER D. DATE A B C DOS D C 3-37 Windows 98 MM.txt mm.txt A. B. C. D. Windows 98 A 3-38 A. B. C. D. Windows 98 C 3-39 / A. B. C. D. Windows 98 / B 3-40 DOS 104

3 A. DISKCOPY B. DEL C. REN D. COPY B C D DEL REN COPY A A 3.2.2 3-1 3-2 \ 3-3 3-4 Windows 98 Windows 98 3-5 DOS DOS COPY DISKCOPY COPY DISKCOPY COPY 105

B Windows 3-6 Windows 98 Windows 98 Windows 98 3-7 Windows 98 MS-DOS Windows 98 F8 MS-DOS F8 3-8 : 15 3-9 Windows 98 : Windows 98 3-10 MS-DOS PROMPT MS-DOS PROMPT[ ] PROMPT 3-11 3-12 Windows 98 106

3 3-13 Windows 98 3-14 Windows 98 Windows 98 16MB 24MB 16MB 3-15 3.3 3.3.1 1. A. B. C. D. 2. Windows 98 A. B. C. D. 3. A. B. C. 107

B Windows D. 4. Windows 98 A. B. C. D. 5. / A. B. C. D. 6. A. B. C. D. 7. A. B. C. D. 8. A. B. C. D. 9. A. B. C. D. 10. DOS A. DATE B. TIME C. DISKCOPY D. DEL 11. A. COPY B. DISCOPY C. REN D. DEL 12. DOS A. DIR B. TYPE C. REN D. DEL 13. A. 10% B. 20% 108

3 C. 15% D. 5% 14. A. Tab+Alt B. Ctrl+Shift C. Alt+Shift D. Ctrl+Tab 15. A. B. C. D. 16. DOS A. VER B. CLS C. DIR D. FORMAT 17. Word A. B. C. D. 18. A. B. C. D. 19. A. B. C. D. 20. Windows 98 A. m/m.txt B. mm.txt C. mm.txt.exe.bat D. MM.bat 3.3.2 1. 2. Windows 98 32 3. Windows 98 4. 5. MS-DOS Windows 6. Windows 98 7. 8. 109

B Windows 9. 10. MS-DOS 3.3.3 1. 2. 3.3.4 A B C D A B C D A B C D 1 8 15 2 9 16 3 10 17 4 11 18 5 12 19 6 13 20 7 14 1. * 2. 3. 4. 5. EXIT 6. 7. 8. 9. 10. FORMAT 110

4 Word 2000 1 Word Word Word 2 3 4 5 6 Word Word 7 Word Word 2000 Microsoft Word 97 Word 2000 Word 2000 Word 2000 Word 4.1 4.1.1 Word 2000 Word 2000 Office 1. Word 2000 1 Office 2000 Word 2000 1 Microsoft Word

B Windows Word 2000 4-1 4-1 Word 2000 2 Office Office 4-2 Word 2000 4-2 Office Microsoft Word Word 2000 112

4 Word 2000 2 Word Word 2000 Word 2000 2. Word 2000 1 Word 2000 Word 2000 1 4-3 4-3 Word 2000 1 2 9 9 Word 3 4 Word 5 6 113

B Windows 7 3. Word 2000 9 1 4-4 2 4-5 4-4 4-5 3 4-6 Web 4 4-7 5 4-8 6 4-9 114

4 Word 2000 7 4-10 4-6 4-7 4-8 4-9 4-10 8 4-11 4-11 Word 2000 4-12 115

B Windows 4-12 4.1.2 1. Windows 98 V 25 V ü Page Down Page Up 4-13 4-13 2. 4-1 3. ABC ABC 116

4 Word 2000 4-1 A a O o,uo B b ou P p un C c iao Q q iu D d uang,iang R r uan,er E e S s ong,iong F f en T t ue G g eng U sh u H h ang V zh ui I ch I W w ia,ua J j an X s ie K k ao Y y uai, L l ai Z z ei M m ian ; ing N n in 1 ABC ABC women de zuguo shi,huayuan 2 yinwei yw jisuanji jsj 3 zhengzhi zz zhengz zzhi 4 ABC 8 4-2 117

B Windows 4-2 1 2 3 4 5 6 7 8 7 8 15 532 3 3 3 ABC 122 211 424 433 631 72 132 1132 1132 51532 25 26 ABC ABC 4-14 4-14 ABC 5 118

4 Word 2000 g1 1 sc52 lh4 sf26 6 ABC jsjdjks jsjdjks 4.1.3 Word Word 1. 1 4-2 Web 2 4-15 3 119

B Windows 4-15 2. 1 4-16 4-16 2 1 120

4 Word 2000 4 2 3 4-17 4-17 4 Ctrl+Alt+Home 4-18 5 Word 4-19 4-18 4-19 121

B Windows 3 1 4-20 4-20 2 4-21 4-21 3 Shift Ctrl Shift Ctrl+A 122

4 Word 2000 4-22 4-22 Alt 4-23 4-23 4 5 Delete 6 1 4-18 4-24 123

B Windows 4-24 4-25 4-25 2 4-26 124 4-26

4 Word 2000 4-27 4-27 4-28 4-28 7 Windows 98 Word 2000 12 12 1 Ctrl+C 125

B Windows 2 Ctrl+X 3 Ctrl+V F2 Enter 3. 1 Word 2000 Times New Roman 4-29 4-30 4-29 4-30 4-31 4-32 126

4 Word 2000 4-31 4-32 2 4-33 4-34 4-33 4-34 4-35 127

B Windows 4-36 4-35 4-36 100 100 4-33 200% 50% 4-37 4-37 4. 4-38 1 5 1 2 128

4 Word 2000 4-38 3 4-39 4 4-40 4-39 4-40 2 3 1 4-41 4-41 129

B Windows 2 4-42 4-42 3 4-43 4 4-44 4-43 4-44 5 4-45 130

4 Word 2000 4-45 5 4-46 4-46 131

B Windows 4-47 5. 4-47 = = 1 4-48 4-49 A4 2 132

4 Word 2000 4-48 4-49 1 4-50 4-50 4-48 133

B Windows 2 4-51 4-51 3 4-52 4-52 3 Word 2000 4-53 134

4 Word 2000 4-53 4-54 4-54 4 Word 2000 4-55 4-55 135

B Windows 4-56 4-56 5 4-57 4-57 4-58 136

4 Word 2000 4-58 6 Ctrl+A 4-59 4-59 4-59 4-60 137

B Windows 4-60 7 1 4-61 100% 4-61 138

4 Word 2000 2 4-62 4-62 8 4-63 4-63 9 139

B Windows 4-64 4-64 Windows Word 4.1.4 Word Word 2000 Word 2000 1. Word 2000 140

4 Word 2000 4-65 4-65 4-66 4-66 4-67 4-67 141

B Windows 4-68 4-69 Word 2000 4-68 4-69 2. 4-70 4-70 142

4 Word 2000 3. Word 2000 Word 2000 1 4-71 4-71 2 4-72 4-72 4-72 3 4-73 4-73 143

B Windows 4-73 4. 1 Word 2000 3 1 4-74 4-74 4-75 144 4-75

4 Word 2000 2 1 3 1 4-75 8 8 2 3 4-76 4-77 4-76 4-77 4-78 6 Web 1 4-78 2 4-79 145

B Windows 4-78 4-79 3 4-80 4-81 4-80 4-81 4 4-82 5 Web Web 4-83 Web 146

4 Word 2000 4-82 4-83 Web Web 3 Word 2000 4-84 4-85 4-84 4-85 4-86 147

B Windows 4-86 4-85 4 1 4-87 4-87 2 4-88 4-88 Web 148

4 Word 2000 3 4-89 4 4-90 4-89 4-90 5 4-91 4-91 4.1.5 Word Word 2000 1. 149

B Windows 4-92 4-92 4-93 4-94 3 4 4-95 4-93 4-94 3 4 4-95 4-96 150 4-96

4 Word 2000 4-97 4-97 4-98 1 0.5 0.75 4-98 151

B Windows 2. Word 2000 4-99 4-99 4-99 3. 1 4 1 Shift+ 4-100 4-100 2 4-101 4-101 3 4-102 152

4 Word 2000 4-102 4-103 4-103 4 4-104 4-104 2 Word 2000 4-105 4-105 4-106 153

B Windows 4-106 4-107 4-107 3 4-108 4-108 4. 1 4-109 9 154

4 Word 2000 4-109 2 4-110 5 3 Word 2000 4-111 4-110 - 4-111 4 155

B Windows Word 2000 4-112 4-112 5 4-113 4-113 4 5. Word 2000 1 156

4 Word 2000 Word 4-114 SUM 4-114 2 4-115 4-115 4-116 4-116 157

B Windows 4-117 4-117 4.2 4.2.1 4-1 Word 2000 Microsoft A. B. C. D. Word 2000 Microsoft Word 97 D 4-2 Word 2000 A. Microsoft Word B. C. D. Office Windows 98 Word Microsoft Word Microsoft Word 2000 Microsoft Word 2000 Office Microsoft Word 2000 Microsoft Word 2000 158

4 Word 2000 C 4-3 A. B. C. D. Word 2000 9 B 4-4 A. B. ABC C. D. Windows 98 ABC A 4-5 Word 2000 A. 5 B. 10 C. 12 D. 20 : Windows 98 Word 2000 12 12 C 4-6 A. Ctrl+C B. Ctrl+A C. Ctrl+Z D. Ctrl+V B C D A A 4-7 159

B Windows A. B. C. D. Word 2000 C 4-8 A. B. C. D. C 4-9 Word A. B. C. D. Word Word Word Word Word Word B 4-10 A. B. C. D. Word 2000 A A 4-11 160

4 Word 2000 A. Back Space B. Delete C. Insert D. Tab A B A B A 4-12 A. B. C. D. A B C D C 4-13 A. B. C. D. = = A 4-14 A. B. C. D. B 4-15 A. B. C. D. Word 2000 Word 2000 B 161

B Windows 4-16 A. B. C. D. A A 4-17 A. B. C. D. Word 2000 Word D 4-18 A. B. C. D. A 4-19 A. B. C. D. A C D B 4-20 A. B. C. ABC D. 162

4 Word 2000 Windows 98 V 25 V ü ABC C 4-21 A. Ctrl+C B. Ctrl+V C. Ctrl+Z D. Ctrl+X A B C D D 4-22 Word A. B. C. D. D 4-23 Word A. B. C. D. Word 2000 Microsoft A 4-24 A. Shift B. Ctrl C. Alt D. Word Ctrl B 163

B Windows 4-25 FIND Find A. B. C. D. A 4-26 A. B. C. D. D 4-27 Word A. Ctrl B. Tab C. Shift D. Ins Shift+ C 4-28 A. 4 B. 6 C. 8 D. 12 8 8 C 4-29 Word A. B. C. D. 164

4 Word 2000 A C D B B 4-30 A. B. ABC C. D. B C A B C D ABC jsj 3 B C D D 4-31 Word 2000 A. B. C. D. A B C Web D D D 4-32 Word A. B. C. D. C 4-33 Word Word 165

B Windows A. Untitled-1 B. C. 1 D. Noname Word 2000 1 C 4-34 Word A. B. C. D. Word 2000 3 B B 4-35 Word A. B. C. D. Word 2000 A 4-36 Word A. B. C. D. B C D A A 4-37 A. B. C. 3 D. Ctrl A B 166

4 Word 2000 D C C 4-38 A. B. C. D. A A 4-39 4 A. B. C. D. A B C D D 4-40 A. B. C. D. C 4.2.2 4-1 Word 2000 4 Word 2000 4 Web Web 167

B Windows 4-2 Word Word Word 4-3 4-4 4-5 : 4-6 Word Word 2000 4-7 4-8 168

4 Word 2000 4-9 4-10 Word 2000 Microsoft Word 2000 Microsoft 4-11 Word 2000 9 4-12 ABC 4-13 Word Shift Shift 4-14 4 4 4-15 9 169

B Windows 9 4-16 Word 2000 4-17 Word Word 4-18 Word Word Alt+F4 Alt+F4 4-19 Word Word 2000 4 Web Word 4-20 1 2 Word 2000 1 2 4.3 4.3.1 1. Word 2000 A. B. 170

4 Word 2000 C. D. 2. Word 2000 A. Word 2000 Microsoft B. C. Word 2000 Microsoft Office 2000 D. Word 2000 3. A. Ctrl+C B. Ctrl+V C. Ctrl+D D. Ctrl+F 4. A. B. C. D. 5. A. B. Delete C. Back Space D. Insert 6. A. B. C. D. 7. A. B. C. D. 8. A. A4 B. B5 C. A3 D. B5 Extra 9. A. B. C. D. 10. A. B. C. D. 11. A. B. C. 171

B Windows D. 12. A. B. Delete C. D. 13. A. B. C. D. 14. A. Shift B. Ctrl C. Alt D. Tab 15. A. B. C. D. 16. Word 2000 A. 3 B. 4 C. 6 D. 8 17. A. B. C. Word 2000 8 D. 18. A. B. C. Ctrl D. Ctrl 19. A. B. C. D. 20. A. B. C. D. 172

4 Word 2000 4.3.2 1. 2. hh 3. 4. 5. 6. 7. Word 8. Word 9. 10. 4.3.3 1. Word 2. 3. 3D 4. 4.3.4 A B C D A B C D A B C D 1 8 15 2 9 16 3 10 17 4 11 18 5 12 19 6 13 20 7 14 173

B Windows 1. 2. 3. 4. 5. 6. 7. 8. 9. 10. 174

5 Excel 2000 1. Excel 2. 3. 4. 5. Excel Excel 2000 Excel 97 Excel 2000 Excel 5.1 5.1.1 Excel 2000 Excel 2000 Office 2000 Excel 2000 Excel 2000 1. Excel 1 Windows 98 Microsoft Excel Excel 2000 5-1 5-2 2 Excel 2000

B Windows Excel 2000 5-3 5-1 5-2 Excel 2000 5-4 176

5 Excel 2000 5-3 5-4 2. Excel 2000 1 Microsoft Excel 5-5 5-5 Word 2000 2 5-6 5-6 Excel 3 5-7 5-7 4 5-8 5-8 177

B Windows 3 = 5 5-9 5-9 3 3. 1 A4 B3 5-10 178 5-10

5 Excel 2000 5-10 2 3 Excel 4 1 Sheet1 2 Sheet2 16 5 5-11 5-11 6 Excel 2000 5.1.2 1. Excel 2000 Book 1 Sheet1 Sheet2 Sheet3 3 5-12 179

B Windows 5-12 Excel 2000 Book1 Book2 2. 5-13 5-13 3. 1 Excel 2000 180

5 Excel 2000 Excel 5-14 5-14 Ctrl+PageUp Ctrl+PageDown 4 2 3 Excel Ctrl 5-15 5-15 5-16 181

B Windows 5-16 4 5-17 5-17 5-18 5-18 182

5 Excel 2000 5 5-19 6 5-20 5-19 5-20 5-21 5-21 7 5-22 183

B Windows 5-22 5.1.3 Excel 65536 256 1. 5-23 5-23 2. 1 5-24 5-24 2 5-25 184

5 Excel 2000 5-24 3 5-25 5-25 4 5-26 5 Ctrl 5-27 5-26 5-27 185

B Windows 3. 1 5-28 5-28 2 4. 1 5-29 5-29 2 186

5 Excel 2000 5. 1 5-30 5-31 5-30 5-31 5-32 5-33 5-32 5-33 2 3 Delete 187

B Windows 6. 1 5-34 5-34 2 5-34 5-35 5-35 7. 1 188

5 Excel 2000 5-36 5-36 2 5-37 5-37 3 5-38 5-38 4 5-39 189

B Windows 5-39 5.1.4 Excel 1 Excel Alt+Enter Enter 3251200 32000 Esc 2 190

5 Excel 2000 1/3 0 1/3 Excel Excel 3 Excel 2000 2002 10 30 2002 10 30 2002/10/30 2002-10-30 30-Oct-2002 10-30-2002 Oct 30 2002 Excel 12 24 12 AM PM A P 24 Ctrl+ Ctrl+Shift+ 4 Excel 5-40 5-40 5-41 5-41 191

B Windows Ctrl+Enter 5-42 5-42 5-43 5-43 5-43 5 Excel 2000 5-44 5-44 192

5 Excel 2000 5.1.5 Excel Excel Excel Excel 1. 1 = 53*98 = 53 * 98 A1 A2 A3 5 15 25 5-45 A4 5-45 A1 15 A4 5-46 2 193

B Windows 5-46 5-47 5-47 3 Excel 4 + * / % ^ & = & = > < < > <= >= True False 194

5 Excel 2000 2. Excel 2000 1 2 3 1 SUM SUM number1 number2 5-48 A1 A2 A3 A4 A4 SUM 5-49 5-48 5-49 5-50 Number1 A1 A3 A4 5-51 5-50 A4 5-52 195

B Windows 5-51 5-52 SUM SUM 5-53 5-53 2 AVERAGE AVERAGE number1 number2 196

5 Excel 2000 5-48 A1 A2 A3 A4 A4 AVERAGE 5-54 5-54 AVERAGE A4 5-55 5-55 5.1.6 1. 1 Excel 2000 5-56 5-56 197

B Windows 2 5-57 5-57 2. 1 5-56 2 5-58 198 5-58

5 Excel 2000 3. 5-59 5-59 4. Excel 5-60 5-61 5-62 199

B Windows 5-60 5-61 5-62 5-63 200 5-63

5 Excel 2000 5. 1 5-64 5-64 2 6. 1 Excel 2000 5-65 5-65 201

B Windows 2 Excel 16 45 5-66 5-67 5-66 5-67 45 16 5-68 202 5-68

5 Excel 2000 3 5-69 Book1 Book2 5-69 Book1 Book2 5-70 Book1 Book2 5-71 5-70 5-71 5.1.7 1. 5-72 203

B Windows 5-72 5-72 5-73 2. 1 5-72 5-74 5-73 5-74 2 Excel 2000 5-72 1 5-75 5-76 204

5 Excel 2000 5-75 5-76 10 5-77 3 3 5-77 10 2 5-78 5-79 5-78 5-79 205

B Windows 5-80 5-81 5-80 5-81 3. Excel 2000 3 Access 1 5-82 5-82 5-83 2 206

5 Excel 2000 5-83 5-84 5-84 5-85 5-85 5-86 5-86 207

B Windows 5-87 5-87 5-87 5-87 5-88 5-88 5.1.8 Excel 1. Excel 1 5-89 208

5 Excel 2000 2 5-90 5-89 5-90 3 5-91 4 5-92 5-91 5-92 5 X Y X Y 5-93 X Y 6 5-94 5-93 X Y 5-94 7 209

B Windows 5-95 8 5-96 5-95 5-96 9 5-97 10 3 5-98 5-97 5-98 X Y 11 5-99 12 5-100 210 5-99 5-100

5 Excel 2000 2. 1 F11 5-101 5-101 2 5-102 5-102 5-103 211

B Windows 5-104 5-103 -1 5-104 -2 5-105 5-105 -3 5-106 5-106 -4 212

5 Excel 2000 5-107 5-107 3 Excel 5-108 5-108 5-109 213

B Windows 5-109 4 5-103 5-110 5-110 5 X Z Y Z 214

5 Excel 2000 8 8 5-111 5-111 6 5-112 5-112 215

B Windows 5.1.9 Excel 1. 5-113 5-113 / / 2. Excel Excel 5-114 3. 5-115 4. 216

5 Excel 2000 5-116 5-114 5-115 5-116 217

B Windows 5.2 5.2.1 5-1 Excel A. B. C. D. Excel 2000 Office A 5-2 Excel A. 1 B. 2 C. 3 D. 4 Excel 2000 Book 1 Sheet1 Sheet2 Sheet3 3 C 5-3 A. B. C. 3 D. A A 5-4 A. Ctrl+PageDown B. Ctrl+Home C. Alt+PageDown D. Alt+Home Ctrl+PageUp Ctrl+PageDown A 218

5 Excel 2000 5-5 A. B. C. D. B 5-6 A. Ctrl B. Shift C. Alt D. Ctrl A 5-7 3/5 A. 3/5 B. 0 3/5 C. 3/5 D. 0 3/5 Excel 0 Excel D 5-8 A. B. C. D. Excel B 5-9 Excel A. 2002 10 30 B. 2002.10.30 C. 2002-10-30 D. 30-Oct-2002 Excel 2000 2002 10 30 2002 10 30 2002/10/30 2002-10-30 219

B Windows 30-Oct-2002 10-30-2002 Oct 30 2002 B Excel B 5-10 Excel A. Ctrl+Enter B. Ctrl+Alt C. Alt+Enter D. Alt+PageDown Excel Ctrl+Enter A 5-11 5*9 A. 5*9 B. 5*9 C. 5*9 D. 5*9 Excel = 53*98 = 53 * 98 A 5-12 A. B. C. D. / A 5-13 A. 220

5 Excel 2000 B. C. D. C C 5-14 A. B. C. D. A B C D D 5-15 Excel A. B. C. D. Excel 4 B 5-16 A. B. C. D. C 5-17 A. 221

B Windows B. C. D. D D 5-18 A. Ctrl+ B. Ctrl+Shift+ C. Ctrl+ D. Ctrl+Alt+ Excel 2000 Ctrl+ Ctrl+Shift+ C 5-19 Excel A. 65536 B. 256 C. 128 D. 37721 Excel 65536 256 B 5-20 100096 A. 100096 B. 100096 C. 100096 D. 100096 C 5-21 Z200 A. B. Ctrl+Z200 C. Z200 D. Ctrl+ Z Ctrl+ 200 222

5 Excel 2000 C 5-22 0.5 A. 5/10 B. =5/10 C. 5/10 D. = 5/10 / Excel Excel = B Excel A C D 5/10 B 5-23 A. B. C. D. Excel A 5-24 A. B. C. F5 D. B 5-25 A. B. C. D. B C D A 223

B Windows A 5-26 A. B. C. D. B 5-27 >60 >200 A. 60 B. 60 200 C. 200 D. 60 200 >60 >200 60 200 B B 5-28 A. B. C. D. Excel A 5-29 A. B. Delete C. D. A B C A B B 224

5 Excel 2000 5-30 Excel A. B. 9 C. Excel D. A B D Excel Excel C 5-31 A. 3 B. 6 C. 12 D. 16 Excel 3 A 5-32 Excel A. Excel 2000 B. C. D. A B C Excel 2000 D 5-33 A. B. C. Shift D. Alt A B C A B A B 225

B Windows C D Alt D 5-34 A. B. Excel C. D. B C D Excel A 5-35 A. B. C. D. A B C D B 5-36 Book2 Book1 A. Book2 Book1 B. Book1 Book2 C. Book1 Book2 D. Book2 Book2 Book1 Book2 A 5-37 A. B. 10 C. D. Excel 2000 226

5 Excel 2000 A 5-38 Excel A. B. C. D. D A B C Excel D 5-39 255 6985 A. 255 B. SUM C. 255 6985 D. Enter B C D A 5-40 A. X Y B. C. X Y D. X Y A 5.2.2 5-1 Excel 2000 Office 2000 Excel 2000 Office 2000 227

B Windows 5-2 Excel Excel 5-3 Excel Excel 65536 256 65536 256 5-4 5-5 5-6 5-7 Excel 3251200 32000 5-8 Excel 4 Excel 4 & = 228

5 Excel 2000 > < <> <= >= True False 5-9 Excel Excel 2000 AVERAGE AVERAGE 5-10 5-11 5-12 Excel 5-13 5-14 229

B Windows 5-15 Ctrl+Enter Ctrl+Enter 5.3 5.3.1 1. A. 6 B. C. D. 2. Microsoft Excel A. B. C. D. 3. A. B. C. D. 4. 1/5 A. 1/5 B. 0 1/5 C. 0 1/5 D. 0 1/5 5. Excel A. Excel B. Excel C. 230

5 Excel 2000 D. 6. A. B. C. D. 7. A. B. C. D. 8. Excel A. B. C. Access D. 9. A4 A5 A6 B4 B5 B6 A. A4 B6 B. A4 B4 C. B6 A4 D. A6 B4 10. A. B. C. D. 11. A. B. X Y C. D. 12. Excel A. B. C. D. 13. Excel A. B. Excel C. Excel D. 14. Excel A. B. C. D. 15. 231

B Windows A. B. C. D. 16. A. B. C. D. 17. A. B. C. D. 18. A. B. C. D. 19. 0.5 A. 5/10 B. =5/10 C. 5/10 D. = 5/10 20. Excel A. 65536 B. 256 C. 26 D. 128 5.3.2 1. 2. 3. 4. 5. 6. 7. 8. 9. 232

5 Excel 2000 10. Excel 5.3.3 1. 2003 2. 5.3.4 A B C D A B C D A B C D 1 8 15 2 9 16 3 10 17 4 11 18 5 12 19 6 13 20 7 14 1. 2. 3. 233

B Windows 4. 5. 6. 7. 8. 9. F11 10. 234

6 Internet 1 2 Modem 3 4 Internet E-mail IE IT Information Technology Internet Internet 6.1 6.1.1 1. 2. 1

B Windows 2 3 4 5 3. 1 / 2 / 236

6 Internet 1 Modem 2 3 4 4. 1 LAN Local Area Network 10 10Mb/s~100Mb/s 3 3 LAN Local Area Network HSLN High Speed Local Network CBE Computer Branch Exchange 2 MAN Metropolitan Area Network 237

B Windows 50Mb/s IEEE802.6 3 5. 1 1 2 2 238

6 Internet 1 / 2 6-1 a 6-1 b 6-1 c a b c 6-1 3 239

B Windows SYN SYN SYN 3 1 2 4 CRC 6. ISO/OSI X.25 IEEE 802 TCP/IP IPX/SPX 1 OSI OSI ISO ISO/OSI Open System Interconnection Reference Model OSI 7 240

6 Internet 6-2 6-2 OSI 1 Physical Layer 2 Data Link Layer 3 Network Layer 4 Transport Layer 5 Session Layer 6 Presentation Layer 241

B Windows 7 Appreciation Layer OSI FTAM VT TP RDA MMS DS OSI 2 X.25 X.25 CCITT DTE Data Terminal Equipment DCE Data Circuit Terminating Equipment 3 IEEE 802 IEEE 802 IEEE 1980 2 IEEE 802 1985 IEEE 802.1 IEEE 802.2 IEEE 802.3 CSMA/CD IEEE 802.4 IEEE 802.5 IEEE 802.6 IEEE 802.7 IEEE 802.8 IEEE 802.9 IEEE 802.10 IEEE 802.11 IEEE 802 6-3 4 TCP/IP TCP/IP Internet TCP/IP TCP Transmission Control Protocol IP Internet Protocol TCP OSI IP IP 242

6 Internet TCP IP TCP IP 802.10 802.1 a 802.3 802.4 802.1 802.2 802.5 802.6 802.9 802.11 6-3 IEEE802 TCP/IP 4 6-4 Telnet FTP TFTP SMTP DNS Others TCP UDP IP Ethernet Token Ting Others 6-4 TCP/IP 1 OSI TCP/IP TCP/IP 2 3 4 TCP/IP TCP/IP TCP/IP 243

B Windows IP TCP/IP 5 IP IP IP IP IP IP 1 IP IP 6-5 0 3 7 15 31 IP IP 6-5 IP IP 4 4 IP 6 6-6 0 2 3 4 5 7 D T R 6-6 3 D T R3 D T R IP IP 2 IP IP 32 4 IP A B C D E 5 6-7 244

6 Internet 0 7 15 23 31 A 0 B 10 C 110 D 1110 E 11110 6-7 IP 0 A 10 B 110 C 1110 D 11110 E A B C D E A B C IP 4 10000000 00011101 00000011 00001110 128.29.3.14 B 58 782 IP 32 IP 1 IP 1 A B C 255.0.0.0 255.255.0.0 255.255.255.0 3 IPX/SPX IPX Xerox XNS IPX IPX SPX IPX 7. 1 245

B Windows 2 6-8 6-8 1 2 3 3 6-9 1 246

6 Internet Web Internet PC PC PC PSTN PC 6-9 PC PCI ISA 247

B Windows 2 UNIX Novell OS/2 Windows NT 6.1.2 Internet Internet 20 60 ARPANet Internet Internet Internet WWW Internet 1. Internet 1 Internet Internet 248

6 Internet 2 Internet Internet 3 Internet Internet Internet 4 Internet 5 Internet 6 Internet 7 Internet Internet 2. Internet 1 Internet Internet 486 16MB Modem 2 Internet ISP Internet Internet Internet 249

B Windows Internet ISP ISP ISP ISP 3 6-10 6-10 6-11 6-11 250

6 Internet 6-12 6-12 6-13 6-13 6-14 6-14 251

B Windows 4 6-15 6-15 6-16 6-16 252

6 Internet 6-17 6-17 6-18 6-18 5 TCP/IP 1 TCP/IP TCP/IP 6-19 253

B Windows 6-19 6-20 6-20 6-21 6-21 Microsoft Microsoft TCP/IP 254

6 Internet 2 Windows / 6-22 Windows 6-23 6-22 Windows 6-23 255

B Windows 3 Internet 6-24 6-24 6-25 6-25 6-26 256

6 Internet 6-26 / 6-27 6-27 4 Modem 163 6-28 Modem 6-29 Windows Netscape Internet 6-30 257

B Windows 6-28 6-29 6-30 IE 6.1.3 Internet Internet Internet 1. WWW Internet HTTP Internet Internet 258

6 Internet WWW WWW WWW Web Windows 98 Web Internet Explorer 4.0 Internet Explorer 2. Internet Explorer Web Internet Explorer http //home.microsoft.com/intl/cn/ Internet Explorer Web Internet Explorer Internet Web 3. Web Web HTML Web Ctrl+A Ctrl+C 4. Web Internet Explorer 6-31 5. Outlook Express Internet 1 Outlook Express Outlook Express Windows 98 Outlook Express Outlook Express 6-32 259

B Windows 6-31 6-32 Outlook Express 2 Outlook Express Outlook Express Outlook Express 6-33 Internet 260 6-33 Internet

6 Internet Internet Internet ISP ISP Internet Mail ISP POP Outlook Express 6.2 6.2.1 6-1 A. B. C. D. B B 6-2 A. B. C. D. 261

B Windows C 6-3 A. B. C. D. D D 6-4 A. B. C. D. C 6-5 A. B. C. D. B 6-6 A. X.25 B. IEEE802.4 C. IEEE802.3 D. IEEE802.6 MAN Metropolitan Area Network 50Mb/s IEEE 802.6 262

6 Internet D 6-7 A. B. C. D. B 6-8 A. B. C. D. A 6-9 A. CRC B. BCD C. D. CRC 263

B Windows C 6-10 OSI A. B. C. D. OSI ISO ISO/OSI Open System Interconnection Reference Model OSI 7 C 6-11 IEEE802 A. IEEE802.1 B. IEEE802.2 C. IEEE802.3 D. IEEE802.6 IEEE802 IEEE 1980 2 IEEE802 1985 IEEE802.2 B 6-12 TCP/IP A. B. C. D. TCP/IP TCP/IP B 6-13 A. B. C. D. 264

6 Internet A 6-14 A. B. C. D. A B C D D 6-15 IP B A. 0.10.255.0 B. 126.255.30.25 C. 192.29.3.14 D. 224.225.0.0 IP 32 4 IP A B C D E5 0 A 10 B 110 C 1110 D 11110 E IP 4 A B C D IP IP B B 6-16 ISP A. B. C. D. CCITT SPX IPX ISP Internet A 6-17 A. B. C. D. 265

B Windows B 6-18 A. Modem B. C. D. Internet A B C Modem D 6-19 A. WWW Internet B. HTTP C. WWW WWW D. WWW A B C WWW Internet HTTP Internet Internet WWW WWW WWW Web D 6-20 IT A. Internet Technology B. Information Technology C. Internet TCP/IP D. Information Technique IT Information Technology IT Information Technology B 6-21 A. B. / C. 266

6 Internet D. / B 6-22 10 A. B. C. D. LAN Local Area Network 10 MAN Metropolitan Area Network A 6-23 A. B. C. D. C 6-24 OSI A. B. C. D. OSI 7 267

B Windows A 6-25 IP IP A. B. C. D. IP IP IP IP IP IP 4 4 IP 6 C 6.2.2 6-1 6-2 6-3 OSI OSI ISO ISO/OSI Open System Interconnection Reference Model 7 268

6 Internet 6-4 TCP/IP TCP/IP Internet 6-5 OSI TCP/IP 4 OSI TCP/IP TCP/IP 6-6 IP IP 32 4 IP 4 32 4 6-7 Xerox XNS IPX Xerox XNS IPX IPX IPX 6-8 6-9 269

B Windows 6-10 6-11 6-12 6-13 6-14 OSI 7 6-15 270

6 Internet 6.3 6.3.1 1. A. B. C. D. 2. A. B. C. D. 3. A. B. C. D. 4. A. B. C. D. 5. A. B. C. D. 6. A. B. C. D. 7. A. B. C. D. 8. OSI 271

B Windows A. B. C. D. 9. CCITT A. IEEE802 B. X.25 C. X2.5 D. TCP/IP 10. A. B. C. D. 11. A. B. C. D. 12. A. B. C. D. 13. A. B. Intranet C. Internet D. 14. PC Internet ISP A. ISP B. ISP C. ISP D. ISP 15. Web A. Web B. Web Web C. Web D. Web 16. Outlook Express A. B. Web C. D. 17. IEEE IEEE 802 A. IEEE 802.3 B. IEEE 802.7 C. IEEE 802.9 D. IEEE 802.10 18. TCP/IP TCP IP TCP OSI IP A. B. 272

6 Internet C. D. 19. A. B. C. D. 20. A. B. C. D. 6.3.2 1. 2. 3. 4. TCP/IP TCP IP 5. 6. Internet Internet 7. Internet Internet 8. 9. IP 32 IP 10. 6.3.3 1. 2. Web 3. Outlook Express 273

B Windows 6.3.4 A B C D A B C D A B C D 1 8 15 2 9 16 3 10 17 4 11 18 5 12 19 6 13 20 7 14 1. 2. 3. 4. IP 5. 6. 7. 8. 9. 10. 274

A B Windows (30 ) 1. A. B. C. D. 2. A. B. C. D. 3. A. B. C. D. 4. RAM / A. B. C. D. 5. A. B. C. D. 6. Windows Caps Lock A. B. C. D. 7.

B Windows A. B. C. D. 8. A. B. C. D. 9. 11001101 A. 316 B. 315 C. 317 D. 314 10. A. B. C. D. 11. MOV AL 7 A. B. C C. Pascal D. 12. A. B. C. D. 13. A. B. C. D. 14. IP B A. 188.25.0.3 B. 70.255.112.3 C. 0.112.211.2 D. 127.127.1.1 15. A. B. C. 200V 50Hz D. 10 ~30 16. Windows 98 A. 10 B. 200 C. 255 D. 256 17. Windows 98 A. 276

A B Windows B. C. D. 18. Windows A. B. C. D. 19. A. % B. * C. / D. * % 20. A. B. C. D. 21. Word 2000 A. B. C. D. 22. Word A. B. C. D. 23. Word A. B. C. D. 24. Word 2000 A. B. C. D. 25. Word A. B. C. D. 26. Excel A. Book1 B. 1 C. 1 D. 1 277

B Windows 27. Excel A. B. C. D. 28. Excel A. 2002/11/5 B. 2002 11 5 C. 2002-11-5 D. 02 11 5 29. Excel A. Ctrl+PageDown B. Ctrl+PageUp C. Alt+PageDown D. Alt+PageUp 30. Excel = & A. & B. & C. D. (20 ) Windows (20 ) 1. newfile 2. newfile file 3. file 4. file student 5. newfile Word (20 ) 1. 2 278

A B Windows 20 70 2. 2cm 2cm 2 3. 2 10 5 4. 5 4 3cm Excel (10 ) 1. Sheet2 25 20 30 25 18 10 15 5 2 3 Sheet2 A B C D A B C D A B C D 1 11 21 2 12 22 3 13 23 4 14 24 5 15 25 6 16 26 7 17 27 8 18 28 9 19 29 10 20 30 279

B Windows (30 ) 1. A. B. C. D. 2. A. B. C. D. 3. A. B. C. D. 4. A. B. C. D. 5. A. B. CD-ROM C. D. 6. Windows 98 A. B. C. D. 7. A. B. C. D. 8. A. B. C. D. 9. 252 280

A B Windows A. 111100110 B. 11111100 C. 10001001 D. 11001111 10. CD-ROM A. B. C. D. 11. A..txt B..doc C..com D..exe 12. 156 8 A. 6A B. 6B C. 6D D. 6E 13. A. B. C. D. 14. Internet A. X.25 B. IEEE 802.3 C. TCP/IP D. IPX 15. A. B. C. D. 16. Windows 98 A. B. C. ABC D. 17. Windows 98 A. B. C. D. 18. Windows 98 A. Ctrl+Shift B. Ctrl+Alt C. Ctrl+ D. Shift+ 19. Windows A. B. C. D. 281

B Windows 282 20. Windows A. B. C. D. 21. Word 2000 A. B. C. D. 22. Word 2000 A. B. C. D. 23. Word 2000 A. 3 B. 5 C. 10 D. 12 24. Word A. B. C. D. 25. Excel 2000 A. B. C. 15 D. 26. Excel 2000 A. SUM B. AVERAGE C. MAX D. MIN 27. Excel 3/7 A. 3/7 B. 0 3/7 C. 0 3/7 D. 3/7 28. Excel A. B. C. D. 29. Excel A. X Y B. C. D. 30. 25*98 A. B.

A B Windows C. 53 * 98 D. (20 ) 60% 4158m 4807m Windows (20 ) 1. 1 2 2. 1 2 3. 1 4. 2 5. 2 Word (20 ) 1. 1 2. 2 3. 3 4. 1 3 4cm 5. 283

B Windows 2002001 89 3 2002002 90 2 2002003 84 5 2002004 93 1 2002005 88 4 Excel (10 ) 1. Sheet1 1 594038 92% 2 438493 97% 3 586749 96% 4 2. 3. Sheet1 A B C D A B C D A B C D 1 11 21 2 12 22 3 13 23 4 14 24 5 15 25 6 16 26 7 17 27 8 18 28 9 19 29 10 20 30 284

B B Windows 2002 1 2 / 3 4 1 2 PentiumII 233 32MB 100MB SVGA 800 600 16 Windows 98 Microsoft Word 97 Microsoft Excel 97 Windows 98/Me/2000/XP

B Windows Microsoft Word 97 Microsoft Excel 97 Microsoft Word 97 Microsoft Excel 97 0 1 / 2 B Windows 3 / 1 1 1 2 286 2

B 3 3 1 4 4 4 5 287

B Windows 5 130199990001 6 6 7 7 288

B 7 8 8 9 9 1 10 11 12 13 289

B Windows 10 11 12 290

B 13 14 14 2 3 291

B Windows 15 15 16 16 4 Word Word Word 292

B 17 17 5 Excel Excel Excel 18 18 293

B Windows C WEXAM C:\WEXAM\13010001 19 19 20 20 294

B 21 21 22 22 295

B Windows 296

C 1 National Computer Rank Examination NCRE 2 NCRE 1994 NCRE 3 NCRE NCRE 4 NCRE NCRE Internet

B Windows QBasic C Fortran FoxBASE+ Visual Basic Visual FoxPro PC PC PC Windows PC B B B B 5 NCRE Visual Basic Visual FoxPro 90 QBasic C Fortran FoxBASE+ 120 180 QBasic C Fortran FoxBASE+ 60 Visual Basic Visual FoxPro 90 B 90 6 NCRE NCRE Fortran Fortran 4 9 B 7 8 298

C 9 ( ) ( ) 10 11 100~90 89~80 79~60 59~0 12 Word Excel PowerPoint Office Internet PC Pentium PC PC Windows 98 PC 299

B Windows Internet 13 NCRE 1994 NCRE 2001 600 214 200 / 150 100 50 0 1994 1995 1996 1997 1998 1999 2000 2001 NCRE 1994 2001 14 NCRE www.neea.edu.cn www.ncre.edu.cn 300