Can anyone give me two examples of using Microsoft Excel Worksheet when you would need two sheet? ?

Any time you have a large amount of data or multiple print ranges it can be beneficial to divide your workspace into separate worksheets.

An accounting spreadsheet I have is broken down into several separate worksheets. One worksheet is simply to keep track of the different accounts and account numbers. If I need to make an entry and don't remember the account number, it's much simpler to select the appropriate tab, reference the account number, and return to the worksheet I was working on without scrolling across several pages of data. I also have separate worksheets for the General Journal, General Ledger, Balance Sheet, Accounts Payable, Accounts Receivable, Payroll, Quarterly and Year End Reports, and so on. Each sheet can be printed separately.

Another spreadsheet I have is designed for a type of "Fantasy Golf". It has separate sheets for tracking the necessary stats. One is for listing the participants of the "Fantasy Golf" competition as well as the golfers they have chosen and their total winnings while on tour. It also utilizes a column for sorting the standing of the participants. A second sheet is for tracking the weekly results of the PGA tour and holds the raw data, including which players qualified in the tour and the amounts awarded to each. This data is imported into the first sheet. Both sheets have separate print ranges.

Either of these examples can be placed into one large spreadsheet, but they both have very large workspaces and separate print and sort ranges. It is simply more convenient and easier to work with multiple worksheets.

Hello;

One example I created was when I made a spreadsheet that had one sheet for raw data and then used other sheets to display the data and graphs for people to view.

Another example would be to have each month have its own sheet and then have the data displayed in a year end synopsis.

I made a spreadsheet that had one part for teaching simple math equations and another sheet for teaching fractions, and a third sheet that dealt with teaching some geometry ideas.

Hope that helps,

Bill

Someone has already provided you with the link to Open Office. I have been using it fo 4 years and have had very few compatibility problems in that time. I currently have both MS Office and OO on my machine and, to be honest, use OO around 75% of the time. Things seem to be relatively glitch free. And if you want free stuff, have a look at the Mozilla website, which gives you a browser (Firefox), that I believe outperforms IE, and a mail application (Thunderbird), that I have had many good reports about.