Alternatively referred to as a worksheet, a spreadsheet is a file made of rows and columns that help sort data, arrange data easily, and calculate numerical data. What makes a spreadsheet software program unique is its ability to calculate values using mathematical formulas and the data in cells. A good example of how a spreadsheet may be utilized is creating an overview of your bank s balance.
Database software such as SAS works differently than spreadsheets in that data is entered in individual records, and the records can then be presented in tabular format if the user so chooses. For example, in a database of client information, an individual record is created for each client with name, address and other pertinent information. The database can be used to print mailing labels for all clients, identify clients by specific characteristics -- such as, for example, all clients east of the Mississippi -- or present client information in tabular format.