How to Calculate Cells in Excel 2007

1. Open Microsoft Excel and create a worksheet with the data you want to calculate. Place your cursor in an empty cell below or beside the column you want to calculate.
2. Select the 'Formula' tab from the Ribbon and click on 'AutoSum' under the 'Function Library' group. To add all the numbers in a column, click on the 'AutoSum' button. Excel 2007 will select the calculated cells on the worksheet for you.
3. Press the 'Enter' key to accept the calculation or manually select the cells you want to calculate, then press the 'Enter' key.
4. Repeat the calculation for additional columns or rows, or copy the formula to your other cells. To copy your calculation to another cell, select the cell with the formula. Then place your mouse just outside the cell (on the bottom-right portion of the cell) until your mouse becomes a plus sign.
5. Drag the cell in the direction of the cells where you want the formula added. The formula will be repeated on those cells.
6. Calculate the average of numbers by placing your cursor in an empty cell and clicking on the arrow for the 'AutoSum' button in the 'Formula' tab. Then click on 'Average.'
7. Use a different formula by clicking on 'More Functions' within 'AutoSum.' Find the formula you need by searching for the function or changing the category and selecting it. The 'Function Arguments' dialog box will open up
8. Click on the button to the right of the dialog box and select the range of values you need. Click on the button again to return to the 'Functions Argument' box. Then press 'OK' when you are finished.