Loading ...
Loading ...
Loading ...
To cut and paste spreadsheet data
1. Move the cursor to the cell whose data you want to cut and then press
(Cut & Paste).
• This enters paste standby. To cancel paste standby, press .
2. Move the cursor to the cell into which you want to paste the data you
just cut, and then press .
• Pasting data simultaneously deletes the data from the cell where you
performed the cut operation, and automatically cancels paste
standby.
Note: In the case of a cut and paste operation, cell references do not
change when pasted, regardless of whether they are relative or absolute.
To copy and paste spreadsheet data
1. Move the cursor to the cell whose data you want to copy and then press
(Copy & Paste).
• This enters paste standby. To cancel paste standby, press .
2. Move the cursor to the cell into which you want to paste the data you
just copied, and then press .
• Paste standby remains enabled until you press , so you can paste
the copied data to other cells, if you want.
Note: When you copy the contents of a cell that contains a formula with a
relative reference, the relative reference will change in accordance with the
location of the cell where the contents are pasted.
To delete input data from a specic cell
Move the cell cursor to the cell whose contents you want to delete and then
press .
To delete the contents of all the cells in a spreadsheet
Press (Delete All).
Using Variables (A, B, C, D, E, F, M, x, y)
You can use to assign the value of a cell to a variable. You can also use
(RECALL) to input the value assigned to a variable into a cell.
Using Spreadsheet Mode Special Commands
In the Spreadsheet Mode, the commands below can be used inside
formulas or constants. These command are on the menu that appears when
you press .
Min(
Returns the minimum of the values in a specified range of cells.
Syntax: Min(start cell:end cell)
Max(
Returns the maximum of the values in a specified range of cells.
Syntax: Max(start cell:end cell)
Mean(
Returns the mean of the values in a specified range of cells.
Syntax: Mean(start cell:end cell)
Sum(
Returns the sum of the values in a specified range of cells.
Syntax: Sum(start cell:end cell)
Ex 3: Continuing from Ex 1, input the formula =Sum(A1:A3), which
calculates the sum of cells A1, A2, and A3, into cell A4.
1. Move the cell cursor to cell A4.
2. Input =Sum(A1:A3).
33
Loading ...
Loading ...
Loading ...