EXCEL
9
, ,
1.1. 2. .
1.2. [1,2] 3 .
2. 1. ([1] .55).
: + + + .
( ) + (1 - ).
( ) + (2 - (), , , , ..).
+ 1 + -2 + ( () ) + + + , + . .
([1] .74)
.
,
.
( ) 2 : 1 , 2 ([1] .64,65).
2.4.1. , . .
+ =A1+1
- =4 - 4
* =A3*X123
/ =D3/Q6
% =10%
: =(A1:C10)
; =(A1;A2;A6)
& ( ).
2.4.2. . =() () . ( ) , . : =B1+B2+B3+C4+C5+D2. (), Enter.
. () (950).
Excel.
( + + c) . Excel, , (å) ̻. , . : =(B1:B3;C4:C5;D2).
|
|
: Y= √(cos(0.35) +log(5.7) +Exp(6.2)) * sin(0.78)
2.6. . . , , , , . 1 4. : =(1;2;3;4) =(1:4).
2.12.6.
(1;2;...)
"&".
1, 2,... - 1 30 , . , , .
:
(" "; "") " ". ""&" "&"".
, , , C2 "", C5 " " C8 32. (" ";C2;" ";C5;" ";C8;" .") " 32 ."
2.8. (_;_;_;_) - .
. ("1990"; 3; 2; "91") "1991"
.
2.10. () - .