Work With Cells; Insert Functions - Nokia E70 User Manual
Nokia cell phone user guide
Hide thumbs
Also See for E70:
- User manual (209 pages) ,
- Manual del usuario (109 pages) ,
- Service manual (20 pages)
Table of Contents
Advertisement
O f f i c e a p p l i c a t i o n s
Tip: To switch between the full and normal screen views, press *. To zoom in, press 5; to zoom out, press 0.
To add a comment to the selected cell, select
The cell is marked with a small triangle in the upper right corner of the cell.
To keep rows visible when scrolling, select a cell below the area that you want to remain visible and
options
Freeze
panes. To keep columns visible, select a cell to the right of the area that you want to remain visible and
>
Options
Advanced options
>
To change the size of rows and columns, select
To sort rows from left to right, select the cells you want to sort and
number of the row to use as a primary sorting criteria. You can change the direction of the sorting order and ignore or match
the case sensitivity.
To sort columns from top to bottom, select the cells you want to sort and
select the column to use as a primary sorting criteria. You can change the direction of the sorting order and ignore or match
the case sensitivity.
To format a font style, select the cells whose font style you want to modify and
font type, size, text color, and background color of the cell.
To change a font formatting, select the cells you want to format and
underline, strikethrough, or position the text in superscript or subscript format within a cell.
To align cell contents, select the cells whose alignment you want to modify and
both the horizontal and vertical alignment and wrap text to adjust the row height of the selected cells to display the entire
content of a cell.
To format cell borders, select the cells whose borders you want to modify and
or only vertical, horizontal, upper, lower, left or right borders. Select
To change the number format, select the cells whose number format you want to modify and
Select the number format from the list. If the format you select includes decimal values, enter a number from 0 to 12 to indicate
the decimal place.
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
and select
Done
when you finish editing.
To insert cells, select the area where you want to insert new cells and
cells
down) or to the left
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
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
or column. If you select
Shift cells
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
finds the lowest value in the numeric contents of a selected range of cells,
#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
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
>
The sum appears in cell C7.
Copyright © 2006 Nokia. All Rights Reserved.
Options
Freeze
panes.
>
Options
Options
Show cell field
>
(Shift cells
right) of the selected range. If you select only one cell, only one new cell is inserted. If you
left, the selected cells are deleted, and the cells right of the selected cells are shifted left. If
Options
> Function. Select #SUM, and press the joystick. Enter C2:C6 inside the brackets, and press the joystick.
Advanced options
Insert
>
>
Cell size
Row height
>
>
Options
>
Options
Options
>
Options
>
Edit cell
field. An upper part editing field opens. Start entering the data,
>
Options
Options
Cells
> Clear. If you select Formats, the formatting of the
>
Options
Insert
Function
>
>
#AVERAGE
Options
Show cell field
>
66
comment. Write a comment, and select OK.
Options
or
Column
width.
Advanced options
Sort
>
Advanced options
>
Options
Format
> Font. You can change the
>
Format
Font
formatting. You can bold, italicize,
>
Options
Format
> Alignment. You can change
>
Options
Format
> Borders. You can modify all
>
Change
to edit the style and color of the borders.
Options
Cells
> Insert. You can insert cells above
>
Cells
> Delete. You can delete an entire row
>
and a function from the list. For example,
calculates the average of the values, and
Edit grid
is active and that the selected cell is
>
Advanced
>
rows. You can select the
Sort
columns. You can
>
Format
> Numbers.
>
(Shift
#MIN
Advertisement
Table of Contents
