A spreadsheet is an interactive computer application program for organization and analysis of information in tabular form. Spreadsheets developed as computerized simulations of paper accounting worksheets. The program operates on data represented as cells of an array, organized in rows and columns. Each cell of the array is a model–view–controller element that can 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 user of the spreadsheet can make changes in any stored value and observe the effects on calculated values. This makes the spreadsheet useful for "what-if" analysis since many cases can be rapidly investigated without tedious manual recalculation. Modern spreadsheet software can have multiple interacting sheets, and can display data either as text and numerals, or in graphical form.
In addition to the fundamental operations of arithmetic and mathematical functions, modern spreadsheets provide built-in functions for common financial and statistical operations. Such calculations as net present value or standard deviation can be applied to tabular data with a pre-programmed function in a formula. Spreadsheet programs also provide conditional expressions, functions to convert between text and numbers, and functions that operate on strings of text.
Spreadsheets have now replaced paper-based systems throughout the business world. Although they were first developed for accounting or bookkeeping tasks, they now are used extensively in any context where tabular lists are built, sorted, and shared.
Visicalc was the first electronic spreadsheet on a microcomputer, and it helped turn the Apple II computer into a popular and widely used system. Lotus 1-2-3 was the leading spreadsheet when DOS was the dominant operating system. Excel now has the largest market share on the Windows and Macintosh platforms. A spreadsheet program is a standard feature of an office productivity suite; since the advent of web apps, office suites now also exist in web app form.
Read more about Spreadsheet: Spreadsheet Use, Concepts, Programming Issues, Shortcomings, Spreadsheet Risk
Other articles related to "spreadsheet, spreadsheets":
... VisiCalc The first widely used normal spreadsheet with A1 notation etc. 3D-Calc multi-dimensional spreadsheet for Atari ST Perfect Calc - CP/M-80 and CP/M-86 Part of the Perfect Office suite, included with early Kaypro 8-bit computers PlanPerfect ... qubecalc the original 3d spreadsheet ms-dos Practicalc - C=64 based spreadsheet ...
... A logical spreadsheet is a spreadsheet in which formulas take the form of logical constraints rather than function definitions ... In traditional spreadsheet systems, such as Excel, cells are partitioned into "directly specified" cells and "computed" cells and the formulas used to ... Logical Spreadsheets relax these restrictions by dispensing with the distinction between directly specified cells and computed cells and generalizing from functional definitions to ...
... on a financial model, in order to eliminate spreadsheet error ... A study in 1998 concluded that even MBA students with over 250 hours of spreadsheet development experience had a 24% chance of introducing spreadsheet error ...
... Spreadsheet risk is the risk associated with deriving a materially incorrect value from Excel or a similar spreadsheet application that will be utilised in making a ... incorrect changes) within the logic of the spreadsheet or the omission of relevant updates (e.g ... Because spreadsheet risk is principally linked to the actions (or inaction) of individuals it is defined as a sub-category of operational risk ...
... Spreadsheet 2000 was a spreadsheet program for Apple Macintosh computers, published by Casady Greene, a distributor of many "smaller" Mac releases ... Originally known as Let's Keep It Simple Spreadsheet, officially abbreviated Let's KISS, the product was renamed Spreadsheet 2000 for its 2.0 release ... Spreadsheet 2000, S2K for short, featured a unique way of building complex spreadsheets from a number of simpler ones containing only input or output data ...