USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
chart
|
|
|
PivotChart
|
|
|
PivotTable
|
|
|
table
|
Detailed explanation-1: -To change the layout of a PivotTable, you can change the PivotTable form and the way that fields, columns, rows, subtotals, empty cells and lines are displayed. To change the format of the PivotTable, you can apply a predefined style, banded rows, and conditional formatting.
Detailed explanation-2: -Your last step before creating your pivot table should be to format your data as a table. Highlight all of your data, and then choose Format as Table in the Styles group on the Home tab.
Detailed explanation-3: -In both Excel and in Power Pivot, you can create a Data Model, a collection of tables with relationships. The data model you see in a workbook in Excel is the same data model you see in the Power Pivot window. Any data you import into Excel is available in Power Pivot, and vice versa.