Page 48 - TP_Plus_v4_Class6
P. 48

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: =MAX(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



                  46  Plus (Ver. 4.0)-VI
   43   44   45   46   47   48   49   50   51   52   53