Computer Applications

In Excel , multiple worksheets are used basically to organize related data . They can be further used to separate the data into different categories like date or product type or department . One main reason for organizing the data is readability

Consider the case of a company utilizing excel to keep a record of all sales . To do so , the company must record the purchase detail such as date of purchase , product details such as id , name , quantity , and price client details such as name , address , shipping address , and payment mode , and sales person

details such as name , employee id , and so on . In this example , a sales person could sell multiple products and there could be multiple clients buying different products . If there were a single sheet , the details regarding the product , sales person as well as client would repeat in many instances leading to increase in size Also , maintainability is affected . In case the client address is changed , or other client specific details are changed , the change would have to be repeated wherever the entry regarding the client is there in the excel sheet . What would help here is to keep a separate worksheet each for product details , sales person details , client details , and purchase details . The worksheet consisting of purchase details would contain a link to the other worksheets

Another example is where one would be using a separate worksheet for each quarter 's detailed budget , and another worksheet - a summary worksheet that would contain the streamlined version...