Page 26 - iPro_trackGPT_V5_Class8
P. 26

To use the mathematical functions in Excel, follow the given steps:




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


                          Tech Tweak

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



                  After pressing Enter key, the price of the pencils will display in cell D3. You can then use the
                  AutoFill feature to quickly calculate the prices for the Geometry Boxes and Pens.




                                                                                            4  To calculate the tax, type
                                                                                           the =PRODUCT(D6,C7)
                                                                                           function in cell D7 and press
                                                                                           the Enter key.



                        3  To calculate the subtotal, type   5  To calculate the total bill, type
                       the  =SUM(D3:D5) function  in      the =SUM(D6:D7) function in cell
                       cell D6 and press the Enter key.   D8 and press the Enter key.


                  Text Functions


                          Function                     Purpose                              Example
                   CONCATENATE(text1,  It joins together two or more  Input: =CONCATENATE(“Track”, “GPT”)
                   text2)                   different text strings.          Output: TrackGPT
                                            It   returns   the    specified  Input: =LEFT(“Track”,3)
                   LEFT(text, num_chars)    number  of characters  from  Output: Tra
                                            the left side of the text string.
                                            It returns the specified number  Input: =RIGHT(“Track”,3)
                   RIGHT(text, num_
                                            of characters from the right  Output: ack
                   chars)
                                            side of the text string.
                                            It  returns  the  length  of  the  Input: =LEN(“Track”)
                   LEN(text)
                                            text string.                     Output: 5

                                            It converts the text string into  Input: =UPPER(“Track”)
                   UPPER(text)
                                            uppercase.                       Output: TRACK
                                            It converts the text string into  Input: =LOWER(”Track”)
                   LOWER(text)
                                            lowercase.                       Output: track







                    24    TrackGPT iPRO (V5.0)-VIII
   21   22   23   24   25   26   27   28   29   30   31