What Excel Is Used For

Electronic spreadsheet programs were originally based on paper spreadsheets used for accounting.

As such, the basic layout of computerized spreadsheets is the same as the paper ones.

Related data is stored intables which are a collection of small rectangular boxes orcellsorganized into rows and columns.

Excel spreadsheet with rows and columns highlighted

All versions of Excel and other spreadsheet programs can store several spreadsheet pages in a single computer file.

The saved computer file is often referred to as aworkbookand each page in the workbook is a separateworksheet.

The intersection point between a column and a row is the small rectangular box known as acell.

Microsoft Excel Formulas and Functions

In these cell references, the column letter is always listed first.

These cells, however, may be located on different worksheets or in different workbooks.

Creating a formulastarts by entering the equal sign in the cell where you want the answer displayed.

Microsoft Excel spreadsheet with financial data

Formulas can also include cell references to the location of data and one or more spreadsheetfunctions.

Excel and Financial Data

Spreadsheets are often used to store financial data.

Excel Alternatives

Other current spreadsheet programs that are available for use include:

Microsoft Excel chart

Microsoft Excel.spreadsheet and graph