Page 49 - modular4.0
P. 49

Chapter Profile
                 In Book2, click to select cell A2. Press Enter key once you've selected cell A2 in Book2. After doing
                 this, the formula in cell A1 of Book1 should look like this: =[Book2]Sheet1!$A$2

                 This reference has 3 parts:
                 1.  The workbook Book2 in square brackets
                 2.  The worksheet Sheet1 followed by ! sign

                 3.  The cell having absolute reference
                 Hence,  referencing  cells  in  the  external  workbooks  are done  by  selecting  the  workbook,  then
                 worksheet, and then the cell you want to link reference to.

                        FUNCTIONS

                 Functions are predefined formulas in Excel to perform both simple and complex calculations. They
                 accept arguments and return values. Arguments are input to the functions. These arguments can
                 be number or text. The values should be given in between opening and closing ( ) parenthesis.


                 Rules for Using Functions
                    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 contain an argument within it.


                 Categories of Functions
                 Excel 2019 provides the following categories of functions:

                    Statistical Functions: Calculates the maximum, minimum, average, etc., of a set of numeric data.
                     Date and Time Functions: Calculates the day, month and year in a date and the hour, minute
                    and second in a particular time.
                     Mathematical Functions: Calculates the square root or absolute value of a number, product of
                    numbers etc.

                    Logical Functions: Compares conditions such as =IF(X>5) and give the result as true or false.
                     Text  Functions:  Performs  a  number  of  operations  on  strings  (i.e.  a  collection  of  characters
                    like 'hello', 'friend', 'computer', etc.) such as finding the length of a string, joining two strings,
                    searching for one string inside another etc.
                 Let us discuss some of these categories in detail.

                 Mathematical Functions

                          Function                          Purpose                             Example
                                                                                      Input: =SUM(4,8,12,16)
                  SUM(range)                  It returns the sum of a range.
                                                                                      Output: 40
                                              It multiplies the values in a range     Input: =PRODUCT(4,2,8)
                  PRODUCT(range)
                                              of cells.                               Output: 64





                                                                                              Formulas and Functions  47
   44   45   46   47   48   49   50   51   52   53   54