Question and answer
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
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 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
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
18,394,780 questions answered
Popular Conversations
A product is
11/20/2014 6:12:42 PM| 8 Answers
Which equation below is a direct variation? A. 1/6x=y B. x + 2 = ...
Weegy: An example of a quadratic equation is y = x^2 - 5 User: The value of y varies directly with x, and y = 4 ...
11/20/2014 7:27:37 AM| 4 Answers
0.0872
Weegy: Scientific notation of 0.0872 is 8.720 10^-2. User: 0.48 Weegy: what you need to know my friend? User: ...
11/20/2014 6:57:30 AM| 2 Answers
Which equation below is a direct variation? A. B. x + 2 = y C. y ...
Weegy: The equation of the line that passes through the points ( 2, 2) and (0, 5)is B. y = 3/2x + 5 User: The value ...
11/20/2014 7:40:11 AM| 2 Answers
The legs of a right triangle have lengths of 4 and 5 units. Find the ...
Weegy: The length of the hypotenuse of a right triangle whose legs are 3 and sqrt 2 is sqrt [3^2 + (sqrt 2)^2] = sqrt ...
11/20/2014 9:03:43 AM| 2 Answers
Is the ordered pair (0,5) a solution of the system of linear ...
Weegy: yes, the ordered pair (0,5) a solution of the system of linear equations: x + y = 5 -5x + 2y = 10. 0 + 5 = 5, ...
11/20/2014 9:19:10 AM| 2 Answers
Find the slope and y-intercept of the line. y = –2x + 8 (Points : ...
Weegy: y = mx + b where m is the slope of the line and b is the y intercept ... equation of the line with slope m 1. y ...
11/20/2014 10:00:11 AM| 2 Answers
Weegy Stuff
S
L
1
L
P
C
1
P
C
1
L
P
C
1
Points 2149 [Total 13860]| Ratings 10| Comments 2049| Invitations 0|Online
S
L
Points 1165 [Total 3451]| Ratings 0| Comments 1165| Invitations 0|Offline
S
1
L
1
L
P
P
L
P
Points 644 [Total 14018]| Ratings 0| Comments 644| Invitations 0|Offline
S
L
Points 635 [Total 1156]| Ratings 6| Comments 575| Invitations 0|Offline
S
Points 352 [Total 384]| Ratings 1| Comments 342| Invitations 0|Offline
S
1
L
L
Points 211 [Total 6605]| Ratings 0| Comments 211| Invitations 0|Offline
S
L
Points 143 [Total 1439]| Ratings 3| Comments 113| Invitations 0|Offline
S
Points 50 [Total 50]| Ratings 0| Comments 0| Invitations 5|Offline
S
Points 37 [Total 37]| Ratings 0| Comments 37| Invitations 0|Offline
S
Points 34 [Total 34]| Ratings 2| Comments 4| Invitations 1|Online
Home | Contact | Blog | About | Terms | Privacy | Social | ©2014 Purple Inc.