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

HP 620LX, 660LX Percentages guidelines, Custom number guidelines, Using functions and formulas, To quickly calculate averages, sums, or maximum/minimum values

1 172

Download 172 pages, 1.79 Mb

•To enter dates, use either a slash (/) or a hyphen (-), and specify months using either the full name or the three-letter abbreviation. When entering a year, Pocket Excel recognizes numbers between 1900 and 2078. See the following table for date and time examples.

Date	Times
8/3/96	3:00
Aug-96	3:00:00 pm
31-Aug-96	8/31/96 3:00 pm

•Enter a date and time in the same cell by typing a space between them.

•A date may appear differently from what you typed because Pocket Excel matches your entry to the closest default format. You can change the format.

Percentages guidelines

•To enter a percentage, type one of the following: the number followed by the percent sign (for example, type 5%), the number as a decimal (for example, 0.05), or the value as a formula (for example, =1/20). For the first method, Pocket Excel will automatically format the cell as a percentage. In the latter two cases, you must format the cell as a percentage.

Custom number guidelines

•If the Microsoft Excel file that youíve transferred to your Handheld PC contains a custom number format, that format may be displayed correctly in Pocket Excel even if there is not an exact format match. You will see Custom selected on the Number tab in the Format Cells dialog box.

Using functions and formulas

Pocket Excel supports about 100 commonly used Microsoft Excel functions. Pocket Excel Help provides specific details on working with functions, which often have several associated arguments. To see function descriptions, tap Insert Function on the Tools menu, and then tap the Help button.

To quickly calculate averages, sums, or maximum/minimum values

1.Select a range of cells.

2.Tap the AutoCalc menu on the status bar at the bottom of the screen.

WorkingwithHPrePalm-InstalledopPCApplicationsUserGuide-79

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