USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Ginger is working with a PivotTable. Which PivotTable formatting task will allow her to turn on the row headers and banded rows?
|
|
applying a PivotTable style
|
|
|
configuring a PivotTable Layout
|
|
|
selecting a report layout
|
|
|
setting PivotTable style options
|
Explanation:
Detailed explanation-1: -To switch between showing and hiding field headers, on the Analyze or Options tab, in the Show group, click Field Headers.
Detailed explanation-2: -Activate the pivot table. From the View menu choose Gridlines.
Detailed explanation-3: -Click any cell in the PivotTable. Click the Design tab. Select an option from the PivotTable Style Options group. Row/Column Headers: Displays special formatting for the first row or column of the PivotTable.
There is 1 question to complete.