Data Manipulation in MS Excel
Data Manipulation
Data manipulation involves entering, editing and formating data. Different formulae and functions can also be applied to manipulate data. User should enter somedata before manipulation.
 |
| Figure 3.10 Entering Data Both side |
Entering Data:
To enter data:
. Click a cell to select it. As user selects a cell, the cell address appear in the Name Box.
. Enter text into the cell using the keyboard. The text appears in the cell and in the formula bar as shown in the figure 3.10
. Two buttons also appear in the Formula Bar, the cancel button.
. When the user has completed typing data, it can be entered permanently into the active cell by pressing "ENTER" or by clicking the mark in the Formula Bar or
by pressing the TAB key on the keyboard.
. User can enter data anywhere in the worksheet by moving to the required cell, using the mouse or arrow keys, and typing the text.
Editing Data:
Editing data means doing any changes in it.
To Edit Data:
. Click on the cell and retype the text OR
. Go to the Formula Bar, select the incorrect text with the mouse and re-type it.
Auto Filling Data:
Auto filling is the use of the fill-handle to copy data and sequences across a range of cells. The fill-handle is at the right corner of each cell, as shown in figure 3.11.
To Fill a Range of Cells:
. Select the cell with the content to fill.
. Point at the black square that appears in the bottom right corner of the cell, until the mouse pointer becomes the fill handle.
. Click and drag in the direction of the range to fill.
Figure 3.11 shows auto filling of even numbers in Column C from 2 to 16.
Excel copies the contents of the cells across the range that user selects. This feature becomes very powerful when used with cells containing formulae.
A lot of time can be saved by copying formulae across a range of cells.
Comments
Post a Comment