Page 82 - TGPT_V5.0_C5_Flipbook
P. 82

Interdisciplinary Learning

                         #Mathematics

                 Make a progress report of 10 students of your class.
                 1.  Create a new workbook.
                 2.  Enter their roll numbers, names, class, ages and subjects (Science, English and Mathematics).
                 3.  Now add two more columns for total and percentage and enter their values.

                 4.  Save the workbook with your name and close Excel.

                            Roll No.          Name              Class             Age            Subjects










                                                                                                        #Lab Activity



                   USING FORMULAS TO PERFORM CALCULATION

              Formulas in Excel begin with an equal (=) sign. When the contents of a cell begin with equal to
              sign, Excel understands that user has enter a formula here. If you don’t enter the equal sign,
              Excel will treat your entry as text and the calculation will fail.

              Different Ways to Enter A Formula


              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,
                 result of the formula appears in the cell.

                   Typing the Formula in the Formula Bar: In this way, we can type the formula in Formula
                 bar after selecting the cell. After entering the formula, when we press the Enter key from
                 the keyboard. The result will appear.






                  80  Premium Edition-V
   77   78   79   80   81   82   83   84   85   86   87