spreadsheet

spreadsheet
/spred"sheet'/
1. Accounting. a work sheet that is arranged in the manner of a mathematical matrix and contains a multicolumn analysis of related entries for easy reference on a single sheet.
2. Computers. See electronic spreadsheet.
Also, spread sheet.
[SPREAD + SHEET1]

* * *

Computer software that allows the user to enter columns and rows of numbers in a ledgerlike format.

Any cell of the ledger may contain either data or a formula that describes the value that should be inserted therein based on the values in other cells. When a change is made in one cell, the program recalculates the contents of all cells affected by the change. Spreadsheets are widely used for performing business calculations on personal computers.

* * *

      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 all but replaced pen-and-ink versions by the end of the 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. In the view of many users, it was the application that 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 would be recomputed.

      Spreadsheets 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 the price of a part, to observe its effect on the cost of a product. With appropriate forecasting formulas, the market for the product, and hence the total profit to expect 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 readily be 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.

* * *


Universalium. 2010.

Игры ⚽ Нужно сделать НИР?

Look at other dictionaries:

  • Spreadsheet — Spreadsheet …   Deutsch Wörterbuch

  • Spreadsheet —   [dt. Arbeitsblatt] (Tabellenblatt), das Dokument oder der Teil eines Dokuments eines Tabellenkalkulationsprogramms, in den ein Anwender Daten eingibt; manchmal auch als Synonym für »Tabellenkalkulation« verwendet.   Ein Tabellenblatt ist aus… …   Universal-Lexikon

  • spreadsheet — 1982, from SPREAD (Cf. spread) + SHEET (Cf. sheet) …   Etymology dictionary

  • spreadsheet — /ingl. ˈsprɛdˌʃiːt/ [vc. ingl., comp. di sheet «foglio (di carta)» e spread «disteso, allungato»] s. m. inv. (elab.) foglio elettronico …   Sinonimi e Contrari. Terza edizione

  • spreadsheet — (izg. sprȅdšīt) m DEFINICIJA inform. 1. kompjuterski program; omogućava definiranje i ostvarenje niza relacija između različitih polja u pravokutnoj tablici 2. program za tablične izračune; tablični kalkulator ETIMOLOGIJA engl …   Hrvatski jezični portal

  • spreadsheet — ► NOUN ▪ a computer program used chiefly for accounting, in which figures arranged in a grid can be manipulated and used in calculations …   English terms dictionary

  • spreadsheet — [spred′shēt΄] n. a computer program that organizes numerical data into rows and columns on a video screen, for computing desired calculations and making overall adjustments based on new data …   English World dictionary

  • Spreadsheet — A spreadsheet is a computer application that simulates a paper worksheet. It displays multiple cells that together make up a grid consisting of rows and columns, each cell containing either alphanumeric text or numeric values. A spreadsheet cell… …   Wikipedia

  • spreadsheet — noun ADJECTIVE ▪ computer, electronic ▪ simple VERB + SPREADSHEET ▪ create, do (informal), make …   Collocations dictionary

  • Spreadsheet — A computer program that organizes numerical data into rows and columns on a terminal screen, for calculating and making adjustments based on new data. The New York Times Financial Glossary * * * spreadsheet spread‧sheet [ˈspredʆiːt] noun… …   Financial and business terms

  • spreadsheet — A computer program that organizes numerical data into rows and columns in order to calculate and make adjustments based on new data. Bloomberg Financial Dictionary * * * spreadsheet spread‧sheet [ˈspredʆiːt] noun [countable] COMPUTING a computer… …   Financial and business terms

Share the article and excerpts

Direct link
Do a right-click on the link above
and select “Copy Link”