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 methods can be used to add a PivotChart to a workbook?
|
|
Click the PivotChart button on the Insert tab.
|
|
|
Right-click in the Chart Area and select Save as Template on the shortcut menu.
|
|
|
Type the name in the PivotTable Name box on the PivotTable Tools Analyze tab.
|
|
|
We can define relationships between data tables.
|
Explanation:
Detailed explanation-1: -Insert a PivotTable Select a table or range of data in your sheet and select Insert > PivotTable to open the Insert PivotTable pane. You can either manually create your own PivotTable or choose a recommended PivotTable to be created for you.
Detailed explanation-2: -On the Insert tab, in the Tables group, click PivotTable.
There is 1 question to complete.