Alternatively referred to as a worksheet, a spreadsheet is a file made of rows and columns that help sort data, arrange data easily, and calculate numerical data. What makes a spreadsheet software program unique is its ability to calculate values using mathematical formulas and the data in cells. A good example of how a spreadsheet may be used is creating an overview of your bank's balance. Below is a basic example of what a Microsoft Excel spreadsheet looks like, as well as all the major portions of a spreadsheet highlighted.
In the above example, this spreadsheet is listing three different checks, the date, their description, and the value of each check. These values are then added together to get the total of $162.00 in cell D6. That value is subtracted from the check balance to give an available $361.00 in cell D8.
What is an active worksheet?
An active worksheet is the worksheet that is currently open. For example, in the picture above, the sheet tabs at the bottom of the window show "Sheet1", "Sheet2", and "Sheet3", with Sheet1 being the active worksheet. The active tab usually has a white background behind the tab name.
Examples of spreadsheet programs
Today, Microsoft Excel is the most popular and widely used spreadsheet program, but there are also many alternatives. Below is a list of spreadsheet programs that can be used to create a spreadsheet.
- Google Docs - (Online and free)
- iWork Numbers - Apple Office Suite
- LibreOffice -> Calc (Free)
- Lotus 1-2-3 (Discontinued)
- Lotus Symphony - Spreadsheets
- Microsoft Excel
- OpenOffice -> Calc (Free)
- VisiCalc (Discontinued)
Other examples and uses of a spreadsheet
Although spreadsheets are typically used with anything containing numbers, the uses of a spreadsheet are almost endless. Below are some other popular uses of spreadsheets.
Spreadsheets are great at any financial data, such as your checking account information, budgets, transactions, billing, invoices, receipts, forecasts, and any payment system.
Form templates can be created to handle inventory, evaluations, performance reviews, quizzes, time sheets, patient information, and surveys.
School and Grades
Teachers can use spreadsheets to track students, calculate grades, and identify important data, such as high and low scores, missing tests, and students who are struggling.
Managing a list in a spreadsheet is a great example of data that does not contain numbers, but still can be used in a spreadsheet. Great examples of spreadsheet lists include telephone, to-do, and grocery lists.
Spreadsheets can keep track of your favorite player stats or stats on the whole team. With the collected data, you can also find averages, high scores, and other statistical data. Spreadsheets can even be used to create tournament brackets.
How many worksheets open by default?
In Microsoft Excel and OpenOffice Calc by default there are three sheet tabs that open (Sheet1, Sheet2, and Sheet3). In Google Docs there are no sheet tabs.
Why wouldn't I just use a word processor?
While it may be true that some of the things mentioned above could be done in a word processor, spreadsheets have a huge advantage over word processors when it comes to numbers. It would be impossible to calculate multiple numbers in a word processor and have the value of the calculation immediately appear. Spreadsheets are also much more dynamic with the data and can hide, show, and sort information to make processing lots of information easier.
- Where can I get a free spreadsheet program?
- How to create a spreadsheet.
- Microsoft Excel help and support.