-
Excel OpenOffice.org Calc
:
, .
:
080105.65
080507.65
220201.65
220301.65
:
080100.62
080500.62
220200.62
-
-
881.3
: - ( : . Excel OpenOffice.org Calc ) /.: . . , .. , .. , . . . .: - , 2008. ..
- .
, , , , , .
, , Ms Office, , OpenOffice.org ( , Excel, ).
1-
080105.65 - ;
080507.65 ;
220201.65 ;
220301.65 .
15.05.08 , 26.05.08.
: | (. . .. , . .-. , .); .. , . .. , . |
: | .. , . ., .. , . . , .; .. , . ., .. , . . , . |
ã - , 2008
. Excel OpenOffice.org Calc .
|
|
, , Ms Office, , OpenOffice.org ( , Excel, ).
:
1. . : / . .. . .: , 2004.
2. , .. Excel, VBA, Internet / .. .: BHV, 2003.
3. , .. : . / .. . .: - , 2007.
:
4. , .. Excel / .. , .. .: BHV, 2004.
5. , .. Microsoft Excel 2000/ .. , .. .: BHV, 1998.
6. , .. Excel: / .. .: , 2000.
1.
.
, : , , , ( Excel , Calc ).
1. .
2. .
3. .
4. .
5. .
1
=+,
= = .
3.1.1.
Excel ( Excel). OpenOffice.org Calc OpenOffice.org2.4 - OpenOffice.org Calc. 3:5, 3:G5 (. 1 , . 2 Excel, . 3 OpenOffice.org Calc).
3.1.2.
:
3:5;
( OpenOffice.org Calc );
3:G5;
( OpenOffice.org Calc B ).
3.1.3.
7:9, ( );
=;
( OpenOffice.org Calc );
+;
( OpenOffice.org Calc );
= + , Ctrl+Shift+Enter.
|
|
2
3.2.1. D = 3 * A - B
, (. 3.1.1). D 33, 11:13.
1.
3.2.2.
=3*;
- ( OpenOffice.org Calc - );
(). - =3*;
( OpenOffice.org Calc - );
Ctrl+Shift+Enter.
3.3. 3
3.3.1.
:
A | B | C | D | E | F | G | |
1. C=A+B | |||||||
-3 | -3 | ||||||
-2 | -7 | ||||||
-8 | -4 | -8 | |||||
-2 | |||||||
-1 | |||||||
-2 | |||||||
2. D=3*A-B | |||||||
-11 | |||||||
-30 | |||||||
3. | |||||||
4. | |||||||
0,412 | -0,263 | 0,009 | |||||
0,232 | -0,053 | -0,05 | |||||
-0,11 | 0,158 | 0,061 | |||||
5. | |||||||
-10 | -12 | ||||||
-12 | -36 | ||||||
-97 | -60 |
15, ;
, , . ( OpenOffice.org Calc , MDETERM, );
3.3.2.
3:5, ( OpenOffice.org Calc 3:5, ).
! 3:5 =(), ( OpenOffice.org Calc =MDETERM(3:5).
4
3.4.1.
:
17:19, ;
2. Excel
A | B | C | D | E | F | G | |
1. C=A+B | |||||||
-3 | -3 | ||||||
-2 | -7 | ||||||
-8 | -4 | -8 | |||||
=+ | =+ | =+ | |||||
=+ | =+ | =+ | |||||
=+ | =+ | =+ | |||||
2. D=3*A-B | |||||||
=3*- | =3*- | =3*- | |||||
=3*- | =3*- | =3*- | |||||
=3*- | =3*- | =3*- | |||||
3. | |||||||
=() | |||||||
4. | |||||||
=(3:5) | =(3:5) | =(.. | |||||
=(3:5) | =(3:5) | =(.. | |||||
=(3:5) | =(3:5) | =(.. | |||||
5. | |||||||
=(3:5;3:G5) | =(3:5;3:G5) | =.. | |||||
=(3:5;3:G5) | =(3:5;3:G5) | =.. | |||||
=(3:5;3:G5) | =(3:5;3:G5) | =.. |
3. Calc
|
|
A | B | C | D | E | F | G | |
1. C=A+B | |||||||
-3 | -3 | ||||||
-2 | -7 | ||||||
-8 | -4 | -8 | |||||
=+ | =+ | =+ | |||||
=+ | =+ | =+ | |||||
=+ | =+ | =+ | |||||
2. D=3*A-B | |||||||
=3*- | =3*- | =3*- | |||||
=3*- | =3*- | =3*- | |||||
=3*- | =3*- | =3*- | |||||
3. | |||||||
=DETERM() | |||||||
4. | |||||||
=INVERSE(3:5) | = INVERSE (3:5) | = INV.. | |||||
= INVERSE (3:5) | = INVERSE (3:5) | =INV(.. | |||||
= INVERSE (3:5) | = INVERSE (3:5) | =INV(.. | |||||
5. | |||||||
=MULT(3:5;3:G5) | = MULT (3:5;3:G5) | = MULT | |||||
= MULT (3:5;3:G5) | = MULT (3:5;3:G5) | = MULT | |||||
= MULT (3:5;3:G5) | = MULT (3:5;3:G5) | = MULT |
3.4.2.
;
, , ( OpenOffice.org Calc , MINVERSE, );
() 3:5;
Ctrl+Shift+Enter.
5
3.5.1.
. = * .
:
21:23, ;
;
, , ( OpenOffice.org Calc , MMULT, );
|
|
1 ( ) (3:5), 2 ( ) (3:G5), Ctrl+Shift+Enter.
! =(3:5;3:G5).
OpenOffice.org Calc = MMULT(3:5; 3:G5)
, . .
( ).
: [6], . 166-171.