Wednesday, March 31, 2010

Entering Data into Excel Spreadsheets ...

 To open a new workbook click on the new option, in the File menu- a new workbook is opened.

 Move the mouse pointer to the cell in which you want to enter the data.

 Double click on the cell or press F12.

 Start typing in the cell. As you type in the cell , the contents of the cell appear in the Formula Bar of Excel.

 After completing the entry, press the enter key. The pointer moves to the next row of the same column.

FUNCTIONS:

 Move the mouse pointer to the cell in which you want the to be displayed.

 Type = (

 Drag the mouse pointer from the first to the last cell in the range of cells that have to beaded.

 Type )

 Press enter.

The sum of the selected range of cells is displayed in the cell.

SAVE A WORKSPACE:

 Open the workboks you want to save under one category.
 Click on the Save Workspace option in the File menu.
 Enter the name of the workspace in the file name field.
 Browse to the folder in which you want to create the workspace.
 Click on the Save Button.

No comments:

Post a Comment