Explore BrainMass

Explore BrainMass

    Excel: Worksheets and Workbooks

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    What is the difference between a workbook and a worksheet? Why would you want to use separate worksheets when using Excel? Please give 2 general examples. Please research and find the method for creating an Excel formula that references information on the first worksheet from a second worksheet. Can you think of a specific personal or business application that would require only one worksheet? Please explain this application.

    © BrainMass Inc. brainmass.com May 20, 2020, 10:38 pm ad1c9bdddf

    Solution Preview

    An Excel workbook can contain one worksheet or thousands depending on the application. A worksheet is just a single page within a workbook.

    Separate worksheets are common in Excel. One use of worksheets within a workbook could be breaking down a business in four quarters for handling finances through a fiscal year. Another example could ...

    Solution Summary

    This solution explains some of the differences between a worksheet and a workbook in Excel, why one would want to use different worksheets when using Excel and provides examples the illustrate the answer. Additionally, the solution explains several Excel functions.