MS Excel. A2, A3, A4, A5 A6 : a, b, c, n m. B1, 1 D1 : I, II, III. B2:D6 . A7, A8, A9 , . MS Excel , . 1.1.
.1.1 |
, . 1 , .2.1.
. 1.2 |
ʻ.
" " 1, , .. . 1:D1 (. .1.3). " " " ", ,
. 1.3 |
, , "" .
, "", "", "" .
, , " ", " " .
, . , , A1:D2 "", 3:7 "".
:
- , ;
- .
() , , , ( 1:D10)/
- Ctrl C
- ()
- " " (" " )
, () :
- Ctrl V
- " " .
:
|
|
- 1:D7;
- ( ;)
- 2, ;
- 1 2;
- ( .)
2.
F, S SR B, :
8 =ABS(COS(()/3)*(B3-B4)*B6^2)/(B5-(B7))), F ;
9 =(B3:B7), ;
10=(B3:B7), ;
.1.4 |
F, S SR , 8, 9 10 . - . , 8, , ( , ) , 8 D8. 9 10 (. .1.4). , :
, . 8:D10, .
:
- ;
- ;
- .
, , , . , , . ( ). , , :
- ;
- ;
- .
, .
Excel | Excel | ||
* | =A2*B2 | ||
/ | =A2/B2 | ||
() | = (A2) | ||
^ (Shift+6), () | =A2^B2, =(A2, B2) | ||
SIN() | sin x | =SIN(A2) | |
COS() | cos x | =COS(A2) | |
TAN() | tg x | =TAN(A2) | |
LN() | ln x | =LN(A2) |
|
|