Page 26 - Trackpad_V1_Book 6_Flipbook
P. 26

MIXED CELL REFERENCING
                  A mixed cell reference refers to a specific row or column. It is basically a combination of relative

                  and absolute references. There are times when we may want a part of the cell reference to change
                  when the formula is copied.
                  In some situations, you may need to make the cell reference as a ‘Mixed’ reference, so that you
                  can lock either a column or a row by preceding it with a Dollar ($) symbol. For example, when the

                  column letter changes, the row stays constant or vice versa.

                                           Typing the formula using                             Typing the formula using
                                            a mixed cell reference                               a mixed cell reference
























                                                                               Displaying a constant result after copying
                                                                                  and pasting the formula in cell C3





                            FUNCTIONS

                  A function is a predefined formula in Excel. It starts with the = (equal to) sign. Functions are used
                  for computing complex calculations. There are many built-in functions provided by Excel. They
                  accept arguments and return values.

                  Arguments are input to the functions. The values should be given in between opening and closing
                  ( ) parenthesis. For example, SUM(A1:A5) A1 and A5 are arguments and Sum is a function.

                  Some rules for using Functions are:
                      All Excel functions must begin with = sign

                      Function name must be a valid Excel name.

                      Function must be followed by opening and closing parenthesis.

                      Most of the functions must contain an argument within it.
                  Let’s discuss the categories of function.






                   24   Trackpad (Version 1.0)-VI
   21   22   23   24   25   26   27   28   29   30   31