#2 Ms Excel | Microsoft Office

To move from one cell to another the keyboard can also be used .

                       

                        * Enter and edit data *

Entries can be of 4 different type they are :- 

. Text :- 

Text in a cell can include any combination of letters number and keyboard symbols . A cell can contain 32767 characters . If column width prevents a text string filling visually in a cell the display extends over neigh boing cells however if the neigh boing cell are occupied the display is truncated . To store a number as a text entry use apostrophe ( , ) as the first character . 

Number :- 

Number include digit from 0 to 9 and some special characters like &,%,+,-,/,() etc . Date and time are stored as number . if 8-15 is entered in a cell excel will display it as 15-aug when an unformatted number does net fit in a cell it is displayed in scientific nolation when a formatted number does not fit in cell #### is displayed . 

Logical values :- 

Logical are entries TRUF and FALSF ( uppercase only ) can be entered in the cells . 

. Formulas :- 

Formulas are entered into the cell to perform calculations . A formulas begins with an equal sign (=) . After completing the formula entry the result of  formula will be displayed in the cell and the formula will be displayed in the formula bar . If the formula entered is wrong error values are stored in the cell .   in functions which    used to perform some calculations are also treated as a formula entry . 

To make any entry in the cell :- 

Select a cell type the content of cell . Press enter or press arrows  keys or click on any other cell to complete the entry .

To Edit the Cell Content :-

Click on the formula bar ( which displays the active cell content ) . Make the correction and press enter to delete the cell content click on the cell and press delete .

Range of Cell :-

Range is a group of cell of ( also called as a block ) selected generally to make the cell formatting to specify a range of cells using the mouse click and drag from the middle of cell ( the mouse pointer should return to doctor's + symbol ) . In the following example the cell F4 to F7 are selected that is the block is F4 to F7 written as F4 ; F7 ( use a single dot or double dot last cell address in a range ) .