VisiCalc (1979) was the first electronic spreadsheet on a microcomputer, and it helped turn the Apple II computer into a popular and widely used system. LANPAR was an acronym: LANguage for Programming Arrays at Random. LANPAR, available in 1969, was the first electronic spreadsheet on mainframe and time sharing computers. 2.5 Lotus 1-2-3 and other MS-DOS spreadsheets.2.2.4 IBM Financial Planning and Control System.2.2.3 Autoplan/Autotab spreadsheet programming language.
This makes the spreadsheet useful for "what-if" analysis since many cases can be rapidly investigated without manual recalculation. Spreadsheet users can adjust any stored value and observe the effects on calculated values. A spreadsheet may also refer to one such electronic document. Each cell 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. The program operates on data entered in cells of a table. Spreadsheets were developed as computerized analogs of paper accounting worksheets.
Watch the video below to learn how to work with simple formulas in Google Sheets.Example of a spreadsheet holding data about a group of audio tracks.Ī spreadsheet is a computer application for computation, organization, analysis and storage of data in tabular form. Using cell references in your formulas will make sure the values in your formulas are accurate. The advantage of using cell references is that you can change a value in a referenced cell and the formula will automatically recalculate. Most of the time, you will be using a cell's address in the formula. In this lesson, we'll focus on formulas that contain one mathematical operator. Google Sheets uses mathematical expressions called formulas that make handling these calculations easy. Creating simple formulasĪ convenient and time-saving feature of Google Sheets is its ability to add, subtract, multiply, and divide numerical information for you. You will also be introduced to the basics of using cell references in formulas. In this lesson, you'll learn how to create simple formulas that will add, subtract, multiply, and divide values. When working with numerical information, Google Sheets can be used to perform calculations. en/googlespreadsheets/working-with-multiple-sheets/content/ Introduction