What is microsoft excel spreadsheet manual#

Spreadsheet programs also provide conditional expressions, functions to convert between text and numbers, and functions that operate on strings of text. Such calculations as net present value or standard deviation can be applied to tabular data with a pre-programmed function in a formula. īesides performing basic arithmetic and mathematical functions, modern spreadsheets provide built-in functions for common financial accountancy and statistical operations.

Modern spreadsheet software can have multiple interacting sheets and can display data either as text and numerals or in graphical form.

What is microsoft excel spreadsheet manual#

This makes the spreadsheet useful for 'what-if' analysis since many cases can be rapidly investigated without manual recalculation. Spreadsheet users can adjust any stored value and observe the effects on calculated values. The term spreadsheet may also refer to one such electronic document. Each cell may contain either numeric or text data, or the results of formulas that automatically calculate and display a value based on the contents of other cells. The program operates on data entered in cells of a table.

Spreadsheets were developed as computerized analogs of paper accounting worksheets. Computer application for organization, analysis, and storage of data in tabular form Example of a spreadsheet holding data about a group of audio tracksĪ spreadsheet is a computer application for computation, organization, analysis and storage of data in tabular form.