Question and answer
Using Excel, what are some dangers in grouping worksheets?
One of the biggest dangers of grouping worksheets, is that when you change something on one worksheet, it is then applied to all of the worksheets that are grouped. While this can be considered a danger, it also can be used to ones advantage. [ Hope this helps. ]
Expert answered|selymi|Points 9546|
Question
Asked 12/5/2012 9:33:38 AM
0 Answers/Comments
Get an answer
New answers
Rating

There are no new answers.

Comments

There are no comments.

Add an answer or comment
Log in or sign up first.
Questions asked by the same visitor
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 is data consolidation and Excel tools
Weegy: To summarize and report results from separate worksheets, you can consolidate data from each separate worksheet into a master worksheet. The worksheets can be in the same workbook as the master worksheet or in other workbooks. [ When you consolidate data, you are assembling data so that you can more easily update and aggregate it on a regular or ad hoc basis. For example, if you have a worksheet of expense figures for each of your regional offices, you might use a consolidation to roll up these figures into a corporate expense worksheet. This master worksheet might contain sales totals and averages, current inventory levels, and highest selling products for the entire enterprise. To consolidate data, use the Consolidate command in the Data Tools group on the Data tab. ] (More)
Question
Expert Answered
Asked 11/30/2012 3:32:11 PM
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
21,080,125 questions answered
Popular Conversations
What is the middle term of the product of (x - 4)(x - 3)? User: ...
Weegy: b.(p + 2)(p + 16) to check: p*p + (2p + 16p) + (2 * 16) = p^2 + 18p + 32 so the answer is b.(p + 2)(p + 16) ...
5/26/2015 1:22:27 PM| 3 Answers
Give the next two numbers in this pattern: 0, 0.75, 1.5, 2.25, ... ...
Weegy: 0.6/0.75 = 0.8 User: Find the direct variation equation which passes through (0, 0) and (4, 1). A. y = 4x ...
5/26/2015 12:36:07 AM| 2 Answers
Evaluate f-2g for f = 4 and g = 32. 2 8 User: Write 6,000,370 in ...
Weegy: y*9 User: (b2)3 Weegy: the bond order of b2 is 1, one bond order = 1/2 (#e- in bonding MO's - #e- in ...
5/26/2015 10:14:55 AM| 2 Answers
What is the solution set of the given equation? 4y - 6y + 9y = -2
Weegy: 4y - 6y + 9y = -2 -2y + 9y = -2 7y = -2 y = -2/7 User: Solve for x. 5x - 6 = 4x + 8 Weegy: ...
5/26/2015 12:20:50 PM| 2 Answers
A major characteristic of monopolistic competition is that prices ...
Weegy: A. higher than in perfect competition. User: A minimum price, set by the government, that must be paid for a ...
5/26/2015 12:56:40 PM| 2 Answers
(2x – 1)(x + 7) = 0
Weegy: (2x + 1)(x + 7) = 0; 2x + 1 = 0; 2x = -1; x = -1/2; x + 7 = 0; x = -7; x = -1/2 or x = -7 User: x^2 ...
5/26/2015 4:37:35 PM| 2 Answers
Weegy Stuff
S
Points 709 [Total 717]| Ratings 1| Comments 699| Invitations 0|Offline
S
L
Points 706 [Total 1236]| Ratings 2| Comments 686| Invitations 0|Offline
S
1
Points 547 [Total 939]| Ratings 2| Comments 527| Invitations 0|Online
S
L
P
Points 408 [Total 2885]| Ratings 1| Comments 398| Invitations 0|Offline
S
P
C
L
P
L
1
P
P
1
P
1
Points 248 [Total 8994]| Ratings 0| Comments 248| Invitations 0|Offline
S
Points 147 [Total 167]| Ratings 0| Comments 147| Invitations 0|Online
S
1
L
L
Points 82 [Total 8265]| Ratings 0| Comments 82| Invitations 0|Offline
S
L
Points 56 [Total 3810]| Ratings 2| Comments 36| Invitations 0|Offline
S
L
1
R
Points 48 [Total 1335]| Ratings 0| Comments 48| Invitations 0|Offline
S
Points 20 [Total 20]| Ratings 2| Comments 0| Invitations 0|Online
Home | Contact | Blog | About | Terms | Privacy | Social | ©2015 Purple Inc.