spreadsheet
Sign in to saveA 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.
Article
45 sectionsContents
- 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
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.
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.