Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 24 - 2615_KEC
P. 24

    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.

                       22   Premium Edition-VI

| 19 20 21 22 23 24 25 26 27 28 29 |