HP Glisten-AT&T manual Enter a simple formula, Enter a formula that contains a cell reference

Page 95

Enter a simple formula

Simple formulas contain operators and constants. Operators are signs or symbols that specify the type of calculation to perform in an expression. Constants are values that are not calculated and do not change. For example, the number 210 is a constant.

Here are some example formulas and what they do:

=128+345 adds 128 and 345.

=5^2 squares 5.

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

2.On the on-screen keyboard, tap = (the equal sign).

3.Enter the formula.

NOTE: To view additional characters on the on-screen keyboard, tap CAP or Shift.

4.On the keyboard, press Enter.

Enter a formula that contains a cell reference

A formula can contain a cell reference. This is the location of a cell on a worksheet. For example, cell B2 is the cell located at the intersection of column B and row 2. A formula that contains a reference to B2 performs a calculation that is based on the value in cell B2. If the value in B2 changes, the result calculated by the formula also changes.

Here are some example formulas with cell references and what they do:

=B2 uses the value in the cell B2.

=B2*C2 multiplies the value in cell B2 by the value in cell C2.

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

2.On the on-screen keyboard, tap = (an equal sign).

3.Enter the formula.

TIP: To include a cell reference, tap the cell you want to include in the formula. For example, to multiply the value in cell B2 by the value in cell C2, tap =, tap B2, tap *, and then tap C2. This will end up looking like this in the selected cell: =B2*C2.

4.On the keyboard, press Enter.

Enter a formula that contains a function

A formula can contain a function. A function is a prewritten formula that takes a value or values, performs an operation, and returns a value or values. Use functions to simplify and shorten formulas on a worksheet, especially those that perform lengthy or complex calculations.

Microsoft® Office Mobile 83

Image 95
Contents HP iPAQ Glisten Page Table of contents Send and receive email messages Customize SettingsSet up your email accounts Manage your HP iPAQ GlistenCreate and manage tasks Set alarm clock Manage your calendarSend and receive text messages and multimedia messages Manage your contactsUse productivity tools Take notesPage Browse the Internet 104 Use Wireless Manager 108Take photos and video Synchronize your HP iPAQ Glisten 119 Connect to a Wi-Fi network 109Use Bluetooth 112 Use AT&T Navigator and other GPS Applications 116Data connection types over the mobile phone network 128 Advanced settings for data connections 130Accessibility 137 Accessories 138 Tips and Tricks 141Index 170 Frequently asked questions 146Product Specifications 166 Troubleshoot your HP iPAQ Glisten 159Xii Welcome to your HP iPAQ Glisten Product registration Quickstart Important Product Information Whats in the box?Remove battery cover Set up your HP iPAQ GlistenInsert optional microSD card Insert SIM card and optional microSD cardInsert SIM card Replace battery cover Insert the batteryCharge your HP iPAQ Glisten Turn on your HP iPAQ Glisten Configure your HP iPAQ GlistenTransfer data from your old device optional Getting started with your HP iPAQ Glisten Earpiece Volume up/downPower/sleep On/off Stylus Start with the Today screen Page Numbers and symbols Using your keyboardIcon Status Status iconsPassword type list, select Simple PIN or Strong alphanumeric PIN setup and lock screenNew email message Missed call New voicemail New text message Answer a call Make and receive phone callsMake a call Redial a numberMake emergency calls Make calls using Speed DialPut a call on hold Use Call WaitingMake a call from a hyperlink phone number Make a call from ContactsCall voicemail Use the speakerphoneCall history Make calls using call historyDial international numbers Make a conference callChange the call history view Set up Call ForwardingSet up Call Barring View call detailsAll calls When roaming Off Set up Caller IDVoice Commander Enter owner information Customize SettingsName your HP iPAQ Glisten Customize ring tone and notification sounds Change regional settingsAdjust volume Set the timeOn the Alignment tab, tap Align Screen Press Start , and then tap Settings Sounds & NotificationsPress Start , and then tap Settings System Screen Text Size Customize your screenCustomize your Today screen Change the power management settings Remove programs Press Start , tap Settings System Remove ProgramsReinstall programs PIN Security section, tap Change PIN Manage your HP iPAQ GlistenSecure your HP iPAQ Glisten Change the SIM PIN Personal Identification NumberLock the keyboard Lock your HP iPAQ Glisten using a PINFile Explorer To… Task ManagerSIM Manager Press Start , and then tap Settings System AT&T Updates Backup your phone using Sprite BackupUpdate your phone using AT&T Updates Battery saving tips Then tap Settings System About Overview Set up your email accountsSet up IT managed corporate email Delete an account Set up personal emailOn the Messaging screen, tap Setup E-mail On the Settings found for screen, tap NextTap Menu New Send and receive email messagesSend an email message Deleted Items Drafts Inbox Outbox Sent ItemsOpen attachments Reply to or forward a messageAdd an attachment to a message Tap Menu Tools Options Signatures Respond to meeting requestsCreate or change a signature Keyboard shortcutsSend and receive text messages and multimedia messages Send a text message Press Start , and then tap E-mail Text/MMS Menu New MMS Send a multimedia messageTap Menu New Outlook Contact Manage your contactsAdd contacts Add an Outlook contactFind a contact Edit contact informationDelete a contact Create and assign a categoryTap Menu Send Text Message Send a text message to a contactSend an email to a contact Assign a ring tone to a contact Send a contacts information as a vCardAdd a contact picture Tap E-mail Group or Messaging Group Create email and messaging groupsContact list tips Set alarm clock Turn off alarm Tap Dismiss Turn on snooze To disable an alarm Tap Menu New Appointment Manage your calendarSchedule an appointment Page View your appointments by category Tap Menu Tools Options Change your calendar view based on your work weekChange calendar options Tap Menu Delete Update an appointmentCancel an appointment Tap Status, and select Not Completed or Completed Create and manage tasksCreate a task Tap Menu New TaskCreate and manage tasks View your tasks by category Tap Menu Options Show the start and due dates in the task listMark a task as complete Overview Write a note Take notesCreate a voice note Create a copy of a note Copy and paste content between notesDelete notes Take notes during a callRename notes Open a file Use productivity toolsMicrosoft Office Mobile Work with Office Mobile DocumentsTap Menu File Save As Create a fileCreate a template Automatically save files on a storage card Create a document or workbook by using a templateSave a copy of a document or workbook Locate a file Set the default Word templateWork with Word Mobile Rename a fileFormat text in a document Open and view a Word documentMove or copy text in a document Create a list in a documentCheck spelling in a document Align text in a documentIndent paragraphs in a document Zoom in or out in a Word Mobile documentGet Started Set the default Excel templateWork with Excel Mobile OverviewEdit a value or text in a cell Enter and edit dataOpen and view an Excel spreadsheet Enter a value or text in a cellTap Menu Copy Copy and paste dataTap Menu Copy or Cut Insert rows Insert cellsTap Menu Insert Cells Format numbers and text Format DataInsert columns Delete cells, rows, or columnsFit rows and columns to data Adjust column widths and row heightsAdjust the view of the worksheet View the data you wantFilter data in a worksheet Zoom in or outHide and display rows or columns Go to a cell or regionAdd values automatically CalculateSort data in a worksheet Calculate values automaticallyEnter a formula that contains a function Enter a simple formulaEnter a formula that contains a cell reference Overview Work with chartsCreate a chart Change the chart type Add titles to a chartTap Menu Format Chart Add a legend to a chartDelete a worksheet Delete a chartWork with worksheets Insert a worksheetChange the slide show orientation Work with PowerPoint MobileSwitch to another worksheet Open and view a slide show presentationZoom in and out in a slide Set slide show playback optionsPress Start , tap Apps Adobe Reader LE OneNote MobileNavigate between slides Tap Menu Exit Tap Tools Go To Page NumberPress Start , tap Tools JetCet Print Tap Add Network Printer Print documents and information with JetCet PrintTap Menu Help About. To close JetCet Print Tap Menu Exit MSN MoneyPress Start , tap Tools JetCet Print Tap Menu Go to Press Start , tap Tools JetCet Print Tap Menu ToolsCamera capture modes Take photos and videoAdjust brightness, saturation, and sharpness Camera settingsBasic capture settings Set an effect Adjust white balanceSet the resolution Capture photos Capture videos Use Multimedia Message Use BluetoothView photos and videos Transfer your media filesTap Menu Open Folder HP Photosmart MobileAttach a voice note to a picture Tap Menu Print Print picturesView a slide show Email picturesUpload photos to Snapfish Associate a contact with a pictureAssign a picture to the Today screen background Tap Menu Tools Screen Saver Enhance documentsSet the slide show screen saver Tap Menu Tools Enhance DocumentTap Menu Organize Organize imagesCopy and paste an image View videosNavigate Browse the InternetInternet Explorer Add a web page to your Favorites list Tap Sign in to Windows Live Tap Accept Windows LiveOverview Sign in to Windows LiveSign in as a different user Tap Menu Account Options Switch Windows Live IDSearch for information Check your emailOption All Wi-Fi Bluetooth Phone Description Use Wireless ManagerConnect using AT&T Wi-Fi Connect to a Wi-Fi networkTap Menu Wi-Fi Settings Open Wi-Fi settingsConnect to a Wi-Fi network Manually connect to a Wi-Fi networkTap the Network Adapters tab Delete a Wi-Fi networkTap Menu Remove Settings Find your IP addressCreate a Bluetooth partnership Use BluetoothOpen Bluetooth settings Use a Bluetooth headsetAccept a Bluetooth partnership Delete a Bluetooth partnershipTap New Incoming Port or New Outgoing Port Change the display name of a Bluetooth partnershipConnect to a computer using Bluetooth Use your iPAQ as a wireless modem with BluetoothTurn off Bluetooth Use AT&T Navigator and other GPS Applications Login to AT&T NavigatorFind your initial position faster with GPS Data Get DirectionsGlobal Positioning System GPS on your HP iPAQ Glisten Identify the COM port for your GPS receiver Troubleshoot frequent GPS signal loss and interferencePress Start , tap Settings Connections GPS Data Synchronize your HP iPAQ Glisten Page Copy files between your HP iPAQ Glisten and computer Copy data from your previous device to your HP iPAQ Glisten Troubleshoot synchronization issuesPage Clear the Now Playing List Update the libraryListen to music and watch videos Windows Media PlayerTap Connect ArcSoft Streaming PlayerPress Start , tap Apps Streaming Player Tap Menu Open AT&T Music Mobile Video Hsdpa Data connection types over the mobile phone networkPage Change an intranet URL Advanced settings for data connectionsConnect to intranet URLs Tap Auto pick Set up an automatic choice for connectionsSet up a VPN server connection End a connection Tap Disconnect Remote Desktop MobilePress Start , tap Tools Remote Desktop Tap Menu New Folder Java ApplicationsPress Start , tap Tools Internet Sharing Use your HP iPAQ Glisten as a wireless modemConnect to a computer using the USB sync cable Click Start Control Panel Network Connections Under Network Tasks, click View Bluetooth network devicesTurn on T-Coil mode Hearing Aid Compliant AccessibilityTurn on TTY Mode Power and Synchronization Accessories139 Other accessories Start the Camera Connect to a wireless network using the Wi-Fi buttonTips and Tricks Lock the KeyboardUse the Lock Screen View your complete call history Use Voice Commander with a headsetQuick access from the Today screen Customize the Start menuAssign a ring tone to contact Add a photo to a contactToday screen status icons Add text quickly using My TextChange wallpaper Control music playbackApplications Frequently asked questionsWhat is About? What is Managed Programs?Managed Programs What is Domain Enroll? What is the Certificates Application?Page Audio and video How do I update the library in Windows Media Player?Why is my battery draining rapidly? BatteryHow long should it take to charge my battery? How can I conserve power when not using the phone?Press Start , and then tap Settings System Remove Programs How do I send a file using Bluetooth? BluetoothWhat Bluetooth profiles are supported by my device? Page What Storage Cards are compatible with my iPAQ? What Bluetooth Accessories are supported by my device?Compatibility Page Page Page Cannot use certain call functions. What should I do? What do I do if my device shows No Service?Connections What bands does my device support?Troubleshoot your HP iPAQ Glisten How can I improve the battery life on my iPAQ?Have trouble charging my battery. What should I do? Am unable to make or receive calls. How do I fix this? Why does the iPAQ sometimes drop calls?Connection Cannot hear calls clearly. How do I resolve this? Have trouble connecting to the Internet. What should I do?Cannot use certain call functions. What should I do? Synchronization Why do I hear noises in the background during a phone call?Which factors degrade the GPS signal and affect accuracy? Miscellaneous Why does the iPAQ seem slow sometimes?My iPAQ becomes very hot when I use it. What has happened? How do I reset my iPAQ?Page System specifications Product SpecificationsSystem specifications Physical specifications Supported frequency bands Operating environmentIndex Keyboard VPNSIM personal identification Number USB
Related manuals
Manual 6 pages 10.67 Kb Manual 38 pages 19.96 Kb

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.