Page 20 - Trackpad_ipro 4.1_Class8
P. 20
DIFFERENT WAYS TO ENTER FORMULAS
There are mainly two ways to enter a formula in a worksheet:
Typing the formula directly in the cell: In this way, the formula is directly typed in the cell
after typing an equal sign as follows:
After entering the formula in the cell, when we
press the Enter key, the result of the formula will
appear in the cell:
Typing the formula in the Formula bar: In this way, we can type the formula in the Formula
bar as follows:
After entering the formula, when we press the Enter key on the keyboard, the result will
appear.
CELL REFERENCING IN FORMULAS AND ITS TYPES
A cell reference is the address of a specific cell or range of cells used in a formula to indicate
where to retrieve data from. If a formula contains references to other cells, Excel will automatically
update the result based on changes in the referenced cells.
To see how this works:
Step 1 Enter 10 in cell A1.
Step 2 Now click on cell A2.
Step 3 Type =A1*2 in the Formula bar.
Step 4 Press the Enter key.
18 iPro (Ver. 4.1)-VIII

