Symbol Technologies MC9000-G Tips for Working in Pocket Excel

MC9000-G with Windows® Mobile 2003 Software for Pocket PCs PRG

7-26

Tips for Working in Pocket Excel

When working in large worksheets in Pocket Excel:

• View in full-screen mode to see as much of the worksheet as possible. Tap View - Full

Screen. To exit full-screen mode, tap Restore.

• Show and hide window elements. Tap View, then the elements you want to show or hide.

• Freeze panes on a worksheet. First select the cell where you want to freeze panes. Tap View

- Freeze Panes. You may want to freeze the top and leftmost panes in a worksheet to keep

row and column labels visible as you scroll through a sheet.

• Split panes to view different areas of a large worksheet. Tap View - Split. Drag the split bar

to where you want it. To remove the split, tap View - Remove Split.

• Show and hide rows and columns. To hide a row or column, select a cell in that row or

column. Tap Format - Row or Column - Hide. To show a hidden row or column, tap Tools - Go

To, then type a reference that is in the hidden row or column. Tap Format - Row or Column -

Unhide.

For more information on using Pocket Excel, tap Start - Help.

Contents

Main Page Page Page Contents About This Guide Chapter 1. Getting Started Chapter 2. Operating Chapter 3. Settings Page Chapter 4. Communications Chapter 5. Spectrum24 Configuration Chapter 6. AirBEAM Smart Chapter 7. Applications Page Chapter 8. Accessories Chapter 9. Software Installation on Development PC Chapter 10. Configuring the Mobile Computer Chapter 11. Maintenance & Troubleshooting Appendix A. Block Recognizer Appendix B. Demo Program Appendix C. ImagerSample Appendix D. Specifications Page Page Page Page Chapter Descriptions Notational Conventions Related Documents and Software Service Information Symbol Support Center Page Page Page Page Getting Started Page Figure 1-1. MC9000-G Unpacking the Mobile Computer Accessories Getting Started Installing and Removing the Main Battery Installing the Main Battery Figure 1-2. Installing the Main Battery Removing the Main Battery Figure 1-3. Removing the Main Battery Charging the Battery Charging the Main Battery and Memory Backup Battery Charging the Main Battery Charging Spare Batteries Table 1-1. Mobile Computer LED Charge Indicators Stylus Figure 1-4. Removing the Stylus Page Strap Lanyard Figure 1-5. Reposition the Strap Lanyard Starting the Mobile Computer Figure 1-6. Symbol Splash Screen Calibrating the Screen Figure 1-7. Align Screen Page Setting Time and Date Checking Battery Status Figure 1-12. Battery Status Screen Configuring the Mobile Computer Operating Page Page Keypads 43-Key Keypad Figure 2-1. 43-Key Keypad Table 2-1. 43-Key Descriptions Table 2-1. 43-Key Descriptions (Continued) 53-Key Keypad Figure 2-2. 53-Key Keypad Table 2-2. 53-Key Descriptions Table 2-2. 53-Key Descriptions (Continued) 3270 Emulator Keypad Figure 2-3. 3270 Emulator Keypad Table 2-3. 3270 Emulator Descriptions Table 2-3. 3270 Emulator Descriptions (Continued) 5250 Emulator Keypad Figure 2-4. 5250 Emulator Keypad Table 2-4. 5250 Emulator Descriptions Table 2-4. 5250 Emulator Descriptions (Continued) VT Emulator Keypad Figure 2-5. VT Emulator Keypad Table 2-5. VT Emulator Descriptions Table 2-5. VT Emulator Descriptions (Continued) Keypad Special Functions Note Table 2-6. Keypad Special Functions Using the Power Button Page Today Screen Figure 2-7. Today Screen Using the Navigation Bar and Command Bar Figure 2-8. Screen Navigation Status Icons Table 2-7. Status Icons Speaker Icon Figure 2-9. Volume Dialog Box Battery Icon Figure 2-10. Battery Status Dialog Box Page Time Icon Page Page Selecting Programs Figure 2-17. Start Menu Using Pop-up Menus Figure 2-18. Pop-up Menu Notifications Entering Information Entering Information Using the Input Panel Page Page Writing on the Screen Page Figure 2-26. Writing on the Screen Figure 2-27. Alternate List Writing Tips Selecting Text Selecting Writing Drawing on the Screen Figure 2-28. Drawing on the Screen Selecting a Drawing Recording a Message Figure 2-29. Recording Screen Using My Text Figure 2-30. Using My Text Entering Information Using Keypads Entering Data Finding Information Figure 2-31. File Explorer Data Capture Laser Scanning Figure 2-32. Laser Aiming Pattern Imaging Aiming the Imager Scanning Considerations Scanning Bar Codes Figure 2-33. Bar Code Centered in Aiming Pattern Figure 2-34. Bar Code Not Centered in Aiming Pattern Scanning Tips Scan LED Indicator Table 2-8. Scan LED Indicators Resetting the Mobile Computer Performing a Warm Boot Performing a Cold Boot Page Settings Page Page Page Adjusting Settings Personal Tab Figure 3-1. Settings - Personal Tab Table 3-1. Personal Tab Applications Table 3-1. Personal Tab Applications (Continued) System Tab Table 3-2. System Tab Applications (Continued) Connections Tab Buttons Program Buttons Up/Down Control Figure 3-4. Buttons Window - Up/Down Control Tab Input Input Method Figure 3-5. Input Window - Input Method Tab Page Page Menus Start Menu Figure 3-8. Menus Window - Start Menu Tab New Menu Figure 3-9. Menus Window - New Menu Tab Owner Information Identification Figure 3-10. Owner Information Window - Identification Tab Notes Figure 3-11. Owner Information Window - Notes Tab Page Passwords Password Figure 3-13. Password Window - Password Tab Page Page Sounds & Notifications Volume Figure 3-16. Sounds & Notifications Window - Volume Tab Notifications Figure 3-17. Sounds & Notifications Window - Notifications Tab Today Appearance Figure 3-18. Today Window - Appearance Tab Items Figure 3-19. Today Window - Items Tab About Versio n Figure 3-20. About Window - Version Tab Device ID Figure 3-21. About Window - Device ID Tab Page Backlight Battery Power Figure 3-23. Backlight Window - Battery Power Tab To change screen brightness level, see Brightness on page 3-32. Table 3-4. Battery Power Backlight Settings Note External Power Figure 3-24. Backlight Window - External Power Tab 2. Make the desired selections. See Table 3-5 for backlight settings. 3. Tap ok. Table 3-5. External Power Backlight Settings Brightness Figure 3-25. Backlight Window - Brightness Tab Certificates Personal Figure 3-26. Certificates Window - Personal Tab Root Figure 3-27. Certificates Window - Root Tab Clock Time Figure 3-28. Clock Window - Time Tab Figure 3-29. Calendar Figure 3-30. Time and Next Appointment Message Alarms Figure 3-33. Alarm Clock Setting Window Page Memory Main Figure 3-35. Memory Window - Main Tab Storage Card Figure 3-36. Memory Window - Storage Card Tab Running Programs Figure 3-37. Memory Window - Running Programs Tab Power Battery Figure 3-38. Power Window - Battery Tab Wireless Figure 3-39. Power Window - Wireless Tab Advanced Figure 3-40. Power Window - Advanced Tab Optimizing Battery Life Page Regional Settings Figure 3-41. Regional Settings Window - Region Tab Page Page Remove Programs Figure 3-46. Remove Programs Window Screen Figure 3-47. Screen Window Symbol Settings Wakeups Figure 3-48. Symbol Settings Window - Wakeups Tab Table 3-6. Wakeup Conditions System 2. In the System tab you can view the system data listed in Table 3-7. Figure 3-49. Symbol Setting Window - System Tab Table 3-7. System Tab Data Table 3-6. Wakeup Conditions (Continued) Table 3-7. System Tab Data Page Connections Wireless Ethernet Figure 3-51. Configure Network Adapters Window Page Page Communications Page Installing Communication Software Installing ActiveSync Setting up a Partnership Page Page Page Page Serial Communication Setup Setting Up a Connection on the Mobile Computer Figure 4-8. ActiveSync Window Page Setting Up a Connection on the Host Computer Figure 4-11. ActiveSync - Not Connected Figure 4-12. Connection Settings Window Ethernet Communication Setup Installing MobileDox Cradle Manager Installing eConnect Figure 4-13. Settings Windows Host Computer Configuration DHCP Server Configuration Cradle Configuration Page Modifying Cradle Settings Figure 4-15. Cradle Settings Window - General Settings Tab 5. Use the TPC/IP Settings tab to modify the DNS and WINS identification settings of the cradle. Figure 4-16. Cradle Settings Window - TCP/IP Settings Tab Figure 4-17. Cradle Settings Window - Port Settings Tab Using ActiveSync Connecting to the Internet on a Wireless Network Figure 4-18. Mobile Companion Menu Page Page Page Figure 4-26. Adapters Message Window Page Spectrum24 Configuration Page Mobile Companion Figure 5-1. Mobile Companion Menu When the menu opens, select Status, WLAN Profiles, Find WLANs or Options from menu. Table 5-1. Mobile Companion Menu Descriptions Finding WLANs Figure 5-2. Available WLAN Networks Table 5-1. Mobile Companion Menu Descriptions (Continued) Figure 5-3. Mode Tab Figure 5-4. Encryption Tab Page Figure 5-5. Mobile Companion - IP Config Tab (DHCP) Figure 5-6. Mobile Companion - IP Config Tab (Static) Figure 5-7. Mobile Companion - Power Tab Status Figure 5-8. Mobile Companion - Signal Tab Figure 5-9. Mobile Companion - Info Tab Figure 5-10. Mobile Companion - IP Status Tab Page Figure 5-11. Mobile Companion - Ping Tab Figure 5-12. Mobile Companion - APs Tab Figure 5-13. Mobile Companion - Peers Tab Setting Options Figure 5-14. Mobile Companion - Option Settings Figure 5-15. Mobile Companion - Change Password Changing Profiles Figure 5-16. Mobile Companion - WLAN Profiles Page Configuring the Radio Using a Registration File Sample Spectrum24DS .Reg File Page Page Page Page Page AirBEAM Smart Page AirBEAM Package Builder AirBEAM Smart Client AirBEAM License Configuring the AirBEAM Smart Client Figure 6-1. AirBEAM Configuration Window Packages(1) Tab Packages(2) Tab Server Tab Misc(1) Tab Misc(2) Tab This tab is used to configure various miscellaneous features. Misc(3) Tab Synchronizing with the Server Manual Synchronization Page AirBEAM Staging Page Applications Page Page Calendar Figure 7-1. Calendar Application Creating Appointments Figure 7-2. Entering an Appointment Figure 7-3. Appointment Summary Screen Creating Meeting Requests Contacts Figure 7-4. Contact Application Figure 7-5. Creating a Contact Figure 7-6. Contacts Summary Screen Task s Figure 7-7. Task Application Figure 7-8. Creating a Task When you tap a task in the task list, a summary screen appears. To change the task, tap Edit. Figure 7-9. Task Summary Screen Notes Figure 7-10. Notes Application Figure 7-11. Creating a Note Inbox Synchronizing E-mail Messages Connecting Directly to an E-mail Server Setting Up an E-mail Service Using the Message List Figure 7-12. Inbox Application Figure 7-13. Viewing a Message Creating E-mail Messages Figure 7-14. Creating a Message Managing E-mail Messages and Folders Folder Behavior with ActiveSync and Direct Connection to Server Pocket Word Figure 7-15. Using Pocket Word Typing Mode Figure 7-16. Formatting Text Writing Mode Figure 7-17. Writing on the Screen in Pocket Word Drawing Mode Figure 7-18. Drawing on the Screen in Pocket Word Recording Mode Pocket Excel Figure 7-19. Using Pocket Excel Tips for Working in Pocket Excel MSN Messenger Setting Up An Account Working with Contacts Figure 7-20. MSN Messenger Contacts Chatting with Contacts Figure 7-21. Sending a Message Page Windows Media Player Figure 7-23. Using Windows Media Player Microsoft Reader Getting Books on the Device Using the Library Reading a Book Using Reader Features Removing a Book Pocket Internet Explorer Mobile Favorites Favorite Links Creating Mobile Favorites Saving Memory on the Mobile Computer Using AvantGo Channels Using Pocket Internet Explorer Figure 7-24. Pocket Internet Explorer Figure 7-25. Mobile Favorites Browsing the Web Pictures Copy Pictures to the Device Edit Pictures Send Pictures Set Picture as Background View Slideshow of Pictures Page Accessories Page Keypads Cradles Miscellaneous Snap-on Modules Keypads Replacing the Keypad Figure 8-1. Removing the Keypad Page Multi Media Card (MMC) / Secure Device (SD) Card Figure 8-3. Inserting the MMC/SD Page Single Slot Serial/USB Cradle Figure 8-4. Single Slot Serial/USB Cradle Figure 8-5. Single Slot Cradle Power/Serial/USB Connections Battery Charging Indicators Table 8-1. Spare Battery LED Charging Indicators Four Slot Ethernet Cradle Figure 8-6. Four Slot Ethernet Cradle Figure 8-7. Four Slot Ethernet Cradle Power Connection Page Page Figure 8-9. Four Slot Charge Only Cradle Power Connection Four Slot Spare Battery Charger Figure 8-10. Four Slot Spare Battery Charger Figure 8-11. Four Slot Spare Battery Charger Power Connection Spare Battery Charging with the Four Slot Spare Battery Charger Table 8-2. Spare Battery LED Charging Indicators Magnetic Stripe Reader Figure 8-12. Magnetic Stripe Reader Table 8-2. Spare Battery LED Charging Indicators (Continued) Attaching and Removing Figure 8-13. Attaching the MSR Figure 8-14. MSR Power Connection Figure 8-15. MSR Serial/USB Connection Battery Charging Indicators Serial/USB Connection Using the MSR Page Cable Adapter Module Figure 8-17. Cable Adapter Module Attaching and Removing Figure 8-18. Attaching the CAM Figure 8-19. CAM Power Connection Figure 8-20. CAM Serial Connection Serial/USB Connection Universal Battery Charger (UBC) Adapter Figure 8-21. UBC Adapter Inserting and Removing a Battery Page The battery usually charges in three hours. Figure 8-23. UBC Adapter LEDs Table 8-3. UBC Adapter Charge LED Status Indications Wall Mounting Bracket and Shelf Slide Installing the Wall Mount Bracket Figure 8-26. Wall Mounting Bracket Mounting Screws Attaching the Shelf Slide to the Wall Mount Bracket One Single Slot Cradle/Four Slot Battery Charger Figure 8-27. Attaching One Shelf Slide Two Single Slot Cradles/Four Slot Battery Chargers Figure 8-28. Attaching Two Shelf Slides Four Slot Cradle Installing the Cradle/Charger on the Bracket Page Page Software Installation on Development PC Page Required System Configurations SMDK for eVC4 SMDK for eVC4 Contents and Locations Table 9-1. SMDK for eVC4 Contents and Locations SMDK for .NET SMDK for .NET Contents and Locations DCP for MC9000w Table 9-2. SMDK for .NET Contents and Location DCP for MC9000w Contents and Locations Installing Other Development Software Table 9-3. DCP Contents and Locations Configuring the Mobile Computer Page Page Page The following table lists the components of the TCM window. Table 10-1. TCM Components Table 10-1. TCM Components (Continued) Defining Script Properties Figure 10-2. Script Properties Window - Partition Data Tab Figure 10-3. Script Properties Window - Options Tab Creating the Script for the Hex Image Page Building the Image Figure 10-5. Configure Build Window Figure 10-6. Build ESSID Partition Window Sending the Hex Image Figure 10-7. Initial Program Loader (IPL) Menu Table 10-2. IPL Menu Partitions Table 10-2. IPL Menu Partitions (Continued) Figure 10-8. Select Transport Menu Table 10-2. IPL Menu Partitions (Continued) Figure 10-9. Baud Rate Menu Figure 10-10. Address Configuration Menu Figure 10-11. Download File? Menu Figure 10-12. Parameters Screen Figure 10-13. Downloading Screen Figure 10-14. Load Terminal Window - Serial and Ethernet Tabs Page TCM Error Messages Table 10-3. TCM Error Messages Table 10-3. TCM Error Messages (Continued) IPL Error Detection Figure 10-15. IPL Error Screen Table 10-4. IPL Errors Page Table 10-4. IPL Errors (Continued) Creating a Splash Screen Splash Screen Format Table 10-5. Splash Screen Format Flash Storage FFS Partitions Working with FFS Partitions RegMerge.dll CopyFiles Non-FFS Partitions Downloading Partitions to the Terminal IPL Partition Update vs. File Update Upgrade Requirements Page Maintenance & Troubleshooting Page Maintaining the Mobile Computer Troubleshooting Mobile Computer Table 11-1. Troubleshooting the Mobile Computer Page Table 11-1. Troubleshooting the Mobile Computer (Continued) Four Slot Charge Only Cradle Table 11-2. Troubleshooting the Four Slot Charge Only Cradle Four Slot Ethernet Cradle Table 11-3. Troubleshooting the Four Slot Ethernet Cradle Table 11-3. Troubleshooting the Four Slot Ethernet Cradle (Continued) Four Slot Spare Battery Charger Single Slot Serial/USB Cradle Table 11-4. Troubleshooting The Four Slot Spare Battery Charger Table 11-5. Troubleshooting the Single Slot Serial/USB Cradle Table 11-5. Troubleshooting the Single Slot Serial/USB Cradle (Continued) Cable Adapter Module Magnetic Stripe Reader Table 11-6. Troubleshooting The Cable Adapter Module Table 11-7. Troubleshooting the Magnetic Stripe Reader Table 11-7. Troubleshooting the Magnetic Stripe Reader (Continued) Page Page Page Figure A-1. Using Block Recognizer Page Demo Program Page Page Page SelfTest Notify Figure B-5. Notify Window Page Display Figure B-7. DisplayTest Window Page MSR 9000 Figure B-9. MSR 9000 Swipe Card Window Page MSR Cameo Figure B-11. MSR Cameo Swipe Card Window Figure B-12. MSR Cameo Data Window Printing Figure B-13. BasicPrint v1.0 Window Scan Figure B-14. ScanSamp2 Example Window Scanning Data Fields Scanning Options Files Figure B-15. InkWiz Example Window Sounds Page Images Figure B-17. ImageViewer Example Window Table B-2. ImageViewer Toolbar Table B-2. ImageViewer Toolbar (Continued) Ctl Panel Page Page Page Page Page Page Page Page Scanner Settings Figure B-32. Scanner Settings Window PC Link Page Page ImagerSample Page Launching ImagerSample Figure C-1. ImagerSample Window Table C-1. ImagerSample Window Options Menus Use the menus to set options and save, capture and view images. File Use the File menu to save, capture and view an image, or exit the ImagerSample application. Save As Capture Viewer Options Help Page Page Page Page Environment The following table summarizes the mobile computers intended operating environment. Table D-1. Technical Specifications Table D-1. Technical Specifications (Continued) Mobile Computer Pin-Outs Figure D-1. Pin Locations Table D-2. MC9000-G Pin-Outs Accessory CAM and MSR Pin-Outs Figure D-2. CAM and MSR Serial Connector Table D-3. CAM and MSR Serial Connector Pin-outs Page Page Page 43-Key Keypad Configuration Figure E-1. 43-Key Keypad Table E-1. 43-Key Keypad Functions Table E-2. 43-Key Keypad Mapping Page Page Page Page Page Page Page Page 53-Key Keypad Configuration Figure E-2. 53-Key Keypad Table E-3. 53-Key Keypad Functions Table E-4. 53-Key Keypad Mapping Page Page Page Page Page Page Page Page 3270 Emulator Configuration Figure E-3. 3270 Emulator Keypad Table E-5. 3270 Key Functions Table E-6. 3270 Emulator Keys Table E-7. 3270 Character Map Table E-6. 3270 Emulator Keys (Continued) Page Page Page Page 5250 Emulator Configuration Figure E-4. 5250 Emulator Keypad Table E-8. 5250 Key Functions Scroll Left Scroll Right Scroll Up Scroll Down Table E-9. 5250 Emulator Keys Table E-10. 5250 Character Map Table E-9. 5250 Emulator Keys (Continued) Page Page Page Page VT Emulator Configuration Figure E-5. VT Emulator Keypad Table E-11. VT Key Functions Scroll Left Scroll Right Scroll Up Scroll Down Table E-12. VT-100 Emulator Keys Table E-13. VT-220 Emulator Keys Table E-13. VT-220 Emulator Keys (Continued) Table E-14. VT/HP Character Map Table E-13. VT-220 Emulator Keys (Continued) Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Index Index-1 Numerics A B C D E F G H I K L N O P Q R S T U V W Page Tell Us What You Think...