Question

An Excel workbook can contain more than one workshet. Give two examples of a spreadsheet application where it would be necessary to have more than one worksheet and explain your answer.

Please help. I am lost when it comes to excel!!

Answer 1

I have set up address book files in Excel, and I use one worksheet for the full address book (everyone I know!), another worksheet for only those I use frequently, one worksheet only for email addresses, and one worksheet only for cell phone numbers. It seems like duplication to my son and daughter, but it works for me!

I also used to set up budgets for state and federal programs at the high school where I worked. I had one Excel file for each school year, and within each file, I had a worksheet for each of the 16 programs.

Those are just two examples.