This section focuses on Spreadsheet software that takes input such as labels, numbers (values) and formulas which are processed into output such as reports, billing, taxes, accounting, charts and graphs.

Spreadsheets take input (data) in the form of labels, values or numbers and formula stored in cells in the spreadsheet.

Cells are made up of the intersection of rows and columns. Different spreadsheet packages offer different quantity of rows and columns, but all spreadsheets use these cells basically the same.

While many of the functions that exist in word processing such as: create, edit, format, store, retrieve and print, spreadsheet programs have many unique features that set them apart from other software packages.

Some of the advantages of using a spreadsheet include:

1. Labor saving from having to calculate large amounts of data by hand

2. Automatic recalculation - when one value in the spreadsheet changes, all dependent value on the spreadsheet are automatically recalculated to reflect the change

3. “What If” Analysis - allow you to change one or more value, view the results, before the final decision is made on keeping (saving)  the spreadsheet

Return to Top

Some of the uses of using a spreadsheet include:

1. Keep track of performance 

2. Budgeting 

3. Expense sheets 

4. Stock market

5. College fund  

6. Taxes - which some programs have built in templates

7. What if analysis - for example:

As mentioned above data is entered into spreadsheet cells and the intersection of the rows and columns make up the cell.  In the active cell (that cell that is identified at the intersection of the row and column) can contain one of the following:

Business graphics represent business data in a visual, easily understood format.  They also generate and sustain the interest of an audience; make a lesson, report, or business document more attractive; help get a point across; can reveal a trend that is lost in a column of numbers; and presenter appears more prepared and organized.

Return to Top