For Seniors: Play Hearts on a Windows Computer
For Seniors: Open an Existing Microsoft Works Document
For Seniors: Add the Puzzle Gadget to the Windows Desktop

For Seniors: Perform Calculations in a Microsoft Works Spreadsheet

Microsoft Works includes a spreadsheet program you can use to organize data and perform calculations. MS 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.

1

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

The cell is highlighted.

2

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

The Easy Calc dialog box appears.

3

Click 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.

4

Select 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.

5

Click 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.

  • Add a Comment
  • Print
  • Share
blog comments powered by Disqus
For Seniors: Play Solitaire on a Windows Computer
For Seniors: Add the Clock Gadget to the Windows Desktop
For Seniors: Change Page Setup of a Microsoft Works Document
For Seniors: Start a Windows 7 Program Automatically
For Seniors: Print a Microsoft Works Document
Advertisement

Inside Dummies.com