How To Perform Calculations in a Microsoft Works Spreadsheet - dummies

How To Perform Calculations in a Microsoft Works Spreadsheet

By Nancy C. Muir

Microsoft Works includes a spreadsheet program you can use to organize data and perform calculations. Microsoft Works Spreadsheet can perform simple or complex calculations on the numbers you enter into a spreadsheet, from averaging a set of numbers to complex statistical analysis.

1Click in a cell where you would like calculation results to appear.

The cell is highlighted.

2Choose Tools→Easy Calc or press the Easy Calc button on the toolbar.

The Easy Calc dialog box appears.

3Click a function in the Common Functions list box and then click Next.

For example, you might choose Add to add the values in a range of cells. When you click Next, the Easy Calc wizard displays the next page.

4Select the cell(s) you want to calculate.

For example, if you are subtracting, click the first cell, then click the cell whose value you want to subtract from the first cell. If you’re adding, drag over the range of cells whose values you want to add.

If you can’t see the cells you want to select, click the double up-arrow button to the right of the text box and the dialog box is temporarily hidden, allowing you to click and drag on your spreadsheet to select the cells you want to calculate. After you make the selection, the dialog box appears again.

5Click Next, then click Finish.

When you click Next, the Final Result page appears. You can enter a different result cell if you want. After you click Finish, the result of the calculation appears in the result cell.

To add numbers quickly, simply click in the cell where you want to place the result and then click the AutoSum button on the toolbar (which looks kind of like a capital M turned sideways). Spreadsheet suggests cells you might want to include in the calculation, but you can click and drag to select different cells. Press Enter to complete the calculation.