Spreadsheets Many software tools are currently available that make financial planners, the analysis of research data, or creating graphs as simple as entering information into a computer program. Spreadsheets are just one of these flexible tools that in recent years have incorporated enormously versatile and diverse capabilities to manipulate data. A spreadsheet is a rectangular grid of rows and columns of cells, much like a ledger, which is used to collect or calculate data. For example, you can perform many automatic calculations, create graphs, sort the data, or perform statistical calculations.
Spreadsheets also come with many build-in functions to calculate cell values based in other cells.
Functions are typically available to perform statistical, financial, and mathematical tasks such as calculating sums, averages, sine, cosine, interest rates, principal portions of interest payments, and many more. In Figure 7, the number of patients seen for each day of the week has been tabulated in the cells B2, B3, B4, B5, and B6. Based on these data, the total number of patients and the average number per day is calculated in cells B8 and B9, respectively. Many more complicated spreadsheets can be constructed for decision support or research purposes. A number of commercial spreadsheet programs are currently available for a number of computer platforms.