Learning Computer Skill Blog

EBEES INFOTRAIN CONSULTANCY SERVICES PVT. LTD. 1. SUM :  Summary  The Excel SUM function returns the sum of values supplied. These values can be numbers, cell references, ranges, arrays, and constants, in any combination. SUM can handle up to 255 individual arguments. Purpose  Add numbers together Return value The sum of values supplied. Syntax  =SUM (number1, [number2], [number3], ...) Examples In the example shown, the formula in D12 is: = SUM ( D6:D10 ) // returns 9.05 2.Round() :  Summary  The Excel ROUND function returns a number rounded to a given number of digits. The ROUND function can round to the right or left of the decimal point. Purpose  Round a number to a given number of digits Return value  A rounded number. Syntax  =ROUND (number, num_digits) Arguments  number  - The number to round. num_digits  ...

                                    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...