: .
: , , , .
- . , . , , .
, , .
, , , , . , , .
, , .
( ), . , .
Crtl +Shift+Enter. , , - , , .
Excel :
- ( ).
, .
1
. : . , , , (. . 1).
. .1
:
1. , - A3:D4, F3:G6, I3:J4 .
:
2. . :
, A10:B11.
4 4 , ,
.
1 2
|
|
Crtl +Shift+Enter.
3. . :
E10:F11
=A10:B11+I3:J4
Crtl +Shift+Enter
4. :
13:14
4 4 , , ,
E10:F11
Crtl +Shift+Enter.
:
, L10:M11
=((A3:D4;F3:G6)+I3:J4)
Crtl +Shift+Enter.
2. , .
:
1. - A3:C5 A7:A9 .
2. . 0, , .
3. , , :
, 12:C14
4 4 , , ,
3:5
Crtl +Shift+Enter.
4. , , - .
5. , =.
.
((QT34+D43)H32)T=? | X1-2X2+6X3=-28 3X1 +3X3=-6 -2X1+X2-4X3=15 | |
(BT23+H32)(E22+D22)=? | 2X1 +X3=6 4X1-3X2-2X3=-1 2X2+7X3=12 | |
(QT34D34+E44)T=? | -3x1+2x3=5 2x1+4x2+4x3=-2 x1-2x2+5x3=31 | |
(E33+H33+DT33)Q34=? | 3x2+2x3=2 -2x1+6x2=-22 4x1-2x2-x3=20 | |
((E44+DT44)(Q43-B43))T=? | 5x1+2x2+x3=21 -2x1-4x2+2x3=-2 7x2+8x3=-14 | |
((H34B43)T+E33-D33)T=? | 6x1-2x2=18 4x1+3x2+4x3=-1 6x2+x3=-18 | |
((D34+B34)Q43)T+E33=? | 8x2+9x3=38 2x1+4x2-2x3=-14 -3x1+2x2+x3=-7 | |
(DT34(E33+B33+H33))T=? | 2x1+4x2+x3=2 -x1+6x2+8x3=17 3x2-12x3=-54 | |
D43(E33+H33)T+QT34=? | -x2-4x3=-18 -8x1+2x2+2x3=12 4x1+4x2=8 | |
(D33+E33)T+H34Q43=? | 7x1+6x2+8x3=64 2x1+3x2-5x3=-19 4x1+5x2+2x3=29 | |
(Q34BT34+E33-D33)T=? | 9x1+7x2-x3=39 -3x2+4x3=-9 3x1+x2+9x3=9 | |
(E33+D33)T(Q34B43)=? | 5x1+x3=25 6x1+7x2+10x3=81 -2x1+4x2+x3=1 | |
(D43+HT34)(E33+Q33)T=? | -x1+8x2-3x3=1 8x1+2x2=-38 -5x2=7x3=-34 | |
(((E44+Q44)D42)H23)T=? | -6x1+7x2-4=-44 3x1+6x2+6x3=57 5x1+4x2+7x3=71 | |
((E33+H33)T+B33)D32=? | -x1-7x2+6x3=-14 2x1+5x2+2x3=19 9x1+6x2+6x3=69 |
|
|