USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
True
|
|
|
False
|
|
|
Either A or B
|
|
|
None of the above
|
Detailed explanation-1: -Q23-False, as when we move chart the data is automatically linked to the other sheet from where we are moving …
Detailed explanation-2: -Move a chart to another worksheet Click anywhere in the chart. Under Chart Tools, on the Design tab, in the Location group, click Move Chart. Do one of the following: To move the chart to a new worksheet, click New sheet, and then in the New sheet box, type a name for the worksheet.
Detailed explanation-3: -So when you move an existing excel chart into a new chart sheet, you would only have the chart in that sheet (and there won’t be any cells or tables like a regular worksheet). In this tutorial, I will show you how to move an existing chart into a new worksheet (as an object) or to a new chart sheet.