Page 20 - iPro_trackGPT_V5_Class8
P. 20
After typing the formula into the cell, press the Enter key. Then, the cell will display the result
of the formula.
Enter the Formula in the Formula Bar: Start by clicking on the Formula bar above the
worksheet, then type an equal sign (=) followed by the formula. This method allows the
formula to be entered and edited outside the cell.
After typing the formula into the cell, press the Enter key. Then, the cell will display the result
of the formula.
CELL REFERENCING IN FORMULAS AND ITS TYPES
A cell reference is the address of a cell that you can use in a formula to show a specific cell. A
formula might also use other cell references. The formula's result depends on the values in those
cells. If you change the values in the referenced cells, the formula's result will automatically
change.
To see how this works, follow the given steps:
1 Enter 10
in cell A1. 3 Type =A1*2
in the Formula
bar and press the
2 Click on Enter key.
cell A2.
If you change the value in cell A1, the value in cell A2 will change as well.
Cell references make it easier to work with formulas, especially for
complex ones. Excel uses three types of cell references: Relative, Absolute,
and Mixed.
18 TrackGPT iPRO (V5.0)-VIII

