HP 620Lx HP 620LX/660LX PalmTop - (English) User Guide - Page 89

Using functions and formulas, To quickly calculate averages, sums, or maximum/minimum values

Get HP 620Lx - Palmtop PC PDF manuals and user guides View all HP 620Lx manuals
Add to My Manuals
Save this manual to your list of manuals

Page 89 highlights

• 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 8/3/96 Aug-96 31-Aug-96 Times 3:00 3:00:00 pm 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. WorkingwithHPrPe-aIlnmstaolplePdCAUpspelircaGtuiiodnes- 79

  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
  • 30
  • 31
  • 32
  • 33
  • 34
  • 35
  • 36
  • 37
  • 38
  • 39
  • 40
  • 41
  • 42
  • 43
  • 44
  • 45
  • 46
  • 47
  • 48
  • 49
  • 50
  • 51
  • 52
  • 53
  • 54
  • 55
  • 56
  • 57
  • 58
  • 59
  • 60
  • 61
  • 62
  • 63
  • 64
  • 65
  • 66
  • 67
  • 68
  • 69
  • 70
  • 71
  • 72
  • 73
  • 74
  • 75
  • 76
  • 77
  • 78
  • 79
  • 80
  • 81
  • 82
  • 83
  • 84
  • 85
  • 86
  • 87
  • 88
  • 89
  • 90
  • 91
  • 92
  • 93
  • 94
  • 95
  • 96
  • 97
  • 98
  • 99
  • 100
  • 101
  • 102
  • 103
  • 104
  • 105
  • 106
  • 107
  • 108
  • 109
  • 110
  • 111
  • 112
  • 113
  • 114
  • 115
  • 116
  • 117
  • 118
  • 119
  • 120
  • 121
  • 122
  • 123
  • 124
  • 125
  • 126
  • 127
  • 128
  • 129
  • 130
  • 131
  • 132
  • 133
  • 134
  • 135
  • 136
  • 137
  • 138
  • 139
  • 140
  • 141
  • 142
  • 143
  • 144
  • 145
  • 146
  • 147
  • 148
  • 149
  • 150
  • 151
  • 152
  • 153
  • 154
  • 155
  • 156
  • 157
  • 158
  • 159
  • 160
  • 161
  • 162
  • 163
  • 164
  • 165
  • 166
  • 167
  • 168
  • 169
  • 170
  • 171
  • 172
HP Palmtop PC User Guide - 79
•
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.
•
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.
WorkingwithPre-InstalledApplications
Date
8/3/96
Aug-96
31-Aug-96
Times
3:00
3:00:00 pm
8/31/96 3:00 pm