Page 85 - TGPT_V5.0_C5_Flipbook
P. 85

Let us use the mathematical functions in Excel.
                 Perform the following steps to use the mathematical functions:

                 When you 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.





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





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



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


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


                     Functions                            Purpose                                  Example
                                                                                         Input: =LEN(A3)
                 Len(text)             It returns the length of the text string.         Output: 6

                                                                                         Input: =UPPER(C3)
                 Upper(text)           It converts the text string into uppercase.       Output: CHIRAG SHARMA

                                                                                         Input: =LOWER(B3)
                 Lower(text)           It converts the text string into lowercase.       Output: sharma

                 Let us use the Text functions by performing the following steps:








                                                                                      Type =UPPER(C3) function
                        Type the  given                                               to convert the full name
                    1   data in the Excel                                             into uppercase and press       2
                        worksheet.                                                    Enter key.



                 When you press the Enter key, the full name appears in uppercase.



                                                                                     Editing Cell Contents in Excel 2021  83
   80   81   82   83   84   85   86   87   88   89   90