Here are some example formulas with functions and what they do:

=SUM(A:A) adds all numbers in column A.

=AVERAGE(A1:B4) averages all numbers in the range from cell A1 to cell B4.

1.Tap the cell in which you want to enter the formula.

2.Tap Menu > Insert > Function.

3.From the Function list, select the function you want, and then tap OK.

4.In the formula bar (fx), near the top of the screen, replace the text between the parentheses—for example, (number1,number2,…)—with the cell references, the numbers, and the operations that you want.

5.On the keyboard, press Enter.

Work with charts

Overview

Charts make it easy to see patterns and trends in data. For example, instead of analyzing several columns of worksheet numbers, you can see at a glance whether sales are decreasing or increasing over quarterly periods, or how the actual sales compare to the projected sales.

Create a chart

You can create a chart on its own sheet or as an embedded object on a worksheet.

1.Arrange the data that you want to plot in a chart.

2.Select the cells that contain the data that you want to use for the chart.

3.Tap Menu > Insert > Chart.

4.Follow the instructions to:

Select a chart type.

Confirm the data range.

Select the data layout.

Add labels to the chart.

Insert the chart as a new sheet or as an object on the current worksheet.

5.Tap Finish.

TIP: To return to a worksheet, tap View > Sheet, and then tap the worksheet name.

84 Chapter 16 Use productivity tools

Page 96
Image 96
HP Glisten-AT&T manual Work with charts, Overview, Create a chart

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.