Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 52 - 2620_Birla Open Mind C-6
P. 52

    Perform the following steps to use the mathematical functions:
                  In the given example, when you type the formula =PRODUCT(B3:C3) in cell D3 and press the Enter key,
                  price of the pencils appears in the cell D3. Using the AutoFill feature, we can calculate the prices of the
                  Geometry Boxes and Pens in cells D4 and D5.

                                                                                         To calculate the price
                                                                                         of Pencils, type the
                                  Type  the  given                                       =PRODUCT(B3:C3) function
                              1   data in the  Excel                                     and press Enter key.         2
                                  worksheet.

                           3   Drag the Fill  Handle
                               of Cell D3 to D5.
                                                                                              Calculate
                                                                                              the Tax by
                                                                                              using the
                                                                                              =(D6*7)/100    5
                                                                                              formula.

                          To calculate the subtotal, type the     Calculate  the  Total  by
                      4   =SUM(D3:D5) function and press      6   using the =SUM(D6:D7)
                          Enter key.                              function.

                  Statistical Functions

                  Excel offers a wide range of statistical functions to analyze data effectively. Here are some commonly
                  used statistical functions in Excel:

                                            It returns the largest value from the values passed  Input: =MAX(4,16,12,9)
                   Max(range)
                                            as argument or values in the given range.            Output: 16
                                            It returns the smallest value from the values        Input: =MIN(4,16,12,9)
                   Min(range)
                                            passed as argument or values in the given range.     Output: 4
                                            It returns the average of the numbers passed as      Input: =AVERAGE(12,3,6)
                   Average(range)
                                            argument or given numbers in a range.                Output: 7

                                            It returns the count of the number of values in the   Input: =COUNT(4,8,12)
                   Count(range)
                                            selected range.                                      Output: 3

                  Text Functions
                  Text functions are used to work on the characters entered as text.
                          Functions                             Purpose                                Example

                                                                                              Input: =CONCATENATE
                   Concatenate              It joins together two or more different text      (“Touch”, “pad”)
                   (text1, text2)           strings.
                                                                                              Output: Touchpad

                                            It returns the specified number of characters     Input: =LEFT(“Touch”,3)
                   Left(text, num_chars)
                                            from the left side of the text string.            Output: Tou
                                            It returns the specified number of characters     Input: =RIGHT(“Touch”,3)
                   Right(text, num_chars)
                                            from the right side of the text string.           Output: uch

                      50  Premium Edition-VI

| 47 48 49 50 51 52 53 54 55 56 57 |