Page 86 - PlusGPT_V2.1_C7_Flipbook
P. 86

Tech Hint

                           Pressing F4 key repeatedly over a reference (cell) will allow you to switch between
                                           making the column, the row, or nothing ‘Absolute’.






                                                                                            21 st
                   Let’s PraCtiCe                                                         Century   #Critical Thinking
                                                                                            Skills
                    If the cells A1, A2 and A3 contain 30, 40 and 50 respectively, then what will be the output of
                    the following formulas:

                    1.  (A1 - A2) * A3             _______________________________________________________

                    2.  A3 + (A1 * A2)             _______________________________________________________

                    3.  A1 * (A2 + A3) – 10        _______________________________________________________



                         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 2016 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.



                  84    Premium Edition-VII
   81   82   83   84   85   86   87   88   89   90   91