Style |
---|
.key { border-right: #000000 1px solid; padding-right: 1px; border-top: #000000 1px solid; padding-left: 1px; font-size: 12px; font-weight: normal; border-left: #000000 1px solid; border-bottom: #000000 1px solid; } |
The next worked example shows how to use the Cambridge Z88 to perform numerical calculations. It shows how you would analyse your monthly expenses, and discover what proportion of your income you were spending on each.
You will learn how to:
- Enter numbers and expressions into a table
- Copy expressions to save typing
- Perform calculations
- Alter the format of the numbers
...
to move up a line | |||
to move down a line | |||
| lightgrey | lightgrey | |
class | key | ||
---|---|---|---|
SHIFT | |||
Highlight | lightgrey | lightgrey | |
class | key | to move to the previous slot to the left | |
| lightgrey | lightgrey | |
class | key | to move to the next slot to the right | |
lightgrey | |||
class | key | ||
Highlight | lightgrey | to move to the left-most slot |
...
The slot B2 will be highlighted on the screen to show that you are editing an expression slot, and the cursor will move to the centre of the top line of the screen so that you can enter an expression. Type the expression
500/6
and press the Highlight
...
Move to slot C2 and press X to enter an expression. Then type
B2
and press Highlight
Effectively you have specified that you always want slots C2 to E2 to contain the same value as slot B2. So, for example, suppose you were granted a rates reduction to £400 per half-year. Move the cursor back to slot B2 and type X to display the slot's previous contents, 500/6. Delete them, by typing
...
and then type the new value:
400/6 Highlight
Not only will the value in B2 change to 66.67, but slots C2 to E2 will also change, since they refer to this value.
...
Next you are going to enter the figure 200 for the four months' mortgage payments. Type 200 into slot B3. If you forgot to type X when entering the figure, the number will appear left-aligned just as you entered it. In this case, move the cursor back to the slot and press X and then Highlight
You do not need to type the same value in slots C3 to E3; the Replicate command will do it automatically.
Select the Replicate command from the BLOCKS menu, and press Highlight
...
This says that you are going to replicate the value in slot B3 to the range of slots C3 to E3. Press Highlight
...
Note that until you press the Highlight
...
You are now going to produce monthly totals for the expenses. Enter the label TOTAL into slot A7, and press Highlight
Now press X, and enter the following expression:
sum(B2 B6)
Press the Highlight
...
Range to copy from | B7 |
Range to copy to | C7 E7 |
Press Highlight
...
Instead of typing the references B7 and E7, you can 'point to' each slot by moving the highlighted slot with the keys Highlight
...
sum(B2 E2)/$F$7 * 100
Press Highlight
This expression is built up as follows:
...
Number of decimal places | 0 |
Floating format | No |
Press Highlight
...