Entering and Editing Data in excel

In Excel there are four distinct types of data that can reside in a cell. These types of data are:

a. Text

b. Numerals

c. Logical values

d. Error

Here we discuss about the all type of data in brief.

Text: -

The behavior of the text data are following

1. Text in a cell can contain any combination of letters, numbers, and keyboard symbols.

2. A cell can contain up to 32,000 characters.

3. If column width prevents a text string from fitting visually in a cell, the display extends over neighboring cells. However, if the neighboring cells are occupied the display is truncated.

Numerals: -

As the name of the data types it is clear that this data can contain all the decimal digits such as 0 to 9 which you ca addition, subtraction, multiplication, divides and also many mathematical and statistical calculation. We are most commonly used excel for use numerical calculation.

· Date and time are also numbers but they are in a special formatting. Let after formatting a cell if u enter 1-9 as a text string. Excel will interpret this as a date and display it as 9-jan or etc

· When a unformatted number does not fit in a cell, it is displayed in scientific notation.

· When a formatted number does not fit in a cell, number signs like hash (###) are displayed.

Logical Values: -

Excel support logical values like TRUE or FALSE in to cells. Logical values are often used in writing conditional formulas. Also there are many condition and formulas which are return logical values example if you say 3 = 4 the result is FALSE.

Error: -

It is a distinct type of data. Let in a formula you are try to divide a number by zero then the result is #DIV/0

Error value, some time when you enter a formula you can see a error which is #N/A its mean the formula is not applicable in this situation.