USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Amy is currently viewing a chart she recently created and would like to make a chart template from it. To complete this task, Amy should:
|
|
take a screenshot of the chart and save it as a graphics file to use as an example for future chart creation.
|
|
|
click the File tab, select Save As, and then select Chart Template for the file type.
|
|
|
click the File tab, select Save As, and then select Chart Template for the file type.
|
|
|
use the Format Selection button to change the template property.
|
Explanation:
Detailed explanation-1: -To copy a chart to another worksheet in the same or a different workbook, right-click the chart and click Copy.
Detailed explanation-2: -Charts provide a visual representation of your data, making it easier to analyze. For example, I want to create a chart for Sales, to see if there is a pattern.
Detailed explanation-3: -On the Design tab, in the Type group, click Change Chart Type. In the Change Chart Type dialog box, click a chart type that you want to use.
Detailed explanation-4: -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.