Showing posts with label Introduction to MS-Excel. Show all posts
Showing posts with label Introduction to MS-Excel. Show all posts

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.

Components of Microsoft Excel Window

CELL: is an intersection of a row and a column. It can contain various types of data, for example, number or characters. A cell is referenced by the name of the column and row. For example, the first cell A1 is in column A and row 1.

WORKSHEETS: are sheets that contain rows and columns of cells in which users can enter data in Excel.

WORKBOOKS: Contain a number of worksheets.

Workspace: Contains related workbooks.

Rows and Columns: a single cell in Excel can contain 65,536 rows and 256 columns. A single cell in Excel can contain 32,767 Characters.

Charts: enable you to graphically represent data in a worksheet. You can also create user-defined charts.

Formula Autocorrect: automatically corrects incorrect formulas in Excel. This feature of excel corrects 15 most common formula entry mistakes automatically. Excel also prompts to correct mistakes by displaying a dialog box and suggesting corrections.

Many Basic feature of MS Office applications are present in Excel. For example,
 Menu bar and Toolbars
 Shortcut menus
 Pop-up and drop down menus
 Cut, copy and paste, drag and drop features.

Range Finder: uses coloured co-ordinated frames to indicate the cells that are referenced in a given formula if the cell in which the result of the formula is displayed is clicked. You can drag the frames and adjust the references of the formula.

Natural language formulas: enable you to use user-defined names of columns in formulas.

Auto correct and spell check: automatically corrects common typing, spelling and grammatical errors. It also lets you perform a spell check on the worksheet.

Starting work in ms-excel

By selecting the menu from the start button as follows:


Start ....> Programs ........> Microsoft Excel