Creating Formulas

Chapter 7: Programs

Figure 7.63 Delete Cells

Shift cells left–deletes the selected cell and shifts existing information to the left. Shift cells up–deletes the selected cell and shifts existing information up. Entire row–deletes an entire row and shifts existing information up. Entire column–deletes an entire column and shifts existing information to the left.

7.11.12 Creating Formulas

A formula is an equation beginning with an = sign that performs operations on your data. The operations can be mathematical and can use numbers, text or cell addresses.

You can enter formulas manually, or you can use the Insert Function command that lists a collection of standard formulas.

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

Page 261

Image 261

Psion Teklogix 7525 user manual Creating Formulas

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 Approvals And Safety Summary CE MarkingTTE 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 Switching The Unit Off Suspend Companion CDTurning The Workabout PRO On and Off Warm Reset Connecting The Workabout PRO To a PCAligning Calibrating The Touchscreen Cold Reset Resetting The Workabout PRO Hand-HeldTo 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 Modifier Keys Activating 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 Creating Uppercase Letters Choosing Multiple Alpha CharactersCreating Uppercase Letters Adjusting The Backlight DisplayAligning 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 Bluetooth Radio Uploading Data In a Docking StationUploading Data In a Docking Station SD/MMC Card-Adding Memory Inserting The CardSD/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 Ownership Information Mail NotificationOwnership Information Task Notification Creating a TaskTask Notification Deleting a Task Editing a TaskMarking a Task As Completed Sorting Tasks Calendar Of Upcoming Appointments Limiting The Tasks Displayed In The Task ScreenCalendar Of Upcoming Appointments Creating And Editing Appointments Adding RemindersCreating 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 Taskbar Pop-Up MenusPop-Up Menus Programs-Using Applications Programs-Using ApplicationsOpening An Application Minimizing An Application Settings SettingsClosing An Application Help Entering TextHelp Soft Keyboard TranscriberSoft Keyboard Transcriber Editing Text Within The Transcriber Block Recognizer And Letter Recognizer Block 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 1 Up/Down Control One ShotsUp/Down Control OneShot LockOneShot/Lock Show Modifier Key State Keyboard Macro Keys Recording And Saving a MacroKeyboard Macro Keys Executing a Macro Unicode MappingDeleting a Macro Unicode Mapping Removing Unicode Values Adding And Changing Unicode Values Scancode Remapping Scancode Remapping Adding a Remap Virtual Key, Function And MacroChoose Virtual Key, Function or Macro Input Method Tab InputEditing a Scancode Remap Removing a Remap Keyboard Options Letter Recognizer OptionsInput Method Tab Transcriber Options 12 Letter Recognizer Quick Settings Inking Quick Settings Word Completion AdvancedWord Completion Options-Additional Choices MenusStart Menu Tab Options-Additional Choices Owner Information New Menu TabNew Menu Tab Password PasswordSound & Notifications Sounds Notifications Today ScreenAppearance Notifications System Settings ItemsItems About About DeviceBacklight Battery Power External PowerBattery Power Certificates IntensityIntensity Personal Tab Root CertificatesCertificates Memory Clock & AlarmsChoosing a Certificate Main Tab Storage Card Running ProgramsStorage Card Battery Tab Power IconWireless Tab Power Icon On External Power On Battery PowerAdvanced Tab Advanced Tab Battery Details Battery DetailsCard Slots Regional Settings Built-In DevicesBuilt-In Devices Remove Programs Tap Start, SettingsScreen Icon Remove Programs Scanner Settings Scanner Settings Decoded Internal Scanners ScannerDecoded 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 Set Length L1 And Set Length L2 Check Digit VerificationTransmit 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 Interleaved 2 Convert To EANInterleaved 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 a Settings UPC E 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 Translations Tab Scan Log FileTranslations Tab Taskbar Icons Wireless WANInput Output GSM/GPRS Status Indicators CDMA/1xRTTTaskbar 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 Data Connection Configuration Tools MenuTools Menu Tap on Disable Auto Data Connection Configuration Show EditDelete Reset NewActivate 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 Performing The Backup Restoring a ProfileRestoring a Profile Connecting To The Internet ConnectionsConnections 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 Setting Up a Network Card Server SettingsSetting 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 Managing An Existing Connection Editing a 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 Setup Bluetooth ModeBluetooth 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 Games ActiveSyncGames ActiveSync Options ActiveSync Options Connecting To The Internet With ActiveSync Scheduling SynchronizationScheduling 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 File Explorer FindFile Explorer Help Internet ExplorerBrowsing 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 Messaging-The Inbox FoldersMessaging-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 Creating a Note Converting Notes To TextCreating 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 Moving Photos To The Workbout PRO Opening a PhotoMoving Photos To The Workbout PRO Deleting a Photo Adjusting Contrast And BrightnessEditing a Photo Deleting a Photo Cropping a Photo Zooming In And OutEditing a Photo Creating a Slide Show Creating a Slide Show Pocket Excel Pocket Excel Workbook Components Moving Between WorksheetsWorkbook 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 Creating a New Document From a TemplateCreating 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 Using the Pocket Word Toolbar Formatting TextFormatting Text Cutting, Copying And Pasting Adjusting Paragraph IndentsTap on Edit, Paste Tap on Edit, Paragraph Undoing Or Redoing An Action Finding TextTap 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 Auto Syncing Music Copying Music And Video Files To Your Hand-HeldCopying 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 Expansion Modules Removing The End-Cap And Back PlateExpansion Modules What’s Inside What’s Inside Shutting Off Power Installing The PC Card Expansion ModuleShutting 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 Installing An SE 923HP Scanner Enabling The SE 1223HP 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 Access Network AddressingLinking a Workabout PRO To An Ethernet Network Charge Indicators-The LED Inserting a Battery In The Single Battery ChargerSingle 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 Docking Station Setup Quad IndicatorsQuad 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 Vehicle Cradle Mounting RecommendationsVehicle Cradle Using The Vehicle Cradle Wiring GuidelinesMounting Template Mounting Template Powered Cradle Installation In High Voltage Vehicles Maintaining The Vehicle CradleMaintaining The Vehicle Cradle Powered Vehicle Cradle Installation Wiring Vehicle Power To The CradlePowered Vehicle Cradle Installation Bluetooth Peripherals Port ReplicatorPort Replicator Bluetooth Peripherals Page SPECIFICATIONS10 Page Weight Hand-Held Computer SpecificationsWorkabout PRO C Models Size Workabout PRO S Model Size Communication EnvironmentalApprovals 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 Symagery SX5390 Advanced Imager Parameter SX5390Symagery SX5390 Advanced Imager Battery Specifications Standard Battery PackBattery 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