Page 25 - Trackpad_ipro 4.1_Class8
P. 25

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












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


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






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



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

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

                 Text Functions


                            Function                        Purpose                            Example

                                                                                  Input: =CONCATENATE(“Track”,
                                                 Joins together  two  or more
                  CONCATENATE(text1, text2)                                       “pad”)
                                                 different text strings
                                                                                  Output: Trackpad
                                                 Returns the specified number  Input: =LEFT(“Track”,3)
                     LEFT(text, num_chars)       of  characters  from  the  left   Output: Tra
                                                 side of the text string

                                                 Returns the specified number  Input: =RIGHT(“Track”,3)
                    RIGHT(text, num_chars)       of characters  from the right    Output: ack
                                                 side of the text string

                                                 Returns the length of the text  Input: =LEN(“Track”)
                            LEN(text)
                                                 string                           Output: 5





                                                                             Spreadsheet—Functions and Charts    23
   20   21   22   23   24   25   26   27   28   29   30