|
Introduction | Workbook | Toolbars | Selecting Cells | Formulas | Charts | Formatting | Saving
MS Excel 2000
Formulas and Functions
One way to process a set of numbers in your worksheet is to use a formula.
Simply click on the cell in which you want the result to be displayed,
then type in your formula. It should begin with the equals sign
(=) and may contain cell references, numerical constants, or pre-defined
Excel functions.
For example, to add the contents of cells A1, B1 and C1 and put
the result in D1 you would type the following formula into cell D1.
Then press Enter.
Another way to do this would be to use an Excel function instead
of typing one out yourself. Select cell D1. Then go to Insert and
then to Function.
Now you can select the function you would like to use. For this
example you would select SUM.
Let's see what happens if we select the AVERAGE function.
Then you would just enter the range of cells you would like to
have averaged. Click OK.
Cell D1 now has the average of cells A1, B1 and C1
Continue with Charts or Return to Workshops
|
