Page 32 - Digicode_AI_class_6
P. 32

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


            When you press the Enter key, the price of the pencils appears in the cell D3. Using the AutoFill
            feature, we can calculate the prices of the Geometry Boxes and Pens.





















                                              3  To calculate the subtotal, type the =SUM(D3:D5)
                                              function and press the Enter key.









                                                                                      4  Calculate the Tax by
                                                                                     using the  =(D6*7)/100
                                                                                     formula.



                         5  Calculate the Total by using the =SUM(D6:D7) function.

            Text Functions


             Functions             Purpose                           Example

             Concatenate           It joins together two or more     Input: =CONCATENATE(“Digi”, “code”)
             (text1, text2)        different text strings.           Output: Digicode

                                   It returns the specified number  Input: =LEFT(“Digi”,3)
             Left(text, num_
                                   of characters from the left side   Output: Dig
             chars)
                                   of the text string.
                                   It returns the specified number  Input: =RIGHT(“Digi”,3)
             Right(text, num_
                                   of characters from the right      Output: igi
             chars)
                                   side of the text string.
                                   It returns the length of the      Input: =LEN(“Digi”)
             Len(text)
                                   text string.                      Output: 4


                30     DigiCode AI-VI
   27   28   29   30   31   32   33   34   35   36   37