Skip to main content

Posts

Showing posts with the label Training of excel

FORMULA MS-EXCEL PART-3

STATISTICAL FUNCTION   1. MAX FUNCTION () Summary  The Excel MAX function returns the largest numeric value in a range of values. The MAX function ignores empty cells, the logical values TRUE and FALSE, and text values. Purpose  Get the largest value Return value  The largest value in the array. Syntax  =MAX (number1, [number2], ...) Arguments  number1  - Number, reference to numeric value, or range that contains numeric values. number2  - [optional] Number, reference to numeric value, or range that contains numeric values. Usage notes  The MAX function can be used to return the largest value from a set of data. For example, the slowest time in a race, the hightest temperature, or the top sales number. Arguments can be provided as constants, or as cell references or ranges, for example: = MAX ( 5 , 10 ) = MAX ( A1 , A2 , A3 ) - MAX ( A1:A10 ) ...

FORMULAS IN EXCEL

                                        FORMULA BAR Functions are predefined formulas that perform calculations on specific values,  called arguments. Each function takes specific types of arguments, such as text, numbers, logical values, references etc.   You can enter the arguments, enclosing them in parentheses. i.e ( ) after the function name. Excel includes many functions that can be divided into the following categories :-                                            MATHEMATICAL FUNCTION   1.SUM () 2.ROUND() 3.ROUNDDOWN() 4.ROUNDUP() 5.ABS N() 6.SQRT() 7.TRUNC() 8.SUM IF() 9.ODD() 10.EVEN() 11.POWER()                         ...

DIFFERENT OPERATORS IN MS-EXCEL

                                    OPERATORS   Operators are used in formulas to execute operations on the values taken by formulas.  Excel use 4 types of operators : 1.Arithmetic Operators 2.Text Concatenation Operators  3.Comparison Operators  4.Reference Operators  www.ebeescorp.com Arithmetic Operators This operation will explained through example Example  Text Concatenation Operators   This operation will explained through example Example  Comparison Operators  To compare values you can create formulas using comparison operators. These operators return a TRUE or FALSE result depending how the formula evaluate the condition .Some common operator are as follow: Reference Operators  Reference operators enable you to combine absolute and relative references and na...