Purchase Solution

Excel: Worksheets and Workbooks

Not what you're looking for?

Ask Custom Question

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.

Purchase this Solution
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.

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 ...

Purchase this Solution
Free BrainMass Quizzes
Inserting and deleting in a linked list

This quiz tests your understanding of how to insert and delete elements in a linked list. Understanding of the use of linked lists, and the related performance aspects, is an important fundamental skill of computer science data structures.

Javscript Basics

Quiz on basics of javascript programming language.

C++ Operators

This quiz tests a student's knowledge about C++ operators.

Word 2010: Table of Contents

Ever wondered where a Table of Contents in a Word document comes from? Maybe you need a refresher on the topic? This quiz will remind you of the keywords and options used when working with a T.O.C. in Word 2010.

Excel Introductory Quiz

This quiz tests your knowledge of basics of MS-Excel.

View More Free Quizzes
Related BrainMass Solutions

  • VB.NET to Excel

    : Dim workbooks As Workbooks = exc.Workbooks Dim workbook As _Workbook = workbooks.Add(XlWBATemplate.xlWBATWorksheet) ' GET THE WORKSHEETS COLLECTION: Dim sheets As Sheets = workbook.Worksheets Dim worksheet As _

  • A workbook can contain more than one worksheet.

    The information on the different worksheets are sometimes independent, i.e. they can be understood without having the other worksheets. However, in some workbooks, the information amongst the worksheets can also be linked.

  • MS Excel

    in the same workbooks.

  • Importance of professional worksheets

    Does it make worksheets and workbooks easier to read and follow, or just clutter them up with unnecessary fluff? Have you ever seen or used a worksheet that had too much formatting or was formatted in a way that was difficult to follow?

  • Inventory Management for workbooks: EOQ, holding costs

    390877 Inventory Management for workbooks: EOQ, holding costs, ordering costs Please use the attached excel worksheet to answer the problem.

  • Techniques Used for Cognitive Intervention

    So, when you look at "thinking" and "change", there are many tools that can be used by a clinician. Some of the most popular tools that can be used by clinicians can be worksheets, handouts, and workbooks.

  • Adjusting Journal Entries - Ace Computer and Duggan Rental

    Prepare the adjusting entries as august 31, 2014 Please see the attached Excel 97-2003 workbooks. This solution illustrates how to make adjusting journal entries, including the related explanations. Attached in 2 Excel files.

  • EOQ for Workbooks and Annual Holding Costs

    b- What are the annual holding costs for the workbooks? c- What are the annual ordering costs? Please see the attached file. The expert calculates EOQ for workbooks and annual holding costs.

  • EOQ Model

    The solution discusses computer training schools and stock workbooks and determines the EOQ.

View More Related Solutions