Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 27 - 2629_Devagiri_C-7
P. 27

    Here:

                         $A3: The column A is fixed (absolute), while the row changes
                        when the formula is copied downward.

                         B$2: The row 2 is fixed (absolute), while the column changes
                        when the formula is copied across.

                     This way, the formula can be copied across the table to generate
                     the multiplication results correctly. So, when the formula is copied
                     to C3 to F3, the formula in each cell will adjust automatically, as
                     shown in the given figure.

                     Similarly,  when the same  row  (from B3:F3)  is copied  down to  B7:F7,  the formulas will  adjust
                     accordingly and display the results.

                            FUNCTIONS AND THEIR TYPES

                     Functions are predefined formulas designed to perform specific calculations based on the data
                     you provide. They can save time and simplify complex calculations.

                     The rules for using functions are:
                         All Excel functions must start with the = sign.

                         The function name should be a valid Excel name.                  Excel can handle up to 255

                         The  function  should  be  followed  by  opening and  closing    arguments in a single function.
                        parentheses ().

                         Most functions require at least one argument within the parentheses.
                     Excel provides many categories of functions. Let us discuss these categories in detail.

                     MATHEMATICAL FUNCTIONS

                     These are functions in Excel that perform mathematical operations, such as addition, subtraction,
                     multiplication, division and more complex calculations.

                                                                                                                      25
                                                                                                         Excel in Excel

| 22 23 24 25 26 27 28 29 30 31 32 |