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 would expect from a
fully-featured spreadsheet.
You can use Sheet to create “worksheets”, and use
PsiWin to transfer worksheets to and from your PC.
Column headingRow heading
Top toolbar
Sheet.p6503/02/2000, 15:08 152 
						

							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 their content, or Go
to to jump to a specific cell.Note: You can alter the number of cells displayed by
using the ‘magnifying glass’ (zoom) icons on the left of
the screen, or by setting the zoom level using the
command on the View menu.
Highlight more than one cell to perform actions
which apply to an area:
·To highlight more than one cell: drag the pen
from the first cell in the block to cover the
desired cells, or hold down Shift and use the
arrow keys.·To highlight a whole column or a whole row: tap
the shaded column or row heading, e.g. “C” or
“2”.
·To highlight the entire worksheet: tap the square
in the top left corner of the worksheet headings.
Entering information
To enter information in a cell, select it and start
typing. You will see the information you are entering
on the input line. The first character you type tells
Sheet what kind of information the cell will contain:
·To enter numbers: begin with a number or with
one of these characters: . - + and (.
·To enter text: simply type it in. If your text starts
with a number, type a  (apostrophe) first, e.g. 24
Longton Road. If you want the text itself to
contain a  at the beginning, type two apostro-
phes, e.g.  97 sales figures.
·To enter a formula for a calculation: begin with a
=. For example, to make a given cell display the
sum of the contents of cells B1 and B2, type in
=B1+B2.
Sheet.p6503/02/2000, 15:08 153 
						

							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 line.
Sizing rows & columns
You can change the width of columns, and the height
of rows, to suit the information contained in them. To
do this:
·Drag the right-hand edge of the column heading
to adjust its width, and the lower edge of the
row heading to adjust its height.
·Use the commands on the Format menu to set
the height of a row in points and the width of a
column in characters.
Note: If you enter more text than can be displayed in
the cell, the information will run over into the next
column if that column is empty. If you enter a number
that’s too long for the cell, you will see a series of #
signs in the cell, but the actual number will still be
stored, Increase the column width to see the number.
Freezing & protecting cells
·To freeze non-scrolling panes on the worksheet:
type the information you wish to “freeze” in the
rows and columns; position the pointer in the cell
below the row to freeze, and to the right of the
column to freeze (this will often be B2). Tap the
 button, or select the command from the
View menu. The “frozen” panes will stay on
screen when scrolling through the rest of the
worksheet.
·To protect the whole worksheet from changes:
select the Protection command from the Tools
menu, then tick Protect worksheet.
·To allow changes to some cells only: highlight the
area(s) for which you wish to allow changes, then
select the Protection command on the Tools
menu and remove the tick to “unlock” only the
highlighted cells. If you then protect the
worksheet, changes are only allowed to the cells
that are not locked.
Sheet.p6503/02/2000, 15:08 154 
						

							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 numbers themselves. For example,
=C2-(B2*C2). The value displayed in this cell is
calculated for whatever values you use in the
component cells.
Note: To sum the contents of a row or column,
position the pointer in the cell at the end of the row
or column and tap the 
 button. Sheet inserts the
formula for the sum of the preceding group of cells,
and calculates their total.
There are two types of cell reference you can use in a
formula:
·Relative references, such as A2. These get
updated when copied and moved elsewhere. For
example, a reference to cell A2 in a formula in
cell B3 will change to B2 if the formula is copied
to cell C3.
Use 
= to
enter formulae
Sheet.p6503/02/2000, 15:08 155 
						

							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”; e.g. if A1 is ‘=A2’, and A2 is ‘=A1’. You
can find any circular references in the worksheet using
the Find commands on the Edit menu. You should
avoid making circular references as they produce
unpredictable results.
Recalculation
Sheet automatically recalculates your worksheet every
time you change part of a calculation. You may want
to turn this feature off if you are making a large
number of changes in the worksheet.To do this:
·Select the Preferences command from the Tools
menu, and set Auto recalculation to off. When
Auto recalculation is off, a ‘+?-’ symbol will be
displayed at the right end of the input line for
cells which need to be recalculated to update
their value.
To recalculate the worksheet, select the Recalculate
now command from the Tools menu.
Functions
Sheet has a large number of functions, e.g. math-
ematical, financial and trigonometric functions, that
you can incorporate in your calculations. See the
built-in help on the Revo for a full list and details of
syntax.
·To use a function in a calculation: type it in; or
insert a function by tapping the function button
, or selecting Function from the Insert menu.
Sheet.p6503/02/2000, 15:08 156 
						

							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 entering the formula. For
example, type “=SUM(”, then drag the highlight
to cover the appropriate range, type a “)” and
press Enter.
Naming ranges
Name ranges so that they are easier to enter in sums
and formulae, e.g. use “=AVERAGE(Totals)” instead
of “=AVERAGE(C8:K8)”. It is better refer to ranges
by a name in formulae, because if you change the
range of cells, you don’t need to update any
references to the range in the worksheet.
·To name a range: highlight the range and add a
name using the Add name command from the
Name commands on the Insert menu. To edit
the range name, use the Edit name command.
Sheet.p6503/02/2000, 15:08 157 
						

							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 the
Format menu to select the font, size and other
attributes, e.g. superscript, strikethrough.
·To add bold, italic or underline: use the
 buttons, or use the Font command on
the Format menu.
·To add a border: tap 
 or select the
command from the Format menu and select a
border style for the cell(s).
·To add shading: tap  or select the
command on the Format menu, and select the
shading you want to apply.
Sorting information
You can sort rows in a list based on values in a single
column or in several columns. You can also sort
columns based on values in rows, if your list is set up
that way. In either case, you can sort using more than
one row or column. For example, if you want to sort
a table based on a ‘surname’ column, but have more
than one entry for each surname, you can sort again
using the ‘first name’ column as well.
Sorting from top to bottom
You can sort information in order from highest to
lowest value, or in alphabetical order, according to
the information in a particular column. Use this type
of sorting if you want to change the order of the
rows in a table, e.g. to sort entries in a table into the
order specified by an ‘Amount’ column.
To sort from top to bottom:
1.Highlight the range of information that you want
to sort (Sheet will only sort information inside
this range).
2.Select Top-to-bottom from the Sort commands
on the Tools menu.
Sheet.p6503/02/2000, 15:08 158 
						

							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 Sort commands on
the Tools menu.3.Select the row that you want to use to order the
columns, and specify the way that you want to
sort. Tap Options if you want to make the sort
case sensitive.
Changing the number format
To change the number format, select the Number
command from the Format menu. You can formats
the highlighted cell range, or all cells in the worksheet.
The number formats include: general, triad (e.g. 3 000
000) and scientific number display; special formats for
displaying text, currency, dates and times, percent-
ages; and a format for hiding the contents of cells.Note: Some settings for the way numbers are
displayed, e.g. the thousands separator, are set in the
International Control panel in the System screen.
Number formats
Sheet.p6503/02/2000, 15:08 159 
						

							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 will be the first “range” that your
graph depicts. You can add other ranges later on
to build up your graph.
2.Tap the Graph button on the Toolbar to move
to the graph view. You will see your graph
displayed on the screen.
Use the Sheet and Graph buttons on the Toolbar to
switch between the two views.
Graph view
Sheet.p6503/02/2000, 15:08 160