Page 46 - Plus_V2.2_C6_Flipbook
P. 46

When you press the Enter key, subtotal appears in the cell D6.

                  Step 6:  Calculate the Tax by using the =(D6*7)/100 formula.














                                      Using SUM function                          Calculating Tax
                  Step 7:  Calculate the Total by using the =SUM(D6:D7) function. Final output appears as shown:



















                                                              Displaying Total

                  Text Functions

                          Functions                           Purpose                              Example

                                                                                          Input: =CONCATENATE
                   CONCATENATE              It joins together two or more different text
                   (text1, text2)           strings.                                      (“Touch”, “pad”)
                                                                                          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

                   RIGHT(text, num_         It returns the specified number of characters  Input: =RIGHT(“Touch”,3)
                   chars)                   from the right side of the text string.       Output: uch

                                                                                          Input: =LEN(“Touch”)
                   LEN(text)                It returns the length of the text string.
                                                                                          Output: 5
                                                                                          Input: =UPPER(“Touch”)
                   UPPER(text)              It converts the text string into uppercase.
                                                                                          Output: TOUCH
                                                                                          Input: =LOWER(”Touch”)
                   LOWER(text)              It converts the text string into lowercase.
                                                                                          Output: touch

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

                  Step 1:  Type the following data in the Excel worksheet.

                  44    Premium Edition-VI
   41   42   43   44   45   46   47   48   49   50   51