1308.501 49.000 |
( ) |
, ., . | ||||||
104 | ||||||
.. | ||||||
.. | ||||||
.. |
2012 .
充..3
4
充.9
..10
MS Exce l MS Office. MS Excel , . . Visual Basic for Application (VBA), MS Excel , .
. . - , , , .
MS Excel:
1. ;
2. ;
3. ;
4. .
49
1
Excel , .
H2 =(F2;G2).
H2 H3-H5.
H6 =(H2:H5).
: B7 =(B2:B5;G2:G5)
, C7-E7 : =(C2:C5;G2:G5)
=(D2:D5;G2:G5)
=(E2:E5;G2:G5)
10 (3 , 2 , 1 ) I2 =(C2*3;D2*2;E2)*10.
I2 I3-I5.
10 I7 =(I2:I5;G2:G5).
, A1-B5, , .
|
|
A1-A5, B1-B5
A1-A5, C1-C5
A1-A5, D1-D5 , .
2.
Excel .
B2 =1,5*SIN(A2/4)*COS(4*A2)*100
B2 B3-B13.
B1-B13 ,
MS Excel . Excel 400 , , , , , . MS Excel, , .
, MS Excel, .
1. http://office.microsoft.com/ru-ru/excel/
2. Excel - :, 2009.
3. Microsoft Office Excel - .. . .-.: -; 2008.
4. ., . Excel. .: -, 2008.
5. . Excel 2007. .: Media, 2008.
6. : . / .. , .. .; . .. . .: , 2011.
7. . Microsoft Office Excel Windows. 2010.