How to insert Hyperlink in MS Word | Insert Hyperlink in Word | Microsoft Word Tips

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…

How to insert shapes and apply format in MS Word | Insert Shapes and Apply Format in Word

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…

How to use Design Tab in MS Word | Design Tab in Microsoft Tab | Design Option in Word

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…

How to insert symbol and special character in MS Word | Microsoft Word Tips | Word Tutorial

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…

How to use layout option in Microsoft Word | Layout option in MS Word | MS Word Tips | Word Tutorial

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…

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.
4. Facebook : https://www.facebook.com/ManzilInstit...…

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.
4. Facebook : https://www.facebook.com/ManzilInstit...…

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…

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…