EXCEL
681.3
Excel / . .. , ... : - , 2007. 20 .
Excel. , , .
( 7 27.04.2007 .)
- .
. . , .
..
1. 1. ......................... 4
1.1. ...................................................... 4
1.1.1. ................................................................ 4
1.1.2. ................................................................ 6
1.2. .......................................................... 6
1.3. ............................................... 7
1.4. ........................................................................... 9
1.5. ..................................................................... 9
2. 2. ................................................................ 9
2.1. ...................................................... 9
2.1.1. .................................................................... 9
2.1.2. .............................................................. 10
2.1.3. ......................... 10
2.2. ........................................................ 12
2.3. ............................................. 12
2.4. ......................................................................... 13
2.5. ................................................................... 13
3. 3. MS Excel ........ 13
3.1. ................................................... 14
|
|
3.1.1. .. 14
3.1.2. ................................................................ 16
3.1.3. ................................................................. 16
3.2. ........................................................ 18
3.3. ............................................. 18
3.4. ......................................................................... 19
3.5. ................................................................... 19
....................................................................... 20
1.
- , .
Excel . . (2.31; 5.402; 45%), (, 1 ), (, ), (12.03.07; 11:30). .
, .. , , . . , , ( 1.1). - . , . , .
1.1 :
; 0,5
. , =. , , , , . +, -, *, / ^ ( ). : =12+5; =SIN(A1)-A1^2.
. . . $ .($A$2). , (A3). . . , ($H4, H$4). F4.
. (=), , , , . . , , , . , , . .
|
|
Excel 400 . . . , . .
1. , (, , , , .), .
2. . , . , . .
. . : ABS (), LN ( ), EXP (ex), , .
. , - . (1, 2, 3) 2, 1 , 3, 1 . 1.2.
1.2 ().
- . , , . . .. . . , , , .
, - . , . , ( ). . , CTRL.. -.
1. .
2. , . , . . ( ).
3. : , , , , .
4. : . .
(, , ). , . () .
|
|
1. I= (N mod 25) +1, N - , I - N 25
2. . . x, y. x , y .
3. . : , , .
3.1. .
3.2. X ( ), Y ( ).
1.1
y = | 0.2 | ||
y = | 0.2 | ||
y = | 0.4 | ||
y = | 0.2 | ||
y = | 0.2 | ||
y = | 0.2 | ||
y = | 0.2 | ||
y = | 0.2 | ||
y = | 0.5 | ||
y = | |||
y = | 0.1 | ||
y = | 0.2 | ||
y = | 0.2 | ||
y = | 0.2 | ||
y = | 0.2 | ||
y = | 0.2 | ||
y = | 0.2 | ||
y = | 0.2 | ||
y = | 0.2 | ||
y = | 0.2 | ||
y = | 0.2 | ||
y = | 0.2 | ||
y = | 0.2 | ||
y = | 0.2 | ||
y = | 0.2 |
, , , , .
1. Excel ?
2. ?
3. ?
4. ?
5. ?
6. . ?
2
( / ) .