HP iPAQ Glisten-AT&T Calculate, TIP:, Sort by, Then by, Ascending, Ascending, AutoCalculate, Menu > Undo Sort, 1.Tap View > Toolbar, 1.Tap View > Status Bar

Sort data in a worksheet

You can sort data in ascending order (A-Z, or 0-9) or descending order (Z to A, or 9 to 0).

1.Select the range you want to sort.

2.Tap Menu > Tools > Sort.

3.In the Sort by list, select the first column you want to sort on.

By default, the Ascending check box is selected. This indicates that the column will be sorted in ascending order. If you want the column sorted in descending order, tap to clear the check box.

4.To sort on additional columns, select them in the Then by box, and then select or clear the Ascending check boxes.

5.Tap OK.

TIP: To undo a sort, tap Menu > Undo Sort.

Calculate

Calculate values automatically

You can quickly calculate the largest number, smallest number, average number, and sum of the numbers in a selected range of values. When you use this method, you preview the result only. The result is not added to the worksheet.

1.Tap View > Status Bar.

2.Select the range of values that you want to calculate.

The AutoCalculate area, on the right side of the status bar, contains a function and a value, for example: SUM=0.

3.Tap the AutoCalculate arrow and tap the type of calculation you want to perform. The result appears in the AutoCalculate area.

Add values automatically

You can quickly add values from a range of cells and include the result in the worksheet by using Autosum.

1.Tap View > Toolbar.

2.Tap the cell where you want to insert the sum of the selected values.

3.On the toolbar, tap Autosum (the ∑ symbol near the bottom of the screen). =SUM() appears in the input box at the top of the workbook.

4.Drag the stylus across the range of cells you want to add. The cells will not be highlighted. However, the cell range in =SUM() is updated.

5.On the keyboard, press Enter. The sum appears in the selected cell.

82 Chapter 16 Use productivity tools