Page 55 - TP_Prime_v2.2_Class_6
P. 55

Logical Functions: Evaluates conditions such as X > 5 and gives the result as true or false.

                   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 at a particular time.

                 Let us discuss these categories in detail.                                                                 FORMULAS AND FUNCTIONS IN EXCEL

                 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
                                                                                                                          53
                                              It returns the remainder after a        Input: =MOD(8,5)
                  MOD(number, divisor)
                                              number is divided by the divisor.       Output: 3

                                              It returns the square root of the       Input: =SQRT(81)
                  SQRT(number)
                                              given number.                           Output: 9


                                              It rounds  number  to an integer        Input: =INT(14.25)
                  INT(number)
                                              value.                                  Output: 14


                                              It returns the result of a number       Input: =POWER(5,3)
                  POWER(number, power)
                                              raised to some power.                   Output: 125

                  ROUND(number,               It returns a number after rounding      Input: =ROUND(35.666,2)

                  number of digits )          to the specified digits.                Output: 35.67

                                              It returns the absolute value of a      Input: =ABS(-25)
                  ABS(number)
                                              given number.                           Output: 25




                                                             Soft Hint

                              In functions, we can also use the cell address in place of the values.



                 Let us use the mathematical functions in Excel.


                 Perform the following steps to use the mathematical functions:

                 Step 1:  Type the data in the Excel worksheet as shown.
   50   51   52   53   54   55   56   57   58   59   60