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.

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

  • information assurance

    - Information assurance (IA) is the practice of protecting against and managing risk related to the use, storage and transmission of data and information systems. (SearchCompliance.com)

  • metadata management

    - Metadata management is the oversight of data associated with data assets to ensure that information can be integrated, accessed, shared, linked, analyzed and maintained to best effect across an org... (WhatIs.com)

  • SAP Data Services

    - SAP Data Services is a data integration and transformation software application. (SearchSAP.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.