- Text
- Numerals
- Logical values
- Error
Text
Text in a cell include any combination of letters, numbers and keyboard symbols.
- A cell can contain up to 32000 characters.
- If column width prevents a text string from fitting visually in a cell, the display extends over neighbouring cells. However, if the neighbouring cells are occupied, the display is shortened but the text remains in the memory.
Numerals
Numerals contain all the decimal digits, such as 0 to 9 on which you can do addition, subtraction, multiplication and other mathematical or statistical operations. Numeric calculation is the most common thing that is done with Excel 2007. Therefore, it is important to understand how Excel understands numerals.
- A number may be displayed using commas, scientific notation, or one of many built-in numeric formats. The numbers in Excel have two aspect-displaying format and the value. the display format is what you see in the cell and the value is the calculated value(which you can see in the formula bar.)
- Date and Time are numbers but with special formatting. If you try to enter 1-9 as a text string, Excel 2007 will interpret it as 9th January as a date and display it as 9-Jan.
- When an unformatted number does not fit in a cell, it is shown in the scientific notation.
- When a formatted number does not fit within a cell, number signs like hash (###) are shown.
Logical Values
You can enter the logical values, such as TRUE or FALSE into cells. Logical values are used in writing conditional formulas.There are many formulas that give the calculated result in terms of logical values. Thus, if you say 3>4, the result is FALSE because 3 is not greater than 4.
Error
An error value is a distinct type of data. For example, if a formula attempts to divide a number by zero, the result is the # Div/0! Error Value.
Nice
ReplyDelete