Spreadsheet Program

From GM-RKB
(Redirected from spreadsheet program)
Jump to navigation Jump to search

A Spreadsheet Program is an interactive data processing system that can solve Spreadsheet Management Tasks (to manipulate spreadsheet documents).



References

2009

  • (Ronen et al., 1989) ⇒ Boaz Ronen, Michael A Palley, and Henry C. Lucas, Jr. (1989). “Spreadsheet Analysis and Design.” In: Communications of the ACM, 32(1). doi:10.1145/63238.63244.
    • ABSTRACT: Although spreadsheet programs and microcomputers have revolutionized information processing in organizations, a significant number of serious errors have been reported through the misuse of this technology. This article discusses several different contexts for the development of spreadsheet models and presents structured design techniques for these models.
    • Spreadsheet programs have become extremely popular with microcomputer users. Spreadsheets are heavily used by both end users and systems professionals. In fact, spreadsheet software has contributed greatly to the popularity of personal computers. These packages present the user with a general purpose problem solving tool.

2015

  • (Wikipedia, 2015) ⇒ http://en.wikipedia.org/wiki/Spreadsheet Retrieved:2015-6-29.
    • A spreadsheet is an interactive computer application program for organization, analysis and storage of data 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 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.

      Spreadsheet users may adjust 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 manual recalculation. Modern spreadsheet software can have multiple interacting sheets, and can display data either as text and numerals, or in graphical form.

      Besides performing basic 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 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.

      LANPAR was the first electronic spreadsheet on mainframe and time sharing computers. VisiCalc was the first electronic spreadsheet on a microcomputer, [1] 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.