Nokia 9290 User's Guide download pdf (Page 229)

211

Office

To confirm what you have entered into a cell, press Enter, OK, or go to another cell

with the Arrows key. To dismiss the action, press Esc or Cancel.

You can also enter a formula to perform operations on worksheet data. Sheet

application provides some predefined, or built-in, formulas, which are known as

functions.

To insert a function, press Insert function. A dialog opens. See Figure 87.

The function categories you can choose from are as follows: All, Financial,

Date and time, Mathematical, Statistical, Lookup, Text, Logical, and Information.

Each category has a set of functions, which you can see from the list next to

Function name. Select the function you want and press Close.

Figure 87

Example: You might want to

sum up figures in cells C2 to

C4 in cell C5; select cell C5,

press Point reference and

select the cell range from C2

to C4. Press Enter or OK to

confirm the action. The SUM

will now appear in C5.

In a formula, you can enter constant values or cell references. A cell reference tells

Sheet where to look for the values or data you want to use in the formula. To enter

a reference to a cell or cells in a formula:

1 Go to the cell you want to edit, and press Edit.

2 Move the cursor to the place where you want to insert a reference, and press

Point reference.

1 2 ... 224 225 226 227 228 229 230 231 232 233 234 ... 343 344

No comments

Nokia 9290 User's Guide Page 229