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…

What Does Datedif Formula Do?
This function calculates the difference between two dates.
It can show the result in weeks, months or years.

Syntax
=DATEDIF(FirstDate,SecondDate,"Interval")
FirstDate : This is the…

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/ManzilInstitute/…

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/ManzilInstitute/…

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/ManzilInstitute/…

What Does DB Function Do ?
This function calculates deprecation based upon a fixed percentage.
The first year is depreciated by the fixed percentage.
The second year uses the same percentage, but uses the original value of the item less the first years depreciation.…

What Does Delta Formula Do ?
This function compares two values and tests whether they are exactly the same.
If the numbers are the same the result will be 1, otherwise the result is 0.
It only works with numbers, text values…

What Does Dmax Function Do ?
This function examines a list of information and produces the largest value from a specified column.

Syntax
=DMAX(DatabaseRange,FieldName,CriteriaRange)
The DatabaseRange is the…

What Does Doller Function Do?
This function converts a number into a piece of text formatted as currency.

Syntax
=DOLLAR(Number,DecimalPlaces)
Number : This is the number which needs to be converted.
DecimalPlaces…

What Does Dsum Function Do ?
This function examines a list of information and produces the total.

Syntax
=DSUM(DatabaseRange,FieldName,CriteriaRange)
The DatabaseRange is the entire list of information you need to examine, including the field names at the…

What Does Edate Formula Do?
This function is used to calculate a date which is a specific number of months in the past or in the future.

Syntax
=EDATE(StartDate,Months)

Formatting
The result will normally be expressed as a number, this can be formatted…

What Does EOMONTH function Do?
This function will show the last day of the month which is a specified number of months before or after a given date.

Syntax
=EOMONTH(StartDate,Months)

Formatting
The result will normally be expressed as a number, this can…

What Does Exact function Do?
This function compares two items of text and determine whether they are exactly the same.
The case of the characters is taken into account, only words which are spelt the same and which have upper and lower case characters in…

What Does Fact Function Do ?
This function calculates the factorial of a number.
The factorial is calculated as 1*2*3*4..etc.
The factorial of 5 is calculated as 1*2*3*4*5, which results in 120.
Decimal fractions of the number are ignored.

Syntax
=FACT(Number)…

What Does fixed function Do ?
This function converts a numeric value to text.
During the conversion the value can be rounded to a specific number of decimal places, and commas can be inserted at the 1,000's.

Syntax
=FIXED(NumberToConvert,DecimalPlaces,Commas)…

What Does fixed function Do ?
This function converts a numeric value to text.
During the conversion the value can be rounded to a specific number of decimal places, and commas can be inserted at the 1,000's.

Syntax
=FIXED(NumberToConvert,DecimalPlaces,Commas)…

What Does floor function Do ?
This function rounds a value down to the nearest multiple specified by the user.

Syntax
=FLOOR(NumberToRound,SignificantValue)

Formatting
No special formatting is needed.

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

What Does forecast function Do ?
This function uses two sets of values to predict a single value.
The predicted value is based on the relationship between the two original sets of values.
If the values are sales figures for months 1 to 6, (Jan to Jun), you…