excel_1начало

'$ & ,

+ " % !"

(( ), , , , , , *

:

! " "

#

" ($ $

$

#$ % "

MS Excel

% &

1, 2, 2009 .

1

, -"# % !;

– VisiCalc (' 1 1 % , 2 1979);

– SuperCalc (1980 Sorcim (Micros %) $ CP/M , 1984 Computer

( & -"# % !;

Associates Int.);

, # !$ .

– Multiplan (1980, Microsoft);

– Lotus 1-2-3 (1982 Lotus Development Corporation);

-# , ;

– Quattro Pro (Borland International);

, % "# , %/ "#

1987 – Excel 2 (Microsoft):

;

1990 – Excel 3: ( , , ( &,

;

% -" % ! % ,

1992 – Excel 4: 3 "0 0, 4 &

;

"#: ( , "% "# (

1994 – Excel 5: " , $," ( $ VBA Visual Basic for

, (, , "# "# % !;

Application;

1995 – Excel 7: 32-,$" ";

( &, ( ( % ! ! ,

1997 – Excel 97: " , 3, $ ( , . 0 . .

. # % , "#;

% Internet;

2002 – Excel 2002: . " ($

. ( , ! "# ,;

" $ % " -" % !

. -# "# ,;

( !

2003 – Excel 2003: - $ $ % , ! ,

, % , ( VBA, 0

(, , 5 ! & 0 ( 0 !

! ( &, $.

" ( ( % ( &, $ . .

1, 2, 2009 .

3

1, 2, 2009 .

4

0 Excel

" ($ $ Excel

7

, %!", $0 # % ,$.

%$ % & -0 % !" , %! .

– - # 1 65535 (2 % 0 #

).

% !

%!

– - " Z, ,

' ( ,

AZ, * BZ . . IV ( 256, 1 % 0 #

%!, ($ #$ )

6 0

%! % , $0 % !", $

' ( , %!

% ,$

<% !>< >,

(, 2, Z4.

' ( , $

( &,$ $ !$ (% ,):

R< >C< %!>,

"

(, R2C1, R72C3. % ( (

Excel

1, 2, 2009 .

5

1, 2, 2009 .

6

3 $

Excel

" ($ $ Excel. ' ( , "

' ( , % ,$ "#

1. .

, , " 0,

2. 8. 3 ! ", , ($7 , .

(, 4:7 7:4 4.7 7.4.

3. .

* (: &

, ( ,?

' ( , %!

% ,$ ,

$0

$ (

( &, 7$ % ,$

. % 0), !$

($ $.

%! , (, C:F

7

" $ ( 7 $0.

* (: & %!

, ( ,?

3 %" & % &. 0 ",

$& "0 % (( ,) $ % ,$

3$, «,»

$0.

# & "# $ ( 7%

($

0 $0.

($ ), , "# 0,

77 $0

(, F5:D4.

! 7, «% ,$».

* (: & $

, ( ,?

$0 #$ $. .

" : 4 , 4 %!, 6

$

1, 2, 2009 .

7

1, 2, 2009 .

8

$

* , 3 $

& - - ( ( $

$ . $

$ . *"% 0 0 - (

% ! " MS

-> &.

0.

Word:

•

$ .

•

*" 3

$0

•

! $

•

, . "

%!

" " $

•

. .

1, 2, 2009 .

9

1, 2, 2009 .

10

8

$0 # Excel

Excel

8 " " $

* $0 # %" &

-> $0 ( « $ »

7 (( $ ( ".)

•

"

8

" $ $

% !

•

* 5 "

"

.

# . "

%! $ "

Excel ( $ . 0

+ ( ! &$

"%

7,89954*1015

( $ ( ( &

.

% !"!)

1, 2, 2009 .

11

1, 2, 2009 .

12

Excel

Excel

8 " " $

8 " " $

" ( $ "# "#:

• %5 0 ( &,$ ( 7, $ % 3$

% "0

"# "# , 0 ( , &

•

8 0 " $"# ,

% ( (

$0 # , "

! ( $0 .

•

! "0 % ( (

"# "#

3 "0

3 ",

( ! , % ( "

$"# , ). (,

$0, 75 7

! "#

( ! "0 ,

$ 0,15. 1 " 15%

'

•

' 3 "0 % ( ( ,

0 3

3 " ,$ , " ( " ,.

' % $ $ 3 , 7 " " ( .)

• *$ – 8

' #$ 0, ( . . # 01.01.1900

12

. ( $ , ( :

''- -99 (04-6 -95);

-''-99(6 -04-95);

''- (04-6 );

-99 (6 -95).

1, 2, 2009 .

13

1, 2, 2009 .

14

"

Excel

"

Excel

–

" 3$

$," ( $.

* "

$0 $ ,

, ( " $

,

«=».

+ ( #

3

. * -

1. ( ! 0 (*, /, +, -, ^, >, <, >=, <=, =, ); ( ! Not,

3 $ $

.

And, Or , "

"# !$#.

( ($#

2. "# %

$ $ ".

* 3

3

&

3. (

(- , " "($7$ 0 $

" $ ("),

( ).

," & $0 ". 0.

( %" &:

* $0, 3 5 0 ,

% 3$ , &

"$.

1. " ( ", ", . .)

% 3$ , &, ,,

2. * " !

,

& . %,

($ .

3. " , %!", $0 # ( , " (

+ ( % 3 . %

#

( 0

$," ( $)

( " ( $ %

4.

( ( &

$&

( ! "($7$

(

1, 2, 2009 .

15

1, 2, 2009 .

16

"

Excel

"

Excel

6 0 3 ,

& 3 % 3$ ,

( -> ( " -> «*»)

, 0

$0 # 1, 2,

, & " " 0 % ( , ", % " " "

*1, *2.

3 ," 7 , $

$0

1, 2, *1, *2 ," 7

$75 $0

, ,$

7% 0 $75 0 $0

, &

" 0

C3

3 ,$

& « »

1, 2, 2009 .

17

1, 2, 2009 .

18

& " "

& " % 7 " "

, # + ( "# ( &, 7$ " $0 #

" $0

# ," 7 ( 3

( , " ( $ ( , )

$ – ( ( $75 # $ ) & $0,

" %" & " # :

3 5 0 (, 0 $0)

•

&$ " – 1

R[1]C[1]

•

% 7$ "

– $A$1

R1C1

•

. " "

– $A1

R1C[1]

• " 1 ," $0,

•

A$1

R[1]C1

$ 5 &

% 7$ & " (, , $) $ $ ( ( $ ,

$0 2

#

%! ;

3 5 # ".

&$ & " $ $

& "

• " 4 ," $0,

( 3

$75 # , "# $

$ 5 &

" ( , ($0)

$0 2

,

< $_ >!< $_( ,>, (, 2!F5

% ! .

" ( , ($0) 0 % 0 (0 *.xls)

[ $_0]< $_ >!< $_( ,>, (,

=[ # &.xls] 1!$A$20

1, 2, 2009 .

19

1, 2, 2009 .

20

$ ( ,

$ ( ,

& $ $0 ( , $ 3

* # 3 ( &, &:

0 * - > $

•

% " ( ), , " "

, 7$

•

! ",

.

•

,: _, .,\, ?.

* 0 ( , $

$0 ((

" ( :

7 –

$0, (,

•

&,$ ( &, &

( % ";

1) ,

•

$ $ % " ( $;

!,

•

&,$ ( &, & C, R

( # 3 $ ,

$0 - !$

( )1;

•

3 %" & % 255 .

$ $0

( , $ 3

" : _ _ , _ .(.

( &, &

7 $ $7$

#, $

( 0

.

1, 2, 2009 .

21

1, 2, 2009 .

22

, % % !

( $

0 , % % ! ( &, &

, " ( ( $0 A3, (

3

$0. & "

( &, & "#, % 7 "# . "# "

" ( ( /

'

( 5 $ .

( & "# % 7 "#

" ( ( ( 5 $

, ( , % % ! ( &, 7$

$ , %! , $ .

( " (

, %! , $

1, 2, 2009 .

23

1, 2, 2009 .

24

( $ $0

( $ $0

& " "

% 7 " . " "

:

3 3 & . F4, ,$ (

5 0 " (0, 0 #$ ). ( $ $

! A1 -> $A$1 -> A$1 -> $A1 -> A1

1, 2, 2009 .

25

1, 2, 2009 .

26

5 $

5 $

( 5 $ #$7$ ,

'

$75 # , "# $ # $

& "#, $ % 7 "# " !!!

'

( 5$ 3 # $ A1, A2 A3

3

, & ( 5$ $75 # $

( 5$ $0 A3

$0

( 5$ 3 $0 A3 ,$ $, ,$ $

, &

3 , 0 $0 *1

1, 2, 2009 .

27

1, 2, 2009 .

28

5 (

. %

#

– ( & ", (

3 . %, ( , $75 7 "( & "$

% , & , &, Microsoft Excel % , %5 % . %.

" ( $ $

"$, & , &,

#####

! ' !

( &, 0 -> ( ! &$

# .

.

#8!

& ' # ! (

( !.

#'/0!

#

" ", ! %$

0

!

#6?

Excel % # , #

# /'

!

#;!

"

#8!

#

#:!

! ! ", ! " #

$

< $0 . % 0, 3 ($ . 7$ ( , , 3

( « . %», ($ $.

1, 2, 2009 .

29

1, 2, 2009 .

30

"

* / , %! ,

$

* , 3 ($ ! # "

% ! ( #$ "($& /

%! , , $ ( , .

#$

% !. *

"

& "

1, 2, 2009 .

31

1, 2, 2009 .

32

" $ , # 0 % !"

" $ , # 0 % !"

: 2

: %! *

("$ & $0 *2

#.

%5 ! 0 ", . . , *4

= (A1:C3) ( 5$

*3 "$ %$

,$7$ "

$0 #, 3 5 # "

: 1 3 ( , 7 ".

: 7% 0 $0, ( $5 ( 5 7 $

: 3 %! %! 3 (

$0 ( ,, "0

&

", (. $ $ , & " 0.

, 7 "

$0 #, 3 5 # "

1, 2, 2009 .

33

1, 2, 2009 .

34

# 7 % !

, % % !

"

* % ! 3 *. ,$7$ ", "0

9 , %$ % ! ( , $ ( & "#

% ! 3

#

,$# , 0

$0 # % !" ( & , "

, & " (« %, »).

%# 5 & ( & – " $ $7$

# ", . . , $5 #. "

$ $7$ , " "$7$ ( .

* % ! (

9 ( &, 7$ " ", , 75$ .&

". 8 "

, "# $0 #

7

%! .

3 , ( &, 7 " , " $0.

,$7$ ",

"0 % !

- , & ( 3

$75 #

#

, "# $ 3 #$&$.

*" :

/ , %! , $ (

0 ", %" ,

# # 3 "

& $0 0 0 3 , , "# %! .

( 5 7 $ . % 7 ( ( 5$ –

, ( &, & " 3 $0.

#$ $ $,& $75 # , "# $ .

1, 2, 2009 .

35

1, 2, 2009 .

36

, % % !"

, % % !"

& ( # & z = cos(x) * sin(y)

( $

1.

* . ( ) 2 0,1 . ( Y

*2

0,2

2.

& " ,$ ) 4 -2 Y

*3 -1

3.

$ "$ ( 75 #

, 0 ) Y

5 = 4+$A$2; C3

=B3+$B$2

4.

( 5

6: 20, 3 D3:O3

5.

* *4 , 7 , ( -

" , % ( &$,

,$ X %! , ,$ Y

3 =COS($A4)*SIN(B$3)

6.

( $0 *4 ( , *5:*20

7.

( ( , *5:*20 ( ,

5: 20

1, 2, 2009 .

37

1, 2, 2009 .

38

( #

, % % !"

*"$

( ,

B4:O20