Question:

What is the difference between a workbook and a worksheet?

by  |  earlier

0 LIKES UnLike

Why would you want to use separate worksheets when using Excel

 Tags:

   Report

3 ANSWERS


  1. In most cases you can use the other sheets as data collectors for complex macros.

    Simple terms: many times you don't want the front sheet to have all of the "work" on it, just the results.  The other sheets can keep data that the end user does not need to see.

    It also allows you to prepare numerous variations of a report without having to start from scratch each time.


  2. Workbooks   In Microsoft Excel, a workbook is the file in which you work and store your data. Because each workbook can contain many sheets, you can organize various kinds of related information in a single file.

    Worksheets   Use worksheets to list and analyze data. You can enter and edit data on several worksheets simultaneously and perform calculations based on data from multiple worksheets. When you create a chart, you can place the chart on the worksheet with its related data or on a separate chart sheet.

    Work sheets can be used many ways like your earnings in one work sheet, your expenses in another work sheet, tax return in another and graphs in another.  

  3. a workbook is a collection of worksheets. For example if you had one sheet that was a table with information, and another sheet with a pie chart, you would have a workbook.

Question Stats

Latest activity: earlier.
This question has 3 answers.

BECOME A GUIDE

Share your knowledge and help people by answering questions.
Unanswered Questions