Need help with a excel question?

Question

A workbook can contain more than one worksheet. Give an example of a spreadsheet application where it would be necessary to have more than one worksheet and explain your answer.

Answer 1

A spreadsheet of all the radio stations in the country seperated by state. Each page alphabetically named.

A spreadsheet of employees seperated by hourly, salaried, and contract.

A spreadsheet of vehicle models seperated by manufacturer.

A spreadsheet with input from several people, each with their own sheet to update, and a master sheet to draw formulas from the other sheets.

Answer 2

I use workbooks with different worksheets all the time at work at a restaurant. A great example that we used was for tracking daily income, where we would report total number of guests, total restaurant, take-out, bar, and banquet revenue for both lunch time and dinner time, then report any comments or concerns for the day (special events, staffing issues, etc). Each workbook was for a certain month, then each worksheet was a specific day.

Another time i use this is for budgeting and payroll, where each worksheet is either one single month, or a day.

Answer 3

i use Excel literally every day....i calculate quotes, bid, generate invoices, and keep track of services...

i link cells in onw worksheet with cells in the other worksheets, cells which might have similarities in formulas and results...

for example, my first worksheet has the bid price and contact information...but the second sheet lists all the formulas and calculations needed to create the bid price (that bid price is linked to sheet #1)...the third sheet would have formulas for inputs to the bid calculations linking results to sheet #2....the fourth sheet could be the invoice amounts or inputs for pricing...

i also use excel in invoice keeping a separate worksheet for each month, for example sheet #1 is jan07, sheet #2 is feb07, etc. etc.

Answer 4

I use excel to organize my weekly menus. Since i service many different clients, who receive simialr menus, it is easy to change only 1 worksheet than10. Within that workbook there are also the temperature logs that are dated and correspond with each menu.

Answer 5

If you're using your sheets to manage costs, dates and data, you could certainly have a need for separate sheets on the same document. I worked for a company where we had three "programs" or product lines with unique deadlines, costs and profits. I needed to track aspects of production (I was the web manager) independently, so I would have a sheet for each.

Then, I could have a 4th sheet where the production deadlines, vender costs, etc., could all be compared. Where it's slick as a single document is, you can have the results on one sheet be a function (using direct data) from another sheet in the same document. If the deadline for one sheet changes, this would effect my fourth sheet. Get it?

Answer 6

One use in business is to create a "database" of all of your information on one worksheet- like a hugh table of information with column headings. Then in order to summarize or analyze the information, you would use other Excel functions like Pivot Tables, Goal Scenario, filter etc to create summaries or other analyses of the information.

Answer 7

some teachers use excell for grades
i am in that class right now and its fun in a way
you dont have to use the other sheets actually i think you can delete them off if you want