EasyManua.ls Logo

Psion 3a Series - Moving Around and Entering Data; Types of Data - Text, Number, Formula

Psion 3a Series
288 pages
Save Page as PDF
Print Icon
To Next Page IconTo Next Page
To Next Page IconTo Next Page
To Previous Page IconTo Previous Page
To Previous Page IconTo Previous Page
Loading...
Moving
around
and
entering data
The
grid
is
the
working
area
of
the
Spreadsheet
-
where
you
enter
your
data.
Each
cell
in
the
grid
can
contain
one
piece
of
information.
Each
cell
is
identified
by
its
cell
reference,
made
from
its
column
(
A
,
B
,
C
...)
and
row
(1,2,3
...).
The
top
left
cell,
for
example,
is
called
A1.
You
can
use
<-
Ti
-»to
move
a
cell
pointer
around
the
grid.
It
marks
where
you
are
on
the
grid
-
the
current
cell
-
rather
like
the
cursor
in
the
Word
Processor.
The
cell
reference
of
the
current
cell
-
A1,
B2
and
so
on
-
is
shown
at
the
left
end
of
the
input
line
at
the
top
of
the
screen.
There
are
256
columns,
labelled
A
to
IV,
and
8192
rows,
labelled
I
to
8192.
The
display
can
only show
a
small
part
of
the
grid,
and
will
scroll
as
required
if
you
try
moving
the
cell
pointer
off
the
screen.
To
enter
data
into
the
current
cell,
just
start
typing.
The
data
appears
in
the
input
line.
When
you've
typed
it:
•
Press
Enter
to
enter
the
data
into
the
current
cell.
•
Alternatively,
use
«-
Ti
to
enter
the
data
and
then
move
the
cell
pointer
in
the
corresponding
direction.
This
is
a
quick
way
to
enter
a
series
of
cells.
As
in
many
other
Series
3a applications
you
can
use
the
'Zoom
in'
and
'Zoom
out'
options
on
the
'Special'
menu
to
change
the
display
size
of
the
data
you
enter.
Types
of
data
-
text,
number,
formula
Each
cell
can
contain
only
one
piece
of
data.
It
will
be
one
of
three
types,
depending
on
the
first
character
you
enter:
•
If
the
first
character
is
one
of
these:
0123456789(.+-
then
the data
is
treated
as
a
number.
!£§=
You
can
also
enter
calculations,
which
are
immediately calculated
and
entered
as
numbers
-
for
example,
78*36
would
enter
into
a
cell
as
2808.
•
If
the
first
character
is
=
the
data
is
treated
as
a
formula.
Formulae
are
used
to
do
calculations.
•
For
any
other
first
character,
the
data
is
treated
as
text.
(Separate
items
of
text
are
sometimes
called
text
strings.)
Cell
width
If
a
text
string
is
too
long
for
its
cell
the
text
is
displayed
on
lop
of
adjacent
cells
to
the
right,
as
long
as
they
are
empty.
(Text
strings
may
be
up
to
236
characters
long.)
If
a
number
in
the
selected
format
is
too
large
for
its
cell,
the
cell
is
displayed
filled
with
#
symbols.
'Illegal
character'
message
If
you
see
an
'Illegal
character'
message
when
you
try
to
enter
data
remember
that
the
first
character
you
type
controls
what
type
of
data
you
are
entering.
For
example,
30b
132
8:
The
Spreadsheet
•

Table of Contents

Related product manuals