Page 24 - iprime_V2.2_class8
P. 24

FUNCTIONS

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


                  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.
                      Text Functions: These functions are used for manipulating text strings, such as combining,
                     trimming, changing the case of text, etc.

                      Logical Functions: These functions are used to perform logical tests and return logical values
                     (TRUE or FALSE).
                      Date and Time Functions: These functions help work with dates and times, allowing users to
                     extract and manipulate date and time information.

                      Lookup  and Reference Functions: These functions are  used to search  for and  return
                     information from a specific range or table.
                      Financial Functions: These functions are used for financial calculations, such as those involving
                     interest rates, loan payments, investments, depreciation, etc.

                      Information Functions: These functions return information about the data or the format,
                     location, or content of a cell.
                  Mathematical Functions


                           Functions                          Purpose                             Example

                                               Adds up all the numbers in a  Input: =SUM(4,8,12,16)
                          SUM(range)
                                               specified range                         Output: 40

                                               Multiplies the numbers in a specified   Input: =PRODUCT(4,2,8)
                       PRODUCT(range)
                                               range                                   Output: 64





                  22     iPRIME (Ver. 2.2)–VIII
   19   20   21   22   23   24   25   26   27   28   29