Page 32 - Computer Genius Class 06
P. 32

n  unctions   e can also use the cell address in place o  the  alues.



                  When you press the Enter key, the price of the pencils appears in the cell D3.  sing 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  ey.










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



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

                  Text Functions


                        Functions                    Purpose                                Example
                   Concatenate           It joins together two or more     Input: =CONCATENATE(“Digi”, “code”)
                    te t1  te t2         different te t strings.           Output: Digicode

                                          t returns the specified num er  Input: =LEFT(“Digi”,3)
                    e t te t  num
                                         of characters from the left side   Output: Dig
                   chars)
                                         o  the te t string.
                                          t returns the specified num er  Input:      T   igi
                    ight te t  num
                                         of characters from the right      Output: igi
                   chars)
                                         side o  the te t string.
                                         It returns the length of the      Input: =LEN(“Digi”)
                    en te t
                                         te t string.                      Output: 4


                      30     Computer Genius-VI
   27   28   29   30   31   32   33   34   35   36   37