Excel, . , . Excel, ӳ, 14 15 Excel 2002 ( , MVP Excel).
Excel, , . , - . Excel , . , :
;
, (, , );
n- .
" CSE", , , Ctrl+Shift+Enter.
, , , . . Excel ( ), ( ) ( ). Excel .
, . , . . , .
, .
. , Enter ( Ok ), Ctrl+Shift+Enter.
. Excel {} .
. , , . ' , , .
|
|
34.
ϳ , , " , ".
1. " (10)
1) B2:K2 <--- {=(B1:K1<0; B1:K1; "")}
2) B3<--- =(B2:K2)
3) B4<--- =(B2:K2)
2. (10)
1) B2:K2 <--- {=(B1:K1>0; B1:K1^2; "")}
2) B3<--- =(B2:K2)
3) B4:K4 <--- { =B1:K1-B3}
3. () (10)
1) B3:K3 <--- {=(B1:K1=0; B2:K2; "")}
2) B4 <--- = (B3:K3)
4. " (10)
1) B2:K2 <--- {=(B1:K1<0; B1:K1; "")}
2) B3 <--- = (B2:K2)
5. N (10)
1) C5:L5<--- {=C1:L1+B5:K5}
2) C6:L6<--- {=(C2:L2=B3;C5:L5;"")}
3) B7<--- =(C6:L6)
4) C8:L8 <--- {=C1:L1*B8:K8}
5) C9:L9<--- {=(C2:L2=B4;C8:L8;"")}
6) B7<--- =(C9:L9)
6. " (10)
1) C2:L2<--- {= (C1:L1<0; C1:L1*B2:K2;B2:K2)}
2) B3<--- =L2
7. (10)
1) B2:K2 <--- {=(B1:K1/2=(B1:K1/2);B1:K1;"")}
2) B3<--- = (B2:K2)
8. (10) , . , .
1) B4:B13 <--- {=(C3:L3)}
2) A4:A13 <--- {=(C2:L2)}
3)C4:L13 <--- {=(C3:L3=B4:B13;(C2:L2<>A4:A13;C3:L3;"");"")}
4) C15 <--- =(C4:L13)
5) C16:L16 <--- {=(C3:L3=C15;C2:L2;"")}