Excel Intro:




One of the most common tasks for spreadsheets is to add up numbers. Since the numbers are almost always in a row or column, Excel has a special button that makes a guess about what numbers you want to add. When the guess is right, you have saved several steps. When the guess is wrong, you can easily change the cell references in the formula.
The
AutoSum button in Excel 2002/2003 has a drop list of the most common functions.

Project 1: Excel Intro Search Glossary Appendix 

Start with: budget.xls at Budget sheet from resource files AutoSum: Column
Excel guesses that you want to add the numbers above the selected cell up to the next blank cell, B6. It surrounds the range B7:B13 with a blinking dashed border. The formula is displayed both in the Formula bar and in the cell. It will overlap other cells if necessary while you are working. All formulas must begin with =, the equals sign. While the blinking dashed border surrounds the cells, clicking or dragging will
change the formula, using the cell references of the cells you clicked or dragged. It can really foul up your calculations to click without careful thought. Pressing
ESC will remove this blinking border and cancel your actions. AutoSum: Drag to change rangeIf Excel guesses incorrectly, you can change the cell references.
Notice the popup tip that shows while you are dragging. It says that you have selected a region that is 4 rows high and 1 column wide. AutoSum: RowAutoSum works for rows also.
AutoSum: Type to change range

~~ 1 Cor. 10:31 ...whatever you do, do it all for the glory of God. ~~ 