Numbers
, : .
. numbers . numbers. Pages , .
?
(3, %) ?
?
?
, 240 3?
.
1. . numbers . numbers, File () -> Open
(), Numbers,
.
2. Window ().
(
).
3. . numbers. . Edit ()
-> (). . numbers. ,
Sheet (). , ,
<BackSpace>. . Edit () -> Past ().
. . numbers.
4. Pages. .
Pages Numbers, Dock.
5. . pages.
/numbers/examples/6.2.6.pages.
-634-
. 5.2.7.
, . 6.34. F6: F13 .
G6:G13 ; , ( ), .
16 .
.
1. . numbers. .
, (. . 6.34).
2. F6 : =SUM(6:6), ,
Function (), Sum ().
. ,
! <Retum>.
.
|
|
|
3. G6. More Functions... ( ...)
-635-
:
Insert Function ( ) Logical (), if (), Insert (). condition () F6>=$C$3, [if-true] (-) , a [if-false] (-) . c : =IF (6>=$$3;""; " ''). <Return>.
!
4. G6 , .
5. 6. , Statistical
(), COUNTIF (). :
COUNTIF(G6:G13; ''''). , <Retum>.
6. , . 6.34. .
: /numbers/examples/6.2.7.numbers.
1
G6:G13 . , , , 4 5.
IF () : AND ( ) OR ( ).
: / umbers/work/6.2.7.n umber s.
2
, . 6.35.
G6:G13 .
6:13 .
D16:D19 .
-636-
|
G6:G13 average (), :
|
6:13 IF (). , . . , IF () ( ).
D16:D19 COUNTIF (), 6:13.
/numbers/work/6.2.7.numbers.
:
-637-
. 5.2.8.
1
(. 6.36).
.
: 456, 545, 402.
, .
.
|
|
|
1. Numbers. - -
. .
. (. . 6.36).
2. ( ) , SUM ().
3. ( ) ( ),
<Command>.
4. , Charts () ,
( . 6.36 ).
5. . 6.37,
-638-
Numbers , . , , . 6.37. , :
6. Chart () Series ()
:
, Data Point Setting (
) Show Pie Values as Percentages ( );
,
<Shift>, Explode () ;
Rotation Angle ( );
, Shadow () Group
().
7. ( ).
: , ,
, , Add Row Below
( ). ,
.
8. : 456, 545, 402.
,
.
9. . numbers.
: /numbers/examples/6.2.8.numbers.
-639-
2
, (. 6.38).
1. . numbers , :
. .
(. 6.38).
2. ( A1:D4). , Chart
() , .
-640-
3. Chart () .
3D Scene ( ). , . 6.38, :
Axis (). X-Axis (
X) Show Gridlines ( ). Y Value
Axis Format ( ) : Minimum ()
0, Maximum () 5 Steps () 5.
Series (). Data Point
Settings ( ) Show Value ( ).
4. . : /numbers/examples/6.2.8.numbers.
|
|
|
-641-
-642-
(. 6.40).
: /numbers/work/6.2.8.numbers.
-643-
. 5.2.8.
1
= 32 x [-5;5] = 0,5. , (. 6.41).
. :
Times New Roman;
;
18 pt;
.
.
.
. X 1, Y 10. . :
;
;
l pt.
-644-
.
1. . numbers , -
. .
2. . .
3. [-5;5], ,
xl =5. 2 5.
4. , () 0,5, :
=2+0,5. ( =
5), . . 22. !
5. = 3x2, 2
: =3*22. !
6. 1:22, , Charts ()
, :
7. , , .
, Chart ()
.
8. Show Title ( ).
-645-
chart. . <Retum>. (. . 5.82), , .
9. Show Legend ( ).
10. Axis () :
, Show Y-Axis ( -Y) Show X-Axis
( -), X-Axis, Y-Axis, & Borders (-, -Y );
, Show Gridlines
( ), X-Axis ( X) Y-Axis ( Y).
11. .
, . Value Axis Format
( ) : X: Minimum () 5, Maximum
() 5, Steps () 5; Y: Minimum () 0, Maximum () 80, Steps
() 8.
|
|
|
12. ,
Fill () .
13. ,
. , Series
() Data Point Symbol ( ) .
, , ,
.
14. . :
/numbers/examples/6.2.9.numbers.
2
= sin(x) [0;2] = /8. , (. 6.42):
1. y=sin(x). .
2. .
-646-
3. X 0 7 1, Y -1 1 0,2.
4. .
5. .
. . .
1. . numbers, -
. sin(x).
2. 2 0.
3. 3 : =A2+PI () /8. Numbers PI ()
. Insert Function (
), , , :
Numeric (). !
4. 2,
6,28 ( 18).
5. 2:18, , Cells ()
Decimals () 2.
.
6. 2 : =SIN(2). sin Insert Function (
) Trigonometric ().
-647-
.
7. ! : /numbers/examples/6.2.9.numbers.
1
= 3+2 [-3;3] = 0,2.
2
= cosfxj [0;2] = /8.
: /numibers/work/6.2.9.numbers.
-648-
