User Manual

FCC DRAFT
Example: If you want to compare and calculate
different loan rates, you can set the number
format to Percentage.
Work with cells
To edit a cell, select a cell and Options > Show cell field >
Edit cell field. An upper part editing field opens. Start
entering the data, and select Done when you finish
editing.
To insert cells, select the area where you want to insert
new cells and Options > Cells > Insert. You can insert cells
above (Shift cells down) or to the left (Shift cells right) of
the selected range. If you select only one cell, only one
new cell is inserted. If you select a range of cells, a
corresponding range of blank cells is inserted. You can
also insert a new row or column.
To clear contents or format from cells, select the cells and
Options > Cells > Clear. If you select Formats, the
formatting of the selected cells is removed, but the
content remains. The default style is used. If you select
Content, the content of the selected cells is deleted, but
the formatting stays the same. You can also remove both
formatting and contents of the selected cells.
To delete cells, rows, or columns, select the items you
want to delete and Options > Cells > Delete. You can delete
an entire row or column. If you select Shift cells left, the
selected cells are deleted, and the cells right of the
selected cells are shifted left. If you select Shift cells up,
the cells below the deleted cells are shifted up.
Tip: When you delete information on which a
chart is based, the information is also removed
from the chart.
Insert functions
Functions are used for automating calculations.
To insert a function into a cell, select a cell. Select
Options > Insert > Function and a function from the list.
#MIN finds the lowest value in the numeric contents of a
selected range of cells, #AVERAGE calculates the average
of the values, and #SUM adds the values together. Once
you have selected a function, press the joystick. The
function is inserted into the selected cell. On the
worksheet, enter the cells you want to include in the
function inside the brackets, and press the joystick.
Tip: Before inserting a function, verify that
Options > Show cell field > Edit grid is active and
that the selected cell is empty or starts with =.
Example: You want to add up the numbers in cells
C2 to C6 and have the results appear in cell C7.
Select cell C7 and Options > Insert > Function.
Select #SUM, and press the joystick. Enter C2:C6
inside the brackets, and press the joystick. The
sum appears in cell C7.
To get more information on a function, select a cell and
Options > Insert > Function. Select a function from the list
and Options > Description.
77
Office applications
file:///C:/USERS/MODEServer/mehowell/12100235/rm-88_texas/en/issue_1/rm-88_texas_en_1.xml Page 77 Mar 9, 2006 5:37:29 PMfile:///C:/USERS/MODEServer/mehowell/12100235/rm-88_texas/en/issue_1/rm-88_texas_en_1.xml Page 77 Mar 9, 2006 5:37:29 PM