FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

HOW TO USE THE CONCATENATE FUNCTION IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
How do you move a chart to a new sheet?
A
Chart Tools Design tab
B
Chart Tools Design tab
C
Chart Tools Design tab
D
Chart Tools Design tab
Explanation: 

Detailed explanation-1: -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-2: -Move a chart to another sheet Click anywhere in the chart. On the Chart Design tab, click Move Chart. Select the New sheet option, and then in the New sheet box, type a name for the new chart sheet. Select the Object in option, and then in the Object in box, select the sheet that you want to place the chart on.

Detailed explanation-3: -Chart tools comprise of two tabs DESIGN and FORMAT. Step 1 − When you click on a chart, CHART TOOLS comprising of DESIGN and FORMAT tabs appear on the Ribbon. Step 2 − Click the DESIGN tab on the Ribbon.

There is 1 question to complete.