Casio PV-S250 User manual

79
Chapter
7Quick-Memo
1Draw toolbar
2Input toolbar
3Quick-Memo category
button
Quick-Memo is like having a digital memo pad on which you can sketch simple
line drawings or jot down reminders.
Entering the Quick-Memo Mode
Tap the Quick-Memo icon below the PV Unit screen to enter the Quick-Memo
Mode.
1
2
3
• This is the Quick-Memo input screen, which appears first whenever you
enter the Quick-Memo Mode.
• Tap in the upper right corner of the screen to exit the Quick-Memo
Mode and return to the screen from which you originally entered it.
Quick-Memo Categories
There are three Quick-Memo categories.As with categories in other modes, Quick-
Memo categories let you group your memos for easier management.
To select a Quick-Memo category
Tap the Quick-Memo category button to cycle through the Quick-Memo
categories in the following sequence: fififi,
etc.
The display shows the Quick-Memos that are stored under the currently
selected category.
7

80
Using the Quick-Memo Drawing Tools
The following describes the functions of the Quick-Memo Drawing tools when
inputting Quick-Memo data.
Tap a drawing tool with the stylus to select it. The currently selected drawing tool
is highlighted on the toolbar. Tapping some of the drawing tools also cycles through
a number of optional settings.
12 34 5
6
Important!
A diagonal line may appear jagged on the display, even in the Quick-Memo list
(page 82).
Pencil Tool
• Tap this tool to cycle through line thickness in the sequence:
medium fithick fithin fimedium , etc.
• Dragging the stylus on the screen while this tool is selected draws a line.
• Note that you can control the type of line produced by the pencil tool
with the line tool, described below.
Eraser Tool
• Tap this tool to cycle through eraser thickness in the sequence:
medium fithick fithin fimedium , etc.
• Dragging the stylus on the screen while this tool is selected erases
anything along the line.
• Note that you can control the type of path produced by the eraser tool
with the line tool, described below.
1Pencil
2Eraser
3Line
4Color
5Undo
6Selected tool

81
Chapter 7 Quick-Memo
Line Tool
• Tap this tool to cycle through the type of line or eraser path produced
when dragging the stylus on the display while the line tool or eraser tool
is selected. Each tap of this tool cycles through the line type in the
sequence: freehand fistraight fivertical/horizontal
firectangle fifreehand , etc.
Color Tool
• Tap this tool to toggle the darkness of the line between the following
settings: black «gray .
Undo Tool
• Tap this tool to undo the last draw operation you just performed.
Creating a New Quick-Memo
Use the procedures in this section to draw the figures you want in a Quick-Memo.
To input a new Quick-Memo
1. Enter the Quick-Memo Mode.
2. Tap the (category) button to select the category where you want to
save the Quick-Memo.
3. Use the drawing tools to draw the figure you want.
• To clear all Quick-Memo screen contents, tap Clr.
4. After you are finished, tap Save to save the Quick-Memo.
• If you want to input another Quick-Memo, tap New.
To draw a line or rectangle
1. Select the line tool for the type of figure (freehand, straight line, vertical/
horizontal line, rectangle) you want to draw.

82
2. Drag the stylus on the display to draw the figure.
Recalling a Quick-Memo
Use the following procedure to scroll through a list of Quick-Memos and find the
one you want. Then you can select a Quick-Memo in the list to view it.
1. While the Quick-Memo input screen is on the display, tap List.
1
3
4
2
• This is the Quick-Memo list screen.
2. Tap the category button to specify the category whose Quick-Memos
you want to view. Selecting displays the Quick-Memos in all
categories.
3. Use the scroll buttons to scroll through the Quick-Memos in the currently
selected category.
4. When the Quick-Memo you want to recall is on the screen, tap it with
the stylus to select it.
1Category button
2Scroll buttons
3Selected Quick-Memo
4Creation date

83
Chapter 7 Quick-Memo
5. Tap the selected Quick-Memo to change to its data display.
1
23
6. In the Quick-Memo data display, you can use the scroll buttons to scroll
back and forward to the data display of other memos.
7. After viewing the Quick-Memo, tap List to return to the list screen.
Screen Copy
The screen copy feature lets you copy an image of certain screens and store it as
a Quick-Memo screen. The following is a list of screens that you can copy with
the screen copy feature.
Data that can be screen copied
All list and data screens
All calendar screens (1, 2, 3-month)
Weekly Scheduler
Daily Scheduler
To Do List
Reminder List
All data screens
Screens listing periodic totals by expense
types or payment types (page 69)
All list and data screens
All list and data screens
Conversion calculation screens
Mode
Contacts
Scheduler
Expense Manager
Memo
Currency Converter
1Scroll buttons
2Category of displayed
Quick-Memo
3Creation date

84
To record a screen copy
1. Display the data for which you want to record a screen copy.
2. Tap the Menu Bar icon to display the menu bar, and then tap Option –
Screen copy.
• The PV Unit switches to the Quick-Memo Mode, with the new screen
copy on the display. Make any additions or changes if you want, and
then store the image by tapping Save.

85
Pocket Sheet gives you access to basic spreadsheet capabilities while on the go.
You can build your own spreadsheets from scratch, and even synchronize with
Microsoft®Excel data on your computer.
Entering the Pocket Sheet Mode
1. Tap the Menu icon to display the Mode Menu, and then tap Pocket
Sheet.
2
1
• This is the Pocket Sheet list screen, which appears first when you enter
the Pocket Sheet Mode.
Pocket Sheet Basics
With Pocket Sheet, you can open up a blank sheet and build the sheet you want
from scratch.
The following sections describe how to open a new sheet, and how to perform
some of the most basic sheet operations.
Chapter
8Pocket Sheet
8
1Sheet titles
2Scroll bar

86
Creating a New Sheet from Scratch
1. Display the Pocket Sheet list screen.
2. Tap the New button.
1
2
6
5
34
• Columns are named using the letters of the alphabet from A to Z, while
rows are numbered sequentially from 1 to 999.
• The maximum capacity for a single sheet is about 32KB (about 1,900
cells when each cell contains one character, without any format settings
or borderlines). The message “Sheet is too big!” appears on the display
whenever the contents of a file exceeds this limit.
If a sheet being received by the unit during a Pocket Sheet Sync operation
exceeds the maximum limit (about 32KB), the excess cell data is
automatically cut off. In this case, the sync operation ends normally,
with no indication that the data was cut off. This means you should
always check sheet contents visually after a sync operation is complete.
• A cell is referred to using its cell reference, which is made up of the
cell’s column name and row number. This means that the cell reference
of the upper left cell in the above sheet is A1, and the cell reference of
the lower right cell is D5.
• The active cell is the one that is currently selected for input. The active
cell is highlighted.
• The numeric keyboard appears first whenever you open a new sheet.
1Row numbers
2Keyboard
3Input field
4Current cell
5Column names
6Cells

87
Chapter 8 Pocket Sheet
Making a Cell the Active Cell
You can make a cell active by tapping it with the stylus so it becomes
highlighted. You can also move the highlighting around the display using
the scroll bar as described below.
• Tapping the gray areas of the scroll bar scrolls the entire screen with the
highlighted active cursor in the same relative position in the newly
displayed screen.
Selecting a Range of Cells
While a sheet is open on the display, drag the stylus across the range of cells
you want to select. The cells become highlighted as you drag across them.
• Dragging straight left or right selects a range of cells in the same row.
• Dragging straight up or down selects a range of cells in the same column.
• Dragging diagonally selects a block of cells (multiple rows and columns).
Jumping to a Specific Cell in a Sheet
Important!
• You cannot jump to a cell located inside a row or column that is frozen. To
jump to such a cell, you must unfreeze the row or column first.
To do this:
Move the highlighting one cell left
Move the highlighting one cell right
Move the highlighting one cell up
Move the highlighting one cell down
Tap here on the Scroll
Bar:
H
J
K
L

88
1. While a sheet is on the display, tap the Menu Bar icon to display the
menu bar, and then tap Edit – Go To to display the Go To screen.
2. Use the on-screen keyboard to type in the cell reference (column and
row) of the cell to which you want to jump.
• To jump to cell Z999, for example, type “Z999”.
3. Tap Exe to jump to the cell you specified.
Inputting Data Into a Cell
This section explains the rules and procedures for inputting text, values, and
mathematical expressions into sheet cells. It also contains detailed information
on the various cell functions that are available.
General Input Rules
The following are the general rules that you should observe whenever
inputting data.
• Anything you enter on the keyboard is input into the sheet’s active cell.
• You can input up to 256 characters into each cell.
• Mixing text and numbers inside the same cell causes everything in the
cell to be treated as text.
• Do not manually input commas as separators inside values. Doing so
interferes with correct display of calculation results. Use the procedure
under “Changing the Format Settings of a Cell” on page 95 to turn on
automatic comma separators.

89
Chapter 8 Pocket Sheet
Cell References
The term cell reference means calling the contents of one cell into another
cell. Pocket Sheet supports three types of cell references: relative, absolute,
and mixed. Whether a cell references is relative, absolute, or mixed does not
make affect the results it normally produces. The cell reference type matters
only when the contents of the cell are copied and then pasted into another
location. See “Copying a Relative Cell Reference” on page 109 and “Copying
an Absolute or Mixed Cell Reference” on page 109 for full information
about how cell references are affected by cut, copy, and paste operations.
Relative Cell References
As its name suggests, a relative cell reference is one that references a cell in
relation to the cell where the reference is made. Note the following examples.
Absolute Cell References
An absolute cell reference is one that references a specific cell, no matter
where it is located in relation to the cell where the reference is made. A
reference is made absolute by inserting a dollar sign in front of its column
name and row number. Note the following examples.
Meaning
Contents of cell A1
Contents of the column of cells from A1
through A10
Contents of the row of cells from A1 to E1
Relative Cell
Reference
A1
A1:A10
A1:E1
Meaning
Contents of cell A1. Both the column ($A) and
row ($1) references are absolute.
Contents of the column of cells from A1
through A10. All the column and row
references are absolute.
Contents of the row of cells from A1 to E1. All
the column and row references are absolute.
Absolute Cell
Reference
$A$1
$A$1:$A$10
$A$1:$E$1

90
Mixed Cell References
A mixed cell reference is one in which one component (column name or
row number) is relative, and the other component is absolute. Note the
following examples.
Using the On-screen Keyboards
Opening a new sheet that does not contain any data or tapping the highlighted
cell within a sheet causes an on-screen keyboard to appear.
• Tapping the button above the text keyboard changes to the numeric
keyboard.
• Tapping the button above the numeric keyboard changes to the
text keyboard.
• Tapping displays a menu of built-in functions.
Meaning
Contents of cell A1. The column reference ($A)
is absolute, and the row reference (1) is
relative.
Contents of cell A1. The column reference (A)
is relative, and the row reference ($1) is
absolute.
Mixed Cell
Reference
$A1
A$1
Text Keyboard
Numeric Keyboard

91
Chapter 8 Pocket Sheet
Inputting Mathematical Expressions
You can set up a cell to perform arithmetic operations (addition, subtraction,
multiplication, division), and other useful functions like SUM (sum of a
series of values), MIN (extracts the lowest value), and COUNT (counts the
number of values). You can also use parentheses to ensure that operations
are performed in the sequence you want.
• Inputting a mathematical expression causes its result to be displayed in
the cell. The mathematical expression itself appears in the input field
only.
• The results of mathematical operations are normally displayed flush right
in the cell.
• If the result of a mathematical expression is longer than the cell that
contains it, the contents of the cell are replaced by a string of # marks.
This is to let you know that the cell contains a value, but the value cannot
be displayed. If this happens, try making the cell wider (page 100).
To input a mathematical expression
1. Make the cell where you want to input the expression the active cell.
2. On the on-screen keyboard, tap =.
• Inputting =as the first character tells the PV Unit that what follows is a
mathematical expression.
3. Use the on-screen keyboard to input the mathematical expression you
want.
• Tapping the buttons above the keyboard inputs the corresponding
function. See “Examples” below for details.
4. After the content of the cell is the way you want, tap NEXT to store it.

92
Examples
The following are some examples of mathematical expressions you can input
into sheet cells.
Cell Contents
=1+2-3
=(1+2)*(3+4)
=(A1+B5)*2
=$A$1+B2
=2^3
=ABS(A1)
=AVERAGE(A1:D5)
=COUNT(A1:D5)
=COUNTA(A1:A7)
=EVEN(3)
=INT(8.9)
=MAX(A1:D5)
=MIN(A1:D5)
=MOD(3,2)
=ODD(2)
=ROUND(2.15,1)
=SQRT(A1*5)
=SUM(A1:D5)
Displayed Result
0
21
Result of expression using contents of cells A1
and B5
Contents of cell A1 + Contents of cell B2
8 (Raises left value to power specified by right
value.)
Absolute value of value in A1
Average of values in cells A1 through D5
Number of values in cells A1 through D5
Number of non blank cells in cells A1 through
A7
4 (Rounds up to the nearest even number.)
8 (Rounds down to the nearest integer.)
Greatest value of those in cells A1 through D5
Least value of those in cells A1 through D5
1 (Integer result when left value is divided by
right value.)
3 (Rounds up to the nearest odd number.)
2.2 (Rounds left value to decimal places
specified by right value.)
Square root of value in cell A1 multiplied by 5
Sum of contents of cells A1 through D5

93
Chapter 8 Pocket Sheet
Inputting Text
Text (letters and numbers) can be input into the active cell using the on-
screen text input keyboard.
• Input make up entirely of numbers (including decimal point) is treated
as a numeric value. Inclusion of even a single non-numeric character
(alpha-character or symbol) causes the input to be treated as text.
• Text is normally aligned in the cell flush left, while numbers are aligned
flush right.
• If a text string is longer than the cell, the extra text is allowed to extend
into the next cell to the right in the sheet display, as long as the
neighboring cell does not contain any data. If it does, the extra characters
are cut off in the sheet display.
• If an input value is longer than the cell that contains it, the contents of
the cell are replaced by a string of # marks. This is to let you know that
the cell contains a value, but the value cannot be displayed. If this
happens, try making the cell wider (page 100).
• If the first character in a cell is an equals sign (=), the text is considered
to be part of a mathematical expression.

94
Input Example
This section contains an example that illustrates a number of Pocket Sheet input
techniques.
Example Data
All of the operations in this section are performed using the data shown
below.
Example: To input the function below into cell C5.
=SUM(A2:B5)*C2
• This calculates the total of the values from cellA2 through cell B5, and
then multiplies it by the value in cell C2 (4).
1. Open a sheet and then tap cell C5.
2. Perform the following keys operations to input characters into the input
field.
SUM
3. Next, use the stylus to drag from cell A2 to cell B5, so all the required
cells become highlighted.
4. Remove the stylus from the screen to input the range of selected cells
into the input field.
5. Tap in the input bar to the right of the close parenthesis to move the
cursor there.

95
Chapter 8 Pocket Sheet
6. Type *into the input field.
7. Tap cell C2.
8. Tap any cell or the NEXT button to display the calculation result.
• The value in cell C5 shows the result of the function.
Controlling the Appearance of a Cell
This section explains how to make cell format settings that control the format of
data inside individual cells or a range of cells. The format settings are: numeric
value category (monetary unit, percent), number of decimal places, alignment,
text style (bold or normal), comma separators for values, and cell lock.
Changing the Format Settings of a Cell
1. Make the cell whose format you want to change the active cell (page
87).
• You can select a single cell or a range of cells.
2. Tap the Menu Bar icon to display the menu bar, and then tap Option –
Formats to display the Formats tab.

96
3. Make the format settings you want.
• See the following sections for information about the settings you can
make on the Formats tab.
4. After making the settings you want, tap Set to apply them.
• Tapping Esc exits the Formats tab without applying any changes you
have made in the settings.
Category
• Tap the Larrow next to Category box to display a list of numeric
value categories.You can specify whether a number should be treated as
simply a numeric value, a monetary value, or a percent. The following
shows the available settings and their meanings.
• For the monetary units and percent, the applicable symbol is appended
automatically to the value in the cell.
• When percent is selected as the category setting, a value of 0.1 becomes
10%, 1 becomes 100%, 10 becomes 1000%, etc.
Category Setting
None
%
$
£
¥
Description
•Numeric value (no setting)
•Percent
•Dollar value
•British pound value
•Japanese yen value
•Euro value

97
Chapter 8 Pocket Sheet
Edit
• Tap this button to display the euro currency symbol editing screen shown
below.
• Note that you can edit the euro currency symbol only. The symbols for
the other currencies are fixed.
• Use the on-screen keyboard to type up to three letters for the currency to
which you want to change. You could input DEM for German marks,
FRF for French francs, etc. After inputting the letters you want, tap Set
to save them.
• The letters you input above replace the euro symbol in the Category
list.

98
Decimal Places
• Tap the Larrow next to the Decimal Places box to display a list of
decimal place settings.You can specify anywhere from 0 to four decimal
places. Selecting Free specifies a free-floating decimal place, which
means the decimal point is located wherever you input it.
Alignment
• Tap the Larrow next to the Alignment box to display a list of alignment
settings. You can select from among General, Left, Center, and Right.
Selecting General causes text to be aligned left, and numbers aligned
right.
Bold
• Tap the check box to toggle bold text on (checked) and off (unchecked).
Comma
• Tap the check box to toggle comma separators every three digits on
(checked) and off (unchecked).