Page 24 - Digicode_AI_class_6
P. 24

We have already learnt in the previous class that formulas 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
               as follows:

























            After entering the formula, when we press the Enter key on the keyboard, the result will appear.


                 22    DigiCode AI-VI
   19   20   21   22   23   24   25   26   27   28   29