FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
You should move a chart to a chart sheet when you want to source data to appear with the chart.
A
True
B
False
C
Either A or B
D
None of the above
Explanation: 

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.

There is 1 question to complete.