spreadsheet

Also known as spreadsheet program, spreadsheet application

A spreadsheet is a computer application for computation, organization, analysis and storage of data in tabular form. Spreadsheets were developed as computerized analogs of paper accounting worksheets. The program operates on data entered in cells of a table. Each cell may contain either numeric or text data, or the results of formulas that automatically calculate and display a value based on the contents of other cells. The term spreadsheet may also refer to one such electronic document.

AI overview

A spreadsheet is a computer program that organizes and analyzes data in a table of cells, where each cell can hold numbers, text, or automatic calculations based on other cells. Spreadsheets were created as digital versions of paper accounting worksheets and are useful for storing, computing, and analyzing information efficiently.

AI-generated from the Wikipedia summary — may contain errors.

Wikidata facts

Image: OpenOffice.org Calc.png

Show 2 more facts

Commons category: Spreadsheet software
P13411: television

Sources (2)

via Wikidata · CC0

~52 min read

Article

45 sections

Contents

Basics
History
Paper spreadsheets
Electronic spreadsheets
Batch spreadsheet report generator BSRG
LANPAR spreadsheet compiler
Autoplan/Autotab spreadsheet programming language
IBM Financial Planning and Control System
APLDOT modeling language
VisiCalc for the Apple II
SuperCalc for CP/M
Lotus 1-2-3 spreadsheet for IBM PC DOS
Microsoft Excel for Apple Macintosh and Windows
Google Sheets, Online, Web-based spreadsheets
Mainframe spreadsheets
Other spreadsheets
Other products
Concepts
Cells
Values
Automatic recalculation
Real-time update
Locked cell
Data format
Cell formatting
Named cells
Cell reference
Cell ranges
Sheets
Formulas
Functions
Subroutines
Remote spreadsheet
Charts
Multi-dimensional spreadsheets
Logical spreadsheets
Programming issues
End-user development
Spreadsheet programs
Shortcomings
Spreadsheet risk
See also
Notes
References
External links

In modern spreadsheet applications, several spreadsheets, often known as "worksheets" or simply "sheets", are gathered together to form a "workbook". A workbook is physically represented by a file containing all the data for the book, the sheets, and the cells with the sheets. Worksheets are normally represented by tabs that flip between pages, each one containing one of the sheets, although Numbers changes this model significantly. Cells in a multi-sheet book add the sheet name to their reference, for instance, "Sheet 1!C10". Some systems extend this syntax to allow cell references to different workbooks.