Spreadsheet

A Spreadsheet is a computer program that imitates a paper worksheet. It shows a large sheet (like a sheet of paper) that has many cells in a grid of rows and columns. Users can put words or numbers into the cells, to make headings and store information (usually numbers). You can also move the grid lines around so that some cells are bigger than others, and change the color or size of text/font, the same way font/text is changed in a word processor. You can even put pictures in the worksheets, make multiple pages, and print out their results on real paper.

The primary reason most people use spreadsheets is for automatic calculations. Spreadsheets can be designed to add up the items/amounts on a bill, calculate sales tax, and even calculate income tax. A user can add and subtract the numbers here, even if the numbers are not next to each other. This means the computer does all the math, and people only need to give the correct information.

Another strength of spreadsheets, is that they can produce diagrams, like graphs and pie-charts, based on the data the user enters. Sometimes the numbers make more sense when the computer turns them into a picture.

 Basics 
thumb
In 1969, a program called LANPAR was created. It was like a digital table that could do math on big computers shared by many people. They named it LANPAR because those words meant something special. Then, in 1979, a similar program called VisiCalc was made for smaller computers.Charles Babcock, "What's The Greatest Software Ever Written?", Information Week, 11 Aug 2006 . Accessed 25 June 2014 This helped make the Apple II computer really popular. Before Windows became common, a program called Lotus 1-2-3 was the most popular for working with these digital tables. But now, Microsoft Excel is the most used one on Windows and Mac computers. These digital table programs are now found in programs that help people do work in offices. In 2006, Google made their own digital table program that you can use on the internet. It's called Google Sheets and is part of Google Drive.

A spreadsheet is like a digital table made up of little boxes called cells. These cells are put in rows (like lines in a book) and columns (like vertical lines). Each cell has a special name that tells its position, using letters for columns and numbers for rows. For example, a cell might be called "C10." This idea of giving cells names was first used in a program called LANPAR. Another program called VisiCalc used a similar way of naming cells. You can also talk about a group of cells that are next to each other, like a bunch of cells in a column. This group is called a range. To talk about a range, you use the names of the first and last cells in that group. For example, you can call the first ten cells in the first column "A1:A10." LANPAR did something special too. It allowed you to do calculations that depended on things you would write later. This was helpful and came back later in programs like Lotus 123 and Microsoft's MultiPlan Version 2.

In the new computer programs that work with tables, we put many tables together to make a big book called a workbook. This workbook is like a special computer file that holds all the information for the book, including the tables and the little boxes in the tables. Each table inside the workbook is called a worksheet or sheet for short. You can imagine these sheets like pages in a book. To switch between them, you can use tabs, just like flipping pages. But one program called Numbers does it differently. If you have many sheets in one book, you give each box a special name that tells which sheet it's in. For example, you might say "Sheet 1!C10" to talk about a box in Sheet 1. Sometimes, you can even use this naming to talk about boxes in other books too.

 Popular spreadsheet software 
 Microsoft Excel
 LibreOffice Calc
 Apple Numbers
 Google Sheets

 Less popular spreadsheet software 
 Lotus 1-2-3 IBM, for Windows, Mac OS X & Linux, original 1983, last 2010
 Quattro Pro, for Windows, original 1989, last 2010
 Gnumeric, for Windows & Linux, original 2002, last 2010
 Kspread, Windows, Mac OS X & Linux, original 2007, last 2010
 EditGrid, internet based, like Google Spreadsheets, 2008
 OpenOffice.org Calc, last 2011

 Old spreadsheet software 
 VisiCalc, original 1979
 APLDOT modeling language: US Railway Association. 1976
 LANPAR spreadsheet compiler: Bell Canada and AT&T, 1969
 Autoplan/Autotab spreadsheet programming language: GE, 1968
 BCL, or Business Computer Language: IBM, 1963
 MultiPlan
 T/Maker
 Target Planner Calc for CP/M and TRS-DOS
 Trapeze for Macintosh
 Wingz for Macintosh

References