MS-Excel

Basics of Ms-Excel

Introduction:

Spreadsheet Program, in computer science, an application program commonly used for budgets, forecasting, and other finance-related tasks. In a spreadsheet program, data and formulas to calculate those data are entered into ledger like forms (spreadsheets or worksheets) for analysis, tracking, planning, or "what-if" evaluations of the impacts of real or proposed changes on an economic strategy. Spreadsheet programs use rows and columns of cells; each cell can hold text or numeric data or a formula that uses values in other cells to calculate a desired result. To ease computation, these programs include built-in functions that perform standard calculations. Depending on the program, a single spreadsheet can contain anywhere from thousands to millions of cells. Some spreadsheet programs can also link one spreadsheet to another that contains related information, and can update data in linked spreadsheets automatically. Spreadsheet programs may also include macro facilities, and some can be used for creating and sorting databases. For printed output, spreadsheet programs usually provide graphing capabilities and a variety of formatting options for both printed pages and text, numeric values, and captions and legends in graphs.

Some of the spread sheet programs are : Lotus 1-2-3, Quattro Pro

Examples :

wpe28.jpg (46751 bytes)
(Figure 1.1)



wpe29.gif (21237 bytes)
(Figure 1.2)


wpe2A.gif (9365 bytes)
(Figure 1.3)

Back to Index