Page 23 - Trackpad_ipro 4.1_Class8
P. 23

Note that, to link cells between external workbooks, select the workbook, then the worksheet,
                 and finally the cell you want to reference.

                     CUSTOMISE WORKSHEET TAB

                 To customise the worksheet tab, follow the given steps:



                                2  Click on the Rename to rename
                                the sheet, Tab Color to select a tab
                                colour, or Delete to delete the sheet.


















                          3  Type in the name or select a colour           1  Right-click the sheet that you
                         you would like for your sheet.                   want to customise.


                 The name or colour of the sheet will be changed.

                 You can also use Insert, Delete, and Move or Copy options to add a new sheet, delete a sheet,
                 and move or copy a sheet, respectively.

                     FUNCTIONS

                 Functions are predefined formulas in Excel to perform both simple and complex calculations. They
                 accept arguments and return values. Arguments are input given to the functions. These arguments
                 can  be  numbers  or text.  The values should  be given in  between the opening  and closing  ( )
                 parenthesis.
                 These are some rules to be followed for using functions:

                    All Excel functions must begin with the = sign.
                    The function name must be a valid name.
                    The function must be followed by opening and closing parenthesis.
                 Categories of Functions


                 Excel provides several categories of functions to help users perform various tasks ranging from
                 simple calculations to complex data analysis. Some of them are as follows:
                    Mathematical Functions: These functions perform basic mathematical operations, such as
                    addition, subtraction, multiplication, division, etc.

                    Statistical Functions: These functions are used for statistical analysis and include measures
                    of central tendency, distribution, probability, etc.



                                                                             Spreadsheet—Functions and Charts    21
   18   19   20   21   22   23   24   25   26   27   28