Palm 700wx - Treo Smartphone 60 MB, Инструкция по использованию

Страница: 159 / 288

S T A Y I N G P R O D U C T I V E
E X C E L M O B I L E
151
7
CH
AP
T
E
R
4 Check or uncheck the Ascending box to
indicate whether you want to sort in
ascending or descending order.
5 (Optional) Select the Then by lists, and
then select second and third level
sorting options.
6 Check or uncheck the Exclude header
row from sort box to indicate whether
you want to sort the header row.
7 Press OK .
Filtering info in a worksheet
1 Highlight the cells that contain the info
you want to filter.
2 Press Menu (right action key) and
select Tools > AutoFilter . A list appears
at the top of each related column.
3 Select one of the new lists, and then
select a filter. This hides all rows that do
not include the selected filter.
4 (Optional) Select the other lists, and
then select other filters.
Creating a chart
1 Open the workbook you want to create
a chart from.
2 Highlight the cells you want to include
in the chart.
3 Press Menu (right action key) and
select Insert > Chart .
4 Select the type of chart, and then press
Next (right action key).
5 Confirm the area you want the chart to
include, and then press
Next
(right action key).
6 Select the data layout, and then press
Next (right action key).
7 Check the boxes to indicate whether
the first row and column represent
labels.
DID YOU KNOW
?
You can also create custom
filters where you specify comparisons. Select
the
filter list, and then select Custom .
TIP
To display all rows again, select the filter
lists, and then select All . To turn off filtering,
press Menu and select Tools > AutoFilter
again.