: MS Excel
-
,
,
2016
004 (004.021)
: MS Excel: - , , . / . ... .. ; : - , 2016. 47 .
- , , , . MS Excel, , MS Excel. .
.
. . , .. .
004 (004.021)
ISBN
, 2016
. 4
1. MS Excel 6
2. MS Excel 11
3. MS Excel 14
4. MS Excel 19
.. 30
1. 31
2. 32
3. 34
4. 35
5. 39
. 44
.. 45
. 46
- MS Excel .
MS Excel (. 1) , , .
. 1. MS Excel 2007 |
MS Excel , , , (.xls,.xlsx). Excel : 1, 2 ..
, , . , . 1 16535, (A, B, , AA, AB ..). , : 256 16535 .
- (, , ).
|
|
MS Excel :
1. , ;
2. (, 15; 1,5; 1000 ..), ,;
3. (, , ..);
4. (, 14.03.01, 13:30 ..) ..
, , , (. 2.).
. 2. |
MS Excel , , . MS Excel , , , .
MS Excel
MS Excel , . MS Excel , .
, MS Excel . MS Excel (=). , 10 12 3 =10-12/3. , : , , , .
, , . , COS() . , .
( ) . , 2 . , MS Excel.
, MS Excel , 1.
1
MS Excel
ABS() | , | = ABS(-2) 2 = ABS(10-3*2) 4 |
() | 3,14159265358979, π 15 . | = () 3,14159265358979 |
COS() | , . , . | = COS(0) 1 = COS(()) -1 |
SIN() | , . , . | = SIN(0) 0 = SIN(()/2) 1 |
TAN() | , . , . | = TAN(0) 0 = TAN(()/4) 1 |
EXP() | e, , . | = EXP(0) 1 = EXP(1) 2,71828 |
LN() | , . . | =LN(EXP(1)) 1 =LN(3) 3 (1,098612) |
() | , . 0. | =(4) 2 =(16+ABS(-9)) 5 |
1 , MS Excel. .
|
|
:
MS Excel +, =3+143 ( B3 143).
MS Excel -, =B3-143 ( B3 143).
MS Excel *, =B3*143 ( B3 143).
MS Excel /, =B3/143 ( B3 143).
MS Excel ^,=B3^143 ( B3 143).