Formulas and Functions in Excel 2007 Software Training Services 05/19/08 Formulas and the Sum Function in Excel 2007 Quick Reference Guide To Sum a Column of Values 1. Click in the cell in which to enter the formula. 2. Click on the AutoSum tool on the Home tab of the Ribbon. 3. The formula will be displayed. Example: =SUM(F4:F9) 4. Click on the checkmark on the Formula bar. How does Excel determine the cells to include in the formula? Excel knows only two types of cell content, values and labels(non-values)…

Formula Basics A formula is a mathematical equation that calculates new values from existing values. In Excel, each formula should begin with an equal sign . The common operators used in formulas are: add (+), subtract (-), multiply (*), divide (/). As a rule, formulas do not contain spaces. When a formula is entered in a cell, the content of the cell is the formula . The value seen (the results of the formula) is displayed, but is not the content of the cell …… Help with Excel Functions Click on the function tool in the formula bar. The Insert Function dialog box displays. 1. Either type a description in the Search box OR select a category from the down arrow. 2. Click on Go. 3. Click once on a function name to select it. 4. Click on the Help on this function link. Ranges Many formulas contain ranges , which are groups of cells that have common boundaries and form a rectangle in shape. Ranges may contain cells in a single row, a single column or may span several rows and columns. When typing a range, the range name is from the top left cell reference to the bottom right cell reference. A colon is entered between the first and the second cell reference. The colon is read as “through. ” Some examples of ranges are: G4:G9 (G4 through G9) B4:E9 (B4 through E9)…

Download Formulas and the Sum Function in Excel 2007.Pdf