Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 29 - 2632_CodeMind
P. 29

    Information Literacy
                             byte Quest                                                    Technology Literacy

                           If the cells A1, A2 and A3 contain 30, 40 and 50 respectively, then calculate and write
                           the output of the following formulas:

                           1.  =(A1 - A2) * A3
                           2.  =A3 + (A1 * A2)
                           3.  =A1 * ((A2 + A3) – 10)

                           4.  =A1 / ((A3 – A1) –5)

                      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 arguments should be given in between the opening and closing ( ) parenthesis.
                      Rules for using Functions

                         All Excel functions must begin with the = sign.
                         Function name must be a valid name.
                         Function must be followed by opening and closing parenthesis.

                      Most of the functions contain an argument within it.
                      Categories of Functions

                      Excel provides the following categories of functions:
                         Statistical Functions: Calculate the maximum, minimum, average, etc. of a set of numeric data.
                          Financial Functions: Calculate interest on a loan, the number of instalment of a loan, the amount
                         of every instalment, etc.

                          Date and Time Functions: Calculate the day, month, and year of a date and the hour, minute,
                         and second of a particular time.
                          Mathematical Functions: Calculate the square root or absolute value of a number, product of
                         numbers, etc.

                          Logical Functions: Evaluate conditions such as X > 5 and give the result as true or false.
                          Text Functions: Perform 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.
                          Database Functions: Query a database based on the data contained in the database.

                          Information Functions: Provide information about a specific cell, such as the type of data it
                         contains, whether it is textual or numeric.
                          Lookup and Reference Functions: Locate specific values in specific cells.
                      Let us discuss some of these categories in detail.

                           28    Premium Edition-VI

| 24 25 26 27 28 29 30 31 32 33 34 |