Filter
Top Products
Copyright © 2004 Nokia. All rights reserved.
145
Office
To insert a function, press Insert function. A dialog opens. See Figure 79. 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 78
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.
3 Select the cells that contain the values you want to use. See ‘To select cells’ on
page 135. The focus remains in the cell you are editing. Press Enter or OK to
confirm the action.
Figure 79
LindaDeepak_ri.fm Page 145 Monday, September 27, 2004 2:34 PM