4.13 – : 2$ – 1
$! : # B# B ## , # .
4.14 – : 2$ – 2
\ A ,B ! , # , A :, ! ( 4.15).
' -2 %
4.15 – * ! # !
$ 4.3. * «< » (4.16).
$ – $ # ! #5:
5 ( *_= ;_Y_;-_ _ )
221
$ # B ! -– <5-+7>C5, D11<=20, B7=D7 . . \ A # B ! -
: |
# ! « » ( : !), # - |
! # !, A ! , |
( |
: ! – # ! « ») : ! « #- |
!_! A_».
4.16 – ) «< »
< ! " 4.5.
" ! 4.5. – < !
Œ |
!- |
|
|
/ |
- |
|
|
|
|
|
|
1 |
2 |
3 |
4 |
1. |
<1 |
+ |
J : < - |
|
|
|
% [ ] |
3. |
<2 |
+ |
|
4. |
<3 |
+ |
" # !" |
5. |
<4 |
+ |
& |
6. |
+4 |
+ |
J ! |
7. |
4 |
+ |
' . . |
8. |
D4 |
+ |
* |
9. |
E4 |
+ |
D |
10. |
F4 |
+ |
& |
11. |
F5 |
+ |
) #. |
12. |
G5 |
+ |
$ |
13. |
H4 |
+ |
* |
$B ! 4.5.
|
1 |
|
2 |
3 |
4 |
|
|
|
|
|
|
= ^::(H6:H10) |
|
|
35. |
|
J11 |
& ! |
# J11¤ B# % |
|
|
|
|
|
#- |
! ( |
|
|
|
|
|
I11 – |
4.1) ¤ % !- |
|
|
|
|
|
K11. |
&11 ¤ ¤ ! |
|
|
|
|
|
|
!. |
|
|
36. |
|
|
- |
(. $ ¤ . , ¤ '! |
|
|
|
|
|
- |
$ ! " ¤ |
|
|
|
|
|
'! < - |
¤ 5 |
|
|
|
|
|
. |
|
|
|
|
|
|
4.2.3 |
|
|
|
$ 4.1 ( «•- |
|
|
€7 € 4 #») 4.3 («$ |
|
! "») ! ! - |
, A B % ! ! % . + , ! ## # B # , B -. ( – %-B # # . J ,: , B -.
$ ! :
1. $ ! #, A . \ A : ! - , B , ! -.
2. + , ! : - . @ : . \ A
! |
: ! , Excel B |
% , A % - |
. |
|
$ . |
|
+ |
{=A1:B3*10} |
{=A1:B3*{10;10;10;10;10;10}}.
3.J % [Ctrl]+[Shift]+[Enter] ! !– ! B . J B , % Excel ! ! # !..
4.+ B , # A , - A , ! ! # . ! ! ! : .
5.@ ! # A ! -! . () B - .) " B # , -[Ctrl]+[Shift]+[Enter] .
6.( B A # #-# . ( B #! % # . ( B ## .
$ 4.4. – «• €7€ 4 #» ( 4.1), -G 3, # 5, 6, 7, 8.
< % ! " 4.6.
" ! 4.6. – < % ! 4.4
Œ |
! |
|
|
/ |
|
|
|
1 |
2 |
3 |
4 |
1. |
<1:H10 |
& ! |
# <1: H10¤ . & |
|
|
- |
¤ . 5 ¤ ! #- |
|
|
|
= 3 ¤ . & ¤ . . |
|
|
|
$ %- |
|
|
|
. |
2. |
H6:H9 |
'# - |
# |
|
|
|
% Delete. |
3. |
H6:H9 |
+ ! - |
! . |
|
|
|
+ : =D6:D9*100/C6:C9 ¤ |
|
|
|
[Ctrl]+[Shift]+[Enter] |
4. |
F6:F9 |
'# - |
# |
|
|
|
% Delete. |
5. |
F6:F9 |
|
! . |
|
|
|
+ : =D6:D9-C6:C9 ¤ - |
|
|
|
[Ctrl]+[Shift]+[Enter] |
!
+ |
- |
|
|
=H*=z(H6:H11>=I6:I11;H*=z(H6:H11=I6:I11;" ";H6:H11-I6:I11);" ") |
=H*=z(H6:H11<I6:I11;I6:I11-H6:H11;" ") |
=H*=z(H6:H11>=I6:I11;H*=z(H6:H11=I6:I11;" ";H6:H11-I6:I11);" ") |
=H*=z(H6:H11<I6:I11;I6:I11-H6:H11;" ") |
=H*=z(H6:H11>=I6:I11;H*=z(H6:H11=I6:I11;" ";H6:H11-I6:I11);" ") |
=H*=z(H6:H11<I6:I11;I6:I11-H6:H11;" ") |
=H*=z(H6:H11>=I6:I11;H*=z(H6:H11=I6:I11;" ";H6:H11-I6:I11);" ") |
=H*=z(H6:H11<I6:I11;I6:I11-H6:H11;" ") |
=H*=z(H6:H11>=I6:I11;H*=z(H6:H11=I6:I11;" ";H6:H11-I6:I11);" ") |
=H*=z(H6:H11<I6:I11;I6:I11-H6:H11;" ") |
=H*=z(H6:H11>=I6:I11;H*=z(H6:H11=I6:I11;" ";H6:H11-I6:I11);" ") |
=H*=z(H6:H11<I6:I11;I6:I11-H6:H11;" ") |
4.18 – ) !B .
$ 4.6. J # 12 # , % <3:D5.
!.
1. B , ! -– <7:D9.
2.¤ ! : ¤ ! 5 '9Kš ¤ 5 ¤ A3:D5 ¤ 5 ¤ ! [Ctrl]+[Shift]+[Enter] .! ( 4.19):
4.19 – $
4.2.4 &
J B # ! #- . $ ! #B # B ! . # % , ! A ! . _ # B #
228
. J B !-! -! .
J % # ! – ! !! ( 4.20):
# +-'! _2 [Enter]. ! #! _2.
4.20 – # ! !
\ A '! # ! , '! !- ! .
$ : ! # :
1.'! # ! , «/» «_».
2.B ! , «/» «_».
3. \ B ! # ! R
C.
\ B # . \ A
! # A !, Excel #-!: , % # : '!.
$ 4.7. – $ '! # # .
!. !5:!7 . . j . & & '! ! '!
'_ 5. $ 4.8. – $ # #-
&_ _1000 &_ _2000.
!. 5: 7 . . j . & & -'! &_ _1000 ;&5: 7 &_ _2000 5.
# , ! - B # B & . , A , B - ! ^ , ! ( -), ! # -.
B ! – , A - ! '! # ! #j: ?.
@ ! # B # -:
. . j . & -% [Shift] 5.
$ ! # -. . j . -'! 5.
4.2.5 ' * % . ' 2
@ # ! -. + -, , !# B . @ ! - ! Excel : %. ( B,# .
! ! % B -B# .
1.! # % B , !, % [Shift] ! # .
2.! # % % [Ctrl]! # , A - # , B B ! .
3.& # # ! # -
% .
Excel # : B !, # [\ ] ! .
B ! – ( B % , !# B !. \ A ! # -, Excel B ! !: