Online Test Banks
Score higher
See Online Test Banks
eLearning
Learning anything is easy
Browse Online Courses
Mobile Apps
Learning on the go
Explore Mobile Apps
Dummies Store
Shop for books and more
Start Shopping

For Seniors: Create a Spreadsheet with Microsoft Works

Microsoft Works includes a spreadsheet program you can use to organize data and perform calculations. Microsoft Works Spreadsheet uses a grid-like structure for entering data (text or numbers).

The individual cells of the grid are formed by the intersection of a row with a column, so a cell is identified by a column letter followed by a row number. For example, B3 identifies the cell located at the intersection of the second column over and third row down.

1

To start a new spreadsheet choose Start→All Programs→Microsoft Works→Microsoft Works Spreadsheet.

Spreadsheet starts, and displays a blank spreadsheet.

If you're already working in Spreadsheet, you can start a new spreadsheet by choosing File→New. To open an existing spreadsheet so you can make changes to it, choose File->Open to locate and open it.

2

Click in a cell.

When you click in a cell, it's surrounded by a border to show that it's active.

3

Type data (text or numbers) into the cell.

Notice that what you type appears in both the cell and the Formula bar.

If your laptop doesn’t include a number pad, press the Fn (Function) key on your keyboard, and then press any of the keys that display the numbers 0 through 9 next to the letters to enter those numbers.

Use the two scrollbars, the one to the right and the one at the bottom, to move vertically or horizontally through a large spreadsheet.

4

Press Tab to complete the entry and move to the next cell.

You can also click the Enter button, which looks like a check mark, to complete your entry and keep the current cell active.

To make changes to a cell, click it and edit the contents displayed in the Formula bar.

Remember to save your work often to avoid losing anything. Choose File→Save, type a filename for the spreadsheet, then click Save. After saving the spreadsheet for the first time, you can keep working on it if you like; just click the Save button on the toolbar or choose File→Save to save any changes you make.

  • Add a Comment
  • Print
  • Share
blog comments powered by Disqus
Advertisement

Inside Dummies.com

Dummies.com Sweepstakes

Win $500. Easy.