0
What is the relationship between worksheets in Microsoft Excel?
Wiki User
∙ 11y ago
Each worksheet starts off blank. There are usually three to begin with. Often only one is used. Sometimes two or more are used and it is possible to insert more. Where more than one is used, often there is no direct relationship between them. They may be about different aspects of the same thing. For example, a business could have all its income on one sheet and all its expenses on another. Data from different departments or regions or time periods, could be on different sheets. It is also possible to link them, so having formulas from one use totals from others. So there could be several individual sheets and grand totals for them all added together on a final sheet. Chart sheets can also show data from other sheets.
Each worksheet starts off blank. There are usually three to begin with. Often only one is used. Sometimes two or more are used and it is possible to insert more. Where more than one is used, often there is no direct relationship between them. They may be about different aspects of the same thing. For example, a business could have all its income on one sheet and all its expenses on another. Data from different departments or regions or time periods, could be on different sheets. It is also possible to link them, so having formulas from one use totals from others. So there could be several individual sheets and grand totals for them all added together on a final sheet. Chart sheets can also show data from other sheets.
Each worksheet starts off blank. There are usually three to begin with. Often only one is used. Sometimes two or more are used and it is possible to insert more. Where more than one is used, often there is no direct relationship between them. They may be about different aspects of the same thing. For example, a business could have all its income on one sheet and all its expenses on another. Data from different departments or regions or time periods, could be on different sheets. It is also possible to link them, so having formulas from one use totals from others. So there could be several individual sheets and grand totals for them all added together on a final sheet. Chart sheets can also show data from other sheets.
Each worksheet starts off blank. There are usually three to begin with. Often only one is used. Sometimes two or more are used and it is possible to insert more. Where more than one is used, often there is no direct relationship between them. They may be about different aspects of the same thing. For example, a business could have all its income on one sheet and all its expenses on another. Data from different departments or regions or time periods, could be on different sheets. It is also possible to link them, so having formulas from one use totals from others. So there could be several individual sheets and grand totals for them all added together on a final sheet. Chart sheets can also show data from other sheets.
Each worksheet starts off blank. There are usually three to begin with. Often only one is used. Sometimes two or more are used and it is possible to insert more. Where more than one is used, often there is no direct relationship between them. They may be about different aspects of the same thing. For example, a business could have all its income on one sheet and all its expenses on another. Data from different departments or regions or time periods, could be on different sheets. It is also possible to link them, so having formulas from one use totals from others. So there could be several individual sheets and grand totals for them all added together on a final sheet. Chart sheets can also show data from other sheets.
Each worksheet starts off blank. There are usually three to begin with. Often only one is used. Sometimes two or more are used and it is possible to insert more. Where more than one is used, often there is no direct relationship between them. They may be about different aspects of the same thing. For example, a business could have all its income on one sheet and all its expenses on another. Data from different departments or regions or time periods, could be on different sheets. It is also possible to link them, so having formulas from one use totals from others. So there could be several individual sheets and grand totals for them all added together on a final sheet. Chart sheets can also show data from other sheets.
Each worksheet starts off blank. There are usually three to begin with. Often only one is used. Sometimes two or more are used and it is possible to insert more. Where more than one is used, often there is no direct relationship between them. They may be about different aspects of the same thing. For example, a business could have all its income on one sheet and all its expenses on another. Data from different departments or regions or time periods, could be on different sheets. It is also possible to link them, so having formulas from one use totals from others. So there could be several individual sheets and grand totals for them all added together on a final sheet. Chart sheets can also show data from other sheets.
Each worksheet starts off blank. There are usually three to begin with. Often only one is used. Sometimes two or more are used and it is possible to insert more. Where more than one is used, often there is no direct relationship between them. They may be about different aspects of the same thing. For example, a business could have all its income on one sheet and all its expenses on another. Data from different departments or regions or time periods, could be on different sheets. It is also possible to link them, so having formulas from one use totals from others. So there could be several individual sheets and grand totals for them all added together on a final sheet. Chart sheets can also show data from other sheets.
Each worksheet starts off blank. There are usually three to begin with. Often only one is used. Sometimes two or more are used and it is possible to insert more. Where more than one is used, often there is no direct relationship between them. They may be about different aspects of the same thing. For example, a business could have all its income on one sheet and all its expenses on another. Data from different departments or regions or time periods, could be on different sheets. It is also possible to link them, so having formulas from one use totals from others. So there could be several individual sheets and grand totals for them all added together on a final sheet. Chart sheets can also show data from other sheets.
Each worksheet starts off blank. There are usually three to begin with. Often only one is used. Sometimes two or more are used and it is possible to insert more. Where more than one is used, often there is no direct relationship between them. They may be about different aspects of the same thing. For example, a business could have all its income on one sheet and all its expenses on another. Data from different departments or regions or time periods, could be on different sheets. It is also possible to link them, so having formulas from one use totals from others. So there could be several individual sheets and grand totals for them all added together on a final sheet. Chart sheets can also show data from other sheets.
Each worksheet starts off blank. There are usually three to begin with. Often only one is used. Sometimes two or more are used and it is possible to insert more. Where more than one is used, often there is no direct relationship between them. They may be about different aspects of the same thing. For example, a business could have all its income on one sheet and all its expenses on another. Data from different departments or regions or time periods, could be on different sheets. It is also possible to link them, so having formulas from one use totals from others. So there could be several individual sheets and grand totals for them all added together on a final sheet. Chart sheets can also show data from other sheets.
Wiki User
∙ 11y ago
Wiki User
∙ 11y agoEach worksheet starts off blank. There are usually three to begin with. Often only one is used. Sometimes two or more are used and it is possible to insert more. Where more than one is used, often there is no direct relationship between them. They may be about different aspects of the same thing. For example, a business could have all its income on one sheet and all its expenses on another. Data from different departments or regions or time periods, could be on different sheets. It is also possible to link them, so having formulas from one use totals from others. So there could be several individual sheets and grand totals for them all added together on a final sheet. Chart sheets can also show data from other sheets.
Add your answer:
Earn +20 pts
How many worksheets does Excel have when it opens a new workbook?
In Microsoft Excel, a new workbook will normally have three worksheets.
What is the relationship between Microsoft Excel and calculations?
The main reason for Excel is to perform calculations.
Excel displays data in a special document called?
Microsoft Excel displays data in Worksheets, also called spreadsheets, or as a group of worksheets known as a Workbook.
How is a sheet made active in Microsoft Excel?
Use Ctrl and Page Up or Ctrl and Page Down to switch between open worksheets.
In excel which would you perform to group ajacent worksheets?
In order to group nonadjacent worksheets, you click first tab, then hold Ctrl and click last tab. Excel was developed by Microsoft.
How many worksheets are there in Microsoft Excel?
Excel 2003 and earlier are limited to 255 worksheets per workbook. There are usually 3 by default when you start Excel, but you can add more or change the default.
What is a spread sheet file in excel?
It is a collection of worksheets and known as a workbook, and has a .xls extension.
Where are individual worksheets stored in Excel?
Worksheets are stored in a workbook in Excel.
Is tabs used in Excel to add worksheets columns and row titles etc?
No. That is a feature of Microsoft Word tables, but not Excel. There are specific options for inserting rows and columns in Excel.
What is the difference between Microsoft Excel 2003 and Microsoft Word?
Microsoft Excel is a worksheet. Microsoft Word is a word processor.
How many worksheets are present is Microsoft Excel?
Quote from the web: "According to Microsoft Excel, the number of worksheets in a workbook is "limited only by available memory." Current versions of Excel cannot use more than 1 GB of memory even if more memory is available on the system. (Excel 2007 will use as much memory as the system will give it.) In my experience, even if you could generate a well-formed workbook with 650 sheets, it is unlikely that any Excel user would be able to open it without running into Excel's memory limit. I'm impressed that you could even get to 200 sheets without a problem, honestly. "
Can a person complete calculations in Microsoft Excel 2003?
Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.
