Page 20 - TP_iPlus_V2.1_Class8
P. 20
i + 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, press the Enter key. When the Enter key is pressed, 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.
i + CELL REFERENCING IN FORMULAS AND ITS TYPES
A cell reference refers to a cell or a range of cells on a worksheet that can be used to find the
values or data. The main benefit of using a cell reference is when the data present in referenced
cell(s) in another worksheet changes, a value returned by the cell reference is automatically
updated.
Cell Reference refers to:
• Data from one or more contiguous cells on the worksheet
18
iPlus (Ver. 2.1)-VIII

