What are some dangers in grouping worksheets in Excel?

The conveniences and the dangers of grouping sheets are the same: whatever you do to one of the grouped sheets you are doing to all of the grouped sheets. [ Whenever you group sheets to perform a task, it is important to remember to ungroup before continuing to work with sheets individually. There are a couple of ways to ungroup sheets. You can right click the tab of one of the grouped sheets

and click “Ungroup sheets” from the menu. You can also remove grouping by clicking on a tab of a sheet that is not in the group, or by clicking on any single sheet’s tab.
]

Expert answered|Shey091808|Points 808|

Question

Asked 12/4/2012 7:59:52 PM

0 Answers/Comments

Rating

There are no new answers.

what exactly is data exchange in Excel? **Weegy:** here are many ways to share data between databases and spreadsheets. The most powerful way is to use ActiveX Data Objects and Visual Basic for Applications to program the exchange. [ Data transferred this way can be exchanged based on a schedule, it can be validated before the transfer is completed and it can ‘massaged’ by either the sending or receiving application ] (More)

Question

Expert Answered

Asked 11/28/2012 6:14:32 AM

0 Answers/Comments

What is What-If analysis in Excel **Weegy:** y using what-if analysis tools in Microsoft Office Excel, you can use several different sets of values in one or more formulas to explore all the various results.
For example, [ you can do what-if analysis to build two budgets that each assumes a certain level of revenue. Or, you can specify a result that you want a formula to produce, and then determine what sets of values will produce that result. Excel provides several different tools to help you perform the type of analysis that fits your needs. ] (More)

Question

Expert Answered

Asked 11/30/2012 8:31:56 AM

0 Answers/Comments

What exactly What-If in Excel? **Weegy:** Three kinds of what-if analysis tools come with Excel: scenarios, data tables, and Goal Seek. Scenarios and data tables take sets of input values and determine possible results. [ A data table works only with one or two variables, but it can accept many different values for those variables. A scenario can have multiple variables, but it can accommodate only up to 32 values. Goal Seek works differently from scenarios and data tables in that it takes a result and determines possible input values that produce that result.
In addition to these three tools, you can install add-ins that help you perform what-if analysis, such as the Solver add-in.
The Solver add-in is similar to Goal Seek, but it can accommodate more variables. You can also create forecasts by using the fill handle and various commands that are built into Excel. For more advanced models, you can use the Analysis Pack add-in. ] (More)

Question

Expert Answered

Asked 12/1/2012 8:25:28 AM

0 Answers/Comments

What are What-If analysis Excel tools? **Weegy:** What-if analysis is the process of changing the values in cells to see how those changes will affect the outcome of formulas on the worksheet.
Three kinds of what-if analysis tools come with Excel: scenarios, data tables, and Goal Seek. [ Scenarios and data tables take sets of input values and determine possible results. A data table works only with one or two variables, but it can accept many different values for those variables. A scenario can have multiple variables, but it can accommodate only up to 32 values. Goal Seek works differently from scenarios and data tables in that it takes a result and determines possible input values that produce that result. ] (More)

Question

Expert Answered

Asked 12/3/2012 10:29:47 AM

0 Answers/Comments

what is the difference between a workbook and a worksheet group in Excel? **Weegy:** A workbook is a file that stores the entered related data; a worksheet is a page of the workbook on which all the data is held. A workbook defines the data of the worksheets; the worksheets allow for the data to be manipulated for specific purposes. [ ] (More)

Question

Expert Answered

Asked 12/4/2012 5:02:56 PM

0 Answers/Comments

20,209,053 questions answered

Points 0 [Total 0]| Ratings 0| Comments 0| Invitations 0|Offline

Points 0 [Total 0]| Ratings 0| Comments 0| Invitations 0|Offline

There are no comments.