USING MICROSOFT EXCEL
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Line, Column, Win-Loss
|
|
|
Click the PivotChart button on the Insert tab.
|
|
|
Type the name in the PivotTable Name box on the PivotTable Tools Analyze tab.
|
|
|
move chart
|
Detailed explanation-1: -Click the PivotTable. Go to PivotTable Tools > Analyze, and in the PivotTable group, click the PivotTable Name text box. For Excel 2007-2010, go to PivotTable Tools > Options, and in the PivotTable group, click the PivotTable Name text box. Type a new name.
Detailed explanation-2: -Click the More button on the PivotTable Tools Design tab and then select New PivotTable Name.
Detailed explanation-3: -PivotTable report Click the field or item that you want to rename. Go to PivotTable Tools > Analyze, and in the Active Field group, click the Active Field text box. If you’re using Excel 2007-2010, go to PivotTable Tools > Options. Type a new name.
Detailed explanation-4: -In the Power Pivot window, select the column for which you want to change the data type. On the Home tab, in the Formatting group, choose a data type from the Data Type list. Columns that contain both numbers and text values cannot be converted to a numeric data type.
Detailed explanation-5: -Which of the following methods can be used to add a PivotChart to a workbook? Click the PivotChart button on the Insert tab. To add a trendline to a chart, you can do which of the following? Right-click a data series and then select Add Trendline on the shortcut menu.