_______________..
__________________2013.
- :
6.030504
5.03050401
6-
㳿
____ ____ ________________ 20____
________________ ..
________________ ..
-
㳿
ֲ 1
1.
2. MS Excel.
2.1 ϳ ,
2.2 ᒺ
| ѳ | |||
2.3
____________________ __ . ________________
() ( )
___________________ _____ ..______________
() ( )
-
㳿
ֲ 2
1.
2. Access
2.1.
| / | ... | , | |||
| 28.08.1987 | 52 071 | ., . 36 | |||
| ³볿 | 14.12.1987 | ., . 81, | |||
| 14.03.1987 | 52 005 | , . . 52 |
2.2
2.3 ( )
____________________ _____ . _____________
() ( )
___________________ ___ .. ________________
() ( )
-
㳿
ֲ 3
1.
2. Excel.
2.1
| ֳ | ʳ | |||
| 1. | ||||
| 2. | 2,7 | |||
| 3. | 2,7 | |||
| 4. | 1,23 |
2.2 ϳ ()
|
|
|
2.3 ³ .
____________________ ______ . ____________
() ( )
___________________ _____ .. ______________
() ( )
-
㳿
ֲ 4
1.
2. ᒺ :
| ѳ | |||
2.2
2.3
____________________ ________ . __________
() ( )
___________________ ______ .. _____________
() ( )
-
㳿
ֲ 5
1.
2. . ϳ .
²̲ / 2000.
| ʳ. | |||
| 8.66 | |||
| 6.07 | |||
| ѳ | 8.23 | ||
| ϳ |
³ .
____________________ _______ . ___________
() ( )
___________________ ___ .. ___________
() ( )
-
㳿
ֲ 6
1.
2. .
2.1 . .
2.2 .
| V | |||||
| ̳ | |||||
____________________ __ . ________________
() ( )
___________________ _____ ..______________
() ( )
-
|
|
|
㳿
ֲ 7
2. 䳿 Excel
:
) =2*3+2
) =2*(3+2)
) =2*(3+2^2
) =2*3+2^2
2.2 ( ).
2.3. 10 2 3
____________________ _____ . _____________
() ( )
___________________ ___ .. ________________
() ( )
-
㳿
ֲ 8
1.
2. 䳿 Excel
2.1. 2, 3 4 10, 01.01.2011 . #:
) =2&3&4
) =3<2
) =C4+3+2
) =C(2:4)
( ).
2.2. 5 2, 3 4.
____________________ __ . ________________
() ( )
___________________ _____ ..______________
() ( )
-
㳿
ֲ 9
1.
2. 䳿 Excel
2.1. F6 =(F1: F5)+10. ̳ F1: F5 . F7:
) =(F1: F5)+10;
) =(F1: F6)+10;
) =(F1: F5);
) =(F1: F6).
2.2 ( )
____________________ _____ . _____________
() ( )
___________________ ___ .. ________________
() ( )
-
㳿
ֲ 10
1.
2. 䳿 Excel
z=ax2+by2 :
) ;
) -2 2;
)
| a= | ||||||||
| b= | z=ax2+by2 | |||||||
| -5 | -4 | -3 | -2 | -1 | ||||
| -5 | ||||||||
| -4 | ||||||||
| -3 | ||||||||
| -2 | ||||||||
| -1 | ||||||||
|
|
|
____________________ __ . ________________
() ( )
___________________ _____ ..______________
() ( )
-
㳿
ֲ 11
1.
2. 䳿 Excel
2.1. F6, =F1+F2+F3+F4+ F5-25. F1: F5:
) =F1+F2+#!+F3+F4-25
) =F1+F2+F3+F4+ F5-25
) = F1+F2+F4+ F5-25
) =F1+F2+#!+F3+F4
2.2 = 2+ cos(3 * 4) 5 2, 3 4.
____________________ _____ . _____________
() ( )
___________________ ___ .. ________________
() ( )
-
㳿
ֲ 12
1.
2. 䳿 Excel
2.1 ³ 10 , . ϳ :
) ;
) ;
) ;
) 5, 4, 3, 2,
| / | ... | . | . | |||||
| .. | ||||||||
| .. | ||||||||
| .. | ||||||||
| .. | ||||||||
| .. | ||||||||
| .. | ||||||||
| .. | ||||||||
| .. | ||||||||
| .. | ||||||||
| .. | ||||||||
____________________ __ . ________________
() ( )
___________________ _____ ..______________
() ( )
-
㳿
ֲ 13
1.
2. .
2.1 .
2.2 ϳ .
2.3
| ̳ | |||
| ʳ | ³ | ||
|
|
|
____________________ __ . ________________
() ( )
___________________ _____ ..______________
() ( )
-
㳿
ֲ 14
1.
2. . ϳ .
| ֳ | ʳ | |||
| 2,5 | ||||
| 1,8 | ||||
| 25,4 | ||||
| 12,3 | ||||
| 1,40 |
.
____________________ __ . ________________
() ( )
___________________ _____ ..______________
() ( )
-
㳿
ֲ 15
1.
2. . ϳ .
²̲ / 2000.
| ʳ. | |||
| 8.66 | |||
| 6.07 | |||
| ѳ | 8.23 | ||
| ϳ |
.
____________________ _____ . _____________
() ( )
___________________ ___ .. ________________
() ( )
-
㳿
ֲ 16
1.
2. .
2.1 ϳ .
2.2 ᒺ :
| .. | - | |||
| 245,25 | ||||
| . | 10,30 | |||
| . | . | 15,50 | ||
| . | . | 18,50 | ||
| . | 57,80 | |||
| 25,00 | ||||
2.3
____________________ __ . ________________
() ( )
___________________ _____ ..______________
() ( )
-
㳿
ֲ 17
1.
2. Excel.
2.1 ϳ .
²̲ / 2000.
| ʳ. | |||
| 8.66 | |||
| 6.07 | |||
| ѳ | 8.23 | ||
| ϳ |
2.2 .
____________________ _____ . _____________
() ( )
___________________ ___ .. ________________
() ( )
-
㳿
ֲ 18
|
|
|
2.1 ᒺ
2.2 ( ) ᒺ WordArt .
____________________ _____ . _____________
() ( )
___________________ ___ .. ________________
() ( )
-
㳿
ֲ 19
1.
2. Word.
2.1
2.2
| - | |||||
| - 1 | 0,5 | - 5 | 0,5 | (0,5 12,5) | - 1 | |
2.3 ³ .
____________________ __ . ________________
() ( )
___________________ _____ ..______________
() ( )
-
㳿
ֲ 20
1.
2.
2.1
2.2.
 |
8-!
, !
. 08.03.2013
____________________ _____ . _____________
() ( )
___________________ ___ .. ________________
() ( )
-
㳿
ֲ 21
1.
2. Word.
2.1.
| / | ... | , | |||
| 28.08.1987 | 52 071 | ., . 36 | |||
| ³볿 | 14.12.1987 | ., . 81, | |||
| 14.03.1987 | 52 005 | , . . 52 |
³ .
.
____________________ __ . ________________
() ( )
___________________ _____ ..______________
() ( )
-
㳿
ֲ 22
1.
2. Y= X2 -5 5
2.1
2.2 ϳ
____________________ _____ . _____________
() ( )
___________________ ___ .. ________________
() ( )
-
㳿
ֲ 23
1.
- ³ 10 , . ϳ :
) ;
) ;
) ;
| / | ... | . | . | |||||
| .. | ||||||||
| .. | ||||||||
| .. | ||||||||
| .. | ||||||||
| .. | ||||||||
| .. | ||||||||
| .. | ||||||||
| .. | ||||||||
| .. | ||||||||
| .. | ||||||||
____________________ __ . ________________
() ( )
___________________ _____ ..______________
() ( )
-
㳿
ֲ 24
1.
2. Excel
2.1 ϳ .
²̲ / 2000.
| ʳ. | |||
| 8.66 | |||
| 6.07 | |||
| ѳ | 8.23 | ||
| ϳ |
ϳ .
³ .
____________________ _____ . _____________
() ( )
___________________ ___ .. ________________
() ( )
-
㳿
ֲ 25
1.
2. Excel
2.1 ϳ .
²̲ / 2000.
| ʳ. | |||
| 8.66 | |||
| 6.07 | |||
| ѳ | 8.23 | ||
| ϳ |
2.2.ϳ .
2.3 ³
____________________ _____ . _____________
() ( )
___________________ ___ .. ________________
() ( )
| ֳ | ʳ | |||
| 2,5 | ||||
| 1,8 | ||||
| 25,4 | ||||
| 12,3 | ||||
| 1,40 |
| V | |||||
| ̳ | |||||
| ̳ | |||||||||
| ʳ | ³ | ||||||||
| .. | - | ||||||||
| 245,25 | 1226,25 | ||||||||
| . | 10,30 | ||||||||
| . | . | 15,50 | |||||||
| . | . | 18,50 | |||||||
| . | 57,80 | ||||||||
| 25,00 | |||||||||
| 372,35 | 940183,75 | ||||||||
