Информатика 1 курс 1 семестр / informatika_uchebnik_Makarova

. ,

( ) .

.

. ,

. – .

, , , ,

. – ,

, , .

.

( ) .

	:
	( )
	:
	:
( )

1..

2.?

3.?

4., .

5.?

6.?

7.?

8.?

9.?

10.

.

11.?

12.?

13.?

14.?

15.?

441

16.?

17.?

18..

19.?

20.?

21.?

22.?

23.?

1.B.C. . 2- . - : OILCO, 1992.

2./ . . . - :

, 1995.

3.. Word 6.0 Windows ( ). - : BHV, 1995.

4.. Running Word 6.0 Windows ( ). - .: Channel Trading Ltd., 1995.

5.A. Microsoft Word Windows 6.0. - : , 1994.

6.. IBM PC . - .: , 1994, 1995.

7./ . . .

. – .: , 1995.

8.., P. Word Windows 2.0 / . . - .: , BHV, 1993.

14.

-

.

– .

.

.

.

5

Excel 5.0 for Windows, .

.

,

– ,

.

-

.

:

,

442

,

,

( )

(Dan Bricklin) 1979 .

, (Bob Frankston),

, , VisiCalc. VisiCalc .

Apple II, .

, Apple

VisiCalc.

( , SuperCalc) VisiCalc

.

– 1982 .

Lotus 1-2-3. Lotus ,

, ,

. Lotus IBM,

, VisiCalc Apple. Lotus 1-2-3 Lotus

50 . .

– . Lotus

, , , VP Planner Paperback Software Quattro Pro Borland International,

, .

– 1987 . Excel Microsoft.

,

.

, ,

.

Excel ,

. Excel

. , Lotus

, , Excel .

.

443

–

, ( )

: , , , .

.

.

– .

– ,

.

, ,

, .

– . 1 ,

. –

Z , AZ , BZ . .

.

, 1 . ,

.

, .

, 2 4).

– ,

.

( )

.

– ( ) .

) ,

. ,

, , ( . 14.1). , ,

, – <:> <..>.

14.1.

, G 3,

G3.

, 1, 1.. 1.

, , 1 .. 10.

, , D4..F5.

( ) ,

.

:

, ,

.

.

, , :

9 ,

.

444

– .

, ( ), (

), (

).

. 14.1,

. : ,

, .

.

.

, ,

.

.

. 14.1.

:

;

;

.

)

, , .

)

),

. ,

,

. ( )

.

.

. ,
.
				.
				.	–

, .

.

.
	,

445

Windows. , DOS,

.

– ,

, .

– ,

,

.

( ) ,

.

. ,

.

.

,

. ( )

, . ,

, ) .

, ,

– –

, , ,

, .

, " " .

, . ,

, ( ).

, ,

, .

, .

. , " "

. , , Framework Frame

).

,

:

, , , .

( ) .

, .

, – .

14.2. :

'142

,

.

( ) , .

14.3. :

446

100 -135

123.32.435

. , , – ,

, .

, , .

14.4. , + 5 + ( 5 + 2 * 5) / 4.

,

, 5, 5 5.

. ,

,

. ( , ) .

, , .

14.5.

,

4, 5, 6, 8, : @AVG ( 4 .. 6, 8).

. .

, ( )

( ). ( ,

1900

) .

. :

–(04- -95);

–( -04-95);

–(04- );

–( -95).

! , ,

,

, :

,

, , (

);

,

.

, ( ),

. .;

, ,

@ ;

,

( ) ,

.

. ,

. .

.

,

447

, .

	,
	(
	). ,		,
	, 12345 12345.00, 0.12345 –
	.12.
	% (
	). , , 0.123
	12.3%, 123 – 12300.0%.
				,
	.
	( ).
	, 12345 12,345 (
	) 12,345.00 ( ).
		,

, :

–, ,

, ) ;

–.

14.6. 12345

1.2345 +04 ( 4 )

1.23 +04 ( 2 ). .0000012

1.2 -06.

.

.

.

.

.

.

.

–

.

,

( ), .

, – .

, , , . , ,

12345

9 .

, $12,345.00 10 ,

.

.

448

!

( ),

, ,

.

.

, .

, ,

.

.

, .

, .

, .

( ) .

:

+, ,

*,

/,

^.

. .

, – –

. ( ,

), .

. .

: (=), (< >),

(>), (<), (<=), (>=).

.

,

:

#NOT# – " ", #AND# – " ",

#OR# – " ".

, .

1, – 0. ,

" " (1) " " (0).

14.7.

:

1	3	5	2
2	3	12	1
3	4	7	6

449

1+ 1*3	18	1
		3,
		1. (
		).
2- 3+ 2	-3	3
		2,
		2. (
		).
2/( 1* 2)	2	1
		2,
		2
		. (
		).
=B1^C1-B2/A3	22	1
		,
		1,
		2
		A3.
		. (
		,
		–
		).
=A1>0#OR#C3>0	1	1 (3>0)
		3 (6>0)

,

1 (" ").

,

. .

	)	)
1, 2,	..., ).	1,	2,..,

.

.

:

;

;

;

;

;

.

, ,

, , . .

, , , ,

, . .

, , .

,

.

,

450