User manual HP AERO 8500 Reference Guide

[. . . ] AERO 8000 H/PC PROFESSIONAL REFERENCE GUIDE NOTICE The information in this document is subject to change without notice. COMPAQ COMPUTER CORPORATION SHALL NOT BE LIABLE FOR TECHNICAL OR EDITORIAL ERRORS OR OMISSIONS CONTAINED HEREIN; NOR FOR INCIDENTAL OR CONSEQUENTIAL DAMAGES RESULTING FROM THE FURNISHING, PERFORMANCE, OR USE OF THIS MATERIAL. This document contains information protected by copyright. No part of this document may be photocopied or reproduced in any form without prior written consent from Compaq Computer Corporation. [. . . ] Enter values, cell references, name references, operators, and functions as appropriate. Example: =(B4/25)+100 =Revenue-Expenses 5. Press ENTER to enter the formula in the cell. Inserting a Function 1. You can review the function in the Description area. Referring to a Cell or Range in a Formula 1. Select the cell or range where the reference belongs. Press ENTER. Referring to a Cell on Another Worksheet Enter, into your formula, the worksheet name followed by an exclamation point (!) and the cell, range, or name reference. Example: =ThirdQtr!Earnings Creating a 3-D Reference Specify, in your formula, two or more sheets in a workbook. Use a colon between the first and last worksheet names. Example: =SUM(Sheet2:Sheet6!$A$2:$C$5) 5 - 50 Windows CE Automatically Calculating Values 1. Select the range of values you want to calculate. Select the AutoCalculate area on the right of the status bar to display a list of calculation types. Select the calculation type from the list. The result appears in the AutoCalculate area. Automatically Summing Values 1. Select the cell where you want to insert the sum. Check the proposed range, enclosed in a dotted border and displayed in the formula bar. If necessary, adjust the range by dragging the border, selecting a new range, or editing the range in the formula bar. Press ENTER. Pocket Excel Functions The following functions are available in Pocket Excel: Database Functions DAVERAGE DCOUNT DCOUNTA DGET DMAX DMIN DPRODUCT DSTDEV DSTDEVP DSUM DVAR DVARP Windows CE 5 - 51 Date and Time Functions DATE DATEVALUE DAY HOUR MINUTE MONTH NOW() SECOND TIME TIMEVALUE YEAR Financial Functions DDB FV IRR NPER NPV PMT PV RATE SLN SYD Information Functions ERROR. TYPE ISBLANK ISERROR ISERR ISLOGICAL ISNA ISNONTEXT ISNUMBER ISTEXT N NA() 5 - 52 Windows CE Logical Functions AND FALSE IF NOT OR TRUE Lookup Functions CHOOSE COLUMNS HLOOKUP INDEX MATCH ROWS VLOOKUP Math and Trigonometry Functions ABS ASIN ATAN ATAN2 COS COUNTIF DEGREES EXP FACT INT LN LOG LOG10 MOD PI() POWER PRODUCT RADIANS RAND() ROUND SIN SQRT SUM SUMIF TAN TRUNC Windows CE 5 - 53 Statistical Functions AVERAGE COUNT COUNTA COUNTBLANK MAX MIN STDEV STDEVP VAR VARP Text Functions EXACT FIND LEFT LEN LOWER MID PROPER REPLACE REPT RIGHT SUBSTITUTE T TRIM UPPER VALUE 5 - 54 Windows CE Shortcuts Selecting Table 12: Selecting Shortcuts To Select A cell A range A row Multiple rows A column Multiple columns Entire worksheet From current cell to first or last cell in row or column From current cell to beginning of worksheet From current cell to last cell in worksheet From current cell to beginning of a row From current cell to end of row From current cell down one screen From current cell up one screen Arrow keys SHIFT + arrow keys SHIFT + SPACEBAR SHIFT + SPACEBAR and SHIFT + UP and DOWN arrow keys CTRL + SPACEBAR CTRL + SPACEBAR and SHIFT + LEFT and RIGHT arrow keys CTRL + A CTRL + SHIFT + arrow keys CTRL + ALT + SHIFT + HOME CTRL + ALT + SHIFT + END ALT + SHIFT + HOME ALT + SHIFT + END ALT + SHIFT + PAGE DOWN ALT + SHIFT + PAGE UP Press Windows CE 5 - 55 Navigating Table 13: Navigating Shortcuts To Select Complete a cell and move down Complete a cell and move up Complete a cell and move right Complete a cell and move left Move to the first or last cell in a row or column Move to the beginning or a row Move to the end of a row Move to the beginning of a worksheet Move to the end of a worksheet Move one screen down Move one screen up Move to next sheet Move to previous worksheet Move to the next/previous workbook Press ENTER SHIFT + ENTER TAB SHIFT + TAB CTRL + arrow keys ALT + HOME ALT + END CTRL + ALT + HOME CTRL + ALT + END ALT + PAGE DOWN ALT + PAGE UP CTRL + ALT + PAGE DOWN CTRL + ALT + PAGE UP CTRL + > or CTRL + < ALT + Z ALT + SHIFT + Z Zoom Reverse zoom 5 - 56 Windows CE Entering and Editing Data Table 14: Entering and Editing Data Shortcuts To Select Complete an entry Cancel an entry Complete a cell and move down Move to the beginning of a line Move to the end of a line Delete the contents of the selected cell Activate cell Fill down Fill to the right Fill the selected range with the current entry Open the Replace With dialog box Calculate all open sheets Hide row Unhide row Hide column Unhide column Enter current date Enter current time ENTER ESC ENTER ALT + HOME ALT + END SHIFT + BACKSPACE CTRL + E CTRL + D CTRL + R CTRL + ENTER CTRL + H CTRL + = CTRL + 9 CTRL + SHIFT + 9 CTRL + 0 CTRL + SHIFT + 0 CTRL + ; CTRL + : Press Windows CE 5 - 57 Formatting Data Table 15: Formatting Data Shortcuts To Select Bold Italic Underline General format Decimal format Time format Date format Currency format Percentage format Exponential format CTRL + B CTRL + I CTRL + U CTRL + SHIFT + ~ CTRL + SHIFT + !CTRL + SHIFT + @ CTRL + SHIFT + # CTRL + SHIFT + $ CTRL + SHIFT + % CTRL + SHIFT + ^ Press Working with Workbooks Setting a Password for a Workbook Protect your workbook with a password. Select FilePassword to access a password dialog box. Type and verify the password you want to protect your file. Select FileSave to save your workbook and retain the password. NOTE: You cannot synchronize workbooks that are password protected. [. . . ] The Aero 8000 is designed to stay on while connected to a computer. Device initiated a safety shutdown due to a critical low battery condition. The PC Card drains too much power from the device batteries. You are using the device in ways that drain that drain the battery quickly. [. . . ]