Page 25 - KEC Khaitan C6 Flipbook
P. 25
WAYS TO ENTER A FORMULA IN EXCEL 2021
We can enter a formula in two ways:
ENTER A FORMULA DIRECTLY INTO THE CELL
Enter a formula into the cell after typing an equals sign. Now, press the Enter key to see the result
of the formula in the cell.
ENTER FORMULA IN THE FORMULA BAR
Select the cell and enter the formula in the Formula bar after typing an equal to sign. Now press
the Enter key to see the result.
21 st
Century #Leadership & Responsibility
Skills
“Always Enter a formula as per
BODMAS rule for accurate result.”
CELL RANGE
A group of selected cells is called a cell range. The selected cells should be in continuation to
form a range. A cell range is used to perform a calculation on multiple cells. The address of a
range is created by using the starting and the ending cell addresses separated by a colon (:)
sign. For example, if we have selected the cells from B2 to E4, then the address of the range will
be B2:E4.
Formulas and Functions in Excel 2021 23

