Youtube Android,Blogging SEO & Whatsapp Tricks

What Does It 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,Date command the format can be changed.

What Does It 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 type the number, such as =COUNTIF(A1:A5,100)

To match a piece of text type the text in quotes, such as =COUNTIF(A1:A5,"Hello")

To match using operators surround the expression with quotes, such as =COUNTIF(A1:A5,">100")

Formatting

No special formatting is needed.

What Does It Do ?
This function counts the number of blank cells in a range.

Syntax

=COUNTBLANK(RangeToTest)

Formatting

No special formatting is needed.

Example

The following table was used by a company which was balloting its workers on whether the company should have a no smoking policy.
Each of the departments in the various factories were questioned.
The response to the question could be Y or N.
As the results of the vote were collated they were entered in to the table.

The =COUNTBLANK() function has been used to calculate the number of departments which
have no yet registered a vote.

What Does It 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

No special formatting is needed.

Example

The following table was used by an Import / Exporting company to convert the weight and size of packages from old style UK measuring system to European system.

Abbreviations

This is a list of all the possible abbreviations which can be used to denote measuring systems.

These characters can be used as a prefix to access further units of measure.
Using "c" as a prefix to meters "m" will allow centimetres "cm" to be calculated.

What Does It 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.

Example

The following table was used by a school to keep track of the examinations taken by each pupil.
Each exam passed was graded as 1, 2 or 3.
A failure was entered as Fail.

The school needed to known how many pupils sat each exam.
The school also needed to know how many exams were taken by each pupil.

The =COUNTA() function has been used because of its ability to count text and numeric entries.