While every effort has been made to follow citation style rules, there may be some discrepancies. Please refer to the appropriate style manual or other sources if you have any questions.
Select Citation Style Copy Citation Share to social media Give Feedback External Websites Thank you for your feedbackOur editors will review what you’ve submitted and determine whether to revise the article.
External WebsitesWhile every effort has been made to follow citation style rules, there may be some discrepancies. Please refer to the appropriate style manual or other sources if you have any questions.
Select Citation Style Copy Citation Share to social media External Websites Thank you for your feedbackOur editors will review what you’ve submitted and determine whether to revise the article.
External WebsitesEncyclopaedia Britannica's editors oversee subject areas in which they have extensive knowledge, whether from years of experience gained by working on that content or via study for an advanced degree. They write new content and verify and edit content received from contributors.
The Editors of Encyclopaedia Britannica Table of Contents Related Topics: Microsoft Excel application software (Show more)Ask the Chatbot a Question
Ask the Chatbot a Question
spreadsheet, computer program that represents information in a two-dimensional grid of data, along with formulas that relate the data. Historically, a spreadsheet is an accounting ledger page that shows various quantitative information useful for managing a business. Electronic spreadsheets replaced pen-and-ink versions in the late 20th century. Spreadsheets are not limited to financial data, however, and are frequently used to represent scientific data and to carry out computations.
The first spreadsheet program was VisiCalc, written for the Apple II computer in 1979. For many users, this application most vividly showed the utility of personal computers for small businesses—in some cases turning a 20-hour-per-week bookkeeping chore into a few minutes of data entry. For example, a simple spreadsheet might hold payroll information with columns for employees’ names and addresses, Social Security numbers, hourly pay, hours worked, tax deductions, and net pay. Cells in the last column could have a formula attached to them to compute pay as a function of cells in the three preceding columns for each employee. The spreadsheet would show the net pay and, upon request, its formula. If tax-withholding rates were changed, all the net pay cells could be easily recomputed.
Britannica Quiz Computers and Technology QuizSpreadsheets are also invaluable in what-if computations. Once a set of formulas have generated data in spreadsheet cells as functions of other cells, one can experiment by changing one parameter, such as a part’s price, to observe its effect on a product’s cost. With appropriate forecasting formulas, the market for the product, and hence the total profit at the old and new price, can then be projected. Used this way, spreadsheets serve the needs of managers, economists, and anyone who works with relationships between types of quantitative information.
Since spreadsheets can be programmed, they can also be used for general computations. They are used for modeling in science and engineering, and they are well suited to educational uses—for example, to display the synthesis of sound from simple audio waveforms. Furthermore, since they are two-dimensional grids of cells, they can be readily programmed as cellular automata, systems of cells whose state depends on the states of their neighbours. American mathematician John H. Conway’s “Game of Life” is a simple example, and other cellular automata can model complex physical or biological processes.
Today spreadsheets for personal computers generally include the ability to convert data into various types of graphs (such as pie charts and bar graphs) and are often integrated with other software, such as word processors and database programs.
The Editors of Encyclopaedia Britannica This article was most recently revised and updated by Erik Gregersen.