USING MICROSOFT EXCEL
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Which of the following is a method used to create a chart template?
|
|
Right-click in the Chart Area and select Save as Template on the shortcut menu.
|
|
|
Click the PivotChart button on the Insert tab.
|
|
|
Right-click a data series and then select Add Trendline on the shortcut menu.
|
|
|
Type the name in the PivotTable Name box on the PivotTable Tools Analyze tab.
|
Explanation:
Detailed explanation-1: -Right-click the chart, and select Save as Template. In the File name box, type an appropriate name for the chart template. Click Save. The chart template automatically appears in the Templates folder for charts.
Detailed explanation-2: -Tip: You can quickly insert a basic Bar chart in a worksheet. Select the data you want to include in your chart, and press Alt+F1. The chart is added to the worksheet and is listed in the Selection pane.
Detailed explanation-3: -In excel charts are created using chart wizard. charts are used . A wizard is found in Microsoft excel where you can process step by step instructions to create a chart in excel.
There is 1 question to complete.