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

Page 94
Image 94
HP Glisten-AT&T manual Sort data in a worksheet, Calculate values automatically, Add values automatically

Glisten-AT&T specifications

The HP Glisten, specifically designed for AT&T, is a smartphone that blends style, functionality, and performance. Launched to cater to a growing demand for smartphones that facilitate communication and entertainment, the Glisten stands out with its compact design and impressive feature set.

One of the main highlights of the HP Glisten is its vibrant display. The device boasts a 2.5-inch AMOLED touchscreen that provides sharp visuals and vibrant colors. This high-quality display enhances the user experience, making it ideal for browsing, watching videos, or playing games. The Glisten features a slide-out QWERTY keyboard, which appeals to users who prefer tactile feedback for typing messages and emails.

Under the hood, the HP Glisten is powered by the Windows Mobile operating system, offering users a familiar interface with access to Microsoft Office applications and various productivity tools. This OS also allows for seamless integration with Windows services, making it a desirable choice for business users. The device comes equipped with 256 MB of RAM and 512 MB of internal storage, expandable via microSD, providing ample space for apps and multimedia files.

Another defining characteristic of the HP Glisten is its connectivity options. With support for 3G networks, users can enjoy fast mobile data speeds that facilitate smoother web browsing and quick downloads. The phone also supports Wi-Fi connectivity, allowing users to connect to wireless networks for enhanced browsing or streaming experiences. Bluetooth support enables easy pairing with headphones, speakers, and other devices.

The Glisten's camera is a crucial feature, equipped with a 3.2-megapixel rear camera that captures decent pictures for casual use. While it may not rival higher-end smartphones in photography, it serves well for social media sharing and basic photography needs.

Battery life is another area where the HP Glisten performs admirably. With a robust battery, users can expect a full day of use on a single charge, allowing for uninterrupted communication and entertainment.

In conclusion, the HP Glisten for AT&T embodies a blend of functionality and design, making it a strong contender in the smartphone market. With its user-friendly interface, robust connectivity options, and practical features, it caters to both business and casual users looking for reliable performance within a compact device.