1
Ȩ MS Excel 2007
1. , Excel.
2. Excel .
3. Excel.
4. : , , .
5. MS Excel.
1
, , .
1. .
2. A 1 = , A 2 = (. 1).
3. 1 4, 2 3. 3, 4 5 , , :
B 3 | B 4 | B 5 | |
. 1.
2
a, b c. , , = (+b+c)/2, : .
1. .
2. 2: 6 . 2 ( 6 , ).
3. 2, 3 4 , b, . 2, ( ) 2 , Enter. 2 . 3 6 b . 4 , xcel r . 4 , , , _
4. 2, 3, 4 6 . (. . 2).
5. 7 =(p *(p ‑ a)*(p ‑ b)*(p ‑ c _), .
6. .
. 2.
3
. 5, 1 12.
1. .
2. .
3. A :
- 2 , ;
- , .
|
|
4. B, (. 3).
- ;
- ;
- , , : ; . .
5. ( . 3), .
6. , , .
. 3.
4
, .
1. .
2. , Excel:
- , , , ;
- ( ) ;
- , Word;
- ( , , .), , , , .. , .
3. 26 . 26 1 ..=, . 26 .
4. 4 = B 4*$ C $26, 4: 15.
5. 4 = D 4*$ C $26, 4: 15.
6. G 4 = F 4*$ C $26, G 4: G 15.
()?
() ?
7. , , , G.
8. , , .
9. 16. . , . Enter.
10. 16, D 16, E 16, F 16, G 16.
11. B 17. (fx), , . , , . Enter.
12. 17, D 17, E 17, F 17, G 17.
13. , , ( ) ( ) .
14. .
. 4.
|
|
, .
Excel (. 5) :
1. , .
2. ( B).
3. 15,3 Excel ( C), .
4. , 15, ( D). / / / .
5. E .
: = ()*12 +3. ( () [ 0; 1]).
6. F [3,15] 1,5. ( ).
7. G ()
. 5.
. | B | D | E | F | G |
. | |||||
23,9 | <= 20 | [‑2, 10] | 1; 0,5 | 01.10.10 | |
34,5 | >= 5 | [0, 25] | 7; 1,5 | 01.11.10 | |
0,92 | [2, 15] | [1, 15] | 0; 0,3 | 01.12.10 | |
98,1 | < 34 | [20, 35] | -1; 0,1 | 01.01.11 | |
8,54 | > ‑12 | [3, 18] | 2; 1,2 | 01.02.11 |
2
Excel
1. MS Excel.
2. .
:
1. , .
2. (, , .). .
:
, , , , .
, ( , ), , .
, , , , .
1
( 1).
1. .
2. A 4: B 15, CTRL , , D 4: D 15 F 4: F 15.
3. / / ( (. 6).
. 6.
4. , ( ). , .
5. , , , , .$ , .
|
|
6. Excel, .
7. , . , , , , .
8. (. 7).
9. .
.
. 7.
2
r = 2 sin(j), j Î [0; 2p].
1. , .
2. ( ) .
3. ( ). r , , j [], r ( Excel , ). , , , , .
4. .
?
3
z = x2 y2 , Î [‑1; 1].
1. ( z).
2. : , 2, ; 1, 1 .
3. 2 , , :
- , , .. ;
- , , .. 1.
, z = x2 y2 :
=$ A 2^2‑ B $1^2
: 2 .
4. Excel, z , . .
5. .
, .
( ) (1 5). ( ) ( 1).
|
|
. | |||||
3