Go Back   TechArena Community > Software > Windows Software
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



What is Workbook and Worksheets in Excel

Windows Software


Reply
 
Thread Tools Search this Thread
  #1  
Old 06-06-2009
Member
 
Join Date: Jun 2009
Posts: 309
What is Workbook and Worksheets in Excel
  

Hi, i am a not a advanced user of computers or internet. Most importantly, i rarely use Microsoft office. In one part of the office that is Excel, i always get confused in Workbook and Worksheets. Could anyone of you make me know the difference in these two words ?

Reply With Quote
  #2  
Old 06-06-2009
Member
 
Join Date: May 2008
Posts: 4,831
Re: What is Workbook and Worksheets in Excel

A workbook is just that, a worksheet is whats in the workbook, kinda like an actual book or a file cabinet. It is a collection of worksheets. 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.If you had one sheet that was a table with information, and another sheet with a pie chart, you would have a workbook.

Worksheet is a sheet on which you are working in Excel workbook. It is used to list and analyze data.Creating formulas for Excel entering formulas into a spreadsheet we want to make as many references as possible to existing data.You can enter and edit data on several worksheets simultaneously and perform calculations based on data from multiple worksheets. Some kinds of worksheets are chart, Excel4 macro,Excel5 dialog, etc..
Reply With Quote
  #3  
Old 06-06-2009
Member
 
Join Date: Apr 2008
Posts: 2,139
Re: What is Workbook and Worksheets in Excel

Microsoft Excel is a spreadsheet application used to process business and financial calculations of various kinds.A workbook is the name Excel gives to the standard type of file that you use to create spreadsheets. It include the Worksheets you work in excel. You can add one or more worksheets if you need to, or alternatively, you can delete unwanted worksheets from a workbook.Remember that You can have just one worksheet in a workbook or you can have a lot of worksheets in a workbook.
Reply With Quote
  #4  
Old 06-06-2009
Member
 
Join Date: Jun 2009
Posts: 309
Re: What is Workbook and Worksheets in Excel

Thank you very much for making know the most confusing difference for me. i understood now that i work on worksheets and save it as workbook.

I appreciate your help.
Reply With Quote
Reply

  TechArena Community > Software > Windows Software
Tags: , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "What is Workbook and Worksheets in Excel"
Thread Thread Starter Forum Replies Last Post
Clicking on Worksheet on multiple Worksheets in the single Excel file not allow viewing the worksheet in Microsoft Excel 2010 Dipanwita Windows Software 8 04-12-2011 10:24 AM
How can I use VBA to copy data from the closed workbook to the open workbook on Microsoft Excel 2010? Borislav Windows Software 3 11-07-2011 10:37 AM
cannot tab between worksheets in Excel 2007 MartinaMiranda Windows Software 5 06-04-2011 08:43 PM
Compare two Excel Worksheets on Mac Claudius Windows Software 2 10-06-2009 10:46 PM
Merging Excel worksheets Alexxx Tips & Tweaks 3 03-03-2009 07:06 PM


All times are GMT +5.5. The time now is 09:47 PM.