Sunday, December 23, 2012

Spread Sheet

What is Mcrosoft Excel?


Microsoft Excel is a commercial spreadsheet application written and distributed by Microsoft for Microsoft Windows and Mac OS X. It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications. It has been a very widely applied spreadsheet for these platforms, especially since version 5 in 1993, and it has almost completely replaced Lotus 1-2-3 as the industry standard for spreadsheets. Excel forms part of Microsoft Office. The current versions are 2010 for Microsoft Windows and 2011 for Mac OS X.Microsoft Excel provides a grid interface to organize nearly any type of information.  The power of Excel lies in its flexibility to define the layout and structure of the information you want to manage.  Basic tasks require no special training, and Excel allows you to work with text, numbers, and date information in a relatively open and unstructured way.  Nearly 30 years after its initial introduction, Excel remains the world’s leading spreadsheet software.

Uses of Microsoft excel:



Spreadsheets are often used to store financial data. Formulas and functions that are used on this type of data include:
  • Performing basic mathematical operations such as summing columns and rows of figures.
  • Finding values such as profit or loss.
  • Calculating repayment plans for loans or mortgages.
  • Finding the average, maximum, or minimum values in a specified range of data.
Other common operations that Excel can be used for include:
  • graphing or charting data to assist users in identifying data trends.
  • sorting and filtering data to find specific information.
The information garnered in a spreadsheet can easily be incorporated into electronic presentations, web pages, or printed off in report form.
What Are Spreadsheet models?
A computer spreadsheet program allows you to create, edit and maintain a spreadsheet (or worksheet) full of data. Spreadsheets allow you to make budgets, invoices and similar documents. They're used heavily in the business and financial sectors. Spreadsheet models allow most of the preparation work to be done for you.
Spreadsheet models exist for a variety of different common purposes, such as the budget of an event or the organization of a payroll.Common uses for spreadsheet models include getting budget estimates or inputting different sets of data to experiment with different financial outcomes.
Spreadsheet models usually come in a certain file format. Microsoft Excel has a large spreadsheet program; other options include Apple Numbers, Google Docs (which reads many formats) and Lotus Symphony.
Advantages of models:
1. Formula can be used to instantly to recalculate totals. 
2. The information can be presented in different ways.
3. You can carry out what if investigations.
Using a spreadsheet you can see all the data at once and when you change any data all computations can be instantaneously updated with the change.

It is a place where you can organize your information. Also if you are using numbers, you can input eqautions to help run those numbers (ex. Excel).


you don't really have to any of the work because if you are finding out sums(working out) you can just drag it and it will bring up all of the other answers for you.