Excel can perform both standard calculator functions as well as advanced algebraic, statistical, logical, and financial calculations. Unless you specify absolute cell references , Excel formulae can be copied to different areas of the worksheet. Select the cell that you want to copy the formula to and use the menu Edit-Paste. When used in a formula, a relative cell reference denotes the cell used in the calculation by location in relation to the cell being modified. This concept can get a bit confusing.
Most charts can be quickly and easily created using the chart wizard.
Invoke the chart wizard by clicking on the button in the standard toolbar. Let's take a look at an example of the chart wizard in action. Let's say that we have 5 months worth of sales figures from three different divisions of a company. First, we would invoke the chart wizard by clicking on the button in the standard toolbar. The first step in creating any chart is to define which type of chart you want to create.