20050401
k
k
k
k
k
Sorting Spreadsheet Data
Spreadsheet data can be sorted column-wise or line-wise. You can select either ascending
sort or descending sort.
Important!
• Sorting can be performed only when the selected range of cells contains all constants.
u
To sort spreadsheet data
1. Select the series of cells in a single row or a single column that you want to sort.
• See “To select a range of cells” (page 9-3-4) for more information.
2. Use the function menu to select the type of sort you want to perform.
Ascending:
2
(EDIT)
6
(
g
)
2
(SRT
•
A)
Descending:
2
(EDIT)
6
(
g
)
3
(SRT
•
D)
• Selecting a sort type will sort the data.
k
k
k
k
k
Deleting and Inserting Cells
You can delete an individual cell, or an entire line or column of cells. You can also insert a
line or column of blank cells when you need to.
u
To delete an entire line or column of cells
1. Select one or more cells inside the line(s) or column(s) you want to delete.
9-4-19
Inputting and Editing Cell Data
# Data sorting is supported only for a single line
or a single column of data. Attempting to
perform a sort operation when multiple lines or
multiples columns are selected will cause a
“Range ERROR”.
# A “Syntax ERROR” will occur if the data you are
trying to sort contains a formula or text.
This cell selection can be used to
delete lines 1 and 2 or columns A
and B.
You could also select the entire line
or column to be deleted.
In this case, pressing
3
(DEL) in
step 2 below will instantly delete the
entire line or column, without
displaying the DEL submenu.
2. Press
3
(DEL) to display the DEL submenu.
Summary of Contents for fx-9860G AU PLUS
Page 1: ...fx 9860G AU User s Guide E http edu casio com ...
Page 2: ...Important Please keep your manual and all information handy for future reference ...
Page 27: ...20050401 1 1 Keys 1 1 1 Keys ...
Page 335: ...20050401 u u u u u Input Example u u u u u Results 6 5 25 Tests ...
Page 361: ...20050401 Calculation Result Output Example p F distribution probability 6 7 15 Distribution ...
Page 435: ...20050401 8 8 2 Program Library egcw w ww w ...
Page 437: ...20050401 8 8 4 Program Library Example 1 Example 2 fw baw bf w fw baw ca w ...
Page 439: ...20050401 8 8 6 Program Library wba wb w w d ...
Page 441: ...20050401 8 8 8 Program Library dw fcde wfcde wfcde fcde w daw w 20070101 ...
Page 443: ...20050401 8 8 10 Program Library b awaw bwaw aw x d w ...
Page 590: ...CASIO COMPUTER CO LTD 6 2 Hon machi 1 chome Shibuya ku Tokyo 151 8543 Japan SA0701 E ...