

Other similarities exist in the program as well including spell check and the ability to insert decorative items such as borders and images. Most spreadsheet applications also allow users to format their sheets with options similar to those that we saw in Word Processing. This is especially useful for "What-if" analysis and forecasting. The true power of the spreadsheet is its ability to handle complex mathematical calculations and automatically recalculate totals as the underlying data in the sheet changes. These programs allow users to work with data in a variety of ways to create budgets, forecasts, inventories, schedules, charts, graphs and many other data based worksheets. Examples include: Lotus 1-2-3, Microsoft Works Spreadsheet, Open Office Calc and Google Drive Spreadsheet. By far, the most frequently used spreadsheet program is Microsoft Excel, but other spreadsheet applications exist as well.

In order to create an electronic spreadsheet, a specialized spreadsheet application is needed. Data in a spreadsheet is organized in a series of rows and columns and can be searched, sorted, calculated and used in a variety of charts and graphs. Home | Basic Computer Functions | SpreadsheetsĪ spreadsheet is a tool that is used to store, manipulate and analyze data.
