Manuals / Brands / Communications / PDAs & Smartphones / HP / Communications / PDAs & Smartphones

HP 620LX, 660LX First Quarter, To enter a formula, Arithmetic operators, Comparison operators, =”Total sales for “&A1, Total Sales for First Quarter

1 172

Download 172 pages, 1.79 Mb

3. Tap the desired function. The result appears in the status bar.

In addition to functions, Pocket Excel supports formulas, so that you can calculate values and analyze worksheets. Specifically, you can perform operations on worksheet values by using one of three operators on elements of a formula:

•Arithmetic operators, such as addition, subtraction, division, multiplication, percent, and exponentiation, perform basic mathematical operations and produce numeric results.

•Comparison operators compare two values and produce the logical value TRUE or FALSE. Examples include =, >, < , >= , <=, < >.

•Text operators join two or more text values into a single combined text value. For example, if First Quarter 1996 is the text in cell A1, the formula, =”Total sales for “&A1, produces the text, Total Sales for First Quarter 1996.

Once you have entered a formula, the formula’s resulting value appears in the corresponding cell on the worksheet. When you select a cell containing a for- mula, the formula always appears in the formula bar.

To enter a formula

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

2.Type an equal sign (=) to activate the formula bar. (A formula must begin with an equal sign.)

3.Enter the formula using the following guidelines:

•Use parentheses to enclose ranges (which are part of formulas) and other function arguments. For example, (A1:B3) represents the cell references and (1,2,3) represents constant values in the formula, =AVERAGE(SUM(A1:B3),SUM(1,2,3)).

80-HPPalmtopPCUserGuide

Contents

HP 620LX/660LX PALMTOP USER GUIDE Notice Edition History HP Software Product License Agreement Page HP Shrinkwrap License Terms Page CONTENTS 4. Translating HP PIM Data Files 5. Working with Pre-InstalledApplications 6. Reference Index Page INTRODUCTION A NOTE ON MODELS ABOUT THIS GUIDE Chapter 1: A Closer Look at the HP Palmtop PC Chapter 2: Using the HP Palmtop PC the First Time Chapter 3: Working with the HP Palmtop PC Chapter 4: Translating HP PIM Data Files Chapter 5: Working with Pre-installedApplications Chapter 1 – A CLOSER LOOK AT THE HP PALMTOP PC External Features - Back view Page Page Chapter 2 – USING THE HP PALMTOP PC FOR THE FIRST TIME INSTALLING THE BATTERIES GETTING STARTED THE WELCOME WIZARD Setting the World Clock Setting the Time Zone Setting Time and Date PARTNERING WITH YOUR DESKTOP COMPUTER Installing Microsoft Windows CE Services !Note Chapter 3 – WORKING WITH THE HP PALMTOP PC GETTING STARTED WITH WINDOWS CE GETTING HELP ON-LINE USING AC POWER MANAGING BATTERY POWER Power Off Power Status Icons Other Warnings about Power Recharging Batteries Tips for Using Batteries Efficiently CUSTOMIZING YOUR HP PALMTOP PC Adjusting Volume Changing Sounds Changing the Background of the Windows CE Desktop Adjusting Brightness and Contrast Adjusting the Double-TapRate Adjusting the Keyboard Changing Owner Information Setting a Password all data Any data saved or changed since your last backup is permanently lost Adding and Removing Software PRINTING RESETTING TRANSFERRING FILES Sending Voice Recorder notes Migrating data ■From Windows CE 1.0 to Windows CE USING A PC CARD USING A PC CARD MODEM USING A COMPACTFLASH CARD SYNCHRONIZING DATA Syncronizing data using an infrared connection Resolving conflicts To manually resolve conflicting items BACKING UP AND RESTORING DATA Restoring Data using HP Data Backup Backup Tips: ■Mobile Devices Backup To back up data to the hard disk of your desktop computer To restore data from your desktop computer Using a PC Card Backing Up Data to a PC Card Restoring Data from a PC Card Using a CompactFlash Card Page Chapter 4 – TRANSLATING HP PIM DATA FILES INSTALLING THE HP PIM TRANSLATION UTILITY STARTING THE TRANSLATION TRANSLATING APPOINTMENT DATA TRANSLATING PHONE BOOK DATA Mapping Field Names Mapping a Name Adding a Mapping Changing a Mapping REVIEWING TRANSLATION STATUS Page Chapter 5 – WORKING WITH PRE-INSTALLEDAPPLICATIONS Quicken®ExpensAbleTM Fiscal ProTM Microsoft Voice Recorder bFAX ProTMFax Send/Receive Application Inbox bFIND Global Find Utility World Clock Calculator Other Possibilities: Sending and receiving information INFORMATION MANAGER FOR WINDOWS CE CALENDAR Tip Week view Month view Agenda View 6-monthCalendar Adding appointments and events to your schedule To add an appointment To add a full-dayevent Changing or deleting appointments and events To move an appointment to a different day or time To change the time duration of an appointment To change a full-dayevent To delete an appointment Printing appointments, events, and tasks To print appointments, events, and tasks CONTACTS To change the information that appears in the contact list Adding and changing contact information To create a new contact card Tips for adding information To modify a contact card To create a copy of a contact card To delete a contact card Finding contact information To find a contact To find specific information on a contact card Printing contact information To print contact information TASKS Sorting Tasks Adding and changing task information To create a new task To edit tasks in the task list To mark a task complete To permanently remove a task from the list To permanently remove all completed tasks from the list Working with reminders Printing a list of tasks MICROSOFT POCKET WORD Working with documents and workbooks Opening a document or workbook To open Pocket Word or Pocket Excel To open an existing document or workbook To create a new document or workbook To create a document or workbook from a sample Saving a document or workbook To save a document or worksheet To close a document or workbook Finding and replacing text or data Moving and copying information To move or copy a selection Fixing a mistake To undo the most recent action To undo the last Undo command Selecting text Formatting text To create a bulleted list Setting tabs To set paragraph indentation Working with fonts To add a font To set or change the default font in a document Using Outline view To switch to Outline view Working with headings and body text To display all headings and body text To display only headings Using the toolbar to move, expand, or collapse text Using symbols to expand or collapse text MICROSOFT POCKET EXCEL To automatically copy data To automatically enter a series Entering values To format a cell as text Formatting numbers To format a cell as a number Working with various number types Currency guidelines Dates and times guidelines Percentages guidelines Custom number guidelines Using functions and formulas To quickly calculate averages, sums, or maximum/minimum values Arithmetic operators Comparison operators First Quarter =”Total sales for “&A1 Total Sales for First Quarter Using references To reference another sheet in a formula Setting up a 3-Dreference To create a 3-Dreference in a formula Naming cells Cell naming guidelines To name a cell or range Managing worksheets To switch to another worksheet To rename a worksheet To add a worksheet To remove a worksheet To change the order of worksheets MICROSOFT POCKET POWERPOINT To create a custom title slide for your presentation To sort your slides To view your presentation notes To set show To do presentations QUICKEN EXPENSABLE FOR WINDOWS CE Starting ExpensAble for the first time Customizing how you work with ExpensAble Entering Expenses Starting a new expense report Creating a new envelope Editing envelope information Editing user information Entering expense transactions Entering data in the Expense Record Adding a memo Entering data about your guests Entering mileage expenses Entering an amount using foreign currency Entering cash advance transactions Entering full or partial reimbursements Splitting transactions Changing the Expense Types list Adding an expense type Editing and deleting expense types Changing the Payment Methods list Adding a payment method Editing and deleting payment methods Managing Envelopes, Folders and Files Do this Important: Tracking the status of your expense reports Changing the status of an envelope Summarizing expenses Setting up a new file Creating a file Entering company and user information Transferring ExpensAble Data FISCAL PRO™ MICROSOFT VOICE RECORDER BFAX™ PRO FAX SEND/RECEIVE APPLICATION Sending your fax Receiving faxes Adding recipients and documents to an existing fax Deleting recipients and documents from a fax Deleting faxes Frequently Asked Questions Can I send a handwritten note How can I send a recurring fax, such as a weekly time sheet or report Can I modify a document after I add it to an outgoing fax Can I modify a recipient after I add that person to an outgoing fax What is a “Dialing Location” and what would I use it for How do I send fax to another country Can I send a fax using a calling card When should I configure bFAX™ to use hardware flow control More information INBOX Setting up a mail service connection To set up the mail service connection Page To change a mail service connection Connecting to a service To connect What happens when you connect To disconnect from a service Choosing to work online or offline Viewing the message list Setting Inbox options To set or change options Retrieving messages from the server To copy a message to your palmtop PC To retrieve a full-textcopy of a message To move a message To unmark a message for moving or copying Reading messages To read a message Replying to and forwarding messages Sending messages To send a new message Working in the message list To clear messages from the Inbox folder To delete a message To unmark messages for deletion Creating and maintaining folders To create a folder To delete a folder Copying messages to and from your desktop computer To copy messages from Inbox to a Microsoft messaging program To copy messages from a Microsoft messaging program to Inbox POCKET INTERNET EXPLORER Browsing the Web To go to an address To search for an Internet site To open a page in another window Creating desktop shortcuts To create a desktop shortcut to the current page Saving Web pages To save a copy of the current page To view a saved Web page Browsing Web pages offline To store Web pages To browse stored Web pages Changing cache-sizeoptions To change the cache size To empty the cache now To empty the cache on exiting Customizing Pocket Internet Explorer Setting start and search pages To set a home or search page Changing Web page viewing options To change Web page viewing options Using cookies To enable custom viewing Setting security options To change security options Specifying proxy servers To specify a proxy server BFINDTM GLOBAL FIND UTILITY To select Search Locations To Edit or Delete Associations To Use “Search Completion” Scripts To Create Shortcuts for Searches and Results WORLD CLOCK Setting home and visiting cities To change your home or visiting city To add a city to the list Setting the date and time To set today’s date To set the current time Setting alarms To set an alarm CALCULATOR SYNCHRONIZATION WITH A DESKTOP COMPUTER Mobile Devices on your desktop computer Adding and removing software To copy a program to your palmtop PC To remove a program from your palmtop PC Backing up and restoring data Transferring files to and from your desktop Converting file types To specify how files are converted Converting Word files Converting Excel files CONNECTING TO AN ISP (INTERNET SERVICE PROVIDER) If you are going to be using email, you will require If you are going to be using the worldwide web, you might require To set up a Remote Networking Connection Page Setting Dialing Patterns and Dailing Locations To set up manual dialing: To set up Internet Mail (E-mailService) To set up www access (if my ISP uses a www proxy server) Chapter 6 – REFERENCE SAFETY, CARE, AND MAINTENANCE TIPS AND TROUBLESHOOTING …hide the taskbar …minimize a document or application ...check battery levels ...find out how much memory is available for storage and/or applications ...find out information about my unit like memory, operating system, and so on …increase the speed of data transfer to and from my desktop PC ...use Pocket Internet Explorer to FTP files ...shut down my palmtop PC using Windows CE ...upgrade the ROM and/or RAM ...determine which card my HP 620LX is addressing if both a PC Card and a ...my password does not work …the system does not respond appropriately to stylus taps …I get the message “Can’t find filename [or one of its components]” when double-tapan icon …I get the error message “Recycle Bin Maximum Size Reached.” ELECTROSTATIC DISCHARGE WARNING WARRANTY, SUPPORT AND SERVICE Consumer Transactions in Australia, New Zealand and the United Kingdom For Consumers in Australia For Consumers in New Zealand Customer Support Page INDEX