Workbook Components

Chapter 7: Programs

7.11.7 Workbook Components

To better understand the components of a workbook, review the diagram below.

Columns

Address of selected text

Rows

Status bar

Toolbar

Menu bar

Entry bar

Cell

Selected cell

Formula drop-down menu Sheet1 drop-down menu

Figure 7.52 Excel Components

•If the toolbar is not visible, tap on the Show/Hide Toolbar icon .

Format

Align

Currency

Decimal

Style

Cells

Left Align

Right

Comma

Zoom

Centre

AutoSum

Style

Show/Hide Toolbar icon

Figure 7.53 Pocket Excel Toolbar

By default, a new workbook has three worksheets in it. Each worksheet has 256 columns and 16,384 rows.

7.11.8 Moving Between Worksheets

To move between worksheets:

•Tap on the Sheet1 drop-down menu, and choose a worksheet.

Psion Teklogix WORKABOUT PRO With Windows Mobile 2003 SE User Manual 223

Page 253

Image 253

Psion Teklogix 7525 user manual Workbook Components, Moving Between Worksheets

Contents

Workabout PRO Hand-Held Computer With Windows Mobile 2003 SE Page Copyright 2005 by Psion Teklogix Inc., Mississauga, Ontario Return-To-Factory Warranty Table of Contents Working With Windows Mobile 2003 SE Contents Connecting To a LAN With 802.11b Contents Contents Programs Contents Expansion Modules Contents Specifications Program License Agreements Device License Agreement License Agreement License Agreement License Agreement Upgrades and Recovery Media Device Page FCC Declaration of Conformity DoC Approvals and Safety Summary CE Marking Approvals And Safety SummaryTTE Directive 1999/5/EC FCC Information To Users For GSM/GPRS Users in North America Important Note Emissions Information For Canada LASER/LED Warnings Vorsicht Page Introduction Page About This Manual About This Manual Text Conventions FeaturesWorkabout PRO Models Text Conventions Processor Wireless CommunicationsOperating System Programming Environment Bar Code Applications Power ManagementExpansion Slots Other Expansion Modules Communication Accessories Power AccessoriesCarrying Accessories Environmental Standard Workabout PRO C Hand-Held Computer Workabout PRO C Workabout PRO S Hand-Held Computer Workabout PRO S Hand-Held Computer Regulatory Labels Regulatory Labels FCC Compliance Label Page Basic Checkout Page Charging The Battery Main BatteryBackup Battery Preparing The Workabout PRO For Operation Companion CD Switching The Unit Off SuspendTurning The Workabout PRO On and Off Connecting The Workabout PRO To a PC Warm ResetAligning Calibrating The Touchscreen Resetting The Workabout PRO Hand-Held Cold ResetTo execute a cold reset and access the BootLoader menu Getting to Know the Workabout PRO Page Front Of Workabout PRO C Features Of The Workabout PRO C Back Of Workabout PRO Features of the Workabout PRO S Features of the Workabout PRO SBatteries Removing And Installing The Battery Pack Battery SafetyRemoving The Battery Cover Installing The Battery Battery Swap Time Battery Swap TimeChargers And Docking Stations Switching On The Workabout PRO Switching The Hand-Held On And OffSwitching Off The Workabout PRO Suspend Switching The Hand-Held On And Off Workabout PRO C Keyboard Workabout PRO C Keyboard Activating Modifier Keys Modifier KeysModifier Keys Locking Modifier Keys KeysShift Key Arrow Keys Keypad Backlight Workabout PRO S Keyboard Workabout PRO S Keyboard Locking Modifier Keys Activating Modifier Keys Pg/Up And Pg/Dn Keys Alpha KeyCaps Key Ctrl And ALT Key Accessing Alpha Characters Accessing Alpha CharactersChoosing a Single Alpha Character Choosing Multiple Alpha Characters Creating Uppercase LettersCreating Uppercase Letters Display Adjusting The BacklightAligning Calibrating The Touchscreen Indicators IndicatorsLED Audio Indicators Audio IndicatorsCharge Status Workabout PRO LED Behaviour Monitoring The Battery And Maximizing Run Time Monitoring The Battery And Maximizing Run TimeStoring Batteries Uploading Data In a Docking Station Bluetooth RadioUploading Data In a Docking Station Inserting The Card SD/MMC Card-Adding MemorySD/MMC Card-Adding Memory Cleaning The Workabout PRO General MaintenanceGeneral Maintenance Caring For The Touchscreen Working with Windows Mobile 2003 SE4 Page Navigating In Windows Mobile 2003 SE And Applications Navigating Using a Touchscreen And Stylus Windows Mobile 2003 Navigation Bar Connectivity IndicatorStart Button Windows Mobile 2003 Navigation Bar Volume Control Today’s Date, Clock And AlarmToday’s Date, Clock And Alarm Clock Clock Screen Mail Notification Ownership InformationOwnership Information Creating a Task Task NotificationTask Notification Deleting a Task Editing a TaskMarking a Task As Completed Sorting Tasks Limiting The Tasks Displayed In The Task Screen Calendar Of Upcoming AppointmentsCalendar Of Upcoming Appointments Adding Reminders Creating And Editing AppointmentsCreating And Editing Appointments Using Categories Using CategoriesDeleting Appointments Start Menu Tap on Start, SettingsCustomizing The Start Menu Start Menu New Menu New Menu Customizing The New Menu Managing Files And FoldersCustomizing The New Menu Tap on Start, File Explorer Renaming a File Creating a New FolderCopying a File Creating a New Folder Deleting a File Using MenusMenu Bars Deleting a File Pop-Up Menus TaskbarPop-Up Menus Programs-Using Applications Programs-Using ApplicationsOpening An Application Minimizing An Application Settings SettingsClosing An Application Entering Text HelpHelp Transcriber Soft KeyboardSoft Keyboard Transcriber Editing Text Within The Transcriber Block Recognizer Block Recognizer And Letter RecognizerBlock Recognizer And Letter Recognizer 31 Letter Recognizer Letter RecognizerPage Connecting to a LAN with 802.11b Page Installing The 802.11b Radio Installing The 802.11b Radio Inserting a CF Card Connecting To a LAN Using An 802.11b Radio Mechanical Stopper Installed Entering New Settings Entering New Settings Authentication Settings Authentication Settings Deleting a Network Deleting a Network Settings Settings Settings Settings Personal Settings Personal SettingsButtons Icon One Shots 1 Up/Down ControlUp/Down Control OneShot LockOneShot/Lock Show Modifier Key State Recording And Saving a Macro Keyboard Macro KeysKeyboard Macro Keys Executing a Macro Unicode MappingDeleting a Macro Unicode Mapping Removing Unicode Values Adding And Changing Unicode Values Scancode Remapping Scancode Remapping Virtual Key, Function And Macro Adding a RemapChoose Virtual Key, Function or Macro Input Method Tab InputEditing a Scancode Remap Removing a Remap Letter Recognizer Options Keyboard OptionsInput Method Tab Transcriber Options 12 Letter Recognizer Quick Settings Inking Quick Settings Advanced Word CompletionWord Completion Options-Additional Choices MenusStart Menu Tab Options-Additional Choices New Menu Tab Owner InformationNew Menu Tab Password PasswordSound & Notifications Sounds Notifications Today ScreenAppearance Notifications Items System SettingsItems About Device AboutBacklight External Power Battery PowerBattery Power Intensity CertificatesIntensity Root Certificates Personal TabCertificates Memory Clock & AlarmsChoosing a Certificate Main Tab Running Programs Storage CardStorage Card Battery Tab Power IconWireless Tab Power Icon On External Power On Battery PowerAdvanced Tab Advanced Tab Battery Details Battery DetailsCard Slots Built-In Devices Regional SettingsBuilt-In Devices Remove Programs Tap Start, SettingsScreen Icon Remove Programs Scanner Settings Scanner Settings Scanner Decoded Internal ScannersDecoded Internal Scanners Options Decoded Internal Scanner Bi-Direction Redundancy 2D Scanning Mode not supportedLength Linear Security Level Data Options Decoded Internal Scanner Enable Trioptic Code EnabledCode Convert To Code Check Digit Verification Set Length L1 And Set Length L2Transmit Check Digit Decode Performance Full AsciiDecode Perf. Level Field Size/Chars Enable Isbt Enable UCC/EAN-128Field Size/Char Strip Leading 20.1.6 EAN 20.1.5 EANPrefix/Suffix EAN-8 Zero Extend UPC E UPC a 20.1.9 UPC/EAN Shared Settings Supp. Redundancy CodabarSecurity Level Linear Decode Notis Editing Clsi Editing Convert To EAN Interleaved 2Interleaved 2 Check Digits MSI PlesseyCheck Digit Algorithm MSI Plessey Enable Code 128 Emulation Enable Field Size/CharDiscrete 2 Discrete 2 Enable Enable RSS-14Reduced Space SymbologyEnable RSS Limited Enable RSS Expanded Enable TLC-39 Enable CC-C And Enable CC-ABDecoded Intermec Iscp Composite not supported UPC E Settings UPC a Settings20.2.5 EAN 20.2.7 UPC/EAN Shared Settings EAN 13 SettingsEAN 13 Settings Addendum Set this parameter to on to enable Codabar Imager TekImager EnabledOptions Imager Center Bar Code Only Code 39 Settings Code 39 SettingsAuto Exposure Fast Converge Code 128 Settings Code 128 Settings20.3.4 UPC/EAN Postal Japanese Postal AustralianPostal Korean Postal PlaNET Postal Royal Postal PostNET20.3.14 2D DataMatrix 20.3.15 2D Maxicode 20.3.18 2D QR Code Enabled Field Size/Char20.3.19 2D RSS Code Aztec Composite Options TabDouble Click Parameters Click Time msec Display Parameters Scan Log File Translations TabTranslations Tab Taskbar Icons Wireless WANInput Output CDMA/1xRTT GSM/GPRS Status IndicatorsTaskbar Icons Establishing a Connection Establishing a Connection Shutting Down The Wireless WAN User Interface Disconnecting From a NetworkDisconnecting From a Network Advanced Information Error States Error States Tools Menu Data Connection ConfigurationTools Menu Tap on Disable Auto Data Connection Configuration Edit ShowDelete New ResetActivate Security Configuration Security ConfigurationAdvanced IP Network Configuration Network Configuration Driver Mode Configuration Driver Mode Configuration Disabled Modem Power ModesEnabled-Off in Suspend Modem Information Enabled Always On Enabled Automatic OffTap on Start, Settings. Tap on the Total Recall icon Total Recall Creating a Backup Profile Creating a Backup ProfileProfile Information View Selections Add Files Restoring a Profile Performing The BackupRestoring a Profile Connections Connecting To The InternetConnections Modem Connection Setup Modem Connection SetupUnder My ISP, tap on Add a new modem connection 65 Phone Connection Screen Advanced Modem Settings Advanced Modem SettingsBaud Rate Wait For Dial Tone Before Dialing Cancel If Not Connected Extra Dial-String Modem CommandsWait For Credit Card Data Bits Parity TCP/IP SettingsStop Bits Flow Control Server Settings Setting Up a Network CardSetting Up a Network Card Changing Network Card Settings Changing Network Card Settings VPN Connection Setup VPN Connection SetupHost name/IP, type the VPN server name or IP address Editing a Connection Managing An Existing ConnectionManaging An Existing Connection Changing a Connection Setting Name Changing a Connection Setting Name Selecting a Network Selecting a NetworkTap on Select Networks Under My Work Network, tap on Set up my proxy server Proxy Server SetupEnding a Connection Ending a Connection Changing Advanced Proxy Server Settings Wireless Network SetupChanging Advanced Proxy Server Settings Choose Socks 4 or Socks Bluetooth Mode Bluetooth SetupBluetooth Setup Scanning For a New Device Scanning For a New Device 80 Passkey PIN Screen Bluetooth Gprs Phone Bluetooth Gprs Phone Bluetooth Gprs Phone Programs Programs Programs Page ActiveSync GamesGames ActiveSync Options ActiveSync Options Scheduling Synchronization Connecting To The Internet With ActiveSyncScheduling Synchronization ActiveSync Rules Tab Connecting To The Internet With ActiveSync Calendar CalculatorContacts Calculator Adding Contacts Adding ContactsTap on Start, Programs, Contacts, or Creating Contact Categories Importing Contacts From Other ProgramsImporting Contacts From Other Programs Tap on Import from another program or file, and tap on Next Viewing Contacts Assigning Contacts To CategoriesAssigning Contacts To Categories Tap Start, Contacts Find File ExplorerFile Explorer Internet Explorer HelpBrowsing Web Sites Turning Images On And Off View MenuFitting The Page To The Screen View Menu Changing Security Options Changing Security Options Freeing Storage Space Changing OptionsChanging Options Tap on Tools, Options, Security tab Organizing Favorite Web Sites Setting a Home Page And Changing Character SetsViewing Mobile Favorites Organizing Favorite Web Sites 18 Favorites Screen Adding Mobile Favorites Synchronizing a Favorite Link Synchronizing a Favorite Link Folders Messaging-The InboxMessaging-The Inbox Synchronizing E-mail With Outlook Synchronizing E-mail With Outlook Changing Synchronization Settings Changing Synchronization Settings Mail Server Accounts-Creating, Editing & Deleting Creating An Account 26 E-mail Auto Configuration Screen 28 Account Information Screen Editing An Account Downloading Messages From a Remote ServerDeleting An Account Downloading Messages From a Remote Server Replying And Forwarding Messages Replying And Forwarding Messages Receiving Attachments Receiving Attachments Attaching a File Creating And Sending a MessageDeleting a Message Creating And Sending a Message Storing Attachments Storage OptionsRemoving Deleted Items Storage Options MSN Messenger Setting Up Your MSN AccountGetting Started MSN Messenger Signing In To MSN Messenger Signing In To MSN Messenger Signing Out Signing OutTap on Tools, Add a Contact Managing Your Privacy Deleting ContactsBlocking And Unblocking a Contact Contact Notification Tap on Tools, My Status Changing Your Status Converting Notes To Text Creating a NoteCreating a Note Tap on Tools, Recognize Converting Notes To Text Recording Notes Renaming a NoteFailed Conversions Renaming a Note Synchronizing a Note Synchronizing a Note Pictures Pictures Opening a Photo Moving Photos To The Workbout PROMoving Photos To The Workbout PRO Deleting a Photo Adjusting Contrast And BrightnessEditing a Photo Deleting a Photo Zooming In And Out Cropping a PhotoEditing a Photo Creating a Slide Show Creating a Slide Show Pocket Excel Pocket Excel Moving Between Worksheets Workbook ComponentsWorkbook Components Entering Data In a Worksheet Adding, Deleting And Renaming WorksheetsAdding, Deleting And Renaming Worksheets Tap on Formats, Modify Sheets Entering Symbols Cancelling An EntryTap on Tools, Insert Symbol Editing Cell Text Or Numbers Copying And Pasting Working With Cells, Rows and ColumnsFormatting Cells Working With Cells, Rows and Columns 57 Format Cells Number Tab 59 Cell Alignment Tab Tap Format, Insert Cells..., or Inserting Rows And Columns Tap on Format, Delete Cells, or Deleting Cells, Rows And Columns Creating Formulas Creating Formulas 64 Manually Entered Formulas Inserting Formulas Manually 66 Formula Results Using The Insert Function Command 67 Insert Function Screen Pocket Word Pocket WordTap on Start, Programs, Pocket Word Creating a New Document From a Template Creating a New DocumentCreating a New Document Opening An Existing Document Opening An Existing Document Reverting To a Previously Saved Version Saving DocumentsSaving Documents Within a document, tap Tools, File, Save Document As Data Entry Modes Handwriting ModeTyping Modes Data Entry Modes Tap on View, Recording Recording Mode Formatting Text Using the Pocket Word ToolbarFormatting Text Cutting, Copying And Pasting Adjusting Paragraph IndentsTap on Edit, Paste Tap on Edit, Paragraph Finding Text Undoing Or Redoing An ActionTap on Edit, Redo 81 Replace Screen Replacing a Word Connecting To a Terminal Server Terminal Services ClientTasks Sharing Documents With Your PC Moving Around Terminal Services Client Moving Around Terminal Services ClientTap on Start, Programs, Terminal Services Client On your PC, choose Start, Settings, Control Panel Windows Media Disconnecting Without Ending a SessionImproving Browser Performance Ending a Session Converting a Media File On Your PC 84 Windows Movie Maker 85 Movie Maker Import File Screen 87 Movie Maker Timeline Copying Music Files From a CD Copying Music Files From a CD 90 Windows Media Rip Screen Copying Music And Video Files To Your Hand-Held Auto Syncing MusicCopying Music And Video Files To Your Hand-Held Auto Syncing Music Tap on Sync settings Playing Music And Videos Playing Music And VideosOn your Workabout PRO, tap Start, Programs, Windows Media Tap on Menu, Library 94 Windows Media Library Screen 96 Library Update Completion Windows Media Player Controls Windows Media Player Controls Expansion Modules Page Removing The End-Cap And Back Plate Expansion ModulesExpansion Modules What’s Inside What’s Inside Installing The PC Card Expansion Module Shutting Off PowerShutting Off Power Pcmcia Module And Mechanical Stopper Installing The PC Card Expansion Module Installing a GSM/GPRS Module Installing a GSM/GPRS Module Inserting The SIM Into The GSM/GPRS Module Installing The Antenna Installing An SE 1223HP Scanner Installing An SE 1223HP Scanner Enabling The SE 1223HP Scanner Installing An SE 923HP ScannerEnabling The SE 1223HP Scanner Enabling The SE 923HP Scanner Enabling The SE 923HP Scanner Peripheral Devices & Accessories Peripheral Devices & Accessories Carrying Accessories Carrying AccessoriesCarrying Accessories Attaching The Hand Strap Attaching The Hand Strap Securing The Hand Strap Attaching The Pistol Grip Attaching The Pistol Grip Protective Carrying Case Protective Carrying Case Using The Swivel Belt Loop With The Carrying Case Using The Swivel Belt Loop With The Carrying Case Belt Clip Soft Shell Holster Soft Shell Holster Batteries Lithium Ion Battery Safety Precautions Chargers And Docking Stations Chargers And Docking Stations Power Consumption Considerations Installation-Chargers And Docking StationsImportant Charger Safety Instructions Installation-Chargers And Docking Stations Important Charger Safety Instructions Desktop Docking Station Desktop Docking Station Battery Charge Duration Charging a Spare BatteryCharger LED Indicators Charging a Battery Installed In The Workabout PRO Troubleshooting The Charging Operation Of The Dock Desktop Battery Charger LED BehaviourDesktop Docking Station Ports Icon Charge Status Linking a Workabout PRO To a PC Linking a Workabout PRO To a PC Network Addressing Network AccessLinking a Workabout PRO To An Ethernet Network Inserting a Battery In The Single Battery Charger Charge Indicators-The LEDSingle Battery Charger-Model #WA3001 Single Battery LED Behaviour Quad Battery Charger-Model #WA3004Quad Battery Charger Quad Battery Charger-Model #WA3004 Troubleshooting Charge Indicators-The LEDsIndicator Flashing Red Power LED Does Not Light Up Indicator Does Not Light When Battery Installed Indicator Does Not Light When Battery InstalledQuad Docking Station-Model #WA4004 Quad Indicators Quad Docking Station SetupQuad Docking Station Setup Battery Charging-LED Behaviour Network AccessHand-Held LED Does Not Light When Docked Network Addressing AC Wall Adaptor And Tether Cable AC Wall Adaptor And Tether Cable 17 Bottom Of Workabout PRO Cigarette Lighter Adaptor Cigarette Lighter Adaptor Vehicle Cradle Mounting Recommendations Vehicle CradleVehicle Cradle Using The Vehicle Cradle Wiring GuidelinesMounting Template Mounting Template Maintaining The Vehicle Cradle Powered Cradle Installation In High Voltage VehiclesMaintaining The Vehicle Cradle Wiring Vehicle Power To The Cradle Powered Vehicle Cradle InstallationPowered Vehicle Cradle Installation Port Replicator Bluetooth PeripheralsPort Replicator Bluetooth Peripherals Page SPECIFICATIONS10 Page Weight Hand-Held Computer SpecificationsWorkabout PRO C Models Size Workabout PRO S Model Size Environmental CommunicationApprovals Scanner Specifications Radio Specifications10.3.1 SE 1223HP Scanner Specifications 802.11b Direct Sequence Spread Spectrum SE 923HP Scanner Specifications 10.3.2 SE 923HP Scanner SpecificationsUser Environment Regulatory E1022 Linear 1D Imager Scanner Parameter E1022 Parameter SX5390 Symagery SX5390 Advanced ImagerSymagery SX5390 Advanced Imager Standard Battery Pack Battery SpecificationsBattery Specifications High-Capacity Battery Pack High-Capacity Battery Pack High-Capacity Battery Pack Maxell ML2032 Rechargeable Coin Battery Maxell ML2032 Rechargeable Coin Battery Appendix a Worldwide Offices Contact Pin Definition Standard Battery LIF Low Insertion Force Port Pinout LIF Low Insertion Force Port Pinout Audio Mini-Plug Page Index 280 Index Clsi Editing Input Excel See Pocket Excel Alpha Scan Indicator 139 scanner warning message 139 Scan Result Notis Editing Output Prefix Char 110 Bad Scan Beep Good Scan Beep Strip Leading Transmit Check Digit MSI Plessey 2D RSS Code 127 2D Scanning Mode 2D UPC Half Block Stitching