1
Microsoft Excel. , .
: , ,
( )
1 "", 2 , 2 , 2 , 3 , D3 , 2 ,G2 , 3 .
3 D3, , [ CTRL ], E3 F3. 3 G3.
1-1; 2-D2; E2-F2; G2-H2; 2-3; 2-3.
2 >> , , . , . 2.
1 3 ( [ CTRL ]+[ 1 ]), , ( ) .
4 F7 ( 4 - F4 !).
G4 =4-4 ( ) G7. 4 = G4*D4, 7. 8 4:7.
, 3 >>> . 3 , 4 - =4*D4 7, 8 - (: >>).
.
, >> () , - ( ), .
, .
( ) . 1 - , 2 - , 2 (, 30,1), 3 - , 3 - .., 3 - . 2 > .
5 , .., - : 4 =4* ( , 2), 8. , 4,5...8. , 4, 5... 8 1.
2 - (, 6 1998 ). . ( ):
4 8, , . ( > > );
|
|
4-8 ( - $ ());
() ( > );
( > >);
( > >).
, , .
( )
1 . F1. > , . 1 C4:C8. [ ENTER ] . 2 .
2- ( 2- >>> ). 2 , 2 , > , () . -.
EXCEL , . .
, :
5:9 5:9 (, [ CTRL ]);
>;
;
>> 5 .
.
5:C9, >, - . >> 8. - - , - , . , > .
. , . .
1, , 1 .
.
1. ?
2. ?
3. , ?
4. ( - )?
5. ?
2