For Seniors: View Currently Installed Printers and Documents in Print Queue
For Seniors: Sync Your Laptop with a Music Device
For Seniors: Change Your User Account Type

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: Change Page Setup of a Microsoft Works Document
For Seniors: Create and Send Windows Mail
For Seniors: Save Favorite Websites in Internet Explorer
For Seniors: Check Spelling in a Microsoft Works Document
For Seniors: Connect Speakers to a Laptop
Advertisement

Inside Dummies.com