, , , (.. , ), .
. - () .
, Windows. Symbol.
.
5.
. , , . , , . Microsoft MS Excel.
, . , . .
, () , . , (:). , 1:2 1,2,1,2.
. , . / $. , $6 , $6 , $$6 - , .
, , . (=) , , , .
. (;). :
= (5:20) , 5:20;
= (1:25; D2:30) ;
= (1:5; 10; 30) ;
= (1<0; 1+2+3; D1*D2) 1:3, 1<0 D1*D2, 1>=0.
= (A1:A7) , 1:7, , .
= (A1:A7) , 1:7, , , , .
|
|
= (1:A7) 1:7.
= (A5;A1:A7;1). A5 1:7. . ( , .)
=(A1: A7). 1:7.. ,
=(A1: A7). . , .
fx. (, SUM, MIN, MAX, IF, ..). .
5.1. :
1. .
2. .
3. .
4. .
5. .
6. .
7. .
8. .
9. .
10. A3.
11. .
:
5.1
B | C | D | E | F | G | ||
110,299 | 12,234 | 57,121 | 5,12 | 0,4632 | 12,421 | ||
392,444 | 11,567 | 55,533 | 6,24 | 0,2344 | 55,321 | ||
233,212 | 10,452 | 49,334 | 3,42 | 0,4642 | 10,433 | ||
422,122 | 11,943 | 54,432 | 3,12 | 0,0300 | 54,433 | ||
232,212 | 12,432 | 54,231 | 6,56 | 0,6843 | 12,433 | ||
432,110 | 11,343 | 57,654 | 4,43 | 0,8686 | 57,655 | ||
182,321 | 10,232 | 55,113 | 7,66 | 0,6432 | 10,202 | ||
175,222 | 12,111 | 58,543 | 3,24 | 0,0342 | 58,540 | ||
142,443 | 11,232 | 50,332 | 4,75 | 0,5222 | 11,234 | ||
322,421 | 11,109 | 51,231 | 6,32 | 0,1222 | 51,233 | ||
= (A1:G10) | |||||||
= (A1: G10) | |||||||
= (A1: G10) | |||||||
= (A1: G10) | |||||||
= (A1: G10) | |||||||
=(A1: G10) | |||||||
=(A1: G10) | |||||||
=(A1: G10) | |||||||
= (A1: G10) | |||||||
= (A1: G10) | |||||||
= (A5;A1:G10;1) | |||||||
=(A1: G10) | |||||||
=(A1: G10) |
5.2. 50 23 . 27 . . .
:
5.2
.. | = (2<=50; 2*23; 50*23+ +(2-50)*27) | ||
.. | = (9<=50; 3*23; 50*23+ +(3-50)*27) | ||
.. | = (11<=50; 11*23; 50*23+ +(11-50) *27) | ||
: | = (2:11) | ||
/: | = (2:11) | ||
/: | (2:11) |
5.3. , . 5.1.
|
|
:
1. , ( ), 2:I11 (. 5.1.).
. 5.1.
2.
/ .
3. (. 5.2.).
. 5.2.
4. ( - ) , :
- . , ;
- , , . (, , ), (. 5.3.).
. 5.3.
5. : , . . (. 5.4.).
. 5.4.
6. , . () , .
7. (.5.5.).
. 5.5.
( 1)
1. ?
2. , , ?
3. , .
QBASIC ( 2)
1. QBASIC?
2. QBASIC ?
3. ?
4. ? ?
5. LET?
6. INPUT PRINT?
7. ?
8. IF?
9. ?
10. ?
11. ?
MS Paint ( 3)
1. ()?
2. ?
3. ?
4. .
5. .
6. ?
7. ?
8. ?
|
|
9. ?
10. 600400 24- ?
11. Paint?
12. Paint.
13. Paint ( )?
14. Paint ?
15. Paint ?
16. Paint ?
17. Paint ?
18. Paint ?
19. Paint ()?
20. Paint?
21. Paint MS Windows?
22. .
MS Word ( 4)
1. ?
2. ?
3. MS Word?
4. ?
5. ?
6. ?
7. ?
8. ?
9. ?
10. ?
11. ?
12. ?
13. ?
14. ?
15. ?
16. ?
17. ?
18. ?
19. ?
20. ?
21. ?
22. ?
23. ?
24. ?
MS Excel ( 5)
1. ?
2. MS Excel?
3. ?
4 ?
5. ?
6. ? .
7. MS Excel?
8. ?
9. .
10. .
11. MS Excel.
12. ?
13. ?
14. MS Excel
14. MS Excel?
15. MS Excel?
16. , .