what type of business would it be necessary to use more than one worksheet in a spreadsheet application?

Answer 1

I've often used multiple worksheets on a spreadsheet to consolidate data into a single place.

Server Summary | Server 1 | Server 2 | Server 3

This saves having to generate a database to consolidate the information, and everyone gets instant access to my source data.

With that idea, I've also created spreadsheets that contain detail information on secondary sheets, and consolidate it on a summary page. Especially useful, when I am pulling from various sources that provide static data (like CSV format files).

Resolved (Employee ID to Email) | Email Address to Name | Employee ID -> Name

Answer 2

Many could make use of that.
The most common is a company that has several divisions or branches in several locations.
Data can be entered for each one, then summed on a total page.
Data can also be entered by the month and then summed for the year.

Answer 3

accounting