USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
John would like to display the count of employee last names on the Yaxisof a PivotChart. What area would he drag this information to in orderto display correctly?
|
|
Report Filter
|
|
|
Legend Fields
|
|
|
Axis Fields
|
|
|
Values
|
Explanation:
Detailed explanation-1: -On the right side of the worksheet, a PivotTable Fields task pane is open. In it are four areas (Filters, Columns, Rows, and Values) where various field names can be placed to create a PivotTable. The task pane also includes a checklist area of the fields from which to choose from the data.
Detailed explanation-2: -Right-click the PivotTable, and then click Show Field List. You can also click Field List on the Ribbon (PivotTable Tools, Options tab, Show group for a PivotTable; PivotChart Tools, Analyze tab, Show/Hide group for a PivotChart).
There is 1 question to complete.