(, ) (, )
Windows. , , ( /, Enter ); . .
Excel . , 1, 1 1900 ( Excel). , 1 2001. 36892, 1 1900. , , , , , , .. .
, , : 1.01.98; 1..98; 1.; 98 . , , . , 5.10.01 5 2001. . , :
00¸29 2000 2029.; 30¸99 1930 1999.
. ( ). , 5.10 5 , 2004, .
-. 24 , 1/24, 12 0,5 .. , . , 10:15:28 10 15 28 0 1900 , 0,420138888888889. , , .
. . , 6:, 6:00 (.. 6 0 ). , . , 7.2.99 6:12:40 7 1999 6 12 40 .
, , Ctrl+; Ctrl+Shift+: .
. / - , . 1 0 .
, . Excel ( ) , . , , , {7;-4;9} . .
|
|
, .
= , , , ( =5+4/35, =12%*D4, =12*4-SIN(D3)^2).
Excel :
( ):
( 1), ^ ,
% , *, / , , +, , .
- , . :
: :
=7+5^3/(6*8)
=A5/(C7-4)+(4+F4)/(8-D5)*2,4
2 + SinD32 =2+(SIN(D3))^2.
%.
%, 100 . , 5%, 0,05. , , . 0,05.
(.. , ) . , 5% 200. =0,05*200, =5%*200 =200*5%. 10. , =E4%. 4.
&. . , , =& .
: =, <, >, <=, >=, < >. , . , , , < >. .
="F">"D" =3>8.
, F D ( F D). , , .
, . , , , , A1, A2, A3 A4, . ( ) =(A1>0)*(A2>0)*(A3>0)*(A4>0).
,
=***=1*1*1*1=1.
1, 0, 1. 0. ( ()), .
. , A1, A2, A3, A4 . =(A1>0)+(A2>0)+(A3>0)+(A4>0).
|
|
, , 2 =+++=0+1+0+0=1.
, 0. , 1 ( 2 4).
. Excel , . , , , , . , , , , , , . , Excel , . 4.
1 | |
1 = | = |
A2 + | =2+ |
D4 * | =2+D4* |
C1 Enter | =2+D4*C1 |
. 2.4-1 |
, , . , ( ) , .
1 | |
1 =( | =( |
A2 , , D8. ; | =(2:D8; |
E3, ) Enter | =(2:D8;3) |
. 2.4-2 |
1 =2+D41. (. 2.4-1) :
. , 1 (. 2.4-2) : =(2:D8;E3). , , , .
Excel , . ( ).
A | B | C | D | E | F | G | |
=(B2:F2) | |||||||
=(E4:F4) | |||||||
=() | |||||||
. 2.4-3 |
, . å . , . ( 2 . 2.4-3) G2 2:F2. G2 . Excel G2 , , Enter. Excel ( ) .
, G4 B4:F4, () . å G4 4:F4. B4:F4 Enter. , , / - ( 6 ), . ( 6:F6).
|
|
A | B | C | |
. 2.4-4 |
. , , . , (. 2.4-4) . 1 =1*1 . . 1:3 , =1:3*B1:B3 Ctrl+Shift+Enter. , 1:3 , {=1:3*B1:B3}.
1:3, 1:3 1:3. . , Ctrl+Shift+Enter.
, , . Ctrl+/, , .
- , . , . Excel .
@ , , , . . (, ), Ctrl+` ( ` , ) : + + + .