How is the Profit-Sharing field added to the PivotTable?

How is the Profit-Sharing field added to the PivotTable?

• A. Check profit sharing from table on right
• B. Drag Profit-Sharing to Values area
• C. Insert > PivotTable > Add Field Profit-Sharing
• D. Design > PivotTable > Add Field

Answer: (A)

Adding a field to a PivotTable is done through the PivotTable Field List on the right. By checking the Profit-Sharing box, you tell Excel to include that field in the PivotTable. The field is placed in the default area (usually Values for numeric data), and the PivotTable updates to reflect the added data. This checkbox method is quick and direct, which is why it's the best answer. Other options don't reflect the standard way to add a field: there isn't an Insert > PivotTable > Add Field path, and the Design path isn't used to add fields. Dragging the field to the Values area is another valid way to add it, but the question specifically describes using the field list checkbox.

Adding a field to a PivotTable is done through the PivotTable Field List on the right. By checking the Profit-Sharing box, you tell Excel to include that field in the PivotTable. The field is placed in the default area (usually Values for numeric data), and the PivotTable updates to reflect the added data. This checkbox method is quick and direct, which is why it's the best answer. Other options don't reflect the standard way to add a field: there isn't an Insert > PivotTable > Add Field path, and the Design path isn't used to add fields. Dragging the field to the Values area is another valid way to add it, but the question specifically describes using the field list checkbox.