Entering DataThis section covers
Saving An Excel
Workbook First-Time
To enter data in a cell
You may also use the arrow keys on the keyboard to accept the data and move by one cell in the direction of the arrow.
The Tab key has the same effect as the Right Arrow key.
To cancel an entry while typing (i.e. before pressing Enter), press the Esc key.
If
you have already pressed Enter, use Edit --> Undo to cancel
the entry. You may also use
the Undo 
button on
the Formatting Toolbar.
|
Important A cell may not always display all the data it contains. The display of data depends on the cell width and the formatting used for that cell.
The Formula Bar, however, always shows the entire content of the active cell. |
When we enter text data in a cell, the following rules apply
|
Alignment: |
Texts are automatically left aligned. |
| Font: | A 10 point Arial font is used by default. |
| Visual Truncation: | If the length of the data exceeds the cell width, the text appears to overflow into the next cell. However, if the next cell is not empty, the data looks truncated. |
|
Wrapping: |
Text does not wrap, unless explicitly specified. |
| Auto Completion: | If the first few characters, entered in the current cell, uniquely match with the text already existing in another cell in the same column, Excel fills the remaining characters for you. This is called the auto completion feature of Excel. (You have the option of ignoring this feature and typing your own data). |
The rules for numeric data are as follows:
| Alignment: | By default, numeric data are right-aligned. |
| Precision Limit: | Numbers are stored with a maximum precision of 15 digits. If a number has more than 15 significant digits, the extra digits are converted to zero. |
| General Format: | |
| Integers: |
Excel automatically adjusts the column width to accommodate up to 11 digits. If the data is longer than 11 digits, Excel uses Scientific (Exponential) Notation. For example, if the number is 1234567890123, it will be shown as 1.23457E+12. |
| Numbers Containing Decimal point: | For presentation, Excel rounds off these numbers to fit in the cell. The cell width is increased up to 11 digits, depending on the size of the integer part of the number. For a bigger number, Excel uses the Scientific Notation. |
| Numbers Containing Comma, Dollar Sign, and Percent Sign: | Excel automatically adjusts the column width to fit these numbers. |
To save the workbook first time, do one of the following:
Choose File --> Save
Choose File --> Save As
Choose
the save 
button from the Standard Toolbar
Whatever option you choose, Excel brings up the "Save As" dialog
box.
The dialog box offers you a few options. You should choose
A file name
A folder, where you want to save the workbook
After you choose the file name and the folder, click on the
button to save your workbook.
|
|
|
|
|
