. 5.1.13.
, . 6.18. . : /pages/tasks/6.1.14.pdf.
1. . pages .
.
2. 12x9, (. 6.18).
3.
, , . Inspector () Table (),
Table (), Edit Rows & Columns ( & )
Sort Descending ( ) (. 5.52).
4. 385
, ( ). Sort
Descending ( ) Edit Rows & Columns ( & ).
-606-
5. 4 383 208.
6. :
/pages/examples/6.1.14.pages.
7. . .
-607-
. 5.1.13.
, . 6.19; , , .
: /pages/tasks/6. 1.15.pdf.
1. Pages. . pages File () -> Open () <Command>+<0>. .
2. , 8 5 -.
(. 6.19). !
3. ,
( 5). Inspector () Table () Format (),
Quick Formula ( ) Average ().
3. :
=AVERAGE (2:4), , , ,
, ,
.
4. , ,
, . 4,
3,33333333. ,
5, Cell Format ( ) Number (),
Decimals () 1. 3,3.
|
|
|
5. , . .
, ( 2:4), , (D6),
-608-
. .
6. D6. , .
: =MIN (2: 4).
2, , 4. <Enter>. 2.
7. D7 : = (D2:D4), 8 :
= AVERAGE (5:5). 8 .
8. . :
/pages/examples/6.1.15. pages.
1
Quick Formula ( ), , . 5.57. : /pages/work/6.1.15. pages.
2
3x3, A1, B1, C1, 2 , . 5.58, (. . 5.58). : /pages/work/6.1.15.pages.
3
, 5 (. . 5.59). : /pages/work/6.1.15.pages.
-609-
. 5.1.14.
1
. . , . 6.20. : /pages/tasks/6. 1.16.pdf.
1. . pages . .
2. 6x3 : .
, , ( ).
3. 6 : =SUM(B2:B5). 2 : =2/$$6,
-610-
, .
4. .
Inspector () Table (), Format
(), Cell Format ( ) Percentage (),
, , Decimals (). !
5. Chart (), :
. 6.21. 6. Chart ():
:
Show Title ( ). . Show Legend ( ), , . 6.21.
|
|
|
7. . Series (), Data Point Settings
( ) Show Pie Values as Percentages (
) Show Series Name ( ).
8. , , Fill
() .
9. , ,
, <Shift>. Explode
() 5 %. , ,
15 %.
10. , , Shadow ()
Group ().
11. .
: /pages/examples/6.1.16.pages.
-611-
2
(. 6.22). : /pages/tasks/6. 1. 16.pdf.
1. . pages .
2. , (. 6.22).
:
3. . Axis (), X-Axis ( X) :
Show Category Labels ( ) : , , , ;
Show Category Title ( ) ;
Show Gridlines ( ), .
-612-
4. Y-Axis ( Y) Show Value Title ( ),
.
5. Value Axis Format ( ) :
Minimum () 0;
Maximum () 20; Steps () - 10.
6. ( . 6.22
), ,
Fill ().
7. , ,
( ),
Fonts () (. . 5.9).
8. 3D Scene (
-613-
), .
9. . : /pages/examples/6.1.16. pages.
. , (. 6.23). : /pages/tasks/6.1.16.pdf.
1. Line ():
2. , . 6.23,
Axis () X-Axis ( X) Vertical Labels ( ).
3. . 6.23, Series
() Data Point Settings ( ) Above Right (
) (2007-2008) Center ( ) (2008-2009).
|
|
|
4. Data
Point Symbol ( ) Symbol Fill ( ) Series ().
5. :
/pages/work/6. 1.16.pages.
-614-
-615-
