Microsoft Excel allows you to apply formulas to cells in a spreadsheet so that calculations are automatically performed.
Using cell references, Excel calculates a formula with whatever numbers are inputted
into cells. Formulas
A value is a piece of information that you enter manually into a cell, such as dates,
names, times, numbers, or other text.
A formula is a collection of numerical values. Excel allows you to apply formulas to adjacent cells so you can add, subtract,
multiply and divide numbers. A cell containing a formula displays the results
of that formula.. Add Column or Row data
Click on the cell where you want the total to appear. Then click on the AutoSum button  located in the toolbar.
A formula will pop-up in the cell. Make sure the correct cells are selected.
In this sample, the formula shows that cell B3 through B8 will be totaled. To
make changes, click on the formula and type in the cell numbers you want to add.
Then click the Enter key. The calculated number will appear.
Other Functions
Excel helps you to write complex formulas and even provides you with pre-written
functions for almost anything you can imagine. For a list of additional functions
that you can perform on your data, click on the arrow key next to the AutoSum button.
|
