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.