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
   20   21   22   23   24   25   26   27   28   29   30