Psion Revo Palmtop Computer Instructions Manual

151
Word
Word.p6503/02/2000, 15:08 151 

152
Sheet
Sheet
Sheet has two views:
·The Sheet view, where information is displayed
as a grid of cells on a worksheet. Cells are
referred to by their position in the grid of
columns and rows, e.g. ‘D3’. You can present
information in table form in Sheet, and perform
calculations based on sets of numbers stored in
the worksheet.
·The Graph view, where you can create graphs
based on information stored in the worksheet.
Sheet is the spreadsheet program. It has many of the
features and functions that you...

153
Sheet
Moving around
The current cell is indicated by a dark border around
a cell. The information you enter in the input line
applies to this cell.
·Tap any cell to select it, or press the arrow keys
to move around. You can use the scrollbars or
the arrow keys to move to other areas of the
worksheet. Hold down the Ctrl key and press
the arrow keys to move by a whole page at a
time.
·Use the Find commands on the Edit menu to
move to other cells. Use Find and Find next to
move to cells if you know...

154
Sheet
·To enter a date: type the day, month and year
on the input line, separating them with a space or
the date separator character as set in the System
screen,  e.g. 1 Oct 69 or 1 10 69, or 10 1 69 if
you use this date format.
·To enter a time: type the hour, minutes and
seconds, separating them with a colon (or the
time separator character as set in the System
screen).Note: To edit the information in a cell: simply
highlight the cell and press Enter. You can then edit
the contents on the input...

155
Sheet
Performing calculations
There are two ways to perform calculations:
·Type the calculation into a single cell. When you
press Enter or move to another cell, the result
will be displayed on the worksheet.
·Use a formula for a calculation; just type the
different parts of your calculation in separate cells
and note their references, e.g. income in B2 and
tax in C2. In a new cell, enter the formula,
beginning with a =. Use the cell references for
the components of the calculation rather than
the...

156
Sheet
·Absolute references, such as $A$2. These
contain a $ sign in front of the parts of the
reference that you don’t want to change even if
the formula is moved elsewhere. So, $A$2 in cell
B3 remains $A$2 when copied to cell C3.Note: You can combine the two types of reference:
A$5 in A6 will become B$5 when copied to B8 (the
‘5’ doesn’t change because it is an absolute
reference).A formula which contains a reference to its own cell,
either directly or indirectly, is called a “circular
reference”;...

157
Sheet
Using ranges
A range is a rectangular block of cells. The reference
for a range is the cell references of the top left and
bottom right corners of the block, separated by a
colon, e.g. B2:C6. You can use ranges to define areas
of the worksheet for applying formatting, creating
graphs, or including range references in formulae, e.g.
=SUM(B2:C6).
·To select a range: highlight all the cells you want
to be a part of your range.
·To use a range in a formula: highlight the range
to be inserted while...

158
Sheet
Changing how information is displayed
You can format the information in the worksheet in a
number of ways, e.g. to differentiate the parts of
tables and calculations. Formatting is applied to all of
the highlighted cells.
·To change the alignment of information: tap
 to set the horizontal alignment, or use the
command on the Format menu to set both the
horizontal and the vertical alignment.
·To change the font or size: use the font
 and size 
 buttons in the
Top toolbar; or use the commands on...

159
Sheet
3.Select the column that you want to use to order
the rows, and specify the way that you want to
sort. Tap Options if you want to make the sort
case sensitive.
Sorting from left to right
You can also sort from left to right. Use this type of
sorting if you want to change the order of the
columns in a table.
To sort from left to right:
1.Highlight the range of information that you want
to sort, rows and columns (Sheet will only sort
information inside this range).
2.Select Left-to-right from the...

160
Sheet
Graphs
You can use Sheet to create, format and print graphs
based on information on the worksheet, e.g. to show
annual sales figures, or the distribution of revenue.
You can create many types of graphs including line
graphs, bar and column graphs, scatter charts and pie
charts. You can add to or alter many aspects of the
graph’s appearance by tapping on the area of the
graph you wish to change.
Creating a graph
To create a graph:
1.Highlight a column or row of numbers in the
Sheet view. This...