FUNDAMENTALS OF COMPUTER

Previous
Next

USING MICROSOFT EXCEL

HOW TO MODIFY THE WORKSHEET TAB IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
John has created a PivotChart and would like to include a guide that would display the names of the series of data included on the chart. Which option would allow him to do this?
A
Report Filter
B
Legend Fields
C
Axis Fields
D
Values
Explanation: 

Detailed explanation-1: -On the Insert tab, click a button to insert either a column, line, pie, or radar chart. Please note that other types of charts do not work with PivotTables at this time.

Detailed explanation-2: -The Insert Chart dialog box lets you choose from a variety of PivotChart types. Some chart types will be better at displaying certain data than others. The most common types of charts are Column, Bar, Line, and Pie. Column and Bar charts work well to compare different sets of data against each other.

Detailed explanation-3: -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).

Detailed explanation-4: -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.

There is 1 question to complete.
Previous
Next