Page 24 - ThinkGPT_V2.1_C6_Flipbook
P. 24

We have already learnt in the previous class that formulas (mathematical expressions) are used to
                  perform calculations. In this chapter, we will learn more about formulas and different ways to add a
                  formula in a worksheet. We will also learn about different types of built-in functions in Excel.

                  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
                     after selecting the cell. After entering the formula, when we press the Enter key on the keyboard,
                     the result will appear.



























                       22    Premium Edition-VI
   19   20   21   22   23   24   25   26   27   28   29