Page 83 - TGPT_V5.0_C5_Flipbook
P. 83

Factbot

                  Excel follows BEDMAS rule for doing mathematical calculations, where B stands for Brackets, E for
                  Exponentiation, D for Division, M for Multiplication, A for Addition and S for Subtraction.


                 Copying a Formula

                 There are two methods to copy a formula:

                 Using the Fill Handle

                 Step 1:  Select the cell that contains the formula, then position the mouse pointer over the
                         lower-right corner of the cell until the black cross (+) appears.
                 Step 2:  Drag the fill handle over the cell or cells to which you want to copy the formula, then
                         release the mouse button.


                                                                     Hintbot


                                            To calculate the sum of adjacent cells: press the
                                              Alt + = keys together after selecting the cells.



                 Using Copy and Paste

                 Step 1: Select the cell that contains the formula, and click on the Copy command.

                 Step 2: Select the cell or cells that you want to copy it to.
                         a.  To copy the formula and any formatting, click on the Paste command.

                         b.   To  copy  the  formula  only,  on  the  Home  tab,  click  on  drop-down  arrow  of  Paste
                             command and select Paste Special, and then select Formulas and click on OK button.


                          Double Tap                                                   Century   #Technology Literacy
                                                                                          21 st
                                                                                         Skills  #Flexibility
                        Write T for True and F for False.
                        a.  Excel makes calculations easier.
                        b.   We can apply all types of mathematical operations like addition, subtraction,
                           multiplication and division in Excel.


                        c.  The input of =25+B2 will give an error message.




                                                                                     Editing Cell Contents in Excel 2021  81
   78   79   80   81   82   83   84   85   86   87   88