Page 54 - TP_Prime_v2.2_Class_6
P. 54

Customise Worksheet Tab


                  Perform the following steps to customise worksheet tab:

                  Step 1:   Right-click the sheet tab that you want to customise.

                  Step 2:   Click on Rename to rename the sheet or Tab Color
                            to select a tab colour or Delete to delete the sheet.
           Prime (Ver. 2.2)-VI  Step 3:   Type in the name or select a colour you would like


                            for your spreadsheet.

                  Step 4:   The  information  will be added to the tab at the
                            bottom of the spreadsheet.


                  You can also use the Insert, Delete, and Move or Copy options          Customising Worksheet Tab
                  to add a new sheet, delete a sheet, and move or copy a sheet respectively.
          52
                    Functions



                  Functions are predefined formulas in Excel to perform both simple and complex calculations.

                  These accept arguments and return values. Arguments are input to the functions. These
                  arguments can be numbers or text. The values should be given in between opening and
                  closing ( ) parenthesis.




                    Rules for using Functions

                  Some rules for using the functions are:
                  • All Excel functions must begin with the = sign.

                     Function name must be a valid Excel name.

                     Function must be followed by opening and closing parentheses.
                     Most of the functions must contain an argument within them.


                    Categories of Functions

                  Excel provides the following categories of functions:

                  •  Mathematical  Functions: Calculates  the square root or absolute value of a number,
                    product of numbers etc.

                     Text Functions: Performs a number of operations on strings (i.e. a collection of characters
                    like 'hello', 'friend', 'computer', etc.) such as finding the length of a string, joining two

                    strings, searching for one string inside another, etc.
   49   50   51   52   53   54   55   56   57   58   59