Part of the Data and data management glossary:

A spreadsheet is a sheet of paper that shows accounting or other data in rows and columns; a spreadsheet is also a computer application program that simulates a physical spreadsheet by capturing, displaying, and manipulating data arranged in rows and columns. The spreadsheet is one of the most popular uses of the personal computer.

Next Steps

In a spreadsheet, spaces that hold items of data are called cells. Each cell is labeled according to its placement (for example, A1, A2, A3...) and may have an absolute or relative reference to the cells around it. A spreadsheet is generally designed to hold numerical data and short text strings. Spreadsheets usually provide the ability to portray data relationships graphically. Spreadsheets generally do not offer the ability to structure and label data items as fully as a database and usually do not offer the ability to query the database. In general, a spreadsheet is a much simpler program than a database program.

Daniel Bricklin and Bob Frankston created the first spreadsheet application, VisiCalc (for "visible calculator"). Lotus 1-2-3 came next, followed by Microsoft Excel. While Lotus 1-2-3 was the first to introduce cell names and macros, Microsoft Excel implemented a graphical user interface and the ability to point and click using a mouse. There are many other spreadsheet applications on the market today; however, Lotus 1-2-3 and Microsoft Excel continue to be the most popular.

This was last updated in January 2006
Posted by: Margaret Rouse

Related Terms

Definitions

  • Excel

    - Excel is a spreadsheet program from Microsoft, a component of its Office product group for business applications. In common with similar products, such as Lotus 1-2-3 and Corel's QuattroPro, Exce... (SearchEnterpriseDesktop.com)

  • pivot table

    - A pivot table is a program tool that allows you to reorganize and summarize selected columns and rows of data in a spreadsheet or database table to obtain a desired report. (SearchSQLServer.com)

  • comma-separated values file (CSV)

    - In computers, a CSV (comma-separated values) file contains the values in a table as a series of ASCII text lines organized so that each column value is separated by a comma from the next column's v... (SearchSQLServer.com)

Glossaries

  • Data and data management

    - Terms related to data, including definitions about data warehousing and words and phrases about data management.

  • Internet applications

    - This WhatIs.com glossary contains terms related to Internet applications, including definitions about Software as a Service (SaaS) delivery models and words and phrases about web sites, e-commerce ...

Ask a Question. Find an Answer.Powered by ITKnowledgeExchange.com

Ask An IT Question

Get answers from your peers on your most technical challenges

Ask Question

Tech TalkComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.