3. 
[0,3; 3,7] c 0,2.
3 0,3 3,7. , .
Y . 3, Y =LN(3*A3).
Y .
3.5
4
4.1 ? ?
4.2 ?
4.3 ?
4.4 ?
4.5 .
4.6 ?
4.7 .
4.8 .
4.9 .
4.10 .
4.11 .
4.12 ()?
4.13 ()?
4.14 ()?
5
5.1 6?
| A | B | C | |
| =(2:3) | |||
| =(5;3) | |||
| =(1:3) | |||
| =(3/4>12;A3-C1;C2*4) |
5.2 C4 ?
| A | B | C | |
| =(1;2) | =(1;2) | ||
| -31 | =$B3+1 | ||
| =(1:3) | |||
| =(A1:A3) | =(B1:B3) | =(A4:B4) |
5.3 6?
| A | B | C | |
| =((A5;1);((B2;1));(B6;1)) | |||
| =(A4; ;C2) | |||
5.4 6?
| A | B | C | |
| =(B1*C2) | =(A5) | ||
| =A4*A5 | |||
| -2 | |||
| =(A1:A5) | =(A3;B3) |
5.5 4 5 2?
| A | B | C | |
| =(A$3) | |||
| =$C3/$C$5 | |||
| =(B1:C2) | |||
| =(A5:C6;"<=5"; A1:C2) | |||
| =(B3:C3;B5:B6) | |||
|
|
|
5.6 C5 6?
| A | B | C | |
| =(A1:C2;">2";A1:C2) | =() | ||
| =A4 | |||
| =(C4) |
5.7 6, 6?
| =(A1:B1) | |||
| =ר(A1:C1) | =(A2:B2) | ||
| =(A3:B3) | |||
| =(A4:B4) | |||
| =(3) | =(A5:B5) | ||
| =(A1:A5) | =B2+A5+C1 |
5.8 A2 C2 4?
| A | B | C | |
| =(2:6) | =(2:6) | ||
| =(A3:6;>11) | |||
| =$B$2*$3+$A3 | |||
| =(B1;1) | |||
| =(6+4) |
5.9 5 6?
| =(B1;C3) | |||
| =(B5) | |||
| =(A4) |
5.10 1, C2, C3, 2?
| 08.03.03 | =(A1) | =(A1) | |
| 09.03.03 | =(A2) | =(A2) | |
| 10.03.03 | =(A3) | =() | |
| 11.03.03 | =(A4) | =(C2:C3) | |
| 12.03.03 | =(A5) | ||
| 13.03.03 | =(A6) |
5.11 6?
| -3 | |||
| =(A1;B2) | |||
| -1 | -5 | ||
| =(B3;C2) | =(B3:B5) | =((A4+A6>20;B6>0);B6;C4) |
5.12 4 3?
| A | B | C | |
| =1+1 | |||
| =(1:2) | |||
| =(A1:A2;C3;B3) | =(3<4;.4*2;B2/2) | =1+2 | |
| =3*2 |
3
Excel
: Excel. :
ü ;
ü ;
ü .
Excel , , . . . , :
ü ( );
ü ;
ü ;
|
|
|
ü .
, . , .
2.1 Microsoft Excel.
2.2 1 1 , 1.
2.3 ( , , ).
2.4 .
2.5 , , , , .
