Learning Resources

Data entry and types (date, alphanumeric)

The information or data we enter in a cell can be of the following types

Text entries
The text entries in Excel start with a single inverted quote (‘). The default alignment of a text entry is left. Alphanumeric entries are all taken as text entries.

Numeric entries
The numeric entries in Excel start with a number and all the characters in this type should consist of the numbers. The default alignment of the numeric entry is right.

Formula entries
The formula entry in Excel start with a plus (+) sign or an equal to (=) sign.

Date entries
The date entry in Excel is right aligned, and date when entered will change into the preset date format.