FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

MODIFYING PAGE SETUP PROPERTIES IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
To remove a chart from the current worksheet and place it on a newly created worksheet, use the ____ dialog box.
A
Cut and paste
B
Relocate
C
Move Chart
D
Move or Cut Chart
E
None
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: -Click the edge of chart’s frame to highlight the chart. On the Home tab, in the Editing group, click Clear > Clear All. Tip: For faster results, you can also press Delete on your keyboard.

Detailed explanation-3: -In Excel, a dialog box is a form that can help you add information and make decisions about different aspects of your current worksheet and its content such as data, charts, or graphic images.

Detailed explanation-4: -Copy all the data on the sheet by pressing CTRL+C. Open the workbook in which you want to paste the data, then click the + in the status bar to add a new blank worksheet. Click the first cell in the new worksheet, then press CTRL+V to paste the data into that worksheet.

There is 1 question to complete.