Support our work by doing the following :
1. Like the videos.
2. Comment on the videos giving suggestions for other videos.
3. Share the Videos Uploaded on this YouTube Channel with your friends and Family.

●▬▬▬▬▬⚜۩۞۩⚜ ▬▬▬▬●
Join these links, which can…

Manzil Institute for Competition Rajpura
Best Institute in Rajpura | Top Institute in Rajpura | Best Coaching in Rajpura | Tuition in Rajpura
competitive exam in rajpura
competitive exams in rajpura
current affairs in rajpura usefull for all competitive exams…

What Does ABS Function Do ?
This function calculates the value of a number, irrespective of whether it is positive or negative.

Syntax
=ABS(CellAddress or Number)

Formatting
The result will be shown as a number, no special formatting is needed.

Support…

You can calculate a persons age based on their birthday and todays date.
The calculation uses the DATEDIF() function.
The DATEDIF() is not documented in Excel 5, 7 or 97, but it is in 2000.

Support our work by doing the following :
1. Like the videos. …

Instead of using the AutoSum button from the toolbar,
you can press Alt and = to achieve the same result.

Move to a blank cell in the Total row or column, then press Alt and =.
or
Select a row, column or all cells and then press Alt and =.

Support our work…

What Does It Do?

This function tests two or more conditions to see if they are all true.
It can be used to test that a series of numbers meet certain conditions.
It can be used to test that a number or a date falls between an upper and lower limit.
Normally…

What Does Average Function Do ?

This function calculates the average from a list of numbers.
If the cell is blank or contains text, the cell will not be used in the average calculation.
If the cell contains zero 0, the cell will be included in the average…

What Does BIN2DEC Do ?

This function converts a binary number to decimal.
Negative numbers are represented using two's-complement notation.

Syntax
=BIN2DEC(BinaryNumber)
The binary number has a limit of ten characters.

Support our work by doing the following…

Sometimes you will need to use brackets, (also known as 'braces'), in formula.
This is to ensure that the calculations are performed in the order that you need.
The need for brackets occurs when you mix plus or minus with divide or multiply.

Mathematically…

What Does Ceiling Function Do ?
This function rounds a number up to the nearest multiple specified by the user.

Syntax
=CEILING(ValueToRound,MultipleToRoundUpTo)
The ValueToRound can be a cell address or a calculation.

Support our work by doing the following…

What Does Cell Function Do ?
This function examines a cell and displays information about the contents, position and formatting.

Syntax
=CELL("TypeOfInfoRequired",CellToTest)
The TypeOfInfoRequired is a text entry which must be surrounded with quotes " ".…

What Does Char Function Do?
This function converts a normal number to the character it represent in the ANSI
character set used by Windows.

Syntax
=CHAR(Number)
The Number must be between 1 and 255.

Support our work by doing the following :
1. Like the…

What Does Choose Function Do?
This function picks from a list of options based upon an Index value given to by the user.

Syntax
=CHOOSE(UserValue, Item1, Item2, Item3 through to Item29)

#choosefunction
#chooseformula
#excelformula
#exceltips
excel formulas…

What Does Concatenate Function Do?
This function joins separate pieces of text into one item.

Syntax
=CONCATENATE(Text1,Text2,Text3...Text30)
Up to thirty pieces of text can be joined.

Formatting
No special formatting is needed, the result will be shown…

What Does Convert Function Do ?
This function converts a value measure in one type of unit, to the same value expressed in a different type of unit, such as Inches to Centimetres.

Syntax
=CONVERT(AmountToConvert,UnitToConvertFrom,UnitToConvertTo)

Formatting…

What Does Count Formula Do ?
This function counts the number of numeric entries in a list.
It will ignore blanks, text and errors.

Syntax
=COUNT(Range1,Range2,Range3... through to Range30)

Formatting…

What Does Counta Function Do ?
This function counts the number of numeric or text entries in a list.
It will ignore blanks.

Syntax
=COUNTA(Range1,Range2,Range3... through to Range30)

Formatting
No special formatting is needed.

Support our work by doing…

What Does Clean Function Do?

This function removes any nonprintable characters from text.

These nonprinting characters are often found in data which has been imported from other systems such as database imports from mainframes.

Syntax
=CLEAN(TextToBeCleaned)…

What Does Code Function Do?
This function shows the ANSI value of a single character, or the first character in a piece of text.
The ANSI character set is used by Windows to identify each keyboard character by using a unique number.
There are 255 characters…

What Does Countif Function Do ?
This function counts the number of items which match criteria set by the user.

Syntax
=COUNTIF(RangeOfThingsToBeCounted,CriteriaToBeMatched)
The criteria can be typed in any of the following ways.
To match a specific number…

What Does Date Function Do?
This function creates a real date by using three normal numbers typed into separate cells.

Syntax
=DATE(year,month,day)

Formatting
The result will normally be displayed in the dd/mm/yy format.
By using the Format,Cells,Number…