A spreadsheet is a computer program for organising, calculating, and storing data in tabular form. Spreadsheets were created as digital counterparts to traditional paper accounting spreadsheets. The data entered into a table's cells is what the program uses to run. Each cell may include text, numeric data, or formula results that automatically calculate and display values based on the contents of neighboring cells. One such electronic document may also be referred to as a spreadsheet.
Users of spreadsheets can change any stored value and watch the changes in calculated values. This enables quick investigation of numerous scenarios without the need for manual recalculation, making the spreadsheet helpful for the "what-if" study. Modern spreadsheet programmes allow for the interaction of multiple sheets and the display of data either graphically or as text and numbers.
Modern spreadsheets include built-in functions for typical financial accounting and statistical procedures in addition to conducting basic mathematical and arithmetic operations. With a pre-programmed function in a formula, computations like standard deviation or net present value can be applied to tabular data. Conditional expressions functions to convert between text and numbers, and functions that operate on text strings are also available in spreadsheet programs.
How are data organized in a spreadsheet?
In a spreadsheet, data is arranged in rows and columns. The first electronic spreadsheet for mainframe and time-sharing computers was LANPAR, which was made accessible in 1969.