I. EXCEL.
519.6
. / .. .- : , 2015.- 14 .
:
EXCEl . , .
,
___ ______________ 2015.
:
1.
EXCEL. .
EXCEL. 4
2.
EXCEL. 7
3.
EXCEL. 9
4.
EXCEL. 10
5.
. 13
6.
EXCEL. 15
1.
EXCEL. . EXCEL.
: EXCEL, ; ; , ; .
..1.
1. EXCEL ;
2. (, , );
3. ;
4. ;
5. ( );
6. 1:S1000;
7. .
8. ;
9. :
A | B | C | D | E | F | |
1 | 2 | 3 | 4 | |||
=B2+C2+D2+E2 | ||||||
=B2*0,3 | =C2*0,3 | =D2*0,3 | =E2*0,3 | =B3+C3+D3+E3 | ||
=B2-B3 | =C2-C3 | =D2-D3 | =E2-E3 | =B4+C4+D4+E4 | ||
=B6+C6+D6+E6 | ||||||
=B2*0,1 | =C2*0,1 | =D2*0,1 | =E2*0,1 | =B7+C7+D7+E7 | ||
=B6+B7 | =C6+C7 | =D6+D7 | =E6+E7 | =B8+C8+D8+E8 | ||
=B4-B8 | =C4-C8 | =D4-D8 | =E4-E8 | =B9+C9+D9+E9 | ||
=B9*0,5 | =C9*0,5 | =D9*0,5 | =E9*0,5 | =B10+C10+D10+E10 | ||
=B9-B10 | =C9-C10 | =D9-D10 | =E9-E10 | =B11+C11+D11+E11 |
|
|
:
- EXCEL;
- ;
- ;
- ;
- EXCEL ;
- .
1. 1. : 2. ; 3. ; 4. 5. . 6. 2. : 7. 18900000000,45; 0,00000012; 67; -3, 12%; 35,2%; 8. 3. : 1/3; 2 5/6; 567/789; 4. : 1234; 15; 5. : A5:D8;B3:R150; 1,3,5,6 A, D, E, F. 6. 1=2, 3=6, 5=10 : A1-A3; A1*A3-A5; A3-A1*(A1+A5) | |
1. : ; ; ; . 2. : 345876008765; 56,7; 0,870004567; -56; 55%; 67,2% 3. : 5/6; 3/45; 2 7/8; 345/987; 4. : 876; 34; 5. : A4:E10; C2:W120; 2,3,5,7 G, H, E, K. 6. 1=2, 3=4, 5=7 : A1-A3; A1*A3-A5; A3-A1*(A1+A5) | |
1. : ; ; ; . 2. : 6783450086000; 0000000000,45; -78; 45000000000; 35%; 12,56%. 3. : 5/6; 1/3; 8 5/9; 456/9876. 4. : 3456; 90 5. : A2:T200; F5:K9; 3,5,9,11 B, D, E, F. 6. 1=3, 3=4, 5=5 : A1-A3; A1*A3-A5; A3-A1*(A1+A5) | |
1. : ; ; ERP-; . 2. : 4578900000; 34,7; 0,000000067; 145000789; 56%; 101,5%; 3. : 3/5; 678/45678; 3 8/9; 4. : 76; 45678; 5. : B3:F5; D2:V110; 1,3,4,7 A, C, G, H. 6. 1=3, 3= 4, 5=7 : A1-A3; A1*A3-A5; A3-A1*(A1+A5) | |
1. : ; ; . 2. : 23400000000; 0,00000000075; 28,85; 23456890876; -89; 15%; 102,23% 3. : 7/9; 2 6/7; 456/987 4. : 76; 4563; 5. : C2:G7; A2:R200; 1,2,5,7 A, C, E, D. 6. 1=6,3=4, 5=2 : A1-A3; A1*A3-A5; A3-A1*(A1+A5) | |
1. : ; ; ; . 2. : 450000076300; 0,00000000045; 123000000; -87; 56,34; 76%; 99,25% 3. : 9/10; 6 7/9; 123/678 4. : 102; 55; 5. : B4:E7; A3:T200; 1,2,5,7 A, C, E, D. 6. 1=5,3=1, 5=4 : A1-A3; A1*A3-A5; A3-A1*(A1+A5) | |
1. : ; ; ; . 2. : 654000000345; 0,000000000032; 12567656454647; -789; 99,21; 100%; 11,99% 3. : 4/7; 6 3/8; 234/9876 4. : 7890; 12; 5. : D3:H7; B4: X150; 2,5,6,9 F, G, K, M. 6. 1=6,3=1, 5=3 : A1-A3; A1*A3-A5; A3-A1*(A1+A5) | |
1. : ; ; ERP-; . 2. : 345000000; 0,000000065; 1678595846734; -54; 98,59; 75,99%; 89%; 3. : 8/9; 5 9/10; 345/9876 4. : 88; 6789; 5. : A5:H7; D2:Y250; 1,4,6,9 A, C, E, G. 6. 1=3,3=5, 5=8 : A1-A3; A1*A3-A5; A3-A1*(A1+A5) |
2.
|
|
EXCEL.
: EXCEL.
, .
. . .
. , . .
.
, , .. .
.
, . , , .
, .
( ), . (. ).
.. .
.. 2.
1. . 1 .
2. () .
3. .
4. , .
|
|
6. .
7. , .
8. , .
:
- ;
- ;
- .
3.